Examples with SqlManager org.nutz.dao.SqlManager used on opensource projects

Example 1 with SqlManager

use of org.nutz.dao.SqlManager in project nutz by nutzam.

the class SQLFileParsingTest method check_Count_SQL.

@Test
public void check_Count_SQL() {
    SqlManager sqls = createSqls();
    assertEquals(10, sqls.count());
    String[] keys = { ".abc.drop", ".abc.create", ".abc.insert", ".abc.update", "abc.fetch", "abc.query", ".student.drop", ".student.create" };
    for (int i = 0; i < keys.length; i++) {
        assertEquals(keys[i], sqls.keys()[i]);
    }
}

Example 2 with SqlManager

use of org.nutz.dao.SqlManager 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 3 with SqlManager

use of org.nutz.dao.SqlManager in project nutz by nutzam.

the class SQLFileParsingTest method test_with_force_index_comment.

@Test
public void test_with_force_index_comment() {
    SqlManager sqls = new FileSqlManager("org/nutz/dao/test/sqls/force_indexs.sqls");
    assertEquals(1, sqls.count());
    assertEquals("oracle.index", sqls.keys()[0]);
    assertTrue(sqls.get("oracle.index").contains("/*"));
}

Example 4 with SqlManager

use of org.nutz.dao.SqlManager 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 5 with SqlManager

use of org.nutz.dao.SqlManager 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"));
}