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