Package org.tamacat.dao.rdb

Examples of org.tamacat.dao.rdb.User

71
72
73
74
75
76
77
78
79
80
81
82
83
84
    );
  }
 
  @Test
  public void testGetInsertSQL() {
    User user = new User();
    user.setValue(User.USER_ID, "admin");
    user.setValue(User.PASSWORD, "test");
    user.setValue(User.DEPT_ID, "123");
    query.addUpdateColumns(User.TABLE.getColumns());
   
    assertEquals(
      "INSERT INTO users (user_id,password,dept_id)"
      + " VALUES ('admin','test','123')", query.getInsertSQL(user));
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
96
      + " VALUES ('admin','test','123')", query.getInsertSQL(user));
  }

  @Test
  public void testGetUpdateSQL() {
    User user = new User();
    user.setValue(User.USER_ID, "admin");
    user.setValue(User.PASSWORD, "test");
    query.addUpdateColumn(User.USER_ID);
    query.addUpdateColumn(User.PASSWORD);
    query.addWhere("and",
      new SQLParser().value(User.USER_ID, Condition.EQUAL, "admin"));
    assertEquals(
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
109
      query.getUpdateSQL(user));
  }

  @Test
  public void testGetDeleteSQL() {
    User user = new User();
    user.setValue(User.USER_ID, "admin");
    query.addUpdateColumn(User.USER_ID);
    assertEquals(
      "DELETE FROM users WHERE users.user_id='admin'",
      query.getDeleteSQL(user));
  }
View Full Code Here
TOP

Related Classes of org.tamacat.dao.rdb.User

  • org.tamacat.dao.rdb.internal.impl.RdbQueryImplTest
    • 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.