From 4bdf01fc828095304e3d85ddd3c2af8d2e7ade08 Mon Sep 17 00:00:00 2001 From: Luca Ferrari Date: Thu, 10 Jul 2025 12:38:23 +0200 Subject: PWC 329 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 | 77 ++++++++++++++++++++++ 2 files changed, 149 insertions(+) create mode 100644 challenge-329/luca-ferrari/pljava/src/main/java/Task1.java create mode 100644 challenge-329/luca-ferrari/pljava/src/main/java/Task2.java (limited to 'challenge-329/luca-ferrari/pljava/src/main/java') diff --git a/challenge-329/luca-ferrari/pljava/src/main/java/Task1.java b/challenge-329/luca-ferrari/pljava/src/main/java/Task1.java new file mode 100644 index 0000000000..be4e77e6fc --- /dev/null +++ b/challenge-329/luca-ferrari/pljava/src/main/java/Task1.java @@ -0,0 +1,72 @@ + + + +package PWC329; + +/** + * PL/Java implementation for PWC 329 + * 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/PWC329-1.jar luca@rachel:/tmp + + + * To install into PostgreSQL execute: + + select sqlj.install_jar( 'file:///tmp/PWC329-1.jar', 'PWC329', true ); + select sqlj.set_classpath( 'public', 'PWC329' ); + + select pwc329.task2_pljava(); + + and then to redeploy: + + select sqlj.replace_jar( 'file:///tmp/PWC329-1.jar', 'PWC329', 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 = "pwc329", + onNullInput = RETURNS_NULL, + effects = IMMUTABLE ) + public static final int[] task1_pljava( String string ) throws SQLException { + logger.log( Level.INFO, "Entering pwc329.task1_pljava" ); + + Map numbers = new HashMap(); + + Pattern regexp = Pattern.compile( "\\d+" ); + Matcher engine = regexp.matcher( string ); + while ( engine.find() ) { + try { + numbers.put( Integer.parseInt( engine.group() ), 1 ); + } catch( Exception e ) { } + } + + int result[] = new int[ numbers.size() ]; + int j = 0; + for ( int i : numbers.keySet() ) + result[ j++ ] = i; + + return result; + } +} diff --git a/challenge-329/luca-ferrari/pljava/src/main/java/Task2.java b/challenge-329/luca-ferrari/pljava/src/main/java/Task2.java new file mode 100644 index 0000000000..64956c8ab5 --- /dev/null +++ b/challenge-329/luca-ferrari/pljava/src/main/java/Task2.java @@ -0,0 +1,77 @@ + + + +package PWC329; + +/** + * PL/Java implementation for PWC 329 + * 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/PWC329-1.jar luca@rachel:/tmp + + + * To install into PostgreSQL execute: + + select sqlj.install_jar( 'file:///tmp/PWC329-1.jar', 'PWC329', true ); + select sqlj.set_classpath( 'public', 'PWC329' ); + + select pwc329.task2_pljava(); + + and then to redeploy: + + select sqlj.replace_jar( 'file:///tmp/PWC329-1.jar', 'PWC329', 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 Task2 { + + private final static Logger logger = Logger.getAnonymousLogger(); + + @Function( schema = "pwc329", + onNullInput = RETURNS_NULL, + effects = IMMUTABLE ) + public static final String task2_pljava( String string ) throws SQLException { + logger.log( Level.INFO, "Entering pwc329.task2_pljava" ); + + + char chars[] = string.toCharArray(); + + int begin = 0; + int end = 0; + + for ( int i = 0; i < chars.length; i++ ) { + char c = chars[ i ]; + char n = Character.toUpperCase( c ); + if ( Character.isUpperCase( c ) ) + n = Character.toLowerCase( c ); + + for ( int j = i + 1; j < chars.length; j++ ) + if ( chars[ j ] == n ) + if ( ( end - begin ) < ( j - i ) ) { + begin = i; + end = j; + } + } + + return string.substring( begin, end + 1 ); + } +} -- cgit