2 * Copyright 2018-2023 Soren Stoutner <soren@stoutner.com>.
4 * This file is part of Privacy Browser Android <https://www.stoutner.com/privacy-browser-android>.
6 * Privacy Browser Android is free software: you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation, either version 3 of the License, or
9 * (at your option) any later version.
11 * Privacy Browser Android is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
16 * You should have received a copy of the GNU General Public License
17 * along with Privacy Browser Android. If not, see <http://www.gnu.org/licenses/>.
20 package com.stoutner.privacybrowser.helpers
22 import android.content.ContentValues
23 import android.content.Context
24 import android.database.DatabaseUtils
25 import android.database.sqlite.SQLiteDatabase
27 import androidx.preference.PreferenceManager
29 import com.stoutner.privacybrowser.R
32 import java.io.FileInputStream
33 import java.io.FileOutputStream
34 import java.io.InputStream
35 import java.io.OutputStream
37 // Define the private class constants.
38 private const val ALLOW_SCREENSHOTS = "allow_screenshots"
39 private const val AMP_REDIRECTS = "amp_redirects"
40 private const val APP_THEME = "app_theme"
41 private const val BLOCK_ALL_THIRD_PARTY_REQUESTS = "block_all_third_party_requests"
42 private const val BOTTOM_APP_BAR = "bottom_app_bar"
43 private const val CLEAR_CACHE = "clear_cache"
44 private const val CLEAR_COOKIES = "clear_cookies"
45 private const val CLEAR_DOM_STORAGE = "clear_dom_storage"
46 private const val CLEAR_EVERYTHING = "clear_everything"
47 private const val CLEAR_FORM_DATA = "clear_form_data" // Clear form data can be removed once the minimum API >= 26.
48 private const val CLEAR_LOGCAT = "clear_logcat"
49 private const val COOKIES = "cookies"
50 private const val CUSTOM_USER_AGENT = "custom_user_agent"
51 private const val DISPLAY_ADDITIONAL_APP_BAR_ICONS = "display_additional_app_bar_icons"
52 private const val DISPLAY_WEBPAGE_IMAGES = "display_webpage_images"
53 private const val DOM_STORAGE = "dom_storage"
54 private const val DOWNLOAD_WITH_EXTERNAL_APP = "download_with_external_app"
55 private const val EASYLIST = "easylist"
56 private const val EASYPRIVACY = "easyprivacy"
57 private const val FANBOYS_ANNOYANCE_LIST = "fanboys_annoyance_list"
58 private const val FANBOYS_SOCIAL_BLOCKING_LIST = "fanboys_social_blocking_list"
59 private const val FONT_SIZE = "font_size"
60 private const val FULL_SCREEN_BROWSING_MODE = "full_screen_browsing_mode"
61 private const val HIDE_APP_BAR = "hide_app_bar"
62 private const val HOMEPAGE = "homepage"
63 private const val ID = "_id"
64 private const val INCOGNITO_MODE = "incognito_mode"
65 private const val JAVASCRIPT = "javascript"
66 private const val OPEN_INTENTS_IN_NEW_TAB = "open_intents_in_new_tab"
67 private const val PREFERENCES_TABLE = "preferences"
68 private const val PROXY = "proxy"
69 private const val PROXY_CUSTOM_URL = "proxy_custom_url"
70 private const val SAVE_FORM_DATA = "save_form_data"
71 private const val SEARCH = "search"
72 private const val SEARCH_CUSTOM_URL = "search_custom_url"
73 private const val SCROLL_APP_BAR = "scroll_app_bar"
74 private const val SWIPE_TO_REFRESH = "swipe_to_refresh"
75 private const val TRACKING_QUERIES = "tracking_queries"
76 private const val ULTRALIST = "ultralist"
77 private const val ULTRAPRIVACY = "ultraprivacy"
78 private const val USER_AGENT = "user_agent"
79 private const val WEBVIEW_THEME = "webview_theme"
80 private const val WIDE_VIEWPORT = "wide_viewport"
82 class ImportExportDatabaseHelper {
83 // Define the public companion object constants. These can be moved to public class constants once the entire project has migrated to Kotlin.
85 // Define the public class constants.
86 const val EXPORT_SUCCESSFUL = "Export Successful"
87 const val IMPORT_SUCCESSFUL = "Import Successful"
88 const val SCHEMA_VERSION = 16
91 fun importUnencrypted(importFileInputStream: InputStream, context: Context): String {
93 // Create a temporary import file.
94 val temporaryImportFile = File.createTempFile("temporary_import_file", null, context.cacheDir)
96 // The file may be copied directly in Kotlin using `File.copyTo`. <https://kotlinlang.org/api/latest/jvm/stdlib/kotlin.io/java.io.-file/copy-to.html>
97 // It can be copied in Android using `Files.copy` once the minimum API >= 26.
98 // <https://developer.android.com/reference/java/nio/file/Files#copy(java.nio.file.Path,%20java.nio.file.Path,%20java.nio.file.CopyOption...)>
99 // However, the file cannot be acquired from the content URI until the minimum API >= 29. <https://developer.android.com/reference/kotlin/android/content/ContentResolver#openfile>
101 // Create a temporary file output stream.
102 val temporaryImportFileOutputStream = FileOutputStream(temporaryImportFile)
104 // Create a transfer byte array.
105 val transferByteArray = ByteArray(1024)
107 // Create an integer to track the number of bytes read.
110 // Copy the import file to the temporary import file.
111 while (importFileInputStream.read(transferByteArray).also { bytesRead = it } > 0) {
112 temporaryImportFileOutputStream.write(transferByteArray, 0, bytesRead)
115 // Flush the temporary import file output stream.
116 temporaryImportFileOutputStream.flush()
118 // Close the file streams.
119 importFileInputStream.close()
120 temporaryImportFileOutputStream.close()
123 // Get a handle for the shared preference.
124 val sharedPreferences = PreferenceManager.getDefaultSharedPreferences(context)
126 // Open the import database. Once the minimum API >= 27 the file can be opened directly without using the string.
127 val importDatabase = SQLiteDatabase.openDatabase(temporaryImportFile.toString(), null, SQLiteDatabase.OPEN_READWRITE)
129 // Get the database version.
130 val importDatabaseVersion = importDatabase.version
132 // Upgrade from schema version 1, first used in Privacy Browser 2.13, to schema version 2, first used in Privacy Browser 2.14.
133 // Previously this upgrade added `download_with_external_app` to the Preferences table. But that is now removed in schema version 10.
135 // Upgrade from schema version 2, first used in Privacy Browser 2.14, to schema version 3, first used in Privacy Browser 2.15.
136 if (importDatabaseVersion < 3) {
137 // `default_font_size` was renamed `font_size`.
138 // Once the SQLite version is >= 3.25.0 (Android API >= 30) `ALTER TABLE RENAME COLUMN` can be used. <https://www.sqlite.org/lang_altertable.html> <https://www.sqlite.org/changes.html>
139 // <https://developer.android.com/reference/android/database/sqlite/package-summary>
140 // In the meantime, a new column must be created with the new name. There is no need to delete the old column on the temporary import database.
142 // Create the new font size column.
143 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $FONT_SIZE TEXT")
145 // Populate the preferences table with the current font size value.
146 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $FONT_SIZE = default_font_size")
149 // Upgrade from schema version 3, first used in Privacy Browser 2.15, to schema version 4, first used in Privacy Browser 2.16.
150 if (importDatabaseVersion < 4) {
151 // Add the Pinned IP Addresses columns to the domains table.
152 importDatabase.execSQL("ALTER TABLE ${DomainsDatabaseHelper.DOMAINS_TABLE} ADD COLUMN ${DomainsDatabaseHelper.PINNED_IP_ADDRESSES} BOOLEAN")
153 importDatabase.execSQL("ALTER TABLE ${DomainsDatabaseHelper.DOMAINS_TABLE} ADD COLUMN ${DomainsDatabaseHelper.IP_ADDRESSES} TEXT")
156 // Upgrade from schema version 4, first used in Privacy Browser 2.16, to schema version 5, first used in Privacy Browser 2.17.
157 if (importDatabaseVersion < 5) {
158 // Add the hide and scroll app bar columns to the preferences table.
159 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $HIDE_APP_BAR BOOLEAN")
160 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $SCROLL_APP_BAR BOOLEAN")
162 // Get the current hide and scroll app bar settings.
163 val hideAppBar = sharedPreferences.getBoolean(HIDE_APP_BAR, true)
164 val scrollAppBar = sharedPreferences.getBoolean(SCROLL_APP_BAR, true)
166 // Populate the preferences table with the current app bar values.
167 // This can switch to using the variables directly once the minimum API >= 30. <https://www.sqlite.org/datatype3.html#boolean_datatype>
168 // <https://developer.android.com/reference/android/database/sqlite/package-summary>
170 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $HIDE_APP_BAR = 1")
172 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $HIDE_APP_BAR = 0")
175 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $SCROLL_APP_BAR = 1")
177 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $SCROLL_APP_BAR = 0")
180 // Upgrade from schema version 5, first used in Privacy Browser 2.17, to schema version 6, first used in Privacy Browser 3.0.
181 if (importDatabaseVersion < 6) {
182 // Add the open intents in new tab column to the preferences table.
183 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $OPEN_INTENTS_IN_NEW_TAB BOOLEAN")
185 // Get the current open intents in new tab preference.
186 val openIntentsInNewTab = sharedPreferences.getBoolean(OPEN_INTENTS_IN_NEW_TAB, true)
188 // Populate the preferences table with the current open intents value.
189 // This can switch to using the variables directly once the API >= 30. <https://www.sqlite.org/datatype3.html#boolean_datatype>
190 // <https://developer.android.com/reference/android/database/sqlite/package-summary>
191 if (openIntentsInNewTab)
192 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $OPEN_INTENTS_IN_NEW_TAB = 1")
194 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $OPEN_INTENTS_IN_NEW_TAB = 0")
197 // Upgrade from schema version 6, first used in Privacy Browser 3.0, to schema version 7, first used in Privacy Browser 3.1.
198 if (importDatabaseVersion < 7) {
199 // Previously this upgrade added `facebook_click_ids` to the Preferences table. But that is now removed in schema version 15.
201 // Add the wide viewport column to the domains table.
202 importDatabase.execSQL("ALTER TABLE ${DomainsDatabaseHelper.DOMAINS_TABLE} ADD COLUMN ${DomainsDatabaseHelper.WIDE_VIEWPORT} INTEGER")
204 // Add the Google Analytics, Twitter AMP redirects, and wide viewport columns to the preferences table.
205 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN google_analytics BOOLEAN")
206 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN twitter_amp_redirects BOOLEAN")
207 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $WIDE_VIEWPORT BOOLEAN")
209 // Get the current preference values.
210 val trackingQueries = sharedPreferences.getBoolean(TRACKING_QUERIES, true)
211 val ampRedirects = sharedPreferences.getBoolean(AMP_REDIRECTS, true)
212 val wideViewport = sharedPreferences.getBoolean(WIDE_VIEWPORT, true)
214 // Populate the preferences with the current Tracking Queries value. Google Analytics was renamed Tracking Queries in schema version 15.
215 // This can switch to using the variables directly once the API >= 30. <https://www.sqlite.org/datatype3.html#boolean_datatype>
216 // <https://developer.android.com/reference/android/database/sqlite/package-summary>
218 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET google_analytics = 1")
220 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET google_analytics = 0")
222 // Populate the preferences table with the current AMP Redirects value. Twitter AMP Redirects was renamed AMP Redirects in schema version 15.
224 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET twitter_amp_redirects = 1")
226 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET twitter_amp_redirects = 0")
228 // Populate the preferences table with the current wide viewport value.
230 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $WIDE_VIEWPORT = 1")
232 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $WIDE_VIEWPORT = 0")
235 // Upgrade from schema version 7, first used in Privacy Browser 3.1, to schema version 8, first used in Privacy Browser 3.2.
236 if (importDatabaseVersion < 8) {
237 // Add the UltraList column to the tables.
238 importDatabase.execSQL("ALTER TABLE ${DomainsDatabaseHelper.DOMAINS_TABLE} ADD COLUMN ${DomainsDatabaseHelper.ULTRALIST} BOOLEAN")
239 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $ULTRALIST BOOLEAN")
241 // Get the current preference values.
242 val ultraList = sharedPreferences.getBoolean(ULTRALIST, true)
244 // Populate the tables with the current UltraList value.
245 // This can switch to using the variables directly once the API >= 30. <https://www.sqlite.org/datatype3.html#boolean_datatype>
246 // <https://developer.android.com/reference/android/database/sqlite/package-summary>
248 importDatabase.execSQL("UPDATE ${DomainsDatabaseHelper.DOMAINS_TABLE} SET ${DomainsDatabaseHelper.ULTRALIST} = 1")
249 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $ULTRALIST = 1")
251 importDatabase.execSQL("UPDATE ${DomainsDatabaseHelper.DOMAINS_TABLE} SET ${DomainsDatabaseHelper.ULTRALIST} = 0")
252 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $ULTRALIST = 0")
256 // Upgrade from schema version 8, first used in Privacy Browser 3.2, to schema version 9, first used in Privacy Browser 3.3.
257 if (importDatabaseVersion < 9) {
258 // Add the new proxy columns to the preferences table.
259 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $PROXY TEXT")
260 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $PROXY_CUSTOM_URL TEXT")
262 // Get the current proxy values.
263 val proxy = sharedPreferences.getString(PROXY, context.getString(R.string.proxy_default_value))
264 var proxyCustomUrl = sharedPreferences.getString(PROXY_CUSTOM_URL, context.getString(R.string.proxy_custom_url_default_value))
266 // SQL escape the proxy custom URL string.
267 proxyCustomUrl = DatabaseUtils.sqlEscapeString(proxyCustomUrl)
269 // Populate the preferences table with the current proxy values. The proxy custom URL does not need to be surrounded by `'` because it was SLQ escaped above.
270 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $PROXY = '$proxy'")
271 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $PROXY_CUSTOM_URL = $proxyCustomUrl")
274 // Upgrade from schema version 9, first used in Privacy Browser 3.3, to schema version 10, first used in Privacy Browser 3.4.
275 // Previously this upgrade added `download_location` and `download_custom_location` to the Preferences table. But they were removed in schema version 13.
277 // Upgrade from schema version 10, first used in Privacy Browser 3.4, to schema version 11, first used in Privacy Browser 3.5.
278 if (importDatabaseVersion < 11) {
279 // Add the app theme column to the preferences table.
280 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $APP_THEME TEXT")
282 // Get a cursor for the dark theme preference.
283 val darkThemePreferencesCursor = importDatabase.rawQuery("SELECT dark_theme FROM $PREFERENCES_TABLE", null)
285 // Move to the first entry.
286 darkThemePreferencesCursor.moveToFirst()
288 // Get the old dark theme value, which is in column 0.
289 val darkTheme = darkThemePreferencesCursor.getInt(0)
291 // Close the dark theme preference cursor.
292 darkThemePreferencesCursor.close()
294 // Get the system default string.
295 val systemDefault = context.getString(R.string.app_theme_default_value)
297 // Get the theme entry values string array.
298 val appThemeEntryValuesStringArray: Array<String> = context.resources.getStringArray(R.array.app_theme_entry_values)
300 // Get the dark string.
301 val dark = appThemeEntryValuesStringArray[2]
303 // Populate the app theme according to the old dark theme preference.
304 if (darkTheme == 0) { // A light theme was selected.
305 // Set the app theme to be the system default.
306 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $APP_THEME = '$systemDefault'")
307 } else { // A dark theme was selected.
308 // Set the app theme to be dark.
309 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $APP_THEME = '$dark'")
312 // Add the WebView theme to the domains table. This defaults to 0, which is `System default`, so a separate step isn't needed to populate the database.
313 importDatabase.execSQL("ALTER TABLE ${DomainsDatabaseHelper.DOMAINS_TABLE} ADD COLUMN ${DomainsDatabaseHelper.WEBVIEW_THEME} INTEGER")
315 // Add the WebView theme to the preferences table.
316 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $WEBVIEW_THEME TEXT")
318 // Get the WebView theme default value string.
319 val webViewThemeDefaultValue = context.getString(R.string.webview_theme_default_value)
321 // Set the WebView theme in the preferences table to be the default.
322 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $WEBVIEW_THEME = '$webViewThemeDefaultValue'")
325 // Upgrade from schema version 11, first used in Privacy Browser 3.5, to schema version 12, first used in Privacy Browser 3.6.
326 if (importDatabaseVersion < 12) {
327 // Add the clear logcat column to the preferences table.
328 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $CLEAR_LOGCAT BOOLEAN")
330 // Get the current clear logcat value.
331 val clearLogcat = sharedPreferences.getBoolean(CLEAR_LOGCAT, true)
333 // Populate the preferences table with the current clear logcat value.
334 // This can switch to using the variables directly once the API >= 30. <https://www.sqlite.org/datatype3.html#boolean_datatype>
335 // <https://developer.android.com/reference/android/database/sqlite/package-summary>
337 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $CLEAR_LOGCAT = 1")
339 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $CLEAR_LOGCAT = 0")
342 // Upgrade from schema version 12, first used in Privacy Browser 3.6, to schema version 13, first used in Privacy Browser 3.7.
343 // Do nothing. `download_location` and `download_custom_location` were removed from the preferences table, but they can be left in the temporary import database without issue.
345 // Upgrade from schema version 13, first used in Privacy Browser 3.7, to schema version 14, first used in Privacy Browser 3.8.
346 if (importDatabaseVersion < 14) {
347 // `enabledthirdpartycookies` was removed from the domains table. `do_not_track` and `third_party_cookies` were removed from the preferences table.
348 // There is no need to delete the columns as they will simply be ignored by the import.
350 // `enablefirstpartycookies` was renamed `cookies`.
351 // Once the SQLite version is >= 3.25.0 (Android API >= 30) `ALTER TABLE RENAME COLUMN` can be used. <https://www.sqlite.org/lang_altertable.html> <https://www.sqlite.org/changes.html>
352 // <https://developer.android.com/reference/android/database/sqlite/package-summary>
353 // In the meantime, a new column must be created with the new name. There is no need to delete the old column on the temporary import database.
355 // Create the new cookies columns.
356 importDatabase.execSQL("ALTER TABLE ${DomainsDatabaseHelper.DOMAINS_TABLE} ADD COLUMN ${DomainsDatabaseHelper.COOKIES} BOOLEAN")
357 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $COOKIES BOOLEAN")
359 // Copy the data from the old cookies columns to the new ones.
360 importDatabase.execSQL("UPDATE ${DomainsDatabaseHelper.DOMAINS_TABLE} SET ${DomainsDatabaseHelper.COOKIES} = enablefirstpartycookies")
361 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $COOKIES = first_party_cookies")
363 // Create the new download with external app and bottom app bar columns.
364 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $DOWNLOAD_WITH_EXTERNAL_APP BOOLEAN")
365 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $BOTTOM_APP_BAR BOOLEAN")
367 // Get the current values for the new columns.
368 val downloadWithExternalApp = sharedPreferences.getBoolean(DOWNLOAD_WITH_EXTERNAL_APP, false)
369 val bottomAppBar = sharedPreferences.getBoolean(BOTTOM_APP_BAR, false)
371 // Populate the preferences table with the current download with external app value.
372 // This can switch to using the variables directly once the API >= 30. <https://www.sqlite.org/datatype3.html#boolean_datatype>
373 // <https://developer.android.com/reference/android/database/sqlite/package-summary>
374 if (downloadWithExternalApp)
375 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $DOWNLOAD_WITH_EXTERNAL_APP = 1")
377 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $DOWNLOAD_WITH_EXTERNAL_APP = 0")
379 // Populate the preferences table with the current bottom app bar value.
381 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $BOTTOM_APP_BAR = 1")
383 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $BOTTOM_APP_BAR = 0")
386 // Upgrade from schema version 14, first used in Privacy Browser 3.8, to schema version 15, first used in Privacy Browser 3.11.
387 if (importDatabaseVersion < 15) {
388 // `facebook_click_ids` was removed from the preferences table.
389 // There is no need to delete the columns as they will simply be ignored by the import.
391 // `x_requested_with_header` was previously added to the preferences and domains tables in this version, but it was removed later in schema version 16.
393 // Create the new URL modification columns.
394 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $TRACKING_QUERIES BOOLEAN")
395 importDatabase.execSQL("ALTER TABLE $PREFERENCES_TABLE ADD COLUMN $AMP_REDIRECTS BOOLEAN")
397 // Copy the data from the old columns to the new ones.
398 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $TRACKING_QUERIES = google_analytics")
399 importDatabase.execSQL("UPDATE $PREFERENCES_TABLE SET $AMP_REDIRECTS = twitter_amp_redirects")
402 // Upgrade from schema version 15, first used in Privacy Browser 3.11, to schema version 16, first used in Privacy Browser 3.12.
403 // This upgrade removed the `x_requested_with_header` from the domains and preferences tables.
404 // There is no need to delete the columns as they will simply be ignored by the import.
406 // Get a cursor for the bookmarks table.
407 val importBookmarksCursor = importDatabase.rawQuery("SELECT * FROM ${BookmarksDatabaseHelper.BOOKMARKS_TABLE}", null)
409 // Delete the current bookmarks database.
410 context.deleteDatabase(BookmarksDatabaseHelper.BOOKMARKS_DATABASE)
412 // Create a new bookmarks database.
413 val bookmarksDatabaseHelper = BookmarksDatabaseHelper(context)
415 // Move to the first record.
416 importBookmarksCursor.moveToFirst()
418 // Copy the data from the import bookmarks cursor into the bookmarks database.
419 for (i in 0 until importBookmarksCursor.count) {
420 // Create a bookmark content values.
421 val bookmarkContentValues = ContentValues()
423 // Add the information for this bookmark to the content values.
424 bookmarkContentValues.put(BookmarksDatabaseHelper.BOOKMARK_NAME, importBookmarksCursor.getString(importBookmarksCursor.getColumnIndexOrThrow(BookmarksDatabaseHelper.BOOKMARK_NAME)))
425 bookmarkContentValues.put(BookmarksDatabaseHelper.BOOKMARK_URL, importBookmarksCursor.getString(importBookmarksCursor.getColumnIndexOrThrow(BookmarksDatabaseHelper.BOOKMARK_URL)))
426 bookmarkContentValues.put(BookmarksDatabaseHelper.PARENT_FOLDER, importBookmarksCursor.getString(importBookmarksCursor.getColumnIndexOrThrow(BookmarksDatabaseHelper.PARENT_FOLDER)))
427 bookmarkContentValues.put(BookmarksDatabaseHelper.DISPLAY_ORDER, importBookmarksCursor.getInt(importBookmarksCursor.getColumnIndexOrThrow(BookmarksDatabaseHelper.DISPLAY_ORDER)))
428 bookmarkContentValues.put(BookmarksDatabaseHelper.IS_FOLDER, importBookmarksCursor.getInt(importBookmarksCursor.getColumnIndexOrThrow(BookmarksDatabaseHelper.IS_FOLDER)))
429 bookmarkContentValues.put(BookmarksDatabaseHelper.FAVORITE_ICON, importBookmarksCursor.getBlob(importBookmarksCursor.getColumnIndexOrThrow(BookmarksDatabaseHelper.FAVORITE_ICON)))
431 // Insert the content values into the bookmarks database.
432 bookmarksDatabaseHelper.createBookmark(bookmarkContentValues)
434 // Advance to the next record.
435 importBookmarksCursor.moveToNext()
438 // Close the bookmarks cursor and database.
439 importBookmarksCursor.close()
440 bookmarksDatabaseHelper.close()
443 // Get a cursor for the domains table.
444 val importDomainsCursor = importDatabase.rawQuery("SELECT * FROM ${DomainsDatabaseHelper.DOMAINS_TABLE} ORDER BY ${DomainsDatabaseHelper.DOMAIN_NAME} ASC", null)
446 // Delete the current domains database.
447 context.deleteDatabase(DomainsDatabaseHelper.DOMAINS_DATABASE)
449 // Create a new domains database.
450 val domainsDatabaseHelper = DomainsDatabaseHelper(context)
452 // Move to the first record.
453 importDomainsCursor.moveToFirst()
455 // Copy the data from the import domains cursor into the domains database.
456 for (i in 0 until importDomainsCursor.count) {
457 // Create a domain content values.
458 val domainContentValues = ContentValues()
460 // Populate the domain content values.
461 domainContentValues.put(DomainsDatabaseHelper.DOMAIN_NAME, importDomainsCursor.getString(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.DOMAIN_NAME)))
462 domainContentValues.put(DomainsDatabaseHelper.ENABLE_JAVASCRIPT, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_JAVASCRIPT)))
463 domainContentValues.put(DomainsDatabaseHelper.COOKIES, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.COOKIES)))
464 domainContentValues.put(DomainsDatabaseHelper.ENABLE_DOM_STORAGE, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_DOM_STORAGE)))
465 domainContentValues.put(DomainsDatabaseHelper.ENABLE_FORM_DATA, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_FORM_DATA)))
466 domainContentValues.put(DomainsDatabaseHelper.ENABLE_EASYLIST, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_EASYLIST)))
467 domainContentValues.put(DomainsDatabaseHelper.ENABLE_EASYPRIVACY, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_EASYPRIVACY)))
468 domainContentValues.put(DomainsDatabaseHelper.ENABLE_FANBOYS_ANNOYANCE_LIST,
469 importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_FANBOYS_ANNOYANCE_LIST)))
470 domainContentValues.put(DomainsDatabaseHelper.ENABLE_FANBOYS_SOCIAL_BLOCKING_LIST,
471 importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_FANBOYS_SOCIAL_BLOCKING_LIST)))
472 domainContentValues.put(DomainsDatabaseHelper.ULTRALIST, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ULTRALIST)))
473 domainContentValues.put(DomainsDatabaseHelper.ENABLE_ULTRAPRIVACY, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_ULTRAPRIVACY)))
474 domainContentValues.put(DomainsDatabaseHelper.BLOCK_ALL_THIRD_PARTY_REQUESTS,
475 importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.BLOCK_ALL_THIRD_PARTY_REQUESTS)))
476 domainContentValues.put(DomainsDatabaseHelper.USER_AGENT, importDomainsCursor.getString(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.USER_AGENT)))
477 domainContentValues.put(DomainsDatabaseHelper.FONT_SIZE, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.FONT_SIZE)))
478 domainContentValues.put(DomainsDatabaseHelper.SWIPE_TO_REFRESH, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SWIPE_TO_REFRESH)))
479 domainContentValues.put(DomainsDatabaseHelper.WEBVIEW_THEME, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.WEBVIEW_THEME)))
480 domainContentValues.put(DomainsDatabaseHelper.WIDE_VIEWPORT, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.WIDE_VIEWPORT)))
481 domainContentValues.put(DomainsDatabaseHelper.DISPLAY_IMAGES, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.DISPLAY_IMAGES)))
482 domainContentValues.put(DomainsDatabaseHelper.PINNED_SSL_CERTIFICATE, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.PINNED_SSL_CERTIFICATE)))
483 domainContentValues.put(DomainsDatabaseHelper.SSL_ISSUED_TO_COMMON_NAME,
484 importDomainsCursor.getString(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_ISSUED_TO_COMMON_NAME)))
485 domainContentValues.put(DomainsDatabaseHelper.SSL_ISSUED_TO_ORGANIZATION,
486 importDomainsCursor.getString(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_ISSUED_TO_ORGANIZATION)))
487 domainContentValues.put(DomainsDatabaseHelper.SSL_ISSUED_TO_ORGANIZATIONAL_UNIT,
488 importDomainsCursor.getString(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_ISSUED_TO_ORGANIZATIONAL_UNIT)))
489 domainContentValues.put(DomainsDatabaseHelper.SSL_ISSUED_BY_COMMON_NAME,
490 importDomainsCursor.getString(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_ISSUED_BY_COMMON_NAME)))
491 domainContentValues.put(DomainsDatabaseHelper.SSL_ISSUED_BY_ORGANIZATION,
492 importDomainsCursor.getString(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_ISSUED_BY_ORGANIZATION)))
493 domainContentValues.put(DomainsDatabaseHelper.SSL_ISSUED_BY_ORGANIZATIONAL_UNIT,
494 importDomainsCursor.getString(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_ISSUED_BY_ORGANIZATIONAL_UNIT)))
495 domainContentValues.put(DomainsDatabaseHelper.SSL_START_DATE, importDomainsCursor.getLong(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_START_DATE)))
496 domainContentValues.put(DomainsDatabaseHelper.SSL_END_DATE, importDomainsCursor.getLong(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_END_DATE)))
497 domainContentValues.put(DomainsDatabaseHelper.PINNED_IP_ADDRESSES, importDomainsCursor.getInt(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.PINNED_IP_ADDRESSES)))
498 domainContentValues.put(DomainsDatabaseHelper.IP_ADDRESSES, importDomainsCursor.getString(importDomainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.IP_ADDRESSES)))
500 // Insert the content values into the domains database.
501 domainsDatabaseHelper.addDomain(domainContentValues)
503 // Advance to the next record.
504 importDomainsCursor.moveToNext()
507 // Close the domains cursor and database.
508 importDomainsCursor.close()
509 domainsDatabaseHelper.close()
512 // Get a cursor for the preferences table.
513 val importPreferencesCursor = importDatabase.rawQuery("SELECT * FROM $PREFERENCES_TABLE", null)
515 // Move to the first record.
516 importPreferencesCursor.moveToFirst()
518 // Import the preference data.
519 sharedPreferences.edit()
520 .putBoolean(JAVASCRIPT, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(JAVASCRIPT)) == 1)
521 .putBoolean(COOKIES, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(COOKIES)) == 1)
522 .putBoolean(DOM_STORAGE, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(DOM_STORAGE)) == 1)
523 .putBoolean(SAVE_FORM_DATA, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(SAVE_FORM_DATA)) == 1) // Save form data can be removed once the minimum API >= 26.
524 .putString(USER_AGENT, importPreferencesCursor.getString(importPreferencesCursor.getColumnIndexOrThrow(USER_AGENT)))
525 .putString(CUSTOM_USER_AGENT, importPreferencesCursor.getString(importPreferencesCursor.getColumnIndexOrThrow(CUSTOM_USER_AGENT)))
526 .putBoolean(INCOGNITO_MODE, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(INCOGNITO_MODE)) == 1)
527 .putBoolean(ALLOW_SCREENSHOTS, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(ALLOW_SCREENSHOTS)) == 1)
528 .putBoolean(EASYLIST, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(EASYLIST)) == 1)
529 .putBoolean(EASYPRIVACY, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(EASYPRIVACY)) == 1)
530 .putBoolean(FANBOYS_ANNOYANCE_LIST, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(FANBOYS_ANNOYANCE_LIST)) == 1)
531 .putBoolean(FANBOYS_SOCIAL_BLOCKING_LIST, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(FANBOYS_SOCIAL_BLOCKING_LIST)) == 1)
532 .putBoolean(ULTRALIST, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(ULTRALIST)) == 1)
533 .putBoolean(ULTRAPRIVACY, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(ULTRAPRIVACY)) == 1)
534 .putBoolean(BLOCK_ALL_THIRD_PARTY_REQUESTS, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(BLOCK_ALL_THIRD_PARTY_REQUESTS)) == 1)
535 .putBoolean(TRACKING_QUERIES, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(TRACKING_QUERIES)) == 1)
536 .putBoolean(AMP_REDIRECTS, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(AMP_REDIRECTS)) == 1)
537 .putString(SEARCH, importPreferencesCursor.getString(importPreferencesCursor.getColumnIndexOrThrow(SEARCH)))
538 .putString(SEARCH_CUSTOM_URL, importPreferencesCursor.getString(importPreferencesCursor.getColumnIndexOrThrow(SEARCH_CUSTOM_URL)))
539 .putString(PROXY, importPreferencesCursor.getString(importPreferencesCursor.getColumnIndexOrThrow(PROXY)))
540 .putString(PROXY_CUSTOM_URL, importPreferencesCursor.getString(importPreferencesCursor.getColumnIndexOrThrow(PROXY_CUSTOM_URL)))
541 .putBoolean(FULL_SCREEN_BROWSING_MODE, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(FULL_SCREEN_BROWSING_MODE)) == 1)
542 .putBoolean(HIDE_APP_BAR, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(HIDE_APP_BAR)) == 1)
543 .putBoolean(CLEAR_EVERYTHING, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(CLEAR_EVERYTHING)) == 1)
544 .putBoolean(CLEAR_COOKIES, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(CLEAR_COOKIES)) == 1)
545 .putBoolean(CLEAR_DOM_STORAGE, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(CLEAR_DOM_STORAGE)) == 1)
546 .putBoolean(CLEAR_FORM_DATA, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(CLEAR_FORM_DATA)) == 1) // Clear form data can be removed once the minimum API >= 26.
547 .putBoolean(CLEAR_LOGCAT, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(CLEAR_LOGCAT)) == 1)
548 .putBoolean(CLEAR_CACHE, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(CLEAR_CACHE)) == 1)
549 .putString(HOMEPAGE, importPreferencesCursor.getString(importPreferencesCursor.getColumnIndexOrThrow(HOMEPAGE)))
550 .putString(FONT_SIZE, importPreferencesCursor.getString(importPreferencesCursor.getColumnIndexOrThrow(FONT_SIZE)))
551 .putBoolean(OPEN_INTENTS_IN_NEW_TAB, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(OPEN_INTENTS_IN_NEW_TAB)) == 1)
552 .putBoolean(SWIPE_TO_REFRESH, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(SWIPE_TO_REFRESH)) == 1)
553 .putBoolean(DOWNLOAD_WITH_EXTERNAL_APP, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(DOWNLOAD_WITH_EXTERNAL_APP)) == 1)
554 .putBoolean(SCROLL_APP_BAR, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(SCROLL_APP_BAR)) == 1)
555 .putBoolean(BOTTOM_APP_BAR, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(BOTTOM_APP_BAR)) == 1)
556 .putBoolean(DISPLAY_ADDITIONAL_APP_BAR_ICONS, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(DISPLAY_ADDITIONAL_APP_BAR_ICONS)) == 1)
557 .putString(APP_THEME, importPreferencesCursor.getString(importPreferencesCursor.getColumnIndexOrThrow(APP_THEME)))
558 .putString(WEBVIEW_THEME, importPreferencesCursor.getString(importPreferencesCursor.getColumnIndexOrThrow(WEBVIEW_THEME)))
559 .putBoolean(WIDE_VIEWPORT, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(WIDE_VIEWPORT)) == 1)
560 .putBoolean(DISPLAY_WEBPAGE_IMAGES, importPreferencesCursor.getInt(importPreferencesCursor.getColumnIndexOrThrow(DISPLAY_WEBPAGE_IMAGES)) == 1)
563 // Close the preferences cursor and database.
564 importPreferencesCursor.close()
565 importDatabase.close()
567 // Delete the temporary import file database, journal, and other related auxiliary files.
568 SQLiteDatabase.deleteDatabase(temporaryImportFile)
570 // Return the import successful string.
572 } catch (exception: Exception) {
573 // Return the import error.
578 fun exportUnencrypted(exportFileOutputStream: OutputStream, context: Context): String {
580 // Create a temporary export file.
581 val temporaryExportFile = File.createTempFile("temporary_export_file", null, context.cacheDir)
583 // Create the temporary export database.
584 val temporaryExportDatabase = SQLiteDatabase.openOrCreateDatabase(temporaryExportFile, null)
586 // Set the temporary export database version number.
587 temporaryExportDatabase.version = SCHEMA_VERSION
590 // Create the temporary export database bookmarks table.
591 temporaryExportDatabase.execSQL(BookmarksDatabaseHelper.CREATE_BOOKMARKS_TABLE)
593 // Open the bookmarks database.
594 val bookmarksDatabaseHelper = BookmarksDatabaseHelper(context)
596 // Get a full bookmarks cursor.
597 val bookmarksCursor = bookmarksDatabaseHelper.allBookmarks
599 // Move to the first record.
600 bookmarksCursor.moveToFirst()
602 // Copy the data from the bookmarks cursor into the export database.
603 for (i in 0 until bookmarksCursor.count) {
604 // Create a bookmark content values.
605 val bookmarkContentValues = ContentValues()
607 // Populate the bookmark content values.
608 bookmarkContentValues.put(BookmarksDatabaseHelper.BOOKMARK_NAME, bookmarksCursor.getString(bookmarksCursor.getColumnIndexOrThrow(BookmarksDatabaseHelper.BOOKMARK_NAME)))
609 bookmarkContentValues.put(BookmarksDatabaseHelper.BOOKMARK_URL, bookmarksCursor.getString(bookmarksCursor.getColumnIndexOrThrow(BookmarksDatabaseHelper.BOOKMARK_URL)))
610 bookmarkContentValues.put(BookmarksDatabaseHelper.PARENT_FOLDER, bookmarksCursor.getString(bookmarksCursor.getColumnIndexOrThrow(BookmarksDatabaseHelper.PARENT_FOLDER)))
611 bookmarkContentValues.put(BookmarksDatabaseHelper.DISPLAY_ORDER, bookmarksCursor.getInt(bookmarksCursor.getColumnIndexOrThrow(BookmarksDatabaseHelper.DISPLAY_ORDER)))
612 bookmarkContentValues.put(BookmarksDatabaseHelper.IS_FOLDER, bookmarksCursor.getInt(bookmarksCursor.getColumnIndexOrThrow(BookmarksDatabaseHelper.IS_FOLDER)))
613 bookmarkContentValues.put(BookmarksDatabaseHelper.FAVORITE_ICON, bookmarksCursor.getBlob(bookmarksCursor.getColumnIndexOrThrow(BookmarksDatabaseHelper.FAVORITE_ICON)))
615 // Insert the content values into the temporary export database.
616 temporaryExportDatabase.insert(BookmarksDatabaseHelper.BOOKMARKS_TABLE, null, bookmarkContentValues)
618 // Advance to the next record.
619 bookmarksCursor.moveToNext()
622 // Close the bookmarks cursor and database.
623 bookmarksCursor.close()
624 bookmarksDatabaseHelper.close()
627 // Create the temporary export database domains table.
628 temporaryExportDatabase.execSQL(DomainsDatabaseHelper.CREATE_DOMAINS_TABLE)
630 // Open the domains database.
631 val domainsDatabaseHelper = DomainsDatabaseHelper(context)
633 // Get a full domains database cursor.
634 val domainsCursor = domainsDatabaseHelper.completeCursorOrderedByDomain
636 // Move to the first record.
637 domainsCursor.moveToFirst()
639 // Copy the data from the domains cursor into the export database.
640 for (i in 0 until domainsCursor.count) {
641 // Create a domain content values.
642 val domainContentValues = ContentValues()
644 // Populate the domain content values.
645 domainContentValues.put(DomainsDatabaseHelper.DOMAIN_NAME, domainsCursor.getString(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.DOMAIN_NAME)))
646 domainContentValues.put(DomainsDatabaseHelper.ENABLE_JAVASCRIPT, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_JAVASCRIPT)))
647 domainContentValues.put(DomainsDatabaseHelper.COOKIES, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.COOKIES)))
648 domainContentValues.put(DomainsDatabaseHelper.ENABLE_DOM_STORAGE, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_DOM_STORAGE)))
649 domainContentValues.put(DomainsDatabaseHelper.ENABLE_FORM_DATA, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_FORM_DATA)))
650 domainContentValues.put(DomainsDatabaseHelper.ENABLE_EASYLIST, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_EASYLIST)))
651 domainContentValues.put(DomainsDatabaseHelper.ENABLE_EASYPRIVACY, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_EASYPRIVACY)))
652 domainContentValues.put(DomainsDatabaseHelper.ENABLE_FANBOYS_ANNOYANCE_LIST, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_FANBOYS_ANNOYANCE_LIST)))
653 domainContentValues.put(DomainsDatabaseHelper.ENABLE_FANBOYS_SOCIAL_BLOCKING_LIST,
654 domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_FANBOYS_SOCIAL_BLOCKING_LIST)))
655 domainContentValues.put(DomainsDatabaseHelper.ULTRALIST, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ULTRALIST)))
656 domainContentValues.put(DomainsDatabaseHelper.ENABLE_ULTRAPRIVACY, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.ENABLE_ULTRAPRIVACY)))
657 domainContentValues.put(DomainsDatabaseHelper.BLOCK_ALL_THIRD_PARTY_REQUESTS, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.BLOCK_ALL_THIRD_PARTY_REQUESTS)))
658 domainContentValues.put(DomainsDatabaseHelper.USER_AGENT, domainsCursor.getString(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.USER_AGENT)))
659 domainContentValues.put(DomainsDatabaseHelper.FONT_SIZE, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.FONT_SIZE)))
660 domainContentValues.put(DomainsDatabaseHelper.SWIPE_TO_REFRESH, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SWIPE_TO_REFRESH)))
661 domainContentValues.put(DomainsDatabaseHelper.WEBVIEW_THEME, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.WEBVIEW_THEME)))
662 domainContentValues.put(DomainsDatabaseHelper.WIDE_VIEWPORT, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.WIDE_VIEWPORT)))
663 domainContentValues.put(DomainsDatabaseHelper.DISPLAY_IMAGES, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.DISPLAY_IMAGES)))
664 domainContentValues.put(DomainsDatabaseHelper.PINNED_SSL_CERTIFICATE, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.PINNED_SSL_CERTIFICATE)))
665 domainContentValues.put(DomainsDatabaseHelper.SSL_ISSUED_TO_COMMON_NAME, domainsCursor.getString(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_ISSUED_TO_COMMON_NAME)))
666 domainContentValues.put(DomainsDatabaseHelper.SSL_ISSUED_TO_ORGANIZATION, domainsCursor.getString(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_ISSUED_TO_ORGANIZATION)))
667 domainContentValues.put(DomainsDatabaseHelper.SSL_ISSUED_TO_ORGANIZATIONAL_UNIT,
668 domainsCursor.getString(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_ISSUED_TO_ORGANIZATIONAL_UNIT)))
669 domainContentValues.put(DomainsDatabaseHelper.SSL_ISSUED_BY_COMMON_NAME, domainsCursor.getString(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_ISSUED_BY_COMMON_NAME)))
670 domainContentValues.put(DomainsDatabaseHelper.SSL_ISSUED_BY_ORGANIZATION, domainsCursor.getString(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_ISSUED_BY_ORGANIZATION)))
671 domainContentValues.put(DomainsDatabaseHelper.SSL_ISSUED_BY_ORGANIZATIONAL_UNIT,
672 domainsCursor.getString(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_ISSUED_BY_ORGANIZATIONAL_UNIT)))
673 domainContentValues.put(DomainsDatabaseHelper.SSL_START_DATE, domainsCursor.getLong(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_START_DATE)))
674 domainContentValues.put(DomainsDatabaseHelper.SSL_END_DATE, domainsCursor.getLong(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.SSL_END_DATE)))
675 domainContentValues.put(DomainsDatabaseHelper.PINNED_IP_ADDRESSES, domainsCursor.getInt(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.PINNED_IP_ADDRESSES)))
676 domainContentValues.put(DomainsDatabaseHelper.IP_ADDRESSES, domainsCursor.getString(domainsCursor.getColumnIndexOrThrow(DomainsDatabaseHelper.IP_ADDRESSES)))
678 // Insert the content values into the temporary export database.
679 temporaryExportDatabase.insert(DomainsDatabaseHelper.DOMAINS_TABLE, null, domainContentValues)
681 // Advance to the next record.
682 domainsCursor.moveToNext()
685 // Close the domains cursor and database.
686 domainsCursor.close()
687 domainsDatabaseHelper.close()
690 // Prepare the preferences table SQL creation string.
691 val createPreferencesTable = "CREATE TABLE $PREFERENCES_TABLE (" +
692 "$ID INTEGER PRIMARY KEY, " +
693 "$JAVASCRIPT BOOLEAN, " +
694 "$COOKIES BOOLEAN, " +
695 "$DOM_STORAGE BOOLEAN, " +
696 "$SAVE_FORM_DATA BOOLEAN, " +
697 "$USER_AGENT TEXT, " +
698 "$CUSTOM_USER_AGENT TEXT, " +
699 "$INCOGNITO_MODE BOOLEAN, " +
700 "$ALLOW_SCREENSHOTS BOOLEAN, " +
701 "$EASYLIST BOOLEAN, " +
702 "$EASYPRIVACY BOOLEAN, " +
703 "$FANBOYS_ANNOYANCE_LIST BOOLEAN, " +
704 "$FANBOYS_SOCIAL_BLOCKING_LIST BOOLEAN, " +
705 "$ULTRALIST BOOLEAN, " +
706 "$ULTRAPRIVACY BOOLEAN, " +
707 "$BLOCK_ALL_THIRD_PARTY_REQUESTS BOOLEAN, " +
708 "$TRACKING_QUERIES BOOLEAN, " +
709 "$AMP_REDIRECTS BOOLEAN, " +
711 "$SEARCH_CUSTOM_URL TEXT, " +
713 "$PROXY_CUSTOM_URL TEXT, " +
714 "$FULL_SCREEN_BROWSING_MODE BOOLEAN, " +
715 "$HIDE_APP_BAR BOOLEAN, " +
716 "$CLEAR_EVERYTHING BOOLEAN, " +
717 "$CLEAR_COOKIES BOOLEAN, " +
718 "$CLEAR_DOM_STORAGE BOOLEAN, " +
719 "$CLEAR_FORM_DATA BOOLEAN, " +
720 "$CLEAR_LOGCAT BOOLEAN, " +
721 "$CLEAR_CACHE BOOLEAN, " +
723 "$FONT_SIZE TEXT, " +
724 "$OPEN_INTENTS_IN_NEW_TAB BOOLEAN, " +
725 "$SWIPE_TO_REFRESH BOOLEAN, " +
726 "$DOWNLOAD_WITH_EXTERNAL_APP BOOLEAN, " +
727 "$SCROLL_APP_BAR BOOLEAN, " +
728 "$BOTTOM_APP_BAR BOOLEAN, " +
729 "$DISPLAY_ADDITIONAL_APP_BAR_ICONS BOOLEAN, " +
730 "$APP_THEME TEXT, " +
731 "$WEBVIEW_THEME TEXT, " +
732 "$WIDE_VIEWPORT BOOLEAN, " +
733 "$DISPLAY_WEBPAGE_IMAGES BOOLEAN)"
735 // Create the temporary export database preferences table.
736 temporaryExportDatabase.execSQL(createPreferencesTable)
738 // Get a handle for the shared preference.
739 val sharedPreferences = PreferenceManager.getDefaultSharedPreferences(context)
741 // Create a preferences content values.
742 val preferencesContentValues = ContentValues()
744 // Populate the preferences content values.
745 preferencesContentValues.put(JAVASCRIPT, sharedPreferences.getBoolean(JAVASCRIPT, false))
746 preferencesContentValues.put(COOKIES, sharedPreferences.getBoolean(COOKIES, false))
747 preferencesContentValues.put(DOM_STORAGE, sharedPreferences.getBoolean(DOM_STORAGE, false))
748 preferencesContentValues.put(SAVE_FORM_DATA, sharedPreferences.getBoolean(SAVE_FORM_DATA, false)) // Save form data can be removed once the minimum API >= 26.
749 preferencesContentValues.put(USER_AGENT, sharedPreferences.getString(USER_AGENT, context.getString(R.string.user_agent_default_value)))
750 preferencesContentValues.put(CUSTOM_USER_AGENT, sharedPreferences.getString(CUSTOM_USER_AGENT, context.getString(R.string.custom_user_agent_default_value)))
751 preferencesContentValues.put(INCOGNITO_MODE, sharedPreferences.getBoolean(INCOGNITO_MODE, false))
752 preferencesContentValues.put(ALLOW_SCREENSHOTS, sharedPreferences.getBoolean(ALLOW_SCREENSHOTS, false))
753 preferencesContentValues.put(EASYLIST, sharedPreferences.getBoolean(EASYLIST, true))
754 preferencesContentValues.put(EASYPRIVACY, sharedPreferences.getBoolean(EASYPRIVACY, true))
755 preferencesContentValues.put(FANBOYS_ANNOYANCE_LIST, sharedPreferences.getBoolean(FANBOYS_ANNOYANCE_LIST, true))
756 preferencesContentValues.put(FANBOYS_SOCIAL_BLOCKING_LIST, sharedPreferences.getBoolean(FANBOYS_SOCIAL_BLOCKING_LIST, true))
757 preferencesContentValues.put(ULTRALIST, sharedPreferences.getBoolean(ULTRALIST, true))
758 preferencesContentValues.put(ULTRAPRIVACY, sharedPreferences.getBoolean(ULTRAPRIVACY, true))
759 preferencesContentValues.put(BLOCK_ALL_THIRD_PARTY_REQUESTS, sharedPreferences.getBoolean(BLOCK_ALL_THIRD_PARTY_REQUESTS, false))
760 preferencesContentValues.put(TRACKING_QUERIES, sharedPreferences.getBoolean(TRACKING_QUERIES, true))
761 preferencesContentValues.put(AMP_REDIRECTS, sharedPreferences.getBoolean(AMP_REDIRECTS, true))
762 preferencesContentValues.put(SEARCH, sharedPreferences.getString(SEARCH, context.getString(R.string.search_default_value)))
763 preferencesContentValues.put(SEARCH_CUSTOM_URL, sharedPreferences.getString(SEARCH_CUSTOM_URL, context.getString(R.string.search_custom_url_default_value)))
764 preferencesContentValues.put(PROXY, sharedPreferences.getString(PROXY, context.getString(R.string.proxy_default_value)))
765 preferencesContentValues.put(PROXY_CUSTOM_URL, sharedPreferences.getString(PROXY_CUSTOM_URL, context.getString(R.string.proxy_custom_url_default_value)))
766 preferencesContentValues.put(FULL_SCREEN_BROWSING_MODE, sharedPreferences.getBoolean(FULL_SCREEN_BROWSING_MODE, false))
767 preferencesContentValues.put(HIDE_APP_BAR, sharedPreferences.getBoolean(HIDE_APP_BAR, true))
768 preferencesContentValues.put(CLEAR_EVERYTHING, sharedPreferences.getBoolean(CLEAR_EVERYTHING, true))
769 preferencesContentValues.put(CLEAR_COOKIES, sharedPreferences.getBoolean(CLEAR_COOKIES, true))
770 preferencesContentValues.put(CLEAR_DOM_STORAGE, sharedPreferences.getBoolean(CLEAR_DOM_STORAGE, true))
771 preferencesContentValues.put(CLEAR_FORM_DATA, sharedPreferences.getBoolean(CLEAR_FORM_DATA, true)) // Clear form data can be removed once the minimum API >= 26.
772 preferencesContentValues.put(CLEAR_LOGCAT, sharedPreferences.getBoolean(CLEAR_LOGCAT, true))
773 preferencesContentValues.put(CLEAR_CACHE, sharedPreferences.getBoolean(CLEAR_CACHE, true))
774 preferencesContentValues.put(HOMEPAGE, sharedPreferences.getString(HOMEPAGE, context.getString(R.string.homepage_default_value)))
775 preferencesContentValues.put(FONT_SIZE, sharedPreferences.getString(FONT_SIZE, context.getString(R.string.font_size_default_value)))
776 preferencesContentValues.put(OPEN_INTENTS_IN_NEW_TAB, sharedPreferences.getBoolean(OPEN_INTENTS_IN_NEW_TAB, true))
777 preferencesContentValues.put(SWIPE_TO_REFRESH, sharedPreferences.getBoolean(SWIPE_TO_REFRESH, true))
778 preferencesContentValues.put(DOWNLOAD_WITH_EXTERNAL_APP, sharedPreferences.getBoolean(DOWNLOAD_WITH_EXTERNAL_APP, false))
779 preferencesContentValues.put(SCROLL_APP_BAR, sharedPreferences.getBoolean(SCROLL_APP_BAR, true))
780 preferencesContentValues.put(BOTTOM_APP_BAR, sharedPreferences.getBoolean(BOTTOM_APP_BAR, false))
781 preferencesContentValues.put(DISPLAY_ADDITIONAL_APP_BAR_ICONS, sharedPreferences.getBoolean(DISPLAY_ADDITIONAL_APP_BAR_ICONS, false))
782 preferencesContentValues.put(APP_THEME, sharedPreferences.getString(APP_THEME, context.getString(R.string.app_theme_default_value)))
783 preferencesContentValues.put(WEBVIEW_THEME, sharedPreferences.getString(WEBVIEW_THEME, context.getString(R.string.webview_theme_default_value)))
784 preferencesContentValues.put(WIDE_VIEWPORT, sharedPreferences.getBoolean(WIDE_VIEWPORT, true))
785 preferencesContentValues.put(DISPLAY_WEBPAGE_IMAGES, sharedPreferences.getBoolean(DISPLAY_WEBPAGE_IMAGES, true))
787 // Insert the preferences content values into the temporary export database.
788 temporaryExportDatabase.insert(PREFERENCES_TABLE, null, preferencesContentValues)
790 // Close the temporary export database.
791 temporaryExportDatabase.close()
794 // The file may be copied directly in Kotlin using `File.copyTo`. <https://kotlinlang.org/api/latest/jvm/stdlib/kotlin.io/java.io.-file/copy-to.html>
795 // It can be copied in Android using `Files.copy` once the minimum API >= 26.
796 // <https://developer.android.com/reference/java/nio/file/Files#copy(java.nio.file.Path,%20java.nio.file.Path,%20java.nio.file.CopyOption...)>
797 // However, the file cannot be acquired from the content URI until the minimum API >= 29. <https://developer.android.com/reference/kotlin/android/content/ContentResolver#openfile>
799 // Create the temporary export file input stream.
800 val temporaryExportFileInputStream = FileInputStream(temporaryExportFile)
802 // Create a byte array.
803 val transferByteArray = ByteArray(1024)
805 // Create an integer to track the number of bytes read.
808 // Copy the temporary export file to the export file output stream.
809 while (temporaryExportFileInputStream.read(transferByteArray).also { bytesRead = it } > 0) {
810 exportFileOutputStream.write(transferByteArray, 0, bytesRead)
813 // Flush the export file output stream.
814 exportFileOutputStream.flush()
816 // Close the file streams.
817 temporaryExportFileInputStream.close()
818 exportFileOutputStream.close()
820 // Delete the temporary export file database, journal, and other related auxiliary files.
821 SQLiteDatabase.deleteDatabase(temporaryExportFile)
823 // Return the export successful string.
825 } catch (exception: Exception) {
826 // Return the export error.