From 2126fcd1ffcf87c9eb31ac28b50ff5fa9315bf0b Mon Sep 17 00:00:00 2001 From: Luca Ferrari Date: Mon, 8 Apr 2024 14:13:18 +0200 Subject: PWC 264 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 PL/Java done Task 2 PL/Java done Task 1 Python done Task 2 Python done --- .../luca-ferrari/pljava/src/main/java/Task1.java | 72 ++++++++++++++++++++ .../luca-ferrari/pljava/src/main/java/Task2.java | 79 ++++++++++++++++++++++ 2 files changed, 151 insertions(+) create mode 100644 challenge-264/luca-ferrari/pljava/src/main/java/Task1.java create mode 100644 challenge-264/luca-ferrari/pljava/src/main/java/Task2.java (limited to 'challenge-264/luca-ferrari/pljava/src/main/java') diff --git a/challenge-264/luca-ferrari/pljava/src/main/java/Task1.java b/challenge-264/luca-ferrari/pljava/src/main/java/Task1.java new file mode 100644 index 0000000000..18f95cc42a --- /dev/null +++ b/challenge-264/luca-ferrari/pljava/src/main/java/Task1.java @@ -0,0 +1,72 @@ + + + +package PWC264; + +/** + * PL/Java implementation for PWC 264 + * 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/PWC264-1.jar luca@rachel:/tmp + + + * To install into PostgreSQL execute: + + select sqlj.install_jar( 'file:///tmp/PWC264-1.jar', 'PWC264', true ); + select sqlj.set_classpath( 'public', 'PWC264' ); + + select pwc264.task2_pljava(); + + and then to redeploy: + + select sqlj.replace_jar( 'file:///tmp/PWC264-1.jar', 'PWC264', 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; +import java.util.regex.*; + +public class Task1 { + + private final static Logger logger = Logger.getAnonymousLogger(); + + @Function( schema = "pwc264", + onNullInput = RETURNS_NULL, + effects = IMMUTABLE ) + public static final String task1_pljava( String string ) throws SQLException { + logger.log( Level.INFO, "Entering pwc264.task1_pljava" ); + + List letters = new LinkedList(); + for ( String l : string.split( "" ) ) { + if ( ! l.equals( l.toUpperCase() ) ) + continue; + + Pattern regexp = Pattern.compile( l.toLowerCase() ); + Matcher engine = regexp.matcher( string ); + if ( ! engine.matches() ) + letters.add( l ); + } + + if ( letters.isEmpty() ) + return "-"; + + Collections.sort( letters ); + return letters.get( letters.size() - 1 ); + } +} diff --git a/challenge-264/luca-ferrari/pljava/src/main/java/Task2.java b/challenge-264/luca-ferrari/pljava/src/main/java/Task2.java new file mode 100644 index 0000000000..718e4e61ca --- /dev/null +++ b/challenge-264/luca-ferrari/pljava/src/main/java/Task2.java @@ -0,0 +1,79 @@ + + + +package PWC264; + +/** + * PL/Java implementation for PWC 264 + * Task 2 + * 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/PWC264-1.jar luca@rachel:/tmp + + + * To install into PostgreSQL execute: + + select sqlj.install_jar( 'file:///tmp/PWC264-1.jar', 'PWC264', true ); + select sqlj.set_classpath( 'public', 'PWC264' ); + + select pwc264.task2_pljava(); + + and then to redeploy: + + select sqlj.replace_jar( 'file:///tmp/PWC264-1.jar', 'PWC264', 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 Task2 { + + private final static Logger logger = Logger.getAnonymousLogger(); + + @Function( schema = "pwc264", + onNullInput = RETURNS_NULL, + effects = IMMUTABLE ) + public static final int[] task2_pljava( int[] source, int[] indexes ) throws SQLException { + logger.log( Level.INFO, "Entering pwc264.task2_pljava" ); + + List target = new LinkedList(); + + for ( int i = 0; i < indexes.length; i++ ) { + int target_index = indexes[ i ]; + if ( target.isEmpty() || target.size() <= target_index ) + target.add( source[ i ] ); + else { + List replace = new LinkedList(); + for ( int ii = 0; ii < target_index; ii++ ) + replace.add( target.get( ii ) ); + replace.add( source[ i ] ); + for ( int ii = target_index; ii < target.size(); ii++ ) + replace.add( target.get( ii ) ); + + target = replace; + } + } + + int[] result = new int[ target.size() ]; + int k = 0; + for ( int v : target ) + result[ k++ ] = v; + + return result; + } +} -- cgit