// Test that primary key constraints are actually removed
@Test
public void removingPrimaryKeyRemovesConstraint() {
SharedGroup db = new SharedGroup(testFile, SharedGroup.Durability.FULL, null);
WriteTransaction trans = db.beginWrite();
Table tbl = trans.getTable("EmployeeTable");
tbl.addColumn(RealmFieldType.STRING, "name");
tbl.addColumn(RealmFieldType.INTEGER, "number");
tbl.setPrimaryKey("name");
tbl.add("Foo", 42);
try {
tbl.add("Foo", 41);
} catch (RealmPrimaryKeyConstraintException e1) {
// Primary key check worked, now remove it and try again.
tbl.setPrimaryKey("");
try {
tbl.add("Foo", 41);
return;
} catch (RealmException e2) {
fail("Primary key not removed");
}
}
fail("Primary key not enforced.");
}
// See https://github.com/realm/realm-java/issues/1775 .
// Before 0.84.2, pk table added prefix "class_" to every class's name.
// After 0.84.2, the pk table should be migrated automatically to remove the "class_".
// In 0.84.2, the class names in pk table has been renamed to some incorrect names like "Thclass",
// "Mclass",
// "NClass", "Meclass" and etc..
// The 0841_pk_migration.realm is made to produce the issue.
@Test
public void primaryKeyTableMigratedWithRightName() throws IOException {
List<String> tableNames =
Arrays.asList(
"ChatList",
"Drafts",
"Member",
"Message",
"Notifs",
"NotifyLink",
"PopularPost",
"Post",
"Tags",
"Threads",
"User");
configFactory.copyRealmFromAssets(context, "0841_pk_migration.realm", "default.realm");
SharedGroup db =
new SharedGroup(
new File(configFactory.getRoot(), Realm.DEFAULT_REALM_NAME).getAbsolutePath(),
SharedGroup.Durability.FULL,
null);
ImplicitTransaction tr = db.beginImplicitTransaction();
// To trigger migratePrimaryKeyTableIfNeeded.
tr.getTable("class_ChatList").getPrimaryKey();
Table table = tr.getTable("pk");
for (int i = 0; i < table.size(); i++) {
UncheckedRow row = table.getUncheckedRow(i);
// io_realm_internal_Table_PRIMARY_KEY_CLASS_COLUMN_INDEX 0LL
assertTrue(tableNames.contains(row.getString(0)));
}
db.close();
}
// Test that primary key constraints are actually removed
@Test
public void removingPrimaryKeyRemovesConstraint_typeSetters() {
SharedGroup db = new SharedGroup(testFile, SharedGroup.Durability.FULL, null);
WriteTransaction trans = db.beginWrite();
Table tbl = trans.getTable("EmployeeTable");
tbl.addColumn(RealmFieldType.STRING, "name");
tbl.setPrimaryKey("name");
// Create first entry with name "foo"
tbl.setString(0, tbl.addEmptyRow(), "Foo");
long rowIndex = tbl.addEmptyRow();
try {
tbl.setString(0, rowIndex, "Foo"); // Try to create 2nd entry with name Foo
} catch (RealmPrimaryKeyConstraintException e1) {
tbl.setPrimaryKey(""); // Primary key check worked, now remove it and try again.
try {
tbl.setString(0, rowIndex, "Foo");
return;
} catch (RealmException e2) {
fail("Primary key not removed");
}
}
fail("Primary key not enforced.");
}
@Test
public void mustAllowDoubleCommitAndRollback() {
SharedGroup db = new SharedGroup(testFile, SharedGroup.Durability.FULL, null);
{
WriteTransaction trans = db.beginWrite();
Table tbl = trans.getTable("EmployeeTable");
tbl.addColumn(RealmFieldType.STRING, "name");
tbl.addColumn(RealmFieldType.INTEGER, "number");
// allow commit before any changes
assertEquals(0, tbl.size());
tbl.add("Hello", 1);
trans.commit();
}
{
WriteTransaction trans = db.beginWrite();
Table tbl = trans.getTable("EmployeeTable");
// allow double rollback
tbl.add("Hello", 2);
assertEquals(2, tbl.size());
trans.rollback();
trans.rollback();
trans.rollback();
trans.rollback();
}
{
ReadTransaction trans = db.beginRead();
Table tbl = trans.getTable("EmployeeTable");
assertEquals(1, tbl.size());
trans.endRead();
}
}
private Table getTableWithIntegerPrimaryKey() {
SharedGroup db = new SharedGroup(testFile, SharedGroup.Durability.FULL, null);
WriteTransaction trans = db.beginWrite();
Table t = trans.getTable("TestTable");
t.addColumn(RealmFieldType.INTEGER, "colName");
t.setPrimaryKey("colName");
return t;
}
@Test
public void mustRollback() {
SharedGroup db = new SharedGroup(testFile, SharedGroup.Durability.FULL, null);
writeOneTransaction(db, 1);
WriteTransaction trans = db.beginWrite();
Table tbl = trans.getTable("EmployeeTable");
tbl.add("Hello", 1);
assertEquals(2, tbl.size());
trans.rollback();
checkRead(db, 1); // Only 1 row now.
}
@Test
public void secondPrimaryKeyTableMigration() throws IOException {
configFactory.copyRealmFromAssets(context, "0841_annotationtypes.realm", "default.realm");
SharedGroup db =
new SharedGroup(
new File(configFactory.getRoot(), Realm.DEFAULT_REALM_NAME).getAbsolutePath(),
SharedGroup.Durability.FULL,
null);
ImplicitTransaction tr = db.beginImplicitTransaction();
Table t = tr.getTable("class_AnnotationTypes");
assertEquals(t.getColumnIndex("id"), t.getPrimaryKey());
assertTrue(t.hasPrimaryKey());
assertEquals("AnnotationTypes", tr.getTable("pk").getString(0, 0));
db.close();
}
protected void checkRead(SharedGroup db, int rows) {
// Read transaction
ReadTransaction trans = db.beginRead();
Table tbl = trans.getTable("EmployeeTable");
assertEquals(true, tbl.isValid());
assertEquals(rows, tbl.size());
trans.endRead();
}
@Test
public void shouldThrowExceptionWhenWritingInReadTrans() {
SharedGroup db = new SharedGroup(testFile, SharedGroup.Durability.FULL, null);
ReadTransaction rt = db.beginRead();
try {
try {
rt.getTable(
"newTable"); // Should throw exception, as this method creates a new table, if the table
// does not exists, thereby making it a mutable operation
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
} finally {
rt.endRead();
}
}
@Test
public void onlyOneCommit() {
SharedGroup db = new SharedGroup(testFile, SharedGroup.Durability.FULL, null);
WriteTransaction trans = db.beginWrite();
try {
Table tbl = trans.getTable("EmployeeTable");
tbl.addColumn(RealmFieldType.STRING, "name");
trans.commit();
try {
trans.commit(); // should throw
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
} catch (Throwable t) {
trans.rollback();
}
}
@Test
public void shouldThrowExceptionAfterClosedReadTransaction() {
SharedGroup db = new SharedGroup(testFile, SharedGroup.Durability.FULL, null);
writeOneTransaction(db, 10);
ReadTransaction rt = db.beginRead();
try {
Table tbl = rt.getTable("EmployeeTable");
rt.endRead();
try {
tbl
.getColumnCount(); // Should throw exception, the table is invalid when transaction has
// been closed
fail();
} catch (IllegalStateException ignored) {
}
} finally {
rt.endRead();
}
}
@Test
public void shouldThrowExceptionAfterClosedReadTransactionWhenWriting() {
SharedGroup db = new SharedGroup(testFile, SharedGroup.Durability.FULL, null);
writeOneTransaction(db, 10);
ReadTransaction rt = db.beginRead();
try {
Table tbl = rt.getTable("EmployeeTable");
rt.endRead();
try {
tbl.addColumn(
RealmFieldType.STRING,
"newString"); // Should throw exception, as adding a column is not allowed in read
// transaction
fail();
} catch (IllegalStateException e) {
// assertNotNull(e);
}
} finally {
rt.endRead();
}
}
protected void writeOneTransaction(SharedGroup db, long rows) {
WriteTransaction trans = db.beginWrite();
Table tbl = trans.getTable("EmployeeTable");
tbl.addColumn(RealmFieldType.STRING, "name");
tbl.addColumn(RealmFieldType.INTEGER, "number");
for (long row = 0; row < rows; row++) tbl.add("Hi", 1);
assertEquals(rows, tbl.size());
trans.commit();
// must throw exception as table is invalid now.
try {
assertEquals(1, tbl.size());
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
}
public void asyncDisposeSharedGroup(long nativePointer) {
SharedGroup.nativeClose(nativePointer);
}
@Test
public void mustFailOnWriteInReadTransactions() {
SharedGroup db = new SharedGroup(testFile, SharedGroup.Durability.FULL, null);
writeOneTransaction(db, 1);
ReadTransaction t = db.beginRead();
Table table = t.getTable("EmployeeTable");
try {
table.addEmptyRow();
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
table.addEmptyRows(1);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
table.clear();
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
table.optimize();
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
table.remove(0);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
table.removeLast();
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
table.setBinaryByteArray(0, 0, null);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
table.setBoolean(0, 0, false);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
table.setDate(0, 0, new Date(0));
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
table.addSearchIndex(0);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
table.setLong(0, 0, 0);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
table.setMixed(0, 0, null);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
table.setString(0, 0, "");
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
TableQuery q = table.where();
try {
q.remove();
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
q.remove(0, 0);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
TableView v = q.findAll();
try {
v.clear();
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
v.remove(0);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
v.removeLast();
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
v.setBinaryByteArray(0, 0, null);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
v.setBoolean(0, 0, false);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
v.setDate(0, 0, new Date());
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
v.setLong(0, 0, 0);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
v.setString(0, 0, "");
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
try {
v.setMixed(0, 0, null);
fail();
} catch (IllegalStateException e) {
assertNotNull(e);
}
t.endRead();
}
