/*
* Copyright 2010 The MyBatis Team
*
* 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 mbg.test.mb3.annotated.flat;
import static mbg.test.common.util.TestUtilities.blobsAreEqual;
import static mbg.test.common.util.TestUtilities.datesAreEqual;
import static mbg.test.common.util.TestUtilities.generateRandomBlob;
import static mbg.test.common.util.TestUtilities.timesAreEqual;
import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertFalse;
import static org.junit.Assert.assertNotNull;
import static org.junit.Assert.assertNull;
import static org.junit.Assert.assertTrue;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import mbg.test.mb3.generated.annotated.flat.mapper.AwfulTableMapper;
import mbg.test.mb3.generated.annotated.flat.mapper.FieldsblobsMapper;
import mbg.test.mb3.generated.annotated.flat.mapper.FieldsonlyMapper;
import mbg.test.mb3.generated.annotated.flat.mapper.PkblobsMapper;
import mbg.test.mb3.generated.annotated.flat.mapper.PkfieldsMapper;
import mbg.test.mb3.generated.annotated.flat.mapper.PkfieldsblobsMapper;
import mbg.test.mb3.generated.annotated.flat.mapper.PkonlyMapper;
import mbg.test.mb3.generated.annotated.flat.model.AwfulTable;
import mbg.test.mb3.generated.annotated.flat.model.AwfulTableExample;
import mbg.test.mb3.generated.annotated.flat.model.Fieldsblobs;
import mbg.test.mb3.generated.annotated.flat.model.FieldsblobsExample;
import mbg.test.mb3.generated.annotated.flat.model.Fieldsonly;
import mbg.test.mb3.generated.annotated.flat.model.FieldsonlyExample;
import mbg.test.mb3.generated.annotated.flat.model.Pkblobs;
import mbg.test.mb3.generated.annotated.flat.model.PkblobsExample;
import mbg.test.mb3.generated.annotated.flat.model.Pkfields;
import mbg.test.mb3.generated.annotated.flat.model.PkfieldsExample;
import mbg.test.mb3.generated.annotated.flat.model.Pkfieldsblobs;
import mbg.test.mb3.generated.annotated.flat.model.PkfieldsblobsExample;
import mbg.test.mb3.generated.annotated.flat.model.Pkonly;
import mbg.test.mb3.generated.annotated.flat.model.PkonlyExample;
import org.apache.ibatis.session.RowBounds;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
/**
* @author Jeff Butler
*
*/
public class FlatJava5Test extends AbstractAnnotatedFlatTest {
@Test
public void testFieldsOnlyInsert() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsonlyMapper mapper = sqlSession.getMapper(FieldsonlyMapper.class);
Fieldsonly record = new Fieldsonly();
record.setDoublefield(11.22);
record.setFloatfield(33.44);
record.setIntegerfield(5);
mapper.insert(record);
FieldsonlyExample example = new FieldsonlyExample();
example.createCriteria().andIntegerfieldEqualTo(5);
List<Fieldsonly> answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
Fieldsonly returnedRecord = answer.get(0);
assertEquals(record.getIntegerfield(), returnedRecord
.getIntegerfield());
assertEquals(record.getDoublefield(), returnedRecord
.getDoublefield());
assertEquals(record.getFloatfield(), returnedRecord.getFloatfield());
} finally {
sqlSession.close();
}
}
@Test
public void testFieldsOnlySelectByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsonlyMapper mapper = sqlSession.getMapper(FieldsonlyMapper.class);
Fieldsonly record = new Fieldsonly();
record.setDoublefield(11.22);
record.setFloatfield(33.44);
record.setIntegerfield(5);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(44.55);
record.setFloatfield(66.77);
record.setIntegerfield(8);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(88.99);
record.setFloatfield(100.111);
record.setIntegerfield(9);
mapper.insert(record);
FieldsonlyExample example = new FieldsonlyExample();
example.createCriteria().andIntegerfieldGreaterThan(5);
List<Fieldsonly> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
example = new FieldsonlyExample();
answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testFieldsOnlySelectByExampleDistinct() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsonlyMapper mapper = sqlSession.getMapper(FieldsonlyMapper.class);
Fieldsonly record = new Fieldsonly();
record.setDoublefield(11.22);
record.setFloatfield(33.44);
record.setIntegerfield(5);
mapper.insert(record);
mapper.insert(record);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(44.55);
record.setFloatfield(66.77);
record.setIntegerfield(8);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(88.99);
record.setFloatfield(100.111);
record.setIntegerfield(9);
mapper.insert(record);
FieldsonlyExample example = new FieldsonlyExample();
example.createCriteria().andIntegerfieldEqualTo(5);
example.setDistinct(true);
List<Fieldsonly> answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
example.clear();
answer = mapper.selectByExample(example);
assertEquals(5, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testFieldsOnlySelectByExampleNoCriteria() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsonlyMapper mapper = sqlSession.getMapper(FieldsonlyMapper.class);
Fieldsonly record = new Fieldsonly();
record.setDoublefield(11.22);
record.setFloatfield(33.44);
record.setIntegerfield(5);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(44.55);
record.setFloatfield(66.77);
record.setIntegerfield(8);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(88.99);
record.setFloatfield(100.111);
record.setIntegerfield(9);
mapper.insert(record);
FieldsonlyExample example = new FieldsonlyExample();
example.createCriteria();
List<Fieldsonly> answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
answer = mapper.selectByExample(null);
assertEquals(3, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testFieldsOnlyDeleteByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsonlyMapper mapper = sqlSession.getMapper(FieldsonlyMapper.class);
Fieldsonly record = new Fieldsonly();
record.setDoublefield(11.22);
record.setFloatfield(33.44);
record.setIntegerfield(5);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(44.55);
record.setFloatfield(66.77);
record.setIntegerfield(8);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(88.99);
record.setFloatfield(100.111);
record.setIntegerfield(9);
mapper.insert(record);
FieldsonlyExample example = new FieldsonlyExample();
example.createCriteria().andIntegerfieldGreaterThan(5);
int rows = mapper.deleteByExample(example);
assertEquals(2, rows);
example = new FieldsonlyExample();
List<Fieldsonly> answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testFieldsOnlyCountByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsonlyMapper mapper = sqlSession.getMapper(FieldsonlyMapper.class);
Fieldsonly record = new Fieldsonly();
record.setDoublefield(11.22);
record.setFloatfield(33.44);
record.setIntegerfield(5);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(44.55);
record.setFloatfield(66.77);
record.setIntegerfield(8);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(88.99);
record.setFloatfield(100.111);
record.setIntegerfield(9);
mapper.insert(record);
FieldsonlyExample example = new FieldsonlyExample();
example.createCriteria().andIntegerfieldGreaterThan(5);
int rows = mapper.countByExample(example);
assertEquals(2, rows);
example.clear();
rows = mapper.countByExample(example);
assertEquals(3, rows);
} finally {
sqlSession.close();
}
}
@Test
public void testPKOnlyInsert() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
Pkonly key = new Pkonly();
key.setId(1);
key.setSeqNum(3);
mapper.insert(key);
PkonlyExample example = new PkonlyExample();
List<Pkonly> answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
Pkonly returnedRecord = answer.get(0);
assertEquals(key.getId(), returnedRecord.getId());
assertEquals(key.getSeqNum(), returnedRecord.getSeqNum());
} finally {
sqlSession.close();
}
}
@Test
public void testPKOnlyDeleteByPrimaryKey() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
Pkonly key = new Pkonly();
key.setId(1);
key.setSeqNum(3);
int rows = mapper.insert(key);
key = new Pkonly();
key.setId(5);
key.setSeqNum(6);
rows = mapper.insert(key);
PkonlyExample example = new PkonlyExample();
List<Pkonly> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
rows = mapper.deleteByPrimaryKey(5, 6);
assertEquals(1, rows);
answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKOnlyDeleteByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
Pkonly key = new Pkonly();
key.setId(1);
key.setSeqNum(3);
mapper.insert(key);
key = new Pkonly();
key.setId(5);
key.setSeqNum(6);
mapper.insert(key);
key = new Pkonly();
key.setId(7);
key.setSeqNum(8);
mapper.insert(key);
PkonlyExample example = new PkonlyExample();
example.createCriteria().andIdGreaterThan(4);
int rows = mapper.deleteByExample(example);
assertEquals(2, rows);
example = new PkonlyExample();
List<Pkonly> answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKOnlySelectByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
Pkonly key = new Pkonly();
key.setId(1);
key.setSeqNum(3);
mapper.insert(key);
key = new Pkonly();
key.setId(5);
key.setSeqNum(6);
mapper.insert(key);
key = new Pkonly();
key.setId(7);
key.setSeqNum(8);
mapper.insert(key);
PkonlyExample example = new PkonlyExample();
example.createCriteria().andIdGreaterThan(4);
List<Pkonly> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKOnlySelectByExampleNoCriteria() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
Pkonly key = new Pkonly();
key.setId(1);
key.setSeqNum(3);
mapper.insert(key);
key = new Pkonly();
key.setId(5);
key.setSeqNum(6);
mapper.insert(key);
key = new Pkonly();
key.setId(7);
key.setSeqNum(8);
mapper.insert(key);
PkonlyExample example = new PkonlyExample();
example.createCriteria();
List<Pkonly> answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKOnlyCountByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
Pkonly key = new Pkonly();
key.setId(1);
key.setSeqNum(3);
mapper.insert(key);
key = new Pkonly();
key.setId(5);
key.setSeqNum(6);
mapper.insert(key);
key = new Pkonly();
key.setId(7);
key.setSeqNum(8);
mapper.insert(key);
PkonlyExample example = new PkonlyExample();
example.createCriteria().andIdGreaterThan(4);
int rows = mapper.countByExample(example);
assertEquals(2, rows);
example.clear();
rows = mapper.countByExample(example);
assertEquals(3, rows);
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsInsert() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setDatefield(new Date());
record.setDecimal100field(10L);
record.setDecimal155field(new BigDecimal("15.12345"));
record.setDecimal30field((short) 3);
record.setDecimal60field(6);
record.setFirstname("Jeff");
record.setId1(1);
record.setId2(2);
record.setLastname("Butler");
record.setTimefield(new Date());
record.setTimestampfield(new Date());
record.setStringboolean(true);
mapper.insert(record);
Pkfields returnedRecord = mapper.selectByPrimaryKey(2, 1);
assertNotNull(returnedRecord);
assertTrue(datesAreEqual(record.getDatefield(), returnedRecord
.getDatefield()));
assertEquals(record.getDecimal100field(), returnedRecord
.getDecimal100field());
assertEquals(record.getDecimal155field(), returnedRecord
.getDecimal155field());
assertEquals(record.getDecimal30field(), returnedRecord
.getDecimal30field());
assertEquals(record.getDecimal60field(), returnedRecord
.getDecimal60field());
assertEquals(record.getFirstname(), returnedRecord.getFirstname());
assertEquals(record.getId1(), returnedRecord.getId1());
assertEquals(record.getId2(), returnedRecord.getId2());
assertEquals(record.getLastname(), returnedRecord.getLastname());
assertTrue(timesAreEqual(record.getTimefield(), returnedRecord
.getTimefield()));
assertEquals(record.getTimestampfield(), returnedRecord
.getTimestampfield());
assertEquals(record.isStringboolean(), returnedRecord.isStringboolean());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsUpdateByPrimaryKey() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record.setFirstname("Scott");
record.setLastname("Jones");
int rows = mapper.updateByPrimaryKey(record);
assertEquals(1, rows);
Pkfields record2 = mapper.selectByPrimaryKey(2, 1);
assertEquals(record.getFirstname(), record2.getFirstname());
assertEquals(record.getLastname(), record2.getLastname());
assertEquals(record.getId1(), record2.getId1());
assertEquals(record.getId2(), record2.getId2());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsUpdateByPrimaryKeySelective() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setDecimal60field(5);
record.setId1(1);
record.setId2(2);
mapper.insert(record);
Pkfields newRecord = new Pkfields();
newRecord.setId1(1);
newRecord.setId2(2);
newRecord.setFirstname("Scott");
newRecord.setDecimal60field(4);
int rows = mapper.updateByPrimaryKeySelective(newRecord);
assertEquals(1, rows);
Pkfields returnedRecord = mapper.selectByPrimaryKey(2, 1);
assertTrue(datesAreEqual(record.getDatefield(), returnedRecord
.getDatefield()));
assertEquals(record.getDecimal100field(), returnedRecord
.getDecimal100field());
assertEquals(record.getDecimal155field(), returnedRecord
.getDecimal155field());
assertEquals(record.getDecimal30field(), returnedRecord
.getDecimal30field());
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());
assertTrue(timesAreEqual(record.getTimefield(), returnedRecord
.getTimefield()));
assertEquals(record.getTimestampfield(), returnedRecord
.getTimestampfield());
} finally {
sqlSession.close();
}
}
@Test
public void testPKfieldsDeleteByPrimaryKey() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
int rows = mapper.deleteByPrimaryKey(2, 1);
assertEquals(1, rows);
PkfieldsExample example = new PkfieldsExample();
List<Pkfields> answer = mapper.selectByExample(example);
assertEquals(0, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsDeleteByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Bob");
record.setLastname("Jones");
record.setId1(3);
record.setId2(4);
mapper.insert(record);
PkfieldsExample example = new PkfieldsExample();
List<Pkfields> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
example = new PkfieldsExample();
example.createCriteria().andLastnameLike("J%");
int rows = mapper.deleteByExample(example);
assertEquals(1, rows);
example = new PkfieldsExample();
answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsSelectByPrimaryKey() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Bob");
record.setLastname("Jones");
record.setId1(3);
record.setId2(4);
mapper.insert(record);
Pkfields newRecord = mapper.selectByPrimaryKey(4, 3);
assertNotNull(newRecord);
assertEquals(record.getFirstname(), newRecord.getFirstname());
assertEquals(record.getLastname(), newRecord.getLastname());
assertEquals(record.getId1(), newRecord.getId1());
assertEquals(record.getId2(), newRecord.getId2());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsSelectByExampleLike() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Fred");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Wilma");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Pebbles");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(3);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Barney");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Betty");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Bamm Bamm");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(3);
mapper.insert(record);
PkfieldsExample example = new PkfieldsExample();
example.createCriteria().andFirstnameLike("B%");
example.setOrderByClause("ID1, ID2");
List<Pkfields> answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
Pkfields returnedRecord = answer.get(0);
assertEquals(2, returnedRecord.getId1().intValue());
assertEquals(1, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(2, returnedRecord.getId1().intValue());
assertEquals(2, returnedRecord.getId2().intValue());
returnedRecord = answer.get(2);
assertEquals(2, returnedRecord.getId1().intValue());
assertEquals(3, returnedRecord.getId2().intValue());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsSelectByExampleNotLike() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Fred");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Wilma");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Pebbles");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(3);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Barney");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Betty");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Bamm Bamm");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(3);
mapper.insert(record);
PkfieldsExample example = new PkfieldsExample();
example.createCriteria().andFirstnameNotLike("B%");
example.setOrderByClause("ID1, ID2");
List<Pkfields> answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
Pkfields returnedRecord = answer.get(0);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(1, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(2, returnedRecord.getId2().intValue());
returnedRecord = answer.get(2);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(3, returnedRecord.getId2().intValue());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsSelectByExampleComplexLike() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Fred");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Wilma");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Pebbles");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(3);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Barney");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Betty");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Bamm Bamm");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(3);
mapper.insert(record);
PkfieldsExample example = new PkfieldsExample();
example.createCriteria().andFirstnameLike("B%").andId2EqualTo(3);
example.or(example.createCriteria().andFirstnameLike("Wi%"));
example.setOrderByClause("ID1, ID2");
List<Pkfields> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
Pkfields returnedRecord = answer.get(0);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(2, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(2, returnedRecord.getId1().intValue());
assertEquals(3, returnedRecord.getId2().intValue());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsSelectByExampleIn() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Fred");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Wilma");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Pebbles");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(3);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Barney");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Betty");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Bamm Bamm");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(3);
mapper.insert(record);
List<Integer> ids = new ArrayList<Integer>();
ids.add(1);
ids.add(3);
PkfieldsExample example = new PkfieldsExample();
example.createCriteria().andId2In(ids);
example.setOrderByClause("ID1, ID2");
List<Pkfields> answer = mapper.selectByExample(example);
assertEquals(4, answer.size());
Pkfields returnedRecord = answer.get(0);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(1, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(3, returnedRecord.getId2().intValue());
returnedRecord = answer.get(2);
assertEquals(2, returnedRecord.getId1().intValue());
assertEquals(1, returnedRecord.getId2().intValue());
returnedRecord = answer.get(3);
assertEquals(2, returnedRecord.getId1().intValue());
assertEquals(3, returnedRecord.getId2().intValue());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsSelectByExampleBetween() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Fred");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Wilma");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Pebbles");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(3);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Barney");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Betty");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Bamm Bamm");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(3);
mapper.insert(record);
PkfieldsExample example = new PkfieldsExample();
example.createCriteria().andId2Between(1, 3);
example.setOrderByClause("ID1, ID2");
List<Pkfields> answer = mapper.selectByExample(example);
assertEquals(6, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsSelectByExampleBetweenWithRowbounds() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Fred");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Wilma");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Pebbles");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(3);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Barney");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Betty");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Bamm Bamm");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(3);
mapper.insert(record);
PkfieldsExample example = new PkfieldsExample();
example.createCriteria().andId2Between(1, 3);
example.setOrderByClause("ID1, ID2");
RowBounds rb = new RowBounds(2, 3);
List<Pkfields> answer = mapper.selectByExampleWithRowbounds(example, rb);
assertEquals(3, answer.size());
assertEquals("Pebbles", answer.get(0).getFirstname());
assertEquals("Barney", answer.get(1).getFirstname());
assertEquals("Betty", answer.get(2).getFirstname());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsSelectByExampleNoCriteria() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Fred");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Wilma");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Pebbles");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(3);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Barney");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(1);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Betty");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Bamm Bamm");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(3);
mapper.insert(record);
PkfieldsExample example = new PkfieldsExample();
example.createCriteria();
example.setOrderByClause("ID1, ID2");
List<Pkfields> answer = mapper.selectByExample(example);
assertEquals(6, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsSelectByExampleEscapedFields() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Fred");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(1);
record.setWierdField(11);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Wilma");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(2);
record.setWierdField(22);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Pebbles");
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(3);
record.setWierdField(33);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Barney");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(1);
record.setWierdField(44);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Betty");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(2);
record.setWierdField(55);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Bamm Bamm");
record.setLastname("Rubble");
record.setId1(2);
record.setId2(3);
record.setWierdField(66);
mapper.insert(record);
List<Integer> values = new ArrayList<Integer>();
values.add(11);
values.add(22);
PkfieldsExample example = new PkfieldsExample();
example.createCriteria().andWierdFieldLessThan(40).andWierdFieldIn(
values);
example.setOrderByClause("ID1, ID2");
List<Pkfields> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsCountByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
Pkfields record = new Pkfields();
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new Pkfields();
record.setFirstname("Bob");
record.setLastname("Jones");
record.setId1(3);
record.setId2(4);
mapper.insert(record);
PkfieldsExample example = new PkfieldsExample();
example.createCriteria().andLastnameLike("J%");
int rows = mapper.countByExample(example);
assertEquals(1, rows);
example.clear();
rows = mapper.countByExample(example);
assertEquals(2, rows);
} finally {
sqlSession.close();
}
}
@Test
public void testPKBlobsInsert() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
Pkblobs record = new Pkblobs();
record.setId(3);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
PkblobsExample example = new PkblobsExample();
List<Pkblobs> answer = mapper.selectByExampleWithBLOBs(example);
assertEquals(1, answer.size());
Pkblobs returnedRecord = answer.get(0);
assertEquals(record.getId(), returnedRecord.getId());
assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord
.getBlob1()));
assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord
.getBlob2()));
} finally {
sqlSession.close();
}
}
@Test
public void testPKBlobsUpdateByPrimaryKeyWithBLOBs() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
Pkblobs record = new Pkblobs();
record.setId(3);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
record = new Pkblobs();
record.setId(3);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
int rows = mapper.updateByPrimaryKeyWithBLOBs(record);
assertEquals(1, rows);
Pkblobs newRecord = mapper.selectByPrimaryKey(3);
assertNotNull(newRecord);
assertEquals(record.getId(), newRecord.getId());
assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
assertTrue(blobsAreEqual(record.getBlob2(), newRecord.getBlob2()));
} finally {
sqlSession.close();
}
}
@Test
public void testPKBlobsUpdateByPrimaryKeySelective() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
Pkblobs record = new Pkblobs();
record.setId(3);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
Pkblobs newRecord = new Pkblobs();
newRecord.setId(3);
newRecord.setBlob2(generateRandomBlob());
mapper.updateByPrimaryKeySelective(newRecord);
Pkblobs returnedRecord = mapper.selectByPrimaryKey(3);
assertNotNull(returnedRecord);
assertEquals(record.getId(), returnedRecord.getId());
assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord
.getBlob1()));
assertTrue(blobsAreEqual(newRecord.getBlob2(), returnedRecord
.getBlob2()));
} finally {
sqlSession.close();
}
}
@Test
public void testPKBlobsDeleteByPrimaryKey() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
Pkblobs record = new Pkblobs();
record.setId(3);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
PkblobsExample example = new PkblobsExample();
List<Pkblobs> answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
int rows = mapper.deleteByPrimaryKey(3);
assertEquals(1, rows);
example = new PkblobsExample();
answer = mapper.selectByExample(example);
assertEquals(0, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKBlobsDeleteByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
Pkblobs record = new Pkblobs();
record.setId(3);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
record = new Pkblobs();
record.setId(6);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
PkblobsExample example = new PkblobsExample();
List<Pkblobs> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
example = new PkblobsExample();
example.createCriteria().andIdLessThan(4);
int rows = mapper.deleteByExample(example);
assertEquals(1, rows);
example = new PkblobsExample();
answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKBlobsSelectByPrimaryKey() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
Pkblobs record = new Pkblobs();
record.setId(3);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
record = new Pkblobs();
record.setId(6);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
Pkblobs newRecord = mapper.selectByPrimaryKey(6);
assertNotNull(newRecord);
assertEquals(record.getId(), newRecord.getId());
assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
assertTrue(blobsAreEqual(record.getBlob2(), newRecord.getBlob2()));
} finally {
sqlSession.close();
}
}
@Test
public void testPKBlobsSelectByExampleWithoutBlobs() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
Pkblobs record = new Pkblobs();
record.setId(3);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
record = new Pkblobs();
record.setId(6);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
PkblobsExample example = new PkblobsExample();
example.createCriteria().andIdGreaterThan(4);
List<Pkblobs> answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
Pkblobs key = answer.get(0);
assertEquals(6, key.getId().intValue());
assertNull(key.getBlob1());
assertNull(key.getBlob2());
} finally {
sqlSession.close();
}
}
@Test
public void testPKBlobsSelectByExampleWithoutBlobsNoCriteria() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
Pkblobs record = new Pkblobs();
record.setId(3);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
record = new Pkblobs();
record.setId(6);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
PkblobsExample example = new PkblobsExample();
example.createCriteria();
List<Pkblobs> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKBlobsSelectByExampleWithBlobs() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
Pkblobs record = new Pkblobs();
record.setId(3);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
record = new Pkblobs();
record.setId(6);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
PkblobsExample example = new PkblobsExample();
example.createCriteria().andIdGreaterThan(4);
List<Pkblobs> answer = mapper.selectByExampleWithBLOBs(example);
assertEquals(1, answer.size());
Pkblobs newRecord = answer.get(0);
assertEquals(record.getId(), newRecord.getId());
assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
assertTrue(blobsAreEqual(record.getBlob2(), newRecord.getBlob2()));
} finally {
sqlSession.close();
}
}
@Test
public void testPKBlobsCountByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
Pkblobs record = new Pkblobs();
record.setId(3);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
record = new Pkblobs();
record.setId(6);
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
PkblobsExample example = new PkblobsExample();
example.createCriteria().andIdLessThan(4);
int rows = mapper.countByExample(example);
assertEquals(1, rows);
example.clear();
rows = mapper.countByExample(example);
assertEquals(2, rows);
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsBlobsInsert() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsblobsMapper mapper = sqlSession.getMapper(PkfieldsblobsMapper.class);
Pkfieldsblobs record = new Pkfieldsblobs();
record.setId1(3);
record.setId2(4);
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
PkfieldsblobsExample example = new PkfieldsblobsExample();
List<Pkfieldsblobs> answer = mapper.selectByExampleWithBLOBs(example);
assertEquals(1, answer.size());
Pkfieldsblobs returnedRecord = answer.get(0);
assertEquals(record.getId1(), returnedRecord.getId1());
assertEquals(record.getId2(), returnedRecord.getId2());
assertEquals(record.getFirstname(), returnedRecord.getFirstname());
assertEquals(record.getLastname(), returnedRecord.getLastname());
assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord
.getBlob1()));
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsBlobsUpdateByPrimaryKeyWithBLOBs() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsblobsMapper mapper = sqlSession.getMapper(PkfieldsblobsMapper.class);
Pkfieldsblobs record = new Pkfieldsblobs();
record.setId1(3);
record.setId2(4);
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
Pkfieldsblobs updateRecord = new Pkfieldsblobs();
updateRecord.setId1(3);
updateRecord.setId2(4);
updateRecord.setFirstname("Scott");
updateRecord.setLastname("Jones");
updateRecord.setBlob1(generateRandomBlob());
int rows = mapper.updateByPrimaryKeyWithBLOBs(updateRecord);
assertEquals(1, rows);
Pkfieldsblobs newRecord = mapper.selectByPrimaryKey(3, 4);
assertEquals(updateRecord.getFirstname(), newRecord.getFirstname());
assertEquals(updateRecord.getLastname(), newRecord.getLastname());
assertEquals(record.getId1(), newRecord.getId1());
assertEquals(record.getId2(), newRecord.getId2());
assertTrue(blobsAreEqual(updateRecord.getBlob1(), newRecord
.getBlob1()));
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsBlobsUpdateByPrimaryKeyWithoutBLOBs() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsblobsMapper mapper = sqlSession.getMapper(PkfieldsblobsMapper.class);
Pkfieldsblobs record = new Pkfieldsblobs();
record.setId1(3);
record.setId2(4);
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
Pkfieldsblobs updateRecord = new Pkfieldsblobs();
updateRecord.setId1(3);
updateRecord.setId2(4);
updateRecord.setFirstname("Scott");
updateRecord.setLastname("Jones");
int rows = mapper.updateByPrimaryKey(updateRecord);
assertEquals(1, rows);
Pkfieldsblobs newRecord = mapper.selectByPrimaryKey(3, 4);
assertEquals(updateRecord.getFirstname(), newRecord.getFirstname());
assertEquals(updateRecord.getLastname(), newRecord.getLastname());
assertEquals(record.getId1(), newRecord.getId1());
assertEquals(record.getId2(), newRecord.getId2());
assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsBlobsUpdateByPrimaryKeySelective() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsblobsMapper mapper = sqlSession.getMapper(PkfieldsblobsMapper.class);
Pkfieldsblobs record = new Pkfieldsblobs();
record.setId1(3);
record.setId2(4);
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
Pkfieldsblobs updateRecord = new Pkfieldsblobs();
updateRecord.setId1(3);
updateRecord.setId2(4);
updateRecord.setLastname("Jones");
int rows = mapper.updateByPrimaryKeySelective(updateRecord);
assertEquals(1, rows);
Pkfieldsblobs returnedRecord = mapper.selectByPrimaryKey(3, 4);
assertEquals(record.getFirstname(), returnedRecord.getFirstname());
assertEquals(updateRecord.getLastname(), returnedRecord
.getLastname());
assertEquals(record.getId1(), returnedRecord.getId1());
assertEquals(record.getId2(), returnedRecord.getId2());
assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord
.getBlob1()));
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsBlobsDeleteByPrimaryKey() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsblobsMapper mapper = sqlSession.getMapper(PkfieldsblobsMapper.class);
Pkfieldsblobs record = new Pkfieldsblobs();
record.setId1(3);
record.setId2(4);
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
record = new Pkfieldsblobs();
record.setId1(5);
record.setId2(6);
record.setFirstname("Scott");
record.setLastname("Jones");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
PkfieldsblobsExample example = new PkfieldsblobsExample();
List<Pkfieldsblobs> answer = mapper
.selectByExample(example);
assertEquals(2, answer.size());
int rows = mapper.deleteByPrimaryKey(5, 6);
assertEquals(1, rows);
example = new PkfieldsblobsExample();
answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsBlobsDeleteByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsblobsMapper mapper = sqlSession.getMapper(PkfieldsblobsMapper.class);
Pkfieldsblobs record = new Pkfieldsblobs();
record.setId1(3);
record.setId2(4);
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
record = new Pkfieldsblobs();
record.setId1(5);
record.setId2(6);
record.setFirstname("Scott");
record.setLastname("Jones");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
PkfieldsblobsExample example = new PkfieldsblobsExample();
List<Pkfieldsblobs> answer = mapper
.selectByExample(example);
assertEquals(2, answer.size());
example = new PkfieldsblobsExample();
example.createCriteria().andId1NotEqualTo(3);
int rows = mapper.deleteByExample(example);
assertEquals(1, rows);
example = new PkfieldsblobsExample();
answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsBlobsSelectByPrimaryKey() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsblobsMapper mapper = sqlSession.getMapper(PkfieldsblobsMapper.class);
Pkfieldsblobs record = new Pkfieldsblobs();
record.setId1(3);
record.setId2(4);
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
record = new Pkfieldsblobs();
record.setId1(5);
record.setId2(6);
record.setFirstname("Scott");
record.setLastname("Jones");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
PkfieldsblobsExample example = new PkfieldsblobsExample();
List<Pkfieldsblobs> answer = mapper
.selectByExample(example);
assertEquals(2, answer.size());
Pkfieldsblobs newRecord = mapper.selectByPrimaryKey(5, 6);
assertEquals(record.getId1(), newRecord.getId1());
assertEquals(record.getId2(), newRecord.getId2());
assertEquals(record.getFirstname(), newRecord.getFirstname());
assertEquals(record.getLastname(), newRecord.getLastname());
assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsBlobsSelectByExampleWithoutBlobs() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsblobsMapper mapper = sqlSession.getMapper(PkfieldsblobsMapper.class);
Pkfieldsblobs record = new Pkfieldsblobs();
record.setId1(3);
record.setId2(4);
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
record = new Pkfieldsblobs();
record.setId1(5);
record.setId2(6);
record.setFirstname("Scott");
record.setLastname("Jones");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
PkfieldsblobsExample example = new PkfieldsblobsExample();
example.createCriteria().andId2EqualTo(6);
List<Pkfieldsblobs> answer = mapper
.selectByExample(example);
assertEquals(1, answer.size());
Pkfieldsblobs newRecord = answer.get(0);
assertEquals(record.getId1(), newRecord.getId1());
assertEquals(record.getId2(), newRecord.getId2());
assertEquals(record.getFirstname(), newRecord.getFirstname());
assertEquals(record.getLastname(), newRecord.getLastname());
assertNull(newRecord.getBlob1());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsBlobsSelectByExampleWithBlobs() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsblobsMapper mapper = sqlSession.getMapper(PkfieldsblobsMapper.class);
Pkfieldsblobs record = new Pkfieldsblobs();
record.setId1(3);
record.setId2(4);
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
record = new Pkfieldsblobs();
record.setId1(5);
record.setId2(6);
record.setFirstname("Scott");
record.setLastname("Jones");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
PkfieldsblobsExample example = new PkfieldsblobsExample();
example.createCriteria().andId2EqualTo(6);
List<Pkfieldsblobs> answer = mapper.selectByExampleWithBLOBs(example);
assertEquals(1, answer.size());
Pkfieldsblobs newRecord = answer.get(0);
assertEquals(record.getId1(), newRecord.getId1());
assertEquals(record.getId2(), newRecord.getId2());
assertEquals(record.getFirstname(), newRecord.getFirstname());
assertEquals(record.getLastname(), newRecord.getLastname());
assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsBlobsSelectByExampleWithBlobsNoCriteria() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsblobsMapper mapper = sqlSession.getMapper(PkfieldsblobsMapper.class);
Pkfieldsblobs record = new Pkfieldsblobs();
record.setId1(3);
record.setId2(4);
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
record = new Pkfieldsblobs();
record.setId1(5);
record.setId2(6);
record.setFirstname("Scott");
record.setLastname("Jones");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
PkfieldsblobsExample example = new PkfieldsblobsExample();
example.createCriteria();
List<Pkfieldsblobs> answer = mapper.selectByExampleWithBLOBs(example);
assertEquals(2, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testFieldsBlobsInsert() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsblobsMapper mapper = sqlSession.getMapper(FieldsblobsMapper.class);
Fieldsblobs record = new Fieldsblobs();
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
FieldsblobsExample example = new FieldsblobsExample();
List<Fieldsblobs> answer = mapper.selectByExampleWithBLOBs(example);
assertEquals(1, answer.size());
Fieldsblobs returnedRecord = answer.get(0);
assertEquals(record.getFirstname(), returnedRecord.getFirstname());
assertEquals(record.getLastname(), returnedRecord.getLastname());
assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord
.getBlob1()));
assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord
.getBlob2()));
} finally {
sqlSession.close();
}
}
@Test
public void testFieldsBlobsDeleteByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsblobsMapper mapper = sqlSession.getMapper(FieldsblobsMapper.class);
Fieldsblobs record = new Fieldsblobs();
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
record = new Fieldsblobs();
record.setFirstname("Scott");
record.setLastname("Jones");
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
FieldsblobsExample example = new FieldsblobsExample();
List<Fieldsblobs> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
example = new FieldsblobsExample();
example.createCriteria().andFirstnameLike("S%");
int rows = mapper.deleteByExample(example);
assertEquals(1, rows);
example = new FieldsblobsExample();
answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testFieldsBlobsSelectByExampleWithoutBlobs() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsblobsMapper mapper = sqlSession.getMapper(FieldsblobsMapper.class);
Fieldsblobs record = new Fieldsblobs();
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
record = new Fieldsblobs();
record.setFirstname("Scott");
record.setLastname("Jones");
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
FieldsblobsExample example = new FieldsblobsExample();
example.createCriteria().andFirstnameLike("S%");
List<Fieldsblobs> answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
Fieldsblobs newRecord = answer.get(0);
assertEquals(record.getFirstname(), newRecord.getFirstname());
assertEquals(record.getLastname(), newRecord.getLastname());
assertNull(newRecord.getBlob1());
assertNull(newRecord.getBlob2());
} finally {
sqlSession.close();
}
}
@Test
public void testFieldsBlobsSelectByExampleWithBlobs() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsblobsMapper mapper = sqlSession.getMapper(FieldsblobsMapper.class);
Fieldsblobs record = new Fieldsblobs();
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
record = new Fieldsblobs();
record.setFirstname("Scott");
record.setLastname("Jones");
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
FieldsblobsExample example = new FieldsblobsExample();
example.createCriteria().andFirstnameLike("S%");
List<Fieldsblobs> answer = mapper.selectByExampleWithBLOBs(example);
assertEquals(1, answer.size());
Fieldsblobs newRecord = answer.get(0);
assertEquals(record.getFirstname(), newRecord.getFirstname());
assertEquals(record.getLastname(), newRecord.getLastname());
assertTrue(blobsAreEqual(record.getBlob1(), newRecord.getBlob1()));
assertTrue(blobsAreEqual(record.getBlob2(), newRecord.getBlob2()));
} finally {
sqlSession.close();
}
}
@Test
public void testFieldsBlobsSelectByExampleWithBlobsNoCriteria() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsblobsMapper mapper = sqlSession.getMapper(FieldsblobsMapper.class);
Fieldsblobs record = new Fieldsblobs();
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
record = new Fieldsblobs();
record.setFirstname("Scott");
record.setLastname("Jones");
record.setBlob1(generateRandomBlob());
record.setBlob2(generateRandomBlob());
mapper.insert(record);
FieldsblobsExample example = new FieldsblobsExample();
example.createCriteria();
List<Fieldsblobs> answer = mapper.selectByExampleWithBLOBs(example);
assertEquals(2, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testPKFieldsBlobsCountByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkfieldsblobsMapper mapper = sqlSession.getMapper(PkfieldsblobsMapper.class);
Pkfieldsblobs record = new Pkfieldsblobs();
record.setId1(3);
record.setId2(4);
record.setFirstname("Jeff");
record.setLastname("Smith");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
record = new Pkfieldsblobs();
record.setId1(5);
record.setId2(6);
record.setFirstname("Scott");
record.setLastname("Jones");
record.setBlob1(generateRandomBlob());
mapper.insert(record);
PkfieldsblobsExample example = new PkfieldsblobsExample();
example.createCriteria().andId1NotEqualTo(3);
int rows = mapper.countByExample(example);
assertEquals(1, rows);
example.clear();
rows = mapper.countByExample(example);
assertEquals(2, rows);
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableInsert() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
Integer generatedCustomerId = record.getCustomerId();
assertEquals(57, generatedCustomerId.intValue());
AwfulTable returnedRecord = mapper
.selectByPrimaryKey(generatedCustomerId);
assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
assertEquals(record.geteMail(), returnedRecord.geteMail());
assertEquals(record.getEmailaddress(), returnedRecord
.getEmailaddress());
assertEquals(record.getFirstFirstName(), returnedRecord
.getFirstFirstName());
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.getSecondFirstName(), returnedRecord
.getSecondFirstName());
assertEquals(record.getThirdFirstName(), returnedRecord
.getThirdFirstName());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableInsertSelective() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insertSelective(record);
Integer generatedCustomerId = record.getCustomerId();
assertEquals(57, generatedCustomerId.intValue());
AwfulTable returnedRecord = mapper
.selectByPrimaryKey(generatedCustomerId);
assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
assertEquals(record.geteMail(), returnedRecord.geteMail());
assertEquals(record.getEmailaddress(), returnedRecord
.getEmailaddress());
assertEquals("Mabel", returnedRecord.getFirstFirstName());
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.getSecondFirstName(), returnedRecord
.getSecondFirstName());
assertEquals(record.getThirdFirstName(), returnedRecord
.getThirdFirstName());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableUpdateByPrimaryKey() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
Integer generatedCustomerId = record.getCustomerId();
record.setId1(11);
record.setId2(22);
int rows = mapper.updateByPrimaryKey(record);
assertEquals(1, rows);
AwfulTable returnedRecord = mapper.selectByPrimaryKey(generatedCustomerId);
assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
assertEquals(record.geteMail(), returnedRecord.geteMail());
assertEquals(record.getEmailaddress(), returnedRecord
.getEmailaddress());
assertEquals(record.getFirstFirstName(), returnedRecord
.getFirstFirstName());
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.getSecondFirstName(), returnedRecord
.getSecondFirstName());
assertEquals(record.getThirdFirstName(), returnedRecord
.getThirdFirstName());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableUpdateByPrimaryKeySelective() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
Integer generatedCustomerId = record.getCustomerId();
AwfulTable newRecord = new AwfulTable();
newRecord.setCustomerId(generatedCustomerId);
newRecord.setId1(11);
newRecord.setId2(22);
int rows = mapper.updateByPrimaryKeySelective(newRecord);
assertEquals(1, rows);
AwfulTable returnedRecord = mapper.selectByPrimaryKey(generatedCustomerId);
assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
assertEquals(record.geteMail(), returnedRecord.geteMail());
assertEquals(record.getEmailaddress(), returnedRecord
.getEmailaddress());
assertEquals(record.getFirstFirstName(), returnedRecord
.getFirstFirstName());
assertEquals(record.getFrom(), returnedRecord.getFrom());
assertEquals(newRecord.getId1(), returnedRecord.getId1());
assertEquals(newRecord.getId2(), returnedRecord.getId2());
assertEquals(record.getId5(), returnedRecord.getId5());
assertEquals(record.getId6(), returnedRecord.getId6());
assertEquals(record.getId7(), returnedRecord.getId7());
assertEquals(record.getSecondFirstName(), returnedRecord
.getSecondFirstName());
assertEquals(record.getThirdFirstName(), returnedRecord
.getThirdFirstName());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableDeleteByPrimaryKey() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
Integer generatedCustomerId = record.getCustomerId();
int rows = mapper.deleteByPrimaryKey(generatedCustomerId);
assertEquals(1, rows);
AwfulTableExample example = new AwfulTableExample();
List<AwfulTable> answer = mapper.selectByExample(example);
assertEquals(0, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableDeleteByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("fred2@fred.com");
record.setEmailaddress("alsofred2@fred.com");
record.setFirstFirstName("fred11");
record.setFrom("from from field");
record.setId1(11);
record.setId2(22);
record.setId5(55);
record.setId6(66);
record.setId7(77);
record.setSecondFirstName("fred22");
record.setThirdFirstName("fred33");
mapper.insert(record);
AwfulTableExample example = new AwfulTableExample();
List<AwfulTable> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
example = new AwfulTableExample();
example.createCriteria().andEMailLike("fred@%");
int rows = mapper.deleteByExample(example);
assertEquals(1, rows);
example.clear();
answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableSelectByPrimaryKey() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("fred2@fred.com");
record.setEmailaddress("alsofred2@fred.com");
record.setFirstFirstName("fred11");
record.setFrom("from from field");
record.setId1(11);
record.setId2(22);
record.setId5(55);
record.setId6(66);
record.setId7(77);
record.setSecondFirstName("fred22");
record.setThirdFirstName("fred33");
mapper.insert(record);
Integer generatedKey = record.getCustomerId();
AwfulTable returnedRecord = mapper.selectByPrimaryKey(generatedKey);
assertNotNull(returnedRecord);
assertEquals(record.getCustomerId(), returnedRecord.getCustomerId());
assertEquals(record.geteMail(), returnedRecord.geteMail());
assertEquals(record.getEmailaddress(), returnedRecord
.getEmailaddress());
assertEquals(record.getFirstFirstName(), returnedRecord
.getFirstFirstName());
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.getSecondFirstName(), returnedRecord
.getSecondFirstName());
assertEquals(record.getThirdFirstName(), returnedRecord
.getThirdFirstName());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableSelectByExampleLike() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("wilma@wilma.com");
record.setEmailaddress("alsoWilma@wilma.com");
record.setFirstFirstName("wilma1");
record.setFrom("from field");
record.setId1(11);
record.setId2(22);
record.setId5(55);
record.setId6(66);
record.setId7(77);
record.setSecondFirstName("wilma2");
record.setThirdFirstName("wilma3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("pebbles@pebbles.com");
record.setEmailaddress("alsoPebbles@pebbles.com");
record.setFirstFirstName("pebbles1");
record.setFrom("from field");
record.setId1(111);
record.setId2(222);
record.setId5(555);
record.setId6(666);
record.setId7(777);
record.setSecondFirstName("pebbles2");
record.setThirdFirstName("pebbles3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("barney@barney.com");
record.setEmailaddress("alsoBarney@barney.com");
record.setFirstFirstName("barney1");
record.setFrom("from field");
record.setId1(1111);
record.setId2(2222);
record.setId5(5555);
record.setId6(6666);
record.setId7(7777);
record.setSecondFirstName("barney2");
record.setThirdFirstName("barney3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("betty@betty.com");
record.setEmailaddress("alsoBetty@betty.com");
record.setFirstFirstName("betty1");
record.setFrom("from field");
record.setId1(11111);
record.setId2(22222);
record.setId5(55555);
record.setId6(66666);
record.setId7(77777);
record.setSecondFirstName("betty2");
record.setThirdFirstName("betty3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("bammbamm@bammbamm.com");
record.setEmailaddress("alsoBammbamm@bammbamm.com");
record.setFirstFirstName("bammbamm1");
record.setFrom("from field");
record.setId1(111111);
record.setId2(222222);
record.setId5(555555);
record.setId6(666666);
record.setId7(777777);
record.setSecondFirstName("bammbamm2");
record.setThirdFirstName("bammbamm3");
mapper.insert(record);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andFirstFirstNameLike("b%");
example.setOrderByClause("\"A_CuStOmEr iD\"");
List<AwfulTable> answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
AwfulTable returnedRecord = answer.get(0);
assertEquals(1111, returnedRecord.getId1().intValue());
assertEquals(2222, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(11111, returnedRecord.getId1().intValue());
assertEquals(22222, returnedRecord.getId2().intValue());
returnedRecord = answer.get(2);
assertEquals(111111, returnedRecord.getId1().intValue());
assertEquals(222222, returnedRecord.getId2().intValue());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableSelectByExampleNotLike() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("wilma@wilma.com");
record.setEmailaddress("alsoWilma@wilma.com");
record.setFirstFirstName("wilma1");
record.setFrom("from field");
record.setId1(11);
record.setId2(22);
record.setId5(55);
record.setId6(66);
record.setId7(77);
record.setSecondFirstName("wilma2");
record.setThirdFirstName("wilma3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("pebbles@pebbles.com");
record.setEmailaddress("alsoPebbles@pebbles.com");
record.setFirstFirstName("pebbles1");
record.setFrom("from field");
record.setId1(111);
record.setId2(222);
record.setId5(555);
record.setId6(666);
record.setId7(777);
record.setSecondFirstName("pebbles2");
record.setThirdFirstName("pebbles3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("barney@barney.com");
record.setEmailaddress("alsoBarney@barney.com");
record.setFirstFirstName("barney1");
record.setFrom("from field");
record.setId1(1111);
record.setId2(2222);
record.setId5(5555);
record.setId6(6666);
record.setId7(7777);
record.setSecondFirstName("barney2");
record.setThirdFirstName("barney3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("betty@betty.com");
record.setEmailaddress("alsoBetty@betty.com");
record.setFirstFirstName("betty1");
record.setFrom("from field");
record.setId1(11111);
record.setId2(22222);
record.setId5(55555);
record.setId6(66666);
record.setId7(77777);
record.setSecondFirstName("betty2");
record.setThirdFirstName("betty3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("bammbamm@bammbamm.com");
record.setEmailaddress("alsoBammbamm@bammbamm.com");
record.setFirstFirstName("bammbamm1");
record.setFrom("from field");
record.setId1(111111);
record.setId2(222222);
record.setId5(555555);
record.setId6(666666);
record.setId7(777777);
record.setSecondFirstName("bammbamm2");
record.setThirdFirstName("bammbamm3");
mapper.insert(record);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andFirstFirstNameNotLike("b%");
example.setOrderByClause("\"A_CuStOmEr iD\"");
List<AwfulTable> answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
AwfulTable returnedRecord = answer.get(0);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(2, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(11, returnedRecord.getId1().intValue());
assertEquals(22, returnedRecord.getId2().intValue());
returnedRecord = answer.get(2);
assertEquals(111, returnedRecord.getId1().intValue());
assertEquals(222, returnedRecord.getId2().intValue());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableSelectByExampleComplexLike() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("wilma@wilma.com");
record.setEmailaddress("alsoWilma@wilma.com");
record.setFirstFirstName("wilma1");
record.setFrom("from field");
record.setId1(11);
record.setId2(22);
record.setId5(55);
record.setId6(66);
record.setId7(77);
record.setSecondFirstName("wilma2");
record.setThirdFirstName("wilma3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("pebbles@pebbles.com");
record.setEmailaddress("alsoPebbles@pebbles.com");
record.setFirstFirstName("pebbles1");
record.setFrom("from field");
record.setId1(111);
record.setId2(222);
record.setId5(555);
record.setId6(666);
record.setId7(777);
record.setSecondFirstName("pebbles2");
record.setThirdFirstName("pebbles3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("barney@barney.com");
record.setEmailaddress("alsoBarney@barney.com");
record.setFirstFirstName("barney1");
record.setFrom("from field");
record.setId1(1111);
record.setId2(2222);
record.setId5(5555);
record.setId6(6666);
record.setId7(7777);
record.setSecondFirstName("barney2");
record.setThirdFirstName("barney3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("betty@betty.com");
record.setEmailaddress("alsoBetty@betty.com");
record.setFirstFirstName("betty1");
record.setFrom("from field");
record.setId1(11111);
record.setId2(22222);
record.setId5(55555);
record.setId6(66666);
record.setId7(77777);
record.setSecondFirstName("betty2");
record.setThirdFirstName("betty3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("bammbamm@bammbamm.com");
record.setEmailaddress("alsoBammbamm@bammbamm.com");
record.setFirstFirstName("bammbamm1");
record.setFrom("from field");
record.setId1(111111);
record.setId2(222222);
record.setId5(555555);
record.setId6(666666);
record.setId7(777777);
record.setSecondFirstName("bammbamm2");
record.setThirdFirstName("bammbamm3");
mapper.insert(record);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andFirstFirstNameLike("b%").andId2EqualTo(222222);
example.or(example.createCriteria().andFirstFirstNameLike("wi%"));
example.setOrderByClause("\"A_CuStOmEr iD\"");
List<AwfulTable> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
AwfulTable returnedRecord = answer.get(0);
assertEquals(11, returnedRecord.getId1().intValue());
assertEquals(22, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(111111, returnedRecord.getId1().intValue());
assertEquals(222222, returnedRecord.getId2().intValue());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableSelectByExampleIn() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("wilma@wilma.com");
record.setEmailaddress("alsoWilma@wilma.com");
record.setFirstFirstName("wilma1");
record.setFrom("from field");
record.setId1(11);
record.setId2(22);
record.setId5(55);
record.setId6(66);
record.setId7(77);
record.setSecondFirstName("wilma2");
record.setThirdFirstName("wilma3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("pebbles@pebbles.com");
record.setEmailaddress("alsoPebbles@pebbles.com");
record.setFirstFirstName("pebbles1");
record.setFrom("from field");
record.setId1(111);
record.setId2(222);
record.setId5(555);
record.setId6(666);
record.setId7(777);
record.setSecondFirstName("pebbles2");
record.setThirdFirstName("pebbles3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("barney@barney.com");
record.setEmailaddress("alsoBarney@barney.com");
record.setFirstFirstName("barney1");
record.setFrom("from field");
record.setId1(1111);
record.setId2(2222);
record.setId5(5555);
record.setId6(6666);
record.setId7(7777);
record.setSecondFirstName("barney2");
record.setThirdFirstName("barney3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("betty@betty.com");
record.setEmailaddress("alsoBetty@betty.com");
record.setFirstFirstName("betty1");
record.setFrom("from field");
record.setId1(11111);
record.setId2(22222);
record.setId5(55555);
record.setId6(66666);
record.setId7(77777);
record.setSecondFirstName("betty2");
record.setThirdFirstName("betty3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("bammbamm@bammbamm.com");
record.setEmailaddress("alsoBammbamm@bammbamm.com");
record.setFirstFirstName("bammbamm1");
record.setFrom("from field");
record.setId1(111111);
record.setId2(222222);
record.setId5(555555);
record.setId6(666666);
record.setId7(777777);
record.setSecondFirstName("bammbamm2");
record.setThirdFirstName("bammbamm3");
mapper.insert(record);
List<Integer> ids = new ArrayList<Integer>();
ids.add(1);
ids.add(11);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andId1In(ids);
example.setOrderByClause("\"A_CuStOmEr iD\"");
List<AwfulTable> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
AwfulTable returnedRecord = answer.get(0);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(2, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(11, returnedRecord.getId1().intValue());
assertEquals(22, returnedRecord.getId2().intValue());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableSelectByExampleBetween() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("wilma@wilma.com");
record.setEmailaddress("alsoWilma@wilma.com");
record.setFirstFirstName("wilma1");
record.setFrom("from field");
record.setId1(11);
record.setId2(22);
record.setId5(55);
record.setId6(66);
record.setId7(77);
record.setSecondFirstName("wilma2");
record.setThirdFirstName("wilma3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("pebbles@pebbles.com");
record.setEmailaddress("alsoPebbles@pebbles.com");
record.setFirstFirstName("pebbles1");
record.setFrom("from field");
record.setId1(111);
record.setId2(222);
record.setId5(555);
record.setId6(666);
record.setId7(777);
record.setSecondFirstName("pebbles2");
record.setThirdFirstName("pebbles3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("barney@barney.com");
record.setEmailaddress("alsoBarney@barney.com");
record.setFirstFirstName("barney1");
record.setFrom("from field");
record.setId1(1111);
record.setId2(2222);
record.setId5(5555);
record.setId6(6666);
record.setId7(7777);
record.setSecondFirstName("barney2");
record.setThirdFirstName("barney3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("betty@betty.com");
record.setEmailaddress("alsoBetty@betty.com");
record.setFirstFirstName("betty1");
record.setFrom("from field");
record.setId1(11111);
record.setId2(22222);
record.setId5(55555);
record.setId6(66666);
record.setId7(77777);
record.setSecondFirstName("betty2");
record.setThirdFirstName("betty3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("bammbamm@bammbamm.com");
record.setEmailaddress("alsoBammbamm@bammbamm.com");
record.setFirstFirstName("bammbamm1");
record.setFrom("from field");
record.setId1(111111);
record.setId2(222222);
record.setId5(555555);
record.setId6(666666);
record.setId7(777777);
record.setSecondFirstName("bammbamm2");
record.setThirdFirstName("bammbamm3");
mapper.insert(record);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andId1Between(1, 1000);
List<AwfulTable> answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableSelectByExampleNoCriteria() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("wilma@wilma.com");
record.setEmailaddress("alsoWilma@wilma.com");
record.setFirstFirstName("wilma1");
record.setFrom("from field");
record.setId1(11);
record.setId2(22);
record.setId5(55);
record.setId6(66);
record.setId7(77);
record.setSecondFirstName("wilma2");
record.setThirdFirstName("wilma3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("pebbles@pebbles.com");
record.setEmailaddress("alsoPebbles@pebbles.com");
record.setFirstFirstName("pebbles1");
record.setFrom("from field");
record.setId1(111);
record.setId2(222);
record.setId5(555);
record.setId6(666);
record.setId7(777);
record.setSecondFirstName("pebbles2");
record.setThirdFirstName("pebbles3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("barney@barney.com");
record.setEmailaddress("alsoBarney@barney.com");
record.setFirstFirstName("barney1");
record.setFrom("from field");
record.setId1(1111);
record.setId2(2222);
record.setId5(5555);
record.setId6(6666);
record.setId7(7777);
record.setSecondFirstName("barney2");
record.setThirdFirstName("barney3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("betty@betty.com");
record.setEmailaddress("alsoBetty@betty.com");
record.setFirstFirstName("betty1");
record.setFrom("from field");
record.setId1(11111);
record.setId2(22222);
record.setId5(55555);
record.setId6(66666);
record.setId7(77777);
record.setSecondFirstName("betty2");
record.setThirdFirstName("betty3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("bammbamm@bammbamm.com");
record.setEmailaddress("alsoBammbamm@bammbamm.com");
record.setFirstFirstName("bammbamm1");
record.setFrom("from field");
record.setId1(111111);
record.setId2(222222);
record.setId5(555555);
record.setId6(666666);
record.setId7(777777);
record.setSecondFirstName("bammbamm2");
record.setThirdFirstName("bammbamm3");
mapper.insert(record);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria();
example.setOrderByClause("\"A_CuStOmEr iD\" desc");
List<AwfulTable> answer = mapper.selectByExample(example);
assertEquals(6, answer.size());
AwfulTable returnedRecord = answer.get(0);
assertEquals(111111, returnedRecord.getId1().intValue());
returnedRecord = answer.get(1);
assertEquals(11111, returnedRecord.getId1().intValue());
returnedRecord = answer.get(2);
assertEquals(1111, returnedRecord.getId1().intValue());
returnedRecord = answer.get(3);
assertEquals(111, returnedRecord.getId1().intValue());
returnedRecord = answer.get(4);
assertEquals(11, returnedRecord.getId1().intValue());
returnedRecord = answer.get(5);
assertEquals(1, returnedRecord.getId1().intValue());
} finally {
sqlSession.close();
}
}
@Test
public void testAwfulTableCountByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
record = new AwfulTable();
record.seteMail("fred2@fred.com");
record.setEmailaddress("alsofred2@fred.com");
record.setFirstFirstName("fred11");
record.setFrom("from from field");
record.setId1(11);
record.setId2(22);
record.setId5(55);
record.setId6(66);
record.setId7(77);
record.setSecondFirstName("fred22");
record.setThirdFirstName("fred33");
mapper.insert(record);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andEMailLike("fred@%");
int rows = mapper.countByExample(example);
assertEquals(1, rows);
example.clear();
rows = mapper.countByExample(example);
assertEquals(2, rows);
} finally {
sqlSession.close();
}
}
@Test
public void testEquals1() {
Pkfields pkfields1 = new Pkfields();
assertFalse(pkfields1.equals(null));
}
@Test
public void testEquals2() {
Pkfields pkfields1 = new Pkfields();
Pkfields pkfields2 = new Pkfields();
assertTrue(pkfields1.equals(pkfields2));
}
@Test
public void testEquals3() {
Pkfields pkfields1 = new Pkfields();
pkfields1.setId1(2);
Pkfields pkfields2 = new Pkfields();
pkfields2.setId1(2);
assertTrue(pkfields1.equals(pkfields2));
}
@Test
public void testEquals4() {
Pkfields pkfields1 = new Pkfields();
pkfields1.setId1(2);
Pkfields pkfields2 = new Pkfields();
pkfields2.setId1(3);
assertFalse(pkfields1.equals(pkfields2));
}
@Test
public void testEquals5() {
AwfulTable awfulTable1 = new AwfulTable();
awfulTable1.setActive(false);
awfulTable1.setCustomerId(3);
awfulTable1.seteMail("fred@fred.com");
awfulTable1.setEmailaddress("fred@fred.com");
awfulTable1.setFirstFirstName("Fred");
awfulTable1.setFrom("from");
awfulTable1.setId1(22);
awfulTable1.setId2(33);
awfulTable1.setId5(55);
awfulTable1.setId6(66);
awfulTable1.setId7(77);
awfulTable1.setLastName("Rubble");
awfulTable1.setSecondFirstName("Bamm Bamm");
awfulTable1.setThirdFirstName("Pebbles");
AwfulTable awfulTable2 = new AwfulTable();
awfulTable2.setActive(false);
awfulTable2.setCustomerId(3);
awfulTable2.seteMail("fred@fred.com");
awfulTable2.setEmailaddress("fred@fred.com");
awfulTable2.setFirstFirstName("Fred");
awfulTable2.setFrom("from");
awfulTable2.setId1(22);
awfulTable2.setId2(33);
awfulTable2.setId5(55);
awfulTable2.setId6(66);
awfulTable2.setId7(77);
awfulTable2.setLastName("Rubble");
awfulTable2.setSecondFirstName("Bamm Bamm");
awfulTable2.setThirdFirstName("Pebbles");
assertTrue(awfulTable1.equals(awfulTable2));
awfulTable2.setActive(true);
assertFalse(awfulTable1.equals(awfulTable2));
}
@Test
public void testHashCode1() {
Pkfields pkfields1 = new Pkfields();
Pkfields pkfields2 = new Pkfields();
assertTrue(pkfields1.hashCode() == pkfields2.hashCode());
}
@Test
public void testHashCode2() {
Pkfields pkfields1 = new Pkfields();
pkfields1.setId1(2);
Pkfields pkfields2 = new Pkfields();
pkfields2.setId1(2);
assertTrue(pkfields1.hashCode() == pkfields2.hashCode());
}
@Test
public void testHashCode3() {
AwfulTable awfulTable1 = new AwfulTable();
awfulTable1.setActive(false);
awfulTable1.setCustomerId(3);
awfulTable1.seteMail("fred@fred.com");
awfulTable1.setEmailaddress("fred@fred.com");
awfulTable1.setFirstFirstName("Fred");
awfulTable1.setFrom("from");
awfulTable1.setId1(22);
awfulTable1.setId2(33);
awfulTable1.setId5(55);
awfulTable1.setId6(66);
awfulTable1.setId7(77);
awfulTable1.setLastName("Rubble");
awfulTable1.setSecondFirstName("Bamm Bamm");
awfulTable1.setThirdFirstName("Pebbles");
AwfulTable awfulTable2 = new AwfulTable();
awfulTable2.setActive(false);
awfulTable2.setCustomerId(3);
awfulTable2.seteMail("fred@fred.com");
awfulTable2.setEmailaddress("fred@fred.com");
awfulTable2.setFirstFirstName("Fred");
awfulTable2.setFrom("from");
awfulTable2.setId1(22);
awfulTable2.setId2(33);
awfulTable2.setId5(55);
awfulTable2.setId6(66);
awfulTable2.setId7(77);
awfulTable2.setLastName("Rubble");
awfulTable2.setSecondFirstName("Bamm Bamm");
awfulTable2.setThirdFirstName("Pebbles");
assertTrue(awfulTable1.hashCode() == awfulTable2.hashCode());
}
}