Package mbg.test.ib2j2.generated.flat.model

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

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
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
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
            record.setThirdFirstName("fred3");

            Integer generatedCustomerId = dao.insert(record);
            assertEquals(57, generatedCustomerId.intValue());

            AwfulTableKey key = new AwfulTableKey();
            key.setCustomerId(generatedCustomerId);
            AwfulTable returnedRecord = dao.selectByPrimaryKey(key);

            assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
            assertEquals(record.geteMail(), returnedRecord.geteMail());
            assertEquals(record.getEmailaddress(), returnedRecord
View Full Code Here
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
            record.setThirdFirstName("fred3");

            Integer generatedCustomerId = dao.insertSelective(record);
            assertEquals(57, generatedCustomerId.intValue());

            AwfulTableKey key = new AwfulTableKey();
            key.setCustomerId(generatedCustomerId);
            AwfulTable returnedRecord = dao.selectByPrimaryKey(key);

            assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
            assertEquals(record.geteMail(), returnedRecord.geteMail());
            assertEquals(record.getEmailaddress(), returnedRecord
View Full Code Here
2083
2084
2085
2086
2087
2088
2089
2090
2091
2092
2093
2094
            record.setId2(new Integer(22));

            int rows = dao.updateByPrimaryKey(record);
            assertEquals(1, rows);

            AwfulTableKey key = new AwfulTableKey();
            key.setCustomerId(generatedCustomerId);
            AwfulTable returnedRecord = dao.selectByPrimaryKey(key);

            assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
            assertEquals(record.geteMail(), returnedRecord.geteMail());
            assertEquals(record.getEmailaddress(), returnedRecord
View Full Code Here
TOP

Related Classes of mbg.test.ib2j2.generated.flat.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.UpdateByPrimaryKeyTest
  • mbg.test.ib2j2.flat.AbstractFlatJava2Test
    • 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.