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

Example 26 with Sql

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

the class CustomizedSqlsTest method test_escape_varname_test.

@Test
public void test_escape_varname_test() {
    Sql sql = Sqls.create("A_$xyz$_B");
    sql.vars().set("xyz", "X");
    assertEquals("A_X_B", sql.toString());
}

Example 27 with Sql

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

the class CustomizedSqlsTest method test_dynamic_query.

@Test
public void test_dynamic_query() {
    pojos.init();
    Platoon p = pojos.create4Platoon(Base.make("xyz"), "GG");
    Sql sql = dao.sqls().create("tank.query").setEntity(dao.getEntity(Tank.class));
    sql.vars().set("id", p.getId());
    sql.setCallback(Sqls.callback.entities());
    dao.execute(sql);
    assertEquals(2, sql.getList(Tank.class).size());
    pojos.dropPlatoon(p.getId());
}

Example 28 with Sql

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

the class SQLFileParsingTest method check_Insert_SQL.

@Test
public void check_Insert_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create(".abc.insert");
    assertTrue(sql.toString().toUpperCase().startsWith("INSERT"));
}

Example 29 with Sql

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

the class SQLFileParsingTest method check_Create_SQL.

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

Example 30 with Sql

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

the class SQLFileParsingTest method check_Update_SQL.

@Test
public void check_Update_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create(".abc.update");
    assertTrue(sql.toString().toUpperCase().startsWith("UPDATE"));
}