use of mbg.test.mb3.generated.mixed.flat.mapper.PkonlyMapper in project generator by mybatis.
the class FlatJava5Test method testPKOnlyDeleteByExample.
@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();
}
}
use of mbg.test.mb3.generated.mixed.flat.mapper.PkonlyMapper in project generator by mybatis.
the class FlatJava5Test method testPKOnlySelectByExample.
@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();
}
}
use of mbg.test.mb3.generated.mixed.flat.mapper.PkonlyMapper in project generator by mybatis.
the class DynamicSqlTest method testPKOnlycount.
@Test
public void testPKOnlycount() {
try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
Pkonly key = new Pkonly(1, 3);
mapper.insert(key);
key = new Pkonly(5, 6);
mapper.insert(key);
key = new Pkonly(7, 8);
mapper.insert(key);
long rows = mapper.count(dsl -> dsl.where(pkonly.id, isGreaterThan(4)));
assertEquals(2, rows);
rows = mapper.count(dsl -> dsl);
assertEquals(3, rows);
}
}
use of mbg.test.mb3.generated.mixed.flat.mapper.PkonlyMapper in project generator by mybatis.
the class ConditionalJava5Test method testPKOnlyCountByExample.
@Test
public void testPKOnlyCountByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
PkonlyKey key = new PkonlyKey();
key.setId(1);
key.setSeqNum(3);
mapper.insert(key);
key = new PkonlyKey();
key.setId(5);
key.setSeqNum(6);
mapper.insert(key);
key = new PkonlyKey();
key.setId(7);
key.setSeqNum(8);
mapper.insert(key);
PkonlyExample example = new PkonlyExample();
example.createCriteria().andIdGreaterThan(4);
long rows = mapper.countByExample(example);
assertEquals(2, rows);
example.clear();
rows = mapper.countByExample(example);
assertEquals(3, rows);
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.mixed.flat.mapper.PkonlyMapper in project generator by mybatis.
the class ConditionalJava5Test method testPKOnlySelectByExample.
@Test
public void testPKOnlySelectByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
PkonlyKey key = new PkonlyKey();
key.setId(1);
key.setSeqNum(3);
mapper.insert(key);
key = new PkonlyKey();
key.setId(5);
key.setSeqNum(6);
mapper.insert(key);
key = new PkonlyKey();
key.setId(7);
key.setSeqNum(8);
mapper.insert(key);
PkonlyExample example = new PkonlyExample();
example.createCriteria().andIdGreaterThan(4);
List<PkonlyKey> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
} finally {
sqlSession.close();
}
}
Aggregations