use of com.github.drinkjava2.functionstest.entitynet.entities.User in project jSqlBox by drinkjava2.
the class UsuageAndSpeedTest method dataMapperStyle.
@Test
public void dataMapperStyle() {
SqlBoxContext ctx = new SqlBoxContext(dataSource);
for (int i = 0; i < REPEAT_TIMES; i++) {
UserPOJO user = new UserPOJO();
user.setName("Sam");
user.setAddress("Canada");
ctx.insert(user);
user.setAddress("China");
ctx.update(user);
UserPOJO sam2 = ctx.load(UserPOJO.class, "Sam");
ctx.delete(sam2);
}
}
use of com.github.drinkjava2.functionstest.entitynet.entities.User in project jSqlBox by drinkjava2.
the class UsuageAndSpeedTest method tXxxStyle.
@Test
public void tXxxStyle() {
SqlBoxContext ctx2 = new SqlBoxContext(dataSource);
Map<String, Object> params = new HashMap<String, Object>();
for (int i = 0; i < REPEAT_TIMES; i++) {
UserAR sam = new UserAR("Sam", "Canada");
UserAR tom = new UserAR("Tom", "China");
params.put("user", sam);
ctx2.tExecute("insert into users (name, address) values(#{user.name},:user.address)", params);
params.put("user", tom);
ctx2.tExecute("update users set name=#{user.name}, address=:user.address", params);
params.clear();
params.put("name", "Tom");
params.put("addr", "China");
Assert.assertEquals(1L, ctx2.tQueryForObject("select count(*) from users where name=#{name} and address=:addr", params));
params.put("u", tom);
ctx2.tExecute("delete from users where name=:u.name or address=#{u.address}", params);
}
}
use of com.github.drinkjava2.functionstest.entitynet.entities.User in project jSqlBox by drinkjava2.
the class UsuageAndSpeedTest method sqlMapperUseText.
@Test
public void sqlMapperUseText() {
SqlBoxContext ctx = new SqlBoxContext(dataSource);
// use global default context
SqlBoxContext.setGlobalSqlBoxContext(ctx);
TextedUser user = new TextedUser();
for (int i = 0; i < REPEAT_TIMES; i++) {
user.insertOneUser("Sam", "Canada");
user.ctx().nUpdate(user.updateAllUserPreSql("Tom", "China"));
// List<Map<String, Object>> users = user.selectUsersByText("Tom", "China");
// Assert.assertEquals(1, users.size());
List<TextedUser> users2 = user.selectUsersByText2("Tom", "China");
Assert.assertEquals(1, users2.size());
user.deleteUsers("Tom", "China");
Assert.assertEquals(0, user.ctx().nQueryForLongValue("select count(*) from users"));
}
}
use of com.github.drinkjava2.functionstest.entitynet.entities.User in project jSqlBox by drinkjava2.
the class UsuageAndSpeedTest method abstractSqlMapperUseText.
@Test
public void abstractSqlMapperUseText() {
SqlBoxContext ctx = new SqlBoxContext(dataSource);
// use global default context
SqlBoxContext.setGlobalSqlBoxContext(ctx);
AbstractUser user = ActiveRecord.create(AbstractUser.class);
for (int i = 0; i < REPEAT_TIMES; i++) {
user.insertOneUser("Sam", "Canada");
user.ctx().nUpdate(user.updateUserPreparedSQL("Tom", "China"));
// List<Map<String, Object>> users = user.selectUserListMap("Tom", "China");
// Assert.assertEquals(1, users.size());
List<AbstractUser> users2 = user.selectAbstractUserList("Tom", "China");
Assert.assertEquals(1, users2.size());
user.deleteUsers("Tom", "China");
Assert.assertEquals(0, user.ctx().nQueryForLongValue("select count(*) from users"));
}
}
use of com.github.drinkjava2.functionstest.entitynet.entities.User in project jSqlBox by drinkjava2.
the class UsuageAndSpeedTest method activeRecordStyle.
@Test
public void activeRecordStyle() {
SqlBoxContext ctx = new SqlBoxContext(dataSource);
UserAR user = new UserAR();
// Use ctx as SqlBoxContext
user.useContext(ctx);
for (int i = 0; i < REPEAT_TIMES; i++) {
user.setName("Sam");
user.setAddress("Canada");
user.insert();
user.setAddress("China");
user.update();
UserAR user2 = user.load("Sam");
user2.delete();
}
}
Aggregations