You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ibatis.apache.org by jg...@apache.org on 2007/10/26 22:55:09 UTC
svn commit: r588774 [5/5] - in
/ibatis/trunk/java/mapper/mapper2/tools/abator/core: build/ doc/ htmldoc/
src/org/apache/ibatis/abator/config/ testJava2/abatortest/java2/
testJava2/abatortest/java2/execute/conditional/legacy/
testJava2/abatortest/java2/...
Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java2/UpdateByExampleTests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java2/UpdateByExampleTests.java?rev=588774&view=auto
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java2/UpdateByExampleTests.java (added)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java2/UpdateByExampleTests.java Fri Oct 26 13:55:08 2007
@@ -0,0 +1,853 @@
+/*
+ * Copyright 2007 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.java2;
+
+import java.sql.SQLException;
+import java.util.List;
+
+import abatortest.BaseTest;
+import abatortest.generated.hierarchical.java2.dao.AwfulTableDAO;
+import abatortest.generated.hierarchical.java2.dao.AwfulTableDAOImpl;
+import abatortest.generated.hierarchical.java2.dao.FieldsblobsDAO;
+import abatortest.generated.hierarchical.java2.dao.FieldsblobsDAOImpl;
+import abatortest.generated.hierarchical.java2.dao.FieldsonlyDAO;
+import abatortest.generated.hierarchical.java2.dao.FieldsonlyDAOImpl;
+import abatortest.generated.hierarchical.java2.dao.PkblobsDAO;
+import abatortest.generated.hierarchical.java2.dao.PkblobsDAOImpl;
+import abatortest.generated.hierarchical.java2.dao.PkfieldsDAO;
+import abatortest.generated.hierarchical.java2.dao.PkfieldsDAOImpl;
+import abatortest.generated.hierarchical.java2.dao.PkfieldsblobsDAO;
+import abatortest.generated.hierarchical.java2.dao.PkfieldsblobsDAOImpl;
+import abatortest.generated.hierarchical.java2.dao.PkonlyDAO;
+import abatortest.generated.hierarchical.java2.dao.PkonlyDAOImpl;
+import abatortest.generated.hierarchical.java2.model.AwfulTable;
+import abatortest.generated.hierarchical.java2.model.AwfulTableExample;
+import abatortest.generated.hierarchical.java2.model.Fieldsblobs;
+import abatortest.generated.hierarchical.java2.model.FieldsblobsExample;
+import abatortest.generated.hierarchical.java2.model.FieldsblobsWithBLOBs;
+import abatortest.generated.hierarchical.java2.model.Fieldsonly;
+import abatortest.generated.hierarchical.java2.model.FieldsonlyExample;
+import abatortest.generated.hierarchical.java2.model.PkblobsExample;
+import abatortest.generated.hierarchical.java2.model.PkblobsKey;
+import abatortest.generated.hierarchical.java2.model.PkblobsWithBLOBs;
+import abatortest.generated.hierarchical.java2.model.Pkfields;
+import abatortest.generated.hierarchical.java2.model.PkfieldsExample;
+import abatortest.generated.hierarchical.java2.model.Pkfieldsblobs;
+import abatortest.generated.hierarchical.java2.model.PkfieldsblobsExample;
+import abatortest.generated.hierarchical.java2.model.PkfieldsblobsWithBLOBs;
+import abatortest.generated.hierarchical.java2.model.PkonlyExample;
+import abatortest.generated.hierarchical.java2.model.PkonlyKey;
+
+/**
+ *
+ * @author Jeff Butler
+ *
+ */
+public class UpdateByExampleTests extends BaseTest {
+
+ protected void setUp() throws Exception {
+ super.setUp();
+ initSqlMapClient(
+ "abatortest/execute/hierarchical/java2/SqlMapConfig.xml",
+ null);
+ }
+
+ public void testFieldsOnlyUpdateByExampleSelective() {
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(11.22);
+ record.setFloatfield(33.44);
+ record.setIntegerfield(5);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(44.55);
+ record.setFloatfield(66.77);
+ record.setIntegerfield(8);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(88.99);
+ record.setFloatfield(100.111);
+ record.setIntegerfield(9);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(99d);
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.createCriteria().andIntegerfieldGreaterThan(5);
+
+ int rows = dao.updateByExampleSelective(record, example);
+ assertEquals(2, rows);
+
+ example.clear();
+ example.createCriteria().andIntegerfieldEqualTo(5);
+ List answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+ record = (Fieldsonly) answer.get(0);
+ assertEquals(record.getDoublefield(), 11.22);
+ assertEquals(record.getFloatfield(), 33.44);
+ assertEquals(record.getIntegerfield().intValue(), 5);
+
+ example.clear();
+ example.createCriteria().andIntegerfieldEqualTo(8);
+ answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+ record = (Fieldsonly) answer.get(0);
+ assertEquals(record.getDoublefield(), 99d);
+ assertEquals(record.getFloatfield(), 66.77);
+ assertEquals(record.getIntegerfield().intValue(), 8);
+
+ example.clear();
+ example.createCriteria().andIntegerfieldEqualTo(9);
+ answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+ record = (Fieldsonly) answer.get(0);
+ assertEquals(record.getDoublefield(), 99d);
+ assertEquals(record.getFloatfield(), 100.111);
+ assertEquals(record.getIntegerfield().intValue(), 9);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testFieldsOnlyUpdateByExample() {
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(11.22);
+ record.setFloatfield(33.44);
+ record.setIntegerfield(5);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(44.55);
+ record.setFloatfield(66.77);
+ record.setIntegerfield(8);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(88.99);
+ record.setFloatfield(100.111);
+ record.setIntegerfield(9);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setIntegerfield(22);
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.createCriteria().andIntegerfieldEqualTo(5);
+
+ int rows = dao.updateByExample(record, example);
+ assertEquals(1, rows);
+
+ example.clear();
+ example.createCriteria().andIntegerfieldEqualTo(22);
+ List answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+ record = (Fieldsonly) answer.get(0);
+ assertNull(record.getDoublefield());
+ assertNull(record.getFloatfield());
+ assertEquals(record.getIntegerfield().intValue(), 22);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKOnlyUpdateByExampleSelective() {
+ PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
+
+ try {
+ PkonlyKey key = new PkonlyKey();
+ key.setId(1);
+ key.setSeqNum(3);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(5);
+ key.setSeqNum(6);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(7);
+ key.setSeqNum(8);
+ dao.insert(key);
+
+ PkonlyExample example = new PkonlyExample();
+ example.createCriteria().andIdGreaterThan(4);
+ key = new PkonlyKey();
+ key.setSeqNum(3);
+ int rows = dao.updateByExampleSelective(key, example);
+ assertEquals(2, rows);
+
+ example.clear();
+ example.createCriteria()
+ .andIdEqualTo(5)
+ .andSeqNumEqualTo(3);
+
+ rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ example.createCriteria()
+ .andIdEqualTo(7)
+ .andSeqNumEqualTo(3);
+
+ rows = dao.countByExample(example);
+ assertEquals(1, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKOnlyUpdateByExample() {
+ PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
+
+ try {
+ PkonlyKey key = new PkonlyKey();
+ key.setId(1);
+ key.setSeqNum(3);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(5);
+ key.setSeqNum(6);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(7);
+ key.setSeqNum(8);
+ dao.insert(key);
+
+ PkonlyExample example = new PkonlyExample();
+ example.createCriteria()
+ .andIdEqualTo(7);
+ key = new PkonlyKey();
+ key.setSeqNum(3);
+ key.setId(22);
+ int rows = dao.updateByExample(key, example);
+ assertEquals(1, rows);
+
+ example.clear();
+ example.createCriteria()
+ .andIdEqualTo(22)
+ .andSeqNumEqualTo(3);
+
+ rows = dao.countByExample(example);
+ assertEquals(1, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKFieldsUpdateByExampleSelective() {
+ PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfields record = new Pkfields();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Bob");
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Fred");
+ PkfieldsExample example = new PkfieldsExample();
+ example.createCriteria().andLastnameLike("J%");
+ int rows = dao.updateByExampleSelective(record, example);
+ assertEquals(1, rows);
+
+ example.clear();
+ example.createCriteria()
+ .andFirstnameEqualTo("Fred")
+ .andLastnameEqualTo("Jones")
+ .andId1EqualTo(3)
+ .andId2EqualTo(4);
+
+ rows = dao.countByExample(example);
+ assertEquals(1, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKFieldsUpdateByExample() {
+ PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfields record = new Pkfields();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Bob");
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Fred");
+ record.setId1(3);
+ record.setId2(4);
+ PkfieldsExample example = new PkfieldsExample();
+ example.createCriteria()
+ .andId1EqualTo(3)
+ .andId2EqualTo(4);
+
+ int rows = dao.updateByExample(record, example);
+ assertEquals(1, rows);
+
+ example.clear();
+ example.createCriteria()
+ .andFirstnameEqualTo("Fred")
+ .andLastnameIsNull()
+ .andId1EqualTo(3)
+ .andId2EqualTo(4);
+
+ rows = dao.countByExample(example);
+ assertEquals(1, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKBlobsUpdateByExampleSelective() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsWithBLOBs newRecord = new PkblobsWithBLOBs();
+ newRecord.setBlob1(generateRandomBlob());
+
+ PkblobsExample example = new PkblobsExample();
+ example.createCriteria().andIdGreaterThan(4);
+ int rows = dao.updateByExampleSelective(newRecord, example);
+ assertEquals(1, rows);
+
+ List answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ PkblobsWithBLOBs returnedRecord = (PkblobsWithBLOBs) answer.get(0);
+
+ assertEquals(6, returnedRecord.getId().intValue());
+ assertTrue(blobsAreEqual(newRecord.getBlob1(), returnedRecord.getBlob1()));
+ assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord.getBlob2()));
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKBlobsUpdateByExampleWithoutBLOBs() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsKey newRecord = new PkblobsKey();
+ newRecord.setId(8);
+
+ PkblobsExample example = new PkblobsExample();
+ example.createCriteria().andIdGreaterThan(4);
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ PkblobsWithBLOBs returnedRecord = (PkblobsWithBLOBs) answer.get(0);
+
+ assertEquals(8, returnedRecord.getId().intValue());
+ assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
+ assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord.getBlob2()));
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKBlobsUpdateByExampleWithBLOBs() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsWithBLOBs newRecord = new PkblobsWithBLOBs();
+ newRecord.setId(8);
+
+ PkblobsExample example = new PkblobsExample();
+ example.createCriteria().andIdGreaterThan(4);
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ PkblobsWithBLOBs returnedRecord = (PkblobsWithBLOBs) answer.get(0);
+
+ assertEquals(8, returnedRecord.getId().intValue());
+ assertNull(returnedRecord.getBlob1());
+ assertNull(returnedRecord.getBlob2());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKFieldsBlobsUpdateByExampleSelective() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsWithBLOBs newRecord = new PkfieldsblobsWithBLOBs();
+ newRecord.setFirstname("Fred");
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.createCriteria().andId1NotEqualTo(3);
+ int rows = dao.updateByExampleSelective(newRecord, example);
+ assertEquals(1, rows);
+
+ 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(newRecord.getFirstname(), returnedRecord.getFirstname());
+ assertEquals(record.getLastname(), returnedRecord.getLastname());
+ assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
+
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKFieldsBlobsUpdateByExampleWithoutBLOBs() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ Pkfieldsblobs newRecord = new Pkfieldsblobs();
+ newRecord.setId1(5);
+ newRecord.setId2(8);
+ newRecord.setFirstname("Fred");
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.createCriteria().andId1EqualTo(5);
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ PkfieldsblobsWithBLOBs returnedRecord = (PkfieldsblobsWithBLOBs) answer.get(0);
+
+ assertEquals(newRecord.getId1(), returnedRecord.getId1());
+ assertEquals(newRecord.getId2(), returnedRecord.getId2());
+ assertEquals(newRecord.getFirstname(), returnedRecord.getFirstname());
+ assertNull(returnedRecord.getLastname());
+ assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
+
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKFieldsBlobsUpdateByExampleWithBLOBs() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsWithBLOBs newRecord = new PkfieldsblobsWithBLOBs();
+ newRecord.setId1(3);
+ newRecord.setId2(8);
+ newRecord.setFirstname("Fred");
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.createCriteria().andId1EqualTo(3);
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ PkfieldsblobsWithBLOBs returnedRecord = (PkfieldsblobsWithBLOBs) answer.get(0);
+
+ assertEquals(newRecord.getId1(), returnedRecord.getId1());
+ assertEquals(newRecord.getId2(), returnedRecord.getId2());
+ assertEquals(newRecord.getFirstname(), returnedRecord.getFirstname());
+ assertNull(returnedRecord.getLastname());
+ assertNull(returnedRecord.getBlob1());
+
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testFieldsBlobsUpdateByExampleSelective() {
+ 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);
+
+ FieldsblobsWithBLOBs newRecord = new FieldsblobsWithBLOBs();
+ newRecord.setLastname("Doe");
+ FieldsblobsExample example = new FieldsblobsExample();
+ example.createCriteria().andFirstnameLike("S%");
+ int rows = dao.updateByExampleSelective(newRecord, example);
+ assertEquals(1, rows);
+
+ List answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ FieldsblobsWithBLOBs returnedRecord = (FieldsblobsWithBLOBs) answer.get(0);
+
+ assertEquals(record.getFirstname(), returnedRecord.getFirstname());
+ assertEquals(newRecord.getLastname(), returnedRecord.getLastname());
+ assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
+ assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord.getBlob2()));
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testFieldsBlobsUpdateByExampleWithoutBLOBs() {
+ 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);
+
+ Fieldsblobs newRecord = new Fieldsblobs();
+ newRecord.setFirstname("Scott");
+ newRecord.setLastname("Doe");
+ FieldsblobsExample example = new FieldsblobsExample();
+ example.createCriteria().andFirstnameLike("S%");
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ FieldsblobsWithBLOBs returnedRecord = (FieldsblobsWithBLOBs) answer.get(0);
+
+ assertEquals(newRecord.getFirstname(), returnedRecord.getFirstname());
+ assertEquals(newRecord.getLastname(), returnedRecord.getLastname());
+ assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
+ assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord.getBlob2()));
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testFieldsBlobsUpdateByExampleWithBLOBs() {
+ 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);
+
+ FieldsblobsWithBLOBs newRecord = new FieldsblobsWithBLOBs();
+ newRecord.setFirstname("Scott");
+ newRecord.setLastname("Doe");
+ FieldsblobsExample example = new FieldsblobsExample();
+ example.createCriteria().andFirstnameLike("S%");
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ FieldsblobsWithBLOBs returnedRecord = (FieldsblobsWithBLOBs) answer.get(0);
+
+ assertEquals(newRecord.getFirstname(), returnedRecord.getFirstname());
+ assertEquals(newRecord.getLastname(), returnedRecord.getLastname());
+ assertNull(returnedRecord.getBlob1());
+ assertNull(returnedRecord.getBlob2());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableUpdateByExampleSelective() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ dao.insert(record);
+
+ record = new AwfulTable();
+ record.seteMail("fred2@fred.com");
+ record.setEmailaddress("alsofred2@fred.com");
+ record.setFirstFirstName("fred11");
+ record.setFourthFirstName("fred44");
+ record.setFrom("from from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("fred22");
+ record.setThirdFirstName("fred33");
+
+ dao.insert(record);
+
+ AwfulTable newRecord = new AwfulTable();
+ newRecord.setFirstFirstName("Alonzo");
+ AwfulTableExample example = new AwfulTableExample();
+ example.createCriteria().andEMailLike("fred2@%");
+ int rows = dao.updateByExampleSelective(newRecord, example);
+ assertEquals(1, rows);
+
+ List answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+
+ AwfulTable returnedRecord = (AwfulTable) answer.get(0);
+
+ assertEquals(record.getCustomerId(), returnedRecord.getCustomerId());
+ assertEquals(record.geteMail(), returnedRecord.geteMail());
+ assertEquals(record.getEmailaddress(), returnedRecord.getEmailaddress());
+ assertEquals(newRecord.getFirstFirstName(), returnedRecord.getFirstFirstName());
+ assertEquals(record.getFourthFirstName(), returnedRecord.getFourthFirstName());
+ assertEquals(record.getFrom(), returnedRecord.getFrom());
+ assertEquals(record.getId1(), returnedRecord.getId1());
+ assertEquals(record.getId2(), returnedRecord.getId2());
+ assertEquals(record.getId5(), returnedRecord.getId5());
+ assertEquals(record.getId6(), returnedRecord.getId6());
+ assertEquals(record.getId7(), returnedRecord.getId7());
+ assertEquals(record.getSecondCustomerId(), returnedRecord.getSecondCustomerId());
+ assertEquals(record.getSecondFirstName(), returnedRecord.getSecondFirstName());
+ assertEquals(record.getThirdFirstName(), returnedRecord.getThirdFirstName());
+
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableUpdateByExample() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ dao.insert(record);
+
+ record = new AwfulTable();
+ record.seteMail("fred2@fred.com");
+ record.setEmailaddress("alsofred2@fred.com");
+ record.setFirstFirstName("fred11");
+ record.setFourthFirstName("fred44");
+ record.setFrom("from from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("fred22");
+ record.setThirdFirstName("fred33");
+
+ dao.insert(record);
+
+ AwfulTable newRecord = new AwfulTable();
+ newRecord.setFirstFirstName("Alonzo");
+ newRecord.setCustomerId(58);
+ newRecord.setId1(111);
+ newRecord.setId2(222);
+ newRecord.setId5(555);
+ newRecord.setId6(666);
+ newRecord.setId7(777);
+ AwfulTableExample example = new AwfulTableExample();
+ example.createCriteria().andEMailLike("fred2@%");
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ example.clear();
+ example.createCriteria().andCustomerIdEqualTo(58);
+ List answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+
+ AwfulTable returnedRecord = (AwfulTable) answer.get(0);
+
+ assertEquals(newRecord.getCustomerId(), returnedRecord.getCustomerId());
+ assertNull(returnedRecord.geteMail());
+ assertNull(returnedRecord.getEmailaddress());
+ assertEquals(newRecord.getFirstFirstName(), returnedRecord.getFirstFirstName());
+ assertNull(returnedRecord.getFourthFirstName());
+ assertNull(returnedRecord.getFrom());
+ assertEquals(newRecord.getId1(), returnedRecord.getId1());
+ assertEquals(newRecord.getId2(), returnedRecord.getId2());
+ assertEquals(newRecord.getId5(), returnedRecord.getId5());
+ assertEquals(newRecord.getId6(), returnedRecord.getId6());
+ assertEquals(newRecord.getId7(), returnedRecord.getId7());
+ assertNull(returnedRecord.getSecondCustomerId());
+ assertNull(returnedRecord.getSecondFirstName());
+ assertNull(returnedRecord.getThirdFirstName());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+}
Added: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java5/UpdateByExampleTests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java5/UpdateByExampleTests.java?rev=588774&view=auto
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java5/UpdateByExampleTests.java (added)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/hierarchical/java5/UpdateByExampleTests.java Fri Oct 26 13:55:08 2007
@@ -0,0 +1,853 @@
+/*
+ * Copyright 2007 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.java5;
+
+import java.sql.SQLException;
+import java.util.List;
+
+import abatortest.BaseTest;
+import abatortest.generated.hierarchical.java5.dao.AwfulTableDAO;
+import abatortest.generated.hierarchical.java5.dao.AwfulTableDAOImpl;
+import abatortest.generated.hierarchical.java5.dao.FieldsblobsDAO;
+import abatortest.generated.hierarchical.java5.dao.FieldsblobsDAOImpl;
+import abatortest.generated.hierarchical.java5.dao.FieldsonlyDAO;
+import abatortest.generated.hierarchical.java5.dao.FieldsonlyDAOImpl;
+import abatortest.generated.hierarchical.java5.dao.PkblobsDAO;
+import abatortest.generated.hierarchical.java5.dao.PkblobsDAOImpl;
+import abatortest.generated.hierarchical.java5.dao.PkfieldsDAO;
+import abatortest.generated.hierarchical.java5.dao.PkfieldsDAOImpl;
+import abatortest.generated.hierarchical.java5.dao.PkfieldsblobsDAO;
+import abatortest.generated.hierarchical.java5.dao.PkfieldsblobsDAOImpl;
+import abatortest.generated.hierarchical.java5.dao.PkonlyDAO;
+import abatortest.generated.hierarchical.java5.dao.PkonlyDAOImpl;
+import abatortest.generated.hierarchical.java5.model.AwfulTable;
+import abatortest.generated.hierarchical.java5.model.AwfulTableExample;
+import abatortest.generated.hierarchical.java5.model.Fieldsblobs;
+import abatortest.generated.hierarchical.java5.model.FieldsblobsExample;
+import abatortest.generated.hierarchical.java5.model.FieldsblobsWithBLOBs;
+import abatortest.generated.hierarchical.java5.model.Fieldsonly;
+import abatortest.generated.hierarchical.java5.model.FieldsonlyExample;
+import abatortest.generated.hierarchical.java5.model.PkblobsExample;
+import abatortest.generated.hierarchical.java5.model.PkblobsKey;
+import abatortest.generated.hierarchical.java5.model.PkblobsWithBLOBs;
+import abatortest.generated.hierarchical.java5.model.Pkfields;
+import abatortest.generated.hierarchical.java5.model.PkfieldsExample;
+import abatortest.generated.hierarchical.java5.model.Pkfieldsblobs;
+import abatortest.generated.hierarchical.java5.model.PkfieldsblobsExample;
+import abatortest.generated.hierarchical.java5.model.PkfieldsblobsWithBLOBs;
+import abatortest.generated.hierarchical.java5.model.PkonlyExample;
+import abatortest.generated.hierarchical.java5.model.PkonlyKey;
+
+/**
+ *
+ * @author Jeff Butler
+ *
+ */
+public class UpdateByExampleTests extends BaseTest {
+
+ protected void setUp() throws Exception {
+ super.setUp();
+ initSqlMapClient(
+ "abatortest/execute/hierarchical/java5/SqlMapConfig.xml",
+ null);
+ }
+
+ public void testFieldsOnlyUpdateByExampleSelective() {
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(11.22);
+ record.setFloatfield(33.44);
+ record.setIntegerfield(5);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(44.55);
+ record.setFloatfield(66.77);
+ record.setIntegerfield(8);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(88.99);
+ record.setFloatfield(100.111);
+ record.setIntegerfield(9);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(99d);
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.createCriteria().andIntegerfieldGreaterThan(5);
+
+ int rows = dao.updateByExampleSelective(record, example);
+ assertEquals(2, rows);
+
+ example.clear();
+ example.createCriteria().andIntegerfieldEqualTo(5);
+ List<Fieldsonly> answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+ record = answer.get(0);
+ assertEquals(record.getDoublefield(), 11.22);
+ assertEquals(record.getFloatfield(), 33.44);
+ assertEquals(record.getIntegerfield().intValue(), 5);
+
+ example.clear();
+ example.createCriteria().andIntegerfieldEqualTo(8);
+ answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+ record = (Fieldsonly) answer.get(0);
+ assertEquals(record.getDoublefield(), 99d);
+ assertEquals(record.getFloatfield(), 66.77);
+ assertEquals(record.getIntegerfield().intValue(), 8);
+
+ example.clear();
+ example.createCriteria().andIntegerfieldEqualTo(9);
+ answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+ record = (Fieldsonly) answer.get(0);
+ assertEquals(record.getDoublefield(), 99d);
+ assertEquals(record.getFloatfield(), 100.111);
+ assertEquals(record.getIntegerfield().intValue(), 9);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testFieldsOnlyUpdateByExample() {
+ FieldsonlyDAO dao = new FieldsonlyDAOImpl(sqlMapClient);
+
+ try {
+ Fieldsonly record = new Fieldsonly();
+ record.setDoublefield(11.22);
+ record.setFloatfield(33.44);
+ record.setIntegerfield(5);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(44.55);
+ record.setFloatfield(66.77);
+ record.setIntegerfield(8);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setDoublefield(88.99);
+ record.setFloatfield(100.111);
+ record.setIntegerfield(9);
+ dao.insert(record);
+
+ record = new Fieldsonly();
+ record.setIntegerfield(22);
+ FieldsonlyExample example = new FieldsonlyExample();
+ example.createCriteria().andIntegerfieldEqualTo(5);
+
+ int rows = dao.updateByExample(record, example);
+ assertEquals(1, rows);
+
+ example.clear();
+ example.createCriteria().andIntegerfieldEqualTo(22);
+ List<Fieldsonly> answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+ record = answer.get(0);
+ assertNull(record.getDoublefield());
+ assertNull(record.getFloatfield());
+ assertEquals(record.getIntegerfield().intValue(), 22);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKOnlyUpdateByExampleSelective() {
+ PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
+
+ try {
+ PkonlyKey key = new PkonlyKey();
+ key.setId(1);
+ key.setSeqNum(3);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(5);
+ key.setSeqNum(6);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(7);
+ key.setSeqNum(8);
+ dao.insert(key);
+
+ PkonlyExample example = new PkonlyExample();
+ example.createCriteria().andIdGreaterThan(4);
+ key = new PkonlyKey();
+ key.setSeqNum(3);
+ int rows = dao.updateByExampleSelective(key, example);
+ assertEquals(2, rows);
+
+ example.clear();
+ example.createCriteria()
+ .andIdEqualTo(5)
+ .andSeqNumEqualTo(3);
+
+ rows = dao.countByExample(example);
+ assertEquals(1, rows);
+
+ example.clear();
+ example.createCriteria()
+ .andIdEqualTo(7)
+ .andSeqNumEqualTo(3);
+
+ rows = dao.countByExample(example);
+ assertEquals(1, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKOnlyUpdateByExample() {
+ PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient);
+
+ try {
+ PkonlyKey key = new PkonlyKey();
+ key.setId(1);
+ key.setSeqNum(3);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(5);
+ key.setSeqNum(6);
+ dao.insert(key);
+
+ key = new PkonlyKey();
+ key.setId(7);
+ key.setSeqNum(8);
+ dao.insert(key);
+
+ PkonlyExample example = new PkonlyExample();
+ example.createCriteria()
+ .andIdEqualTo(7);
+ key = new PkonlyKey();
+ key.setSeqNum(3);
+ key.setId(22);
+ int rows = dao.updateByExample(key, example);
+ assertEquals(1, rows);
+
+ example.clear();
+ example.createCriteria()
+ .andIdEqualTo(22)
+ .andSeqNumEqualTo(3);
+
+ rows = dao.countByExample(example);
+ assertEquals(1, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKFieldsUpdateByExampleSelective() {
+ PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfields record = new Pkfields();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Bob");
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Fred");
+ PkfieldsExample example = new PkfieldsExample();
+ example.createCriteria().andLastnameLike("J%");
+ int rows = dao.updateByExampleSelective(record, example);
+ assertEquals(1, rows);
+
+ example.clear();
+ example.createCriteria()
+ .andFirstnameEqualTo("Fred")
+ .andLastnameEqualTo("Jones")
+ .andId1EqualTo(3)
+ .andId2EqualTo(4);
+
+ rows = dao.countByExample(example);
+ assertEquals(1, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKFieldsUpdateByExample() {
+ PkfieldsDAO dao = new PkfieldsDAOImpl(sqlMapClient);
+
+ try {
+ Pkfields record = new Pkfields();
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Bob");
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+
+ dao.insert(record);
+
+ record = new Pkfields();
+ record.setFirstname("Fred");
+ record.setId1(3);
+ record.setId2(4);
+ PkfieldsExample example = new PkfieldsExample();
+ example.createCriteria()
+ .andId1EqualTo(3)
+ .andId2EqualTo(4);
+
+ int rows = dao.updateByExample(record, example);
+ assertEquals(1, rows);
+
+ example.clear();
+ example.createCriteria()
+ .andFirstnameEqualTo("Fred")
+ .andLastnameIsNull()
+ .andId1EqualTo(3)
+ .andId2EqualTo(4);
+
+ rows = dao.countByExample(example);
+ assertEquals(1, rows);
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKBlobsUpdateByExampleSelective() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsWithBLOBs newRecord = new PkblobsWithBLOBs();
+ newRecord.setBlob1(generateRandomBlob());
+
+ PkblobsExample example = new PkblobsExample();
+ example.createCriteria().andIdGreaterThan(4);
+ int rows = dao.updateByExampleSelective(newRecord, example);
+ assertEquals(1, rows);
+
+ List<PkblobsWithBLOBs> answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ PkblobsWithBLOBs returnedRecord = answer.get(0);
+
+ assertEquals(6, returnedRecord.getId().intValue());
+ assertTrue(blobsAreEqual(newRecord.getBlob1(), returnedRecord.getBlob1()));
+ assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord.getBlob2()));
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKBlobsUpdateByExampleWithoutBLOBs() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsKey newRecord = new PkblobsKey();
+ newRecord.setId(8);
+
+ PkblobsExample example = new PkblobsExample();
+ example.createCriteria().andIdGreaterThan(4);
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List<PkblobsWithBLOBs> answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ PkblobsWithBLOBs returnedRecord = answer.get(0);
+
+ assertEquals(8, returnedRecord.getId().intValue());
+ assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
+ assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord.getBlob2()));
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKBlobsUpdateByExampleWithBLOBs() {
+ PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkblobsWithBLOBs record = new PkblobsWithBLOBs();
+ record.setId(3);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkblobsWithBLOBs();
+ record.setId(6);
+ record.setBlob1(generateRandomBlob());
+ record.setBlob2(generateRandomBlob());
+ dao.insert(record);
+
+ PkblobsWithBLOBs newRecord = new PkblobsWithBLOBs();
+ newRecord.setId(8);
+
+ PkblobsExample example = new PkblobsExample();
+ example.createCriteria().andIdGreaterThan(4);
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List<PkblobsWithBLOBs> answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ PkblobsWithBLOBs returnedRecord = answer.get(0);
+
+ assertEquals(8, returnedRecord.getId().intValue());
+ assertNull(returnedRecord.getBlob1());
+ assertNull(returnedRecord.getBlob2());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKFieldsBlobsUpdateByExampleSelective() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsWithBLOBs newRecord = new PkfieldsblobsWithBLOBs();
+ newRecord.setFirstname("Fred");
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.createCriteria().andId1NotEqualTo(3);
+ int rows = dao.updateByExampleSelective(newRecord, example);
+ assertEquals(1, rows);
+
+ List<PkfieldsblobsWithBLOBs> answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ PkfieldsblobsWithBLOBs returnedRecord = answer.get(0);
+
+ assertEquals(record.getId1(), returnedRecord.getId1());
+ assertEquals(record.getId2(), returnedRecord.getId2());
+ assertEquals(newRecord.getFirstname(), returnedRecord.getFirstname());
+ assertEquals(record.getLastname(), returnedRecord.getLastname());
+ assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
+
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKFieldsBlobsUpdateByExampleWithoutBLOBs() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ Pkfieldsblobs newRecord = new Pkfieldsblobs();
+ newRecord.setId1(5);
+ newRecord.setId2(8);
+ newRecord.setFirstname("Fred");
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.createCriteria().andId1EqualTo(5);
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List<PkfieldsblobsWithBLOBs> answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ PkfieldsblobsWithBLOBs returnedRecord = answer.get(0);
+
+ assertEquals(newRecord.getId1(), returnedRecord.getId1());
+ assertEquals(newRecord.getId2(), returnedRecord.getId2());
+ assertEquals(newRecord.getFirstname(), returnedRecord.getFirstname());
+ assertNull(returnedRecord.getLastname());
+ assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
+
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testPKFieldsBlobsUpdateByExampleWithBLOBs() {
+ PkfieldsblobsDAO dao = new PkfieldsblobsDAOImpl(sqlMapClient);
+
+ try {
+ PkfieldsblobsWithBLOBs record = new PkfieldsblobsWithBLOBs();
+ record.setId1(3);
+ record.setId2(4);
+ record.setFirstname("Jeff");
+ record.setLastname("Smith");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ record = new PkfieldsblobsWithBLOBs();
+ record.setId1(5);
+ record.setId2(6);
+ record.setFirstname("Scott");
+ record.setLastname("Jones");
+ record.setBlob1(generateRandomBlob());
+ dao.insert(record);
+
+ PkfieldsblobsWithBLOBs newRecord = new PkfieldsblobsWithBLOBs();
+ newRecord.setId1(3);
+ newRecord.setId2(8);
+ newRecord.setFirstname("Fred");
+ PkfieldsblobsExample example = new PkfieldsblobsExample();
+ example.createCriteria().andId1EqualTo(3);
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List<PkfieldsblobsWithBLOBs> answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ PkfieldsblobsWithBLOBs returnedRecord = answer.get(0);
+
+ assertEquals(newRecord.getId1(), returnedRecord.getId1());
+ assertEquals(newRecord.getId2(), returnedRecord.getId2());
+ assertEquals(newRecord.getFirstname(), returnedRecord.getFirstname());
+ assertNull(returnedRecord.getLastname());
+ assertNull(returnedRecord.getBlob1());
+
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testFieldsBlobsUpdateByExampleSelective() {
+ 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);
+
+ FieldsblobsWithBLOBs newRecord = new FieldsblobsWithBLOBs();
+ newRecord.setLastname("Doe");
+ FieldsblobsExample example = new FieldsblobsExample();
+ example.createCriteria().andFirstnameLike("S%");
+ int rows = dao.updateByExampleSelective(newRecord, example);
+ assertEquals(1, rows);
+
+ List<FieldsblobsWithBLOBs> answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ FieldsblobsWithBLOBs returnedRecord = answer.get(0);
+
+ assertEquals(record.getFirstname(), returnedRecord.getFirstname());
+ assertEquals(newRecord.getLastname(), returnedRecord.getLastname());
+ assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
+ assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord.getBlob2()));
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testFieldsBlobsUpdateByExampleWithoutBLOBs() {
+ 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);
+
+ Fieldsblobs newRecord = new Fieldsblobs();
+ newRecord.setFirstname("Scott");
+ newRecord.setLastname("Doe");
+ FieldsblobsExample example = new FieldsblobsExample();
+ example.createCriteria().andFirstnameLike("S%");
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List<FieldsblobsWithBLOBs> answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ FieldsblobsWithBLOBs returnedRecord = answer.get(0);
+
+ assertEquals(newRecord.getFirstname(), returnedRecord.getFirstname());
+ assertEquals(newRecord.getLastname(), returnedRecord.getLastname());
+ assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
+ assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord.getBlob2()));
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testFieldsBlobsUpdateByExampleWithBLOBs() {
+ 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);
+
+ FieldsblobsWithBLOBs newRecord = new FieldsblobsWithBLOBs();
+ newRecord.setFirstname("Scott");
+ newRecord.setLastname("Doe");
+ FieldsblobsExample example = new FieldsblobsExample();
+ example.createCriteria().andFirstnameLike("S%");
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List<FieldsblobsWithBLOBs> answer = dao.selectByExampleWithBLOBs(example);
+ assertEquals(1, answer.size());
+
+ FieldsblobsWithBLOBs returnedRecord = answer.get(0);
+
+ assertEquals(newRecord.getFirstname(), returnedRecord.getFirstname());
+ assertEquals(newRecord.getLastname(), returnedRecord.getLastname());
+ assertNull(returnedRecord.getBlob1());
+ assertNull(returnedRecord.getBlob2());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableUpdateByExampleSelective() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ dao.insert(record);
+
+ record = new AwfulTable();
+ record.seteMail("fred2@fred.com");
+ record.setEmailaddress("alsofred2@fred.com");
+ record.setFirstFirstName("fred11");
+ record.setFourthFirstName("fred44");
+ record.setFrom("from from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("fred22");
+ record.setThirdFirstName("fred33");
+
+ dao.insert(record);
+
+ AwfulTable newRecord = new AwfulTable();
+ newRecord.setFirstFirstName("Alonzo");
+ AwfulTableExample example = new AwfulTableExample();
+ example.createCriteria().andEMailLike("fred2@%");
+ int rows = dao.updateByExampleSelective(newRecord, example);
+ assertEquals(1, rows);
+
+ List<AwfulTable> answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+
+ AwfulTable returnedRecord = answer.get(0);
+
+ assertEquals(record.getCustomerId(), returnedRecord.getCustomerId());
+ assertEquals(record.geteMail(), returnedRecord.geteMail());
+ assertEquals(record.getEmailaddress(), returnedRecord.getEmailaddress());
+ assertEquals(newRecord.getFirstFirstName(), returnedRecord.getFirstFirstName());
+ assertEquals(record.getFourthFirstName(), returnedRecord.getFourthFirstName());
+ assertEquals(record.getFrom(), returnedRecord.getFrom());
+ assertEquals(record.getId1(), returnedRecord.getId1());
+ assertEquals(record.getId2(), returnedRecord.getId2());
+ assertEquals(record.getId5(), returnedRecord.getId5());
+ assertEquals(record.getId6(), returnedRecord.getId6());
+ assertEquals(record.getId7(), returnedRecord.getId7());
+ assertEquals(record.getSecondCustomerId(), returnedRecord.getSecondCustomerId());
+ assertEquals(record.getSecondFirstName(), returnedRecord.getSecondFirstName());
+ assertEquals(record.getThirdFirstName(), returnedRecord.getThirdFirstName());
+
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testAwfulTableUpdateByExample() {
+ AwfulTableDAO dao = new AwfulTableDAOImpl(sqlMapClient);
+
+ try {
+ AwfulTable record = new AwfulTable();
+ record.seteMail("fred@fred.com");
+ record.setEmailaddress("alsofred@fred.com");
+ record.setFirstFirstName("fred1");
+ record.setFourthFirstName("fred4");
+ record.setFrom("from field");
+ record.setId1(1);
+ record.setId2(2);
+ record.setId5(5);
+ record.setId6(6);
+ record.setId7(7);
+ record.setSecondCustomerId(567);
+ record.setSecondFirstName("fred2");
+ record.setThirdFirstName("fred3");
+
+ dao.insert(record);
+
+ record = new AwfulTable();
+ record.seteMail("fred2@fred.com");
+ record.setEmailaddress("alsofred2@fred.com");
+ record.setFirstFirstName("fred11");
+ record.setFourthFirstName("fred44");
+ record.setFrom("from from field");
+ record.setId1(11);
+ record.setId2(22);
+ record.setId5(55);
+ record.setId6(66);
+ record.setId7(77);
+ record.setSecondCustomerId(567567);
+ record.setSecondFirstName("fred22");
+ record.setThirdFirstName("fred33");
+
+ dao.insert(record);
+
+ AwfulTable newRecord = new AwfulTable();
+ newRecord.setFirstFirstName("Alonzo");
+ newRecord.setCustomerId(58);
+ newRecord.setId1(111);
+ newRecord.setId2(222);
+ newRecord.setId5(555);
+ newRecord.setId6(666);
+ newRecord.setId7(777);
+ AwfulTableExample example = new AwfulTableExample();
+ example.createCriteria().andEMailLike("fred2@%");
+ int rows = dao.updateByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ example.clear();
+ example.createCriteria().andCustomerIdEqualTo(58);
+ List<AwfulTable> answer = dao.selectByExample(example);
+ assertEquals(1, answer.size());
+
+ AwfulTable returnedRecord = answer.get(0);
+
+ assertEquals(newRecord.getCustomerId(), returnedRecord.getCustomerId());
+ assertNull(returnedRecord.geteMail());
+ assertNull(returnedRecord.getEmailaddress());
+ assertEquals(newRecord.getFirstFirstName(), returnedRecord.getFirstFirstName());
+ assertNull(returnedRecord.getFourthFirstName());
+ assertNull(returnedRecord.getFrom());
+ assertEquals(newRecord.getId1(), returnedRecord.getId1());
+ assertEquals(newRecord.getId2(), returnedRecord.getId2());
+ assertEquals(newRecord.getId5(), returnedRecord.getId5());
+ assertEquals(newRecord.getId6(), returnedRecord.getId6());
+ assertEquals(newRecord.getId7(), returnedRecord.getId7());
+ assertNull(returnedRecord.getSecondCustomerId());
+ assertNull(returnedRecord.getSecondFirstName());
+ assertNull(returnedRecord.getThirdFirstName());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+}
Modified: ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/miscellaneous/MiscellaneousTests.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/miscellaneous/MiscellaneousTests.java?rev=588774&r1=588773&r2=588774&view=diff
==============================================================================
--- ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/miscellaneous/MiscellaneousTests.java (original)
+++ ibatis/trunk/java/mapper/mapper2/tools/abator/core/testJava5/abatortest/execute/miscellaneous/MiscellaneousTests.java Fri Oct 26 13:55:08 2007
@@ -42,6 +42,7 @@
import abatortest.generated.miscellaneous.model.MyObject;
import abatortest.generated.miscellaneous.model.MyObjectExample;
import abatortest.generated.miscellaneous.model.MyObjectKey;
+import abatortest.execute.miscellaneous.FirstName;
/**
* @author Jeff Butler
@@ -756,6 +757,102 @@
fail("decimal30field should be ignored");
} catch (NoSuchFieldException e) {
// ignore (normal case)
+ }
+ }
+
+ public void testMyObjectUpdateByExampleSelective() {
+ MyObjectDAO dao = new MyObjectDAOImpl(sqlMapClient);
+
+ try {
+ MyObject record = new MyObject();
+ FirstName fn = new FirstName();
+ fn.setValue("Jeff");
+ record.setFirstname(fn);
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insertMyObject(record);
+
+ record = new MyObject();
+ fn = new FirstName();
+ fn.setValue("Bob");
+ record.setFirstname(fn);
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+
+ dao.insertMyObject(record);
+
+ MyObject newRecord = new MyObject();
+ newRecord.setLastname("Barker");
+
+ MyObjectExample example = new MyObjectExample();
+ fn = new FirstName();
+ fn.setValue("B%");
+ example.createCriteria().andFirstnameLike(fn);
+ int rows = dao.updateMyObjectByExampleSelective(newRecord, example);
+ assertEquals(1, rows);
+
+ List<MyObject> answer = dao.selectMyObjectByExample(example);
+ assertEquals(1, answer.size());
+
+ MyObject returnedRecord = answer.get(0);
+
+ assertEquals(newRecord.getLastname(), returnedRecord.getLastname());
+ assertEquals(record.getFirstname(), returnedRecord.getFirstname());
+ assertEquals(record.getId1(), returnedRecord.getId1());
+ assertEquals(record.getId2(), returnedRecord.getId2());
+ } catch (SQLException e) {
+ fail(e.getMessage());
+ }
+ }
+
+ public void testMyObjectUpdateByExample() {
+ MyObjectDAO dao = new MyObjectDAOImpl(sqlMapClient);
+
+ try {
+ MyObject record = new MyObject();
+ FirstName fn = new FirstName();
+ fn.setValue("Jeff");
+ record.setFirstname(fn);
+ record.setLastname("Smith");
+ record.setId1(1);
+ record.setId2(2);
+ dao.insertMyObject(record);
+
+ record = new MyObject();
+ fn = new FirstName();
+ fn.setValue("Bob");
+ record.setFirstname(fn);
+ record.setLastname("Jones");
+ record.setId1(3);
+ record.setId2(4);
+
+ dao.insertMyObject(record);
+
+ MyObject newRecord = new MyObject();
+ newRecord.setLastname("Barker");
+ newRecord.setId1(3);
+ newRecord.setId2(4);
+
+ MyObjectExample example = new MyObjectExample();
+ example.createCriteria()
+ .andId1EqualTo(3)
+ .andId2EqualTo(4);
+ int rows = dao.updateMyObjectByExample(newRecord, example);
+ assertEquals(1, rows);
+
+ List<MyObject> answer = dao.selectMyObjectByExample(example);
+ assertEquals(1, answer.size());
+
+ MyObject returnedRecord = answer.get(0);
+
+ assertEquals(newRecord.getLastname(), returnedRecord.getLastname());
+ assertNull(returnedRecord.getFirstname());
+ assertEquals(newRecord.getId1(), returnedRecord.getId1());
+ assertEquals(newRecord.getId2(), returnedRecord.getId2());
+ } catch (SQLException e) {
+ fail(e.getMessage());
}
}
}