@Test
public void testInsertCreatorModifier() {
Connection db = getConnection();
long app = getAppId();
try {
Record record;
DateFormat df = new SimpleDateFormat("yyyy-MM-dd hh:mm");
Date date = df.parse("2000-01-01 01:34");
record = new Record();
record.setUser("Created_by", "aono");
record.setUser("Updated_by", "aono");
record.setDateTime("Created_datetime", date);
record.setDateTime("Updated_datetime", date);
db.insert(app, record);
ResultSet rs = db.select(app, "");
if (rs.size() != 1) {
fail("invalid count");
}
rs.first();
if (!rs.getUser("Created_by").getCode().equals("aono")) {
fail("failed to update created by");
}
if (!rs.getUser("Updated_by").getCode().equals("aono")) {
fail("failed to update updated by");
}
if (!rs.getDateTime("Created_datetime").equals(date)) {
fail("failed to update created datetime" + rs.getDate("Created_datetime").toString());
}
if (!rs.getDateTime("Updated_datetime").equals(date)) {
fail("failed to update updated datetime" + rs.getDate("Updated_datetime").toString());
}
} catch (Exception e) {
fail("db exception:" + e.getMessage());
}
}
