From 3ddfde9a5418ba23aef752162c73d423a5e207a3 Mon Sep 17 00:00:00 2001 From: Stefan Niedermann Date: Tue, 11 May 2021 21:15:56 +0200 Subject: Sanitize API versions while migrating the database --- .../notes/shared/util/DatabaseIndexUtil.java | 41 ---------------------- 1 file changed, 41 deletions(-) delete mode 100644 app/src/main/java/it/niedermann/owncloud/notes/shared/util/DatabaseIndexUtil.java (limited to 'app/src/main/java/it/niedermann/owncloud/notes/shared') diff --git a/app/src/main/java/it/niedermann/owncloud/notes/shared/util/DatabaseIndexUtil.java b/app/src/main/java/it/niedermann/owncloud/notes/shared/util/DatabaseIndexUtil.java deleted file mode 100644 index 8506c713..00000000 --- a/app/src/main/java/it/niedermann/owncloud/notes/shared/util/DatabaseIndexUtil.java +++ /dev/null @@ -1,41 +0,0 @@ -package it.niedermann.owncloud.notes.shared.util; - -import android.database.Cursor; -import android.database.sqlite.SQLiteDatabase; -import android.util.Log; - -import androidx.annotation.NonNull; -import androidx.sqlite.db.SupportSQLiteDatabase; - -public class DatabaseIndexUtil { - - private static final String TAG = DatabaseIndexUtil.class.getSimpleName(); - - private DatabaseIndexUtil() { - - } - - public static void createIndex(@NonNull SupportSQLiteDatabase db, @NonNull String table, @NonNull String... columns) { - for (String column : columns) { - createIndex(db, table, column); - } - } - - public static void createIndex(@NonNull SupportSQLiteDatabase db, @NonNull String table, @NonNull String column) { - String indexName = table + "_" + column + "_idx"; - Log.v(TAG, "Creating database index: CREATE INDEX IF NOT EXISTS " + indexName + " ON " + table + "(" + column + ")"); - db.execSQL("CREATE INDEX " + indexName + " ON " + table + "(" + column + ")"); - } - - public static void dropIndexes(@NonNull SupportSQLiteDatabase db) { - try (Cursor c = db.query("SELECT name, sql FROM sqlite_master WHERE type = 'index'")) { - while (c.moveToNext()) { - // Skip automatic indexes which we can't drop manually - if (c.getString(1) != null) { - Log.v(TAG, "Deleting database index: DROP INDEX " + c.getString(0)); - db.execSQL("DROP INDEX " + c.getString(0)); - } - } - } - } -} -- cgit v1.2.3