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/09/25 04:48:40 UTC
svn commit: r579041 [2/6] - in
/ibatis/trunk/java/mapper/mapper2/tools/abator/core: build/ doc/
src/org/apache/ibatis/abator/api/ src/org/apache/ibatis/abator/config/
src/org/apache/ibatis/abator/config/xml/
src/org/apache/ibatis/abator/internal/ src/o...
Copied: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/ConditionalJava2TestSuite.java (from r574711, ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/ConditionalJava2Tests.java)
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/ConditionalJava2TestSuite.java?p2=ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/ConditionalJava2TestSuite.java&p1=ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/ConditionalJava2Tests.java&r1=574711&r2=579041&rev=579041&view=diff
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/ConditionalJava2Tests.java (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/ConditionalJava2TestSuite.java Mon Sep 24 19:48:38 2007
@@ -16,3030 +16,27 @@
package abatortest.java2.execute.conditional.java2;
-import java.math.BigDecimal;
-import java.sql.SQLException;
-import java.util.ArrayList;
-import java.util.Date;
-import java.util.List;
-
-import abatortest.java2.BaseTest;
-import abatortest.java2.generated.conditional.java2.dao.AwfulTableDAO;
-import abatortest.java2.generated.conditional.java2.dao.AwfulTableDAOImpl;
-import abatortest.java2.generated.conditional.java2.dao.FieldsblobsDAO;
-import abatortest.java2.generated.conditional.java2.dao.FieldsblobsDAOImpl;
-import abatortest.java2.generated.conditional.java2.dao.FieldsonlyDAO;
-import abatortest.java2.generated.conditional.java2.dao.FieldsonlyDAOImpl;
-import abatortest.java2.generated.conditional.java2.dao.PkblobsDAO;
-import abatortest.java2.generated.conditional.java2.dao.PkblobsDAOImpl;
-import abatortest.java2.generated.conditional.java2.dao.PkfieldsDAO;
-import abatortest.java2.generated.conditional.java2.dao.PkfieldsDAOImpl;
-import abatortest.java2.generated.conditional.java2.dao.PkfieldsblobsDAO;
-import abatortest.java2.generated.conditional.java2.dao.PkfieldsblobsDAOImpl;
-import abatortest.java2.generated.conditional.java2.dao.PkonlyDAO;
-import abatortest.java2.generated.conditional.java2.dao.PkonlyDAOImpl;
-import abatortest.java2.generated.conditional.java2.model.AwfulTable;
-import abatortest.java2.generated.conditional.java2.model.AwfulTableExample;
-import abatortest.java2.generated.conditional.java2.model.Fieldsblobs;
-import abatortest.java2.generated.conditional.java2.model.FieldsblobsExample;
-import abatortest.java2.generated.conditional.java2.model.FieldsblobsWithBLOBs;
-import abatortest.java2.generated.conditional.java2.model.Fieldsonly;
-import abatortest.java2.generated.conditional.java2.model.FieldsonlyExample;
-import abatortest.java2.generated.conditional.java2.model.Pkblobs;
-import abatortest.java2.generated.conditional.java2.model.PkblobsExample;
-import abatortest.java2.generated.conditional.java2.model.Pkfields;
-import abatortest.java2.generated.conditional.java2.model.PkfieldsExample;
-import abatortest.java2.generated.conditional.java2.model.PkfieldsKey;
-import abatortest.java2.generated.conditional.java2.model.Pkfieldsblobs;
-import abatortest.java2.generated.conditional.java2.model.PkfieldsblobsExample;
-import abatortest.java2.generated.conditional.java2.model.PkfieldsblobsKey;
-import abatortest.java2.generated.conditional.java2.model.PkonlyExample;
-import abatortest.java2.generated.conditional.java2.model.PkonlyKey;
+import junit.framework.Test;
+import junit.framework.TestSuite;
/**
* @author Jeff Butler
*
*/
-public class ConditionalJava2Tests extends BaseTest {
-
- protected void setUp() throws Exception {
- super.setUp();
- initSqlMapClient(
- "abatortest/java2/execute/conditional/java2/SqlMapConfig.xml",
- null);
- }
-
- public void testFieldsOnlyInsert() {
- FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
-
- try {
- Fieldsonly record = new Fieldsonly();
- record.setDoublefield(new Double(11.22));
- record.setFloatfield(new Double(33.44));
- record.setIntegerfield(new Integer(5));
- dao.insert(record);
-
- FieldsonlyExample example = new FieldsonlyExample();
- example.createCriteria().andIntegerfieldEqualTo(new Integer(5));
-
- List answer = dao.selectByExample(example);
- assertEquals(1, answer.size());
-
- Fieldsonly returnedRecord = (Fieldsonly) answer.get(0);
- assertEquals(record.getIntegerfield(), returnedRecord
- .getIntegerfield());
- assertEquals(record.getDoublefield(), returnedRecord
- .getDoublefield());
- assertEquals(record.getFloatfield(), returnedRecord.getFloatfield());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testFieldsOnlySelectByExample() {
- FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
-
- try {
- Fieldsonly record = new Fieldsonly();
- record.setDoublefield(new Double(11.22));
- record.setFloatfield(new Double(33.44));
- record.setIntegerfield(new Integer(5));
- dao.insert(record);
-
- record = new Fieldsonly();
- record.setDoublefield(new Double(44.55));
- record.setFloatfield(new Double(66.77));
- record.setIntegerfield(new Integer(8));
- dao.insert(record);
-
- record = new Fieldsonly();
- record.setDoublefield(new Double(88.99));
- record.setFloatfield(new Double(100.111));
- record.setIntegerfield(new Integer(9));
- dao.insert(record);
-
- FieldsonlyExample example = new FieldsonlyExample();
- example.createCriteria().andIntegerfieldGreaterThan(new Integer(5));
-
- List answer = dao.selectByExample(example);
- assertEquals(2, answer.size());
-
- example = new FieldsonlyExample();
- answer = dao.selectByExample(example);
- assertEquals(3, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testFieldsOnlySelectByExampleNoCriteria() {
- FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
-
- try {
- Fieldsonly record = new Fieldsonly();
- record.setDoublefield(new Double(11.22));
- record.setFloatfield(new Double(33.44));
- record.setIntegerfield(new Integer(5));
- dao.insert(record);
-
- record = new Fieldsonly();
- record.setDoublefield(new Double(44.55));
- record.setFloatfield(new Double(66.77));
- record.setIntegerfield(new Integer(8));
- dao.insert(record);
-
- record = new Fieldsonly();
- record.setDoublefield(new Double(88.99));
- record.setFloatfield(new Double(100.111));
- record.setIntegerfield(new Integer(9));
- dao.insert(record);
-
- FieldsonlyExample example = new FieldsonlyExample();
- example.createCriteria();
-
- List answer = dao.selectByExample(example);
- assertEquals(3, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testFieldsOnlyDeleteByExample() {
- FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
-
- try {
- Fieldsonly record = new Fieldsonly();
- record.setDoublefield(new Double(11.22));
- record.setFloatfield(new Double(33.44));
- record.setIntegerfield(new Integer(5));
- dao.insert(record);
-
- record = new Fieldsonly();
- record.setDoublefield(new Double(44.55));
- record.setFloatfield(new Double(66.77));
- record.setIntegerfield(new Integer(8));
- dao.insert(record);
-
- record = new Fieldsonly();
- record.setDoublefield(new Double(88.99));
- record.setFloatfield(new Double(100.111));
- record.setIntegerfield(new Integer(9));
- dao.insert(record);
-
- FieldsonlyExample example = new FieldsonlyExample();
- example.createCriteria().andIntegerfieldGreaterThan(new Integer(5));
-
- int rows = dao.deleteByExample(example);
- assertEquals(2, rows);
-
- example = new FieldsonlyExample();
- List answer = dao.selectByExample(example);
- assertEquals(1, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testFieldsOnlyCountByExample() {
- FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
-
- try {
- Fieldsonly record = new Fieldsonly();
- record.setDoublefield(new Double(11.22));
- record.setFloatfield(new Double(33.44));
- record.setIntegerfield(new Integer(5));
- dao.insert(record);
-
- record = new Fieldsonly();
- record.setDoublefield(new Double(44.55));
- record.setFloatfield(new Double(66.77));
- record.setIntegerfield(new Integer(8));
- dao.insert(record);
-
- record = new Fieldsonly();
- record.setDoublefield(new Double(88.99));
- record.setFloatfield(new Double(100.111));
- record.setIntegerfield(new Integer(9));
- dao.insert(record);
-
- FieldsonlyExample example = new FieldsonlyExample();
- example.createCriteria().andIntegerfieldGreaterThan(new Integer(5));
-
- 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);
-
- try {
- PkonlyKey key = new PkonlyKey();
- key.setId(new Integer(1));
- key.setSeqNum(new Integer(3));
- dao.insert(key);
-
- PkonlyExample example = new PkonlyExample();
- List answer = dao.selectByExample(example);
- assertEquals(1, answer.size());
-
- PkonlyKey returnedRecord = (PkonlyKey) answer.get(0);
- assertEquals(key.getId(), returnedRecord.getId());
- assertEquals(key.getSeqNum(), returnedRecord.getSeqNum());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKOnlyDeleteByPrimaryKey() {
- PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
-
- try {
- PkonlyKey key = new PkonlyKey();
- key.setId(new Integer(1));
- key.setSeqNum(new Integer(3));
- dao.insert(key);
-
- key = new PkonlyKey();
- key.setId(new Integer(5));
- key.setSeqNum(new Integer(6));
- dao.insert(key);
-
- PkonlyExample example = new PkonlyExample();
- List answer = dao.selectByExample(example);
- assertEquals(2, answer.size());
-
- key = new PkonlyKey();
- key.setId(new Integer(5));
- key.setSeqNum(new Integer(6));
- int rows = dao.deleteByPrimaryKey(key);
- assertEquals(1, rows);
-
- answer = dao.selectByExample(example);
- assertEquals(1, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKOnlyDeleteByExample() {
- PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
-
- try {
- PkonlyKey key = new PkonlyKey();
- key.setId(new Integer(1));
- key.setSeqNum(new Integer(3));
- dao.insert(key);
-
- key = new PkonlyKey();
- key.setId(new Integer(5));
- key.setSeqNum(new Integer(6));
- dao.insert(key);
-
- key = new PkonlyKey();
- key.setId(new Integer(7));
- key.setSeqNum(new Integer(8));
- dao.insert(key);
-
- PkonlyExample example = new PkonlyExample();
- example.createCriteria().andIdGreaterThan(new Integer(4));
- int rows = dao.deleteByExample(example);
- assertEquals(2, rows);
-
- example = new PkonlyExample();
- List answer = dao.selectByExample(example);
- assertEquals(1, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKOnlySelectByExample() {
- PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
-
- try {
- PkonlyKey key = new PkonlyKey();
- key.setId(new Integer(1));
- key.setSeqNum(new Integer(3));
- dao.insert(key);
-
- key = new PkonlyKey();
- key.setId(new Integer(5));
- key.setSeqNum(new Integer(6));
- dao.insert(key);
-
- key = new PkonlyKey();
- key.setId(new Integer(7));
- key.setSeqNum(new Integer(8));
- dao.insert(key);
-
- PkonlyExample example = new PkonlyExample();
- example.createCriteria().andIdGreaterThan(new Integer(4));
- List answer = dao.selectByExample(example);
- assertEquals(2, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKOnlySelectByExampleNoCriteria() {
- PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
-
- try {
- PkonlyKey key = new PkonlyKey();
- key.setId(new Integer(1));
- key.setSeqNum(new Integer(3));
- dao.insert(key);
-
- key = new PkonlyKey();
- key.setId(new Integer(5));
- key.setSeqNum(new Integer(6));
- dao.insert(key);
-
- key = new PkonlyKey();
- key.setId(new Integer(7));
- key.setSeqNum(new Integer(8));
- dao.insert(key);
-
- PkonlyExample example = new PkonlyExample();
- example.createCriteria();
- List answer = dao.selectByExample(example);
- assertEquals(3, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKOnlyCountByExample() {
- PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
-
- try {
- PkonlyKey key = new PkonlyKey();
- key.setId(new Integer(1));
- key.setSeqNum(new Integer(3));
- dao.insert(key);
-
- key = new PkonlyKey();
- key.setId(new Integer(5));
- key.setSeqNum(new Integer(6));
- dao.insert(key);
-
- key = new PkonlyKey();
- key.setId(new Integer(7));
- key.setSeqNum(new Integer(8));
- dao.insert(key);
-
- PkonlyExample example = new PkonlyExample();
- example.createCriteria().andIdGreaterThan(new Integer(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);
-
- try {
- Pkfields record = new Pkfields();
- record.setDatefield(new Date());
- record.setDecimal100field(new Long(10L));
- record.setDecimal155field(new BigDecimal("15.12345"));
- record.setDecimal30field(new Short((short) 3));
- record.setDecimal60field(new Integer(6));
- record.setFirstname("Jeff");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
- record.setLastname("Butler");
- record.setTimefield(new Date());
- record.setTimestampfield(new Date());
-
- dao.insert(record);
-
- PkfieldsKey key = new PkfieldsKey();
- key.setId1(new Integer(1));
- key.setId2(new Integer(2));
-
- Pkfields returnedRecord = dao.selectByPrimaryKey(key);
- assertNotNull(returnedRecord);
-
- assertTrue(datesAreEqual(record.getDatefield(), returnedRecord
- .getDatefield()));
- assertEquals(record.getDecimal100field(), returnedRecord
- .getDecimal100field());
- assertEquals(record.getDecimal155field(), returnedRecord
- .getDecimal155field());
- assertEquals(record.getDecimal30field(), returnedRecord
- .getDecimal30field());
- assertEquals(record.getDecimal60field(), returnedRecord
- .getDecimal60field());
- assertEquals(record.getFirstname(), returnedRecord.getFirstname());
- assertEquals(record.getId1(), returnedRecord.getId1());
- assertEquals(record.getId2(), returnedRecord.getId2());
- assertEquals(record.getLastname(), returnedRecord.getLastname());
- assertTrue(timesAreEqual(record.getTimefield(), returnedRecord
- .getTimefield()));
- assertEquals(record.getTimestampfield(), returnedRecord
- .getTimestampfield());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsUpdateByPrimaryKey() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
-
- dao.insert(record);
-
- record.setFirstname("Scott");
- record.setLastname("Jones");
-
- int rows = dao.updateByPrimaryKey(record);
- assertEquals(1, rows);
-
- PkfieldsKey key = new PkfieldsKey();
- key.setId1(new Integer(1));
- key.setId2(new Integer(2));
-
- Pkfields record2 = dao.selectByPrimaryKey(key);
-
- assertEquals(record.getFirstname(), record2.getFirstname());
- assertEquals(record.getLastname(), record2.getLastname());
- assertEquals(record.getId1(), record2.getId1());
- assertEquals(record.getId2(), record2.getId2());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsUpdateByPrimaryKeySelective() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setDecimal60field(new Integer(5));
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
-
- dao.insert(record);
-
- Pkfields newRecord = new Pkfields();
- newRecord.setId1(new Integer(1));
- newRecord.setId2(new Integer(2));
- newRecord.setFirstname("Scott");
- newRecord.setDecimal60field(new Integer(4));
-
- int rows = dao.updateByPrimaryKeySelective(newRecord);
- assertEquals(1, rows);
-
- PkfieldsKey key = new PkfieldsKey();
- key.setId1(new Integer(1));
- key.setId2(new Integer(2));
-
- Pkfields returnedRecord = dao.selectByPrimaryKey(key);
-
- assertTrue(datesAreEqual(record.getDatefield(), returnedRecord
- .getDatefield()));
- assertEquals(record.getDecimal100field(), returnedRecord
- .getDecimal100field());
- assertEquals(record.getDecimal155field(), returnedRecord
- .getDecimal155field());
- assertEquals(record.getDecimal30field(), returnedRecord
- .getDecimal30field());
- assertEquals(newRecord.getDecimal60field(), returnedRecord
- .getDecimal60field());
- assertEquals(newRecord.getFirstname(), returnedRecord
- .getFirstname());
- assertEquals(record.getId1(), returnedRecord.getId1());
- assertEquals(record.getId2(), returnedRecord.getId2());
- assertEquals(record.getLastname(), returnedRecord.getLastname());
- assertTrue(timesAreEqual(record.getTimefield(), returnedRecord
- .getTimefield()));
- assertEquals(record.getTimestampfield(), returnedRecord
- .getTimestampfield());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKfieldsDeleteByPrimaryKey() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
-
- dao.insert(record);
-
- PkfieldsKey key = new PkfieldsKey();
- key.setId1(new Integer(1));
- key.setId2(new Integer(2));
-
- int rows = dao.deleteByPrimaryKey(key);
- assertEquals(1, rows);
-
- PkfieldsExample example = new PkfieldsExample();
- List answer = dao.selectByExample(example);
- assertEquals(0, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsDeleteByExample() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Bob");
- record.setLastname("Jones");
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
-
- dao.insert(record);
-
- PkfieldsExample example = new PkfieldsExample();
- List answer = dao.selectByExample(example);
- assertEquals(2, answer.size());
-
- example = new PkfieldsExample();
- example.createCriteria().andLastnameLike("J%");
- int rows = dao.deleteByExample(example);
- assertEquals(1, rows);
-
- example = new PkfieldsExample();
- answer = dao.selectByExample(example);
- assertEquals(1, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsSelectByPrimaryKey() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Bob");
- record.setLastname("Jones");
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- dao.insert(record);
-
- PkfieldsKey key = new PkfieldsKey();
- key.setId1(new Integer(3));
- key.setId2(new Integer(4));
- Pkfields newRecord = dao.selectByPrimaryKey(key);
-
- assertNotNull(newRecord);
- assertEquals(record.getFirstname(), newRecord.getFirstname());
- assertEquals(record.getLastname(), newRecord.getLastname());
- assertEquals(record.getId1(), newRecord.getId1());
- assertEquals(record.getId2(), newRecord.getId2());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsSelectByExampleLike() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Fred");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(1));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Wilma");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Pebbles");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(3));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Barney");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(1));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Betty");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Bamm Bamm");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(3));
- dao.insert(record);
-
- PkfieldsExample example = new PkfieldsExample();
- example.createCriteria().andFirstnameLike("B%");
- example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
- assertEquals(3, answer.size());
- Pkfields returnedRecord = (Pkfields) answer.get(0);
- assertEquals(2, returnedRecord.getId1().intValue());
- assertEquals(1, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(1);
- assertEquals(2, returnedRecord.getId1().intValue());
- assertEquals(2, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(2);
- assertEquals(2, returnedRecord.getId1().intValue());
- assertEquals(3, returnedRecord.getId2().intValue());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsSelectByExampleNotLike() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Fred");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(1));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Wilma");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Pebbles");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(3));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Barney");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(1));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Betty");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Bamm Bamm");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(3));
- dao.insert(record);
-
- PkfieldsExample example = new PkfieldsExample();
- example.createCriteria().andFirstnameNotLike("B%");
- example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
- assertEquals(3, answer.size());
- Pkfields returnedRecord = (Pkfields) answer.get(0);
- assertEquals(1, returnedRecord.getId1().intValue());
- assertEquals(1, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(1);
- assertEquals(1, returnedRecord.getId1().intValue());
- assertEquals(2, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(2);
- assertEquals(1, returnedRecord.getId1().intValue());
- assertEquals(3, returnedRecord.getId2().intValue());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsSelectByExampleComplexLike() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Fred");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(1));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Wilma");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Pebbles");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(3));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Barney");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(1));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Betty");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Bamm Bamm");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(3));
- dao.insert(record);
-
- PkfieldsExample example = new PkfieldsExample();
- example.createCriteria().andFirstnameLike("B%").andId2EqualTo(
- new Integer(3));
- example.or(example.createCriteria().andFirstnameLike("Wi%"));
-
- example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
- assertEquals(2, answer.size());
- Pkfields returnedRecord = (Pkfields) answer.get(0);
- assertEquals(1, returnedRecord.getId1().intValue());
- assertEquals(2, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(1);
- assertEquals(2, returnedRecord.getId1().intValue());
- assertEquals(3, returnedRecord.getId2().intValue());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsSelectByExampleIn() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Fred");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(1));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Wilma");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Pebbles");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(3));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Barney");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(1));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Betty");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Bamm Bamm");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(3));
- dao.insert(record);
-
- List ids = new ArrayList();
- ids.add(new Integer(1));
- ids.add(new Integer(3));
-
- PkfieldsExample example = new PkfieldsExample();
- example.createCriteria().andId2In(ids);
-
- example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
- assertEquals(4, answer.size());
- Pkfields returnedRecord = (Pkfields) answer.get(0);
- assertEquals(1, returnedRecord.getId1().intValue());
- assertEquals(1, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(1);
- assertEquals(1, returnedRecord.getId1().intValue());
- assertEquals(3, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(2);
- assertEquals(2, returnedRecord.getId1().intValue());
- assertEquals(1, returnedRecord.getId2().intValue());
- returnedRecord = (Pkfields) answer.get(3);
- assertEquals(2, returnedRecord.getId1().intValue());
- assertEquals(3, returnedRecord.getId2().intValue());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsSelectByExampleBetween() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Fred");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(1));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Wilma");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Pebbles");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(3));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Barney");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(1));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Betty");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Bamm Bamm");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(3));
- dao.insert(record);
-
- PkfieldsExample example = new PkfieldsExample();
- example.createCriteria().andId2Between(new Integer(1),
- new Integer(3));
-
- example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
- assertEquals(6, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsSelectByExampleNoCriteria() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Fred");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(1));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Wilma");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Pebbles");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(3));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Barney");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(1));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Betty");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Bamm Bamm");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(3));
- dao.insert(record);
-
- PkfieldsExample example = new PkfieldsExample();
- example.createCriteria();
-
- example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
- assertEquals(6, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsSelectByExampleEscapedFields() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Fred");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(1));
- record.setWierdField(new Integer(11));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Wilma");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
- record.setWierdField(new Integer(22));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Pebbles");
- record.setLastname("Flintstone");
- record.setId1(new Integer(1));
- record.setId2(new Integer(3));
- record.setWierdField(new Integer(33));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Barney");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(1));
- record.setWierdField(new Integer(44));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Betty");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(2));
- record.setWierdField(new Integer(55));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Bamm Bamm");
- record.setLastname("Rubble");
- record.setId1(new Integer(2));
- record.setId2(new Integer(3));
- record.setWierdField(new Integer(66));
- dao.insert(record);
-
- List values = new ArrayList();
- values.add(new Integer(11));
- values.add(new Integer(22));
-
- PkfieldsExample example = new PkfieldsExample();
- example.createCriteria().andWierdFieldLessThan(new Integer(40))
- .andWierdFieldIn(values);
-
- example.setOrderByClause("ID1, ID2");
- List answer = dao.selectByExample(example);
- assertEquals(2, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsCountByExample() {
- PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
-
- try {
- Pkfields record = new Pkfields();
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setId1(new Integer(1));
- record.setId2(new Integer(2));
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Bob");
- record.setLastname("Jones");
- record.setId1(new Integer(3));
- record.setId2(new Integer(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);
-
- try {
- Pkblobs record = new Pkblobs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- PkblobsExample example = new PkblobsExample();
- List answer = dao.selectByExampleWithBLOBs(example);
- assertEquals(1, answer.size());
-
- Pkblobs returnedRecord = (Pkblobs) answer.get(0);
- assertEquals(record.getId(), returnedRecord.getId());
- assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord
- .getBlob1()));
- assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord
- .getBlob2()));
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKBlobsUpdateByPrimaryKeyWithBLOBs() {
- PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
-
- try {
- Pkblobs record = new Pkblobs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkblobs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.updateByPrimaryKey(record);
-
- Pkblobs newRecord = dao.selectByPrimaryKey(new Integer(3));
-
- assertNotNull(newRecord);
- assertEquals(record.getId(), newRecord.getId());
- assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
- assertTrue(blobsAreEqual(record.getBlob2(), newRecord.getBlob2()));
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKBlobsUpdateByPrimaryKeySelective() {
- PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
-
- try {
- Pkblobs record = new Pkblobs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- Pkblobs newRecord = new Pkblobs();
- newRecord.setId(new Integer(3));
- newRecord.setBlob2(generateRandomBlob());
- dao.updateByPrimaryKeySelective(newRecord);
-
- Pkblobs returnedRecord = dao.selectByPrimaryKey(new Integer(3));
- assertNotNull(returnedRecord);
- assertEquals(record.getId(), returnedRecord.getId());
- assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord
- .getBlob1()));
- assertTrue(blobsAreEqual(newRecord.getBlob2(), returnedRecord
- .getBlob2()));
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKBlobsDeleteByPrimaryKey() {
- PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
-
- try {
- Pkblobs record = new Pkblobs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- PkblobsExample example = new PkblobsExample();
- List answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(1, answer.size());
-
- int rows = dao.deleteByPrimaryKey(new Integer(3));
- assertEquals(1, rows);
-
- example = new PkblobsExample();
- answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(0, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKBlobsDeleteByExample() {
- PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
-
- try {
- Pkblobs record = new Pkblobs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkblobs();
- record.setId(new Integer(6));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- PkblobsExample example = new PkblobsExample();
- List answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(2, answer.size());
-
- example = new PkblobsExample();
- example.createCriteria().andIdLessThan(new Integer(4));
- int rows = dao.deleteByExample(example);
- assertEquals(1, rows);
-
- example = new PkblobsExample();
- answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(1, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKBlobsSelectByPrimaryKey() {
- PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
-
- try {
- Pkblobs record = new Pkblobs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkblobs();
- record.setId(new Integer(6));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- Pkblobs newRecord = dao.selectByPrimaryKey(new Integer(6));
- assertNotNull(newRecord);
- assertEquals(record.getId(), newRecord.getId());
- assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
- assertTrue(blobsAreEqual(record.getBlob2(), newRecord.getBlob2()));
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKBlobsSelectByExampleWithoutBlobs() {
- PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
-
- try {
- Pkblobs record = new Pkblobs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkblobs();
- record.setId(new Integer(6));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- PkblobsExample example = new PkblobsExample();
- example.createCriteria().andIdGreaterThan(new Integer(4));
- List answer = dao.selectByExampleWithoutBLOBs(example);
-
- assertEquals(1, answer.size());
-
- Pkblobs key = (Pkblobs) answer.get(0);
- assertEquals(6, key.getId().intValue());
- assertNull(key.getBlob1());
- assertNull(key.getBlob2());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKBlobsSelectByExampleWithoutBlobsNoCriteria() {
- PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
-
- try {
- Pkblobs record = new Pkblobs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkblobs();
- record.setId(new Integer(6));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- PkblobsExample example = new PkblobsExample();
- example.createCriteria();
- List answer = dao.selectByExampleWithoutBLOBs(example);
-
- assertEquals(2, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKBlobsSelectByExampleWithBlobs() {
- PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
-
- try {
- Pkblobs record = new Pkblobs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkblobs();
- record.setId(new Integer(6));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- PkblobsExample example = new PkblobsExample();
- example.createCriteria().andIdGreaterThan(new Integer(4));
- List answer = dao.selectByExampleWithBLOBs(example);
-
- assertEquals(1, answer.size());
-
- Pkblobs newRecord = (Pkblobs) answer.get(0);
- assertEquals(record.getId(), newRecord.getId());
- assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
- assertTrue(blobsAreEqual(record.getBlob2(), newRecord.getBlob2()));
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKBlobsCountByExample() {
- PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
-
- try {
- Pkblobs record = new Pkblobs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkblobs();
- record.setId(new Integer(6));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- PkblobsExample example = new PkblobsExample();
- example.createCriteria().andIdLessThan(new Integer(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);
-
- try {
- Pkfieldsblobs record = new Pkfieldsblobs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- PkfieldsblobsExample example = new PkfieldsblobsExample();
- List answer = dao.selectByExampleWithBLOBs(example);
- assertEquals(1, answer.size());
-
- Pkfieldsblobs returnedRecord = (Pkfieldsblobs) answer.get(0);
- assertEquals(record.getId1(), returnedRecord.getId1());
- assertEquals(record.getId2(), returnedRecord.getId2());
- assertEquals(record.getFirstname(), returnedRecord.getFirstname());
- assertEquals(record.getLastname(), returnedRecord.getLastname());
- assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord
- .getBlob1()));
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsBlobsUpdateByPrimaryKeyWithBLOBs() {
- PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
-
- try {
- Pkfieldsblobs record = new Pkfieldsblobs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- Pkfieldsblobs updateRecord = new Pkfieldsblobs();
- updateRecord.setId1(new Integer(3));
- updateRecord.setId2(new Integer(4));
- updateRecord.setFirstname("Scott");
- updateRecord.setLastname("Jones");
- updateRecord.setBlob1(generateRandomBlob());
-
- int rows = dao.updateByPrimaryKeyWithBLOBs(updateRecord);
- assertEquals(1, rows);
-
- PkfieldsblobsKey key = new PkfieldsblobsKey();
- key.setId1(new Integer(3));
- key.setId2(new Integer(4));
- Pkfieldsblobs newRecord = dao.selectByPrimaryKey(key);
- assertEquals(updateRecord.getFirstname(), newRecord.getFirstname());
- assertEquals(updateRecord.getLastname(), newRecord.getLastname());
- assertEquals(record.getId1(), newRecord.getId1());
- assertEquals(record.getId2(), newRecord.getId2());
- assertTrue(blobsAreEqual(updateRecord.getBlob1(), newRecord
- .getBlob1()));
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsBlobsUpdateByPrimaryKeyWithoutBLOBs() {
- PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
-
- try {
- Pkfieldsblobs record = new Pkfieldsblobs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- Pkfieldsblobs updateRecord = new Pkfieldsblobs();
- updateRecord.setId1(new Integer(3));
- updateRecord.setId2(new Integer(4));
- updateRecord.setFirstname("Scott");
- updateRecord.setLastname("Jones");
-
- int rows = dao.updateByPrimaryKeyWithoutBLOBs(updateRecord);
- assertEquals(1, rows);
-
- PkfieldsblobsKey key = new PkfieldsblobsKey();
- key.setId1(new Integer(3));
- key.setId2(new Integer(4));
- Pkfieldsblobs newRecord = dao.selectByPrimaryKey(key);
- assertEquals(updateRecord.getFirstname(), newRecord.getFirstname());
- assertEquals(updateRecord.getLastname(), newRecord.getLastname());
- assertEquals(record.getId1(), newRecord.getId1());
- assertEquals(record.getId2(), newRecord.getId2());
- assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsBlobsUpdateByPrimaryKeySelective() {
- PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
-
- try {
- Pkfieldsblobs record = new Pkfieldsblobs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- Pkfieldsblobs updateRecord = new Pkfieldsblobs();
- updateRecord.setId1(new Integer(3));
- updateRecord.setId2(new Integer(4));
- updateRecord.setLastname("Jones");
-
- int rows = dao.updateByPrimaryKeySelective(updateRecord);
- assertEquals(1, rows);
-
- PkfieldsblobsKey key = new PkfieldsblobsKey();
- key.setId1(new Integer(3));
- key.setId2(new Integer(4));
- Pkfieldsblobs returnedRecord = dao.selectByPrimaryKey(key);
- assertEquals(record.getFirstname(), returnedRecord.getFirstname());
- assertEquals(updateRecord.getLastname(), returnedRecord
- .getLastname());
- assertEquals(record.getId1(), returnedRecord.getId1());
- assertEquals(record.getId2(), returnedRecord.getId2());
- assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord
- .getBlob1()));
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsBlobsDeleteByPrimaryKey() {
- PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
-
- try {
- Pkfieldsblobs record = new Pkfieldsblobs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkfieldsblobs();
- record.setId1(new Integer(5));
- record.setId2(new Integer(6));
- record.setFirstname("Scott");
- record.setLastname("Jones");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- PkfieldsblobsExample example = new PkfieldsblobsExample();
- List answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(2, answer.size());
-
- PkfieldsblobsKey key = new PkfieldsblobsKey();
- key.setId1(new Integer(5));
- key.setId2(new Integer(6));
- int rows = dao.deleteByPrimaryKey(key);
- assertEquals(1, rows);
-
- example = new PkfieldsblobsExample();
- answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(1, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsBlobsDeleteByExample() {
- PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
-
- try {
- Pkfieldsblobs record = new Pkfieldsblobs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkfieldsblobs();
- record.setId1(new Integer(5));
- record.setId2(new Integer(6));
- record.setFirstname("Scott");
- record.setLastname("Jones");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- PkfieldsblobsExample example = new PkfieldsblobsExample();
- List answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(2, answer.size());
-
- example = new PkfieldsblobsExample();
- example.createCriteria().andId1NotEqualTo(new Integer(3));
- int rows = dao.deleteByExample(example);
- assertEquals(1, rows);
-
- example = new PkfieldsblobsExample();
- answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(1, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsBlobsSelectByPrimaryKey() {
- PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
-
- try {
- Pkfieldsblobs record = new Pkfieldsblobs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkfieldsblobs();
- record.setId1(new Integer(5));
- record.setId2(new Integer(6));
- record.setFirstname("Scott");
- record.setLastname("Jones");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- PkfieldsblobsExample example = new PkfieldsblobsExample();
- List answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(2, answer.size());
-
- PkfieldsblobsKey key = new PkfieldsblobsKey();
- key.setId1(new Integer(5));
- key.setId2(new Integer(6));
- Pkfieldsblobs newRecord = dao.selectByPrimaryKey(key);
- assertEquals(record.getId1(), newRecord.getId1());
- assertEquals(record.getId2(), newRecord.getId2());
- assertEquals(record.getFirstname(), newRecord.getFirstname());
- assertEquals(record.getLastname(), newRecord.getLastname());
- assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsBlobsSelectByExampleWithoutBlobs() {
- PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
-
- try {
- Pkfieldsblobs record = new Pkfieldsblobs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkfieldsblobs();
- record.setId1(new Integer(5));
- record.setId2(new Integer(6));
- record.setFirstname("Scott");
- record.setLastname("Jones");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- PkfieldsblobsExample example = new PkfieldsblobsExample();
- example.createCriteria().andId2EqualTo(new Integer(6));
- List answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(1, answer.size());
-
- Pkfieldsblobs newRecord = (Pkfieldsblobs) answer.get(0);
- assertEquals(record.getId1(), newRecord.getId1());
- assertEquals(record.getId2(), newRecord.getId2());
- assertEquals(record.getFirstname(), newRecord.getFirstname());
- assertEquals(record.getLastname(), newRecord.getLastname());
- assertNull(newRecord.getBlob1());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsBlobsSelectByExampleWithBlobs() {
- PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
-
- try {
- Pkfieldsblobs record = new Pkfieldsblobs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkfieldsblobs();
- record.setId1(new Integer(5));
- record.setId2(new Integer(6));
- record.setFirstname("Scott");
- record.setLastname("Jones");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- PkfieldsblobsExample example = new PkfieldsblobsExample();
- example.createCriteria().andId2EqualTo(new Integer(6));
- List answer = dao.selectByExampleWithBLOBs(example);
- assertEquals(1, answer.size());
-
- Pkfieldsblobs newRecord = (Pkfieldsblobs) answer.get(0);
- assertEquals(record.getId1(), newRecord.getId1());
- assertEquals(record.getId2(), newRecord.getId2());
- assertEquals(record.getFirstname(), newRecord.getFirstname());
- assertEquals(record.getLastname(), newRecord.getLastname());
- assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsBlobsSelectByExampleWithBlobsNoCriteria() {
- PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
-
- try {
- Pkfieldsblobs record = new Pkfieldsblobs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkfieldsblobs();
- record.setId1(new Integer(5));
- record.setId2(new Integer(6));
- record.setFirstname("Scott");
- record.setLastname("Jones");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- PkfieldsblobsExample example = new PkfieldsblobsExample();
- example.createCriteria();
- List answer = dao.selectByExampleWithBLOBs(example);
- assertEquals(2, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testPKFieldsBlobsCountByExample() {
- PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
-
- try {
- Pkfieldsblobs record = new Pkfieldsblobs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- record = new Pkfieldsblobs();
- record.setId1(new Integer(5));
- record.setId2(new Integer(6));
- record.setFirstname("Scott");
- record.setLastname("Jones");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- PkfieldsblobsExample example = new PkfieldsblobsExample();
- example.createCriteria().andId1NotEqualTo(new Integer(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);
-
- try {
- FieldsblobsWithBLOBs record = new FieldsblobsWithBLOBs();
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- FieldsblobsExample example = new FieldsblobsExample();
- List answer = dao.selectByExampleWithBLOBs(example);
- assertEquals(1, answer.size());
-
- FieldsblobsWithBLOBs returnedRecord = (FieldsblobsWithBLOBs) answer
- .get(0);
- assertEquals(record.getFirstname(), returnedRecord.getFirstname());
- assertEquals(record.getLastname(), returnedRecord.getLastname());
- assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord
- .getBlob1()));
- assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord
- .getBlob2()));
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testFieldsBlobsDeleteByExample() {
- 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();
- List answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(2, answer.size());
-
- example = new FieldsblobsExample();
- example.createCriteria().andFirstnameLike("S%");
- int rows = dao.deleteByExample(example);
- assertEquals(1, rows);
-
- example = new FieldsblobsExample();
- answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(1, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testFieldsBlobsSelectByExampleWithoutBlobs() {
- 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%");
- List answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(1, answer.size());
-
- Fieldsblobs newRecord = (Fieldsblobs) answer.get(0);
- assertFalse(newRecord instanceof FieldsblobsWithBLOBs);
- assertEquals(record.getFirstname(), newRecord.getFirstname());
- assertEquals(record.getLastname(), newRecord.getLastname());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testFieldsBlobsSelectByExampleWithBlobs() {
- 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%");
- List answer = dao.selectByExampleWithBLOBs(example);
- assertEquals(1, answer.size());
-
- FieldsblobsWithBLOBs newRecord = (FieldsblobsWithBLOBs) answer
- .get(0);
- assertEquals(record.getFirstname(), newRecord.getFirstname());
- 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 testFieldsBlobsSelectByExampleWithBlobsNoCriteria() {
- 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();
- List answer = dao.selectByExampleWithBLOBs(example);
- assertEquals(2, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- 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);
-
- 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());
-
- AwfulTable returnedRecord = dao
- .selectByPrimaryKey(generatedCustomerId);
-
- assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
- assertEquals(record.geteMail(), returnedRecord.geteMail());
- assertEquals(record.getEmailaddress(), returnedRecord
- .getEmailaddress());
- assertEquals(record.getFirstFirstName(), returnedRecord
- .getFirstFirstName());
- assertEquals(record.getFourthFirstName(), returnedRecord
- .getFourthFirstName());
- assertEquals(record.getFrom(), returnedRecord.getFrom());
- assertEquals(record.getId1(), returnedRecord.getId1());
- assertEquals(record.getId2(), returnedRecord.getId2());
- assertEquals(record.getId5(), returnedRecord.getId5());
- assertEquals(record.getId6(), returnedRecord.getId6());
- assertEquals(record.getId7(), returnedRecord.getId7());
- assertEquals(record.getSecondCustomerId(), returnedRecord
- .getSecondCustomerId());
- assertEquals(record.getSecondFirstName(), returnedRecord
- .getSecondFirstName());
- assertEquals(record.getThirdFirstName(), returnedRecord
- .getThirdFirstName());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testAwfulTableUpdateByPrimaryKey() {
- AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
-
- try {
- AwfulTable record = new AwfulTable();
- record.seteMail("fred@fred.com");
- record.setEmailaddress("alsofred@fred.com");
- record.setFirstFirstName("fred1");
- record.setFourthFirstName("fred4");
- record.setFrom("from field");
- record.setId1(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);
-
- AwfulTable returnedRecord = dao.selectByPrimaryKey(generatedCustomerId);
-
- assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
- assertEquals(record.geteMail(), returnedRecord.geteMail());
- assertEquals(record.getEmailaddress(), returnedRecord
- .getEmailaddress());
- assertEquals(record.getFirstFirstName(), returnedRecord
- .getFirstFirstName());
- assertEquals(record.getFourthFirstName(), returnedRecord
- .getFourthFirstName());
- assertEquals(record.getFrom(), returnedRecord.getFrom());
- assertEquals(record.getId1(), returnedRecord.getId1());
- assertEquals(record.getId2(), returnedRecord.getId2());
- assertEquals(record.getId5(), returnedRecord.getId5());
- assertEquals(record.getId6(), returnedRecord.getId6());
- assertEquals(record.getId7(), returnedRecord.getId7());
- assertEquals(record.getSecondCustomerId(), returnedRecord
- .getSecondCustomerId());
- assertEquals(record.getSecondFirstName(), returnedRecord
- .getSecondFirstName());
- assertEquals(record.getThirdFirstName(), returnedRecord
- .getThirdFirstName());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testAwfulTableUpdateByPrimaryKeySelective() {
- AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
-
- try {
- AwfulTable record = new AwfulTable();
- record.seteMail("fred@fred.com");
- record.setEmailaddress("alsofred@fred.com");
- record.setFirstFirstName("fred1");
- record.setFourthFirstName("fred4");
- record.setFrom("from field");
- record.setId1(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);
-
- AwfulTable returnedRecord = dao.selectByPrimaryKey(generatedCustomerId);
-
- assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
- assertEquals(record.geteMail(), returnedRecord.geteMail());
- assertEquals(record.getEmailaddress(), returnedRecord
- .getEmailaddress());
- assertEquals(record.getFirstFirstName(), returnedRecord
- .getFirstFirstName());
- assertEquals(record.getFourthFirstName(), returnedRecord
- .getFourthFirstName());
- assertEquals(record.getFrom(), returnedRecord.getFrom());
- assertEquals(newRecord.getId1(), returnedRecord.getId1());
- assertEquals(newRecord.getId2(), returnedRecord.getId2());
- assertEquals(record.getId5(), returnedRecord.getId5());
- assertEquals(record.getId6(), returnedRecord.getId6());
- assertEquals(record.getId7(), returnedRecord.getId7());
- assertEquals(record.getSecondCustomerId(), returnedRecord
- .getSecondCustomerId());
- assertEquals(record.getSecondFirstName(), returnedRecord
- .getSecondFirstName());
- assertEquals(record.getThirdFirstName(), returnedRecord
- .getThirdFirstName());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testAwfulTableDeleteByPrimaryKey() {
- AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
-
- try {
- AwfulTable record = new AwfulTable();
- record.seteMail("fred@fred.com");
- record.setEmailaddress("alsofred@fred.com");
- record.setFirstFirstName("fred1");
- record.setFourthFirstName("fred4");
- record.setFrom("from field");
- record.setId1(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);
-
- int rows = dao.deleteByPrimaryKey(generatedCustomerId);
- assertEquals(1, rows);
-
- AwfulTableExample example = new AwfulTableExample();
- List answer = dao.selectByExample(example);
- assertEquals(0, answer.size());
- } catch (SQLException e) {
- fail(e.getMessage());
- }
- }
-
- public void testAwfulTableDeleteByExample() {
- AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
-
- try {
- AwfulTable record = new AwfulTable();
- record.seteMail("fred@fred.com");
- record.setEmailaddress("alsofred@fred.com");
- record.setFirstFirstName("fred1");
- record.setFourthFirstName("fred4");
- record.setFrom("from field");
- record.setId1(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");
[... 831 lines stripped ...]