From 0cc3d19f45790123a25f7f33d9c5b3b239a48c5f Mon Sep 17 00:00:00 2001 From: Luca Ferrari Date: Wed, 14 Feb 2024 11:29:06 +0100 Subject: PWC 256 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/Task2.java | 58 ++++++++++++++++++++++ 1 file changed, 58 insertions(+) create mode 100644 challenge-256/luca-ferrari/pljava/src/main/java/Task2.java (limited to 'challenge-256/luca-ferrari/pljava/src/main/java/Task2.java') diff --git a/challenge-256/luca-ferrari/pljava/src/main/java/Task2.java b/challenge-256/luca-ferrari/pljava/src/main/java/Task2.java new file mode 100644 index 0000000000..75e231c2c2 --- /dev/null +++ b/challenge-256/luca-ferrari/pljava/src/main/java/Task2.java @@ -0,0 +1,58 @@ +package PWC256; + +/** + * PL/Java implementation for PWC 256 + * 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/PWC256.jar luca@venkman:/tmp + + + * To install into PostgreSQL execute: + + select sqlj.install_jar( 'file:///tmp/PWC256.jar', 'PWC256', true ); + + select 256.task2_pljava(); + + and then to redeploy: + + select sqlj.replace_jar( 'file:///tmp/PWC256.jar', 'PWC256', 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 Task2 { + private final static Logger logger = Logger.getAnonymousLogger(); + + @Function( schema = "256", + onNullInput = RETURNS_NULL, + effects = IMMUTABLE ) + public static final String task2_pljava( String left, String right ) throws SQLException { + logger.log( Level.INFO, "Entering task2_pljava" ); + + StringBuffer buffer = new StringBuffer( left.length() + right.length() ); + + int max_index = Math.max( left.length(), right.length() ); + for ( int index = 0; index < max_index; index++ ) { + if ( index < left.length() ) + buffer.append( left.charAt( index ) ); + if ( index < right.length() ) + buffer.append( right.charAt( index ) ); + } + + return buffer.toString(); + } +} -- cgit