Java Code Examples for android.database.sqlite.SQLiteDatabase#deleteDatabase()

@Override
protected void tearDown() throws Exception {
    super.tearDown();
    toggleAirplaneMode();
    //TODO Figure out how to isolate tests from one another. Currently, the next test seems to start before this method completes, causing a No Such Table exception.
    SQLiteDatabase.deleteDatabase(mHackerNewsDatabaseFile);
}
 

public void deleteDatabase() {
    // Are you sure? (y/n)
    final SQLiteDatabase db = mOpenHelper.getWritableDatabase();
    final File dbFile = new File(db.getPath());
    mOpenHelper.close();
    if (dbFile.exists()) {
        SQLiteDatabase.deleteDatabase(dbFile);
    }
    mOpenHelper = new DatabaseHelper(getContext());
}
 

public void deleteDatabase() {
    // Are you sure? (y/n)
    final SQLiteDatabase db = mOpenHelper.getWritableDatabase();
    final File dbFile = new File(db.getPath());
    mOpenHelper.close();
    if (dbFile.exists()) {
        SQLiteDatabase.deleteDatabase(dbFile);
    }
    mOpenHelper = new DatabaseHelper(getContext());
    mOpenHelper.mListener = mListener;
}
 

private void checkUserDatabase() {
    File oldUserDatabase = getDatabasePath(UserDataDBHelper.DATABASE_NAME);
    File newUserDatabasePath = new File(UserDataDBHelper.getDatabasePath(this));
    if (oldUserDatabase.exists() && !newUserDatabasePath.exists()) {
        try {
            StorageUtils.copyFile(oldUserDatabase, newUserDatabasePath);
            SQLiteDatabase.deleteDatabase(oldUserDatabase);
        } catch (IOException e) {
            Timber.e(e);
        }
    } else if (oldUserDatabase.exists() && newUserDatabasePath.exists()) {
        SQLiteDatabase.deleteDatabase(oldUserDatabase);
    }
}
 

@Override
public boolean deleteDatabase(String name) {
    try {
        File f = getDatabasePath(name);
        return SQLiteDatabase.deleteDatabase(f);
    } catch (Exception e) {
    }
    return false;
}
 

/**
 * Creates a new {@code CeDatabaseHelper}. If pre-N db file is present at the old location,
 * it also performs migration to the new CE database.
 */
static CeDatabaseHelper create(
        Context context,
        File preNDatabaseFile,
        File ceDatabaseFile) {
    boolean newDbExists = ceDatabaseFile.exists();
    if (Log.isLoggable(TAG, Log.VERBOSE)) {
        Log.v(TAG, "CeDatabaseHelper.create ceDatabaseFile=" + ceDatabaseFile
                + " oldDbExists=" + preNDatabaseFile.exists()
                + " newDbExists=" + newDbExists);
    }
    boolean removeOldDb = false;
    if (!newDbExists && preNDatabaseFile.exists()) {
        removeOldDb = migratePreNDbToCe(preNDatabaseFile, ceDatabaseFile);
    }
    // Try to open and upgrade if necessary
    CeDatabaseHelper ceHelper = new CeDatabaseHelper(context, ceDatabaseFile.getPath());
    ceHelper.getWritableDatabase();
    ceHelper.close();
    if (removeOldDb) {
        Slog.i(TAG, "Migration complete - removing pre-N db " + preNDatabaseFile);
        if (!SQLiteDatabase.deleteDatabase(preNDatabaseFile)) {
            Slog.e(TAG, "Cannot remove pre-N db " + preNDatabaseFile);
        }
    }
    return ceHelper;
}
 

@Override
public boolean deleteDatabase(String name) {
    try {
        File f = getDatabasePath(name);
        return SQLiteDatabase.deleteDatabase(f);
    } catch (Exception e) {
    }
    return false;
}
 

@Override
public boolean deleteDatabase(String name) {
    try {
        File f = validateFilePath(name, false);
        return SQLiteDatabase.deleteDatabase(f);
    } catch (Exception e) {
    }
    return false;
}
 

@Override
public boolean deleteDatabase(String name) {
    try {
        File f = validateFilePath(name, false);
        return SQLiteDatabase.deleteDatabase(f);
    } catch (Exception e) {
    }
    return false;
}
 

public void deleteDatabase() {
    // Are you sure? (y/n)
    final SQLiteDatabase db = mOpenHelper.getWritableDatabase();
    final File dbFile = new File(db.getPath());
    mOpenHelper.close();
    if (dbFile.exists()) {
        SQLiteDatabase.deleteDatabase(dbFile);
    }
    mOpenHelper = new DatabaseHelper(getContext());
}
 

