Examples with FileSqlManager org.nutz.dao.impl.FileSqlManager used on opensource projects

Example 1 with FileSqlManager

use of org.nutz.dao.impl.FileSqlManager in project nutz by nutzam.

the class CustomizedSqlsTest method test_dynamic_insert.

@Test
public void test_dynamic_insert() {
    pojos.init();
    ((NutDao) dao).setSqlManager(new FileSqlManager("org/nutz/dao/test/sqls/exec.sqls"));
    int platoonId = 23;
    try {
        pojos.initPlatoon(platoonId);
        Sql sql = dao.sqls().create("tank.insert");
        sql.vars().set("id", platoonId);
        sql.params().set("code", "T1").set("weight", 12);
        dao.execute(sql);
        sql = dao.sqls().create("tank.insert");
        sql.vars().set("id", platoonId);
        sql.params().set("code", "T2").set("weight", 13);
        dao.execute(sql);
        sql = dao.sqls().create("tank.insert");
        sql.vars().set("id", platoonId);
        sql.params().set("code", "T3").set("weight", 14);
        dao.execute(sql);
        sql = dao.sqls().create("tank.insert");
        sql.vars().set("id", platoonId);
        sql.params().set("code", "T4").set("weight", 15);
        dao.execute(sql);
        TableName.run(platoonId, new Atom() {

            public void run() {
                assertEquals(4, dao.count(Tank.class));
            }
        });
    } catch (SqlNotFoundException e) {
    } finally {
        pojos.dropPlatoon(platoonId);
    }
}

Example 2 with FileSqlManager

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

use of org.nutz.dao.impl.FileSqlManager in project nutz by nutzam.

the class SQLFileParsingTest method test_with_inline_comment.

@Test
public void test_with_inline_comment() throws IOException {
    FileSqlManager sqls = new FileSqlManager();
    sqls.add(new StringReader("/*hi*/\n/*测试*/select 1 from t_pet"));
    assertEquals(1, sqls.count());
    assertEquals("hi", sqls.keys()[0]);
    assertEquals("/*测试*/select 1 from t_pet", sqls.get("hi"));
}

Example 4 with FileSqlManager

use of org.nutz.dao.impl.FileSqlManager in project nutz by nutzam.

the class SQLFileParsingTest method check_PersonTestSQLs.

@Test
public void check_PersonTestSQLs() {
    SqlManager sqls = new FileSqlManager("org/nutz/dao/test/sqls/sqls.sqls");
    String[] keys = { ".abc.drop", ".abc.create", ".abc.insert", ".abc.update", "abc.fetch", "abc.query", ".student.drop", ".student.create", ".student2.drop", ".student2.create" };
    for (int i = 0; i < keys.length; i++) {
        assertEquals(keys[i], sqls.keys()[i]);
    }
}

Example 5 with FileSqlManager

use of org.nutz.dao.impl.FileSqlManager 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());
}