You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ibatis.apache.org by jg...@apache.org on 2007/02/17 07:14:21 UTC
svn commit: r508716 [8/10] - in
/ibatis/trunk/java/mapper/mapper2/tools/abator/core: build/ devlib/ doc/
src/org/apache/ibatis/abator/ant/ src/org/apache/ibatis/abator/api/
src/org/apache/ibatis/abator/config/
src/org/apache/ibatis/abator/internal/db/ ...
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/java5/FlatJava5Tests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/java5/FlatJava5Tests.java?view=diff&rev=508716&r1=508715&r2=508716
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/java5/FlatJava5Tests.java (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/java5/FlatJava5Tests.java Fri Feb 16 22:14:18 2007
@@ -23,7 +23,8 @@
import java.util.List;
import abatortest.BaseTest;
-import abatortest.generated.conditional.java2.model.PkfieldsKey;
+import abatortest.generated.flat.java5.dao.AwfulTableDAO;
+import abatortest.generated.flat.java5.dao.AwfulTableDAOImpl;
import abatortest.generated.flat.java5.dao.FieldsblobsDAO;
import abatortest.generated.flat.java5.dao.FieldsblobsDAOImpl;
import abatortest.generated.flat.java5.dao.FieldsonlyDAO;
@@ -36,6 +37,8 @@
import abatortest.generated.flat.java5.dao.PkfieldsblobsDAOImpl;
import abatortest.generated.flat.java5.dao.PkonlyDAO;
import abatortest.generated.flat.java5.dao.PkonlyDAOImpl;
+import abatortest.generated.flat.java5.model.AwfulTable;
+import abatortest.generated.flat.java5.model.AwfulTableExample;
import abatortest.generated.flat.java5.model.Fieldsblobs;
import abatortest.generated.flat.java5.model.FieldsblobsExample;
import abatortest.generated.flat.java5.model.Fieldsonly;
@@ -148,7 +151,7 @@
FieldsonlyExample example = new FieldsonlyExample();
example.createCriteria();
- List answer = dao.selectByExample(example);
+ List<Fieldsonly> answer = dao.selectByExample(example);
assertEquals(3, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
@@ -321,7 +324,7 @@
PkonlyExample example = new PkonlyExample();
example.createCriteria();
- List answer = dao.selectByExample(example);
+ List<Pkonly> answer = dao.selectByExample(example);
assertEquals(3, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
@@ -424,10 +427,6 @@
int rows = dao.updateByPrimaryKeySelective(newRecord);
assertEquals(1, rows);
- PkfieldsKey key = new PkfieldsKey();
- key.setId1(1);
- key.setId2(2);
-
Pkfields returnedRecord = dao.selectByPrimaryKey(1, 2);
assertTrue(datesAreEqual(record.getDatefield(), returnedRecord
@@ -470,7 +469,7 @@
assertEquals(1, rows);
PkfieldsExample example = new PkfieldsExample();
- List answer = dao.selectByExample(example);
+ List<Pkfields> answer = dao.selectByExample(example);
assertEquals(0, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
@@ -592,15 +591,15 @@
PkfieldsExample example = new PkfieldsExample();
example.createCriteria().andFirstnameLike("B%");
example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
+ List<Pkfields> answer = dao.selectByExample(example);
assertEquals(3, answer.size());
- Pkfields returnedRecord = (Pkfields) answer.get(0);
+ Pkfields returnedRecord = answer.get(0);
assertEquals(2, returnedRecord.getId1().intValue());
assertEquals(1, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(1);
+ returnedRecord = answer.get(1);
assertEquals(2, returnedRecord.getId1().intValue());
assertEquals(2, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(2);
+ returnedRecord = answer.get(2);
assertEquals(2, returnedRecord.getId1().intValue());
assertEquals(3, returnedRecord.getId2().intValue());
} catch (SQLException e) {
@@ -657,15 +656,15 @@
PkfieldsExample example = new PkfieldsExample();
example.createCriteria().andFirstnameNotLike("B%");
example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
+ List<Pkfields> answer = dao.selectByExample(example);
assertEquals(3, answer.size());
- Pkfields returnedRecord = (Pkfields) answer.get(0);
+ Pkfields returnedRecord = answer.get(0);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(1, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(1);
+ returnedRecord = answer.get(1);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(2, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(2);
+ returnedRecord = answer.get(2);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(3, returnedRecord.getId2().intValue());
} catch (SQLException e) {
@@ -724,12 +723,12 @@
example.or(example.createCriteria().andFirstnameLike("Wi%"));
example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
+ List<Pkfields> answer = dao.selectByExample(example);
assertEquals(2, answer.size());
- Pkfields returnedRecord = (Pkfields) answer.get(0);
+ Pkfields returnedRecord = answer.get(0);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(2, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(1);
+ returnedRecord = answer.get(1);
assertEquals(2, returnedRecord.getId1().intValue());
assertEquals(3, returnedRecord.getId2().intValue());
} catch (SQLException e) {
@@ -737,7 +736,6 @@
}
}
- @SuppressWarnings("unchecked")
public void testPKFieldsSelectByExampleIn() {
PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
@@ -784,7 +782,7 @@
record.setId2(3);
dao.insert(record);
- List ids = new ArrayList();
+ List<Integer> ids = new ArrayList<Integer>();
ids.add(1);
ids.add(3);
@@ -792,18 +790,18 @@
example.createCriteria().andId2In(ids);
example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
+ List<Pkfields> answer = dao.selectByExample(example);
assertEquals(4, answer.size());
- Pkfields returnedRecord = (Pkfields) answer.get(0);
+ Pkfields returnedRecord = answer.get(0);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(1, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(1);
+ returnedRecord = answer.get(1);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(3, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(2);
+ returnedRecord = answer.get(2);
assertEquals(2, returnedRecord.getId1().intValue());
assertEquals(1, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(3);
+ returnedRecord = answer.get(3);
assertEquals(2, returnedRecord.getId1().intValue());
assertEquals(3, returnedRecord.getId2().intValue());
} catch (SQLException e) {
@@ -861,7 +859,7 @@
example.createCriteria().andId2Between(1, 3);
example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
+ List<Pkfields> answer = dao.selectByExample(example);
assertEquals(6, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
@@ -918,7 +916,7 @@
example.createCriteria();
example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
+ List<Pkfields> answer = dao.selectByExample(example);
assertEquals(6, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
@@ -986,7 +984,7 @@
values);
example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
+ List<Pkfields> answer = dao.selectByExample(example);
assertEquals(2, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
@@ -1206,7 +1204,7 @@
PkblobsExample example = new PkblobsExample();
example.createCriteria();
- List answer = dao.selectByExampleWithoutBLOBs(example);
+ List<Pkblobs> answer = dao.selectByExampleWithoutBLOBs(example);
assertEquals(2, answer.size());
} catch (SQLException e) {
@@ -1577,7 +1575,7 @@
PkfieldsblobsExample example = new PkfieldsblobsExample();
example.createCriteria();
- List answer = dao.selectByExampleWithBLOBs(example);
+ List<Pkfieldsblobs> answer = dao.selectByExampleWithBLOBs(example);
assertEquals(2, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
@@ -1732,8 +1730,1030 @@
FieldsblobsExample example = new FieldsblobsExample();
example.createCriteria();
- List answer = dao.selectByExampleWithBLOBs(example);
+ List<Fieldsblobs> answer = dao.selectByExampleWithBLOBs(example);
assertEquals(2, answer.size());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableInsert() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ 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.getFourthFirstName(), returnedRecord
+ .getFourthFirstName());
+ 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.getSecondCustomerId(), returnedRecord
+ .getSecondCustomerId());
+ assertEquals(record.getSecondFirstName(), returnedRecord
+ .getSecondFirstName());
+ assertEquals(record.getThirdFirstName(), returnedRecord
+ .getThirdFirstName());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableUpdateByPrimaryKey() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ Integer generatedCustomerId = dao.insert(record);
+
+ record.setId1(11);
+ record.setId2(22);
+
+ int rows = dao.updateByPrimaryKey(record);
+ assertEquals(1, rows);
+
+ 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.getFourthFirstName(), returnedRecord
+ .getFourthFirstName());
+ 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.getSecondCustomerId(), returnedRecord
+ .getSecondCustomerId());
+ assertEquals(record.getSecondFirstName(), returnedRecord
+ .getSecondFirstName());
+ assertEquals(record.getThirdFirstName(), returnedRecord
+ .getThirdFirstName());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableUpdateByPrimaryKeySelective() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ Integer generatedCustomerId = dao.insert(record);
+
+ AwfulTable newRecord = new AwfulTable();
+ newRecord.setCustomerId(generatedCustomerId);
+ newRecord.setId1(11);
+ newRecord.setId2(22);
+
+ int rows = dao.updateByPrimaryKeySelective(newRecord);
+ assertEquals(1, rows);
+
+ 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.getFourthFirstName(), returnedRecord
+ .getFourthFirstName());
+ assertEquals(record.getFrom(), returnedRecord.getFrom());
+ assertEquals(newRecord.getId1(), returnedRecord.getId1());
+ assertEquals(newRecord.getId2(), returnedRecord.getId2());
+ assertEquals(record.getId5(), returnedRecord.getId5());
+ assertEquals(record.getId6(), returnedRecord.getId6());
+ assertEquals(record.getId7(), returnedRecord.getId7());
+ assertEquals(record.getSecondCustomerId(), returnedRecord
+ .getSecondCustomerId());
+ assertEquals(record.getSecondFirstName(), returnedRecord
+ .getSecondFirstName());
+ assertEquals(record.getThirdFirstName(), returnedRecord
+ .getThirdFirstName());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableDeleteByPrimaryKey() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ Integer generatedCustomerId = dao.insert(record);
+
+ int rows = dao.deleteByPrimaryKey(generatedCustomerId);
+ assertEquals(1, rows);
+
+ AwfulTableExample example = new AwfulTableExample();
+ List<AwfulTable> answer = dao.selectByExample(example);
+ assertEquals(0, answer.size());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableDeleteByExample() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("fred44");
+ record.setFrom("from from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("fred22");
+ record.setThirdFirstName("fred33");
+
+ dao.insert(record);
+
+ AwfulTableExample example = new AwfulTableExample();
+ List<AwfulTable> 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 (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableSelectByPrimaryKey() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("fred44");
+ record.setFrom("from from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ 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.getFourthFirstName(), returnedRecord
+ .getFourthFirstName());
+ 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.getSecondCustomerId(), returnedRecord
+ .getSecondCustomerId());
+ assertEquals(record.getSecondFirstName(), returnedRecord
+ .getSecondFirstName());
+ assertEquals(record.getThirdFirstName(), returnedRecord
+ .getThirdFirstName());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableSelectByExampleLike() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("wilma4");
+ record.setFrom("from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("pebbles4");
+ record.setFrom("from field");
+ record.setId1(111);
+ record.setId2(222);
+ record.setId5(555);
+ record.setId6(666);
+ record.setId7(777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("barney4");
+ record.setFrom("from field");
+ record.setId1(1111);
+ record.setId2(2222);
+ record.setId5(5555);
+ record.setId6(6666);
+ record.setId7(7777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("betty4");
+ record.setFrom("from field");
+ record.setId1(11111);
+ record.setId2(22222);
+ record.setId5(55555);
+ record.setId6(66666);
+ record.setId7(77777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("bammbamm4");
+ record.setFrom("from field");
+ record.setId1(111111);
+ record.setId2(222222);
+ record.setId5(555555);
+ record.setId6(666666);
+ record.setId7(777777);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("bammbamm2");
+ record.setThirdFirstName("bammbamm3");
+ dao.insert(record);
+
+ AwfulTableExample example = new AwfulTableExample();
+ example.createCriteria().andFirstFirstNameLike("b%");
+ example.setOrderByClause("\"A_CuStOmEr iD\"");
+ List<AwfulTable> answer = dao.selectByExample(example);
+ assertEquals(3, answer.size());
+ AwfulTable returnedRecord = answer.get(0);
+ assertEquals(1111, returnedRecord.getId1().intValue());
+ assertEquals(2222, returnedRecord.getId2().intValue());
+ returnedRecord = answer.get(1);
+ assertEquals(11111, returnedRecord.getId1().intValue());
+ assertEquals(22222, returnedRecord.getId2().intValue());
+ returnedRecord = answer.get(2);
+ assertEquals(111111, returnedRecord.getId1().intValue());
+ assertEquals(222222, returnedRecord.getId2().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableSelectByExampleNotLike() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("wilma4");
+ record.setFrom("from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("pebbles4");
+ record.setFrom("from field");
+ record.setId1(111);
+ record.setId2(222);
+ record.setId5(555);
+ record.setId6(666);
+ record.setId7(777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("barney4");
+ record.setFrom("from field");
+ record.setId1(1111);
+ record.setId2(2222);
+ record.setId5(5555);
+ record.setId6(6666);
+ record.setId7(7777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("betty4");
+ record.setFrom("from field");
+ record.setId1(11111);
+ record.setId2(22222);
+ record.setId5(55555);
+ record.setId6(66666);
+ record.setId7(77777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("bammbamm4");
+ record.setFrom("from field");
+ record.setId1(111111);
+ record.setId2(222222);
+ record.setId5(555555);
+ record.setId6(666666);
+ record.setId7(777777);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("bammbamm2");
+ record.setThirdFirstName("bammbamm3");
+ dao.insert(record);
+
+ AwfulTableExample example = new AwfulTableExample();
+ example.createCriteria().andFirstFirstNameNotLike("b%");
+ example.setOrderByClause("\"A_CuStOmEr iD\"");
+ List<AwfulTable> answer = dao.selectByExample(example);
+ assertEquals(3, answer.size());
+ AwfulTable returnedRecord = answer.get(0);
+ assertEquals(1, returnedRecord.getId1().intValue());
+ assertEquals(2, returnedRecord.getId2().intValue());
+ returnedRecord = answer.get(1);
+ assertEquals(11, returnedRecord.getId1().intValue());
+ assertEquals(22, returnedRecord.getId2().intValue());
+ returnedRecord = answer.get(2);
+ assertEquals(111, returnedRecord.getId1().intValue());
+ assertEquals(222, returnedRecord.getId2().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableSelectByExampleComplexLike() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("wilma4");
+ record.setFrom("from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("pebbles4");
+ record.setFrom("from field");
+ record.setId1(111);
+ record.setId2(222);
+ record.setId5(555);
+ record.setId6(666);
+ record.setId7(777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("barney4");
+ record.setFrom("from field");
+ record.setId1(1111);
+ record.setId2(2222);
+ record.setId5(5555);
+ record.setId6(6666);
+ record.setId7(7777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("betty4");
+ record.setFrom("from field");
+ record.setId1(11111);
+ record.setId2(22222);
+ record.setId5(55555);
+ record.setId6(66666);
+ record.setId7(77777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("bammbamm4");
+ record.setFrom("from field");
+ record.setId1(111111);
+ record.setId2(222222);
+ record.setId5(555555);
+ record.setId6(666666);
+ record.setId7(777777);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("bammbamm2");
+ record.setThirdFirstName("bammbamm3");
+ dao.insert(record);
+
+ AwfulTableExample example = new AwfulTableExample();
+ example.createCriteria().andFirstFirstNameLike("b%").andId2EqualTo(222222);
+ example.or(example.createCriteria().andFirstFirstNameLike("wi%"));
+ example.setOrderByClause("\"A_CuStOmEr iD\"");
+ List<AwfulTable> answer = dao.selectByExample(example);
+ assertEquals(2, answer.size());
+ AwfulTable returnedRecord = answer.get(0);
+ assertEquals(11, returnedRecord.getId1().intValue());
+ assertEquals(22, returnedRecord.getId2().intValue());
+ returnedRecord = answer.get(1);
+ assertEquals(111111, returnedRecord.getId1().intValue());
+ assertEquals(222222, returnedRecord.getId2().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableSelectByExampleIn() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("wilma4");
+ record.setFrom("from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("pebbles4");
+ record.setFrom("from field");
+ record.setId1(111);
+ record.setId2(222);
+ record.setId5(555);
+ record.setId6(666);
+ record.setId7(777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("barney4");
+ record.setFrom("from field");
+ record.setId1(1111);
+ record.setId2(2222);
+ record.setId5(5555);
+ record.setId6(6666);
+ record.setId7(7777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("betty4");
+ record.setFrom("from field");
+ record.setId1(11111);
+ record.setId2(22222);
+ record.setId5(55555);
+ record.setId6(66666);
+ record.setId7(77777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("bammbamm4");
+ record.setFrom("from field");
+ record.setId1(111111);
+ record.setId2(222222);
+ record.setId5(555555);
+ record.setId6(666666);
+ record.setId7(777777);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("bammbamm2");
+ record.setThirdFirstName("bammbamm3");
+ dao.insert(record);
+
+ List<Integer> ids = new ArrayList<Integer>();
+ ids.add(1);
+ ids.add(11);
+
+ AwfulTableExample example = new AwfulTableExample();
+ example.createCriteria().andId1In(ids);
+ example.setOrderByClause("\"A_CuStOmEr iD\"");
+ List<AwfulTable> answer = dao.selectByExample(example);
+
+ assertEquals(2, answer.size());
+ AwfulTable returnedRecord = answer.get(0);
+ assertEquals(1, returnedRecord.getId1().intValue());
+ assertEquals(2, returnedRecord.getId2().intValue());
+ returnedRecord = answer.get(1);
+ assertEquals(11, returnedRecord.getId1().intValue());
+ assertEquals(22, returnedRecord.getId2().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableSelectByExampleBetween() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("wilma4");
+ record.setFrom("from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("pebbles4");
+ record.setFrom("from field");
+ record.setId1(111);
+ record.setId2(222);
+ record.setId5(555);
+ record.setId6(666);
+ record.setId7(777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("barney4");
+ record.setFrom("from field");
+ record.setId1(1111);
+ record.setId2(2222);
+ record.setId5(5555);
+ record.setId6(6666);
+ record.setId7(7777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("betty4");
+ record.setFrom("from field");
+ record.setId1(11111);
+ record.setId2(22222);
+ record.setId5(55555);
+ record.setId6(66666);
+ record.setId7(77777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("bammbamm4");
+ record.setFrom("from field");
+ record.setId1(111111);
+ record.setId2(222222);
+ record.setId5(555555);
+ record.setId6(666666);
+ record.setId7(777777);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("bammbamm2");
+ record.setThirdFirstName("bammbamm3");
+ dao.insert(record);
+
+ AwfulTableExample example = new AwfulTableExample();
+ example.createCriteria().andId1Between(1, 1000);
+ List<AwfulTable> answer = dao.selectByExample(example);
+ assertEquals(3, answer.size());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableSelectByExampleNoCriteria() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("wilma4");
+ record.setFrom("from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("pebbles4");
+ record.setFrom("from field");
+ record.setId1(111);
+ record.setId2(222);
+ record.setId5(555);
+ record.setId6(666);
+ record.setId7(777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("barney4");
+ record.setFrom("from field");
+ record.setId1(1111);
+ record.setId2(2222);
+ record.setId5(5555);
+ record.setId6(6666);
+ record.setId7(7777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("betty4");
+ record.setFrom("from field");
+ record.setId1(11111);
+ record.setId2(22222);
+ record.setId5(55555);
+ record.setId6(66666);
+ record.setId7(77777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("bammbamm4");
+ record.setFrom("from field");
+ record.setId1(111111);
+ record.setId2(222222);
+ record.setId5(555555);
+ record.setId6(666666);
+ record.setId7(777777);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("bammbamm2");
+ record.setThirdFirstName("bammbamm3");
+ dao.insert(record);
+
+ AwfulTableExample example = new AwfulTableExample();
+ example.createCriteria();
+ example.setOrderByClause("\"A_CuStOmEr iD\" desc");
+
+ List<AwfulTable> answer = dao.selectByExample(example);
+ assertEquals(6, answer.size());
+ AwfulTable returnedRecord = answer.get(0);
+ assertEquals(111111, returnedRecord.getId1().intValue());
+ returnedRecord = answer.get(1);
+ assertEquals(11111, returnedRecord.getId1().intValue());
+ returnedRecord = answer.get(2);
+ assertEquals(1111, returnedRecord.getId1().intValue());
+ returnedRecord = answer.get(3);
+ assertEquals(111, returnedRecord.getId1().intValue());
+ returnedRecord = answer.get(4);
+ assertEquals(11, returnedRecord.getId1().intValue());
+ returnedRecord = answer.get(5);
+ assertEquals(1, returnedRecord.getId1().intValue());
} catch (SQLException e) {
fail(e.getMessage());
}
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/java5/SqlMapConfig.xml
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/java5/SqlMapConfig.xml?view=diff&rev=508716&r1=508715&r2=508716
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/java5/SqlMapConfig.xml (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/java5/SqlMapConfig.xml Fri Feb 16 22:14:18 2007
@@ -23,5 +23,6 @@
<sqlMap resource="abatortest/generated/flat/java5/xml/PKFIELDS_SqlMap.xml" />
<sqlMap resource="abatortest/generated/flat/java5/xml/PKFIELDSBLOBS_SqlMap.xml" />
<sqlMap resource="abatortest/generated/flat/java5/xml/PKONLY_SqlMap.xml" />
+ <sqlMap resource="abatortest/generated/flat/java5/xml/awful table_SqlMap.xml" />
</sqlMapConfig>
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/legacy/FlatLegacyTests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/legacy/FlatLegacyTests.java?view=diff&rev=508716&r1=508715&r2=508716
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/legacy/FlatLegacyTests.java (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/legacy/FlatLegacyTests.java Fri Feb 16 22:14:18 2007
@@ -22,6 +22,8 @@
import java.util.List;
import abatortest.BaseTest;
+import abatortest.generated.flat.legacy.dao.AwfulTableDAO;
+import abatortest.generated.flat.legacy.dao.AwfulTableDAOImpl;
import abatortest.generated.flat.legacy.dao.FieldsblobsDAO;
import abatortest.generated.flat.legacy.dao.FieldsblobsDAOImpl;
import abatortest.generated.flat.legacy.dao.FieldsonlyDAO;
@@ -34,6 +36,8 @@
import abatortest.generated.flat.legacy.dao.PkfieldsblobsDAOImpl;
import abatortest.generated.flat.legacy.dao.PkonlyDAO;
import abatortest.generated.flat.legacy.dao.PkonlyDAOImpl;
+import abatortest.generated.flat.legacy.model.AwfulTable;
+import abatortest.generated.flat.legacy.model.AwfulTableExample;
import abatortest.generated.flat.legacy.model.Fieldsblobs;
import abatortest.generated.flat.legacy.model.FieldsblobsExample;
import abatortest.generated.flat.legacy.model.Fieldsonly;
@@ -1253,6 +1257,679 @@
assertEquals(record.getLastname(), newRecord.getLastname());
assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
assertTrue(blobsAreEqual(record.getBlob2(), newRecord.getBlob2()));
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableInsert() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ 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.getFourthFirstName(), returnedRecord
+ .getFourthFirstName());
+ 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.getSecondCustomerId(), returnedRecord
+ .getSecondCustomerId());
+ assertEquals(record.getSecondFirstName(), returnedRecord
+ .getSecondFirstName());
+ assertEquals(record.getThirdFirstName(), returnedRecord
+ .getThirdFirstName());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableUpdateByPrimaryKey() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ Integer generatedCustomerId = dao.insert(record);
+
+ record.setId1(11);
+ record.setId2(22);
+
+ int rows = dao.updateByPrimaryKey(record);
+ assertEquals(1, rows);
+
+ 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.getFourthFirstName(), returnedRecord
+ .getFourthFirstName());
+ 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.getSecondCustomerId(), returnedRecord
+ .getSecondCustomerId());
+ assertEquals(record.getSecondFirstName(), returnedRecord
+ .getSecondFirstName());
+ assertEquals(record.getThirdFirstName(), returnedRecord
+ .getThirdFirstName());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableUpdateByPrimaryKeySelective() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ Integer generatedCustomerId = dao.insert(record);
+
+ AwfulTable newRecord = new AwfulTable();
+ newRecord.setCustomerId(generatedCustomerId);
+ newRecord.setId1(11);
+ newRecord.setId2(22);
+
+ int rows = dao.updateByPrimaryKeySelective(newRecord);
+ assertEquals(1, rows);
+
+ 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.getFourthFirstName(), returnedRecord
+ .getFourthFirstName());
+ assertEquals(record.getFrom(), returnedRecord.getFrom());
+ assertEquals(newRecord.getId1(), returnedRecord.getId1());
+ assertEquals(newRecord.getId2(), returnedRecord.getId2());
+ assertEquals(record.getId5(), returnedRecord.getId5());
+ assertEquals(record.getId6(), returnedRecord.getId6());
+ assertEquals(record.getId7(), returnedRecord.getId7());
+ assertEquals(record.getSecondCustomerId(), returnedRecord
+ .getSecondCustomerId());
+ assertEquals(record.getSecondFirstName(), returnedRecord
+ .getSecondFirstName());
+ assertEquals(record.getThirdFirstName(), returnedRecord
+ .getThirdFirstName());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableDeleteByPrimaryKey() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ Integer generatedCustomerId = dao.insert(record);
+
+ int rows = dao.deleteByPrimaryKey(generatedCustomerId);
+ assertEquals(1, rows);
+
+ AwfulTableExample example = new AwfulTableExample();
+ List answer = dao.selectByExample(example);
+ assertEquals(0, answer.size());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableDeleteByExample() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("fred44");
+ record.setFrom("from from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ 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.seteMail("fred@%");
+ example.seteMail_Indicator(AwfulTableExample.EXAMPLE_LIKE);
+ int rows = dao.deleteByExample(example);
+ assertEquals(1, rows);
+
+ example = new AwfulTableExample();
+ answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableSelectByPrimaryKey() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("fred44");
+ record.setFrom("from from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ 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.getFourthFirstName(), returnedRecord
+ .getFourthFirstName());
+ 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.getSecondCustomerId(), returnedRecord
+ .getSecondCustomerId());
+ assertEquals(record.getSecondFirstName(), returnedRecord
+ .getSecondFirstName());
+ assertEquals(record.getThirdFirstName(), returnedRecord
+ .getThirdFirstName());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableSelectByExampleLike() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("wilma4");
+ record.setFrom("from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("pebbles4");
+ record.setFrom("from field");
+ record.setId1(111);
+ record.setId2(222);
+ record.setId5(555);
+ record.setId6(666);
+ record.setId7(777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("barney4");
+ record.setFrom("from field");
+ record.setId1(1111);
+ record.setId2(2222);
+ record.setId5(5555);
+ record.setId6(6666);
+ record.setId7(7777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("betty4");
+ record.setFrom("from field");
+ record.setId1(11111);
+ record.setId2(22222);
+ record.setId5(55555);
+ record.setId6(66666);
+ record.setId7(77777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("bammbamm4");
+ record.setFrom("from field");
+ record.setId1(111111);
+ record.setId2(222222);
+ record.setId5(555555);
+ record.setId6(666666);
+ record.setId7(777777);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("bammbamm2");
+ record.setThirdFirstName("bammbamm3");
+ dao.insert(record);
+
+ AwfulTableExample example = new AwfulTableExample();
+ example.setFirstFirstName("b%");
+ example.setFirstFirstName_Indicator(AwfulTableExample.EXAMPLE_LIKE);
+ List answer = dao.selectByExample(example, "\"A_CuStOmEr iD\"");
+ 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 (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableSelectByExampleComplexLike() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("wilma4");
+ record.setFrom("from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("pebbles4");
+ record.setFrom("from field");
+ record.setId1(111);
+ record.setId2(222);
+ record.setId5(555);
+ record.setId6(666);
+ record.setId7(777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("barney4");
+ record.setFrom("from field");
+ record.setId1(1111);
+ record.setId2(2222);
+ record.setId5(5555);
+ record.setId6(6666);
+ record.setId7(7777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("betty4");
+ record.setFrom("from field");
+ record.setId1(11111);
+ record.setId2(22222);
+ record.setId5(55555);
+ record.setId6(66666);
+ record.setId7(77777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("bammbamm4");
+ record.setFrom("from field");
+ record.setId1(111111);
+ record.setId2(222222);
+ record.setId5(555555);
+ record.setId6(666666);
+ record.setId7(777777);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("bammbamm2");
+ record.setThirdFirstName("bammbamm3");
+ dao.insert(record);
+
+ AwfulTableExample example = new AwfulTableExample();
+ example.setFirstFirstName("wi%");
+ example.setFirstFirstName_Indicator(AwfulTableExample.EXAMPLE_LIKE);
+ example.setId2(222222);
+ example.setId2_Indicator(AwfulTableExample.EXAMPLE_EQUALS);
+ example.setCombineTypeOr(true);
+ List answer = dao.selectByExample(example, "\"A_CuStOmEr iD\"");
+ assertEquals(2, answer.size());
+ AwfulTable returnedRecord = (AwfulTable) answer.get(0);
+ assertEquals(11, returnedRecord.getId1().intValue());
+ assertEquals(22, returnedRecord.getId2().intValue());
+ returnedRecord = (AwfulTable) answer.get(1);
+ assertEquals(111111, returnedRecord.getId1().intValue());
+ assertEquals(222222, returnedRecord.getId2().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableSelectByExampleNoCriteria() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ 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.setFourthFirstName("wilma4");
+ record.setFrom("from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("pebbles4");
+ record.setFrom("from field");
+ record.setId1(111);
+ record.setId2(222);
+ record.setId5(555);
+ record.setId6(666);
+ record.setId7(777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("barney4");
+ record.setFrom("from field");
+ record.setId1(1111);
+ record.setId2(2222);
+ record.setId5(5555);
+ record.setId6(6666);
+ record.setId7(7777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("betty4");
+ record.setFrom("from field");
+ record.setId1(11111);
+ record.setId2(22222);
+ record.setId5(55555);
+ record.setId6(66666);
+ record.setId7(77777);
+ record.setSecondCustomerId(567567);
+ 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.setFourthFirstName("bammbamm4");
+ record.setFrom("from field");
+ record.setId1(111111);
+ record.setId2(222222);
+ record.setId5(555555);
+ record.setId6(666666);
+ record.setId7(777777);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("bammbamm2");
+ record.setThirdFirstName("bammbamm3");
+ dao.insert(record);
+
+ AwfulTableExample example = new AwfulTableExample();
+ List answer = dao.selectByExample(example, "\"A_CuStOmEr iD\" desc");
+ assertEquals(6, answer.size());
+ AwfulTable returnedRecord = (AwfulTable) answer.get(0);
+ assertEquals(111111, returnedRecord.getId1().intValue());
+ returnedRecord = (AwfulTable) answer.get(1);
+ assertEquals(11111, returnedRecord.getId1().intValue());
+ returnedRecord = (AwfulTable) answer.get(2);
+ assertEquals(1111, returnedRecord.getId1().intValue());
+ returnedRecord = (AwfulTable) answer.get(3);
+ assertEquals(111, returnedRecord.getId1().intValue());
+ returnedRecord = (AwfulTable) answer.get(4);
+ assertEquals(11, returnedRecord.getId1().intValue());
+ returnedRecord = (AwfulTable) answer.get(5);
+ assertEquals(1, returnedRecord.getId1().intValue());
} catch (SQLException e) {
fail(e.getMessage());
}
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/legacy/SqlMapConfig.xml
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/legacy/SqlMapConfig.xml?view=diff&rev=508716&r1=508715&r2=508716
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/legacy/SqlMapConfig.xml (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/legacy/SqlMapConfig.xml Fri Feb 16 22:14:18 2007
@@ -23,5 +23,6 @@
<sqlMap resource="abatortest/generated/flat/legacy/xml/PKFIELDS_SqlMap.xml" />
<sqlMap resource="abatortest/generated/flat/legacy/xml/PKFIELDSBLOBS_SqlMap.xml" />
<sqlMap resource="abatortest/generated/flat/legacy/xml/PKONLY_SqlMap.xml" />
+ <sqlMap resource="abatortest/generated/flat/legacy/xml/awful table_SqlMap.xml" />
</sqlMapConfig>