utPLSQL
diff --git a/‎src/main/java/org/utplsql/api/db/DynamicParameterList.java‎
Lines changed: 28 additions & 0 deletions b/‎src/main/java/org/utplsql/api/db/DynamicParameterList.java‎
Lines changed: 28 additions & 0 deletions
diff --git a/‎src/main/java/org/utplsql/api/db/DynamicParameterListBuilder.java‎
Lines changed: 29 additions & 0 deletions b/‎src/main/java/org/utplsql/api/db/DynamicParameterListBuilder.java‎
Lines changed: 29 additions & 0 deletions
diff --git a/‎src/test/java/org/utplsql/api/db/DynamicParameterListTest.java‎
Lines changed: 29 additions & 0 deletions b/‎src/test/java/org/utplsql/api/db/DynamicParameterListTest.java‎
Lines changed: 29 additions & 0 deletions
@@ -0,0 +1,28 @@
+package org.utplsql.api.db;
+
+import java.util.LinkedHashMap;
+import java.util.function.Consumer;
+import java.util.stream.Collectors;
+
+public class DynamicParameterList {
+
+    LinkedHashMap<String, Consumer<Integer>> params;
+
+    DynamicParameterList(LinkedHashMap<String, Consumer<Integer>> params) {
+        this.params = params;
+    }
+
+    public String getSql() {
+        return params.keySet().stream()
+                .map(e -> e + " = ?")
+                .collect(Collectors.joining(", "));
+    }
+
+    public void applyFromIndex( int startIndex ) {
+        int index = startIndex;
+        for ( Consumer<Integer> function : params.values() ) {
+            function.accept(index++);
+        }
+    }
+
+}
@@ -0,0 +1,29 @@
+package org.utplsql.api.db;
+
+import java.util.LinkedHashMap;
+import java.util.function.Consumer;
+
+public class DynamicParameterListBuilder {
+
+    private LinkedHashMap<String, Consumer<Integer>> params = new LinkedHashMap<>();
+
+    private DynamicParameterListBuilder() {
+
+    }
+
+    public DynamicParameterListBuilder addParameter(String identifier, Consumer<Integer> function) {
+
+        params.put(identifier, function);
+
+        return this;
+    }
+
+    public DynamicParameterList build() {
+        return new DynamicParameterList(params);
+    }
+
+
+    public static DynamicParameterListBuilder create() {
+        return new DynamicParameterListBuilder();
+    }
+}
@@ -0,0 +1,29 @@
+package org.utplsql.api.db;
+
+import org.junit.jupiter.api.Test;
+
+import java.util.ArrayList;
+
+import static org.junit.jupiter.api.Assertions.assertEquals;
+
+public class DynamicParameterListTest {
+
+    @Test
+    void firstTest() {
+
+        final ArrayList<Object> resultArray = new ArrayList<>();
+
+        DynamicParameterList parameterList = DynamicParameterListBuilder.create()
+                .addParameter("a_object_owner", i -> resultArray.add(i + ": MyOwner"))
+                .addParameter("a_num_param", i -> resultArray.add( i + ": 123"))
+                .build();
+
+        parameterList.applyFromIndex(5);
+        assertEquals("a_object_owner = ?, a_num_param = ?", parameterList.getSql());
+
+        ArrayList<Object> expectedList = new ArrayList<>();
+        expectedList.add("5: MyOwner");
+        expectedList.add("6: 123");
+        assertEquals( expectedList, resultArray);
+    }
+}