You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ibatis.apache.org by jg...@apache.org on 2007/02/06 06:06:31 UTC
svn commit: r503987 [17/18] - in
/ibatis/trunk/java/mapper/mapper2/tools/abator/core: build/ devlib/
src/org/apache/ibatis/abator/config/
src/org/apache/ibatis/abator/internal/db/
src/org/apache/ibatis/abator/internal/java/dao/ src/org/apache/ibatis/ab...
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?view=diff&rev=503987&r1=503986&r2=503987
==============================================================================
--- 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 Feb 5 21:06:29 2007
@@ -17,17 +17,23 @@
package abatortest.execute.hierarchical.legacy;
import java.math.BigDecimal;
-import java.util.ArrayList;
+import java.sql.SQLException;
import java.util.Date;
import java.util.List;
import abatortest.BaseTest;
import abatortest.generated.hierarchical.legacy.dao.FieldsblobsDAO;
+import abatortest.generated.hierarchical.legacy.dao.FieldsblobsDAOImpl;
import abatortest.generated.hierarchical.legacy.dao.FieldsonlyDAO;
+import abatortest.generated.hierarchical.legacy.dao.FieldsonlyDAOImpl;
import abatortest.generated.hierarchical.legacy.dao.PkblobsDAO;
+import abatortest.generated.hierarchical.legacy.dao.PkblobsDAOImpl;
import abatortest.generated.hierarchical.legacy.dao.PkfieldsDAO;
+import abatortest.generated.hierarchical.legacy.dao.PkfieldsDAOImpl;
import abatortest.generated.hierarchical.legacy.dao.PkfieldsblobsDAO;
+import abatortest.generated.hierarchical.legacy.dao.PkfieldsblobsDAOImpl;
import abatortest.generated.hierarchical.legacy.dao.PkonlyDAO;
+import abatortest.generated.hierarchical.legacy.dao.PkonlyDAOImpl;
import abatortest.generated.hierarchical.legacy.model.Fieldsblobs;
import abatortest.generated.hierarchical.legacy.model.FieldsblobsExample;
import abatortest.generated.hierarchical.legacy.model.FieldsblobsWithBLOBs;
@@ -48,1086 +54,1261 @@
/**
* @author Jeff Butler
- *
+ *
*/
public class HierarchicalLegacyTests extends BaseTest {
protected void setUp() throws Exception {
super.setUp();
- initDaoManager("abatortest/execute/hierarchical/legacy/dao.xml", null);
+ initSqlMapClient(
+ "abatortest/execute/hierarchical/legacy/SqlMapConfig.xml", null);
}
-
+
public void testFieldsOnlyInsert() {
- FieldsonlyDAO dao = (FieldsonlyDAO) daoManager.getDao(FieldsonlyDAO.class);
-
- Fieldsonly record = new Fieldsonly();
- record.setDoublefield(new Double(11.22));
- record.setFloatfield(new Float(33.44));
- record.setIntegerfield(new Integer(5));
- dao.insert(record);
-
- FieldsonlyExample example = new FieldsonlyExample();
- example.setIntegerfield(new Integer(5));
- example.setIntegerfield_Indicator(FieldsonlyExample.EXAMPLE_EQUALS);
-
- 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());
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(new Double(11.22));
+ record.setFloatfield(new Float(33.44));
+ record.setIntegerfield(new Integer(5));
+ dao.insert(record);
+
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.setIntegerfield(new Integer(5));
+ example.setIntegerfield_Indicator(FieldsonlyExample.EXAMPLE_EQUALS);
+
+ 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 = (FieldsonlyDAO) daoManager.getDao(FieldsonlyDAO.class);
-
- Fieldsonly record = new Fieldsonly();
- record.setDoublefield(new Double(11.22));
- record.setFloatfield(new Float(33.44));
- record.setIntegerfield(new Integer(5));
- dao.insert(record);
-
- record = new Fieldsonly();
- record.setDoublefield(new Double(44.55));
- record.setFloatfield(new Float(66.77));
- record.setIntegerfield(new Integer(8));
- dao.insert(record);
-
- record = new Fieldsonly();
- record.setDoublefield(new Double(88.99));
- record.setFloatfield(new Float(100.111));
- record.setIntegerfield(new Integer(9));
- dao.insert(record);
-
- FieldsonlyExample example = new FieldsonlyExample();
- example.setIntegerfield(new Integer(5));
- example.setIntegerfield_Indicator(FieldsonlyExample.EXAMPLE_GREATER_THAN);
-
- List answer = dao.selectByExample(example);
- assertEquals(2, answer.size());
-
- example = new FieldsonlyExample();
- answer = dao.selectByExample(example);
- assertEquals(3, answer.size());
-
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(new Double(11.22));
+ record.setFloatfield(new Float(33.44));
+ record.setIntegerfield(new Integer(5));
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(new Double(44.55));
+ record.setFloatfield(new Float(66.77));
+ record.setIntegerfield(new Integer(8));
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(new Double(88.99));
+ record.setFloatfield(new Float(100.111));
+ record.setIntegerfield(new Integer(9));
+ dao.insert(record);
+
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.setIntegerfield(new Integer(5));
+ example
+ .setIntegerfield_Indicator(FieldsonlyExample.EXAMPLE_GREATER_THAN);
+
+ 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 testFieldsOnlyDeleteByExample() {
- FieldsonlyDAO dao = (FieldsonlyDAO) daoManager.getDao(FieldsonlyDAO.class);
-
- Fieldsonly record = new Fieldsonly();
- record.setDoublefield(new Double(11.22));
- record.setFloatfield(new Float(33.44));
- record.setIntegerfield(new Integer(5));
- dao.insert(record);
-
- record = new Fieldsonly();
- record.setDoublefield(new Double(44.55));
- record.setFloatfield(new Float(66.77));
- record.setIntegerfield(new Integer(8));
- dao.insert(record);
-
- record = new Fieldsonly();
- record.setDoublefield(new Double(88.99));
- record.setFloatfield(new Float(100.111));
- record.setIntegerfield(new Integer(9));
- dao.insert(record);
-
- FieldsonlyExample example = new FieldsonlyExample();
- example.setIntegerfield(new Integer(5));
- example.setIntegerfield_Indicator(FieldsonlyExample.EXAMPLE_GREATER_THAN);
-
- int rows = dao.deleteByExample(example);
- assertEquals(2, rows);
-
- example = new FieldsonlyExample();
- List answer = dao.selectByExample(example);
- assertEquals(1, answer.size());
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(new Double(11.22));
+ record.setFloatfield(new Float(33.44));
+ record.setIntegerfield(new Integer(5));
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(new Double(44.55));
+ record.setFloatfield(new Float(66.77));
+ record.setIntegerfield(new Integer(8));
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(new Double(88.99));
+ record.setFloatfield(new Float(100.111));
+ record.setIntegerfield(new Integer(9));
+ dao.insert(record);
+
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.setIntegerfield(new Integer(5));
+ example
+ .setIntegerfield_Indicator(FieldsonlyExample.EXAMPLE_GREATER_THAN);
+
+ 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 testPKOnlyInsert() {
- PkonlyDAO dao = (PkonlyDAO) daoManager.getDao(PkonlyDAO.class);
-
- 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());
+ 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 = (PkonlyDAO) daoManager.getDao(PkonlyDAO.class);
-
- 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());
+ 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 = (PkonlyDAO) daoManager.getDao(PkonlyDAO.class);
-
- 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.setId(4);
- example.setId_Indicator(PkonlyExample.EXAMPLE_GREATER_THAN);
- int rows = dao.deleteByExample(example);
- assertEquals(2, rows);
-
- example = new PkonlyExample();
- List answer = dao.selectByExample(example);
- assertEquals(1, answer.size());
+ 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.setId(4);
+ example.setId_Indicator(PkonlyExample.EXAMPLE_GREATER_THAN);
+ 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 = (PkonlyDAO) daoManager.getDao(PkonlyDAO.class);
-
- 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.setId(4);
- example.setId_Indicator(PkonlyExample.EXAMPLE_GREATER_THAN);
- List answer = dao.selectByExample(example);
- assertEquals(2, answer.size());
+ 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.setId(4);
+ example.setId_Indicator(PkonlyExample.EXAMPLE_GREATER_THAN);
+ List answer = dao.selectByExample(example);
+ assertEquals(2, answer.size());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
}
-
+
public void testPKFieldsInsert() {
- PkfieldsDAO dao = (PkfieldsDAO) daoManager.getDao(PkfieldsDAO.class);
-
- 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());
+ 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 = (PkfieldsDAO) daoManager.getDao(PkfieldsDAO.class);
-
- 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());
+ 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 = (PkfieldsDAO) daoManager.getDao(PkfieldsDAO.class);
-
- 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());
+ 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 = (PkfieldsDAO) daoManager.getDao(PkfieldsDAO.class);
-
- 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());
+ 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 = (PkfieldsDAO) daoManager.getDao(PkfieldsDAO.class);
-
- 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.setLastname("J%");
- example.setLastname_Indicator(PkfieldsExample.EXAMPLE_LIKE);
- int rows = dao.deleteByExample(example);
- assertEquals(1, rows);
-
- example = new PkfieldsExample();
- answer = dao.selectByExample(example);
- assertEquals(1, answer.size());
+ 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.setLastname("J%");
+ example.setLastname_Indicator(PkfieldsExample.EXAMPLE_LIKE);
+ 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 = (PkfieldsDAO) daoManager.getDao(PkfieldsDAO.class);
-
- 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());
+ 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 testPKFieldsSelectByExample() {
- PkfieldsDAO dao = (PkfieldsDAO) daoManager.getDao(PkfieldsDAO.class);
-
- 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.setId1(new Integer(3));
- example.setId1_Indicator(PkfieldsExample.EXAMPLE_EQUALS);
- example.setId2(new Integer(4));
- example.setId2_Indicator(PkfieldsExample.EXAMPLE_EQUALS);
-
- List answer = dao.selectByExample(example);
-
- assertEquals(1, answer.size());
-
- Pkfields newRecord = (Pkfields) answer.get(0);
-
- assertNotNull(newRecord);
- assertEquals(record.getFirstname(), newRecord.getFirstname());
- assertEquals(record.getLastname(), newRecord.getLastname());
- assertEquals(record.getId1(), newRecord.getId1());
- assertEquals(record.getId2(), newRecord.getId2());
+ 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.setId1(new Integer(3));
+ example.setId1_Indicator(PkfieldsExample.EXAMPLE_EQUALS);
+ example.setId2(new Integer(4));
+ example.setId2_Indicator(PkfieldsExample.EXAMPLE_EQUALS);
+
+ List answer = dao.selectByExample(example);
+
+ assertEquals(1, answer.size());
+
+ Pkfields newRecord = (Pkfields) answer.get(0);
+
+ 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 testPKFieldsSelectByExampleEscapedFields() {
- PkfieldsDAO dao = (PkfieldsDAO) daoManager.getDao(PkfieldsDAO.class);
-
- Pkfields record = new Pkfields();
- record.setFirstname("Fred");
- record.setLastname("Flintstone");
- record.setId1(1);
- record.setId2(1);
- record.setWierdField(11);
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Wilma");
- record.setLastname("Flintstone");
- record.setId1(1);
- record.setId2(2);
- record.setWierdField(22);
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Pebbles");
- record.setLastname("Flintstone");
- record.setId1(1);
- record.setId2(3);
- record.setWierdField(33);
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Barney");
- record.setLastname("Rubble");
- record.setId1(2);
- record.setId2(1);
- record.setWierdField(44);
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Betty");
- record.setLastname("Rubble");
- record.setId1(2);
- record.setId2(2);
- record.setWierdField(55);
- dao.insert(record);
-
- record = new Pkfields();
- record.setFirstname("Bamm Bamm");
- record.setLastname("Rubble");
- record.setId1(2);
- record.setId2(3);
- record.setWierdField(66);
- dao.insert(record);
-
- PkfieldsExample example = new PkfieldsExample();
- example.setWierdField(40);
- example.setWierdField_Indicator(PkfieldsExample.EXAMPLE_LESS_THAN);
-
- List answer = dao.selectByExample(example);
- assertEquals(3, answer.size());
+ PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfields record = new Pkfields();
+ record.setFirstname("Fred");
+ record.setLastname("Flintstone");
+ record.setId1(1);
+ record.setId2(1);
+ record.setWierdField(11);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Wilma");
+ record.setLastname("Flintstone");
+ record.setId1(1);
+ record.setId2(2);
+ record.setWierdField(22);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Pebbles");
+ record.setLastname("Flintstone");
+ record.setId1(1);
+ record.setId2(3);
+ record.setWierdField(33);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Barney");
+ record.setLastname("Rubble");
+ record.setId1(2);
+ record.setId2(1);
+ record.setWierdField(44);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Betty");
+ record.setLastname("Rubble");
+ record.setId1(2);
+ record.setId2(2);
+ record.setWierdField(55);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Bamm Bamm");
+ record.setLastname("Rubble");
+ record.setId1(2);
+ record.setId2(3);
+ record.setWierdField(66);
+ dao.insert(record);
+
+ PkfieldsExample example = new PkfieldsExample();
+ example.setWierdField(40);
+ example.setWierdField_Indicator(PkfieldsExample.EXAMPLE_LESS_THAN);
+
+ List answer = dao.selectByExample(example);
+ assertEquals(3, answer.size());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
}
-
+
public void testPKBlobsInsert() {
- PkblobsDAO dao = (PkblobsDAO) daoManager.getDao(PkblobsDAO.class);
-
- PkblobsWithBLOBs record = new PkblobsWithBLOBs();
-
- 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());
-
- PkblobsWithBLOBs returnedRecord = (PkblobsWithBLOBs) answer.get(0);
- assertEquals(record.getId(), returnedRecord.getId());
- assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
- assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord.getBlob2()));
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ 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());
+
+ PkblobsWithBLOBs returnedRecord = (PkblobsWithBLOBs) 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 = (PkblobsDAO) daoManager.getDao(PkblobsDAO.class);
-
- PkblobsWithBLOBs record = new PkblobsWithBLOBs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- record = new PkblobsWithBLOBs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- int rows = dao.updateByPrimaryKey(record);
- assertEquals(1, rows);
-
- PkblobsKey key = new PkblobsKey();
- key.setId(new Integer(3));
-
- PkblobsWithBLOBs newRecord = dao.selectByPrimaryKey(key);
-
- assertNotNull(newRecord);
- assertEquals(record.getId(), newRecord.getId());
- assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
- assertTrue(blobsAreEqual(record.getBlob2(), newRecord.getBlob2()));
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(new Integer(3));
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(new Integer(3));
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ int rows = dao.updateByPrimaryKey(record);
+ assertEquals(1, rows);
+
+ PkblobsKey key = new PkblobsKey();
+ key.setId(new Integer(3));
+
+ PkblobsWithBLOBs newRecord = dao.selectByPrimaryKey(key);
+
+ 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 = (PkblobsDAO) daoManager.getDao(PkblobsDAO.class);
-
- PkblobsWithBLOBs record = new PkblobsWithBLOBs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- PkblobsWithBLOBs newRecord = new PkblobsWithBLOBs();
- newRecord.setId(new Integer(3));
- newRecord.setBlob2(generateRandomBlob());
- dao.updateByPrimaryKeySelective(newRecord);
-
- PkblobsKey key = new PkblobsKey();
- key.setId(new Integer(3));
-
- PkblobsWithBLOBs returnedRecord = dao.selectByPrimaryKey(key);
- assertNotNull(returnedRecord);
- assertEquals(record.getId(), returnedRecord.getId());
- assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
- assertTrue(blobsAreEqual(newRecord.getBlob2(), returnedRecord.getBlob2()));
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(new Integer(3));
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsWithBLOBs newRecord = new PkblobsWithBLOBs();
+ newRecord.setId(new Integer(3));
+ newRecord.setBlob2(generateRandomBlob());
+ dao.updateByPrimaryKeySelective(newRecord);
+
+ PkblobsKey key = new PkblobsKey();
+ key.setId(new Integer(3));
+
+ PkblobsWithBLOBs returnedRecord = dao.selectByPrimaryKey(key);
+ 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 = (PkblobsDAO) daoManager.getDao(PkblobsDAO.class);
-
- PkblobsWithBLOBs record = new PkblobsWithBLOBs();
-
- 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());
-
- PkblobsKey key = new PkblobsKey();
- key.setId(new Integer(3));
- int rows = dao.deleteByPrimaryKey(key);
- assertEquals(1, rows);
-
- example = new PkblobsExample();
- answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(0, answer.size());
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ 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());
+
+ PkblobsKey key = new PkblobsKey();
+ key.setId(new Integer(3));
+ int rows = dao.deleteByPrimaryKey(key);
+ 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 = (PkblobsDAO) daoManager.getDao(PkblobsDAO.class);
-
- PkblobsWithBLOBs record = new PkblobsWithBLOBs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- record = new PkblobsWithBLOBs();
- 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.setId(new Integer(4));
- example.setId_Indicator(PkblobsExample.EXAMPLE_LESS_THAN);
- int rows = dao.deleteByExample(example);
- assertEquals(1, rows);
-
- example = new PkblobsExample();
- answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(1, answer.size());
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(new Integer(3));
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ 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.setId(new Integer(4));
+ example.setId_Indicator(PkblobsExample.EXAMPLE_LESS_THAN);
+ 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 = (PkblobsDAO) daoManager.getDao(PkblobsDAO.class);
-
- PkblobsWithBLOBs record = new PkblobsWithBLOBs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- record = new PkblobsWithBLOBs();
- record.setId(new Integer(6));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- PkblobsKey key = new PkblobsKey();
- key.setId(new Integer(6));
- PkblobsWithBLOBs newRecord = dao.selectByPrimaryKey(key);
- assertNotNull(newRecord);
- assertEquals(record.getId(), newRecord.getId());
- assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
- assertTrue(blobsAreEqual(record.getBlob2(), newRecord.getBlob2()));
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(new Integer(3));
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(new Integer(6));
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsKey key = new PkblobsKey();
+ key.setId(new Integer(6));
+ PkblobsWithBLOBs newRecord = dao.selectByPrimaryKey(key);
+ 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 = (PkblobsDAO) daoManager.getDao(PkblobsDAO.class);
-
- PkblobsWithBLOBs record = new PkblobsWithBLOBs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- record = new PkblobsWithBLOBs();
- record.setId(new Integer(6));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- PkblobsExample example = new PkblobsExample();
- example.setId(new Integer(4));
- example.setId_Indicator(PkblobsExample.EXAMPLE_GREATER_THAN);
- List answer = dao.selectByExampleWithoutBLOBs(example);
-
- assertEquals(1, answer.size());
-
- PkblobsKey key = (PkblobsKey) answer.get(0);
- assertFalse(key instanceof PkblobsWithBLOBs);
- assertEquals(6, key.getId().intValue());
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(new Integer(3));
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(new Integer(6));
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsExample example = new PkblobsExample();
+ example.setId(new Integer(4));
+ example.setId_Indicator(PkblobsExample.EXAMPLE_GREATER_THAN);
+ List answer = dao.selectByExampleWithoutBLOBs(example);
+
+ assertEquals(1, answer.size());
+
+ PkblobsKey key = (PkblobsKey) answer.get(0);
+ assertFalse(key instanceof PkblobsWithBLOBs);
+ assertEquals(6, key.getId().intValue());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
}
-
+
public void testPKBlobsSelectByExampleWithBlobs() {
- PkblobsDAO dao = (PkblobsDAO) daoManager.getDao(PkblobsDAO.class);
-
- PkblobsWithBLOBs record = new PkblobsWithBLOBs();
- record.setId(new Integer(3));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- record = new PkblobsWithBLOBs();
- record.setId(new Integer(6));
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
- PkblobsExample example = new PkblobsExample();
- example.setId(new Integer(4));
- example.setId_Indicator(PkblobsExample.EXAMPLE_GREATER_THAN);
- List answer = dao.selectByExampleWithBLOBs(example);
-
- assertEquals(1, answer.size());
-
- PkblobsWithBLOBs newRecord = (PkblobsWithBLOBs) answer.get(0);
- assertEquals(record.getId(), newRecord.getId());
- assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
- assertTrue(blobsAreEqual(record.getBlob2(), newRecord.getBlob2()));
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(new Integer(3));
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(new Integer(6));
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsExample example = new PkblobsExample();
+ example.setId(new Integer(4));
+ example.setId_Indicator(PkblobsExample.EXAMPLE_GREATER_THAN);
+ List answer = dao.selectByExampleWithBLOBs(example);
+
+ assertEquals(1, answer.size());
+
+ PkblobsWithBLOBs newRecord = (PkblobsWithBLOBs) 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 testPKFieldsBlobsInsert() {
- PkfieldsblobsDAO dao = (PkfieldsblobsDAO) daoManager.getDao(PkfieldsblobsDAO.class);
-
- PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
- 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());
-
- PkfieldsblobsWithBLOBs returnedRecord = (PkfieldsblobsWithBLOBs) 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()));
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ 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());
+
+ PkfieldsblobsWithBLOBs returnedRecord = (PkfieldsblobsWithBLOBs) 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 = (PkfieldsblobsDAO) daoManager.getDao(PkfieldsblobsDAO.class);
-
- PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- PkfieldsblobsWithBLOBs updateRecord = new PkfieldsblobsWithBLOBs();
- updateRecord.setId1(new Integer(3));
- updateRecord.setId2(new Integer(4));
- updateRecord.setFirstname("Scott");
- updateRecord.setLastname("Jones");
- updateRecord.setBlob1(generateRandomBlob());
-
- int rows = dao.updateByPrimaryKey(updateRecord);
- assertEquals(1, rows);
-
- PkfieldsblobsKey key = new PkfieldsblobsKey();
- key.setId1(new Integer(3));
- key.setId2(new Integer(4));
- PkfieldsblobsWithBLOBs 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()));
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(new Integer(3));
+ record.setId2(new Integer(4));
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsWithBLOBs updateRecord = new PkfieldsblobsWithBLOBs();
+ updateRecord.setId1(new Integer(3));
+ updateRecord.setId2(new Integer(4));
+ updateRecord.setFirstname("Scott");
+ updateRecord.setLastname("Jones");
+ updateRecord.setBlob1(generateRandomBlob());
+
+ int rows = dao.updateByPrimaryKey(updateRecord);
+ assertEquals(1, rows);
+
+ PkfieldsblobsKey key = new PkfieldsblobsKey();
+ key.setId1(new Integer(3));
+ key.setId2(new Integer(4));
+ PkfieldsblobsWithBLOBs 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 = (PkfieldsblobsDAO) daoManager.getDao(PkfieldsblobsDAO.class);
-
- PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
- 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.updateByPrimaryKey(updateRecord);
- assertEquals(1, rows);
-
- PkfieldsblobsKey key = new PkfieldsblobsKey();
- key.setId1(new Integer(3));
- key.setId2(new Integer(4));
- PkfieldsblobsWithBLOBs 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()));
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ 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.updateByPrimaryKey(updateRecord);
+ assertEquals(1, rows);
+
+ PkfieldsblobsKey key = new PkfieldsblobsKey();
+ key.setId1(new Integer(3));
+ key.setId2(new Integer(4));
+ PkfieldsblobsWithBLOBs 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 = (PkfieldsblobsDAO) daoManager.getDao(PkfieldsblobsDAO.class);
-
- PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- PkfieldsblobsWithBLOBs updateRecord = new PkfieldsblobsWithBLOBs();
- 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));
- PkfieldsblobsWithBLOBs 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()));
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(new Integer(3));
+ record.setId2(new Integer(4));
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsWithBLOBs updateRecord = new PkfieldsblobsWithBLOBs();
+ 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));
+ PkfieldsblobsWithBLOBs 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 = (PkfieldsblobsDAO) daoManager.getDao(PkfieldsblobsDAO.class);
-
- PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- record = new PkfieldsblobsWithBLOBs();
- 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());
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(new Integer(3));
+ record.setId2(new Integer(4));
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ 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 = (PkfieldsblobsDAO) daoManager.getDao(PkfieldsblobsDAO.class);
-
- PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- record = new PkfieldsblobsWithBLOBs();
- 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.setId1(new Integer(3));
- example.setId1_Indicator(PkfieldsblobsExample.EXAMPLE_NOT_EQUALS);
- int rows = dao.deleteByExample(example);
- assertEquals(1, rows);
-
- example = new PkfieldsblobsExample();
- answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(1, answer.size());
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(new Integer(3));
+ record.setId2(new Integer(4));
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ 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.setId1(new Integer(3));
+ example.setId1_Indicator(PkfieldsblobsExample.EXAMPLE_NOT_EQUALS);
+ 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 = (PkfieldsblobsDAO) daoManager.getDao(PkfieldsblobsDAO.class);
-
- PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- record = new PkfieldsblobsWithBLOBs();
- 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));
- PkfieldsblobsWithBLOBs 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()));
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(new Integer(3));
+ record.setId2(new Integer(4));
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ 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));
+ PkfieldsblobsWithBLOBs 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 = (PkfieldsblobsDAO) daoManager.getDao(PkfieldsblobsDAO.class);
-
- PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- record = new PkfieldsblobsWithBLOBs();
- 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.setId2(new Integer(6));
- example.setId2_Indicator(PkfieldsblobsExample.EXAMPLE_EQUALS);
- List answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(1, answer.size());
-
- Pkfieldsblobs newRecord = (Pkfieldsblobs) answer.get(0);
- assertFalse(newRecord instanceof PkfieldsblobsWithBLOBs);
- assertEquals(record.getId1(), newRecord.getId1());
- assertEquals(record.getId2(), newRecord.getId2());
- assertEquals(record.getFirstname(), newRecord.getFirstname());
- assertEquals(record.getLastname(), newRecord.getLastname());
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(new Integer(3));
+ record.setId2(new Integer(4));
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ 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.setId2(new Integer(6));
+ example.setId2_Indicator(PkfieldsblobsExample.EXAMPLE_EQUALS);
+ List answer = dao.selectByExampleWithoutBLOBs(example);
+ assertEquals(1, answer.size());
+
+ Pkfieldsblobs newRecord = (Pkfieldsblobs) answer.get(0);
+ assertFalse(newRecord instanceof PkfieldsblobsWithBLOBs);
+ assertEquals(record.getId1(), newRecord.getId1());
+ assertEquals(record.getId2(), newRecord.getId2());
+ assertEquals(record.getFirstname(), newRecord.getFirstname());
+ assertEquals(record.getLastname(), newRecord.getLastname());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
}
-
+
public void testPKFieldsBlobsSelectByExampleWithBlobs() {
- PkfieldsblobsDAO dao = (PkfieldsblobsDAO) daoManager.getDao(PkfieldsblobsDAO.class);
-
- PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
- record.setId1(new Integer(3));
- record.setId2(new Integer(4));
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- dao.insert(record);
-
- record = new PkfieldsblobsWithBLOBs();
- 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.setId2(new Integer(6));
- example.setId2_Indicator(PkfieldsblobsExample.EXAMPLE_EQUALS);
- List answer = dao.selectByExampleWithBLOBs(example);
- assertEquals(1, answer.size());
-
- PkfieldsblobsWithBLOBs newRecord = (PkfieldsblobsWithBLOBs) 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()));
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(new Integer(3));
+ record.setId2(new Integer(4));
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ 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.setId2(new Integer(6));
+ example.setId2_Indicator(PkfieldsblobsExample.EXAMPLE_EQUALS);
+ List answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ PkfieldsblobsWithBLOBs newRecord = (PkfieldsblobsWithBLOBs) 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 testFieldsBlobsInsert() {
- FieldsblobsDAO dao = (FieldsblobsDAO) daoManager.getDao(FieldsblobsDAO.class);
-
- 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()));
+ 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 = (FieldsblobsDAO) daoManager.getDao(FieldsblobsDAO.class);
-
- 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.setFirstname("S%");
- example.setFirstname_Indicator(FieldsblobsExample.EXAMPLE_LIKE);
- int rows = dao.deleteByExample(example);
- assertEquals(1, rows);
-
- example = new FieldsblobsExample();
- answer = dao.selectByExampleWithoutBLOBs(example);
- assertEquals(1, answer.size());
+ 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.setFirstname("S%");
+ example.setFirstname_Indicator(FieldsblobsExample.EXAMPLE_LIKE);
+ 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 = (FieldsblobsDAO) daoManager.getDao(FieldsblobsDAO.class);
-
- FieldsblobsWithBLOBs record = new FieldsblobsWithBLOBs();
- record.setFirstname("Jeff");
- record.setLastname("Smith");
- record.setBlob1(generateRandomBlob());
- record.setBlob2(generateRandomBlob());
- dao.insert(record);
-
[... 113 lines stripped ...]