/*
- * Copyright © 2016-2022 Soren Stoutner <soren@stoutner.com>.
+ * Copyright 2016-2022 Soren Stoutner <soren@stoutner.com>.
*
* This file is part of Privacy Browser Android <https://www.stoutner.com/privacy-browser-android>.
*
// Code for upgrading the database will be added here when the schema version > 1.
}
+ // Get a cursor of all the folders.
+ val allFolders: Cursor
+ get() {
+ // Get a readable database handle.
+ val bookmarksDatabase = this.readableDatabase
+
+ // Return the cursor with the all the folders. The cursor cannot be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $IS_FOLDER = 1 ORDER BY $BOOKMARK_NAME ASC", null)
+ }
+
+ // Get a cursor for all bookmarks and folders.
+ val allBookmarks: Cursor
+ get() {
+ // Get a readable database handle.
+ val bookmarksDatabase = this.readableDatabase
+
+ // Return a cursor with the entire contents of the bookmarks table. The cursor cannot be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE", null)
+ }
+
+ // Get a cursor for all bookmarks and folders ordered by display order.
+ val allBookmarksByDisplayOrder: Cursor
+ get() {
+ // Get a readable database handle.
+ val bookmarksDatabase = this.readableDatabase
+
+ // Return a cursor with the entire contents of the bookmarks table ordered by the display order. The cursor cannot be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE ORDER BY $DISPLAY_ORDER ASC", null)
+ }
+
// Create a bookmark.
fun createBookmark(bookmarkName: String, bookmarkURL: String, parentFolder: String, displayOrder: Int, favoriteIcon: ByteArray) {
// Store the bookmark data in a content values.
bookmarksDatabase.close()
}
+ // Delete one bookmark.
+ fun deleteBookmark(databaseId: Int) {
+ // Get a writable database handle.
+ val bookmarksDatabase = this.writableDatabase
+
+ // Deletes the row with the given database ID.
+ bookmarksDatabase.delete(BOOKMARKS_TABLE, "$ID = $databaseId", null)
+
+ // Close the database handle.
+ bookmarksDatabase.close()
+ }
+
// Get a cursor for the bookmark with the specified database ID.
fun getBookmark(databaseId: Int): Cursor {
// Get a readable database handle.
return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $ID = $databaseId", null)
}
- // Get the folder name for the specified database ID.
- fun getFolderName(databaseId: Int): String {
+ // Get a cursor for all bookmarks and folders by display order except those with the specified IDs.
+ fun getAllBookmarksByDisplayOrderExcept(exceptIdLongArray: LongArray): Cursor {
// Get a readable database handle.
val bookmarksDatabase = this.readableDatabase
- // Get the cursor for the folder with the specified database ID.
- val folderCursor = bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $ID = $databaseId", null)
-
- // Move to the first record.
- folderCursor.moveToFirst()
+ // Prepare a string builder to contain the comma-separated list of IDs not to get.
+ val idsNotToGetStringBuilder = StringBuilder()
- // Get the folder name.
- val folderName = folderCursor.getString(folderCursor.getColumnIndexOrThrow(BOOKMARK_NAME))
+ // Extract the array of IDs not to get to the string builder.
+ for (databaseIdLong in exceptIdLongArray) {
+ // Check to see if there is already a number in the builder.
+ if (idsNotToGetStringBuilder.isNotEmpty()) {
+ // This is not the first number, so place a `,` before the new number.
+ idsNotToGetStringBuilder.append(",")
+ }
- // Close the cursor and the database handle.
- folderCursor.close()
- bookmarksDatabase.close()
+ // Add the new number to the builder.
+ idsNotToGetStringBuilder.append(databaseIdLong)
+ }
- // Return the folder name.
- return folderName
+ // Return a cursor with all the bookmarks except those specified ordered by display order. The cursor cannot be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $ID NOT IN ($idsNotToGetStringBuilder) ORDER BY $DISPLAY_ORDER ASC", null)
}
- // Get the database ID for the specified folder name.
- fun getFolderDatabaseId(folderName: String): Int {
+ // Get a cursor for all bookmarks and folders except those with the specified IDs.
+ fun getAllBookmarksExcept(exceptIdLongArray: LongArray): Cursor {
// Get a readable database handle.
val bookmarksDatabase = this.readableDatabase
- // SQL escape the folder name.
- val sqlEscapedFolderName = DatabaseUtils.sqlEscapeString(folderName)
-
- // Get the cursor for the folder with the specified name.
- val folderCursor = bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $BOOKMARK_NAME = $sqlEscapedFolderName AND $IS_FOLDER = 1", null)
-
- // Move to the first record.
- folderCursor.moveToFirst()
+ // Prepare a string builder to contain the comma-separated list of IDs not to get.
+ val idsNotToGetStringBuilder = StringBuilder()
- // Get the database ID.
- val databaseId = folderCursor.getInt(folderCursor.getColumnIndexOrThrow(ID))
+ // Extract the array of IDs not to get to the string builder.
+ for (databaseIdLong in exceptIdLongArray) {
+ // Check to see if there is already a number in the builder.
+ if (idsNotToGetStringBuilder.isNotEmpty()) {
+ // This is not the first number, so place a `,` before the new number.
+ idsNotToGetStringBuilder.append(",")
+ }
- // Close the cursor and the database handle.
- folderCursor.close()
- bookmarksDatabase.close()
+ // Add the new number to the builder.
+ idsNotToGetStringBuilder.append(databaseIdLong)
+ }
- // Return the database ID.
- return databaseId
+ // Return a cursor with all the bookmarks except those specified. The cursor cannot be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $ID NOT IN ($idsNotToGetStringBuilder)", null)
}
- // Get a cursor for the specified folder name.
- fun getFolder(folderName: String): Cursor {
+ // Get a cursor with just database ID of bookmarks and folders in the specified folder. This is useful for deleting folders with bookmarks that have favorite icons too large to fit in a cursor.
+ fun getBookmarkIds(folderName: String): Cursor {
// Get a readable database handle.
val bookmarksDatabase = this.readableDatabase
// SQL escape the folder name.
val sqlEscapedFolderName = DatabaseUtils.sqlEscapeString(folderName)
- // Return the cursor for the specified folder. The cursor can't be closed because it is used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $BOOKMARK_NAME = $sqlEscapedFolderName AND $IS_FOLDER = 1", null)
- }
-
- // Get a cursor of all the folders except those specified.
- fun getFoldersExcept(exceptFolders: String): Cursor {
- // Get a readable database handle.
- val bookmarksDatabase = this.readableDatabase
-
- // Return the cursor of all folders except those specified. Each individual folder in the list has already been SQL escaped. The cursor can't be closed because it is used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $IS_FOLDER = 1 AND $BOOKMARK_NAME NOT IN ($exceptFolders) ORDER BY $BOOKMARK_NAME ASC", null)
- }
-
- // Get a cursor with all the subfolders of the specified folder.
- fun getSubfolders(currentFolder: String): Cursor {
- // Get a readable database handle.
- val bookmarksDatabase = this.readableDatabase
-
- // SQL escape the current folder.
- val sqlEscapedCurrentFolder = DatabaseUtils.sqlEscapeString(currentFolder)
-
- // Return the cursor with the subfolders. The cursor can't be closed because it is used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedCurrentFolder AND $IS_FOLDER = 1", null)
+ // Return a cursor with all the database IDs. The cursor cannot be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT $ID FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedFolderName", null)
}
- // Get the name of the parent folder.
- fun getParentFolderName(currentFolder: String): String {
+ // Get a cursor for bookmarks and folders in the specified folder.
+ fun getBookmarks(folderName: String): Cursor {
// Get a readable database handle.
val bookmarksDatabase = this.readableDatabase
- // SQL escape the current folder.
- val sqlEscapedCurrentFolder = DatabaseUtils.sqlEscapeString(currentFolder)
-
- // Get a cursor for the current folder.
- val bookmarkCursor = bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $IS_FOLDER = 1 AND $BOOKMARK_NAME = $sqlEscapedCurrentFolder", null)
-
- // Move to the first record.
- bookmarkCursor.moveToFirst()
-
- // Store the name of the parent folder.
- val parentFolder = bookmarkCursor.getString(bookmarkCursor.getColumnIndexOrThrow(PARENT_FOLDER))
-
- // Close the cursor and the database.
- bookmarkCursor.close()
- bookmarksDatabase.close()
+ // SQL escape the folder name.
+ val sqlEscapedFolderName = DatabaseUtils.sqlEscapeString(folderName)
- // Return the parent folder string.
- return parentFolder
+ // Return a cursor with all the bookmarks in a specified folder. The cursor cannot be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedFolderName", null)
}
- // Get the name of the parent folder.
- fun getParentFolderName(databaseId: Int): String {
+ // Get a cursor for bookmarks and folders in the specified folder ordered by display order.
+ fun getBookmarksByDisplayOrder(folderName: String): Cursor {
// Get a readable database handle.
val bookmarksDatabase = this.readableDatabase
- // Get a cursor for the specified database ID.
- val bookmarkCursor = bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $ID = $databaseId", null)
-
- // Move to the first record.
- bookmarkCursor.moveToFirst()
-
- // Store the name of the parent folder.
- val parentFolder = bookmarkCursor.getString(bookmarkCursor.getColumnIndexOrThrow(PARENT_FOLDER))
-
- // Close the cursor and the database.
- bookmarkCursor.close()
- bookmarksDatabase.close()
+ // SQL escape the folder name.
+ val sqlEscapedFolderName = DatabaseUtils.sqlEscapeString(folderName)
- // Return the parent folder string.
- return parentFolder
+ // Return a cursor with all the bookmarks in the specified folder ordered by display order. The cursor cannot be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedFolderName ORDER BY $DISPLAY_ORDER ASC", null)
}
- // Get a cursor of all the folders.
- val allFolders: Cursor
- get() {
- // Get a readable database handle.
- val bookmarksDatabase = this.readableDatabase
-
- // Return the cursor with the all the folders. The cursor cannot be closed because it is used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $IS_FOLDER = 1 ORDER BY $BOOKMARK_NAME ASC", null)
- }
-
- // Get a cursor for all bookmarks and folders.
- val allBookmarks: Cursor
- get() {
- // Get a readable database handle.
- val bookmarksDatabase = this.readableDatabase
-
- // Return a cursor with the entire contents of the bookmarks table. The cursor cannot be closed because it is used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE", null)
- }
-
- // Get a cursor for all bookmarks and folders ordered by display order.
- val allBookmarksByDisplayOrder: Cursor
- get() {
- // Get a readable database handle.
- val bookmarksDatabase = this.readableDatabase
-
- // Return a cursor with the entire contents of the bookmarks table ordered by the display order. The cursor cannot be closed because it is used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE ORDER BY $DISPLAY_ORDER ASC", null)
- }
-
- // Get a cursor for all bookmarks and folders except those with the specified IDs.
- fun getAllBookmarksExcept(exceptIdLongArray: LongArray): Cursor {
+ // Get a cursor for bookmarks and folders in the specified folder by display order except those with the specified IDs.
+ fun getBookmarksByDisplayOrderExcept(exceptIdLongArray: LongArray, folderName: String): Cursor {
// Get a readable database handle.
val bookmarksDatabase = this.readableDatabase
idsNotToGetStringBuilder.append(databaseIdLong)
}
- // Return a cursor with all the bookmarks except those specified. The cursor cannot be closed because it is used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $ID NOT IN ($idsNotToGetStringBuilder)", null)
+ // SQL escape the folder name.
+ val sqlEscapedFolderName = DatabaseUtils.sqlEscapeString(folderName)
+
+ // Return a cursor with all the bookmarks in the specified folder except for those database IDs specified ordered by display order.
+ // The cursor cannot be closed because it will be used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedFolderName AND $ID NOT IN ($idsNotToGetStringBuilder) ORDER BY $DISPLAY_ORDER ASC",
+ null)
}
- // Get a cursor for all bookmarks and folders by display order except those with the specified IDs.
- fun getAllBookmarksByDisplayOrderExcept(exceptIdLongArray: LongArray): Cursor {
+ // Get a cursor for bookmarks and folders in the specified folder except those with the specified IDs.
+ fun getBookmarksExcept(exceptIdLongArray: LongArray, folderName: String): Cursor {
// Get a readable database handle.
val bookmarksDatabase = this.readableDatabase
idsNotToGetStringBuilder.append(databaseIdLong)
}
- // Return a cursor with all the bookmarks except those specified ordered by display order. The cursor cannot be closed because it is used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $ID NOT IN ($idsNotToGetStringBuilder) ORDER BY $DISPLAY_ORDER ASC", null)
+ // SQL escape the folder name.
+ val sqlEscapedFolderName = DatabaseUtils.sqlEscapeString(folderName)
+
+ // Return a cursor with all the bookmarks in the specified folder except for those database IDs specified. The cursor cannot be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedFolderName AND $ID NOT IN ($idsNotToGetStringBuilder)", null)
}
- // Get a cursor for bookmarks and folders in the specified folder.
- fun getBookmarks(folderName: String): Cursor {
+ // Get a cursor for the specified folder name.
+ fun getFolder(folderName: String): Cursor {
// Get a readable database handle.
val bookmarksDatabase = this.readableDatabase
// SQL escape the folder name.
val sqlEscapedFolderName = DatabaseUtils.sqlEscapeString(folderName)
- // Return a cursor with all the bookmarks in a specified folder. The cursor cannot be closed because it is used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedFolderName", null)
+ // Return the cursor for the specified folder. The cursor can't be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $BOOKMARK_NAME = $sqlEscapedFolderName AND $IS_FOLDER = 1", null)
}
- // Get a cursor for bookmarks and folders in the specified folder ordered by display order.
- fun getBookmarksByDisplayOrder(folderName: String): Cursor {
- // Get a readable database handle.
- val bookmarksDatabase = this.readableDatabase
+ fun getFolderBookmarks(folderDatabaseId: Int): Cursor {
+ // Get the folder name.
+ val folderName = getFolderName(folderDatabaseId)
// SQL escape the folder name.
val sqlEscapedFolderName = DatabaseUtils.sqlEscapeString(folderName)
- // Return a cursor with all the bookmarks in the specified folder ordered by display order. The cursor cannot be closed because it is used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedFolderName ORDER BY $DISPLAY_ORDER ASC", null)
+ // Get a readable database handle.
+ val bookmarksDatabase = this.readableDatabase
+
+ // Return a cursor with all the bookmarks in the folder. The cursor cannot be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedFolderName AND $IS_FOLDER = 0 ORDER BY $DISPLAY_ORDER ASC", null)
}
- // Get a cursor with just database ID of bookmarks and folders in the specified folder. This is useful for deleting folders with bookmarks that have favorite icons too large to fit in a cursor.
- fun getBookmarkIds(folderName: String): Cursor {
+ // Get the database ID for the specified folder name.
+ fun getFolderDatabaseId(folderName: String): Int {
// Get a readable database handle.
val bookmarksDatabase = this.readableDatabase
// SQL escape the folder name.
val sqlEscapedFolderName = DatabaseUtils.sqlEscapeString(folderName)
- // Return a cursor with all the database IDs. The cursor cannot be closed because it is used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT $ID FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedFolderName", null)
+ // Get the cursor for the folder with the specified name.
+ val folderCursor = bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $BOOKMARK_NAME = $sqlEscapedFolderName AND $IS_FOLDER = 1", null)
+
+ // Move to the first record.
+ folderCursor.moveToFirst()
+
+ // Get the database ID.
+ val databaseId = folderCursor.getInt(folderCursor.getColumnIndexOrThrow(ID))
+
+ // Close the cursor and the database handle.
+ folderCursor.close()
+ bookmarksDatabase.close()
+
+ // Return the database ID.
+ return databaseId
}
- // Get a cursor for bookmarks and folders in the specified folder except those with the specified IDs.
- fun getBookmarksExcept(exceptIdLongArray: LongArray, folderName: String): Cursor {
+ // Get the folder name for the specified database ID.
+ fun getFolderName(databaseId: Int): String {
// Get a readable database handle.
val bookmarksDatabase = this.readableDatabase
- // Prepare a string builder to contain the comma-separated list of IDs not to get.
- val idsNotToGetStringBuilder = StringBuilder()
+ // Get the cursor for the folder with the specified database ID.
+ val folderCursor = bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $ID = $databaseId", null)
- // Extract the array of IDs not to get to the string builder.
- for (databaseIdLong in exceptIdLongArray) {
- // Check to see if there is already a number in the builder.
- if (idsNotToGetStringBuilder.isNotEmpty()) {
- // This is not the first number, so place a `,` before the new number.
- idsNotToGetStringBuilder.append(",")
- }
+ // Move to the first record.
+ folderCursor.moveToFirst()
- // Add the new number to the builder.
- idsNotToGetStringBuilder.append(databaseIdLong)
- }
+ // Get the folder name.
+ val folderName = folderCursor.getString(folderCursor.getColumnIndexOrThrow(BOOKMARK_NAME))
- // SQL escape the folder name.
- val sqlEscapedFolderName = DatabaseUtils.sqlEscapeString(folderName)
+ // Close the cursor and the database handle.
+ folderCursor.close()
+ bookmarksDatabase.close()
- // Return a cursor with all the bookmarks in the specified folder except for those database IDs specified. The cursor cannot be closed because it is used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedFolderName AND $ID NOT IN ($idsNotToGetStringBuilder)", null)
+ // Return the folder name.
+ return folderName
}
- // Get a cursor for bookmarks and folders in the specified folder by display order except those with the specified IDs.
- fun getBookmarksByDisplayOrderExcept(exceptIdLongArray: LongArray, folderName: String): Cursor {
+ // Get a cursor of all the folders except those specified.
+ fun getFoldersExcept(exceptFolders: String): Cursor {
// Get a readable database handle.
val bookmarksDatabase = this.readableDatabase
- // Prepare a string builder to contain the comma-separated list of IDs not to get.
- val idsNotToGetStringBuilder = StringBuilder()
+ // Return the cursor of all folders except those specified. Each individual folder in the list has already been SQL escaped. The cursor can't be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $IS_FOLDER = 1 AND $BOOKMARK_NAME NOT IN ($exceptFolders) ORDER BY $BOOKMARK_NAME ASC", null)
+ }
- // Extract the array of IDs not to get to the string builder.
- for (databaseIdLong in exceptIdLongArray) {
- // Check to see if there is already a number in the builder.
- if (idsNotToGetStringBuilder.isNotEmpty()) {
- // This is not the first number, so place a `,` before the new number.
- idsNotToGetStringBuilder.append(",")
- }
+ // Get the name of the parent folder.
+ fun getParentFolderName(currentFolder: String): String {
+ // Get a readable database handle.
+ val bookmarksDatabase = this.readableDatabase
- // Add the new number to the builder.
- idsNotToGetStringBuilder.append(databaseIdLong)
- }
+ // SQL escape the current folder.
+ val sqlEscapedCurrentFolder = DatabaseUtils.sqlEscapeString(currentFolder)
- // SQL escape the folder name.
- val sqlEscapedFolderName = DatabaseUtils.sqlEscapeString(folderName)
+ // Get a cursor for the current folder.
+ val bookmarkCursor = bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $IS_FOLDER = 1 AND $BOOKMARK_NAME = $sqlEscapedCurrentFolder", null)
- // Return a cursor with all the bookmarks in the specified folder except for those database IDs specified ordered by display order.
- // The cursor cannot be closed because it will be used in the parent activity.
- return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedFolderName AND $ID NOT IN ($idsNotToGetStringBuilder) ORDER BY $DISPLAY_ORDER ASC",
- null)
+ // Move to the first record.
+ bookmarkCursor.moveToFirst()
+
+ // Store the name of the parent folder.
+ val parentFolder = bookmarkCursor.getString(bookmarkCursor.getColumnIndexOrThrow(PARENT_FOLDER))
+
+ // Close the cursor and the database.
+ bookmarkCursor.close()
+ bookmarksDatabase.close()
+
+ // Return the parent folder string.
+ return parentFolder
+ }
+
+ // Get the name of the parent folder.
+ fun getParentFolderName(databaseId: Int): String {
+ // Get a readable database handle.
+ val bookmarksDatabase = this.readableDatabase
+
+ // Get a cursor for the specified database ID.
+ val bookmarkCursor = bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $ID = $databaseId", null)
+
+ // Move to the first record.
+ bookmarkCursor.moveToFirst()
+
+ // Store the name of the parent folder.
+ val parentFolder = bookmarkCursor.getString(bookmarkCursor.getColumnIndexOrThrow(PARENT_FOLDER))
+
+ // Close the cursor and the database.
+ bookmarkCursor.close()
+ bookmarksDatabase.close()
+
+ // Return the parent folder string.
+ return parentFolder
+ }
+
+ // Get a cursor with all the subfolders of the specified folder.
+ fun getSubfolders(currentFolder: String): Cursor {
+ // Get a readable database handle.
+ val bookmarksDatabase = this.readableDatabase
+
+ // SQL escape the current folder.
+ val sqlEscapedCurrentFolder = DatabaseUtils.sqlEscapeString(currentFolder)
+
+ // Return the cursor with the subfolders. The cursor can't be closed because it is used in the parent activity.
+ return bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedCurrentFolder AND $IS_FOLDER = 1", null)
}
// Check if a database ID is a folder.
return isFolder
}
+ // Move one bookmark or folder to a new folder.
+ fun moveToFolder(databaseId: Int, newFolder: String) {
+ // Get a writable database handle.
+ val bookmarksDatabase = this.writableDatabase
+
+ // SQL escape the new folder name.
+ val sqlEscapedNewFolder = DatabaseUtils.sqlEscapeString(newFolder)
+
+ // Get a cursor for all the bookmarks in the new folder ordered by display order.
+ val newFolderCursor = bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedNewFolder ORDER BY $DISPLAY_ORDER ASC", null)
+
+ // Set the new display order.
+ val displayOrder: Int = if (newFolderCursor.count > 0) { // There are already bookmarks in the folder.
+ // Move to the last bookmark.
+ newFolderCursor.moveToLast()
+
+ // Set the display order to be one greater that the last bookmark.
+ newFolderCursor.getInt(newFolderCursor.getColumnIndexOrThrow(DISPLAY_ORDER)) + 1
+ } else { // There are no bookmarks in the new folder.
+ // Set the display order to be `0`.
+ 0
+ }
+
+ // Close the cursor.
+ newFolderCursor.close()
+
+ // Create a content values.
+ val bookmarkContentValues = ContentValues()
+
+ // Store the new values.
+ bookmarkContentValues.put(DISPLAY_ORDER, displayOrder)
+ bookmarkContentValues.put(PARENT_FOLDER, newFolder)
+
+ // Update the database.
+ bookmarksDatabase.update(BOOKMARKS_TABLE, bookmarkContentValues, "$ID = $databaseId", null)
+
+ // Close the database handle.
+ bookmarksDatabase.close()
+ }
+
// Update the bookmark name and URL.
fun updateBookmark(databaseId: Int, bookmarkName: String, bookmarkUrl: String) {
// Initialize a content values.
bookmarksDatabase.close()
}
+ // Update the display order for one bookmark or folder.
+ fun updateDisplayOrder(databaseId: Int, displayOrder: Int) {
+ // Get a writable database handle.
+ val bookmarksDatabase = this.writableDatabase
+
+ // Create a content values.
+ val bookmarkContentValues = ContentValues()
+
+ // Store the new display order.
+ bookmarkContentValues.put(DISPLAY_ORDER, displayOrder)
+
+ // Update the database.
+ bookmarksDatabase.update(BOOKMARKS_TABLE, bookmarkContentValues, "$ID = $databaseId", null)
+
+ // Close the database handle.
+ bookmarksDatabase.close()
+ }
+
// Update the folder name.
fun updateFolder(databaseId: Int, oldFolderName: String, newFolderName: String) {
// Get a writable database handle.
// Close the database handle.
bookmarksDatabase.close()
}
-
- // Update the display order for one bookmark or folder.
- fun updateDisplayOrder(databaseId: Int, displayOrder: Int) {
- // Get a writable database handle.
- val bookmarksDatabase = this.writableDatabase
-
- // Create a content values.
- val bookmarkContentValues = ContentValues()
-
- // Store the new display order.
- bookmarkContentValues.put(DISPLAY_ORDER, displayOrder)
-
- // Update the database.
- bookmarksDatabase.update(BOOKMARKS_TABLE, bookmarkContentValues, "$ID = $databaseId", null)
-
- // Close the database handle.
- bookmarksDatabase.close()
- }
-
- // Move one bookmark or folder to a new folder.
- fun moveToFolder(databaseId: Int, newFolder: String) {
- // Get a writable database handle.
- val bookmarksDatabase = this.writableDatabase
-
- // SQL escape the new folder name.
- val sqlEscapedNewFolder = DatabaseUtils.sqlEscapeString(newFolder)
-
- // Get a cursor for all the bookmarks in the new folder ordered by display order.
- val newFolderCursor = bookmarksDatabase.rawQuery("SELECT * FROM $BOOKMARKS_TABLE WHERE $PARENT_FOLDER = $sqlEscapedNewFolder ORDER BY $DISPLAY_ORDER ASC", null)
-
- // Set the new display order.
- val displayOrder: Int = if (newFolderCursor.count > 0) { // There are already bookmarks in the folder.
- // Move to the last bookmark.
- newFolderCursor.moveToLast()
-
- // Set the display order to be one greater that the last bookmark.
- newFolderCursor.getInt(newFolderCursor.getColumnIndexOrThrow(DISPLAY_ORDER)) + 1
- } else { // There are no bookmarks in the new folder.
- // Set the display order to be `0`.
- 0
- }
-
- // Close the cursor.
- newFolderCursor.close()
-
- // Create a content values.
- val bookmarkContentValues = ContentValues()
-
- // Store the new values.
- bookmarkContentValues.put(DISPLAY_ORDER, displayOrder)
- bookmarkContentValues.put(PARENT_FOLDER, newFolder)
-
- // Update the database.
- bookmarksDatabase.update(BOOKMARKS_TABLE, bookmarkContentValues, "$ID = $databaseId", null)
-
- // Close the database handle.
- bookmarksDatabase.close()
- }
-
- // Delete one bookmark.
- fun deleteBookmark(databaseId: Int) {
- // Get a writable database handle.
- val bookmarksDatabase = this.writableDatabase
-
- // Deletes the row with the given database ID.
- bookmarksDatabase.delete(BOOKMARKS_TABLE, "$ID = $databaseId", null)
-
- // Close the database handle.
- bookmarksDatabase.close()
- }
-}
\ No newline at end of file
+}
projects / PrivacyBrowserAndroid.git / blobdiff