@Test
public void testDeleteByRecord() {
Connection db = getConnection();
long app = getAppId();
try {
Record record = new Record();
List<Long> ids = insertRecords();
long id = ids.get(1);
ResultSet rs = db.select(app, "Record_number = " + id);
if (rs.size() != 1) {
fail("invalid count");
}
rs.next();
record.setId(rs.getId());
record.setRevision(rs.getRevision());
db.deleteByRecord(app, record);
rs = db.select(app, "");
if (rs.size() != 2) {
fail("failed to delete");
}
} catch (Exception e) {
fail("db exception:" + e.getMessage());
}
}
