use of mbg.test.mb3.generated.dsql.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.
the class MiscellaneousTest method testMyObjectDeleteByExample.
@Test
public void testMyObjectDeleteByExample() {
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);
record = new MyObject();
fn = new FirstName();
fn.setValue("Bob");
record.setFirstname(fn);
record.setLastname("Jones");
record.setId1(3);
record.setId2(4);
mapper.insert(record);
List<MyObject> answer = mapper.select(SelectDSLCompleter.allRows());
assertEquals(2, answer.size());
int rows = mapper.delete(dsl -> dsl.where(myObject.lastname, isLike("J%")));
assertEquals(1, rows);
answer = mapper.select(SelectDSLCompleter.allRows());
assertEquals(1, answer.size());
}
}
use of mbg.test.mb3.generated.dsql.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.
the class MiscellaneousTest method testMyObjectSelectByExampleBetween.
@Test
public void testMyObjectSelectByExampleBetween() {
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);
List<MyObject> answer = mapper.select(dsl -> dsl.where(myObject.id2, isBetween(1).and(3)).orderBy(myObject.id1, myObject.id2));
assertEquals(6, answer.size());
}
}
use of mbg.test.mb3.generated.dsql.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.
the class MiscellaneousTest method testMyObjectUpdateByPrimaryKey.
@Test
public void testMyObjectUpdateByPrimaryKey() {
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);
fn = new FirstName();
fn.setValue("Scott");
record.setFirstname(fn);
record.setLastname("Jones");
int rows = mapper.updateByPrimaryKey(record);
assertEquals(1, rows);
Optional<MyObject> record2 = mapper.selectByPrimaryKey(2, 1);
assertThat(record2).hasValueSatisfying(r2 -> {
assertEquals(record.getFirstname(), r2.getFirstname());
assertEquals(record.getLastname(), r2.getLastname());
assertEquals(record.getId1(), r2.getId1());
assertEquals(record.getId2(), r2.getId2());
});
}
}
use of mbg.test.mb3.generated.dsql.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.
the class MiscellaneousTest method testMyObjectSelectByExampleNotLike.
@Test
public void testMyObjectSelectByExampleNotLike() {
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%");
List<MyObject> answer = mapper.select(dsl -> dsl.where(myObject.firstname, isNotLike(fn1)).orderBy(myObject.id1, myObject.id2));
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());
}
}
use of mbg.test.mb3.generated.dsql.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.
the class MiscellaneousTest method testMyObjectSelectByExampleLikeInsensitive.
@Test
public void testMyObjectSelectByExampleLikeInsensitive() {
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);
List<MyObject> answer = mapper.select(dsl -> dsl.where(myObject.lastname, isLike("RU%")).orderBy(myObject.id1, myObject.id2));
assertEquals(0, answer.size());
answer = mapper.select(dsl -> dsl.where(myObject.lastname, isLikeCaseInsensitive("RU%")));
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());
}
}
Aggregations