use of mbg.test.mb3.generated.annotated.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.
the class MiscellaneousTest method testMyObjectSelectByExampleTimeEquals.
@Test
public void testMyObjectSelectByExampleTimeEquals() {
try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
MyObjectMapper mapper = sqlSession.getMapper(MyObjectMapper.class);
MyObject record = new MyObject();
record.setStartDate(new Date());
record.setDecimal100field(10L);
record.setDecimal155field(15.12345);
record.setDecimal60field(6);
FirstName fn = new FirstName();
fn.setValue("Jeff");
record.setFirstname(fn);
record.setId1(1);
record.setId2(2);
record.setLastname("Butler");
MyTime myTime = new MyTime();
myTime.setHours(12);
myTime.setMinutes(34);
myTime.setSeconds(5);
record.setTimefield(myTime);
record.setTimestampfield(new Date());
mapper.insert(record);
List<MyObject> results = mapper.select(dsl -> dsl.where(myObject.timefield, isEqualTo(myTime)));
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());
}
}
use of mbg.test.mb3.generated.annotated.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.
the class MiscellaneousTest method testMyObjectDeleteByPrimaryKey.
@Test
public void testMyObjectDeleteByPrimaryKey() {
try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
MyObjectMapper mapper = sqlSession.getMapper(MyObjectMapper.class);
MyObject record = new MyObject();
FirstName fn = new FirstName();
fn.setValue("Jeff");
record.setFirstname(fn);
record.setLastname("Smith");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
int rows = mapper.deleteByPrimaryKey(2, 1);
assertEquals(1, rows);
List<MyObject> answer = mapper.select(SelectDSLCompleter.allRows());
assertEquals(0, answer.size());
}
}
use of mbg.test.mb3.generated.annotated.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.
the class MiscellaneousTest method testMyObjectSelectByExampleComplexLike.
@Test
public void testMyObjectSelectByExampleComplexLike() {
try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
MyObjectMapper mapper = sqlSession.getMapper(MyObjectMapper.class);
MyObject record = new MyObject();
FirstName fn = new FirstName();
fn.setValue("Fred");
record.setFirstname(fn);
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(1);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Wilma");
record.setFirstname(fn);
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Pebbles");
record.setFirstname(fn);
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(3);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Barney");
record.setFirstname(fn);
record.setLastname("Rubble");
record.setId1(2);
record.setId2(1);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Betty");
record.setFirstname(fn);
record.setLastname("Rubble");
record.setId1(2);
record.setId2(2);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Bamm Bamm");
record.setFirstname(fn);
record.setLastname("Rubble");
record.setId1(2);
record.setId2(3);
mapper.insert(record);
FirstName fn1 = new FirstName();
fn1.setValue("B%");
FirstName fn2 = new FirstName();
fn2.setValue("W%");
List<MyObject> answer = mapper.select(dsl -> dsl.where(myObject.firstname, isLike(fn1), and(myObject.id2, isEqualTo(3))).or(myObject.firstname, isLike(fn2)).orderBy(myObject.id1, myObject.id2));
assertEquals(2, answer.size());
MyObject 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());
}
}
use of mbg.test.mb3.generated.annotated.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.
the class MiscellaneousTest method testMyObjectSelectByExampleNotLike.
@Test
public void testMyObjectSelectByExampleNotLike() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
MyObjectMapper mapper = sqlSession.getMapper(MyObjectMapper.class);
MyObject record = new MyObject();
FirstName fn = new FirstName();
fn.setValue("Fred");
record.setFirstname(fn);
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(1);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Wilma");
record.setFirstname(fn);
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Pebbles");
record.setFirstname(fn);
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(3);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Barney");
record.setFirstname(fn);
record.setLastname("Rubble");
record.setId1(2);
record.setId2(1);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Betty");
record.setFirstname(fn);
record.setLastname("Rubble");
record.setId1(2);
record.setId2(2);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Bamm Bamm");
record.setFirstname(fn);
record.setLastname("Rubble");
record.setId1(2);
record.setId2(3);
mapper.insert(record);
MyObjectCriteria example = new MyObjectCriteria();
fn = new FirstName();
fn.setValue("B%");
example.createCriteria().andFirstnameNotLike(fn);
example.setOrderByClause("ID1, ID2");
List<MyObject> answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
MyObject 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();
}
}
use of mbg.test.mb3.generated.annotated.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.
the class MiscellaneousTest method testMyObjectSelectByExampleLikeInsensitive.
@Test
public void testMyObjectSelectByExampleLikeInsensitive() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
MyObjectMapper mapper = sqlSession.getMapper(MyObjectMapper.class);
MyObject record = new MyObject();
FirstName fn = new FirstName();
fn.setValue("Fred");
record.setFirstname(fn);
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(1);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Wilma");
record.setFirstname(fn);
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(2);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Pebbles");
record.setFirstname(fn);
record.setLastname("Flintstone");
record.setId1(1);
record.setId2(3);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Barney");
record.setFirstname(fn);
record.setLastname("Rubble");
record.setId1(2);
record.setId2(1);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Betty");
record.setFirstname(fn);
record.setLastname("Rubble");
record.setId1(2);
record.setId2(2);
mapper.insert(record);
record = new MyObject();
fn = new FirstName();
fn.setValue("Bamm Bamm");
record.setFirstname(fn);
record.setLastname("Rubble");
record.setId1(2);
record.setId2(3);
mapper.insert(record);
MyObjectCriteria example = new MyObjectCriteria();
example.createCriteria().andLastnameLike("RU%");
example.setOrderByClause("ID1, ID2");
List<MyObject> answer = mapper.selectByExample(example);
assertEquals(0, answer.size());
example.clear();
example.createCriteria().andLastnameLikeInsensitive("RU%");
answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
MyObject 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();
}
}
Aggregations