public void testOpenFile() throws SQLiteException {
SQLiteConnection connection = fileDb();
assertFalse(connection.isOpen());
try {
connection.openReadonly();
fail("successfully opened");
} catch (SQLiteException e) {
// norm
}
assertFalse(connection.isOpen());
connection.dispose();
assertFalse(connection.isOpen());
connection.dispose();
assertFalse(connection.isOpen());
connection = fileDb();
boolean allowCreate = false;
try {
connection.open(allowCreate);
fail("successfully opened");
} catch (SQLiteException e) {
// norm
}
connection.open(true);
assertTrue(connection.isOpen());
assertEquals(dbFile(), connection.getDatabaseFile());
connection.dispose();
assertFalse(connection.isOpen());
}
public void testOpenMemory() throws SQLiteException {
SQLiteConnection connection = memDb();
assertFalse(connection.isOpen());
try {
connection.openReadonly();
fail("successfully opened");
} catch (SQLiteException e) {
// norm
}
assertFalse(connection.isOpen());
connection.dispose();
assertFalse(connection.isOpen());
connection.dispose();
assertFalse(connection.isOpen());
connection = memDb();
try {
connection.open(false);
fail("successfully opened");
} catch (SQLiteException e) {
// norm
}
connection.open();
assertTrue(connection.isOpen());
assertNull(connection.getDatabaseFile());
assertTrue(connection.isMemoryDatabase());
connection.dispose();
assertFalse(connection.isOpen());
}
/** Close a database (in the current thread). */
@Override
void closeDatabaseNow() {
try {
if (mydb != null) mydb.dispose();
} catch (Exception e) {
Log.e(SQLitePlugin.class.getSimpleName(), "couldn't close database, ignoring", e);
}
}
public void testOpenV2() throws SQLiteException {
SQLiteConnection db = fileDb();
db.openV2(
SQLiteConstants.SQLITE_OPEN_CREATE
| SQLiteConstants.SQLITE_OPEN_READWRITE
| SQLiteConstants.SQLITE_OPEN_NOMUTEX);
db.exec("create table x(x)");
db.dispose();
}
public void testCannotReopen() throws SQLiteException {
SQLiteConnection connection = fileDb();
connection.open();
assertTrue(connection.isOpen());
try {
connection.open();
} catch (AssertionError e) {
// ok
}
assertTrue(connection.isOpen());
connection.dispose();
assertFalse(connection.isOpen());
connection.dispose();
assertFalse(connection.isOpen());
try {
connection.open();
fail("reopened connection");
} catch (SQLiteException e) {
// ok
}
assertFalse(connection.isOpen());
}
