Search in sources :

Example 16 with Pet

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

the class QueryTest method query_by_cri_equals_null.

/**
     * Github Issue #101
     */
@Test
public void query_by_cri_equals_null() {
    Criteria cri = Cnd.cri();
    cri.where().andEquals("name", null);
    List<Pet> pets = dao.query(Pet.class, cri, null);
    assertEquals(0, pets.size());
    cri = Cnd.cri();
    cri.where().andNotEquals("name", null);
    pets = dao.query(Pet.class, cri, null);
    assertEquals(8, pets.size());
}
Also used : Criteria(org.nutz.dao.sql.Criteria) SimpleCriteria(org.nutz.dao.util.cri.SimpleCriteria) Pet(org.nutz.dao.test.meta.Pet) Test(org.junit.Test)

Example 17 with Pet

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

the class SimpleDaoTest method test_simple_update.

@Test
public void test_simple_update() {
    dao.fastInsert(Lang.array(Pet.create("A"), Pet.create("B")));
    Pet a = dao.fetch(Pet.class, "A");
    a.setName("C");
    a.setAge(5);
    dao.update(a);
    Pet c = dao.fetch(Pet.class, "C");
    assertEquals("C", c.getName());
    assertEquals(5, c.getAge());
    Pet b = dao.fetch(Pet.class, "B");
    assertEquals("B", b.getName());
}
Also used : Issue1163Pet(org.nutz.dao.test.meta.issue1163.Issue1163Pet) Pet(org.nutz.dao.test.meta.Pet) Test(org.junit.Test)

Example 18 with Pet

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

the class EachTest method each_by_like_ignorecase.

@Test
public void each_by_like_ignorecase() {
    SimpleCriteria cri = Cnd.cri();
    cri.where().andLike("name", "PeT6", true);
    final List<Pet> pets = new ArrayList<Pet>();
    dao.each(Pet.class, cri, dao.createPager(1, 10), new Each<Pet>() {

        public void invoke(int i, Pet pet, int length) {
            pets.add(pet);
        }
    });
    assertEquals(1, pets.size());
    assertEquals("pet6", pets.get(0).getName());
}
Also used : SimpleCriteria(org.nutz.dao.util.cri.SimpleCriteria) ArrayList(java.util.ArrayList) Pet(org.nutz.dao.test.meta.Pet) Test(org.junit.Test)

Example 19 with Pet

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

the class UpdateTest method test_update_ignore_null.

/**
     * For issue #557
     */
@Test
public void test_update_ignore_null() {
    dao.create(Pet.class, true);
    final Pet pet = Pet.create("XiaoBai").setAge(20);
    dao.insert(pet);
    FieldFilter.create(Pet.class, true).run(new Atom() {

        public void run() {
            Pet p1 = new Pet().setAge(12).setId(pet.getId());
            dao.update(p1);
        }
    });
    Pet p2 = dao.fetch(Pet.class, pet.getId());
    assertEquals("XiaoBai", p2.getName());
}
Also used : Pet(org.nutz.dao.test.meta.Pet) Atom(org.nutz.trans.Atom) Test(org.junit.Test)

Example 20 with Pet

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

the class UpdateTest method test_update_self_plus.

@Test
public void test_update_self_plus() {
    dao.create(Pet.class, true);
    Pet pet = Pet.create("Xy");
    pet.setAge(98);
    dao.insert(pet);
    pet = dao.fetch(Pet.class, (Cnd) null);
    dao.update(Pet.class, Chain.makeSpecial("age", "+1"), null);
    assertEquals(pet.getAge() + 1, dao.fetch(Pet.class, pet.getId()).getAge());
}
Also used : Cnd(org.nutz.dao.Cnd) Pet(org.nutz.dao.test.meta.Pet) Test(org.junit.Test)

Aggregations

Pet (org.nutz.dao.test.meta.Pet)48 Test (org.junit.Test)45 Issue1163Pet (org.nutz.dao.test.meta.issue1163.Issue1163Pet)13 Atom (org.nutz.trans.Atom)8 Sql (org.nutz.dao.sql.Sql)7 ArrayList (java.util.ArrayList)6 Record (org.nutz.dao.entity.Record)5 List (java.util.List)4 HashMap (java.util.HashMap)3 NutDao (org.nutz.dao.impl.NutDao)3 NutSql (org.nutz.dao.impl.sql.NutSql)3 SimpleCriteria (org.nutz.dao.util.cri.SimpleCriteria)3 Connection (java.sql.Connection)2 SQLException (java.sql.SQLException)2 Timestamp (java.sql.Timestamp)2 Cnd (org.nutz.dao.Cnd)2 Criteria (org.nutz.dao.sql.Criteria)2 Master (org.nutz.dao.test.meta.Master)2 Stopwatch (org.nutz.lang.Stopwatch)2 Molecule (org.nutz.trans.Molecule)2