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

Example 11 with Pet

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

the class InsertTest method test_insert_by_fieldfilter.

@Test
public void test_insert_by_fieldfilter() {
    dao.create(Pet.class, true);
    final Pet pet = Pet.create("xb");
    pet.setNickName("xiaobai");
    FieldFilter.create(Pet.class, "^id|name$").run(new Atom() {

        public void run() {
            dao.insert(pet);
        }
    });
    Pet xb = dao.fetch(Pet.class, "xb");
    assertNull(xb.getNickName());
}

Example 12 with Pet

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

the class QueryTest method test_record_to_entity.

@Test
public void test_record_to_entity() {
    if (dao.meta().isH2())
        // h2死活过不去啊
        return;
    dao.each(Pet.class, null, new Each<Pet>() {

        public void invoke(int index, Pet pet, int length) {
            pet.setNickName("AA_" + pet.getName().toUpperCase());
            // 不知道为啥h2数据库会抛出表不存在的异常
            dao.update(pet);
        }
    });
    Entity<Pet> en = dao.getEntity(Pet.class);
    Sql sql = Sqls.queryRecord("SELECT * FROM t_pet");
    dao.execute(sql);
    List<Record> recs = sql.getList(Record.class);
    Pet[] pets = new Pet[recs.size()];
    int i = 0;
    for (Record rec : recs) pets[i++] = rec.toEntity(en);
    for (Pet pet : pets) assertEquals("AA_" + pet.getName().toUpperCase(), pet.getNickName());
}

Example 13 with Pet

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

the class QueryTest method fetch_record.

@Test
public void fetch_record() {
    Record re = dao.fetch("t_pet", Cnd.where("name", "=", "pet3"));
    if (dao.meta().isOracle())
        re.remove("rn");
    if (dao.meta().isSqlServer()) {
        re.remove("__rn__");
        re.remove("__tc__");
    }
    System.out.println(re.keySet());
    Pet pet = re.toPojo(Pet.class);
    assertEquals(7, re.getColumnCount());
    assertEquals(4, pet.getId());
    assertEquals("pet3", pet.getName());
    dao.create(Pet.class, true);
    dao.insert(Pet.create("中文啊中文"));
}

Example 14 with Pet

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

the class QueryTest method test_fetcy_by_fieldfilter.

/**
     * add for Issue #605
     */
@Test
public void test_fetcy_by_fieldfilter() {
    Molecule<Pet> mo = new Molecule<Pet>() {

        public void run() {
            setObj(dao.fetch(Pet.class, 5));
        }
    };
    FieldFilter.create(Pet.class, "^id|name$").run(mo);
    Pet pet = mo.getObj();
    assertEquals(5, pet.getId());
    assertEquals("pet4", pet.getName());
    assertEquals(0, pet.getAge());
    assertNull(pet.getBirthday());
    assertNull(pet.getNickName());
}

Example 15 with Pet

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

the class QueryTest method query_by_like_ignorecase.

@Test
public void query_by_like_ignorecase() {
    SimpleCriteria cri = Cnd.cri();
    cri.where().andLike("name", "PeT6", true);
    List<Pet> pets = dao.query(Pet.class, cri, dao.createPager(1, 10));
    assertEquals(1, pets.size());
    assertEquals("pet6", pets.get(0).getName());
}