@Test
public void testScriptStuff() throws Exception {
Handle h = openHandle();
Script s = h.createScript("default-data");
s.execute();
assertEquals(2, h.select("select * from something").size());
}
@Test
public void testNamedParamsInExternal() throws Exception {
Handle h = openHandle();
h.createStatement("insert-id-name").bind("id", 1).bind("name", "Tip").execute();
assertEquals(1, h.select("select name from something").size());
}
@Test
public void testNamedPositionalNamedParamsInPrepared() throws Exception {
Handle h = openHandle();
h.insert("insert-id-name", 3, "Tip");
assertEquals(1, h.select("select name from something").size());
}
@Test
public void testCommentsInExternalSql() throws Exception {
Handle h = openHandle();
h.insert("insert-eric-with-comments");
assertEquals(1, h.select("select name from something").size());
}
@Test
public void testLocateNamedWithSuffix() throws Exception {
Handle h = openHandle();
h.insert("insert-keith.sql");
assertEquals(1, h.select("select name from something").size());
}
@Test
public void testLocateNamedWithoutSuffix() throws Exception {
Handle h = openHandle();
h.createStatement("insert-keith").execute();
assertEquals(1, h.select("select name from something").size());
}