Package org.nutz.dao.sql

Examples of org.nutz.dao.sql.Sql

36
37
38
39
40
41
42
43
  }

  @Test
  public void check_Create_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create(".abc.create");
    assertTrue(sql.toString().toUpperCase().startsWith("CREATE"));
  }
View Full Code Here
43
44
45
46
47
48
49
50
  }

  @Test
  public void check_Insert_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create(".abc.insert");
    assertTrue(sql.toString().toUpperCase().startsWith("INSERT"));
  }
View Full Code Here
50
51
52
53
54
55
56
57
  }

  @Test
  public void check_Update_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create(".abc.update");
    assertTrue(sql.toString().toUpperCase().startsWith("UPDATE"));
  }
View Full Code Here
57
58
59
60
61
62
63
64
  }

  @Test
  public void check_Fetch_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create("abc.fetch");
    assertTrue(sql.toString().toUpperCase().startsWith("SELECT"));
  }
View Full Code Here
64
65
66
67
68
69
70
71
  }

  @Test
  public void check_Query_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create("abc.query");
    assertTrue(sql.toString().toUpperCase().startsWith("SELECT"));
  }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
  @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());
  }
View Full Code Here
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
public class SqlImplTest {

  @Test
  public void test_sql_get_list() {
    Sql sql = Sqls.create("SELECT version()");
    ArrayList<Map<Object, Object>> list = new ArrayList<Map<Object, Object>>();
    list.add(new HashMap<Object, Object>());
    list.add(new HashMap<Object, Object>());

    sql.getContext().setResult(list);

    List<?> re = sql.getList(Map.class);// 传入 map结果会导致上面的isFrom 为false
    assertTrue(re == list);

    re = sql.getList(HashMap.class);// 因为list中的实例是HashMap,因此能够正常返回
    assertTrue(re == list);
  }
View Full Code Here
29
30
31
32
33
34
35
36
37
public class CustomizedSqlsTest extends DaoCase {

  @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());
  }
View Full Code Here
20
21
22
23
24
25
26
27
28
29
30
31
  }

  @Test
  public void clear_links() {
    dao.create(Pet.class, true);
    Sql sql1 = Sqls.create("INSERT INTO t_pet (name) VALUES ('A')");
    Sql sql2 = Sqls.create("INSERT INTO t_pet (nocol) VALUES ('B')");
    try {
      dao.execute(sql1, sql2);
      fail();
    }
    catch (DaoException e) {}
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
107
  }

  @Test
  public void run_2_sqls_with_error() {
    assertEquals(0, dao.count(Pet.class));
    Sql sql1 = Sqls.create("INSERT INTO t_pet (name) VALUES ('A')");
    Sql sql2 = Sqls.create("INSERT INTO t_pet (nocol) VALUES ('B')");
    try {
      dao.execute(sql1, sql2);
      fail();
    }
    catch (DaoException e) {}
View Full Code Here
TOP

Related Classes of org.nutz.dao.sql.Sql

  • org.nutz.dao.impl.AbstractSqlManager
  • org.nutz.dao.impl.jdbc.AbstractJdbcExpert
  • org.nutz.dao.impl.jdbc.sqlserver2005.Sqlserver2005JdbcExpert
  • org.nutz.dao.impl.NutDao
  • org.nutz.dao.impl.sql.SqlTemplate
  • org.nutz.dao.test.exec.SimpleDaoExecTest
  • org.nutz.dao.test.normal.BoneCP_Test
  • org.nutz.dao.test.normal.CreateDropTableTest
  • org.nutz.dao.test.normal.CreateTableWithCommentTest
  • org.nutz.dao.test.normal.DaoRecordTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.