@Test
public void testUpdatablesUK() throws Exception {
jOOQAbstractTest.reset = false;
S store = create().newRecord(TBookStore());
try {
store.refresh();
}
catch (InvalidResultException expected) {}
store.setValue(TBookStore_NAME(), "Rösslitor");
assertEquals(1, store.store());
store = create().fetchOne(TBookStore(), TBookStore_NAME().equal("Rösslitor"));
assertEquals("Rösslitor", store.getValue(TBookStore_NAME()));
// Updating the main unique key should result in a new record
store.setValue(TBookStore_NAME(), "Amazon");
assertEquals(1, store.store());
store = create().fetchOne(TBookStore(), TBookStore_NAME().equal("Amazon"));
assertEquals("Amazon", store.getValue(TBookStore_NAME()));
// Delete and re-create the store
store.delete();
assertEquals("Amazon", store.getValue(TBookStore_NAME()));
assertEquals(null, create().fetchOne(TBookStore(), TBookStore_NAME().equal("Amazon")));
switch (getDialect()) {
// Sybase ASE and SQL server do not allow for explicitly setting
// values on IDENTITY columns
case ASE:
case SQLSERVER:
log.info("SKIPPING", "Storing previously deleted UpdatableRecords");
break;
default:
store.store();
assertEquals("Amazon", store.getValue(TBookStore_NAME()));
store.refresh();
assertEquals("Amazon", store.getValue(TBookStore_NAME()));
}
store = create().fetchOne(TBookStore(), TBookStore_NAME().equal("Rösslitor"));
assertEquals("Rösslitor", store.getValue(TBookStore_NAME()));
}
