Add failing test for Boolean support of DynamicParameterList

pesse · pesse · commit 4f591ef4214e · 2019-07-22T23:05:45.000+02:00
diff --git a/src/main/java/org/utplsql/api/db/DynamicParameterList.java b/src/main/java/org/utplsql/api/db/DynamicParameterList.java
@@ -115,6 +115,18 @@ public DynamicParameterListBuilder addIfNotEmpty(String identifier, Object[] val
             return this;
         }
 
+        public DynamicParameterListBuilder add(String identifier, Boolean value) {
+            params.put(identifier, null);
+            return this;
+        }
+
+        public DynamicParameterListBuilder addIfNotEmpty(String identifier, Boolean value) {
+            if ( value != null ) {
+                add(identifier, value);
+            }
+            return this;
+        }
+
         public DynamicParameterList build() {
             return new DynamicParameterList(params);
         }
diff --git a/src/test/java/org/utplsql/api/db/DynamicParameterListTest.java b/src/test/java/org/utplsql/api/db/DynamicParameterListTest.java
@@ -59,6 +59,20 @@ void can_add_array() throws SQLException {
             verify(conn).createOracleArray("MY_TYPE", numArr);
             verify(stmt).setArray(3, null);
         }
+
+        @Test
+        void can_add_boolean() throws SQLException {
+            CallableStatement stmt = mock(CallableStatement.class);
+
+            DynamicParameterList paramList = DynamicParameterList.builder()
+                    .add("a_bool", true)
+                    .build();
+
+            assertEquals("a_param => (case ? when 1 then true else false)", paramList.getSql());
+
+            paramList.setParamsStartWithIndex(stmt, 3);
+            verify(stmt).setInt(3, 1);
+        }
     }
 
     @Nested
