use of mbg.test.ib2j2.generated.flat.model.AwfulTable in project generator by mybatis.
the class SelectByExampleTest method testAwfulTableSelectByExampleLike.
public void testAwfulTableSelectByExampleLike() {
AwfulTableDAO dao = getAwfulTableDAO();
try {
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(new Integer(1));
record.setId2(new Integer(2));
record.setId5(new Integer(5));
record.setId6(new Integer(6));
record.setId7(new Integer(7));
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("wilma@wilma.com");
record.setEmailaddress("alsoWilma@wilma.com");
record.setFirstFirstName("wilma1");
record.setFrom("from field");
record.setId1(new Integer(11));
record.setId2(new Integer(22));
record.setId5(new Integer(55));
record.setId6(new Integer(66));
record.setId7(new Integer(77));
record.setSecondFirstName("wilma2");
record.setThirdFirstName("wilma3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("pebbles@pebbles.com");
record.setEmailaddress("alsoPebbles@pebbles.com");
record.setFirstFirstName("pebbles1");
record.setFrom("from field");
record.setId1(new Integer(111));
record.setId2(new Integer(222));
record.setId5(new Integer(555));
record.setId6(new Integer(666));
record.setId7(new Integer(777));
record.setSecondFirstName("pebbles2");
record.setThirdFirstName("pebbles3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("barney@barney.com");
record.setEmailaddress("alsoBarney@barney.com");
record.setFirstFirstName("barney1");
record.setFrom("from field");
record.setId1(new Integer(1111));
record.setId2(new Integer(2222));
record.setId5(new Integer(5555));
record.setId6(new Integer(6666));
record.setId7(new Integer(7777));
record.setSecondFirstName("barney2");
record.setThirdFirstName("barney3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("betty@betty.com");
record.setEmailaddress("alsoBetty@betty.com");
record.setFirstFirstName("betty1");
record.setFrom("from field");
record.setId1(new Integer(11111));
record.setId2(new Integer(22222));
record.setId5(new Integer(55555));
record.setId6(new Integer(66666));
record.setId7(new Integer(77777));
record.setSecondFirstName("betty2");
record.setThirdFirstName("betty3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("bammbamm@bammbamm.com");
record.setEmailaddress("alsoBammbamm@bammbamm.com");
record.setFirstFirstName("bammbamm1");
record.setFrom("from field");
record.setId1(new Integer(111111));
record.setId2(new Integer(222222));
record.setId5(new Integer(555555));
record.setId6(new Integer(666666));
record.setId7(new Integer(777777));
record.setSecondFirstName("bammbamm2");
record.setThirdFirstName("bammbamm3");
dao.insert(record);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andFirstFirstNameLike("b%");
example.setOrderByClause("\"A_CuStOmEr iD\"");
List answer = dao.selectByExample(example);
assertEquals(3, answer.size());
AwfulTable returnedRecord = (AwfulTable) answer.get(0);
assertEquals(1111, returnedRecord.getId1().intValue());
assertEquals(2222, returnedRecord.getId2().intValue());
returnedRecord = (AwfulTable) answer.get(1);
assertEquals(11111, returnedRecord.getId1().intValue());
assertEquals(22222, returnedRecord.getId2().intValue());
returnedRecord = (AwfulTable) answer.get(2);
assertEquals(111111, returnedRecord.getId1().intValue());
assertEquals(222222, returnedRecord.getId2().intValue());
} catch (Exception e) {
fail(e.getMessage());
}
}
use of mbg.test.ib2j2.generated.flat.model.AwfulTable in project generator by mybatis.
the class SelectByPrimaryKeyTest method testAwfulTableSelectByPrimaryKey.
public void testAwfulTableSelectByPrimaryKey() {
AwfulTableDAO dao = getAwfulTableDAO();
try {
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(new Integer(1));
record.setId2(new Integer(2));
record.setId5(new Integer(5));
record.setId6(new Integer(6));
record.setId7(new Integer(7));
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("fred2@fred.com");
record.setEmailaddress("alsofred2@fred.com");
record.setFirstFirstName("fred11");
record.setFrom("from from field");
record.setId1(new Integer(11));
record.setId2(new Integer(22));
record.setId5(new Integer(55));
record.setId6(new Integer(66));
record.setId7(new Integer(77));
record.setSecondFirstName("fred22");
record.setThirdFirstName("fred33");
Integer generatedKey = dao.insert(record);
AwfulTable returnedRecord = dao.selectByPrimaryKey(generatedKey);
assertNotNull(returnedRecord);
assertEquals(record.getCustomerId(), returnedRecord.getCustomerId());
assertEquals(record.geteMail(), returnedRecord.geteMail());
assertEquals(record.getEmailaddress(), returnedRecord.getEmailaddress());
assertEquals(record.getFirstFirstName(), returnedRecord.getFirstFirstName());
assertEquals(record.getFrom(), returnedRecord.getFrom());
assertEquals(record.getId1(), returnedRecord.getId1());
assertEquals(record.getId2(), returnedRecord.getId2());
assertEquals(record.getId5(), returnedRecord.getId5());
assertEquals(record.getId6(), returnedRecord.getId6());
assertEquals(record.getId7(), returnedRecord.getId7());
assertEquals(record.getSecondFirstName(), returnedRecord.getSecondFirstName());
assertEquals(record.getThirdFirstName(), returnedRecord.getThirdFirstName());
} catch (Exception e) {
fail(e.getMessage());
}
}
use of mbg.test.ib2j2.generated.flat.model.AwfulTable in project generator by mybatis.
the class FlatJava5Test method testHashCode3.
@Test
public void testHashCode3() {
AwfulTable awfulTable1 = new AwfulTable();
awfulTable1.setActive(false);
awfulTable1.setCustomerId(3);
awfulTable1.seteMail("fred@fred.com");
awfulTable1.setEmailaddress("fred@fred.com");
awfulTable1.setFirstFirstName("Fred");
awfulTable1.setFrom("from");
awfulTable1.setId1(22);
awfulTable1.setId2(33);
awfulTable1.setId5(55);
awfulTable1.setId6(66);
awfulTable1.setId7(77);
awfulTable1.setLastName("Rubble");
awfulTable1.setSecondFirstName("Bamm Bamm");
awfulTable1.setThirdFirstName("Pebbles");
AwfulTable awfulTable2 = new AwfulTable();
awfulTable2.setActive(false);
awfulTable2.setCustomerId(3);
awfulTable2.seteMail("fred@fred.com");
awfulTable2.setEmailaddress("fred@fred.com");
awfulTable2.setFirstFirstName("Fred");
awfulTable2.setFrom("from");
awfulTable2.setId1(22);
awfulTable2.setId2(33);
awfulTable2.setId5(55);
awfulTable2.setId6(66);
awfulTable2.setId7(77);
awfulTable2.setLastName("Rubble");
awfulTable2.setSecondFirstName("Bamm Bamm");
awfulTable2.setThirdFirstName("Pebbles");
assertTrue(awfulTable1.hashCode() == awfulTable2.hashCode());
}
use of mbg.test.ib2j2.generated.flat.model.AwfulTable in project generator by mybatis.
the class DeleteByExampleTest method testAwfulTableDeleteByExample.
public void testAwfulTableDeleteByExample() {
AwfulTableDAO dao = getAwfulTableDAO();
try {
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(new Integer(1));
record.setId2(new Integer(2));
record.setId5(new Integer(5));
record.setId6(new Integer(6));
record.setId7(new Integer(7));
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("fred2@fred.com");
record.setEmailaddress("alsofred2@fred.com");
record.setFirstFirstName("fred11");
record.setFrom("from from field");
record.setId1(new Integer(11));
record.setId2(new Integer(22));
record.setId5(new Integer(55));
record.setId6(new Integer(66));
record.setId7(new Integer(77));
record.setSecondFirstName("fred22");
record.setThirdFirstName("fred33");
dao.insert(record);
AwfulTableExample example = new AwfulTableExample();
List answer = dao.selectByExample(example);
assertEquals(2, answer.size());
example = new AwfulTableExample();
example.createCriteria().andEMailLike("fred@%");
int rows = dao.deleteByExample(example);
assertEquals(1, rows);
example.clear();
answer = dao.selectByExample(example);
assertEquals(1, answer.size());
} catch (Exception e) {
fail(e.getMessage());
}
}
use of mbg.test.ib2j2.generated.flat.model.AwfulTable in project generator by mybatis.
the class InsertTest method testAwfulTableInsert.
public void testAwfulTableInsert() {
AwfulTableDAO dao = getAwfulTableDAO();
try {
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(new Integer(1));
record.setId2(new Integer(2));
record.setId5(new Integer(5));
record.setId6(new Integer(6));
record.setId7(new Integer(7));
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
record.setActive(true);
Integer generatedCustomerId = dao.insert(record);
assertEquals(57, generatedCustomerId.intValue());
AwfulTable returnedRecord = dao.selectByPrimaryKey(generatedCustomerId);
assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
assertEquals(record.geteMail(), returnedRecord.geteMail());
assertEquals(record.getEmailaddress(), returnedRecord.getEmailaddress());
assertEquals(record.getFirstFirstName(), returnedRecord.getFirstFirstName());
assertEquals(record.getFrom(), returnedRecord.getFrom());
assertEquals(record.getId1(), returnedRecord.getId1());
assertEquals(record.getId2(), returnedRecord.getId2());
assertEquals(record.getId5(), returnedRecord.getId5());
assertEquals(record.getId6(), returnedRecord.getId6());
assertEquals(record.getId7(), returnedRecord.getId7());
assertEquals(record.getSecondFirstName(), returnedRecord.getSecondFirstName());
assertEquals(record.getThirdFirstName(), returnedRecord.getThirdFirstName());
assertEquals(record.isActive(), returnedRecord.isActive());
} catch (Exception e) {
fail(e.getMessage());
}
}
Aggregations