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 [4/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/testJava2/abatortest/java2/execute/hierarchical/java2/HierarchicalJava2Tests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/java2/HierarchicalJava2Tests.java?view=diff&rev=508716&r1=508715&r2=508716
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/java2/HierarchicalJava2Tests.java (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/java2/HierarchicalJava2Tests.java Fri Feb 16 22:14:18 2007
@@ -23,6 +23,8 @@
import java.util.List;
import abatortest.java2.BaseTest;
+import abatortest.java2.generated.hierarchical.java2.dao.AwfulTableDAO;
+import abatortest.java2.generated.hierarchical.java2.dao.AwfulTableDAOImpl;
import abatortest.java2.generated.hierarchical.java2.dao.FieldsblobsDAO;
import abatortest.java2.generated.hierarchical.java2.dao.FieldsblobsDAOImpl;
import abatortest.java2.generated.hierarchical.java2.dao.FieldsonlyDAO;
@@ -35,6 +37,9 @@
import abatortest.java2.generated.hierarchical.java2.dao.PkfieldsblobsDAOImpl;
import abatortest.java2.generated.hierarchical.java2.dao.PkonlyDAO;
import abatortest.java2.generated.hierarchical.java2.dao.PkonlyDAOImpl;
+import abatortest.java2.generated.hierarchical.java2.model.AwfulTable;
+import abatortest.java2.generated.hierarchical.java2.model.AwfulTableExample;
+import abatortest.java2.generated.hierarchical.java2.model.AwfulTableKey;
import abatortest.java2.generated.hierarchical.java2.model.Fieldsblobs;
import abatortest.java2.generated.hierarchical.java2.model.FieldsblobsExample;
import abatortest.java2.generated.hierarchical.java2.model.FieldsblobsWithBLOBs;
@@ -1782,6 +1787,1037 @@
example.createCriteria();
List 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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(567));
+ record.setSecondFirstName("fred2");
+ 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
+ .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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(567));
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ Integer generatedCustomerId = dao.insert(record);
+
+ record.setId1(new Integer(11));
+ 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
+ .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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(567));
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ Integer generatedCustomerId = dao.insert(record);
+
+ AwfulTable newRecord = new AwfulTable();
+ newRecord.setCustomerId(generatedCustomerId);
+ newRecord.setId1(new Integer(11));
+ newRecord.setId2(new Integer(22));
+
+ int rows = dao.updateByPrimaryKeySelective(newRecord);
+ 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
+ .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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(567));
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ Integer generatedCustomerId = dao.insert(record);
+
+ AwfulTableKey key = new AwfulTableKey();
+ key.setCustomerId(generatedCustomerId);
+ int rows = dao.deleteByPrimaryKey(key);
+ 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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(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.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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(567567));
+ record.setSecondFirstName("fred22");
+ record.setThirdFirstName("fred33");
+
+ Integer generatedKey = dao.insert(record);
+
+ AwfulTableKey key = new AwfulTableKey();
+ key.setCustomerId(generatedKey);
+ AwfulTable returnedRecord = dao.selectByPrimaryKey(key);
+
+ 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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(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(new Integer(111));
+ record.setId2(new Integer(222));
+ record.setId5(new Integer(555));
+ record.setId6(new Integer(666));
+ record.setId7(new Integer(777));
+ record.setSecondCustomerId(new Integer(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(new Integer(1111));
+ record.setId2(new Integer(2222));
+ record.setId5(new Integer(5555));
+ record.setId6(new Integer(6666));
+ record.setId7(new Integer(7777));
+ record.setSecondCustomerId(new Integer(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(new Integer(11111));
+ record.setId2(new Integer(22222));
+ record.setId5(new Integer(55555));
+ record.setId6(new Integer(66666));
+ record.setId7(new Integer(77777));
+ record.setSecondCustomerId(new Integer(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(new Integer(111111));
+ record.setId2(new Integer(222222));
+ record.setId5(new Integer(555555));
+ record.setId6(new Integer(666666));
+ record.setId7(new Integer(777777));
+ record.setSecondCustomerId(new Integer(567567));
+ 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 (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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(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(new Integer(111));
+ record.setId2(new Integer(222));
+ record.setId5(new Integer(555));
+ record.setId6(new Integer(666));
+ record.setId7(new Integer(777));
+ record.setSecondCustomerId(new Integer(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(new Integer(1111));
+ record.setId2(new Integer(2222));
+ record.setId5(new Integer(5555));
+ record.setId6(new Integer(6666));
+ record.setId7(new Integer(7777));
+ record.setSecondCustomerId(new Integer(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(new Integer(11111));
+ record.setId2(new Integer(22222));
+ record.setId5(new Integer(55555));
+ record.setId6(new Integer(66666));
+ record.setId7(new Integer(77777));
+ record.setSecondCustomerId(new Integer(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(new Integer(111111));
+ record.setId2(new Integer(222222));
+ record.setId5(new Integer(555555));
+ record.setId6(new Integer(666666));
+ record.setId7(new Integer(777777));
+ record.setSecondCustomerId(new Integer(567567));
+ record.setSecondFirstName("bammbamm2");
+ record.setThirdFirstName("bammbamm3");
+ dao.insert(record);
+
+ AwfulTableExample example = new AwfulTableExample();
+ example.createCriteria().andFirstFirstNameNotLike("b%");
+ example.setOrderByClause("\"A_CuStOmEr iD\"");
+ List answer = dao.selectByExample(example);
+ assertEquals(3, answer.size());
+ AwfulTable returnedRecord = (AwfulTable) answer.get(0);
+ assertEquals(1, returnedRecord.getId1().intValue());
+ assertEquals(2, returnedRecord.getId2().intValue());
+ returnedRecord = (AwfulTable) answer.get(1);
+ assertEquals(11, returnedRecord.getId1().intValue());
+ assertEquals(22, returnedRecord.getId2().intValue());
+ returnedRecord = (AwfulTable) 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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(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(new Integer(111));
+ record.setId2(new Integer(222));
+ record.setId5(new Integer(555));
+ record.setId6(new Integer(666));
+ record.setId7(new Integer(777));
+ record.setSecondCustomerId(new Integer(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(new Integer(1111));
+ record.setId2(new Integer(2222));
+ record.setId5(new Integer(5555));
+ record.setId6(new Integer(6666));
+ record.setId7(new Integer(7777));
+ record.setSecondCustomerId(new Integer(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(new Integer(11111));
+ record.setId2(new Integer(22222));
+ record.setId5(new Integer(55555));
+ record.setId6(new Integer(66666));
+ record.setId7(new Integer(77777));
+ record.setSecondCustomerId(new Integer(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(new Integer(111111));
+ record.setId2(new Integer(222222));
+ record.setId5(new Integer(555555));
+ record.setId6(new Integer(666666));
+ record.setId7(new Integer(777777));
+ record.setSecondCustomerId(new Integer(567567));
+ record.setSecondFirstName("bammbamm2");
+ record.setThirdFirstName("bammbamm3");
+ dao.insert(record);
+
+ AwfulTableExample example = new AwfulTableExample();
+ example.createCriteria().andFirstFirstNameLike("b%").andId2EqualTo(new Integer(222222));
+ example.or(example.createCriteria().andFirstFirstNameLike("wi%"));
+ example.setOrderByClause("\"A_CuStOmEr iD\"");
+ List answer = dao.selectByExample(example);
+ 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 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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(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(new Integer(111));
+ record.setId2(new Integer(222));
+ record.setId5(new Integer(555));
+ record.setId6(new Integer(666));
+ record.setId7(new Integer(777));
+ record.setSecondCustomerId(new Integer(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(new Integer(1111));
+ record.setId2(new Integer(2222));
+ record.setId5(new Integer(5555));
+ record.setId6(new Integer(6666));
+ record.setId7(new Integer(7777));
+ record.setSecondCustomerId(new Integer(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(new Integer(11111));
+ record.setId2(new Integer(22222));
+ record.setId5(new Integer(55555));
+ record.setId6(new Integer(66666));
+ record.setId7(new Integer(77777));
+ record.setSecondCustomerId(new Integer(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(new Integer(111111));
+ record.setId2(new Integer(222222));
+ record.setId5(new Integer(555555));
+ record.setId6(new Integer(666666));
+ record.setId7(new Integer(777777));
+ record.setSecondCustomerId(new Integer(567567));
+ record.setSecondFirstName("bammbamm2");
+ record.setThirdFirstName("bammbamm3");
+ dao.insert(record);
+
+ 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());
+ assertEquals(2, returnedRecord.getId2().intValue());
+ returnedRecord = (AwfulTable) 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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(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(new Integer(111));
+ record.setId2(new Integer(222));
+ record.setId5(new Integer(555));
+ record.setId6(new Integer(666));
+ record.setId7(new Integer(777));
+ record.setSecondCustomerId(new Integer(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(new Integer(1111));
+ record.setId2(new Integer(2222));
+ record.setId5(new Integer(5555));
+ record.setId6(new Integer(6666));
+ record.setId7(new Integer(7777));
+ record.setSecondCustomerId(new Integer(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(new Integer(11111));
+ record.setId2(new Integer(22222));
+ record.setId5(new Integer(55555));
+ record.setId6(new Integer(66666));
+ record.setId7(new Integer(77777));
+ record.setSecondCustomerId(new Integer(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(new Integer(111111));
+ record.setId2(new Integer(222222));
+ record.setId5(new Integer(555555));
+ record.setId6(new Integer(666666));
+ record.setId7(new Integer(777777));
+ record.setSecondCustomerId(new Integer(567567));
+ 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());
+ }
+ }
+
+ 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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(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(new Integer(111));
+ record.setId2(new Integer(222));
+ record.setId5(new Integer(555));
+ record.setId6(new Integer(666));
+ record.setId7(new Integer(777));
+ record.setSecondCustomerId(new Integer(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(new Integer(1111));
+ record.setId2(new Integer(2222));
+ record.setId5(new Integer(5555));
+ record.setId6(new Integer(6666));
+ record.setId7(new Integer(7777));
+ record.setSecondCustomerId(new Integer(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(new Integer(11111));
+ record.setId2(new Integer(22222));
+ record.setId5(new Integer(55555));
+ record.setId6(new Integer(66666));
+ record.setId7(new Integer(77777));
+ record.setSecondCustomerId(new Integer(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(new Integer(111111));
+ record.setId2(new Integer(222222));
+ record.setId5(new Integer(555555));
+ record.setId6(new Integer(666666));
+ record.setId7(new Integer(777777));
+ record.setSecondCustomerId(new Integer(567567));
+ 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());
+ 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/testJava2/abatortest/java2/execute/hierarchical/java2/SqlMapConfig.xml
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/java2/SqlMapConfig.xml?view=diff&rev=508716&r1=508715&r2=508716
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/java2/SqlMapConfig.xml (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/java2/SqlMapConfig.xml Fri Feb 16 22:14:18 2007
@@ -23,5 +23,6 @@
<sqlMap resource="abatortest/java2/generated/hierarchical/java2/xml/PKFIELDS_SqlMap.xml" />
<sqlMap resource="abatortest/java2/generated/hierarchical/java2/xml/PKFIELDSBLOBS_SqlMap.xml" />
<sqlMap resource="abatortest/java2/generated/hierarchical/java2/xml/PKONLY_SqlMap.xml" />
+ <sqlMap resource="abatortest/java2/generated/hierarchical/java2/xml/awful table_SqlMap.xml" />
</sqlMapConfig>
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/legacy/HierarchicalLegacyTests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/legacy/HierarchicalLegacyTests.java?view=diff&rev=508716&r1=508715&r2=508716
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/legacy/HierarchicalLegacyTests.java (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/legacy/HierarchicalLegacyTests.java Fri Feb 16 22:14:18 2007
@@ -22,6 +22,8 @@
import java.util.List;
import abatortest.java2.BaseTest;
+import abatortest.java2.generated.hierarchical.legacy.dao.AwfulTableDAO;
+import abatortest.java2.generated.hierarchical.legacy.dao.AwfulTableDAOImpl;
import abatortest.java2.generated.hierarchical.legacy.dao.FieldsblobsDAO;
import abatortest.java2.generated.hierarchical.legacy.dao.FieldsblobsDAOImpl;
import abatortest.java2.generated.hierarchical.legacy.dao.FieldsonlyDAO;
@@ -34,6 +36,9 @@
import abatortest.java2.generated.hierarchical.legacy.dao.PkfieldsblobsDAOImpl;
import abatortest.java2.generated.hierarchical.legacy.dao.PkonlyDAO;
import abatortest.java2.generated.hierarchical.legacy.dao.PkonlyDAOImpl;
+import abatortest.java2.generated.hierarchical.legacy.model.AwfulTable;
+import abatortest.java2.generated.hierarchical.legacy.model.AwfulTableExample;
+import abatortest.java2.generated.hierarchical.legacy.model.AwfulTableKey;
import abatortest.java2.generated.hierarchical.legacy.model.Fieldsblobs;
import abatortest.java2.generated.hierarchical.legacy.model.FieldsblobsExample;
import abatortest.java2.generated.hierarchical.legacy.model.FieldsblobsWithBLOBs;
@@ -1308,6 +1313,689 @@
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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(567));
+ record.setSecondFirstName("fred2");
+ 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
+ .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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(567));
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ Integer generatedCustomerId = dao.insert(record);
+
+ record.setId1(new Integer(11));
+ 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
+ .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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(567));
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ Integer generatedCustomerId = dao.insert(record);
+
+ AwfulTable newRecord = new AwfulTable();
+ newRecord.setCustomerId(generatedCustomerId);
+ newRecord.setId1(new Integer(11));
+ newRecord.setId2(new Integer(22));
+
+ int rows = dao.updateByPrimaryKeySelective(newRecord);
+ 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
+ .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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(567));
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ Integer generatedCustomerId = dao.insert(record);
+
+ AwfulTableKey key = new AwfulTableKey();
+ key.setCustomerId(generatedCustomerId);
+ int rows = dao.deleteByPrimaryKey(key);
+ 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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(567567));
+ record.setSecondFirstName("fred22");
+ record.setThirdFirstName("fred33");
+
+ Integer generatedKey = dao.insert(record);
+
+ AwfulTableKey key = new AwfulTableKey();
+ key.setCustomerId(generatedKey);
+ AwfulTable returnedRecord = dao.selectByPrimaryKey(key);
+
+ 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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(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(new Integer(111));
+ record.setId2(new Integer(222));
+ record.setId5(new Integer(555));
+ record.setId6(new Integer(666));
+ record.setId7(new Integer(777));
+ record.setSecondCustomerId(new Integer(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(new Integer(1111));
+ record.setId2(new Integer(2222));
+ record.setId5(new Integer(5555));
+ record.setId6(new Integer(6666));
+ record.setId7(new Integer(7777));
+ record.setSecondCustomerId(new Integer(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(new Integer(11111));
+ record.setId2(new Integer(22222));
+ record.setId5(new Integer(55555));
+ record.setId6(new Integer(66666));
+ record.setId7(new Integer(77777));
+ record.setSecondCustomerId(new Integer(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(new Integer(111111));
+ record.setId2(new Integer(222222));
+ record.setId5(new Integer(555555));
+ record.setId6(new Integer(666666));
+ record.setId7(new Integer(777777));
+ record.setSecondCustomerId(new Integer(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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(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(new Integer(111));
+ record.setId2(new Integer(222));
+ record.setId5(new Integer(555));
+ record.setId6(new Integer(666));
+ record.setId7(new Integer(777));
+ record.setSecondCustomerId(new Integer(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(new Integer(1111));
+ record.setId2(new Integer(2222));
+ record.setId5(new Integer(5555));
+ record.setId6(new Integer(6666));
+ record.setId7(new Integer(7777));
+ record.setSecondCustomerId(new Integer(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(new Integer(11111));
+ record.setId2(new Integer(22222));
+ record.setId5(new Integer(55555));
+ record.setId6(new Integer(66666));
+ record.setId7(new Integer(77777));
+ record.setSecondCustomerId(new Integer(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(new Integer(111111));
+ record.setId2(new Integer(222222));
+ record.setId5(new Integer(555555));
+ record.setId6(new Integer(666666));
+ record.setId7(new Integer(777777));
+ record.setSecondCustomerId(new Integer(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(new Integer(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(new Integer(1));
+ record.setId2(new Integer(2));
+ record.setId5(new Integer(5));
+ record.setId6(new Integer(6));
+ record.setId7(new Integer(7));
+ record.setSecondCustomerId(new Integer(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(new Integer(11));
+ record.setId2(new Integer(22));
+ record.setId5(new Integer(55));
+ record.setId6(new Integer(66));
+ record.setId7(new Integer(77));
+ record.setSecondCustomerId(new Integer(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(new Integer(111));
+ record.setId2(new Integer(222));
+ record.setId5(new Integer(555));
+ record.setId6(new Integer(666));
+ record.setId7(new Integer(777));
+ record.setSecondCustomerId(new Integer(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(new Integer(1111));
+ record.setId2(new Integer(2222));
+ record.setId5(new Integer(5555));
+ record.setId6(new Integer(6666));
+ record.setId7(new Integer(7777));
+ record.setSecondCustomerId(new Integer(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(new Integer(11111));
+ record.setId2(new Integer(22222));
+ record.setId5(new Integer(55555));
+ record.setId6(new Integer(66666));
+ record.setId7(new Integer(77777));
+ record.setSecondCustomerId(new Integer(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(new Integer(111111));
+ record.setId2(new Integer(222222));
+ record.setId5(new Integer(555555));
+ record.setId6(new Integer(666666));
+ record.setId7(new Integer(777777));
+ record.setSecondCustomerId(new Integer(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/testJava2/abatortest/java2/execute/hierarchical/legacy/SqlMapConfig.xml
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/legacy/SqlMapConfig.xml?view=diff&rev=508716&r1=508715&r2=508716
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/legacy/SqlMapConfig.xml (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/hierarchical/legacy/SqlMapConfig.xml Fri Feb 16 22:14:18 2007
@@ -23,5 +23,6 @@
<sqlMap resource="abatortest/java2/generated/hierarchical/legacy/xml/PKFIELDS_SqlMap.xml" />
<sqlMap resource="abatortest/java2/generated/hierarchical/legacy/xml/PKFIELDSBLOBS_SqlMap.xml" />
<sqlMap resource="abatortest/java2/generated/hierarchical/legacy/xml/PKONLY_SqlMap.xml" />
+ <sqlMap resource="abatortest/java2/generated/hierarchical/legacy/xml/awful table_SqlMap.xml" />
</sqlMapConfig>
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/CreateDB.sql
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/CreateDB.sql?view=diff&rev=508716&r1=508715&r2=508716
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/CreateDB.sql (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/CreateDB.sql Fri Feb 16 22:14:18 2007
@@ -4,6 +4,7 @@
drop table PKBlobs if exists;
drop table PKFieldsBlobs if exists;
drop table FieldsBlobs if exists;
+drop table "awful table" if exists;
drop table BlobsOnly if exists;
create table FieldsOnly (
@@ -55,6 +56,25 @@
lastName varchar(20),
blob1 longvarbinary,
blob2 longvarbinary
+);
+
+create table "awful table" (
+ "CuStOmEr iD" int generated by default as identity (start with 57) not null,
+ "customer id" int,
+ "first name" varchar(20),
+ "First Name" varchar(20),
+ "first Name" varchar(20),
+ first_name varchar(20),
+ firstName varchar(20),
+ E_MAIL varchar(20),
+ _id1 int not null,
+ $id2 int not null,
+ id5_ int not null,
+ id6$ int not null,
+ id7$$ int not null,
+ EmailAddress varchar(30),
+ "from" varchar(30),
+ primary key("CuStOmEr iD")
);
-- this table should be ignored, nothing generated