Examples with Sql org.nutz.dao.sql.Sql used on opensource projects

Example 66 with Sql

use of org.nutz.dao.sql.Sql in project nutz by nutzam.

the class SQLFileParsingTest method check_Fetch_SQL.

@Test
public void check_Fetch_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create("abc.fetch");
    assertTrue(sql.toString().toUpperCase().startsWith("SELECT"));
}

Example 67 with Sql

use of org.nutz.dao.sql.Sql in project nutz by nutzam.

the class SQLFileParsingTest method test_parse_whole_directory.

@Test
public void test_parse_whole_directory() {
    SqlManager sqls = new FileSqlManager("org/nutz/dao/test/sqls/dir");
    assertTrue(sqls.count() > 0);
    Sql sql = sqls.create(".abc.update");
    sql.params().set("name", "ABC");
    sql.params().set("id", 16);
    assertEquals("UPDATE t_abc SET name='ABC' WHERE id=16;", sql.toString());
}

Example 68 with Sql

use of org.nutz.dao.sql.Sql in project nutz by nutzam.

the class SQLFileParsingTest method check_parse_comboSqls.

@Test
public void check_parse_comboSqls() {
    SqlManager sqls = new FileSqlManager("org/nutz/dao/test/sqls/sqls.sqls");
    List<Sql> list = sqls.createCombo();
    assertEquals(10, list.size());
}

Example 69 with Sql

use of org.nutz.dao.sql.Sql in project nutz by nutzam.

the class SQLFileParsingTest method check_Query_SQL.

@Test
public void check_Query_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create("abc.query");
    assertTrue(sql.toString().toUpperCase().startsWith("SELECT"));
}