use of mbg.test.ib2j5.generated.conditional.dao.PkonlyDAO in project generator by mybatis.
the class ConditionalJava5Test method testPKOnlySelectByExample.
@Test
public void testPKOnlySelectByExample() {
PkonlyDAO dao = getPkonlyDAO();
try {
PkonlyKey key = new PkonlyKey();
key.setId(1);
key.setSeqNum(3);
dao.insert(key);
key = new PkonlyKey();
key.setId(5);
key.setSeqNum(6);
dao.insert(key);
key = new PkonlyKey();
key.setId(7);
key.setSeqNum(8);
dao.insert(key);
PkonlyExample example = new PkonlyExample();
example.createCriteria().andIdGreaterThan(4);
List<PkonlyKey> answer = dao.selectByExample(example);
assertEquals(2, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
}
}
use of mbg.test.ib2j5.generated.conditional.dao.PkonlyDAO in project generator by mybatis.
the class ConditionalJava5Test method testPKOnlyInsert.
@Test
public void testPKOnlyInsert() {
PkonlyDAO dao = getPkonlyDAO();
try {
PkonlyKey key = new PkonlyKey();
key.setId(1);
key.setSeqNum(3);
dao.insert(key);
PkonlyExample example = new PkonlyExample();
List<PkonlyKey> answer = dao.selectByExample(example);
assertEquals(1, answer.size());
PkonlyKey returnedRecord = answer.get(0);
assertEquals(key.getId(), returnedRecord.getId());
assertEquals(key.getSeqNum(), returnedRecord.getSeqNum());
} catch (SQLException e) {
fail(e.getMessage());
}
}
use of mbg.test.ib2j5.generated.conditional.dao.PkonlyDAO in project generator by mybatis.
the class AbstractConditionalJava5Test method getPkonlyDAO.
protected PkonlyDAO getPkonlyDAO() {
PkonlyDAOImpl dao = new PkonlyDAOImpl();
dao.setSqlMapClient(getSqlMapClient());
return dao;
}
use of mbg.test.ib2j5.generated.conditional.dao.PkonlyDAO in project generator by mybatis.
the class UpdateByExampleTest method testPKOnlyUpdateByExample.
@Test
public void testPKOnlyUpdateByExample() {
PkonlyDAO dao = getPkonlyDAO();
try {
PkonlyKey key = new PkonlyKey();
key.setId(1);
key.setSeqNum(3);
dao.insert(key);
key = new PkonlyKey();
key.setId(5);
key.setSeqNum(6);
dao.insert(key);
key = new PkonlyKey();
key.setId(7);
key.setSeqNum(8);
dao.insert(key);
PkonlyExample example = new PkonlyExample();
example.createCriteria().andIdEqualTo(7);
key = new PkonlyKey();
key.setSeqNum(3);
key.setId(22);
int rows = dao.updateByExample(key, example);
assertEquals(1, rows);
example.clear();
example.createCriteria().andIdEqualTo(22).andSeqNumEqualTo(3);
long returnedRows = dao.countByExample(example);
assertEquals(1, returnedRows);
} catch (SQLException e) {
fail(e.getMessage());
}
}
use of mbg.test.ib2j5.generated.conditional.dao.PkonlyDAO in project generator by mybatis.
the class ConditionalJava5Test method testPKOnlyCountByExample.
@Test
public void testPKOnlyCountByExample() {
PkonlyDAO dao = getPkonlyDAO();
try {
PkonlyKey key = new PkonlyKey();
key.setId(1);
key.setSeqNum(3);
dao.insert(key);
key = new PkonlyKey();
key.setId(5);
key.setSeqNum(6);
dao.insert(key);
key = new PkonlyKey();
key.setId(7);
key.setSeqNum(8);
dao.insert(key);
PkonlyExample example = new PkonlyExample();
example.createCriteria().andIdGreaterThan(4);
long rows = dao.countByExample(example);
assertEquals(2, rows);
example.clear();
rows = dao.countByExample(example);
assertEquals(3, rows);
} catch (SQLException e) {
fail(e.getMessage());
}
}
Aggregations