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 2006/08/16 04:32:12 UTC

svn commit: r431771 [10/11] - in /ibatis/trunk/java/mapper/mapper2/tools/abator/core: build/ devlib/ src/org/apache/ibatis/abator/ant/ src/org/apache/ibatis/abator/api/ src/org/apache/ibatis/abator/config/xml/ src/org/apache/ibatis/abator/exception/ sr...

Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/hierarchical/legacy/HierarchicalLegacyTests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/hierarchical/legacy/HierarchicalLegacyTests.java?rev=431771&view=auto
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/hierarchical/legacy/HierarchicalLegacyTests.java (added)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/hierarchical/legacy/HierarchicalLegacyTests.java Tue Aug 15 19:32:09 2006
@@ -0,0 +1,1073 @@
+/*
+ *  Copyright 2006 The Apache Software Foundation
+ *
+ *  Licensed under the Apache License, Version 2.0 (the "License");
+ *  you may not use this file except in compliance with the License.
+ *  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ *  Unless required by applicable law or agreed to in writing, software
+ *  distributed under the License is distributed on an "AS IS" BASIS,
+ *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ *  See the License for the specific language governing permissions and
+ *  limitations under the License.
+ */
+
+package abatortest.execute.hierarchical.legacy;
+
+import java.math.BigDecimal;
+import java.util.Date;
+import java.util.List;
+
+import abatortest.BaseTest;
+import abatortest.generated.hierarchical.legacy.dao.FieldsblobsDAO;
+import abatortest.generated.hierarchical.legacy.dao.FieldsonlyDAO;
+import abatortest.generated.hierarchical.legacy.dao.PkblobsDAO;
+import abatortest.generated.hierarchical.legacy.dao.PkfieldsDAO;
+import abatortest.generated.hierarchical.legacy.dao.PkfieldsblobsDAO;
+import abatortest.generated.hierarchical.legacy.dao.PkonlyDAO;
+import abatortest.generated.hierarchical.legacy.model.Fieldsblobs;
+import abatortest.generated.hierarchical.legacy.model.FieldsblobsExample;
+import abatortest.generated.hierarchical.legacy.model.FieldsblobsWithBLOBs;
+import abatortest.generated.hierarchical.legacy.model.Fieldsonly;
+import abatortest.generated.hierarchical.legacy.model.FieldsonlyExample;
+import abatortest.generated.hierarchical.legacy.model.PkblobsExample;
+import abatortest.generated.hierarchical.legacy.model.PkblobsKey;
+import abatortest.generated.hierarchical.legacy.model.PkblobsWithBLOBs;
+import abatortest.generated.hierarchical.legacy.model.Pkfields;
+import abatortest.generated.hierarchical.legacy.model.PkfieldsExample;
+import abatortest.generated.hierarchical.legacy.model.PkfieldsKey;
+import abatortest.generated.hierarchical.legacy.model.Pkfieldsblobs;
+import abatortest.generated.hierarchical.legacy.model.PkfieldsblobsExample;
+import abatortest.generated.hierarchical.legacy.model.PkfieldsblobsKey;
+import abatortest.generated.hierarchical.legacy.model.PkfieldsblobsWithBLOBs;
+import abatortest.generated.hierarchical.legacy.model.PkonlyExample;
+import abatortest.generated.hierarchical.legacy.model.PkonlyKey;
+
+/**
+ * @author Jeff Butler
+ *
+ */
+public class HierarchicalLegacyTests extends BaseTest {
+
+    protected void setUp() throws Exception {
+        super.setUp();
+        initDaoManager("abatortest/execute/hierarchical/legacy/dao.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());
+    }
+    
+    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());
+        
+    }
+    
+    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());
+    }
+    
+    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());
+    }
+    
+    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());
+    }
+    
+    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());
+    }
+    
+    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());
+    }
+    
+    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());
+    }
+
+    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());
+    }
+
+    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());
+    }
+
+    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());
+    }
+
+    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());
+    }
+    
+    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());
+    }
+    
+    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());
+    }
+    
+    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()));
+    }
+    
+    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()));
+    }
+    
+    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()));
+    }
+    
+    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());
+    }
+    
+    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());
+    }
+    
+    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()));
+    }
+    
+    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());
+    }
+    
+    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()));
+    }
+    
+    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()));
+    }
+    
+    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()));
+    }
+    
+    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()));
+    }
+    
+    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()));
+    }
+    
+    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());
+    }
+    
+    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());
+    }
+    
+    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()));
+    }
+    
+    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());
+    }
+    
+    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()));
+    }
+
+    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()));
+    }
+    
+    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());
+    }
+    
+    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);
+        
+        record = new FieldsblobsWithBLOBs();
+        record.setFirstname("Scott");
+        record.setLastname("Jones");
+        record.setBlob1(generateRandomBlob());
+        record.setBlob2(generateRandomBlob());
+        dao.insert(record);
+        
+        FieldsblobsExample example = new FieldsblobsExample();
+        example.setFirstname("S%");
+        example.setFirstname_Indicator(FieldsblobsExample.EXAMPLE_LIKE);
+        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());
+    }
+    
+    public void testFieldsBlobsSelectByExampleWithBlobs() {
+        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();
+        example.setFirstname("S%");
+        example.setFirstname_Indicator(FieldsblobsExample.EXAMPLE_LIKE);
+        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()));
+    }
+}

Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/hierarchical/legacy/SqlMapConfig.xml
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/hierarchical/legacy/SqlMapConfig.xml?rev=431771&view=auto
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/hierarchical/legacy/SqlMapConfig.xml (added)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/hierarchical/legacy/SqlMapConfig.xml Tue Aug 15 19:32:09 2006
@@ -0,0 +1,27 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE sqlMapConfig
+  PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
+  "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
+
+<sqlMapConfig>
+
+  <settings useStatementNamespaces="true" />
+
+  <transactionManager type="JDBC">
+    <dataSource type="SIMPLE">
+      <property name="JDBC.Driver" value="org.hsqldb.jdbcDriver"/>
+      <property name="JDBC.ConnectionURL" value="jdbc:hsqldb:mem:aname"/>
+      <property name="JDBC.Username" value="sa"/>
+      <property name="JDBC.Password" value=""/>
+      <property name="JDBC.DefaultAutoCommit" value="true"/>
+    </dataSource>
+  </transactionManager>
+
+  <sqlMap resource="abatortest/generated/hierarchical/legacy/xml/FIELDSBLOBS_SqlMap.xml" />
+  <sqlMap resource="abatortest/generated/hierarchical/legacy/xml/FIELDSONLY_SqlMap.xml" />
+  <sqlMap resource="abatortest/generated/hierarchical/legacy/xml/PKBLOBS_SqlMap.xml" />
+  <sqlMap resource="abatortest/generated/hierarchical/legacy/xml/PKFIELDS_SqlMap.xml" />
+  <sqlMap resource="abatortest/generated/hierarchical/legacy/xml/PKFIELDSBLOBS_SqlMap.xml" />
+  <sqlMap resource="abatortest/generated/hierarchical/legacy/xml/PKONLY_SqlMap.xml" />
+
+</sqlMapConfig>

Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/hierarchical/legacy/dao.xml
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/hierarchical/legacy/dao.xml?rev=431771&view=auto
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/hierarchical/legacy/dao.xml (added)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/hierarchical/legacy/dao.xml Tue Aug 15 19:32:09 2006
@@ -0,0 +1,31 @@
+<!DOCTYPE daoConfig
+  PUBLIC "-//ibatis.apache.org//DTD DAO Configuration 2.0//EN"
+  "http://www.ibatis.com/dtd/dao-2.dtd">
+
+<daoConfig>
+  <context>
+    <transactionManager type="SQLMAP">
+      <property name="SqlMapConfigResource" 
+                value="abatortest/execute/hierarchical/legacy/SqlMapConfig.xml"/>
+    </transactionManager>
+
+    <dao interface="abatortest.generated.hierarchical.legacy.dao.FieldsblobsDAO" 
+         implementation="abatortest.generated.hierarchical.legacy.dao.FieldsblobsDAOImpl" />
+
+    <dao interface="abatortest.generated.hierarchical.legacy.dao.FieldsonlyDAO" 
+         implementation="abatortest.generated.hierarchical.legacy.dao.FieldsonlyDAOImpl" />
+
+    <dao interface="abatortest.generated.hierarchical.legacy.dao.PkblobsDAO" 
+         implementation="abatortest.generated.hierarchical.legacy.dao.PkblobsDAOImpl" />
+
+    <dao interface="abatortest.generated.hierarchical.legacy.dao.PkfieldsblobsDAO" 
+         implementation="abatortest.generated.hierarchical.legacy.dao.PkfieldsblobsDAOImpl" />
+
+    <dao interface="abatortest.generated.hierarchical.legacy.dao.PkfieldsDAO" 
+         implementation="abatortest.generated.hierarchical.legacy.dao.PkfieldsDAOImpl" />
+
+    <dao interface="abatortest.generated.hierarchical.legacy.dao.PkonlyDAO" 
+         implementation="abatortest.generated.hierarchical.legacy.dao.PkonlyDAOImpl" />
+  </context>
+
+</daoConfig>

Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/BaseClass.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/BaseClass.java?rev=431771&view=auto
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/BaseClass.java (added)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/BaseClass.java Tue Aug 15 19:32:09 2006
@@ -0,0 +1,28 @@
+/*
+ *  Copyright 2006 The Apache Software Foundation
+ *
+ *  Licensed under the Apache License, Version 2.0 (the "License");
+ *  you may not use this file except in compliance with the License.
+ *  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ *  Unless required by applicable law or agreed to in writing, software
+ *  distributed under the License is distributed on an "AS IS" BASIS,
+ *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ *  See the License for the specific language governing permissions and
+ *  limitations under the License.
+ */
+package abatortest.execute.miscellaneous;
+
+/**
+ * @author Jeff Butler
+ */
+public class BaseClass {
+    /**
+     * 
+     */
+    public BaseClass() {
+        super();
+    }
+}

Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/BaseInterface.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/BaseInterface.java?rev=431771&view=auto
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/BaseInterface.java (added)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/BaseInterface.java Tue Aug 15 19:32:09 2006
@@ -0,0 +1,23 @@
+/*
+ *  Copyright 2006 The Apache Software Foundation
+ *
+ *  Licensed under the Apache License, Version 2.0 (the "License");
+ *  you may not use this file except in compliance with the License.
+ *  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ *  Unless required by applicable law or agreed to in writing, software
+ *  distributed under the License is distributed on an "AS IS" BASIS,
+ *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ *  See the License for the specific language governing permissions and
+ *  limitations under the License.
+ */
+package abatortest.execute.miscellaneous;
+
+/**
+ * @author Jeff Butler
+ */
+public interface BaseInterface {
+
+}

Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/FirstName.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/FirstName.java?rev=431771&view=auto
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/FirstName.java (added)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/FirstName.java Tue Aug 15 19:32:09 2006
@@ -0,0 +1,56 @@
+/*
+ *  Copyright 2006 The Apache Software Foundation
+ *
+ *  Licensed under the Apache License, Version 2.0 (the "License");
+ *  you may not use this file except in compliance with the License.
+ *  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ *  Unless required by applicable law or agreed to in writing, software
+ *  distributed under the License is distributed on an "AS IS" BASIS,
+ *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ *  See the License for the specific language governing permissions and
+ *  limitations under the License.
+ */
+
+package abatortest.execute.miscellaneous;
+
+/**
+ * @author Jeff Butler
+ *
+ */
+public class FirstName {
+
+    private String value;
+    
+    /**
+     * 
+     */
+    public FirstName() {
+        super();
+    }
+
+    public String getValue() {
+        return value;
+    }
+
+    public void setValue(String value) {
+        this.value = value;
+    }
+
+    @Override
+    public boolean equals(Object arg0) {
+        if (arg0 == null) {
+            return false;
+        }
+        
+        return value.equals(((FirstName)arg0).getValue());
+    }
+
+    @Override
+    public int hashCode() {
+        return value == null ? 0 : value.hashCode();
+    }
+
+}

Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/FirstNameTypeHandler.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/FirstNameTypeHandler.java?rev=431771&view=auto
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/FirstNameTypeHandler.java (added)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/FirstNameTypeHandler.java Tue Aug 15 19:32:09 2006
@@ -0,0 +1,71 @@
+/*
+ *  Copyright 2006 The Apache Software Foundation
+ *
+ *  Licensed under the Apache License, Version 2.0 (the "License");
+ *  you may not use this file except in compliance with the License.
+ *  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ *  Unless required by applicable law or agreed to in writing, software
+ *  distributed under the License is distributed on an "AS IS" BASIS,
+ *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ *  See the License for the specific language governing permissions and
+ *  limitations under the License.
+ */
+
+package abatortest.execute.miscellaneous;
+
+import java.sql.SQLException;
+import java.sql.Types;
+
+import com.ibatis.sqlmap.client.extensions.ParameterSetter;
+import com.ibatis.sqlmap.client.extensions.ResultGetter;
+import com.ibatis.sqlmap.client.extensions.TypeHandlerCallback;
+
+/**
+ * @author Jeff Butler
+ *
+ */
+public class FirstNameTypeHandler implements TypeHandlerCallback {
+
+    /**
+     * 
+     */
+    public FirstNameTypeHandler() {
+        super();
+    }
+
+    /* (non-Javadoc)
+     * @see com.ibatis.sqlmap.client.extensions.TypeHandlerCallback#setParameter(com.ibatis.sqlmap.client.extensions.ParameterSetter, java.lang.Object)
+     */
+    public void setParameter(ParameterSetter arg0, Object arg1)
+            throws SQLException {
+        if (arg1 == null) {
+            arg0.setNull(Types.VARCHAR);
+        } else {
+            arg0.setString(((FirstName) arg1).getValue());
+        }
+    }
+
+    /* (non-Javadoc)
+     * @see com.ibatis.sqlmap.client.extensions.TypeHandlerCallback#getResult(com.ibatis.sqlmap.client.extensions.ResultGetter)
+     */
+    public Object getResult(ResultGetter arg0) throws SQLException {
+        return valueOf(arg0.getString());
+    }
+
+    /* (non-Javadoc)
+     * @see com.ibatis.sqlmap.client.extensions.TypeHandlerCallback#valueOf(java.lang.String)
+     */
+    public Object valueOf(String arg0) {
+        if (arg0 == null) {
+            return null;
+        } else {
+            FirstName answer = new FirstName();
+            answer.setValue(arg0);
+            return answer;
+        }
+    }
+
+}

Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/MiscellaneousTests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/MiscellaneousTests.java?rev=431771&view=auto
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/MiscellaneousTests.java (added)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/MiscellaneousTests.java Tue Aug 15 19:32:09 2006
@@ -0,0 +1,670 @@
+/*
+ *  Copyright 2006 The Apache Software Foundation
+ *
+ *  Licensed under the Apache License, Version 2.0 (the "License");
+ *  you may not use this file except in compliance with the License.
+ *  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ *  Unless required by applicable law or agreed to in writing, software
+ *  distributed under the License is distributed on an "AS IS" BASIS,
+ *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ *  See the License for the specific language governing permissions and
+ *  limitations under the License.
+ */
+
+package abatortest.execute.miscellaneous;
+
+import java.util.ArrayList;
+import java.util.Date;
+import java.util.List;
+
+import abatortest.BaseTest;
+import abatortest.generated.miscellaneous.dao.MyObjectDAO;
+import abatortest.generated.miscellaneous.model.MyObject;
+import abatortest.generated.miscellaneous.model.MyObjectExample;
+import abatortest.generated.miscellaneous.model.MyObjectKey;
+
+/**
+ * @author Jeff Butler
+ *
+ */
+public class MiscellaneousTests extends BaseTest {
+
+    protected void setUp() throws Exception {
+        super.setUp();
+        initDaoManager("abatortest/execute/miscellaneous/dao.xml", null);
+    }
+    
+    public void testMyObjectinsertMyObject() {
+        MyObjectDAO dao = (MyObjectDAO) daoManager.getDao(MyObjectDAO.class);
+        
+        MyObject record = new MyObject();
+        record.setStartDate(new Date());
+        record.setDecimal100field(new Long(10L));
+        record.setDecimal155field(new Double(15.12345));
+        record.setDecimal60field(new Integer(6));
+        FirstName fn = new FirstName();
+        fn.setValue("Jeff");
+        record.setFirstname(fn);
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(2));
+        record.setLastname("Butler");
+        
+        MyTime myTime = new MyTime();
+        myTime.setHours(12);
+        myTime.setMinutes(34);
+        myTime.setSeconds(05);
+        record.setTimefield(myTime);
+        record.setTimestampfield(new Date());
+        
+        dao.insertMyObject(record);
+        
+        MyObjectKey key = new MyObjectKey();
+        key.setId1(new Integer(1));
+        key.setId2(new Integer(2));
+        
+        MyObject returnedRecord = dao.selectMyObjectByPrimaryKey(key);
+        assertNotNull(returnedRecord);
+        
+        assertTrue(datesAreEqual(record.getStartDate(), returnedRecord.getStartDate()));
+        assertEquals(record.getDecimal100field(), returnedRecord.getDecimal100field());
+        assertEquals(record.getDecimal155field(), returnedRecord.getDecimal155field());
+        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());
+        assertEquals(record.getTimefield(), returnedRecord.getTimefield());
+        assertEquals(record.getTimestampfield(), returnedRecord.getTimestampfield());
+    }
+
+    public void testMyObjectUpdateByPrimaryKey() {
+        MyObjectDAO dao = (MyObjectDAO) daoManager.getDao(MyObjectDAO.class);
+        
+        MyObject record = new MyObject();
+        FirstName fn = new FirstName();
+        fn.setValue("Jeff");
+        record.setFirstname(fn);
+        record.setLastname("Smith");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(2));
+        
+        dao.insertMyObject(record);
+
+        fn = new FirstName();
+        fn.setValue("Scott");
+        record.setFirstname(fn);
+        record.setLastname("Jones");
+        
+        int rows = dao.updateMyObjectByPrimaryKey(record);
+        assertEquals(1, rows);
+        
+        MyObjectKey key = new MyObjectKey();
+        key.setId1(new Integer(1));
+        key.setId2(new Integer(2));
+        
+        MyObject record2 = dao.selectMyObjectByPrimaryKey(key);
+        
+        assertEquals(record.getFirstname(), record2.getFirstname());
+        assertEquals(record.getLastname(), record2.getLastname());
+        assertEquals(record.getId1(), record2.getId1());
+        assertEquals(record.getId2(), record2.getId2());
+    }
+
+    public void testMyObjectUpdateByPrimaryKeySelective() {
+        MyObjectDAO dao = (MyObjectDAO) daoManager.getDao(MyObjectDAO.class);
+        
+        MyObject record = new MyObject();
+        FirstName fn = new FirstName();
+        fn.setValue("Jeff");
+        record.setFirstname(fn);
+        record.setLastname("Smith");
+        record.setDecimal60field(new Integer(5));
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(2));
+        
+        dao.insertMyObject(record);
+        
+        MyObject newRecord = new MyObject();
+        newRecord.setId1(new Integer(1));
+        newRecord.setId2(new Integer(2));
+        fn = new FirstName();
+        fn.setValue("Scott");
+        newRecord.setFirstname(fn);
+        record.setStartDate(new Date());
+        
+        int rows = dao.updateMyObjectByPrimaryKeySelective(newRecord);
+        assertEquals(1, rows);
+        
+        MyObjectKey key = new MyObjectKey();
+        key.setId1(new Integer(1));
+        key.setId2(new Integer(2));
+        
+        MyObject returnedRecord = dao.selectMyObjectByPrimaryKey(key);
+        
+        assertTrue(datesAreEqual(newRecord.getStartDate(), returnedRecord.getStartDate()));
+        assertEquals(record.getDecimal100field(), returnedRecord.getDecimal100field());
+        assertEquals(record.getDecimal155field(), returnedRecord.getDecimal155field());
+
+        // with columns mapped to primitive types, the column is always updated 
+        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());
+        assertEquals(record.getTimefield(), returnedRecord.getTimefield());
+        assertEquals(record.getTimestampfield(), returnedRecord.getTimestampfield());
+    }
+
+    public void testMyObjectDeleteByPrimaryKey() {
+        MyObjectDAO dao = (MyObjectDAO) daoManager.getDao(MyObjectDAO.class);
+        
+        MyObject record = new MyObject();
+        FirstName fn = new FirstName();
+        fn.setValue("Jeff");
+        record.setFirstname(fn);
+        record.setLastname("Smith");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(2));
+        
+        dao.insertMyObject(record);
+        
+        MyObjectKey key = new MyObjectKey();
+        key.setId1(new Integer(1));
+        key.setId2(new Integer(2));
+        
+        int rows = dao.deleteMyObjectByPrimaryKey(key);
+        assertEquals(1, rows);
+        
+        MyObjectExample example = new MyObjectExample();
+        List answer = dao.selectMyObjectByExample(example);
+        assertEquals(0, answer.size());
+    }
+
+    public void testMyObjectDeleteByExample() {
+        MyObjectDAO dao = (MyObjectDAO) daoManager.getDao(MyObjectDAO.class);
+        
+        MyObject record = new MyObject();
+        FirstName fn = new FirstName();
+        fn.setValue("Jeff");
+        record.setFirstname(fn);
+        record.setLastname("Smith");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(2));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Bob");
+        record.setFirstname(fn);
+        record.setLastname("Jones");
+        record.setId1(new Integer(3));
+        record.setId2(new Integer(4));
+        
+        dao.insertMyObject(record);
+        
+        MyObjectExample example = new MyObjectExample();
+        List answer = dao.selectMyObjectByExample(example);
+        assertEquals(2, answer.size());
+        
+        example = new MyObjectExample();
+        example.createCriteria().andLastnameLike("J%");
+        int rows = dao.deleteMyObjectByExample(example);
+        assertEquals(1, rows);
+        
+        example = new MyObjectExample();
+        answer = dao.selectMyObjectByExample(example);
+        assertEquals(1, answer.size());
+    }
+    
+    public void testMyObjectSelectByPrimaryKey() {
+        MyObjectDAO dao = (MyObjectDAO) daoManager.getDao(MyObjectDAO.class);
+        
+        MyObject record = new MyObject();
+        FirstName fn = new FirstName();
+        fn.setValue("Jeff");
+        record.setFirstname(fn);
+        record.setLastname("Smith");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(2));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Bob");
+        record.setFirstname(fn);
+        record.setLastname("Jones");
+        record.setId1(new Integer(3));
+        record.setId2(new Integer(4));
+        dao.insertMyObject(record);
+        
+        MyObjectKey key = new MyObjectKey();
+        key.setId1(new Integer(3));
+        key.setId2(new Integer(4));
+        MyObject newRecord = dao.selectMyObjectByPrimaryKey(key);
+        
+        assertNotNull(newRecord);
+        assertEquals(record.getFirstname(), newRecord.getFirstname());
+        assertEquals(record.getLastname(), newRecord.getLastname());
+        assertEquals(record.getId1(), newRecord.getId1());
+        assertEquals(record.getId2(), newRecord.getId2());
+    }
+    
+    public void testMyObjectSelectByExampleLike() {
+        MyObjectDAO dao = (MyObjectDAO) daoManager.getDao(MyObjectDAO.class);
+        
+        MyObject record = new MyObject();
+        FirstName fn = new FirstName();
+        fn.setValue("Fred");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(1));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Wilma");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(2));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Pebbles");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(3));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Barney");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(1));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Betty");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(2));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Bamm Bamm");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(3));
+        dao.insertMyObject(record);
+        
+        MyObjectExample example = new MyObjectExample();
+        fn = new FirstName();
+        fn.setValue("B%");
+        example.createCriteria().andFirstnameLike(fn);
+        example.setOrderByClause("ID1, ID2");
+        List answer = dao.selectMyObjectByExample(example);
+        assertEquals(3, answer.size());
+        MyObject returnedRecord = (MyObject) answer.get(0);
+        assertEquals(2, returnedRecord.getId1().intValue());
+        assertEquals(1, returnedRecord.getId2().intValue());
+        returnedRecord = (MyObject) answer.get(1);
+        assertEquals(2, returnedRecord.getId1().intValue());
+        assertEquals(2, returnedRecord.getId2().intValue());
+        returnedRecord = (MyObject) answer.get(2);
+        assertEquals(2, returnedRecord.getId1().intValue());
+        assertEquals(3, returnedRecord.getId2().intValue());
+    }
+    
+    public void testMyObjectSelectByExampleNotLike() {
+        MyObjectDAO dao = (MyObjectDAO) daoManager.getDao(MyObjectDAO.class);
+        
+        MyObject record = new MyObject();
+        FirstName fn = new FirstName();
+        fn.setValue("Fred");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(1));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Wilma");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(2));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Pebbles");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(3));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Barney");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(1));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Betty");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(2));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Bamm Bamm");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(3));
+        dao.insertMyObject(record);
+        
+        MyObjectExample example = new MyObjectExample();
+        fn = new FirstName();
+        fn.setValue("B%");
+        example.createCriteria().andFirstnameNotLike(fn);
+        example.setOrderByClause("ID1, ID2");
+        List answer = dao.selectMyObjectByExample(example);
+        assertEquals(3, answer.size());
+        MyObject returnedRecord = (MyObject) answer.get(0);
+        assertEquals(1, returnedRecord.getId1().intValue());
+        assertEquals(1, returnedRecord.getId2().intValue());
+        returnedRecord = (MyObject) answer.get(1);
+        assertEquals(1, returnedRecord.getId1().intValue());
+        assertEquals(2, returnedRecord.getId2().intValue());
+        returnedRecord = (MyObject) answer.get(2);
+        assertEquals(1, returnedRecord.getId1().intValue());
+        assertEquals(3, returnedRecord.getId2().intValue());
+    }
+    
+    public void testMyObjectSelectByExampleComplexLike() {
+        MyObjectDAO dao = (MyObjectDAO) daoManager.getDao(MyObjectDAO.class);
+        
+        MyObject record = new MyObject();
+        FirstName fn = new FirstName();
+        fn.setValue("Fred");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(1));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Wilma");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(2));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Pebbles");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(3));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Barney");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(1));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Betty");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(2));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Bamm Bamm");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(3));
+        dao.insertMyObject(record);
+        
+        MyObjectExample example = new MyObjectExample();
+        fn = new FirstName();
+        fn.setValue("B%");
+        example.createCriteria().andFirstnameLike(fn)
+            .andId2EqualTo(3);
+        fn = new FirstName();
+        fn.setValue("W%");
+        example.or(example.createCriteria().andFirstnameLike(fn));
+        
+        example.setOrderByClause("ID1, ID2");
+        List answer = dao.selectMyObjectByExample(example);
+        assertEquals(2, answer.size());
+        MyObject returnedRecord = (MyObject) answer.get(0);
+        assertEquals(1, returnedRecord.getId1().intValue());
+        assertEquals(2, returnedRecord.getId2().intValue());
+        returnedRecord = (MyObject) answer.get(1);
+        assertEquals(2, returnedRecord.getId1().intValue());
+        assertEquals(3, returnedRecord.getId2().intValue());
+    }
+    
+    public void testMyObjectSelectByExampleIn() {
+        MyObjectDAO dao = (MyObjectDAO) daoManager.getDao(MyObjectDAO.class);
+        
+        MyObject record = new MyObject();
+        FirstName fn = new FirstName();
+        fn.setValue("Fred");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(1);
+        record.setId2(1);
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Wilma");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(2));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Pebbles");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(3));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Barney");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(1));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Betty");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(2));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Bamm Bamm");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(3));
+        dao.insertMyObject(record);
+        
+        List<Integer> ids = new ArrayList<Integer>();
+        ids.add(1);
+        ids.add(3);
+        
+        MyObjectExample example = new MyObjectExample();
+        example.createCriteria().andId2In(ids);
+        
+        example.setOrderByClause("ID1, ID2");
+        List answer = dao.selectMyObjectByExample(example);
+        assertEquals(4, answer.size());
+        MyObject returnedRecord = (MyObject) answer.get(0);
+        assertEquals(1, returnedRecord.getId1().intValue());
+        assertEquals(1, returnedRecord.getId2().intValue());
+        returnedRecord = (MyObject) answer.get(1);
+        assertEquals(1, returnedRecord.getId1().intValue());
+        assertEquals(3, returnedRecord.getId2().intValue());
+        returnedRecord = (MyObject) answer.get(2);
+        assertEquals(2, returnedRecord.getId1().intValue());
+        assertEquals(1, returnedRecord.getId2().intValue());
+        returnedRecord = (MyObject) answer.get(3);
+        assertEquals(2, returnedRecord.getId1().intValue());
+        assertEquals(3, returnedRecord.getId2().intValue());
+    }
+    
+    public void testMyObjectSelectByExampleBetween() {
+        MyObjectDAO dao = (MyObjectDAO) daoManager.getDao(MyObjectDAO.class);
+        
+        MyObject record = new MyObject();
+        FirstName fn = new FirstName();
+        fn.setValue("Fred");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(1));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Wilma");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(2));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Pebbles");
+        record.setFirstname(fn);
+        record.setLastname("Flintstone");
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(3));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Barney");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(1));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Betty");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(2));
+        dao.insertMyObject(record);
+        
+        record = new MyObject();
+        fn = new FirstName();
+        fn.setValue("Bamm Bamm");
+        record.setFirstname(fn);
+        record.setLastname("Rubble");
+        record.setId1(new Integer(2));
+        record.setId2(new Integer(3));
+        dao.insertMyObject(record);
+        
+        MyObjectExample example = new MyObjectExample();
+        example.createCriteria().andId2Between(new Integer(1), new Integer(3));
+        
+        example.setOrderByClause("ID1, ID2");
+        List answer = dao.selectMyObjectByExample(example);
+        assertEquals(6, answer.size());
+    }
+
+    public void testMyObjectSelectByExampleTimeEquals() {
+        MyObjectDAO dao = (MyObjectDAO) daoManager.getDao(MyObjectDAO.class);
+        
+        MyObject record = new MyObject();
+        record.setStartDate(new Date());
+        record.setDecimal100field(new Long(10L));
+        record.setDecimal155field(new Double(15.12345));
+        record.setDecimal60field(new Integer(6));
+        FirstName fn = new FirstName();
+        fn.setValue("Jeff");
+        record.setFirstname(fn);
+        record.setId1(new Integer(1));
+        record.setId2(new Integer(2));
+        record.setLastname("Butler");
+        
+        MyTime myTime = new MyTime();
+        myTime.setHours(12);
+        myTime.setMinutes(34);
+        myTime.setSeconds(05);
+        record.setTimefield(myTime);
+        record.setTimestampfield(new Date());
+        
+        dao.insertMyObject(record);
+
+        MyObjectExample example = new MyObjectExample();
+        example.createCriteria().andTimefieldEqualTo(myTime);
+        List<MyObject> results = dao.selectMyObjectByExample(example);
+        assertEquals(1, results.size());
+        MyObject returnedRecord = results.get(0);
+        
+        assertTrue(datesAreEqual(record.getStartDate(), returnedRecord.getStartDate()));
+        assertEquals(record.getDecimal100field(), returnedRecord.getDecimal100field());
+        assertEquals(record.getDecimal155field(), returnedRecord.getDecimal155field());
+        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());
+        assertEquals(record.getTimefield(), returnedRecord.getTimefield());
+        assertEquals(record.getTimestampfield(), returnedRecord.getTimestampfield());
+    }
+}

Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/MyTime.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/MyTime.java?rev=431771&view=auto
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/MyTime.java (added)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/test/abatortest/execute/miscellaneous/MyTime.java Tue Aug 15 19:32:09 2006
@@ -0,0 +1,77 @@
+/*
+ *  Copyright 2006 The Apache Software Foundation
+ *
+ *  Licensed under the Apache License, Version 2.0 (the "License");
+ *  you may not use this file except in compliance with the License.
+ *  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ *  Unless required by applicable law or agreed to in writing, software
+ *  distributed under the License is distributed on an "AS IS" BASIS,
+ *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ *  See the License for the specific language governing permissions and
+ *  limitations under the License.
+ */
+
+package abatortest.execute.miscellaneous;
+
+/**
+ * @author Jeff Butler
+ *
+ */
+public class MyTime {
+    private int hours;
+    private int minutes;
+    private int seconds;
+
+    /**
+     * 
+     */
+    public MyTime() {
+        super();
+    }
+
+    public int getHours() {
+        return hours;
+    }
+
+    public void setHours(int hours) {
+        this.hours = hours;
+    }
+
+    public int getMinutes() {
+        return minutes;
+    }
+
+    public void setMinutes(int minutes) {
+        this.minutes = minutes;
+    }
+
+    public int getSeconds() {
+        return seconds;
+    }
+
+    public void setSeconds(int seconds) {
+        this.seconds = seconds;
+    }
+
+    @Override
+    public boolean equals(Object arg0) {
+        if (arg0 == null) {
+            return false;
+        }
+        
+        MyTime other = (MyTime) arg0;
+        
+        return this.hours == other.hours
+            && this.minutes == other.minutes
+            && this.seconds == other.seconds;
+    }
+
+    @Override
+    public int hashCode() {
+        return hours + minutes + seconds;
+    }
+
+}