Package org.nutz.dao.test.meta

Examples of org.nutz.dao.test.meta.Pet

84
85
86
87
88
89
90
91
92
93
94
95
96
    }

    @Test
    public void testQueryForObjectClassOfT() {
        pojos.initPet();
        Pet pet = Pet.create("papa");
        Timestamp createTime = new Timestamp(System.currentTimeMillis());
        pet.setBirthday(createTime);

        dao.insert(pet);
        String sql = "SELECT birthday FROM t_pet";
        Timestamp dbCreateTime = sqlTemplate.queryForObject(sql, null, Timestamp.class);
        assertEquals(createTime, dbCreateTime);
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
    }

    @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);
    }
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
    }

    @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"));
    }
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
        Master m = new Master();
        m.setName("zozoh");
        m.setPets(new ArrayList<Pet>(2));

        Pet pet = new Pet();
        pet.setAge(25);
        pet.setName("Wendal");
        m.getPets().add(pet);

        pet = new Pet();
        pet.setAge(25);
        pet.setName("Juqkai");
        m.getPets().add(pet);

        dao.insertWith(m, "pets");
        assertTrue(m.getId() > 0);
        assertEquals(2, dao.count(Pet.class, Cnd.where("masterId", "=", m.getId())));
View Full Code Here
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
     * 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());
    }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
    }

    @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());
    }
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
    }

    @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());
    }
View Full Code Here
235
236
237
238
239
240
241
242
243
244
245
246
247
    }

    @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());
    }
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
        dao.create(Pet.class, true);
    }

    private void insertRecords(int len) {
        for (int i = 0; i < len; i++) {
            Pet pet = Pet.create("pet" + i);
            pet.setNickName("alias_" + i);
            pet.setPrice(R.random(30, 100) / 3.1415f);
            dao.insert(pet);
        }
    }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
89
        }
    }

    @Test
    public void test_simple_fetch_record() {
        Pet pet = Pet.create("abc");
        long now = System.currentTimeMillis();
        pet.setBirthday(Castors.me().castTo(now, 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"));
View Full Code Here
TOP

Related Classes of org.nutz.dao.test.meta.Pet

  • org.nutz.dao.impl.sql.SqlLiteralTest
  • org.nutz.dao.PojoTest
  • org.nutz.dao.test.exec.SimpleDaoExecTest
  • org.nutz.dao.test.mapping.ManyTest
  • org.nutz.dao.test.normal.FieldFilterTest
  • org.nutz.dao.test.normal.InsertTest
  • org.nutz.dao.test.normal.QueryTest
  • org.nutz.dao.test.normal.SimpleDaoTest
  • org.nutz.dao.test.normal.UpdateTest
  • org.nutz.dao.test.sqls.SqlTemplateTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.