@Test public void addSQLWithParameterAndNegativeIndex() { // Setup StatementStorage storage = new StatementStorage(); storage.addSql("SELECT * FROM CARS WHERE CAR_ID = ?"); Object marker = "I am the prepared Statement"; storage.addPreparedStatement(marker); storage.addParameter(marker, -1, "1"); List<String> result = storage.getParameters(marker); assertThat(result, is(not(equalTo(null)))); assertThat(result, contains(equalTo(null))); }
@Test public void addSQLWithParameterAndAddWrongIndex() { // Setup StatementStorage storage = new StatementStorage(); storage.addSql("SELECT * FROM CARS WHERE CAR_ID = ?"); Object marker = "I am the prepared Statement"; storage.addPreparedStatement(marker); storage.addParameter(marker, 1, "1"); List<String> result = storage.getParameters(marker); assertThat(result, is(not(equalTo(null)))); assertThat(result, contains(equalTo(null))); }
@Test public void addSQLWithoutParameterAndSetParameter() { // Setup StatementStorage storage = new StatementStorage(); storage.addSql("SELECT * FROM CARS"); Object marker = "I am the prepared Statement"; storage.addPreparedStatement(marker); storage.addParameter(marker, 0, "1"); List<String> result = storage.getParameters(marker); assertThat(result, is(not(equalTo(null)))); assertThat(result, is(empty())); }
@Test public void addSQLWithParameterAndAddNullValue() { // Setup StatementStorage storage = new StatementStorage(); storage.addSql("SELECT * FROM CARS WHERE CAR_ID = ?"); Object marker = "I am the prepared Statement"; storage.addPreparedStatement(marker); storage.addParameter(marker, 0, null); List<String> result = storage.getParameters(marker); assertThat(result, is(not(equalTo(null)))); assertThat(result, contains(equalTo("null"))); } }
@Test public void addSQLWithParameterAndRead() { // Setup StatementStorage storage = new StatementStorage(); storage.addSql("SELECT * FROM CARS WHERE CAR_ID = ?"); Object marker = "I am the prepared Statement"; storage.addPreparedStatement(marker); storage.addParameter(marker, 0, "1"); List<String> result = storage.getParameters(marker); assertThat(result, contains(equalTo("'1'"))); }