From 7c3628d24263d828b990af5eeac286e3ab7819af Mon Sep 17 00:00:00 2001 From: Luca Ferrari Date: Mon, 29 Jan 2024 09:55:32 +0100 Subject: PWC 254 Task 1 Raku done Task 2 Raku done Task 1 PL/Perl done Task 2 PL/Perl done Task 1 PL/PgSQL done Task 2 PL/PgSQL done Task 1 Python done Task 2 Python done Task 1 PL/Java done Task2 PL/java done --- .../luca-ferrari/pljava/src/main/java/Task1.java | 50 ++++++++++++++++++++++ 1 file changed, 50 insertions(+) create mode 100644 challenge-254/luca-ferrari/pljava/src/main/java/Task1.java (limited to 'challenge-254/luca-ferrari/pljava/src/main/java/Task1.java') diff --git a/challenge-254/luca-ferrari/pljava/src/main/java/Task1.java b/challenge-254/luca-ferrari/pljava/src/main/java/Task1.java new file mode 100644 index 0000000000..643a13cbab --- /dev/null +++ b/challenge-254/luca-ferrari/pljava/src/main/java/Task1.java @@ -0,0 +1,50 @@ +package PWC254; + +/** + * PL/Java implementation for PWC 254 + * Task 1 + * See + * + * + * To compile on the local machine: + + $ export JAVA_HOME=/usr/lib/jvm/java-17-openjdk-amd64/ # if not already set + $ mvn clean build + $ $ scp target/PWC253-1.jar luca@venkman:/tmp + + + * To install into PostgreSQL execute: + + select sqlj.install_jar( 'file:///tmp/PWC254-1.jar', 'PWC254', true ); + select sqlj.set_classpath( 'public', 'PWC254' ); + + select task1_pljava(); + + and then to redeploy: + + select sqlj.replace_jar( 'file:///tmp/PWC254-1.jar', 'PWC254', true ); + +*/ + +import org.postgresql.pljava.*; +import org.postgresql.pljava.annotation.Function; +import static org.postgresql.pljava.annotation.Function.Effects.IMMUTABLE; +import static org.postgresql.pljava.annotation.Function.OnNullInput.RETURNS_NULL; + +import java.util.*; +import java.sql.SQLException; +import java.util.logging.*; + +public class Task1 { + + private final static Logger logger = Logger.getAnonymousLogger(); + + @Function( onNullInput = RETURNS_NULL, effects = IMMUTABLE ) + public static final boolean task1_pljava( int num ) throws SQLException { + for ( int i = 2; i < Math.sqrt( num ); i++ ) + if ( Math.pow( i, 3 ) == num ) + return true; + + return false; + } +} -- cgit