From 44a92ee6dd0ca577889cc1489e1237d5084a1efc Mon Sep 17 00:00:00 2001 From: Luca Ferrari Date: Thu, 4 Apr 2024 13:03:27 +0200 Subject: PWC 263 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 | 74 +++++++++++++++ .../luca-ferrari/pljava/src/main/java/Task2.java | 103 +++++++++++++++++++++ 2 files changed, 177 insertions(+) create mode 100644 challenge-263/luca-ferrari/pljava/src/main/java/Task1.java create mode 100644 challenge-263/luca-ferrari/pljava/src/main/java/Task2.java (limited to 'challenge-263/luca-ferrari/pljava/src/main/java') diff --git a/challenge-263/luca-ferrari/pljava/src/main/java/Task1.java b/challenge-263/luca-ferrari/pljava/src/main/java/Task1.java new file mode 100644 index 0000000000..50f9cdd131 --- /dev/null +++ b/challenge-263/luca-ferrari/pljava/src/main/java/Task1.java @@ -0,0 +1,74 @@ + + + +package PWC263; + +/** + * PL/Java implementation for PWC 263 + * 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/PWC263-1.jar luca@rachel:/tmp + + + * To install into PostgreSQL execute: + + select sqlj.install_jar( 'file:///tmp/PWC263-1.jar', 'PWC263', true ); + select sqlj.set_classpath( 'public', 'PWC263' ); + + select pwc263.task2_pljava(); + + and then to redeploy: + + select sqlj.replace_jar( 'file:///tmp/PWC263-1.jar', 'PWC263', 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 = "pwc263", + onNullInput = RETURNS_NULL, + effects = IMMUTABLE ) + public static final int[] task1_pljava( int k, int[] nums ) throws SQLException { + logger.log( Level.INFO, "Entering pwc263.task1_pljava" ); + + List source = new LinkedList(); + for ( int v : nums ) + source.add( v ); + + Collections.sort( source ); + + final List result = new LinkedList(); + IntStream.range( 0, source.size() ) + .forEach( index -> { + if ( source.get( index ) == k ) + result.add( index ); + } ); + + int res[] = new int[ result.size() ]; + for ( int i = 0; i < res.length; i++ ) + res[ i ] = result.get( i ); + + return res; + + } +} diff --git a/challenge-263/luca-ferrari/pljava/src/main/java/Task2.java b/challenge-263/luca-ferrari/pljava/src/main/java/Task2.java new file mode 100644 index 0000000000..e177ef5a38 --- /dev/null +++ b/challenge-263/luca-ferrari/pljava/src/main/java/Task2.java @@ -0,0 +1,103 @@ + + + +package PWC263; + +/** + * PL/Java implementation for PWC 263 + * 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/PWC263-1.jar luca@rachel:/tmp + + + * To install into PostgreSQL execute: + + select sqlj.install_jar( 'file:///tmp/PWC263-1.jar', 'PWC263', true ); + select sqlj.set_classpath( 'public', 'PWC263' ); + + select pwc263.task2_pljava(); + + and then to redeploy: + + select sqlj.replace_jar( 'file:///tmp/PWC263-1.jar', 'PWC263', 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 implements ResultSetProvider { + + private final static Logger logger = Logger.getAnonymousLogger(); + + @Function( schema = "pwc263", + onNullInput = RETURNS_NULL, + effects = IMMUTABLE ) + public static final ResultSetProvider task2_pljava( int i[], int j[] ) throws SQLException { + logger.log( Level.INFO, "Entering pwc263.task2_pljava" ); + return new Task2( i, j ); + } + + + Map quantity = new HashMap(); + List items = new LinkedList(); + + public Task2( int[] i, int[] j ) { + super(); + + int index = 0; + while ( index < i.length ) { + int item = i[ index ]; + int qty = i[ index + 1 ]; + quantity.put( i[ index ], i[ index + 1 ] ); + index += 2; + } + + index = 0; + while ( index < j.length ) { + int item = j[ index ]; + int qty = j[ index + 1 ]; + if ( quantity.containsKey( item ) ) + qty += quantity.get( item ); + + + quantity.put( item, qty ); + index += 2; + } + + items.addAll( quantity.keySet() ); + + } + + @Override + public boolean assignRowValues( ResultSet tuples, int row ) + throws SQLException { + + if ( items.isEmpty() || quantity.isEmpty() ) + return false; + + int item = items.remove( 0 ); + + tuples.updateInt( 1, item ); + tuples.updateInt( 2, quantity.get( item ) ); + return true; + } + + @Override + public void close() {} +} -- cgit