Examples with Pet org.nutz.dao.test.meta.Pet used on opensource projects

Example 21 with Pet

use of org.nutz.dao.test.meta.Pet in project nutz by nutzam.

the class SqlTemplateTest method testQueryForObjectClassOfT.

@Test
public void testQueryForObjectClassOfT() {
    pojos.initPet();
    Pet pet = Pet.create("papa");
    Timestamp createTime = new Timestamp(System.currentTimeMillis() / 1000 * 1000);
    pet.setBirthday(createTime);
    dao.insert(pet);
    String sql = "SELECT birthday FROM t_pet";
    Timestamp dbCreateTime = sqlTemplate.queryForObject(sql, null, Timestamp.class);
    assertEquals(createTime.getTime() / 1000, dbCreateTime.getTime() / 1000);
    String sql1 = "SELECT birthday FROM t_pet WHERE 1=2";
    dbCreateTime = sqlTemplate.queryForObject(sql1, null, Timestamp.class);
    assertTrue(dbCreateTime == null);
}

Example 22 with Pet

use of org.nutz.dao.test.meta.Pet in project nutz by nutzam.

the class SimpleDaoTest method test_query_2.

@Test
public void test_query_2() {
    dao.insert(Pet.create(100));
    List<Pet> list = dao.query(Pet.class, null);
    for (Pet pet : list) {
        assertNotNull(pet.getName());
    }
}

Example 23 with Pet

use of org.nutz.dao.test.meta.Pet in project nutz by nutzam.

the class SimpleDaoTest method test_simple_fetch_record.

@Test
public void test_simple_fetch_record() {
    Pet pet = Pet.create("abc");
    long now = System.currentTimeMillis();
    pet.setBirthday(Castors.me().castTo(now / 1000 * 1000, Timestamp.class));
    dao.insert(pet);
    List<Record> pets = dao.query("t_pet", null, null);
    assertEquals(1, pets.size());
    assertEquals("abc", pets.get(0).getString("name"));
    assertEquals(now / 1000, pets.get(0).getTimestamp("birthday").getTime() / 1000);
}

Example 24 with Pet

use of org.nutz.dao.test.meta.Pet in project nutz by nutzam.

the class SimpleDaoTest method test_escape_char.

/**
     * for issue #515 写给 mysql 一个特殊的例子
     */
@Test
public void test_escape_char() {
    if (dao.meta().isMySql()) {
        dao.insert(Pet.create("A").setNickName("AAA"));
        dao.insert(Pet.create("B").setNickName("B%B"));
        Criteria cri = Cnd.cri();
        cri.where().andLike("alias", "\\%");
        List<Pet> pets = dao.query(Pet.class, cri);
        assertEquals(1, pets.size());
        assertEquals("B", pets.get(0).getName());
    }
}

Example 25 with Pet

use of org.nutz.dao.test.meta.Pet in project nutz by nutzam.

the class CndTest method test_from_obj.

@Test
public void test_from_obj() {
    Pet pet = new Pet();
    pet.setName("wendal");
    System.out.println(Cnd.from(dao, pet));
    assertEquals(" WHERE (name='wendal')", Cnd.from(dao, pet).toString());
    pet.setAge(10);
    System.out.println(Cnd.from(dao, pet));
    assertEquals(" WHERE (name='wendal' AND age=10)", Cnd.from(dao, pet).toString());
    pet.setAge(0);
    assertEquals(" WHERE (name='wendal' AND age=0)", Cnd.from(dao, pet, FieldMatcher.make("age|name", null, true).setIgnoreZero(false)).toString());
}