From 2b5457f572cf53ed6ff5b679de754feafa5b8eb6 Mon Sep 17 00:00:00 2001 From: Luca Ferrari Date: Mon, 4 Mar 2024 09:39:17 +0100 Subject: PWC 259 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 Task 2 PL/Java done --- .../luca-ferrari/pljava/src/main/java/Task1.java | 73 ++++++++++++++++++++++ 1 file changed, 73 insertions(+) create mode 100644 challenge-259/luca-ferrari/pljava/src/main/java/Task1.java (limited to 'challenge-259/luca-ferrari/pljava/src/main/java/Task1.java') diff --git a/challenge-259/luca-ferrari/pljava/src/main/java/Task1.java b/challenge-259/luca-ferrari/pljava/src/main/java/Task1.java new file mode 100644 index 0000000000..de464e56c0 --- /dev/null +++ b/challenge-259/luca-ferrari/pljava/src/main/java/Task1.java @@ -0,0 +1,73 @@ + + + +package PWC259; + +/** + * PL/Java implementation for PWC 259 + * 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/PWC259-1.jar luca@rachel:/tmp + + + * To install into PostgreSQL execute: + + select sqlj.install_jar( 'file:///tmp/PWC259-1.jar', 'PWC259', true ); + + select pwc259.task2_pljava(); + + and then to redeploy: + + select sqlj.replace_jar( 'file:///tmp/PWC259-1.jar', 'PWC259', 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.util.stream.*; +import java.sql.SQLException; +import java.util.logging.*; +import java.sql.ResultSet; +import java.sql.Date; + +public class Task1 { + + private final static Logger logger = Logger.getAnonymousLogger(); + + @Function( schema = "pwc259", + onNullInput = RETURNS_NULL, + effects = IMMUTABLE ) + public static final java.sql.Date task1_pljava( Date startDay, int how_many, Date[] holidays ) throws SQLException { + logger.log( Level.INFO, "Entering pwc259.task1_pljava" ); + + Calendar day = Calendar.getInstance(); + day.setTime( startDay ); + + while ( how_many > 0 ) { + day.add( Calendar.DAY_OF_YEAR, 1 ); + + while ( day.get( Calendar.DAY_OF_MONTH ) == Calendar.SUNDAY + || day.get( Calendar.DAY_OF_MONTH ) == Calendar.SATURDAY ) + day.add( Calendar.DAY_OF_YEAR, 1 ); + + if ( holidays != null ) + for ( Date skip : holidays ) + if ( skip.equals( day.getTime() ) ) + day.add( Calendar.DAY_OF_YEAR, 1 ); + + how_many--; + } + + return new java.sql.Date( day.getTimeInMillis() ); + } +} -- cgit