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

Example 41 with Pet

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

the class UpdateTest method test_update_chain_and_cnd.

@Test
public void test_update_chain_and_cnd() {
    dao.create(Pet.class, true);
    Pet pet = Pet.create("xb");
    pet.setNickName("XB");
    dao.insert(pet);
    dao.update(Pet.class, Chain.make("name", "xiaobai"), Cnd.where("nickName", "=", "XB"));
    pet = dao.fetch(Pet.class, "xiaobai");
    assertEquals("XB", pet.getNickName());
}

Example 42 with Pet

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

the class UpdateTest method test_update_chain_and_cnd_by_in.

@Test
public void test_update_chain_and_cnd_by_in() {
    dao.create(Pet.class, true);
    Pet pet = Pet.create("xb");
    pet.setNickName("XB");
    dao.insert(pet);
    dao.update(Pet.class, Chain.make("name", "xiaobai"), Cnd.where("nickName", "in", Lang.array("XB")));
    pet = dao.fetch(Pet.class, "xiaobai");
    assertEquals("XB", pet.getNickName());
}

Example 43 with Pet

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

the class CustomizedSqlsTest method test_query_without_entity.

@Test
public void test_query_without_entity() {
    pojos.initPet();
    dao.insert(Pet.create(4));
    Sql sql = Sqls.create("SELECT * FROM t_pet $condition");
    sql.setCondition(Cnd.where("name", "like", "pet_%").asc("name"));
    sql.setCallback(new SqlCallback() {

        public Object invoke(Connection conn, ResultSet rs, Sql sql) throws SQLException {
            List<Pet> pets = new ArrayList<Pet>(4);
            while (rs.next()) pets.add(dao.getObject(Pet.class, rs, null));
            return pets;
        }
    });
    dao.execute(sql);
    List<Pet> pets = sql.getList(Pet.class);
    assertEquals(4, pets.size());
    assertEquals("pet_00", pets.get(0).getName());
    assertEquals("pet_01", pets.get(1).getName());
    assertEquals("pet_02", pets.get(2).getName());
    assertEquals("pet_03", pets.get(3).getName());
}

Example 44 with Pet

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

the class SqlTemplateTest method testQueryForRecord.

@Test
public void testQueryForRecord() {
    pojos.initPet();
    Pet pet = Pet.create("papa");
    dao.insert(pet);
    String sql = "SELECT name,age FROM $table WHERE id = @id";
    Map<String, Object> vars = new HashMap<String, Object>();
    vars.put("table", "t_pet");
    Map<String, Object> params = new HashMap<String, Object>();
    params.put("id", pet.getId());
    Record re = sqlTemplate.queryForRecord(sql, vars, params);
    assertEquals(pet.getName(), re.getString("name"));
}

Example 45 with Pet

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

the class SqlTemplateTest method testQueryForObjectEntityOfT.

@Test
public void testQueryForObjectEntityOfT() {
    pojos.initPet();
    Pet pet = Pet.create("papa");
    dao.insert(pet);
    String sql = "SELECT * FROM t_pet";
    Pet p2 = sqlTemplate.queryForObject(sql, null, dao.getEntity(Pet.class));
    assertEquals(pet.getName(), p2.getName());
    String sql1 = "SELECT * FROM t_pet WHERE 1=2";
    Pet p3 = sqlTemplate.queryForObject(sql1, null, dao.getEntity(Pet.class));
    assertTrue(p3 == null);
}