aboutsummaryrefslogtreecommitdiff
path: root/challenge-289/luca-ferrari/pljava
diff options
context:
space:
mode:
Diffstat (limited to 'challenge-289/luca-ferrari/pljava')
-rw-r--r--challenge-289/luca-ferrari/pljava/pom.xml72
-rw-r--r--challenge-289/luca-ferrari/pljava/src/main/java/Task1.java64
-rw-r--r--challenge-289/luca-ferrari/pljava/src/main/java/Task2.java89
3 files changed, 225 insertions, 0 deletions
diff --git a/challenge-289/luca-ferrari/pljava/pom.xml b/challenge-289/luca-ferrari/pljava/pom.xml
new file mode 100644
index 0000000000..27cc94c005
--- /dev/null
+++ b/challenge-289/luca-ferrari/pljava/pom.xml
@@ -0,0 +1,72 @@
+
+<project
+ xmlns="http://maven.apache.org/POM/4.0.0"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation= "http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" >
+ <modelVersion>4.0.0</modelVersion>
+
+ <groupId>PWC</groupId>
+ <artifactId>
+ PWC289
+ </artifactId>
+ <version>
+ 1
+ </version>
+
+ <name>Perl Weekly Challenge 289 with package PWC289</name>
+ <description>Implementation of the tasks in PL/Java for PWC 289</description>
+
+ <properties>
+ <project.build.sourceEncoding>US-ASCII</project.build.sourceEncoding>
+ </properties>
+
+ <dependencies>
+ <dependency>
+ <groupId>org.postgresql</groupId>
+ <artifactId>pljava-api</artifactId>
+ <version>1.6.6</version>
+ </dependency>
+ </dependencies>
+
+ <build>
+ <plugins>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-compiler-plugin</artifactId>
+ <version>3.8.1</version>
+ <configuration>
+ <release>9</release>
+ </configuration>
+ </plugin>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-jar-plugin</artifactId>
+ <version>2.6</version>
+ <configuration>
+ <archive>
+ <manifest>
+ <!-- This identifies and version-stamps the jar.
+ Not essential, but easy and useful. -->
+ <addDefaultImplementationEntries>
+ true
+ </addDefaultImplementationEntries>
+ </manifest>
+
+ <manifestSections>
+ <!-- This identifies a file in the jar named
+ pljava.ddr as an SQLJDeploymentDescriptor. -->
+ <manifestSection>
+ <name>pljava.ddr</name>
+ <manifestEntries>
+ <SQLJDeploymentDescriptor>
+ true
+ </SQLJDeploymentDescriptor>
+ </manifestEntries>
+ </manifestSection>
+ </manifestSections>
+ </archive>
+ </configuration>
+ </plugin>
+ </plugins>
+ </build>
+</project>
diff --git a/challenge-289/luca-ferrari/pljava/src/main/java/Task1.java b/challenge-289/luca-ferrari/pljava/src/main/java/Task1.java
new file mode 100644
index 0000000000..9666996c9a
--- /dev/null
+++ b/challenge-289/luca-ferrari/pljava/src/main/java/Task1.java
@@ -0,0 +1,64 @@
+
+
+
+package PWC289;
+
+/**
+ * PL/Java implementation for PWC 289
+ * Task 1
+ * See <https://perlweeklychallenge.org/blog/perl-weekly-challenge-289>
+ *
+ *
+ * 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/PWC289-1.jar luca@rachel:/tmp
+
+
+ * To install into PostgreSQL execute:
+
+ select sqlj.install_jar( 'file:///tmp/PWC289-1.jar', 'PWC289', true );
+ select sqlj.set_classpath( 'public', 'PWC289' );
+
+ select pwc289.task2_pljava();
+
+ and then to redeploy:
+
+ select sqlj.replace_jar( 'file:///tmp/PWC289-1.jar', 'PWC289', 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 = "pwc289",
+ onNullInput = RETURNS_NULL,
+ effects = IMMUTABLE )
+ public static final int task1_pljava( int[] nums ) throws SQLException {
+ logger.log( Level.INFO, "Entering pwc289.task1_pljava" );
+
+ List<Integer> sorted = IntStream.of( nums ).boxed().sorted( Collections.reverseOrder() )
+ .collect( Collectors.toList() );
+
+
+ if ( sorted.size() >= 3 )
+ return sorted.get( 3 );
+ else
+ return sorted.get( 0 );
+
+ }
+}
diff --git a/challenge-289/luca-ferrari/pljava/src/main/java/Task2.java b/challenge-289/luca-ferrari/pljava/src/main/java/Task2.java
new file mode 100644
index 0000000000..8532cda167
--- /dev/null
+++ b/challenge-289/luca-ferrari/pljava/src/main/java/Task2.java
@@ -0,0 +1,89 @@
+
+
+
+package PWC289;
+
+/**
+ * PL/Java implementation for PWC 289
+ * Task 2
+ * See <https://perlweeklychallenge.org/blog/perl-weekly-challenge-289>
+ *
+ *
+ * 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/PWC289-1.jar luca@rachel:/tmp
+
+
+ * To install into PostgreSQL execute:
+
+ select sqlj.install_jar( 'file:///tmp/PWC289-1.jar', 'PWC289', true );
+ select sqlj.set_classpath( 'public', 'PWC289' );
+
+ select pwc289.task2_pljava();
+
+ and then to redeploy:
+
+ select sqlj.replace_jar( 'file:///tmp/PWC289-1.jar', 'PWC289', 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 = "pwc289",
+ onNullInput = RETURNS_NULL,
+ effects = IMMUTABLE )
+ public static final String[] task2_pljava( String[] words ) throws SQLException {
+ logger.log( Level.INFO, "Entering pwc289.task2_pljava" );
+
+ List<String> result = new LinkedList<String>();
+
+ for ( String current : words ) {
+ String[] letters = current.split( "" );
+
+
+ int last_index = letters.length - 1;
+ int first_index = 0;
+
+ Pattern pattern = Pattern.compile( "^[a-z0-9A-Z]$" );
+
+
+ while ( ! pattern.matcher( letters[ last_index ] ).find() )
+ last_index--;
+
+ List<String> shuffling = new LinkedList<String>();
+ for ( int i = 1; i < last_index; i++ )
+ shuffling.add( letters[ i ] );
+
+ Collections.shuffle( shuffling );
+
+ String current_result = letters[ first_index ] + String.join( "", shuffling );
+ for ( int i = last_index; i < letters.length; i++ )
+ current_result += letters[ i ];
+
+ result.add( current_result );
+ }
+
+ String[] output = new String[ result.size() ];
+ for ( int i = 0; i < output.length; i++ )
+ output[ i ] = result.get( i );
+
+ return output;
+ }
+}
generated by cgit (git 2.34.1) at 2026-04-18 15:57:23 +0000