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/08/28 06:06:03 UTC
svn commit: r570300 [2/2] - in
/ibatis/trunk/java/mapper/mapper2/tools/abator/core: build/
src/org/apache/ibatis/abator/ant/ src/org/apache/ibatis/abator/api/
src/org/apache/ibatis/abator/config/
src/org/apache/ibatis/abator/config/xml/ src/org/apache/...
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/conditional/legacy/ConditionalLegacyTests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/conditional/legacy/ConditionalLegacyTests.java?rev=570300&r1=570299&r2=570300&view=diff
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/conditional/legacy/ConditionalLegacyTests.java (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/conditional/legacy/ConditionalLegacyTests.java Mon Aug 27 21:06:02 2007
@@ -170,6 +170,44 @@
}
}
+ public void testFieldsOnlyCountByExample() {
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(11.22);
+ record.setFloatfield(33.44);
+ record.setIntegerfield(5);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(44.55);
+ record.setFloatfield(66.77);
+ record.setIntegerfield(8);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(88.99);
+ record.setFloatfield(100.111);
+ record.setIntegerfield(9);
+ dao.insert(record);
+
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.setIntegerfield(5);
+ example
+ .setIntegerfield_Indicator(FieldsonlyExample.EXAMPLE_GREATER_THAN);
+
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example = new FieldsonlyExample();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKOnlyInsert() {
PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
@@ -284,6 +322,39 @@
}
}
+ public void testPKOnlyCountByExample() {
+ PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
+
+ try {
+ PkonlyKey key = new PkonlyKey();
+ key.setId(1);
+ key.setSeqNum(3);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(5);
+ key.setSeqNum(6);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(7);
+ key.setSeqNum(8);
+ dao.insert(key);
+
+ PkonlyExample example = new PkonlyExample();
+ example.setId(4);
+ example.setId_Indicator(PkonlyExample.EXAMPLE_GREATER_THAN);
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example = new PkonlyExample();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsInsert() {
PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
@@ -618,6 +689,38 @@
}
}
+ public void testPKFieldsCountByExample() {
+ PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfields record = new Pkfields();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Bob");
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+ dao.insert(record);
+
+ PkfieldsExample example = new PkfieldsExample();
+ example.setLastname("J%");
+ example.setLastname_Indicator(PkfieldsExample.EXAMPLE_LIKE);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new PkfieldsExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKBlobsInsert() {
PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
@@ -847,6 +950,36 @@
}
}
+ public void testPKBlobsCountByExample() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ Pkblobs record = new Pkblobs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new Pkblobs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsExample example = new PkblobsExample();
+ example.setId(4);
+ example.setId_Indicator(PkblobsExample.EXAMPLE_LESS_THAN);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new PkblobsExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsBlobsInsert() {
PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
@@ -1171,6 +1304,40 @@
}
}
+ public void testPKFieldsBlobsCountByExample() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfieldsblobs record = new Pkfieldsblobs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new Pkfieldsblobs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.setId1(3);
+ example.setId1_Indicator(PkfieldsblobsExample.EXAMPLE_NOT_EQUALS);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new PkfieldsblobsExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testFieldsBlobsInsert() {
FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient);
@@ -1303,6 +1470,38 @@
}
}
+ public void testFieldsBlobsCountByExample() {
+ FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ FieldsblobsWithBLOBs record = new FieldsblobsWithBLOBs();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new FieldsblobsWithBLOBs();
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ FieldsblobsExample example = new FieldsblobsExample();
+ example.setFirstname("S%");
+ example.setFirstname_Indicator(FieldsblobsExample.EXAMPLE_LIKE);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new FieldsblobsExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testAwfulTableInsert() {
AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
@@ -1972,6 +2171,58 @@
assertEquals(11, returnedRecord.getId1().intValue());
returnedRecord = (AwfulTable) answer.get(5);
assertEquals(1, returnedRecord.getId1().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableCountByExample() {
+ 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();
+ example.seteMail("fred@%");
+ example.seteMail_Indicator(AwfulTableExample.EXAMPLE_LIKE);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new AwfulTableExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
} catch (SQLException e) {
fail(e.getMessage());
}
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/java2/FlatJava2Tests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/java2/FlatJava2Tests.java?rev=570300&r1=570299&r2=570300&view=diff
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/java2/FlatJava2Tests.java (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/flat/java2/FlatJava2Tests.java Mon Aug 27 21:06:02 2007
@@ -194,6 +194,42 @@
}
}
+ public void testFieldsOnlyCountByExample() {
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(11.22);
+ record.setFloatfield(33.44);
+ record.setIntegerfield(5);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(44.55);
+ record.setFloatfield(66.77);
+ record.setIntegerfield(8);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(88.99);
+ record.setFloatfield(100.111);
+ record.setIntegerfield(9);
+ dao.insert(record);
+
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.createCriteria().andIntegerfieldGreaterThan(5);
+
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKOnlyInsert() {
PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
@@ -331,6 +367,38 @@
}
}
+ public void testPKOnlyCountByExample() {
+ PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
+
+ try {
+ Pkonly key = new Pkonly();
+ key.setId(1);
+ key.setSeqNum(3);
+ dao.insert(key);
+
+ key = new Pkonly();
+ key.setId(5);
+ key.setSeqNum(6);
+ dao.insert(key);
+
+ key = new Pkonly();
+ key.setId(7);
+ key.setSeqNum(8);
+ dao.insert(key);
+
+ PkonlyExample example = new PkonlyExample();
+ example.createCriteria().andIdGreaterThan(4);
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsInsert() {
PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
@@ -991,6 +1059,38 @@
}
}
+ public void testPKFieldsCountByExample() {
+ PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfields record = new Pkfields();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Bob");
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+
+ dao.insert(record);
+
+ PkfieldsExample example = new PkfieldsExample();
+ example.createCriteria().andLastnameLike("J%");
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKBlobsInsert() {
PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
@@ -1243,6 +1343,35 @@
}
}
+ public void testPKBlobsCountByExample() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ Pkblobs record = new Pkblobs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new Pkblobs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsExample example = new PkblobsExample();
+ example.createCriteria().andIdLessThan(4);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsBlobsInsert() {
PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
@@ -1578,6 +1707,39 @@
}
}
+ public void testPKFieldsBlobsCountByExample() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfieldsblobs record = new Pkfieldsblobs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new Pkfieldsblobs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.createCriteria().andId1NotEqualTo(3);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testFieldsBlobsInsert() {
FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient);
@@ -1733,6 +1895,33 @@
}
}
+ public void testFieldsBlobsCountByExample() {
+ FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsblobs record = new Fieldsblobs();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new Fieldsblobs();
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ FieldsblobsExample example = new FieldsblobsExample();
+ example.createCriteria().andFirstnameLike("S%");
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testAwfulTableInsert() {
AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
@@ -2750,6 +2939,57 @@
assertEquals(11, returnedRecord.getId1().intValue());
returnedRecord = (AwfulTable) answer.get(5);
assertEquals(1, returnedRecord.getId1().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableCountByExample() {
+ 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();
+ example.createCriteria().andEMailLike("fred@%");
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
} catch (SQLException e) {
fail(e.getMessage());
}
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?rev=570300&r1=570299&r2=570300&view=diff
==============================================================================
--- 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 Mon Aug 27 21:06:02 2007
@@ -194,6 +194,41 @@
}
}
+ public void testFieldsOnlyCountByExample() {
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(11.22);
+ record.setFloatfield(33.44);
+ record.setIntegerfield(5);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(44.55);
+ record.setFloatfield(66.77);
+ record.setIntegerfield(8);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(88.99);
+ record.setFloatfield(100.111);
+ record.setIntegerfield(9);
+ dao.insert(record);
+
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.createCriteria().andIntegerfieldGreaterThan(5);
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKOnlyInsert() {
PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
@@ -331,6 +366,38 @@
}
}
+ public void testPKOnlyCountByExample() {
+ PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
+
+ try {
+ Pkonly key = new Pkonly();
+ key.setId(1);
+ key.setSeqNum(3);
+ dao.insert(key);
+
+ key = new Pkonly();
+ key.setId(5);
+ key.setSeqNum(6);
+ dao.insert(key);
+
+ key = new Pkonly();
+ key.setId(7);
+ key.setSeqNum(8);
+ dao.insert(key);
+
+ PkonlyExample example = new PkonlyExample();
+ example.createCriteria().andIdGreaterThan(4);
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsInsert() {
PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
@@ -991,6 +1058,37 @@
}
}
+ public void testPKFieldsCountByExample() {
+ PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfields record = new Pkfields();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Bob");
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+ dao.insert(record);
+
+ PkfieldsExample example = new PkfieldsExample();
+ example.createCriteria().andLastnameLike("J%");
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKBlobsInsert() {
PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
@@ -1243,6 +1341,35 @@
}
}
+ public void testPKBlobsCountByExample() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ Pkblobs record = new Pkblobs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new Pkblobs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsExample example = new PkblobsExample();
+ example.createCriteria().andIdLessThan(4);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsBlobsInsert() {
PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
@@ -1737,6 +1864,39 @@
}
}
+ public void testPKFieldsBlobsCountByExample() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfieldsblobs record = new Pkfieldsblobs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new Pkfieldsblobs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.createCriteria().andId1NotEqualTo(3);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testAwfulTableInsert() {
AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
@@ -2754,6 +2914,57 @@
assertEquals(11, returnedRecord.getId1().intValue());
returnedRecord = answer.get(5);
assertEquals(1, returnedRecord.getId1().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableCountByExample() {
+ 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();
+ example.createCriteria().andEMailLike("fred@%");
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
} catch (SQLException e) {
fail(e.getMessage());
}
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?rev=570300&r1=570299&r2=570300&view=diff
==============================================================================
--- 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 Mon Aug 27 21:06:02 2007
@@ -167,6 +167,44 @@
}
}
+ public void testFieldsOnlyCountByExample() {
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(11.22);
+ record.setFloatfield(33.44);
+ record.setIntegerfield(5);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(44.55);
+ record.setFloatfield(66.77);
+ record.setIntegerfield(8);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(88.99);
+ record.setFloatfield(100.111);
+ record.setIntegerfield(9);
+ dao.insert(record);
+
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.setIntegerfield(5);
+ example
+ .setIntegerfield_Indicator(FieldsonlyExample.EXAMPLE_GREATER_THAN);
+
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example = new FieldsonlyExample();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKOnlyInsert() {
PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
@@ -278,6 +316,39 @@
}
}
+ public void testPKOnlyCountByExample() {
+ PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
+
+ try {
+ Pkonly key = new Pkonly();
+ key.setId(1);
+ key.setSeqNum(3);
+ dao.insert(key);
+
+ key = new Pkonly();
+ key.setId(5);
+ key.setSeqNum(6);
+ dao.insert(key);
+
+ key = new Pkonly();
+ key.setId(7);
+ key.setSeqNum(8);
+ dao.insert(key);
+
+ PkonlyExample example = new PkonlyExample();
+ example.setId(4);
+ example.setId_Indicator(PkonlyExample.EXAMPLE_GREATER_THAN);
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example = new PkonlyExample();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsInsert() {
PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
@@ -593,6 +664,38 @@
}
}
+ public void testPKFieldsCountByExample() {
+ PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfields record = new Pkfields();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Bob");
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+ dao.insert(record);
+
+ PkfieldsExample example = new PkfieldsExample();
+ example.setLastname("J%");
+ example.setLastname_Indicator(PkfieldsExample.EXAMPLE_LIKE);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new PkfieldsExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKBlobsInsert() {
PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
@@ -822,6 +925,36 @@
}
}
+ public void testPKBlobsCountByExample() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ Pkblobs record = new Pkblobs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new Pkblobs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsExample example = new PkblobsExample();
+ example.setId(4);
+ example.setId_Indicator(PkblobsExample.EXAMPLE_LESS_THAN);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new PkblobsExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsBlobsInsert() {
PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
@@ -1131,6 +1264,40 @@
}
}
+ public void testPKFieldsBlobsCountByExample() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfieldsblobs record = new Pkfieldsblobs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new Pkfieldsblobs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.setId1(3);
+ example.setId1_Indicator(PkfieldsblobsExample.EXAMPLE_NOT_EQUALS);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new PkfieldsblobsExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testFieldsBlobsInsert() {
FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient);
@@ -1262,6 +1429,38 @@
}
}
+ public void testFieldsBlobsCountByExample() {
+ FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsblobs record = new Fieldsblobs();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new Fieldsblobs();
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ FieldsblobsExample example = new FieldsblobsExample();
+ example.setFirstname("S%");
+ example.setFirstname_Indicator(FieldsblobsExample.EXAMPLE_LIKE);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new FieldsblobsExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testAwfulTableInsert() {
AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
@@ -1930,6 +2129,58 @@
assertEquals(11, returnedRecord.getId1().intValue());
returnedRecord = (AwfulTable) answer.get(5);
assertEquals(1, returnedRecord.getId1().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableCountByExample() {
+ 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();
+ example.seteMail("fred@%");
+ example.seteMail_Indicator(AwfulTableExample.EXAMPLE_LIKE);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new AwfulTableExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
} catch (SQLException e) {
fail(e.getMessage());
}
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java2/HierarchicalJava2Tests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java2/HierarchicalJava2Tests.java?rev=570300&r1=570299&r2=570300&view=diff
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java2/HierarchicalJava2Tests.java (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java2/HierarchicalJava2Tests.java Mon Aug 27 21:06:02 2007
@@ -201,6 +201,42 @@
}
}
+ public void testFieldsOnlyCountByExample() {
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(11.22);
+ record.setFloatfield(33.44);
+ record.setIntegerfield(5);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(44.55);
+ record.setFloatfield(66.77);
+ record.setIntegerfield(8);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(88.99);
+ record.setFloatfield(100.111);
+ record.setIntegerfield(9);
+ dao.insert(record);
+
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.createCriteria().andIntegerfieldGreaterThan(5);
+
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKOnlyInsert() {
PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
@@ -341,6 +377,38 @@
}
}
+ public void testPKOnlyCountByExample() {
+ PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
+
+ try {
+ PkonlyKey key = new PkonlyKey();
+ key.setId(1);
+ key.setSeqNum(3);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(5);
+ key.setSeqNum(6);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(7);
+ key.setSeqNum(8);
+ dao.insert(key);
+
+ PkonlyExample example = new PkonlyExample();
+ example.createCriteria().andIdGreaterThan(4);
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsInsert() {
PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
@@ -1020,6 +1088,38 @@
}
}
+ public void testPKFieldsCountByExample() {
+ PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfields record = new Pkfields();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Bob");
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+
+ dao.insert(record);
+
+ PkfieldsExample example = new PkfieldsExample();
+ example.createCriteria().andLastnameLike("J%");
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKBlobsInsert() {
PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
@@ -1281,6 +1381,35 @@
}
}
+ public void testPKBlobsCountByExample() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsExample example = new PkblobsExample();
+ example.createCriteria().andIdLessThan(4);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsBlobsInsert() {
PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
@@ -1633,6 +1762,39 @@
}
}
+ public void testPKFieldsBlobsCountByExample() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.createCriteria().andId1NotEqualTo(3);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testFieldsBlobsInsert() {
FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient);
@@ -1789,6 +1951,37 @@
}
}
+ public void testFieldsBlobsCountByExample() {
+ FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ FieldsblobsWithBLOBs record = new FieldsblobsWithBLOBs();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new FieldsblobsWithBLOBs();
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ FieldsblobsExample example = new FieldsblobsExample();
+ example.createCriteria().andFirstnameLike("S%");
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testAwfulTableInsert() {
AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
@@ -2815,6 +3008,57 @@
assertEquals(11, returnedRecord.getId1().intValue());
returnedRecord = (AwfulTable) answer.get(5);
assertEquals(1, returnedRecord.getId1().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableCountByExample() {
+ 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();
+ example.createCriteria().andEMailLike("fred@%");
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
} catch (SQLException e) {
fail(e.getMessage());
}
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java5/HierarchicalJava5Tests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java5/HierarchicalJava5Tests.java?rev=570300&r1=570299&r2=570300&view=diff
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java5/HierarchicalJava5Tests.java (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java5/HierarchicalJava5Tests.java Mon Aug 27 21:06:02 2007
@@ -201,6 +201,41 @@
}
}
+ public void testFieldsOnlyCountByExample() {
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(11.22);
+ record.setFloatfield(33.44);
+ record.setIntegerfield(5);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(44.55);
+ record.setFloatfield(66.77);
+ record.setIntegerfield(8);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(88.99);
+ record.setFloatfield(100.111);
+ record.setIntegerfield(9);
+ dao.insert(record);
+
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.createCriteria().andIntegerfieldGreaterThan(5);
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKOnlyInsert() {
PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
@@ -341,6 +376,38 @@
}
}
+ public void testPKOnlyCountByExample() {
+ PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
+
+ try {
+ PkonlyKey key = new PkonlyKey();
+ key.setId(1);
+ key.setSeqNum(3);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(5);
+ key.setSeqNum(6);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(7);
+ key.setSeqNum(8);
+ dao.insert(key);
+
+ PkonlyExample example = new PkonlyExample();
+ example.createCriteria().andIdGreaterThan(4);
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsInsert() {
PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
@@ -1020,6 +1087,38 @@
}
}
+ public void testPKFieldsCountByExample() {
+ PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfields record = new Pkfields();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Bob");
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+
+ dao.insert(record);
+
+ PkfieldsExample example = new PkfieldsExample();
+ example.createCriteria().andLastnameLike("J%");
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKBlobsInsert() {
PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
@@ -1283,6 +1382,35 @@
}
}
+ public void testPKBlobsCountByExample() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsExample example = new PkblobsExample();
+ example.createCriteria().andIdLessThan(4);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsBlobsInsert() {
PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
@@ -1639,6 +1767,39 @@
}
}
+ public void testPKFieldsBlobsCountByExample() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.createCriteria().andId1NotEqualTo(3);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testFieldsBlobsInsert() {
FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient);
@@ -1795,6 +1956,37 @@
}
}
+ public void testFieldsBlobsCountByExample() {
+ FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ FieldsblobsWithBLOBs record = new FieldsblobsWithBLOBs();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new FieldsblobsWithBLOBs();
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ FieldsblobsExample example = new FieldsblobsExample();
+ example.createCriteria().andFirstnameLike("S%");
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testAwfulTableInsert() {
AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
@@ -2821,6 +3013,57 @@
assertEquals(11, returnedRecord.getId1().intValue());
returnedRecord = answer.get(5);
assertEquals(1, returnedRecord.getId1().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableCountByExample() {
+ 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();
+ example.createCriteria().andEMailLike("fred@%");
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
} catch (SQLException e) {
fail(e.getMessage());
}
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/legacy/HierarchicalLegacyTests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/legacy/HierarchicalLegacyTests.java?rev=570300&r1=570299&r2=570300&view=diff
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/legacy/HierarchicalLegacyTests.java (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/legacy/HierarchicalLegacyTests.java Mon Aug 27 21:06:02 2007
@@ -173,6 +173,44 @@
}
}
+ public void testFieldsOnlyCountByExample() {
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(11.22);
+ record.setFloatfield(33.44);
+ record.setIntegerfield(5);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(44.55);
+ record.setFloatfield(66.77);
+ record.setIntegerfield(8);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(88.99);
+ record.setFloatfield(100.111);
+ record.setIntegerfield(9);
+ dao.insert(record);
+
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.setIntegerfield(5);
+ example
+ .setIntegerfield_Indicator(FieldsonlyExample.EXAMPLE_GREATER_THAN);
+
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example = new FieldsonlyExample();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKOnlyInsert() {
PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
@@ -287,6 +325,39 @@
}
}
+ public void testPKOnlyCountByExample() {
+ PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
+
+ try {
+ PkonlyKey key = new PkonlyKey();
+ key.setId(1);
+ key.setSeqNum(3);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(5);
+ key.setSeqNum(6);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(7);
+ key.setSeqNum(8);
+ dao.insert(key);
+
+ PkonlyExample example = new PkonlyExample();
+ example.setId(4);
+ example.setId_Indicator(PkonlyExample.EXAMPLE_GREATER_THAN);
+ int rows = dao.countByExample(example);
+ assertEquals(2, rows);
+
+ example = new PkonlyExample();
+ rows = dao.countByExample(example);
+ assertEquals(3, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsInsert() {
PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
@@ -621,6 +692,39 @@
}
}
+ public void testPKFieldsCountByExample() {
+ PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfields record = new Pkfields();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Bob");
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+
+ dao.insert(record);
+
+ PkfieldsExample example = new PkfieldsExample();
+ example.setLastname("J%");
+ example.setLastname_Indicator(PkfieldsExample.EXAMPLE_LIKE);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new PkfieldsExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKBlobsInsert() {
PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
@@ -859,6 +963,36 @@
}
}
+ public void testPKBlobsCountByExample() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsExample example = new PkblobsExample();
+ example.setId(4);
+ example.setId_Indicator(PkblobsExample.EXAMPLE_LESS_THAN);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new PkblobsExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testPKFieldsBlobsInsert() {
PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
@@ -1185,6 +1319,40 @@
}
}
+ public void testPKFieldsBlobsCountByExample() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.setId1(3);
+ example.setId1_Indicator(PkfieldsblobsExample.EXAMPLE_NOT_EQUALS);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new PkfieldsblobsExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testFieldsBlobsInsert() {
FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient);
@@ -1317,6 +1485,38 @@
}
}
+ public void testFieldsBlobsCountByExample() {
+ FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ FieldsblobsWithBLOBs record = new FieldsblobsWithBLOBs();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new FieldsblobsWithBLOBs();
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ FieldsblobsExample example = new FieldsblobsExample();
+ example.setFirstname("S%");
+ example.setFirstname_Indicator(FieldsblobsExample.EXAMPLE_LIKE);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new FieldsblobsExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
public void testAwfulTableInsert() {
AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
@@ -1995,6 +2195,58 @@
assertEquals(11, returnedRecord.getId1().intValue());
returnedRecord = (AwfulTable) answer.get(5);
assertEquals(1, returnedRecord.getId1().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableCountByExample() {
+ 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();
+ example.seteMail("fred@%");
+ example.seteMail_Indicator(AwfulTableExample.EXAMPLE_LIKE);
+ int rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example = new AwfulTableExample();
+ rows = dao.countByExample(example);
+ assertEquals(2, rows);
} catch (SQLException e) {
fail(e.getMessage());
}