@Test
public void testUpdateByRecord() {
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());
record.setString("Single_line_text", "hoge");
db.updateByRecord(app, record);
rs = db.select(app, "Single_line_text = \"hoge\"");
if (rs.size() != 1) {
fail("failed to update");
}
rs.next();
if (rs.getId() != id) {
fail("invalid id");
}
} catch (Exception e) {
fail("db exception:" + e.getMessage());
}
}
@Test
public void testDeleteByRecords2() {
Connection db = getConnection();
long app = getAppId();
Record record;
List<Record> records = new ArrayList<Record>();
ResultSet rs = null;
try {
List<Long> ids = insertRecords();
rs = db.select(app, "");
if (rs.size() != 3) {
fail("invalid count");
}
record = new Record();
rs.next();
record.setId(rs.getId());
record.setString("Single_line_text", "hoge");
db.updateByRecord(app, record);
} catch (Exception e) {
fail("db exception:" + e.getMessage());
}
try {
rs.first();
while (rs.next()) {
record = new Record();
record.setId(rs.getId());
record.setRevision(rs.getRevision());
record.setString("Single_line_text", "hoge");
records.add(record);
}
db.deleteByRecords(app, records);
fail("no conflict");
} catch (Exception e) {
}
}