Added: ibatis/trunk/java/tools/ibator/core/testJava5/ibatortest/execute/conditional/java5/SqlMapConfig.xml URL: http://svn.apache.org/viewvc/ibatis/trunk/java/tools/ibator/core/testJava5/ibatortest/execute/conditional/java5/SqlMapConfig.xml?rev=648102&view=auto ============================================================================== --- ibatis/trunk/java/tools/ibator/core/testJava5/ibatortest/execute/conditional/java5/SqlMapConfig.xml (added) +++ ibatis/trunk/java/tools/ibator/core/testJava5/ibatortest/execute/conditional/java5/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/generated/conditional/java5/xml/FIELDSBLOBS_SqlMap.xml" /> + <sqlMap resource="ibatortest/generated/conditional/java5/xml/FIELDSONLY_SqlMap.xml" /> + <sqlMap resource="ibatortest/generated/conditional/java5/xml/PKBLOBS_SqlMap.xml" /> + <sqlMap resource="ibatortest/generated/conditional/java5/xml/PKFIELDS_SqlMap.xml" /> + <sqlMap resource="ibatortest/generated/conditional/java5/xml/PKFIELDSBLOBS_SqlMap.xml" /> + <sqlMap resource="ibatortest/generated/conditional/java5/xml/PKONLY_SqlMap.xml" /> + <sqlMap resource="ibatortest/generated/conditional/java5/xml/awful table_SqlMap.xml" /> + +</sqlMapConfig>
Added: ibatis/trunk/java/tools/ibator/core/testJava5/ibatortest/execute/conditional/java5/UpdateByExampleTests.java URL: http://svn.apache.org/viewvc/ibatis/trunk/java/tools/ibator/core/testJava5/ibatortest/execute/conditional/java5/UpdateByExampleTests.java?rev=648102&view=auto ============================================================================== --- ibatis/trunk/java/tools/ibator/core/testJava5/ibatortest/execute/conditional/java5/UpdateByExampleTests.java (added) +++ ibatis/trunk/java/tools/ibator/core/testJava5/ibatortest/execute/conditional/java5/UpdateByExampleTests.java Mon Apr 14 19:32:53 2008 @@ -0,0 +1,851 @@ +/* + * 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.execute.conditional.java5; + +import java.sql.SQLException; +import java.util.List; + +import ibatortest.BaseTest; +import ibatortest.generated.conditional.java5.dao.AwfulTableDAO; +import ibatortest.generated.conditional.java5.dao.AwfulTableDAOImpl; +import ibatortest.generated.conditional.java5.dao.FieldsblobsDAO; +import ibatortest.generated.conditional.java5.dao.FieldsblobsDAOImpl; +import ibatortest.generated.conditional.java5.dao.FieldsonlyDAO; +import ibatortest.generated.conditional.java5.dao.FieldsonlyDAOImpl; +import ibatortest.generated.conditional.java5.dao.PkblobsDAO; +import ibatortest.generated.conditional.java5.dao.PkblobsDAOImpl; +import ibatortest.generated.conditional.java5.dao.PkfieldsDAO; +import ibatortest.generated.conditional.java5.dao.PkfieldsDAOImpl; +import ibatortest.generated.conditional.java5.dao.PkfieldsblobsDAO; +import ibatortest.generated.conditional.java5.dao.PkfieldsblobsDAOImpl; +import ibatortest.generated.conditional.java5.dao.PkonlyDAO; +import ibatortest.generated.conditional.java5.dao.PkonlyDAOImpl; +import ibatortest.generated.conditional.java5.model.AwfulTable; +import ibatortest.generated.conditional.java5.model.AwfulTableExample; +import ibatortest.generated.conditional.java5.model.Fieldsblobs; +import ibatortest.generated.conditional.java5.model.FieldsblobsExample; +import ibatortest.generated.conditional.java5.model.FieldsblobsWithBLOBs; +import ibatortest.generated.conditional.java5.model.Fieldsonly; +import ibatortest.generated.conditional.java5.model.FieldsonlyExample; +import ibatortest.generated.conditional.java5.model.Pkblobs; +import ibatortest.generated.conditional.java5.model.PkblobsExample; +import ibatortest.generated.conditional.java5.model.Pkfields; +import ibatortest.generated.conditional.java5.model.PkfieldsExample; +import ibatortest.generated.conditional.java5.model.Pkfieldsblobs; +import ibatortest.generated.conditional.java5.model.PkfieldsblobsExample; +import ibatortest.generated.conditional.java5.model.PkonlyExample; +import ibatortest.generated.conditional.java5.model.PkonlyKey; + +/** + * + * @author Jeff Butler + * + */ +public class UpdateByExampleTests extends BaseTest { + + protected void setUp() throws Exception { + super.setUp(); + initSqlMapClient( + "ibatortest/execute/conditional/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 { + Pkblobs record = new Pkblobs(); + record.setId(3); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new Pkblobs(); + record.setId(6); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + Pkblobs newRecord = new Pkblobs(); + newRecord.setBlob1(generateRandomBlob()); + + PkblobsExample example = new PkblobsExample(); + example.createCriteria().andIdGreaterThan(4); + int rows = dao.updateByExampleSelective(newRecord, example); + assertEquals(1, rows); + + List<Pkblobs> answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkblobs 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 { + Pkblobs record = new Pkblobs(); + record.setId(3); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new Pkblobs(); + record.setId(6); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + Pkblobs newRecord = new Pkblobs(); + newRecord.setId(8); + + PkblobsExample example = new PkblobsExample(); + example.createCriteria().andIdGreaterThan(4); + int rows = dao.updateByExampleWithoutBLOBs(newRecord, example); + assertEquals(1, rows); + + List<Pkblobs> answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkblobs 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 { + Pkblobs record = new Pkblobs(); + record.setId(3); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + record = new Pkblobs(); + record.setId(6); + record.setBlob1(generateRandomBlob()); + record.setBlob2(generateRandomBlob()); + dao.insert(record); + + Pkblobs newRecord = new Pkblobs(); + newRecord.setId(8); + + PkblobsExample example = new PkblobsExample(); + example.createCriteria().andIdGreaterThan(4); + int rows = dao.updateByExampleWithBLOBs(newRecord, example); + assertEquals(1, rows); + + List<Pkblobs> answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkblobs 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 { + Pkfieldsblobs record = new Pkfieldsblobs(); + record.setId1(3); + record.setId2(4); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + dao.insert(record); + + record = new Pkfieldsblobs(); + record.setId1(5); + record.setId2(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(3); + int rows = dao.updateByExampleSelective(newRecord, example); + assertEquals(1, rows); + + List<Pkfieldsblobs> answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkfieldsblobs 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 { + Pkfieldsblobs record = new Pkfieldsblobs(); + record.setId1(3); + record.setId2(4); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + dao.insert(record); + + record = new Pkfieldsblobs(); + 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.updateByExampleWithoutBLOBs(newRecord, example); + assertEquals(1, rows); + + List<Pkfieldsblobs> answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkfieldsblobs 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 { + Pkfieldsblobs record = new Pkfieldsblobs(); + record.setId1(3); + record.setId2(4); + record.setFirstname("Jeff"); + record.setLastname("Smith"); + record.setBlob1(generateRandomBlob()); + dao.insert(record); + + record = new Pkfieldsblobs(); + record.setId1(5); + record.setId2(6); + record.setFirstname("Scott"); + record.setLastname("Jones"); + record.setBlob1(generateRandomBlob()); + dao.insert(record); + + Pkfieldsblobs newRecord = new Pkfieldsblobs(); + newRecord.setId1(3); + newRecord.setId2(8); + newRecord.setFirstname("Fred"); + PkfieldsblobsExample example = new PkfieldsblobsExample(); + example.createCriteria().andId1EqualTo(3); + int rows = dao.updateByExampleWithBLOBs(newRecord, example); + assertEquals(1, rows); + + List<Pkfieldsblobs> answer = dao.selectByExampleWithBLOBs(example); + assertEquals(1, answer.size()); + + Pkfieldsblobs 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("[EMAIL PROTECTED]"); + record.setEmailaddress("[EMAIL PROTECTED]"); + 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("[EMAIL PROTECTED]"); + record.setEmailaddress("[EMAIL PROTECTED]"); + 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("[EMAIL PROTECTED]"); + 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("[EMAIL PROTECTED]"); + record.setEmailaddress("[EMAIL PROTECTED]"); + 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("[EMAIL PROTECTED]"); + record.setEmailaddress("[EMAIL PROTECTED]"); + 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("[EMAIL PROTECTED]"); + 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()); + } + } +}
