Package mbg.test.ib2j2.generated.conditional.model

Examples of mbg.test.ib2j2.generated.conditional.model.AwfulTable

226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
    public void testFieldsOnlyCountByExample() {
        FieldsonlyDAO dao = getFieldsonlyDAO();

        try {
            Fieldsonly record = new Fieldsonly();
            record.setDoublefield(new Double(11.22));
            record.setFloatfield(new Double(33.44));
            record.setIntegerfield(new Integer(5));
            dao.insert(record);

            record = new Fieldsonly();
            record.setDoublefield(new Double(44.55));
            record.setFloatfield(new Double(66.77));
            record.setIntegerfield(new Integer(8));
            dao.insert(record);

            record = new Fieldsonly();
            record.setDoublefield(new Double(88.99));
            record.setFloatfield(new Double(100.111));
            record.setIntegerfield(new Integer(9));
            dao.insert(record);

            FieldsonlyExample example = new FieldsonlyExample();
            example.createCriteria().andIntegerfieldGreaterThan(new Integer(5));
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
70
            record.setDoublefield(new Double(11.22));
            record.setFloatfield(new Double(33.44));
            record.setIntegerfield(new Integer(5));
            dao.insert(record);

            FieldsonlyExample example = new FieldsonlyExample();
            example.createCriteria().andIntegerfieldEqualTo(new Integer(5));

            List answer = dao.selectByExample(example);
            assertEquals(1, answer.size());

            Fieldsonly returnedRecord = (Fieldsonly) answer.get(0);
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
            record.setDoublefield(new Double(88.99));
            record.setFloatfield(new Double(100.111));
            record.setIntegerfield(new Integer(9));
            dao.insert(record);

            FieldsonlyExample example = new FieldsonlyExample();
            example.createCriteria().andIntegerfieldGreaterThan(new Integer(5));

            List answer = dao.selectByExample(example);
            assertEquals(2, answer.size());

            example.clear();
            answer = dao.selectByExample(example);
            assertEquals(3, answer.size());
        } catch (SQLException e) {
            fail(e.getMessage());
        }
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
            record.setDoublefield(new Double(88.99));
            record.setFloatfield(new Double(100.111));
            record.setIntegerfield(new Integer(9));
            dao.insert(record);

            FieldsonlyExample example = new FieldsonlyExample();
            example.createCriteria().andIntegerfieldEqualTo(new Integer(5));
            example.setDistinct(true);

            List answer = dao.selectByExample(example);
            assertEquals(1, answer.size());

            example.clear();
            answer = dao.selectByExample(example);
            assertEquals(5, answer.size());
        } catch (SQLException e) {
            fail(e.getMessage());
        }
View Full Code Here
173
174
175
176
177
178
179
180
181
182
183
184
            record.setDoublefield(new Double(88.99));
            record.setFloatfield(new Double(100.111));
            record.setIntegerfield(new Integer(9));
            dao.insert(record);

            FieldsonlyExample example = new FieldsonlyExample();
            example.createCriteria();

            List answer = dao.selectByExample(example);
            assertEquals(3, answer.size());

            answer = dao.selectByExample(null);
View Full Code Here
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
            record.setDoublefield(new Double(88.99));
            record.setFloatfield(new Double(100.111));
            record.setIntegerfield(new Integer(9));
            dao.insert(record);

            FieldsonlyExample example = new FieldsonlyExample();
            example.createCriteria().andIntegerfieldGreaterThan(new Integer(5));

            int rows = dao.deleteByExample(example);
            assertEquals(2, rows);

            example.clear();
            List answer = dao.selectByExample(example);
            assertEquals(1, answer.size());
        } catch (SQLException e) {
            fail(e.getMessage());
        }
View Full Code Here
2714
2715
2716
2717
2718
2719
2720
2721
2722
2723
2724
2725
2726
            List ids = new ArrayList();
            ids.add(new Integer(1));
            ids.add(new Integer(11));

            AwfulTableExample example = new AwfulTableExample();
            example.createCriteria().andId1In(ids);
            example.setOrderByClause("\"A_CuStOmEr iD\"");
            List answer = dao.selectByExample(example);
           
            assertEquals(2, answer.size());
            AwfulTable returnedRecord = (AwfulTable) answer.get(0);
            assertEquals(1, returnedRecord.getId1().intValue());
View Full Code Here
2819
2820
2821
2822
2823
2824
2825
2826
2827
2828
2829
2830
            record.setId7(new Integer(777777));
            record.setSecondFirstName("bammbamm2");
            record.setThirdFirstName("bammbamm3");
            dao.insert(record);

            AwfulTableExample example = new AwfulTableExample();
            example.createCriteria().andId1Between(new Integer(1), new Integer(1000));
            List answer = dao.selectByExample(example);
            assertEquals(3, answer.size());
        } catch (SQLException e) {
            fail(e.getMessage());
        }
View Full Code Here
2916
2917
2918
2919
2920
2921
2922
2923
2924
2925
2926
2927
2928
            record.setId7(new Integer(777777));
            record.setSecondFirstName("bammbamm2");
            record.setThirdFirstName("bammbamm3");
            dao.insert(record);

            AwfulTableExample example = new AwfulTableExample();
            example.createCriteria();
            example.setOrderByClause("\"A_CuStOmEr iD\" desc");
           
            List answer = dao.selectByExample(example);
            assertEquals(6, answer.size());
            AwfulTable returnedRecord = (AwfulTable) answer.get(0);
            assertEquals(111111, returnedRecord.getId1().intValue());
View Full Code Here
2973
2974
2975
2976
2977
2978
2979
2980
2981
2982
2983
2984
2985
2986
2987
2988
            record.setSecondFirstName("fred22");
            record.setThirdFirstName("fred33");

            dao.insert(record);

            AwfulTableExample example = new AwfulTableExample();
            example.createCriteria().andEMailLike("fred@%");
            int rows = dao.countByExample(example);
            assertEquals(1, rows);

            example.clear();
            rows = dao.countByExample(example);
            assertEquals(2, rows);
        } catch (SQLException e) {
            fail(e.getMessage());
        }
View Full Code Here
TOP

Related Classes of mbg.test.ib2j2.generated.conditional.model.AwfulTable

  • mbg.test.common.FirstName
  • mbg.test.common.MyTime
  • mbg.test.ib2j2.conditional.CountByExampleTest
  • mbg.test.ib2j2.conditional.DeleteByExampleTest
  • mbg.test.ib2j2.conditional.DeleteByPrimaryKeyTest
  • mbg.test.ib2j2.conditional.InsertTest
  • mbg.test.ib2j2.conditional.SelectByExampleTest
  • mbg.test.ib2j2.conditional.SelectByPrimaryKeyTest
  • mbg.test.ib2j2.conditional.UpdateByExampleTest
  • mbg.test.ib2j2.conditional.UpdateByPrimaryKeyTest
    • 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.