Examples with Entity cn.hutool.db.Entity used on opensource projects

Example 6 with Entity

use of cn.hutool.db.Entity in project hutool by looly.

the class EntityTest method parseTest.

@Test
public void parseTest() {
    User user = new User();
    user.setId(1);
    user.setName("test");
    Entity entity = Entity.create("testTable").parseBean(user);
    Assert.assertEquals(Integer.valueOf(1), entity.getInt("id"));
    Assert.assertEquals("test", entity.getStr("name"));
}

Example 7 with Entity

use of cn.hutool.db.Entity in project hutool by looly.

the class UpdateTest method updateTest.

/**
 * 对更新做单元测试
 *
 * @throws SQLException
 */
@Test
@Ignore
public void updateTest() throws SQLException {
    // 改
    int update = runner.update(Entity.create("user").set("age", 88), Entity.create().set("name", "unitTestUser"));
    Assert.assertTrue(update > 0);
    Entity result2 = runner.get("user", "name", "unitTestUser");
    Assert.assertSame(88, (int) result2.getInt("age"));
}

Example 8 with Entity

use of cn.hutool.db.Entity in project hutool by looly.

the class CRUDTest method insertBatchTest.

@Test
@Ignore
public void insertBatchTest() throws SQLException {
    User user1 = new User();
    user1.setName("张三");
    user1.setAge(12);
    user1.setBirthday("19900112");
    user1.setGender(true);
    User user2 = new User();
    user2.setName("李四");
    user2.setAge(12);
    user2.setBirthday("19890512");
    user2.setGender(false);
    Entity data1 = Entity.parse(user1);
    Entity data2 = Entity.parse(user2);
    Console.log(data1);
    Console.log(data2);
    int[] result = runner.insert(CollUtil.newArrayList(data1, data2));
    Console.log(result);
}

Example 9 with Entity

use of cn.hutool.db.Entity in project hutool by looly.

the class CRUDTest method findTest.

@Test
public void findTest() throws SQLException {
    List<Entity> find = runner.find(CollUtil.newArrayList("name AS name2"), Entity.create("user"), new EntityListHandler());
    Assert.assertFalse(find.isEmpty());
}

Example 10 with Entity

use of cn.hutool.db.Entity in project hutool by looly.

the class DsTest method tomcatDsTest.

@Test
public void tomcatDsTest() throws SQLException {
    DSFactory.setCurrentDSFactory(new TomcatDSFactory());
    DataSource ds = DSFactory.get();
    SqlRunner runner = SqlRunner.create(ds);
    List<Entity> all = runner.findAll("user");
    Assert.assertTrue(CollUtil.isNotEmpty(all));
}