use of mbg.test.mb3.generated.annotated.hierarchical.Immutable.Mapper.PkonlyMapper in project generator by mybatis.
the class HierarchicalJava5Test method testPKOnlyInsert.
@Test
public void testPKOnlyInsert() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
PkonlyKey key = new PkonlyKey(1, 3);
mapper.insert(key);
PkonlyExample example = new PkonlyExample();
List<PkonlyKey> answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
PkonlyKey returnedRecord = answer.get(0);
assertEquals(key.getId(), returnedRecord.getId());
assertEquals(key.getSeqNum(), returnedRecord.getSeqNum());
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.annotated.hierarchical.Immutable.Mapper.PkonlyMapper in project generator by mybatis.
the class HierarchicalJava5Test method testPKOnlyCountByExample.
@Test
public void testPKOnlyCountByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
PkonlyKey key = new PkonlyKey(1, 3);
mapper.insert(key);
key = new PkonlyKey(5, 6);
mapper.insert(key);
key = new PkonlyKey(7, 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.annotated.hierarchical.Immutable.Mapper.PkonlyMapper in project generator by mybatis.
the class HierarchicalJava5Test method testPKOnlySelectByExampleNoCriteria.
@Test
public void testPKOnlySelectByExampleNoCriteria() {
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();
List<PkonlyKey> answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.annotated.hierarchical.Immutable.Mapper.PkonlyMapper in project generator by mybatis.
the class SimpleAnnotatedTest method testPkonly.
@Test
public void testPkonly() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
Pkonly record = new Pkonly();
record.setId(1);
record.setSeqNum(1);
mapper.insert(record);
record = new Pkonly();
record.setId(1);
record.setSeqNum(2);
mapper.insert(record);
record = new Pkonly();
record.setId(2);
record.setSeqNum(1);
mapper.insert(record);
record = new Pkonly();
record.setId(2);
record.setSeqNum(2);
mapper.insert(record);
List<Pkonly> records = mapper.selectAll();
assertEquals(4, records.size());
mapper.deleteByPrimaryKey(record.getId(), record.getSeqNum());
records = mapper.selectAll();
assertEquals(3, records.size());
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.annotated.hierarchical.Immutable.Mapper.PkonlyMapper in project generator by mybatis.
the class UpdateByExampleTest method testPKOnlyUpdateByExampleSelective.
@Test
public void testPKOnlyUpdateByExampleSelective() {
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);
key = new PkonlyKey();
key.setSeqNum(3);
int rows = mapper.updateByExampleSelective(key, example);
assertEquals(2, rows);
example.clear();
example.createCriteria().andIdEqualTo(5).andSeqNumEqualTo(3);
long returnedRows = mapper.countByExample(example);
assertEquals(1, returnedRows);
example.clear();
example.createCriteria().andIdEqualTo(7).andSeqNumEqualTo(3);
returnedRows = mapper.countByExample(example);
assertEquals(1, returnedRows);
} finally {
sqlSession.close();
}
}
Aggregations