use of mbg.test.ib2j2.generated.hierarchical.model.AwfulTableKey in project generator by mybatis.
the class HierarchicalJava5Test method testAwfulTableUpdateByPrimaryKeySelective.
@Test
public void testAwfulTableUpdateByPrimaryKeySelective() {
AwfulTableDAO dao = getAwfulTableDAO();
try {
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
Integer generatedCustomerId = dao.insert(record);
AwfulTable newRecord = new AwfulTable();
newRecord.setCustomerId(generatedCustomerId);
newRecord.setId1(11);
newRecord.setId2(22);
int rows = dao.updateByPrimaryKeySelective(newRecord);
assertEquals(1, rows);
AwfulTableKey key = new AwfulTableKey();
key.setCustomerId(generatedCustomerId);
AwfulTable returnedRecord = dao.selectByPrimaryKey(key);
assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
assertEquals(record.geteMail(), returnedRecord.geteMail());
assertEquals(record.getEmailaddress(), returnedRecord.getEmailaddress());
assertEquals(record.getFirstFirstName(), returnedRecord.getFirstFirstName());
assertEquals(record.getFrom(), returnedRecord.getFrom());
assertEquals(newRecord.getId1(), returnedRecord.getId1());
assertEquals(newRecord.getId2(), returnedRecord.getId2());
assertEquals(record.getId5(), returnedRecord.getId5());
assertEquals(record.getId6(), returnedRecord.getId6());
assertEquals(record.getId7(), returnedRecord.getId7());
assertEquals(record.getSecondFirstName(), returnedRecord.getSecondFirstName());
assertEquals(record.getThirdFirstName(), returnedRecord.getThirdFirstName());
} catch (Exception e) {
fail(e.getMessage());
}
}
use of mbg.test.ib2j2.generated.hierarchical.model.AwfulTableKey in project generator by mybatis.
the class HierarchicalJava5Test method testAwfulTableInsertSelective.
@Test
public void testAwfulTableInsertSelective() {
AwfulTableDAO dao = getAwfulTableDAO();
try {
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
Integer generatedCustomerId = dao.insertSelective(record);
assertEquals(57, generatedCustomerId.intValue());
AwfulTableKey key = new AwfulTableKey();
key.setCustomerId(generatedCustomerId);
AwfulTable returnedRecord = dao.selectByPrimaryKey(key);
assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
assertEquals(record.geteMail(), returnedRecord.geteMail());
assertEquals(record.getEmailaddress(), returnedRecord.getEmailaddress());
assertEquals("Mabel", returnedRecord.getFirstFirstName());
assertEquals(record.getFrom(), returnedRecord.getFrom());
assertEquals(record.getId1(), returnedRecord.getId1());
assertEquals(record.getId2(), returnedRecord.getId2());
assertEquals(record.getId5(), returnedRecord.getId5());
assertEquals(record.getId6(), returnedRecord.getId6());
assertEquals(record.getId7(), returnedRecord.getId7());
assertEquals(record.getSecondFirstName(), returnedRecord.getSecondFirstName());
assertEquals(record.getThirdFirstName(), returnedRecord.getThirdFirstName());
} catch (Exception e) {
fail(e.getMessage());
}
}
use of mbg.test.ib2j2.generated.hierarchical.model.AwfulTableKey in project generator by mybatis.
the class HierarchicalJava5Test method testAwfulTableUpdateByPrimaryKey.
@Test
public void testAwfulTableUpdateByPrimaryKey() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
mapper.insert(record);
Integer generatedCustomerId = record.getCustomerId();
record.setId1(11);
record.setId2(22);
int rows = mapper.updateByPrimaryKey(record);
assertEquals(1, rows);
AwfulTableKey key = new AwfulTableKey();
key.setCustomerId(generatedCustomerId);
AwfulTable returnedRecord = mapper.selectByPrimaryKey(key);
assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
assertEquals(record.geteMail(), returnedRecord.geteMail());
assertEquals(record.getEmailaddress(), returnedRecord.getEmailaddress());
assertEquals(record.getFirstFirstName(), returnedRecord.getFirstFirstName());
assertEquals(record.getFrom(), returnedRecord.getFrom());
assertEquals(record.getId1(), returnedRecord.getId1());
assertEquals(record.getId2(), returnedRecord.getId2());
assertEquals(record.getId5(), returnedRecord.getId5());
assertEquals(record.getId6(), returnedRecord.getId6());
assertEquals(record.getId7(), returnedRecord.getId7());
assertEquals(record.getSecondFirstName(), returnedRecord.getSecondFirstName());
assertEquals(record.getThirdFirstName(), returnedRecord.getThirdFirstName());
} finally {
sqlSession.close();
}
}
use of mbg.test.ib2j2.generated.hierarchical.model.AwfulTableKey in project generator by mybatis.
the class HierarchicalJava2Test method testAwfulTableSelectByPrimaryKey.
public void testAwfulTableSelectByPrimaryKey() {
AwfulTableDAO dao = getAwfulTableDAO();
try {
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(new Integer(1));
record.setId2(new Integer(2));
record.setId5(new Integer(5));
record.setId6(new Integer(6));
record.setId7(new Integer(7));
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("fred2@fred.com");
record.setEmailaddress("alsofred2@fred.com");
record.setFirstFirstName("fred11");
record.setFrom("from from field");
record.setId1(new Integer(11));
record.setId2(new Integer(22));
record.setId5(new Integer(55));
record.setId6(new Integer(66));
record.setId7(new Integer(77));
record.setSecondFirstName("fred22");
record.setThirdFirstName("fred33");
Integer generatedKey = dao.insert(record);
AwfulTableKey key = new AwfulTableKey();
key.setCustomerId(generatedKey);
AwfulTable returnedRecord = dao.selectByPrimaryKey(key);
assertNotNull(returnedRecord);
assertEquals(record.getCustomerId(), returnedRecord.getCustomerId());
assertEquals(record.geteMail(), returnedRecord.geteMail());
assertEquals(record.getEmailaddress(), returnedRecord.getEmailaddress());
assertEquals(record.getFirstFirstName(), returnedRecord.getFirstFirstName());
assertEquals(record.getFrom(), returnedRecord.getFrom());
assertEquals(record.getId1(), returnedRecord.getId1());
assertEquals(record.getId2(), returnedRecord.getId2());
assertEquals(record.getId5(), returnedRecord.getId5());
assertEquals(record.getId6(), returnedRecord.getId6());
assertEquals(record.getId7(), returnedRecord.getId7());
assertEquals(record.getSecondFirstName(), returnedRecord.getSecondFirstName());
assertEquals(record.getThirdFirstName(), returnedRecord.getThirdFirstName());
} catch (SQLException e) {
fail(e.getMessage());
}
}
use of mbg.test.ib2j2.generated.hierarchical.model.AwfulTableKey in project generator by mybatis.
the class HierarchicalJava2Test method testAwfulTableUpdateByPrimaryKey.
public void testAwfulTableUpdateByPrimaryKey() {
AwfulTableDAO dao = getAwfulTableDAO();
try {
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(new Integer(1));
record.setId2(new Integer(2));
record.setId5(new Integer(5));
record.setId6(new Integer(6));
record.setId7(new Integer(7));
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
Integer generatedCustomerId = dao.insert(record);
record.setId1(new Integer(11));
record.setId2(new Integer(22));
int rows = dao.updateByPrimaryKey(record);
assertEquals(1, rows);
AwfulTableKey key = new AwfulTableKey();
key.setCustomerId(generatedCustomerId);
AwfulTable returnedRecord = dao.selectByPrimaryKey(key);
assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
assertEquals(record.geteMail(), returnedRecord.geteMail());
assertEquals(record.getEmailaddress(), returnedRecord.getEmailaddress());
assertEquals(record.getFirstFirstName(), returnedRecord.getFirstFirstName());
assertEquals(record.getFrom(), returnedRecord.getFrom());
assertEquals(record.getId1(), returnedRecord.getId1());
assertEquals(record.getId2(), returnedRecord.getId2());
assertEquals(record.getId5(), returnedRecord.getId5());
assertEquals(record.getId6(), returnedRecord.getId6());
assertEquals(record.getId7(), returnedRecord.getId7());
assertEquals(record.getSecondFirstName(), returnedRecord.getSecondFirstName());
assertEquals(record.getThirdFirstName(), returnedRecord.getThirdFirstName());
} catch (SQLException e) {
fail(e.getMessage());
}
}
Aggregations