@Override
public boolean deleteDatabase(String name) {
    try {
        File f = validateFilePath(name, false);
        return SQLiteDatabase.deleteDatabase(f);
    } catch (Exception e) {
    }
    return false;
}
 

@Override
public boolean deleteDatabase(String name) {
    try {
        File f = getDatabasePath(name);
        return SQLiteDatabase.deleteDatabase(f);
    } catch (Exception e) {
    }
    return false;
}
 

@Override
public boolean deleteDatabase(String name) {
    try {
        File f = validateFilePath(name, false);
        return SQLiteDatabase.deleteDatabase(f);
    } catch (Exception e) {
    }
    return false;
}
 

@Override
public boolean deleteDatabase(String name) {
    try {
        File f = validateFilePath(name, false);
        return SQLiteDatabase.deleteDatabase(f);
    } catch (Exception e) {
    }
    return false;
}
 

@Override
public boolean deleteDatabase(String name) {
    try {
        File f = getDatabasePath(name);
        return SQLiteDatabase.deleteDatabase(f);
    } catch (Exception e) {
    }
    return false;
}
 

@Override
public boolean deleteDatabase(String name) {
    try {
        File f = getDatabasePath(name);
        return SQLiteDatabase.deleteDatabase(f);
    } catch (Exception e) {
    }
    return false;
}
 

private void deleteDatabaseFile(String fileName) {
	if (fileName.equalsIgnoreCase(":memory:") || fileName.trim().length() == 0) {
		return;
	}
	if (this.logEnabled) {
		Logger.fatal("deleting the database file: " + fileName);
	}
	try {
		if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.JELLY_BEAN) {
			SQLiteDatabase.deleteDatabase(new File(fileName));
		} else {
			try {
				final boolean deleted = new File(fileName).delete();
				if (!deleted) {
					if (this.logEnabled) {
						Logger.fatal("Could not delete the database file " + fileName);
					}
				}
			} catch (Exception error) {
				if (this.logEnabled) {
					Logger.fatal("error while deleting corrupted database file " + error.getMessage());
				}
			}
		}
	} catch (Exception e) {
		if (this.logEnabled) {
			/* print warning and ignore exception */
			Logger.warn("delete failed: ", e);
		}
	}
}
 

private void moveFileSourcesDb(Context context, SQLiteDatabase database) {
	File dbFile = context.getDatabasePath("mizuu_sources");
	if (dbFile.exists()) {
		// The old database file exists! Let's create
		// a table for it in the new combined database
		database.execSQL(DATABASE_CREATE_FILESOURCES);

		String KEY_FILEPATH = "filepath";
		String KEY_TYPE = "type"; // movie / TV show
		String KEY_FILESOURCE_TYPE = "is_smb"; // local file / NAS / other sources... Used to be 0 = local file, 1 = smb.
		String KEY_USER = "user";
		String KEY_PASSWORD = "password";
		String KEY_DOMAIN = "domain";

		String[] SELECT_ALL = new String[]{KEY_FILEPATH, KEY_TYPE, KEY_FILESOURCE_TYPE, KEY_USER, KEY_PASSWORD, KEY_DOMAIN};

		SQLiteDatabase db = SQLiteDatabase.openOrCreateDatabase(dbFile, null);
		Cursor c = db.query("sources", SELECT_ALL, null, null, null, null, null);

		try {
			while (c.moveToNext()) {
				ContentValues cv = new ContentValues();
				cv.put(KEY_FILEPATH, c.getString(c.getColumnIndex(KEY_FILEPATH)));
				cv.put(KEY_TYPE, c.getString(c.getColumnIndex(KEY_TYPE)));
				cv.put(KEY_FILESOURCE_TYPE, c.getInt(c.getColumnIndex(KEY_FILESOURCE_TYPE)));
				cv.put(KEY_USER, c.getString(c.getColumnIndex(KEY_USER)));
				cv.put(KEY_PASSWORD, c.getString(c.getColumnIndex(KEY_PASSWORD)));
				cv.put(KEY_DOMAIN, c.getString(c.getColumnIndex(KEY_DOMAIN)));

				database.insert("sources", null, cv);
			}
		} catch (Exception e) {} finally {
			c.close();
			db.close();

			if (MizLib.hasJellyBean())
				SQLiteDatabase.deleteDatabase(dbFile);
			else					
				dbFile.delete();
		}
	}
}
 

static void deleteDbFileWarnIfFailed(File dbFile) {
    if (!SQLiteDatabase.deleteDatabase(dbFile)) {
        Log.w(TAG, "Database at " + dbFile + " was not deleted successfully");
    }
}
 

@After
public void unregisterIdlingResources() {
    Espresso.unregisterIdlingResources(mSyncAdapterIdlingResource);
    SQLiteDatabase.deleteDatabase(mHackerNewsDatabaseFile);
}