Added: ibatis/trunk/java/tools/ibator/core/testJava2/ibatortest/java2/execute/flat/java2/SqlMapConfig.xml URL: http://svn.apache.org/viewvc/ibatis/trunk/java/tools/ibator/core/testJava2/ibatortest/java2/execute/flat/java2/SqlMapConfig.xml?rev=648102&view=auto ============================================================================== --- ibatis/trunk/java/tools/ibator/core/testJava2/ibatortest/java2/execute/flat/java2/SqlMapConfig.xml (added) +++ ibatis/trunk/java/tools/ibator/core/testJava2/ibatortest/java2/execute/flat/java2/SqlMapConfig.xml Mon Apr 14 19:32:53 2008 @@ -0,0 +1,28 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE sqlMapConfig + PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" + "http://ibatis.apache.org/dtd/sql-map-config-2.dtd";> + +<sqlMapConfig> + + <settings useStatementNamespaces="true" /> + + <transactionManager type="JDBC"> + <dataSource type="SIMPLE"> + <property name="JDBC.Driver" value="org.hsqldb.jdbcDriver"/> + <property name="JDBC.ConnectionURL" value="jdbc:hsqldb:mem:aname"/> + <property name="JDBC.Username" value="sa"/> + <property name="JDBC.Password" value=""/> + <property name="JDBC.DefaultAutoCommit" value="true"/> + </dataSource> + </transactionManager> + + <sqlMap resource="ibatortest/java2/generated/flat/java2/xml/FIELDSBLOBS_SqlMap.xml" /> + <sqlMap resource="ibatortest/java2/generated/flat/java2/xml/FIELDSONLY_SqlMap.xml" /> + <sqlMap resource="ibatortest/java2/generated/flat/java2/xml/PKBLOBS_SqlMap.xml" /> + <sqlMap resource="ibatortest/java2/generated/flat/java2/xml/PKFIELDS_SqlMap.xml" /> + <sqlMap resource="ibatortest/java2/generated/flat/java2/xml/PKFIELDSBLOBS_SqlMap.xml" /> + <sqlMap resource="ibatortest/java2/generated/flat/java2/xml/PKONLY_SqlMap.xml" /> + <sqlMap resource="ibatortest/java2/generated/flat/java2/xml/awful table_SqlMap.xml" /> + +</sqlMapConfig>
Added: ibatis/trunk/java/tools/ibator/core/testJava2/ibatortest/java2/execute/flat/java2/UpdateByExampleTests.java URL: http://svn.apache.org/viewvc/ibatis/trunk/java/tools/ibator/core/testJava2/ibatortest/java2/execute/flat/java2/UpdateByExampleTests.java?rev=648102&view=auto ============================================================================== --- ibatis/trunk/java/tools/ibator/core/testJava2/ibatortest/java2/execute/flat/java2/UpdateByExampleTests.java (added) +++ ibatis/trunk/java/tools/ibator/core/testJava2/ibatortest/java2/execute/flat/java2/UpdateByExampleTests.java Mon Apr 14 19:32:53 2008 @@ -0,0 +1,850 @@ +/* + * 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 ibatortest.java2.execute.flat.java2; + +import java.sql.SQLException; +import java.util.List; + +import ibatortest.java2.BaseTest; +import ibatortest.java2.generated.flat.java2.dao.AwfulTableDAO; +import ibatortest.java2.generated.flat.java2.dao.AwfulTableDAOImpl; +import ibatortest.java2.generated.flat.java2.dao.FieldsblobsDAO; +import ibatortest.java2.generated.flat.java2.dao.FieldsblobsDAOImpl; +import ibatortest.java2.generated.flat.java2.dao.FieldsonlyDAO; +import ibatortest.java2.generated.flat.java2.dao.FieldsonlyDAOImpl; +import ibatortest.java2.generated.flat.java2.dao.PkblobsDAO; +import ibatortest.java2.generated.flat.java2.dao.PkblobsDAOImpl; +import ibatortest.java2.generated.flat.java2.dao.PkfieldsDAO; +import ibatortest.java2.generated.flat.java2.dao.PkfieldsDAOImpl; +import ibatortest.java2.generated.flat.java2.dao.PkfieldsblobsDAO; +import ibatortest.java2.generated.flat.java2.dao.PkfieldsblobsDAOImpl; +import ibatortest.java2.generated.flat.java2.dao.PkonlyDAO; +import ibatortest.java2.generated.flat.java2.dao.PkonlyDAOImpl; +import ibatortest.java2.generated.flat.java2.model.AwfulTable; +import ibatortest.java2.generated.flat.java2.model.AwfulTableExample; +import ibatortest.java2.generated.flat.java2.model.Fieldsblobs; +import ibatortest.java2.generated.flat.java2.model.FieldsblobsExample; +import ibatortest.java2.generated.flat.java2.model.Fieldsonly; +import ibatortest.java2.generated.flat.java2.model.FieldsonlyExample; +import ibatortest.java2.generated.flat.java2.model.Pkblobs; +import ibatortest.java2.generated.flat.java2.model.PkblobsExample; +import ibatortest.java2.generated.flat.java2.model.Pkfields; +import ibatortest.java2.generated.flat.java2.model.PkfieldsExample; +import ibatortest.java2.generated.flat.java2.model.Pkfieldsblobs; +import ibatortest.java2.generated.flat.java2.model.PkfieldsblobsExample; +import ibatortest.java2.generated.flat.java2.model.Pkonly; +import ibatortest.java2.generated.flat.java2.model.PkonlyExample; + +/** + * + * @author Jeff Butler + * + */ +public class UpdateByExampleTests extends BaseTest { + + protected void setUp() throws Exception { + super.setUp(); + initSqlMapClient( + "ibatortest/java2/execute/flat/java2/SqlMapConfig.xml", + null); + } + + public void testFieldsOnlyUpdateByExampleSelective() { + 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); + + record = new Fieldsonly(); + record.setDoublefield(new Double(99)); + FieldsonlyExample example = new FieldsonlyExample(); + example.createCriteria().andIntegerfieldGreaterThan(new Integer(5)); + + int rows = dao.updateByExampleSelective(record, example); + assertEquals(2, rows); + + example.clear(); + example.createCriteria().andIntegerfieldEqualTo(new Integer(5)); + List answer = dao.selectByExample(example); + assertEquals(1, answer.size()); + record = (Fieldsonly) answer.get(0); + assertEquals(record.getDoublefield(), new Double(11.22)); + assertEquals(record.getFloatfield(), new Double(33.44)); + assertEquals(record.getIntegerfield(), new Integer(5)); + + example.clear(); + example.createCriteria().andIntegerfieldEqualTo(new Integer(8)); + answer = dao.selectByExample(example); + assertEquals(1, answer.size()); + record = (Fieldsonly) answer.get(0); + assertEquals(record.getDoublefield(), new Double(99)); + assertEquals(record.getFloatfield(), new Double(66.77)); + assertEquals(record.getIntegerfield(), new Integer(8)); + + example.clear(); + example.createCriteria().andIntegerfieldEqualTo(new Integer(9)); + answer = dao.selectByExample(example); + assertEquals(1, answer.size()); + record = (Fieldsonly) answer.get(0); + assertEquals(record.getDoublefield(), new Double(99)); + assertEquals(record.getFloatfield(), new Double(100.111)); + assertEquals(record.getIntegerfield(), new Integer(9)); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testFieldsOnlyUpdateByExample() { + 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); + + record = new Fieldsonly(); + record.setIntegerfield(new Integer(22)); + FieldsonlyExample example = new FieldsonlyExample(); + example.createCriteria().andIntegerfieldEqualTo(new Integer(5)); + + int rows = dao.updateByExample(record, example); + assertEquals(1, rows); + + example.clear(); + example.createCriteria().andIntegerfieldEqualTo(new Integer(22)); + List answer = dao.selectByExample(example); + assertEquals(1, answer.size()); + record = (Fieldsonly) answer.get(0); + assertNull(record.getDoublefield()); + assertNull(record.getFloatfield()); + assertEquals(record.getIntegerfield(), new Integer(22)); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKOnlyUpdateByExampleSelective() { + PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient); + + try { + Pkonly key = new Pkonly(); + key.setId(new Integer(1)); + key.setSeqNum(new Integer(3)); + dao.insert(key); + + key = new Pkonly(); + key.setId(new Integer(5)); + key.setSeqNum(new Integer(6)); + dao.insert(key); + + key = new Pkonly(); + key.setId(new Integer(7)); + key.setSeqNum(new Integer(8)); + dao.insert(key); + + PkonlyExample example = new PkonlyExample(); + example.createCriteria().andIdGreaterThan(new Integer(4)); + key = new Pkonly(); + key.setSeqNum(new Integer(3)); + int rows = dao.updateByExampleSelective(key, example); + assertEquals(2, rows); + + example.clear(); + example.createCriteria() + .andIdEqualTo(new Integer(5)) + .andSeqNumEqualTo(new Integer(3)); + + rows = dao.countByExample(example); + assertEquals(1, rows); + + example.clear(); + example.createCriteria() + .andIdEqualTo(new Integer(7)) + .andSeqNumEqualTo(new Integer(3)); + + rows = dao.countByExample(example); + assertEquals(1, rows); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKOnlyUpdateByExample() { + PkonlyDAO dao = new PkonlyDAOImpl(sqlMapClient); + + try { + Pkonly key = new Pkonly(); + key.setId(new Integer(1)); + key.setSeqNum(new Integer(3)); + dao.insert(key); + + key = new Pkonly(); + key.setId(new Integer(5)); + key.setSeqNum(new Integer(6)); + dao.insert(key); + + key = new Pkonly(); + key.setId(new Integer(7)); + key.setSeqNum(new Integer(8)); + dao.insert(key); + + PkonlyExample example = new PkonlyExample(); + example.createCriteria() + .andIdEqualTo(new Integer(7)); + key = new Pkonly(); + key.setSeqNum(new Integer(3)); + key.setId(new Integer(22)); + int rows = dao.updateByExample(key, example); + assertEquals(1, rows); + + example.clear(); + example.createCriteria() + .andIdEqualTo(new Integer(22)) + .andSeqNumEqualTo(new Integer(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(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); + + 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(new Integer(3)) + .andId2EqualTo(new Integer(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(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); + + record = new Pkfields(); + record.setFirstname("Fred"); + record.setId1(new Integer(3)); + record.setId2(new Integer(4)); + PkfieldsExample example = new PkfieldsExample(); + example.createCriteria() + .andId1EqualTo(new Integer(3)) + .andId2EqualTo(new Integer(4)); + + int rows = dao.updateByExample(record, example); + assertEquals(1, rows); + + example.clear(); + example.createCriteria() + .andFirstnameEqualTo("Fred") + .andLastnameIsNull() + .andId1EqualTo(new Integer(3)) + .andId2EqualTo(new Integer(4)); + + rows = dao.countByExample(example); + assertEquals(1, rows); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKBlobsUpdateByExampleSelective() { + PkblobsDAO dao = new PkblobsDAOImpl(sqlMapClient); + + try { + Pkblobs record = new Pkblobs(); + record.setId(new Integer(3)); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new Pkblobs(); + record.setId(new Integer(6)); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + Pkblobs newRecord = new Pkblobs(); + newRecord.setBlob1(generateRandomBlob()); + + PkblobsExample example = new PkblobsExample(); + example.createCriteria().andIdGreaterThan(new Integer(4)); + int rows = dao.updateByExampleSelective(newRecord, example); + assertEquals(1, rows); + + List answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkblobs returnedRecord = (Pkblobs) answer.get(0); + + assertEquals(new Integer(6), returnedRecord.getId()); + 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 { + Pkblobs record = new Pkblobs(); + record.setId(new Integer(3)); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new Pkblobs(); + record.setId(new Integer(6)); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + Pkblobs newRecord = new Pkblobs(); + newRecord.setId(new Integer(8)); + + PkblobsExample example = new PkblobsExample(); + example.createCriteria().andIdGreaterThan(new Integer(4)); + int rows = dao.updateByExampleWithoutBLOBs(newRecord, example); + assertEquals(1, rows); + + List answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkblobs returnedRecord = (Pkblobs) answer.get(0); + + assertEquals(new Integer(8), returnedRecord.getId()); + 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 { + Pkblobs record = new Pkblobs(); + record.setId(new Integer(3)); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new Pkblobs(); + record.setId(new Integer(6)); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + Pkblobs newRecord = new Pkblobs(); + newRecord.setId(new Integer(8)); + + PkblobsExample example = new PkblobsExample(); + example.createCriteria().andIdGreaterThan(new Integer(4)); + int rows = dao.updateByExampleWithBLOBs(newRecord, example); + assertEquals(1, rows); + + List answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkblobs returnedRecord = (Pkblobs) answer.get(0); + + assertEquals(new Integer(8), returnedRecord.getId()); + assertNull(returnedRecord.getBlob1()); + assertNull(returnedRecord.getBlob2()); + } catch (SQLException e) { + fail(e.getMessage()); + } + } + + public void testPKFieldsBlobsUpdateByExampleSelective() { + 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); + + Pkfieldsblobs newRecord = new Pkfieldsblobs(); + newRecord.setFirstname("Fred"); + PkfieldsblobsExample example = new PkfieldsblobsExample(); + example.createCriteria().andId1NotEqualTo(new Integer(3)); + int rows = dao.updateByExampleSelective(newRecord, example); + assertEquals(1, rows); + + 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(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 { + 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); + + Pkfieldsblobs newRecord = new Pkfieldsblobs(); + newRecord.setId1(new Integer(5)); + newRecord.setId2(new Integer(8)); + newRecord.setFirstname("Fred"); + PkfieldsblobsExample example = new PkfieldsblobsExample(); + example.createCriteria().andId1EqualTo(new Integer(5)); + int rows = dao.updateByExampleWithoutBLOBs(newRecord, example); + assertEquals(1, rows); + + List answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkfieldsblobs returnedRecord = (Pkfieldsblobs) 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 { + 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); + + Pkfieldsblobs newRecord = new Pkfieldsblobs(); + newRecord.setId1(new Integer(3)); + newRecord.setId2(new Integer(8)); + newRecord.setFirstname("Fred"); + PkfieldsblobsExample example = new PkfieldsblobsExample(); + example.createCriteria().andId1EqualTo(new Integer(3)); + int rows = dao.updateByExampleWithBLOBs(newRecord, example); + assertEquals(1, rows); + + List answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkfieldsblobs returnedRecord = (Pkfieldsblobs) 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 { + Fieldsblobs record = new Fieldsblobs(); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new Fieldsblobs(); + record.setFirstname("Scott"); + record.setLastname("Jones"); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + Fieldsblobs newRecord = new Fieldsblobs(); + 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()); + + Fieldsblobs returnedRecord = (Fieldsblobs) 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 { + Fieldsblobs record = new Fieldsblobs(); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new Fieldsblobs(); + 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.updateByExampleWithoutBLOBs(newRecord, example); + assertEquals(1, rows); + + List answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Fieldsblobs returnedRecord = (Fieldsblobs) 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 { + Fieldsblobs record = new Fieldsblobs(); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new Fieldsblobs(); + 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.updateByExampleWithBLOBs(newRecord, example); + assertEquals(1, rows); + + List answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Fieldsblobs returnedRecord = (Fieldsblobs) 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("[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); + + AwfulTable newRecord = new AwfulTable(); + newRecord.setFirstFirstName("Alonzo"); + AwfulTableExample example = new AwfulTableExample(); + example.createCriteria().andEMailLike("[EMAIL PROTECTED]"); + 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("[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); + + AwfulTable newRecord = new AwfulTable(); + newRecord.setFirstFirstName("Alonzo"); + newRecord.setCustomerId(new Integer(58)); + newRecord.setId1(new Integer(111)); + newRecord.setId2(new Integer(222)); + newRecord.setId5(new Integer(555)); + newRecord.setId6(new Integer(666)); + newRecord.setId7(new Integer(777)); + AwfulTableExample example = new AwfulTableExample(); + example.createCriteria().andEMailLike("[EMAIL PROTECTED]"); + int rows = dao.updateByExample(newRecord, example); + assertEquals(1, rows); + + example.clear(); + example.createCriteria().andCustomerIdEqualTo(new Integer(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()); + } + } +}
