Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/CountByExampleTests.java URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/CountByExampleTests.java?rev=579041&view=auto ============================================================================== --- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/CountByExampleTests.java (added) +++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/CountByExampleTests.java Mon Sep 24 19:48:38 2007 @@ -0,0 +1,287 @@ +package abatortest.java2.execute.conditional.java2; + +import java.sql.SQLException; + +import abatortest.java2.BaseTest; +import abatortest.java2.generated.conditional.java2.dao.AwfulTableDAO; +import abatortest.java2.generated.conditional.java2.dao.AwfulTableDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.FieldsblobsDAO; +import abatortest.java2.generated.conditional.java2.dao.FieldsblobsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.FieldsonlyDAO; +import abatortest.java2.generated.conditional.java2.dao.FieldsonlyDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkblobsDAO; +import abatortest.java2.generated.conditional.java2.dao.PkblobsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsDAO; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsblobsDAO; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsblobsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkonlyDAO; +import abatortest.java2.generated.conditional.java2.dao.PkonlyDAOImpl; +import abatortest.java2.generated.conditional.java2.model.AwfulTable; +import abatortest.java2.generated.conditional.java2.model.AwfulTableExample; +import abatortest.java2.generated.conditional.java2.model.FieldsblobsExample; +import abatortest.java2.generated.conditional.java2.model.FieldsblobsWithBLOBs; +import abatortest.java2.generated.conditional.java2.model.Fieldsonly; +import abatortest.java2.generated.conditional.java2.model.FieldsonlyExample; +import abatortest.java2.generated.conditional.java2.model.Pkblobs; +import abatortest.java2.generated.conditional.java2.model.PkblobsExample; +import abatortest.java2.generated.conditional.java2.model.Pkfields; +import abatortest.java2.generated.conditional.java2.model.PkfieldsExample; +import abatortest.java2.generated.conditional.java2.model.Pkfieldsblobs; +import abatortest.java2.generated.conditional.java2.model.PkfieldsblobsExample; +import abatortest.java2.generated.conditional.java2.model.PkonlyExample; +import abatortest.java2.generated.conditional.java2.model.PkonlyKey; + +public class CountByExampleTests extends BaseTest { + + protected void setUp() throws Exception { + super.setUp(); + initSqlMapClient( + "abatortest/java2/execute/conditional/java2/SqlMapConfig.xml", + null); + } + + public void testFieldsOnlyCountByExample() { + FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient); + + try { + Fieldsonly record = new Fieldsonly(); + record.setDoublefield(new Double(11.22)); + record.setFloatfield(new Double(33.44)); + record.setIntegerfield(new Integer(5)); + dao.insert(record); + + record = new Fieldsonly(); + record.setDoublefield(new Double(44.55)); + record.setFloatfield(new Double(66.77)); + record.setIntegerfield(new Integer(8)); + dao.insert(record); + + record = new Fieldsonly(); + record.setDoublefield(new Double(88.99)); + record.setFloatfield(new Double(100.111)); + record.setIntegerfield(new Integer(9)); + dao.insert(record); + + FieldsonlyExample example = new FieldsonlyExample(); + example.createCriteria().andIntegerfieldGreaterThan(new Integer(5)); + + int rows = dao.countByExample(example); + assertEquals(2, rows); + + example.clear(); + rows = dao.countByExample(example); + assertEquals(3, rows); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKOnlyCountByExample() { + PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient); + + try { + PkonlyKey key = new PkonlyKey(); + key.setId(new Integer(1)); + key.setSeqNum(new Integer(3)); + dao.insert(key); + + key = new PkonlyKey(); + key.setId(new Integer(5)); + key.setSeqNum(new Integer(6)); + dao.insert(key); + + key = new PkonlyKey(); + key.setId(new Integer(7)); + key.setSeqNum(new Integer(8)); + dao.insert(key); + + PkonlyExample example = new PkonlyExample(); + example.createCriteria().andIdGreaterThan(new Integer(4)); + int rows = dao.countByExample(example); + assertEquals(2, rows); + + example.clear(); + rows = dao.countByExample(example); + assertEquals(3, rows); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKFieldsBlobsCountByExample() { + PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient); + + try { + Pkfieldsblobs record = new Pkfieldsblobs(); + record.setId1(new Integer(3)); + record.setId2(new Integer(4)); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + dao.insert(record); + + record = new Pkfieldsblobs(); + record.setId1(new Integer(5)); + record.setId2(new Integer(6)); + record.setFirstname("Scott"); + record.setLastname("Jones"); + record.setBlob1(generateRandomBlob()); + dao.insert(record); + + PkfieldsblobsExample example = new PkfieldsblobsExample(); + example.createCriteria().andId1NotEqualTo(new Integer(3)); + int rows = dao.countByExample(example); + assertEquals(1, rows); + + example.clear(); + rows = dao.countByExample(example); + assertEquals(2, rows); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKFieldsCountByExample() { + PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient); + + try { + Pkfields record = new Pkfields(); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setId1(new Integer(1)); + record.setId2(new Integer(2)); + dao.insert(record); + + record = new Pkfields(); + record.setFirstname("Bob"); + record.setLastname("Jones"); + record.setId1(new Integer(3)); + record.setId2(new Integer(4)); + + dao.insert(record); + + PkfieldsExample example = new PkfieldsExample(); + example.createCriteria().andLastnameLike("J%"); + int rows = dao.countByExample(example); + assertEquals(1, rows); + + example.clear(); + rows = dao.countByExample(example); + assertEquals(2, rows); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKBlobsCountByExample() { + PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient); + + try { + Pkblobs record = new Pkblobs(); + record.setId(new Integer(3)); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new Pkblobs(); + record.setId(new Integer(6)); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + PkblobsExample example = new PkblobsExample(); + example.createCriteria().andIdLessThan(new Integer(4)); + int rows = dao.countByExample(example); + assertEquals(1, rows); + + example.clear(); + rows = dao.countByExample(example); + assertEquals(2, rows); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testFieldsBlobsCountByExample() { + FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient); + + try { + FieldsblobsWithBLOBs record = new FieldsblobsWithBLOBs(); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new FieldsblobsWithBLOBs(); + record.setFirstname("Scott"); + record.setLastname("Jones"); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + FieldsblobsExample example = new FieldsblobsExample(); + example.createCriteria().andFirstnameLike("S%"); + int rows = dao.countByExample(example); + assertEquals(1, rows); + + example.clear(); + rows = dao.countByExample(example); + assertEquals(2, rows); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testAwfulTableCountByExample() { + AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient); + + try { + AwfulTable record = new AwfulTable(); + record.seteMail("[EMAIL PROTECTED]"); + record.setEmailaddress("[EMAIL PROTECTED]"); + record.setFirstFirstName("fred1"); + record.setFourthFirstName("fred4"); + record.setFrom("from field"); + record.setId1(new Integer(1)); + record.setId2(new Integer(2)); + record.setId5(new Integer(5)); + record.setId6(new Integer(6)); + record.setId7(new Integer(7)); + record.setSecondCustomerId(new Integer(567)); + record.setSecondFirstName("fred2"); + record.setThirdFirstName("fred3"); + + dao.insert(record); + + record = new AwfulTable(); + record.seteMail("[EMAIL PROTECTED]"); + record.setEmailaddress("[EMAIL PROTECTED]"); + record.setFirstFirstName("fred11"); + record.setFourthFirstName("fred44"); + record.setFrom("from from field"); + record.setId1(new Integer(11)); + record.setId2(new Integer(22)); + record.setId5(new Integer(55)); + record.setId6(new Integer(66)); + record.setId7(new Integer(77)); + record.setSecondCustomerId(new Integer(567567)); + record.setSecondFirstName("fred22"); + record.setThirdFirstName("fred33"); + + dao.insert(record); + + AwfulTableExample example = new AwfulTableExample(); + example.createCriteria().andEMailLike("[EMAIL PROTECTED]"); + int rows = dao.countByExample(example); + assertEquals(1, rows); + + example.clear(); + rows = dao.countByExample(example); + assertEquals(2, rows); + } catch (SQLException e) { + fail(e.getMessage()); + } + } +}
Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/DeleteByExampleTests.java URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/DeleteByExampleTests.java?rev=579041&view=auto ============================================================================== --- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/DeleteByExampleTests.java (added) +++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/DeleteByExampleTests.java Mon Sep 24 19:48:38 2007 @@ -0,0 +1,309 @@ +package abatortest.java2.execute.conditional.java2; + +import java.sql.SQLException; +import java.util.List; + +import abatortest.java2.BaseTest; +import abatortest.java2.generated.conditional.java2.dao.AwfulTableDAO; +import abatortest.java2.generated.conditional.java2.dao.AwfulTableDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.FieldsblobsDAO; +import abatortest.java2.generated.conditional.java2.dao.FieldsblobsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.FieldsonlyDAO; +import abatortest.java2.generated.conditional.java2.dao.FieldsonlyDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkblobsDAO; +import abatortest.java2.generated.conditional.java2.dao.PkblobsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsDAO; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsblobsDAO; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsblobsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkonlyDAO; +import abatortest.java2.generated.conditional.java2.dao.PkonlyDAOImpl; +import abatortest.java2.generated.conditional.java2.model.AwfulTable; +import abatortest.java2.generated.conditional.java2.model.AwfulTableExample; +import abatortest.java2.generated.conditional.java2.model.FieldsblobsExample; +import abatortest.java2.generated.conditional.java2.model.FieldsblobsWithBLOBs; +import abatortest.java2.generated.conditional.java2.model.Fieldsonly; +import abatortest.java2.generated.conditional.java2.model.FieldsonlyExample; +import abatortest.java2.generated.conditional.java2.model.Pkblobs; +import abatortest.java2.generated.conditional.java2.model.PkblobsExample; +import abatortest.java2.generated.conditional.java2.model.Pkfields; +import abatortest.java2.generated.conditional.java2.model.PkfieldsExample; +import abatortest.java2.generated.conditional.java2.model.Pkfieldsblobs; +import abatortest.java2.generated.conditional.java2.model.PkfieldsblobsExample; +import abatortest.java2.generated.conditional.java2.model.PkonlyExample; +import abatortest.java2.generated.conditional.java2.model.PkonlyKey; + +public class DeleteByExampleTests extends BaseTest { + + protected void setUp() throws Exception { + super.setUp(); + initSqlMapClient( + "abatortest/java2/execute/conditional/java2/SqlMapConfig.xml", + null); + } + + public void testFieldsOnlyDeleteByExample() { + FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient); + + try { + Fieldsonly record = new Fieldsonly(); + record.setDoublefield(new Double(11.22)); + record.setFloatfield(new Double(33.44)); + record.setIntegerfield(new Integer(5)); + dao.insert(record); + + record = new Fieldsonly(); + record.setDoublefield(new Double(44.55)); + record.setFloatfield(new Double(66.77)); + record.setIntegerfield(new Integer(8)); + dao.insert(record); + + record = new Fieldsonly(); + record.setDoublefield(new Double(88.99)); + record.setFloatfield(new Double(100.111)); + record.setIntegerfield(new Integer(9)); + dao.insert(record); + + FieldsonlyExample example = new FieldsonlyExample(); + example.createCriteria().andIntegerfieldGreaterThan(new Integer(5)); + + int rows = dao.deleteByExample(example); + assertEquals(2, rows); + + example = new FieldsonlyExample(); + List answer = dao.selectByExample(example); + assertEquals(1, answer.size()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKOnlyDeleteByExample() { + PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient); + + try { + PkonlyKey key = new PkonlyKey(); + key.setId(new Integer(1)); + key.setSeqNum(new Integer(3)); + dao.insert(key); + + key = new PkonlyKey(); + key.setId(new Integer(5)); + key.setSeqNum(new Integer(6)); + dao.insert(key); + + key = new PkonlyKey(); + key.setId(new Integer(7)); + key.setSeqNum(new Integer(8)); + dao.insert(key); + + PkonlyExample example = new PkonlyExample(); + example.createCriteria().andIdGreaterThan(new Integer(4)); + int rows = dao.deleteByExample(example); + assertEquals(2, rows); + + example = new PkonlyExample(); + List answer = dao.selectByExample(example); + assertEquals(1, answer.size()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKFieldsDeleteByExample() { + PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient); + + try { + Pkfields record = new Pkfields(); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setId1(new Integer(1)); + record.setId2(new Integer(2)); + dao.insert(record); + + record = new Pkfields(); + record.setFirstname("Bob"); + record.setLastname("Jones"); + record.setId1(new Integer(3)); + record.setId2(new Integer(4)); + + dao.insert(record); + + PkfieldsExample example = new PkfieldsExample(); + List answer = dao.selectByExample(example); + assertEquals(2, answer.size()); + + example = new PkfieldsExample(); + example.createCriteria().andLastnameLike("J%"); + int rows = dao.deleteByExample(example); + assertEquals(1, rows); + + example = new PkfieldsExample(); + answer = dao.selectByExample(example); + assertEquals(1, answer.size()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKBlobsDeleteByExample() { + PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient); + + try { + Pkblobs record = new Pkblobs(); + record.setId(new Integer(3)); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new Pkblobs(); + record.setId(new Integer(6)); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + PkblobsExample example = new PkblobsExample(); + List answer = dao.selectByExampleWithoutBLOBs(example); + assertEquals(2, answer.size()); + + example = new PkblobsExample(); + example.createCriteria().andIdLessThan(new Integer(4)); + int rows = dao.deleteByExample(example); + assertEquals(1, rows); + + example = new PkblobsExample(); + answer = dao.selectByExampleWithoutBLOBs(example); + assertEquals(1, answer.size()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKFieldsBlobsDeleteByExample() { + PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient); + + try { + Pkfieldsblobs record = new Pkfieldsblobs(); + record.setId1(new Integer(3)); + record.setId2(new Integer(4)); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + dao.insert(record); + + record = new Pkfieldsblobs(); + record.setId1(new Integer(5)); + record.setId2(new Integer(6)); + record.setFirstname("Scott"); + record.setLastname("Jones"); + record.setBlob1(generateRandomBlob()); + dao.insert(record); + + PkfieldsblobsExample example = new PkfieldsblobsExample(); + List answer = dao.selectByExampleWithoutBLOBs(example); + assertEquals(2, answer.size()); + + example = new PkfieldsblobsExample(); + example.createCriteria().andId1NotEqualTo(new Integer(3)); + int rows = dao.deleteByExample(example); + assertEquals(1, rows); + + example = new PkfieldsblobsExample(); + answer = dao.selectByExampleWithoutBLOBs(example); + assertEquals(1, answer.size()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testFieldsBlobsDeleteByExample() { + FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient); + + try { + FieldsblobsWithBLOBs record = new FieldsblobsWithBLOBs(); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new FieldsblobsWithBLOBs(); + record.setFirstname("Scott"); + record.setLastname("Jones"); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + FieldsblobsExample example = new FieldsblobsExample(); + List answer = dao.selectByExampleWithoutBLOBs(example); + assertEquals(2, answer.size()); + + example = new FieldsblobsExample(); + example.createCriteria().andFirstnameLike("S%"); + int rows = dao.deleteByExample(example); + assertEquals(1, rows); + + example = new FieldsblobsExample(); + answer = dao.selectByExampleWithoutBLOBs(example); + assertEquals(1, answer.size()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testAwfulTableDeleteByExample() { + AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient); + + try { + AwfulTable record = new AwfulTable(); + record.seteMail("[EMAIL PROTECTED]"); + record.setEmailaddress("[EMAIL PROTECTED]"); + record.setFirstFirstName("fred1"); + record.setFourthFirstName("fred4"); + record.setFrom("from field"); + record.setId1(new Integer(1)); + record.setId2(new Integer(2)); + record.setId5(new Integer(5)); + record.setId6(new Integer(6)); + record.setId7(new Integer(7)); + record.setSecondCustomerId(new Integer(567)); + record.setSecondFirstName("fred2"); + record.setThirdFirstName("fred3"); + + dao.insert(record); + + record = new AwfulTable(); + record.seteMail("[EMAIL PROTECTED]"); + record.setEmailaddress("[EMAIL PROTECTED]"); + record.setFirstFirstName("fred11"); + record.setFourthFirstName("fred44"); + record.setFrom("from from field"); + record.setId1(new Integer(11)); + record.setId2(new Integer(22)); + record.setId5(new Integer(55)); + record.setId6(new Integer(66)); + record.setId7(new Integer(77)); + record.setSecondCustomerId(new Integer(567567)); + record.setSecondFirstName("fred22"); + record.setThirdFirstName("fred33"); + + dao.insert(record); + + AwfulTableExample example = new AwfulTableExample(); + List answer = dao.selectByExample(example); + assertEquals(2, answer.size()); + + example = new AwfulTableExample(); + example.createCriteria().andEMailLike("[EMAIL PROTECTED]"); + int rows = dao.deleteByExample(example); + assertEquals(1, rows); + + example.clear(); + answer = dao.selectByExample(example); + assertEquals(1, answer.size()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + +} Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/DeleteByPrimaryKeyTests.java URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/DeleteByPrimaryKeyTests.java?rev=579041&view=auto ============================================================================== --- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/DeleteByPrimaryKeyTests.java (added) +++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/DeleteByPrimaryKeyTests.java Mon Sep 24 19:48:38 2007 @@ -0,0 +1,192 @@ +package abatortest.java2.execute.conditional.java2; + +import java.sql.SQLException; +import java.util.List; + +import abatortest.java2.BaseTest; +import abatortest.java2.generated.conditional.java2.dao.AwfulTableDAO; +import abatortest.java2.generated.conditional.java2.dao.AwfulTableDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkblobsDAO; +import abatortest.java2.generated.conditional.java2.dao.PkblobsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsDAO; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsblobsDAO; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsblobsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkonlyDAO; +import abatortest.java2.generated.conditional.java2.dao.PkonlyDAOImpl; +import abatortest.java2.generated.conditional.java2.model.AwfulTable; +import abatortest.java2.generated.conditional.java2.model.AwfulTableExample; +import abatortest.java2.generated.conditional.java2.model.Pkblobs; +import abatortest.java2.generated.conditional.java2.model.PkblobsExample; +import abatortest.java2.generated.conditional.java2.model.Pkfields; +import abatortest.java2.generated.conditional.java2.model.PkfieldsExample; +import abatortest.java2.generated.conditional.java2.model.PkfieldsKey; +import abatortest.java2.generated.conditional.java2.model.Pkfieldsblobs; +import abatortest.java2.generated.conditional.java2.model.PkfieldsblobsExample; +import abatortest.java2.generated.conditional.java2.model.PkfieldsblobsKey; +import abatortest.java2.generated.conditional.java2.model.PkonlyExample; +import abatortest.java2.generated.conditional.java2.model.PkonlyKey; + +public class DeleteByPrimaryKeyTests extends BaseTest { + + protected void setUp() throws Exception { + super.setUp(); + initSqlMapClient( + "abatortest/java2/execute/conditional/java2/SqlMapConfig.xml", + null); + } + + public void testPKOnlyDeleteByPrimaryKey() { + PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient); + + try { + PkonlyKey key = new PkonlyKey(); + key.setId(new Integer(1)); + key.setSeqNum(new Integer(3)); + dao.insert(key); + + key = new PkonlyKey(); + key.setId(new Integer(5)); + key.setSeqNum(new Integer(6)); + dao.insert(key); + + PkonlyExample example = new PkonlyExample(); + List answer = dao.selectByExample(example); + assertEquals(2, answer.size()); + + key = new PkonlyKey(); + key.setId(new Integer(5)); + key.setSeqNum(new Integer(6)); + int rows = dao.deleteByPrimaryKey(key); + assertEquals(1, rows); + + answer = dao.selectByExample(example); + assertEquals(1, answer.size()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKfieldsDeleteByPrimaryKey() { + PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient); + + try { + Pkfields record = new Pkfields(); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setId1(new Integer(1)); + record.setId2(new Integer(2)); + + dao.insert(record); + + PkfieldsKey key = new PkfieldsKey(); + key.setId1(new Integer(1)); + key.setId2(new Integer(2)); + + int rows = dao.deleteByPrimaryKey(key); + assertEquals(1, rows); + + PkfieldsExample example = new PkfieldsExample(); + List answer = dao.selectByExample(example); + assertEquals(0, answer.size()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKBlobsDeleteByPrimaryKey() { + PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient); + + try { + Pkblobs record = new Pkblobs(); + record.setId(new Integer(3)); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + PkblobsExample example = new PkblobsExample(); + List answer = dao.selectByExampleWithoutBLOBs(example); + assertEquals(1, answer.size()); + + int rows = dao.deleteByPrimaryKey(new Integer(3)); + assertEquals(1, rows); + + example = new PkblobsExample(); + answer = dao.selectByExampleWithoutBLOBs(example); + assertEquals(0, answer.size()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKFieldsBlobsDeleteByPrimaryKey() { + PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient); + + try { + Pkfieldsblobs record = new Pkfieldsblobs(); + record.setId1(new Integer(3)); + record.setId2(new Integer(4)); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + dao.insert(record); + + record = new Pkfieldsblobs(); + record.setId1(new Integer(5)); + record.setId2(new Integer(6)); + record.setFirstname("Scott"); + record.setLastname("Jones"); + record.setBlob1(generateRandomBlob()); + dao.insert(record); + + PkfieldsblobsExample example = new PkfieldsblobsExample(); + List answer = dao.selectByExampleWithoutBLOBs(example); + assertEquals(2, answer.size()); + + PkfieldsblobsKey key = new PkfieldsblobsKey(); + key.setId1(new Integer(5)); + key.setId2(new Integer(6)); + int rows = dao.deleteByPrimaryKey(key); + assertEquals(1, rows); + + example = new PkfieldsblobsExample(); + answer = dao.selectByExampleWithoutBLOBs(example); + assertEquals(1, answer.size()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testAwfulTableDeleteByPrimaryKey() { + AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient); + + try { + AwfulTable record = new AwfulTable(); + record.seteMail("[EMAIL PROTECTED]"); + record.setEmailaddress("[EMAIL PROTECTED]"); + record.setFirstFirstName("fred1"); + record.setFourthFirstName("fred4"); + record.setFrom("from field"); + record.setId1(new Integer(1)); + record.setId2(new Integer(2)); + record.setId5(new Integer(5)); + record.setId6(new Integer(6)); + record.setId7(new Integer(7)); + record.setSecondCustomerId(new Integer(567)); + record.setSecondFirstName("fred2"); + record.setThirdFirstName("fred3"); + + Integer generatedCustomerId = dao.insert(record); + + int rows = dao.deleteByPrimaryKey(generatedCustomerId); + assertEquals(1, rows); + + AwfulTableExample example = new AwfulTableExample(); + List answer = dao.selectByExample(example); + assertEquals(0, answer.size()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + +} Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/InsertTests.java URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/InsertTests.java?rev=579041&view=auto ============================================================================== --- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/InsertTests.java (added) +++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava2/abatortest/java2/execute/conditional/java2/InsertTests.java Mon Sep 24 19:48:38 2007 @@ -0,0 +1,275 @@ +package abatortest.java2.execute.conditional.java2; + +import java.math.BigDecimal; +import java.sql.SQLException; +import java.util.Date; +import java.util.List; + +import abatortest.java2.BaseTest; +import abatortest.java2.generated.conditional.java2.dao.AwfulTableDAO; +import abatortest.java2.generated.conditional.java2.dao.AwfulTableDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.FieldsblobsDAO; +import abatortest.java2.generated.conditional.java2.dao.FieldsblobsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.FieldsonlyDAO; +import abatortest.java2.generated.conditional.java2.dao.FieldsonlyDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkblobsDAO; +import abatortest.java2.generated.conditional.java2.dao.PkblobsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsDAO; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsblobsDAO; +import abatortest.java2.generated.conditional.java2.dao.PkfieldsblobsDAOImpl; +import abatortest.java2.generated.conditional.java2.dao.PkonlyDAO; +import abatortest.java2.generated.conditional.java2.dao.PkonlyDAOImpl; +import abatortest.java2.generated.conditional.java2.model.AwfulTable; +import abatortest.java2.generated.conditional.java2.model.FieldsblobsExample; +import abatortest.java2.generated.conditional.java2.model.FieldsblobsWithBLOBs; +import abatortest.java2.generated.conditional.java2.model.Fieldsonly; +import abatortest.java2.generated.conditional.java2.model.FieldsonlyExample; +import abatortest.java2.generated.conditional.java2.model.Pkblobs; +import abatortest.java2.generated.conditional.java2.model.PkblobsExample; +import abatortest.java2.generated.conditional.java2.model.Pkfields; +import abatortest.java2.generated.conditional.java2.model.PkfieldsKey; +import abatortest.java2.generated.conditional.java2.model.Pkfieldsblobs; +import abatortest.java2.generated.conditional.java2.model.PkfieldsblobsExample; +import abatortest.java2.generated.conditional.java2.model.PkonlyExample; +import abatortest.java2.generated.conditional.java2.model.PkonlyKey; + +public class InsertTests extends BaseTest { + + protected void setUp() throws Exception { + super.setUp(); + initSqlMapClient( + "abatortest/java2/execute/conditional/java2/SqlMapConfig.xml", + null); + } + + public void testFieldsOnlyInsert() { + FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient); + + try { + Fieldsonly record = new Fieldsonly(); + record.setDoublefield(new Double(11.22)); + record.setFloatfield(new Double(33.44)); + record.setIntegerfield(new Integer(5)); + dao.insert(record); + + FieldsonlyExample example = new FieldsonlyExample(); + example.createCriteria().andIntegerfieldEqualTo(new Integer(5)); + + List answer = dao.selectByExample(example); + assertEquals(1, answer.size()); + + Fieldsonly returnedRecord = (Fieldsonly) answer.get(0); + assertEquals(record.getIntegerfield(), returnedRecord + .getIntegerfield()); + assertEquals(record.getDoublefield(), returnedRecord + .getDoublefield()); + assertEquals(record.getFloatfield(), returnedRecord.getFloatfield()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKOnlyInsert() { + PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient); + + try { + PkonlyKey key = new PkonlyKey(); + key.setId(new Integer(1)); + key.setSeqNum(new Integer(3)); + dao.insert(key); + + PkonlyExample example = new PkonlyExample(); + List answer = dao.selectByExample(example); + assertEquals(1, answer.size()); + + PkonlyKey returnedRecord = (PkonlyKey) answer.get(0); + assertEquals(key.getId(), returnedRecord.getId()); + assertEquals(key.getSeqNum(), returnedRecord.getSeqNum()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKFieldsInsert() { + PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient); + + try { + Pkfields record = new Pkfields(); + record.setDatefield(new Date()); + record.setDecimal100field(new Long(10L)); + record.setDecimal155field(new BigDecimal("15.12345")); + record.setDecimal30field(new Short((short) 3)); + record.setDecimal60field(new Integer(6)); + record.setFirstname("Jeff"); + record.setId1(new Integer(1)); + record.setId2(new Integer(2)); + record.setLastname("Butler"); + record.setTimefield(new Date()); + record.setTimestampfield(new Date()); + + dao.insert(record); + + PkfieldsKey key = new PkfieldsKey(); + key.setId1(new Integer(1)); + key.setId2(new Integer(2)); + + Pkfields returnedRecord = dao.selectByPrimaryKey(key); + assertNotNull(returnedRecord); + + assertTrue(datesAreEqual(record.getDatefield(), returnedRecord + .getDatefield())); + assertEquals(record.getDecimal100field(), returnedRecord + .getDecimal100field()); + assertEquals(record.getDecimal155field(), returnedRecord + .getDecimal155field()); + assertEquals(record.getDecimal30field(), returnedRecord + .getDecimal30field()); + assertEquals(record.getDecimal60field(), returnedRecord + .getDecimal60field()); + assertEquals(record.getFirstname(), returnedRecord.getFirstname()); + assertEquals(record.getId1(), returnedRecord.getId1()); + assertEquals(record.getId2(), returnedRecord.getId2()); + assertEquals(record.getLastname(), returnedRecord.getLastname()); + assertTrue(timesAreEqual(record.getTimefield(), returnedRecord + .getTimefield())); + assertEquals(record.getTimestampfield(), returnedRecord + .getTimestampfield()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKBlobsInsert() { + PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient); + + try { + Pkblobs record = new Pkblobs(); + record.setId(new Integer(3)); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + PkblobsExample example = new PkblobsExample(); + List answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkblobs returnedRecord = (Pkblobs) answer.get(0); + assertEquals(record.getId(), returnedRecord.getId()); + assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord + .getBlob1())); + assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord + .getBlob2())); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKFieldsBlobsInsert() { + PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient); + + try { + Pkfieldsblobs record = new Pkfieldsblobs(); + record.setId1(new Integer(3)); + record.setId2(new Integer(4)); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + dao.insert(record); + + PkfieldsblobsExample example = new PkfieldsblobsExample(); + List answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkfieldsblobs returnedRecord = (Pkfieldsblobs) answer.get(0); + assertEquals(record.getId1(), returnedRecord.getId1()); + assertEquals(record.getId2(), returnedRecord.getId2()); + assertEquals(record.getFirstname(), returnedRecord.getFirstname()); + assertEquals(record.getLastname(), returnedRecord.getLastname()); + assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord + .getBlob1())); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testFieldsBlobsInsert() { + FieldsblobsDAO dao = new FieldsblobsDAOImpl(sqlMapClient); + + try { + FieldsblobsWithBLOBs record = new FieldsblobsWithBLOBs(); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + FieldsblobsExample example = new FieldsblobsExample(); + List answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + FieldsblobsWithBLOBs returnedRecord = (FieldsblobsWithBLOBs) answer + .get(0); + assertEquals(record.getFirstname(), returnedRecord.getFirstname()); + assertEquals(record.getLastname(), returnedRecord.getLastname()); + assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord + .getBlob1())); + assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord + .getBlob2())); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testAwfulTableInsert() { + AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient); + + try { + AwfulTable record = new AwfulTable(); + + record.seteMail("[EMAIL PROTECTED]"); + record.setEmailaddress("[EMAIL PROTECTED]"); + record.setFirstFirstName("fred1"); + record.setFourthFirstName("fred4"); + record.setFrom("from field"); + record.setId1(new Integer(1)); + record.setId2(new Integer(2)); + record.setId5(new Integer(5)); + record.setId6(new Integer(6)); + record.setId7(new Integer(7)); + record.setSecondCustomerId(new Integer(567)); + record.setSecondFirstName("fred2"); + record.setThirdFirstName("fred3"); + + Integer generatedCustomerId = dao.insert(record); + assertEquals(57, generatedCustomerId.intValue()); + + AwfulTable returnedRecord = dao + .selectByPrimaryKey(generatedCustomerId); + + assertEquals(generatedCustomerId, returnedRecord.getCustomerId()); + assertEquals(record.geteMail(), returnedRecord.geteMail()); + assertEquals(record.getEmailaddress(), returnedRecord + .getEmailaddress()); + assertEquals(record.getFirstFirstName(), returnedRecord + .getFirstFirstName()); + assertEquals(record.getFourthFirstName(), returnedRecord + .getFourthFirstName()); + assertEquals(record.getFrom(), returnedRecord.getFrom()); + assertEquals(record.getId1(), returnedRecord.getId1()); + assertEquals(record.getId2(), returnedRecord.getId2()); + assertEquals(record.getId5(), returnedRecord.getId5()); + assertEquals(record.getId6(), returnedRecord.getId6()); + assertEquals(record.getId7(), returnedRecord.getId7()); + assertEquals(record.getSecondCustomerId(), returnedRecord + .getSecondCustomerId()); + assertEquals(record.getSecondFirstName(), returnedRecord + .getSecondFirstName()); + assertEquals(record.getThirdFirstName(), returnedRecord + .getThirdFirstName()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + +}
