@Test
public void testParsing2() throws IOException {
String testQuery =
Resources.toString(
NamedParameterPreparedStatementTest.class.getResource("test.sql"), Charsets.UTF_8);
String expectedParsedQuery =
Resources.toString(
NamedParameterPreparedStatementTest.class.getResource("expected.sql"), Charsets.UTF_8);
List<String> expectedParameterList = Lists.newArrayList("named_parameter1", "named_parameter2");
NamedParameterPreparedStatement.ParseResult parseResult =
NamedParameterPreparedStatement.parse(testQuery);
assertEquals(expectedParsedQuery, parseResult.getSql());
assertThat(expectedParameterList, is(parseResult.getOrderedParameters()));
}
@Test
public void testParsing() {
String testQuery =
"SELECT * FROM table "
+ "WHERE afield = ':not me' "
+ "AND bfield = :param1 "
+ "AND cfield = :param2 "
+ "and dfield = :param2;";
String expectedParsedQuery =
"SELECT * FROM table "
+ "WHERE afield = ':not me' "
+ "AND bfield = ? "
+ "AND cfield = ? "
+ "and dfield = ?;";
List<String> expectedParameterList = Lists.newArrayList("param1", "param2", "param2");
NamedParameterPreparedStatement.ParseResult parseResult =
NamedParameterPreparedStatement.parse(testQuery);
assertEquals(expectedParsedQuery, parseResult.getSql());
assertThat(expectedParameterList, is(parseResult.getOrderedParameters()));
}
