use of mbg.test.mb3.generated.hierarchical.model.PkonlyKey in project generator by mybatis.
the class HierarchicalJava2Test method testPKOnlyDeleteByPrimaryKey.
public void testPKOnlyDeleteByPrimaryKey() {
PkonlyDAO dao = getPkonlyDAO();
try {
PkonlyKey key = new PkonlyKey();
key.setId(new Integer(1));
key.setSeqNum(new Integer(3));
dao.insert(key);
key = new PkonlyKey();
key.setId(new Integer(5));
key.setSeqNum(new Integer(6));
dao.insert(key);
PkonlyExample example = new PkonlyExample();
List answer = dao.selectByExample(example);
assertEquals(2, answer.size());
key = new PkonlyKey();
key.setId(new Integer(5));
key.setSeqNum(new Integer(6));
int rows = dao.deleteByPrimaryKey(key);
assertEquals(1, rows);
answer = dao.selectByExample(example);
assertEquals(1, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
}
}
use of mbg.test.mb3.generated.hierarchical.model.PkonlyKey in project generator by mybatis.
the class HierarchicalJava2Test method testPKOnlyInsert.
public void testPKOnlyInsert() {
PkonlyDAO dao = getPkonlyDAO();
try {
PkonlyKey key = new PkonlyKey();
key.setId(new Integer(1));
key.setSeqNum(new Integer(3));
dao.insert(key);
PkonlyExample example = new PkonlyExample();
List answer = dao.selectByExample(example);
assertEquals(1, answer.size());
PkonlyKey returnedRecord = (PkonlyKey) answer.get(0);
assertEquals(key.getId(), returnedRecord.getId());
assertEquals(key.getSeqNum(), returnedRecord.getSeqNum());
} catch (SQLException e) {
fail(e.getMessage());
}
}
use of mbg.test.mb3.generated.hierarchical.model.PkonlyKey in project generator by mybatis.
the class HierarchicalJava2Test method testPKOnlyDeleteByExample.
public void testPKOnlyDeleteByExample() {
PkonlyDAO dao = getPkonlyDAO();
try {
PkonlyKey key = new PkonlyKey();
key.setId(new Integer(1));
key.setSeqNum(new Integer(3));
dao.insert(key);
key = new PkonlyKey();
key.setId(new Integer(5));
key.setSeqNum(new Integer(6));
dao.insert(key);
key = new PkonlyKey();
key.setId(new Integer(7));
key.setSeqNum(new Integer(8));
dao.insert(key);
PkonlyExample example = new PkonlyExample();
example.createCriteria().andIdGreaterThan(new Integer(4));
int rows = dao.deleteByExample(example);
assertEquals(2, rows);
example = new PkonlyExample();
List answer = dao.selectByExample(example);
assertEquals(1, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
}
}
use of mbg.test.mb3.generated.hierarchical.model.PkonlyKey in project generator by mybatis.
the class HierarchicalJava2Test method testPKOnlySelectByExampleNoCriteria.
public void testPKOnlySelectByExampleNoCriteria() {
PkonlyDAO dao = getPkonlyDAO();
try {
PkonlyKey key = new PkonlyKey();
key.setId(new Integer(1));
key.setSeqNum(new Integer(3));
dao.insert(key);
key = new PkonlyKey();
key.setId(new Integer(5));
key.setSeqNum(new Integer(6));
dao.insert(key);
key = new PkonlyKey();
key.setId(new Integer(7));
key.setSeqNum(new Integer(8));
dao.insert(key);
PkonlyExample example = new PkonlyExample();
example.createCriteria();
List answer = dao.selectByExample(example);
assertEquals(3, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
}
}
use of mbg.test.mb3.generated.hierarchical.model.PkonlyKey in project generator by mybatis.
the class HierarchicalJava2Test method testPKOnlySelectByExample.
public void testPKOnlySelectByExample() {
PkonlyDAO dao = getPkonlyDAO();
try {
PkonlyKey key = new PkonlyKey();
key.setId(new Integer(1));
key.setSeqNum(new Integer(3));
dao.insert(key);
key = new PkonlyKey();
key.setId(new Integer(5));
key.setSeqNum(new Integer(6));
dao.insert(key);
key = new PkonlyKey();
key.setId(new Integer(7));
key.setSeqNum(new Integer(8));
dao.insert(key);
PkonlyExample example = new PkonlyExample();
example.createCriteria().andIdGreaterThan(new Integer(4));
List answer = dao.selectByExample(example);
assertEquals(2, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
}
}
Aggregations