How to use

close

method

in

androidx.sqlite.db.SupportSQLiteDatabase

/**
 * Closes a previously opened database connection.
 */
public void close() {
  try {
    mDatabase.close();
    Timber.d("Database %s closed = %s", mDatabase.getPath(), !mDatabase.isOpen());
  } catch (Exception e) {
    // The pre-framework requery API ate this exception, but the framework API exposes it.
    // We may want to propagate it in the future, but for now maintain the old API and log.
    Timber.e(e, "Failed to close database %s", this.getDatabase().getPath());
  }
}

db.close();

db.close();

@Test(expected = net.sqlcipher.database.SQLiteException.class)
public void defaultBehavior() throws IOException {
 assertTrue(getDbFile().exists());
 SafeHelperFactory factory=
  SafeHelperFactory.fromUser(new SpannableStringBuilder(PASSPHRASE));
 SupportSQLiteOpenHelper helper=
  factory.create(InstrumentationRegistry.getTargetContext(), DB_NAME,
   new Callback(1));
 SupportSQLiteDatabase db=helper.getReadableDatabase();
 db.close();
}

private void dekey(Callable<?> decrypter) throws Exception {
 SafeHelperFactory factory=
  SafeHelperFactory.fromUser(new SpannableStringBuilder(PASSPHRASE));
 SupportSQLiteOpenHelper helper=
  factory.create(InstrumentationRegistry.getTargetContext(), DB_NAME,
   new Callback(1));
 SupportSQLiteDatabase db=helper.getWritableDatabase();
 assertOriginalContent(db);
 db.close();
 final Context ctxt=InstrumentationRegistry.getTargetContext();
 decrypter.call();
 SQLiteDatabase plainDb=
  SQLiteDatabase.openDatabase(ctxt.getDatabasePath(DB_NAME).getAbsolutePath(),
   null, SQLiteDatabase.OPEN_READWRITE);
 assertOriginalContent(plainDb);
 plainDb.close();
}

db.close();

private void enkey(Callable<?> encrypter) throws Exception {
 final Context ctxt=InstrumentationRegistry.getTargetContext();
 assertEquals(SQLCipherUtils.State.DOES_NOT_EXIST, SQLCipherUtils.getDatabaseState(ctxt, DB_NAME));
 SQLiteDatabase plainDb=
  SQLiteDatabase.openOrCreateDatabase(ctxt.getDatabasePath(DB_NAME).getAbsolutePath(),
   null);
 plainDb.execSQL("CREATE TABLE foo (bar, goo);");
 plainDb.execSQL("INSERT INTO foo (bar, goo) VALUES (?, ?)",
  new Object[] {1, "two"});
 assertOriginalContent(plainDb);
 plainDb.close();
 assertEquals(SQLCipherUtils.State.UNENCRYPTED, SQLCipherUtils.getDatabaseState(ctxt, DB_NAME));
 encrypter.call();
 assertEquals(SQLCipherUtils.State.ENCRYPTED, SQLCipherUtils.getDatabaseState(ctxt, DB_NAME));
 SafeHelperFactory factory=
  SafeHelperFactory.fromUser(new SpannableStringBuilder(PASSPHRASE));
 SupportSQLiteOpenHelper helper=
  factory.create(InstrumentationRegistry.getTargetContext(), DB_NAME,
   new Callback(1));
 SupportSQLiteDatabase db=helper.getReadableDatabase();
 assertOriginalContent(db);
 db.close();
}

@Test
public void wal() throws IOException {
 SafeHelperFactory factory=
  SafeHelperFactory.fromUser(new SpannableStringBuilder(PASSPHRASE));
 SupportSQLiteOpenHelper helper=
  factory.create(InstrumentationRegistry.getTargetContext(), DB_NAME,
   new Callback(1));
 SupportSQLiteDatabase db=helper.getWritableDatabase();
 assertFalse(db.isWriteAheadLoggingEnabled());
 assertTrue(db.enableWriteAheadLogging());
 assertTrue(db.isWriteAheadLoggingEnabled());
 db.close();
 factory=SafeHelperFactory.fromUser(new SpannableStringBuilder(PASSPHRASE));
 helper=
  factory.create(InstrumentationRegistry.getTargetContext(), DB_NAME,
   new Callback(1));
 db=helper.getWritableDatabase();
 assertTrue(db.isWriteAheadLoggingEnabled());
 db.disableWriteAheadLogging();
 assertFalse(db.isWriteAheadLoggingEnabled());
 db.close();
}

@Test
public void migrate() throws IOException {
 assertTrue(getDbFile().exists());
 SafeHelperFactory factory=
  SafeHelperFactory.fromUser(new SpannableStringBuilder(PASSPHRASE),
   SafeHelperFactory.POST_KEY_SQL_MIGRATE);
 SupportSQLiteOpenHelper helper=
  factory.create(InstrumentationRegistry.getTargetContext(), DB_NAME,
   new Callback(1));
 SupportSQLiteDatabase db=helper.getReadableDatabase();
 assertOriginalContent(db);
 db.close();
 // with migrate, the change should be permanent
 factory=SafeHelperFactory.fromUser(new SpannableStringBuilder(PASSPHRASE));
 helper=factory.create(InstrumentationRegistry.getTargetContext(), DB_NAME,
   new Callback(1));
 db=helper.getReadableDatabase();
 assertOriginalContent(db);
 db.close();
}

@Test
public void v3() throws IOException {
 assertTrue(getDbFile().exists());
 SafeHelperFactory factory=
  SafeHelperFactory.fromUser(new SpannableStringBuilder(PASSPHRASE),
   SafeHelperFactory.POST_KEY_SQL_V3);
 SupportSQLiteOpenHelper helper=
  factory.create(InstrumentationRegistry.getTargetContext(), DB_NAME,
   new Callback(1));
 SupportSQLiteDatabase db=helper.getReadableDatabase();
 assertOriginalContent(db);
 db.close();
 // with v3, the change should be temporary
 factory=SafeHelperFactory.fromUser(new SpannableStringBuilder(PASSPHRASE));
 helper=factory.create(InstrumentationRegistry.getTargetContext(), DB_NAME,
  new Callback(1));
 boolean didWeGoBoom = false;
 try {
  db = helper.getReadableDatabase();
 }
 catch (net.sqlcipher.database.SQLiteException ex) {
  didWeGoBoom = true;
 }
 assertTrue(didWeGoBoom);
}

@Test
public void rekey() throws IOException {
 SafeHelperFactory factory=
  SafeHelperFactory.fromUser(new SpannableStringBuilder("sekrit"));
 SupportSQLiteOpenHelper helper=
  factory.create(InstrumentationRegistry.getTargetContext(), DB_NAME,
   new Callback(1));
 SupportSQLiteDatabase db=helper.getWritableDatabase();
 assertOriginalContent(db);
 SafeHelperFactory.rekey(db, new SpannableStringBuilder(PASSPHRASE));
 assertOriginalContent(db);
 db.execSQL("UPDATE foo SET bar=?, goo=?", new Object[] {3, "four"});
 assertUpdatedContent(db);
 db.close();
 factory=SafeHelperFactory.fromUser(new SpannableStringBuilder(PASSPHRASE));
 helper=factory.create(InstrumentationRegistry.getTargetContext(), DB_NAME,
  new Callback(1));
 db=helper.getWritableDatabase();
 assertUpdatedContent(db);
}