The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 1 | /* |
| 2 | * Copyright (C) 2008 The Android Open Source Project |
| 3 | * |
| 4 | * Licensed under the Apache License, Version 2.0 (the "License"); |
| 5 | * you may not use this file except in compliance with the License. |
| 6 | * You may obtain a copy of the License at |
| 7 | * |
| 8 | * http://www.apache.org/licenses/LICENSE-2.0 |
| 9 | * |
| 10 | * Unless required by applicable law or agreed to in writing, software |
| 11 | * distributed under the License is distributed on an "AS IS" BASIS, |
| 12 | * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| 13 | * See the License for the specific language governing permissions and |
| 14 | * limitations under the License. |
| 15 | */ |
| 16 | |
Daniel Sandler | 325dc23 | 2013-06-05 22:57:57 -0400 | [diff] [blame] | 17 | package com.android.launcher3; |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 18 | |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 19 | import static com.android.launcher3.config.FeatureFlags.MULTI_DB_GRID_MIRATION_ALGO; |
Tracy Zhou | f601872 | 2020-02-06 16:37:16 -0800 | [diff] [blame] | 20 | import static com.android.launcher3.provider.LauncherDbUtils.copyTable; |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 21 | import static com.android.launcher3.provider.LauncherDbUtils.dropTable; |
| 22 | import static com.android.launcher3.provider.LauncherDbUtils.tableExists; |
| 23 | |
Sunny Goyal | 22ca9ec | 2017-05-18 15:03:13 -0700 | [diff] [blame] | 24 | import android.annotation.TargetApi; |
Jon Miranda | 2bc6b93 | 2019-03-07 15:24:46 -0800 | [diff] [blame] | 25 | import android.app.backup.BackupManager; |
The Android Open Source Project | 7376fae | 2009-03-11 12:11:58 -0700 | [diff] [blame] | 26 | import android.appwidget.AppWidgetHost; |
Mike Cleron | b87bd16 | 2009-10-30 16:36:56 -0700 | [diff] [blame] | 27 | import android.appwidget.AppWidgetManager; |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 28 | import android.content.ComponentName; |
Adam Cohen | 228da5a | 2011-07-27 22:23:47 -0700 | [diff] [blame] | 29 | import android.content.ContentProvider; |
Yura | 085c853 | 2014-02-11 15:15:29 +0000 | [diff] [blame] | 30 | import android.content.ContentProviderOperation; |
| 31 | import android.content.ContentProviderResult; |
Adam Cohen | 228da5a | 2011-07-27 22:23:47 -0700 | [diff] [blame] | 32 | import android.content.ContentUris; |
| 33 | import android.content.ContentValues; |
| 34 | import android.content.Context; |
| 35 | import android.content.Intent; |
Yura | 085c853 | 2014-02-11 15:15:29 +0000 | [diff] [blame] | 36 | import android.content.OperationApplicationException; |
Michael Jurka | b85f8a4 | 2012-04-25 15:48:32 -0700 | [diff] [blame] | 37 | import android.content.SharedPreferences; |
Sunny Goyal | c0f03d9 | 2019-03-22 14:13:36 -0700 | [diff] [blame] | 38 | import android.content.pm.ProviderInfo; |
Adam Cohen | 228da5a | 2011-07-27 22:23:47 -0700 | [diff] [blame] | 39 | import android.content.res.Resources; |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 40 | import android.database.Cursor; |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 41 | import android.database.DatabaseUtils; |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 42 | import android.database.SQLException; |
Adam Cohen | 228da5a | 2011-07-27 22:23:47 -0700 | [diff] [blame] | 43 | import android.database.sqlite.SQLiteDatabase; |
Adam Cohen | 228da5a | 2011-07-27 22:23:47 -0700 | [diff] [blame] | 44 | import android.database.sqlite.SQLiteQueryBuilder; |
Sunny Goyal | 0b03778 | 2015-04-02 10:27:03 -0700 | [diff] [blame] | 45 | import android.database.sqlite.SQLiteStatement; |
Adam Cohen | 228da5a | 2011-07-27 22:23:47 -0700 | [diff] [blame] | 46 | import android.net.Uri; |
Sunny Goyal | 7779d62 | 2015-06-11 16:18:39 -0700 | [diff] [blame] | 47 | import android.os.Binder; |
Sunny Goyal | 22ca9ec | 2017-05-18 15:03:13 -0700 | [diff] [blame] | 48 | import android.os.Build; |
Sunny Goyal | b2d46ce | 2015-03-26 11:32:11 -0700 | [diff] [blame] | 49 | import android.os.Bundle; |
Sunny Goyal | 7779d62 | 2015-06-11 16:18:39 -0700 | [diff] [blame] | 50 | import android.os.Process; |
Sunny Goyal | 7c74e4a | 2016-12-15 15:53:17 -0800 | [diff] [blame] | 51 | import android.os.UserHandle; |
Sunny Goyal | 337c81f | 2019-12-10 12:19:13 -0800 | [diff] [blame] | 52 | import android.os.UserManager; |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 53 | import android.provider.BaseColumns; |
Sunny Goyal | c0f03d9 | 2019-03-22 14:13:36 -0700 | [diff] [blame] | 54 | import android.provider.Settings; |
Adam Cohen | 228da5a | 2011-07-27 22:23:47 -0700 | [diff] [blame] | 55 | import android.text.TextUtils; |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 56 | import android.util.Log; |
Sunny Goyal | c0f03d9 | 2019-03-22 14:13:36 -0700 | [diff] [blame] | 57 | import android.util.Xml; |
Adam Cohen | 228da5a | 2011-07-27 22:23:47 -0700 | [diff] [blame] | 58 | |
Sunny Goyal | 0fe505b | 2014-08-06 09:55:36 -0700 | [diff] [blame] | 59 | import com.android.launcher3.AutoInstallsLayout.LayoutParserCallback; |
| 60 | import com.android.launcher3.LauncherSettings.Favorites; |
Sunny Goyal | a9e2f5a | 2016-06-10 12:22:04 -0700 | [diff] [blame] | 61 | import com.android.launcher3.config.FeatureFlags; |
Sunny Goyal | fdbef27 | 2017-02-01 12:52:54 -0800 | [diff] [blame] | 62 | import com.android.launcher3.logging.FileLog; |
Sunny Goyal | 05f3088 | 2017-05-03 12:42:18 -0700 | [diff] [blame] | 63 | import com.android.launcher3.model.DbDowngradeHelper; |
Sunny Goyal | 337c81f | 2019-12-10 12:19:13 -0800 | [diff] [blame] | 64 | import com.android.launcher3.pm.UserCache; |
Sunny Goyal | a9e2f5a | 2016-06-10 12:22:04 -0700 | [diff] [blame] | 65 | import com.android.launcher3.provider.LauncherDbUtils; |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 66 | import com.android.launcher3.provider.LauncherDbUtils.SQLiteTransaction; |
Sunny Goyal | e8f7d5a | 2016-05-24 11:30:14 -0700 | [diff] [blame] | 67 | import com.android.launcher3.provider.RestoreDbTask; |
Sunny Goyal | c0f03d9 | 2019-03-22 14:13:36 -0700 | [diff] [blame] | 68 | import com.android.launcher3.util.IOUtils; |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 69 | import com.android.launcher3.util.IntArray; |
| 70 | import com.android.launcher3.util.IntSet; |
Sunny Goyal | 19026b2 | 2018-03-09 14:37:37 -0800 | [diff] [blame] | 71 | import com.android.launcher3.util.NoLocaleSQLiteHelper; |
Sunny Goyal | 9dbb27c | 2019-07-17 15:12:56 -0700 | [diff] [blame] | 72 | import com.android.launcher3.util.PackageManagerHelper; |
Adam Cohen | 091440a | 2015-03-18 14:16:05 -0700 | [diff] [blame] | 73 | import com.android.launcher3.util.Thunk; |
Yogisha Dixit | 741fae9 | 2021-02-22 14:03:44 +0000 | [diff] [blame] | 74 | import com.android.launcher3.widget.LauncherAppWidgetHost; |
Michael Jurka | 8b805b1 | 2012-04-18 14:23:14 -0700 | [diff] [blame] | 75 | |
Sunny Goyal | c0f03d9 | 2019-03-22 14:13:36 -0700 | [diff] [blame] | 76 | import org.xmlpull.v1.XmlPullParser; |
| 77 | |
Sunny Goyal | 05f3088 | 2017-05-03 12:42:18 -0700 | [diff] [blame] | 78 | import java.io.File; |
Hyunyoung Song | 6aa3729 | 2017-02-06 10:46:24 -0800 | [diff] [blame] | 79 | import java.io.FileDescriptor; |
Sunny Goyal | c0f03d9 | 2019-03-22 14:13:36 -0700 | [diff] [blame] | 80 | import java.io.InputStream; |
Hyunyoung Song | 6aa3729 | 2017-02-06 10:46:24 -0800 | [diff] [blame] | 81 | import java.io.PrintWriter; |
Sunny Goyal | c0f03d9 | 2019-03-22 14:13:36 -0700 | [diff] [blame] | 82 | import java.io.StringReader; |
Mike Cleron | b87bd16 | 2009-10-30 16:36:56 -0700 | [diff] [blame] | 83 | import java.net.URISyntaxException; |
Adam Cohen | 228da5a | 2011-07-27 22:23:47 -0700 | [diff] [blame] | 84 | import java.util.ArrayList; |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 85 | import java.util.Arrays; |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 86 | import java.util.Locale; |
Pinyao Ting | 0807c94 | 2020-04-28 13:58:45 -0700 | [diff] [blame] | 87 | import java.util.concurrent.TimeUnit; |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 88 | import java.util.function.Supplier; |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 89 | |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 90 | public class LauncherProvider extends ContentProvider { |
Sunny Goyal | c74e419 | 2015-09-08 14:01:03 -0700 | [diff] [blame] | 91 | private static final String TAG = "LauncherProvider"; |
Joe Onorato | a30ce8e | 2009-11-11 08:16:49 -0800 | [diff] [blame] | 92 | private static final boolean LOGD = false; |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 93 | |
Sunny Goyal | 05f3088 | 2017-05-03 12:42:18 -0700 | [diff] [blame] | 94 | private static final String DOWNGRADE_SCHEMA_FILE = "downgrade_schema.json"; |
Pinyao Ting | 0807c94 | 2020-04-28 13:58:45 -0700 | [diff] [blame] | 95 | private static final long RESTORE_BACKUP_TABLE_DELAY = TimeUnit.SECONDS.toMillis(30); |
Sunny Goyal | 05f3088 | 2017-05-03 12:42:18 -0700 | [diff] [blame] | 96 | |
Sunny Goyal | 3c7d55b | 2017-04-13 12:01:47 -0700 | [diff] [blame] | 97 | /** |
| 98 | * Represents the schema of the database. Changes in scheme need not be backwards compatible. |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 99 | * When increasing the scheme version, ensure that downgrade_schema.json is updated |
Sunny Goyal | 3c7d55b | 2017-04-13 12:01:47 -0700 | [diff] [blame] | 100 | */ |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 101 | public static final int SCHEMA_VERSION = 28; |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 102 | |
Sunny Goyal | 4276e7b | 2018-11-26 23:44:41 -0800 | [diff] [blame] | 103 | public static final String AUTHORITY = BuildConfig.APPLICATION_ID + ".settings"; |
Pinyao Ting | 96186af | 2020-07-20 11:03:39 -0700 | [diff] [blame] | 104 | public static final String KEY_LAYOUT_PROVIDER_AUTHORITY = "KEY_LAYOUT_PROVIDER_AUTHORITY"; |
Winson Chung | 3d503fb | 2011-07-13 17:25:49 -0700 | [diff] [blame] | 105 | |
Sunny Goyal | e87e6ab | 2014-11-21 22:42:53 -0800 | [diff] [blame] | 106 | static final String EMPTY_DATABASE_CREATED = "EMPTY_DATABASE_CREATED"; |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 107 | |
Sunny Goyal | f076eae | 2016-01-11 12:25:10 -0800 | [diff] [blame] | 108 | protected DatabaseHelper mOpenHelper; |
Pinyao Ting | 96186af | 2020-07-20 11:03:39 -0700 | [diff] [blame] | 109 | protected String mProviderAuthority; |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 110 | |
Pinyao Ting | 0807c94 | 2020-04-28 13:58:45 -0700 | [diff] [blame] | 111 | private long mLastRestoreTimestamp = 0L; |
| 112 | |
Hyunyoung Song | 6aa3729 | 2017-02-06 10:46:24 -0800 | [diff] [blame] | 113 | /** |
| 114 | * $ adb shell dumpsys activity provider com.android.launcher3 |
| 115 | */ |
| 116 | @Override |
| 117 | public void dump(FileDescriptor fd, PrintWriter writer, String[] args) { |
| 118 | LauncherAppState appState = LauncherAppState.getInstanceNoCreate(); |
| 119 | if (appState == null || !appState.getModel().isModelLoaded()) { |
| 120 | return; |
| 121 | } |
| 122 | appState.getModel().dumpState("", fd, writer, args); |
| 123 | } |
| 124 | |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 125 | @Override |
| 126 | public boolean onCreate() { |
Zak Cohen | 3eeb41d | 2020-02-14 14:15:13 -0800 | [diff] [blame] | 127 | if (FeatureFlags.IS_STUDIO_BUILD) { |
Sunny Goyal | e26d100 | 2016-06-20 14:52:14 -0700 | [diff] [blame] | 128 | Log.d(TAG, "Launcher process started"); |
| 129 | } |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 130 | |
Sunny Goyal | fdbef27 | 2017-02-01 12:52:54 -0800 | [diff] [blame] | 131 | // The content provider exists for the entire duration of the launcher main process and |
Sunny Goyal | 66f2b35 | 2018-02-09 10:57:12 -0800 | [diff] [blame] | 132 | // is the first component to get created. |
| 133 | MainProcessInitializer.initialize(getContext().getApplicationContext()); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 134 | return true; |
| 135 | } |
| 136 | |
| 137 | @Override |
| 138 | public String getType(Uri uri) { |
| 139 | SqlArguments args = new SqlArguments(uri, null, null); |
| 140 | if (TextUtils.isEmpty(args.where)) { |
| 141 | return "vnd.android.cursor.dir/" + args.table; |
| 142 | } else { |
| 143 | return "vnd.android.cursor.item/" + args.table; |
| 144 | } |
| 145 | } |
| 146 | |
Sunny Goyal | f076eae | 2016-01-11 12:25:10 -0800 | [diff] [blame] | 147 | /** |
| 148 | * Overridden in tests |
| 149 | */ |
| 150 | protected synchronized void createDbIfNotExists() { |
Sunny Goyal | d3849d1 | 2015-10-29 10:28:32 -0700 | [diff] [blame] | 151 | if (mOpenHelper == null) { |
Tracy Zhou | ed5f308 | 2020-04-20 01:13:26 -0700 | [diff] [blame] | 152 | mOpenHelper = DatabaseHelper.createDatabaseHelper( |
| 153 | getContext(), false /* forMigration */); |
Sunny Goyal | e8f7d5a | 2016-05-24 11:30:14 -0700 | [diff] [blame] | 154 | |
| 155 | if (RestoreDbTask.isPending(getContext())) { |
Jon Miranda | c7206ca | 2019-05-13 14:57:50 -0700 | [diff] [blame] | 156 | if (!RestoreDbTask.performRestore(getContext(), mOpenHelper, |
| 157 | new BackupManager(getContext()))) { |
Sunny Goyal | e8f7d5a | 2016-05-24 11:30:14 -0700 | [diff] [blame] | 158 | mOpenHelper.createEmptyDB(mOpenHelper.getWritableDatabase()); |
| 159 | } |
| 160 | // Set is pending to false irrespective of the result, so that it doesn't get |
| 161 | // executed again. |
| 162 | RestoreDbTask.setPending(getContext(), false); |
| 163 | } |
Sunny Goyal | d3849d1 | 2015-10-29 10:28:32 -0700 | [diff] [blame] | 164 | } |
| 165 | } |
| 166 | |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 167 | private synchronized boolean prepForMigration(String dbFile, String targetTableName, |
| 168 | Supplier<DatabaseHelper> src, Supplier<DatabaseHelper> dst) { |
| 169 | if (TextUtils.equals(dbFile, mOpenHelper.getDatabaseName())) { |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 170 | return false; |
| 171 | } |
| 172 | |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 173 | final DatabaseHelper helper = src.get(); |
| 174 | mOpenHelper = dst.get(); |
| 175 | copyTable(helper.getReadableDatabase(), Favorites.TABLE_NAME, |
| 176 | mOpenHelper.getWritableDatabase(), targetTableName, getContext()); |
| 177 | helper.close(); |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 178 | return true; |
| 179 | } |
| 180 | |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 181 | @Override |
| 182 | public Cursor query(Uri uri, String[] projection, String selection, |
| 183 | String[] selectionArgs, String sortOrder) { |
Sunny Goyal | d3849d1 | 2015-10-29 10:28:32 -0700 | [diff] [blame] | 184 | createDbIfNotExists(); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 185 | |
| 186 | SqlArguments args = new SqlArguments(uri, selection, selectionArgs); |
| 187 | SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); |
| 188 | qb.setTables(args.table); |
| 189 | |
Romain Guy | 73b979d | 2009-06-09 12:57:21 -0700 | [diff] [blame] | 190 | SQLiteDatabase db = mOpenHelper.getWritableDatabase(); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 191 | Cursor result = qb.query(db, projection, args.where, args.args, null, null, sortOrder); |
Pinyao Ting | 0960b45 | 2020-10-14 11:17:04 -0700 | [diff] [blame] | 192 | final Bundle extra = new Bundle(); |
| 193 | extra.putString(LauncherSettings.Settings.EXTRA_DB_NAME, mOpenHelper.getDatabaseName()); |
| 194 | result.setExtras(extra); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 195 | result.setNotificationUri(getContext().getContentResolver(), uri); |
| 196 | |
| 197 | return result; |
| 198 | } |
| 199 | |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 200 | @Thunk static int dbInsertAndCheck(DatabaseHelper helper, |
Michael Jurka | a8c760d | 2011-04-28 14:59:33 -0700 | [diff] [blame] | 201 | SQLiteDatabase db, String table, String nullColumnHack, ContentValues values) { |
Dan Sandler | d502404 | 2014-01-09 15:01:33 -0500 | [diff] [blame] | 202 | if (values == null) { |
| 203 | throw new RuntimeException("Error: attempting to insert null values"); |
| 204 | } |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 205 | if (!values.containsKey(LauncherSettings.Favorites._ID)) { |
Michael Jurka | a8c760d | 2011-04-28 14:59:33 -0700 | [diff] [blame] | 206 | throw new RuntimeException("Error: attempting to add item without specifying an id"); |
| 207 | } |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 208 | helper.checkId(values); |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 209 | return (int) db.insert(table, nullColumnHack, values); |
Michael Jurka | a8c760d | 2011-04-28 14:59:33 -0700 | [diff] [blame] | 210 | } |
| 211 | |
Sunny Goyal | d106418 | 2015-08-13 12:08:30 -0700 | [diff] [blame] | 212 | private void reloadLauncherIfExternal() { |
Sunny Goyal | 8c48d8b | 2019-01-25 15:10:18 -0800 | [diff] [blame] | 213 | if (Binder.getCallingPid() != Process.myPid()) { |
Sunny Goyal | d106418 | 2015-08-13 12:08:30 -0700 | [diff] [blame] | 214 | LauncherAppState app = LauncherAppState.getInstanceNoCreate(); |
| 215 | if (app != null) { |
Sunny Goyal | dd96a5e | 2017-02-17 11:22:34 -0800 | [diff] [blame] | 216 | app.getModel().forceReload(); |
Sunny Goyal | d106418 | 2015-08-13 12:08:30 -0700 | [diff] [blame] | 217 | } |
| 218 | } |
| 219 | } |
| 220 | |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 221 | @Override |
| 222 | public Uri insert(Uri uri, ContentValues initialValues) { |
Sunny Goyal | d3849d1 | 2015-10-29 10:28:32 -0700 | [diff] [blame] | 223 | createDbIfNotExists(); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 224 | SqlArguments args = new SqlArguments(uri); |
| 225 | |
Sunny Goyal | d106418 | 2015-08-13 12:08:30 -0700 | [diff] [blame] | 226 | // In very limited cases, we support system|signature permission apps to modify the db. |
| 227 | if (Binder.getCallingPid() != Process.myPid()) { |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 228 | if (!initializeExternalAdd(initialValues)) { |
Adam Cohen | a043fa8 | 2014-07-23 14:49:38 -0700 | [diff] [blame] | 229 | return null; |
| 230 | } |
| 231 | } |
| 232 | |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 233 | SQLiteDatabase db = mOpenHelper.getWritableDatabase(); |
Chris Wren | 1ada10d | 2013-09-13 18:01:38 -0400 | [diff] [blame] | 234 | addModifiedTime(initialValues); |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 235 | final int rowId = dbInsertAndCheck(mOpenHelper, db, args.table, null, initialValues); |
Sunny Goyal | e72f3d5 | 2015-03-02 14:24:21 -0800 | [diff] [blame] | 236 | if (rowId < 0) return null; |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 237 | onAddOrDeleteOp(db); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 238 | |
| 239 | uri = ContentUris.withAppendedId(uri, rowId); |
Sunny Goyal | 8c48d8b | 2019-01-25 15:10:18 -0800 | [diff] [blame] | 240 | reloadLauncherIfExternal(); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 241 | return uri; |
| 242 | } |
| 243 | |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 244 | private boolean initializeExternalAdd(ContentValues values) { |
| 245 | // 1. Ensure that externally added items have a valid item id |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 246 | int id = mOpenHelper.generateNewItemId(); |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 247 | values.put(LauncherSettings.Favorites._ID, id); |
| 248 | |
| 249 | // 2. In the case of an app widget, and if no app widget id is specified, we |
| 250 | // attempt allocate and bind the widget. |
| 251 | Integer itemType = values.getAsInteger(LauncherSettings.Favorites.ITEM_TYPE); |
| 252 | if (itemType != null && |
| 253 | itemType.intValue() == LauncherSettings.Favorites.ITEM_TYPE_APPWIDGET && |
| 254 | !values.containsKey(LauncherSettings.Favorites.APPWIDGET_ID)) { |
| 255 | |
| 256 | final AppWidgetManager appWidgetManager = AppWidgetManager.getInstance(getContext()); |
| 257 | ComponentName cn = ComponentName.unflattenFromString( |
| 258 | values.getAsString(Favorites.APPWIDGET_PROVIDER)); |
| 259 | |
| 260 | if (cn != null) { |
| 261 | try { |
Sunny Goyal | 55fddc8 | 2017-04-06 15:02:52 -0700 | [diff] [blame] | 262 | AppWidgetHost widgetHost = mOpenHelper.newLauncherWidgetHost(); |
| 263 | int appWidgetId = widgetHost.allocateAppWidgetId(); |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 264 | values.put(LauncherSettings.Favorites.APPWIDGET_ID, appWidgetId); |
| 265 | if (!appWidgetManager.bindAppWidgetIdIfAllowed(appWidgetId,cn)) { |
Sunny Goyal | 55fddc8 | 2017-04-06 15:02:52 -0700 | [diff] [blame] | 266 | widgetHost.deleteAppWidgetId(appWidgetId); |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 267 | return false; |
| 268 | } |
| 269 | } catch (RuntimeException e) { |
| 270 | Log.e(TAG, "Failed to initialize external widget", e); |
| 271 | return false; |
| 272 | } |
| 273 | } else { |
| 274 | return false; |
| 275 | } |
| 276 | } |
| 277 | |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 278 | return true; |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 279 | } |
| 280 | |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 281 | @Override |
| 282 | public int bulkInsert(Uri uri, ContentValues[] values) { |
Sunny Goyal | d3849d1 | 2015-10-29 10:28:32 -0700 | [diff] [blame] | 283 | createDbIfNotExists(); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 284 | SqlArguments args = new SqlArguments(uri); |
| 285 | |
| 286 | SQLiteDatabase db = mOpenHelper.getWritableDatabase(); |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 287 | try (SQLiteTransaction t = new SQLiteTransaction(db)) { |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 288 | int numValues = values.length; |
| 289 | for (int i = 0; i < numValues; i++) { |
Chris Wren | 1ada10d | 2013-09-13 18:01:38 -0400 | [diff] [blame] | 290 | addModifiedTime(values[i]); |
Michael Jurka | a8c760d | 2011-04-28 14:59:33 -0700 | [diff] [blame] | 291 | if (dbInsertAndCheck(mOpenHelper, db, args.table, null, values[i]) < 0) { |
| 292 | return 0; |
| 293 | } |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 294 | } |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 295 | onAddOrDeleteOp(db); |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 296 | t.commit(); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 297 | } |
| 298 | |
Sunny Goyal | d106418 | 2015-08-13 12:08:30 -0700 | [diff] [blame] | 299 | reloadLauncherIfExternal(); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 300 | return values.length; |
| 301 | } |
| 302 | |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 303 | @TargetApi(Build.VERSION_CODES.M) |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 304 | @Override |
Yura | 085c853 | 2014-02-11 15:15:29 +0000 | [diff] [blame] | 305 | public ContentProviderResult[] applyBatch(ArrayList<ContentProviderOperation> operations) |
| 306 | throws OperationApplicationException { |
Sunny Goyal | d3849d1 | 2015-10-29 10:28:32 -0700 | [diff] [blame] | 307 | createDbIfNotExists(); |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 308 | try (SQLiteTransaction t = new SQLiteTransaction(mOpenHelper.getWritableDatabase())) { |
Sunny Goyal | 8c48d8b | 2019-01-25 15:10:18 -0800 | [diff] [blame] | 309 | boolean isAddOrDelete = false; |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 310 | |
| 311 | final int numOperations = operations.size(); |
| 312 | final ContentProviderResult[] results = new ContentProviderResult[numOperations]; |
| 313 | for (int i = 0; i < numOperations; i++) { |
| 314 | ContentProviderOperation op = operations.get(i); |
| 315 | results[i] = op.apply(this, results, i); |
| 316 | |
| 317 | isAddOrDelete |= (op.isInsert() || op.isDelete()) && |
| 318 | results[i].count != null && results[i].count > 0; |
| 319 | } |
| 320 | if (isAddOrDelete) { |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 321 | onAddOrDeleteOp(t.getDb()); |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 322 | } |
| 323 | |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 324 | t.commit(); |
Sunny Goyal | d106418 | 2015-08-13 12:08:30 -0700 | [diff] [blame] | 325 | reloadLauncherIfExternal(); |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 326 | return results; |
Yura | 085c853 | 2014-02-11 15:15:29 +0000 | [diff] [blame] | 327 | } |
| 328 | } |
| 329 | |
| 330 | @Override |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 331 | public int delete(Uri uri, String selection, String[] selectionArgs) { |
Sunny Goyal | d3849d1 | 2015-10-29 10:28:32 -0700 | [diff] [blame] | 332 | createDbIfNotExists(); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 333 | SqlArguments args = new SqlArguments(uri, selection, selectionArgs); |
| 334 | |
| 335 | SQLiteDatabase db = mOpenHelper.getWritableDatabase(); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 336 | |
Louis Begin | a9c21c6 | 2016-08-15 15:18:41 -0700 | [diff] [blame] | 337 | if (Binder.getCallingPid() != Process.myPid() |
| 338 | && Favorites.TABLE_NAME.equalsIgnoreCase(args.table)) { |
Sunny Goyal | 55fddc8 | 2017-04-06 15:02:52 -0700 | [diff] [blame] | 339 | mOpenHelper.removeGhostWidgets(mOpenHelper.getWritableDatabase()); |
Louis Begin | a9c21c6 | 2016-08-15 15:18:41 -0700 | [diff] [blame] | 340 | } |
| 341 | int count = db.delete(args.table, args.where, args.args); |
| 342 | if (count > 0) { |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 343 | onAddOrDeleteOp(db); |
Louis Begin | a9c21c6 | 2016-08-15 15:18:41 -0700 | [diff] [blame] | 344 | reloadLauncherIfExternal(); |
| 345 | } |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 346 | return count; |
| 347 | } |
| 348 | |
| 349 | @Override |
| 350 | public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) { |
Sunny Goyal | d3849d1 | 2015-10-29 10:28:32 -0700 | [diff] [blame] | 351 | createDbIfNotExists(); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 352 | SqlArguments args = new SqlArguments(uri, selection, selectionArgs); |
| 353 | |
Chris Wren | 1ada10d | 2013-09-13 18:01:38 -0400 | [diff] [blame] | 354 | addModifiedTime(values); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 355 | SQLiteDatabase db = mOpenHelper.getWritableDatabase(); |
| 356 | int count = db.update(args.table, values, args.where, args.args); |
Sunny Goyal | d106418 | 2015-08-13 12:08:30 -0700 | [diff] [blame] | 357 | reloadLauncherIfExternal(); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 358 | return count; |
| 359 | } |
| 360 | |
Sunny Goyal | 7779d62 | 2015-06-11 16:18:39 -0700 | [diff] [blame] | 361 | @Override |
Tony Wickham | 827cef2 | 2016-03-17 15:39:39 -0700 | [diff] [blame] | 362 | public Bundle call(String method, final String arg, final Bundle extras) { |
Sunny Goyal | 7779d62 | 2015-06-11 16:18:39 -0700 | [diff] [blame] | 363 | if (Binder.getCallingUid() != Process.myUid()) { |
| 364 | return null; |
| 365 | } |
Sunny Goyal | d3849d1 | 2015-10-29 10:28:32 -0700 | [diff] [blame] | 366 | createDbIfNotExists(); |
Sunny Goyal | 7779d62 | 2015-06-11 16:18:39 -0700 | [diff] [blame] | 367 | |
| 368 | switch (method) { |
Sunny Goyal | d249748 | 2015-09-22 18:24:19 -0700 | [diff] [blame] | 369 | case LauncherSettings.Settings.METHOD_CLEAR_EMPTY_DB_FLAG: { |
| 370 | clearFlagEmptyDbCreated(); |
| 371 | return null; |
| 372 | } |
Sunny Goyal | a5c8a9e | 2016-07-08 08:32:44 -0700 | [diff] [blame] | 373 | case LauncherSettings.Settings.METHOD_WAS_EMPTY_DB_CREATED : { |
| 374 | Bundle result = new Bundle(); |
| 375 | result.putBoolean(LauncherSettings.Settings.EXTRA_VALUE, |
Pinyao Ting | 96186af | 2020-07-20 11:03:39 -0700 | [diff] [blame] | 376 | Utilities.getPrefs(getContext()).getBoolean( |
| 377 | mOpenHelper.getKey(EMPTY_DATABASE_CREATED), false)); |
Sunny Goyal | a5c8a9e | 2016-07-08 08:32:44 -0700 | [diff] [blame] | 378 | return result; |
| 379 | } |
Sunny Goyal | d249748 | 2015-09-22 18:24:19 -0700 | [diff] [blame] | 380 | case LauncherSettings.Settings.METHOD_DELETE_EMPTY_FOLDERS: { |
| 381 | Bundle result = new Bundle(); |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 382 | result.putIntArray(LauncherSettings.Settings.EXTRA_VALUE, deleteEmptyFolders() |
| 383 | .toArray()); |
Sunny Goyal | d249748 | 2015-09-22 18:24:19 -0700 | [diff] [blame] | 384 | return result; |
| 385 | } |
| 386 | case LauncherSettings.Settings.METHOD_NEW_ITEM_ID: { |
| 387 | Bundle result = new Bundle(); |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 388 | result.putInt(LauncherSettings.Settings.EXTRA_VALUE, |
| 389 | mOpenHelper.generateNewItemId()); |
Sunny Goyal | d249748 | 2015-09-22 18:24:19 -0700 | [diff] [blame] | 390 | return result; |
| 391 | } |
| 392 | case LauncherSettings.Settings.METHOD_NEW_SCREEN_ID: { |
| 393 | Bundle result = new Bundle(); |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 394 | result.putInt(LauncherSettings.Settings.EXTRA_VALUE, |
| 395 | mOpenHelper.generateNewScreenId()); |
Sunny Goyal | d249748 | 2015-09-22 18:24:19 -0700 | [diff] [blame] | 396 | return result; |
| 397 | } |
| 398 | case LauncherSettings.Settings.METHOD_CREATE_EMPTY_DB: { |
Sunny Goyal | e05b08f | 2017-02-23 18:30:22 -0800 | [diff] [blame] | 399 | mOpenHelper.createEmptyDB(mOpenHelper.getWritableDatabase()); |
Sunny Goyal | d249748 | 2015-09-22 18:24:19 -0700 | [diff] [blame] | 400 | return null; |
| 401 | } |
| 402 | case LauncherSettings.Settings.METHOD_LOAD_DEFAULT_FAVORITES: { |
| 403 | loadDefaultFavoritesIfNecessary(); |
| 404 | return null; |
| 405 | } |
Sunny Goyal | 55fddc8 | 2017-04-06 15:02:52 -0700 | [diff] [blame] | 406 | case LauncherSettings.Settings.METHOD_REMOVE_GHOST_WIDGETS: { |
| 407 | mOpenHelper.removeGhostWidgets(mOpenHelper.getWritableDatabase()); |
| 408 | return null; |
| 409 | } |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 410 | case LauncherSettings.Settings.METHOD_NEW_TRANSACTION: { |
| 411 | Bundle result = new Bundle(); |
| 412 | result.putBinder(LauncherSettings.Settings.EXTRA_VALUE, |
| 413 | new SQLiteTransaction(mOpenHelper.getWritableDatabase())); |
| 414 | return result; |
| 415 | } |
| 416 | case LauncherSettings.Settings.METHOD_REFRESH_BACKUP_TABLE: { |
Pinyao Ting | 26c4e23 | 2020-04-15 22:25:06 -0700 | [diff] [blame] | 417 | mOpenHelper.mBackupTableExists = tableExists(mOpenHelper.getReadableDatabase(), |
| 418 | Favorites.BACKUP_TABLE_NAME); |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 419 | return null; |
| 420 | } |
Samuel Fufa | f667a13 | 2020-05-29 14:47:42 -0700 | [diff] [blame] | 421 | case LauncherSettings.Settings.METHOD_REFRESH_HOTSEAT_RESTORE_TABLE: { |
| 422 | mOpenHelper.mHotseatRestoreTableExists = tableExists( |
| 423 | mOpenHelper.getReadableDatabase(), Favorites.HYBRID_HOTSEAT_BACKUP_TABLE); |
| 424 | return null; |
| 425 | } |
Pinyao Ting | ba9c557 | 2019-09-24 14:25:46 -0700 | [diff] [blame] | 426 | case LauncherSettings.Settings.METHOD_RESTORE_BACKUP_TABLE: { |
Pinyao Ting | 0807c94 | 2020-04-28 13:58:45 -0700 | [diff] [blame] | 427 | final long ts = System.currentTimeMillis(); |
| 428 | if (ts - mLastRestoreTimestamp > RESTORE_BACKUP_TABLE_DELAY) { |
| 429 | mLastRestoreTimestamp = ts; |
| 430 | RestoreDbTask.restoreIfPossible( |
| 431 | getContext(), mOpenHelper, new BackupManager(getContext())); |
| 432 | } |
Pinyao Ting | ba9c557 | 2019-09-24 14:25:46 -0700 | [diff] [blame] | 433 | return null; |
| 434 | } |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 435 | case LauncherSettings.Settings.METHOD_UPDATE_CURRENT_OPEN_HELPER: { |
| 436 | if (MULTI_DB_GRID_MIRATION_ALGO.get()) { |
| 437 | Bundle result = new Bundle(); |
| 438 | result.putBoolean(LauncherSettings.Settings.EXTRA_VALUE, |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 439 | prepForMigration( |
| 440 | InvariantDeviceProfile.INSTANCE.get(getContext()).dbFile, |
| 441 | Favorites.TMP_TABLE, |
| 442 | () -> mOpenHelper, |
Tracy Zhou | ed5f308 | 2020-04-20 01:13:26 -0700 | [diff] [blame] | 443 | () -> DatabaseHelper.createDatabaseHelper( |
| 444 | getContext(), true /* forMigration */))); |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 445 | return result; |
| 446 | } |
Pinyao Ting | 96186af | 2020-07-20 11:03:39 -0700 | [diff] [blame] | 447 | return null; |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 448 | } |
| 449 | case LauncherSettings.Settings.METHOD_PREP_FOR_PREVIEW: { |
| 450 | if (MULTI_DB_GRID_MIRATION_ALGO.get()) { |
| 451 | Bundle result = new Bundle(); |
| 452 | result.putBoolean(LauncherSettings.Settings.EXTRA_VALUE, |
| 453 | prepForMigration( |
| 454 | arg /* dbFile */, |
| 455 | Favorites.PREVIEW_TABLE_NAME, |
Tracy Zhou | ed5f308 | 2020-04-20 01:13:26 -0700 | [diff] [blame] | 456 | () -> DatabaseHelper.createDatabaseHelper( |
| 457 | getContext(), arg, true /* forMigration */), |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 458 | () -> mOpenHelper)); |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 459 | return result; |
| 460 | } |
Pinyao Ting | 96186af | 2020-07-20 11:03:39 -0700 | [diff] [blame] | 461 | return null; |
| 462 | } |
| 463 | case LauncherSettings.Settings.METHOD_SWITCH_DATABASE: { |
| 464 | if (TextUtils.equals(arg, mOpenHelper.getDatabaseName())) return null; |
| 465 | final DatabaseHelper helper = mOpenHelper; |
| 466 | if (extras == null || !extras.containsKey(KEY_LAYOUT_PROVIDER_AUTHORITY)) { |
| 467 | mProviderAuthority = null; |
| 468 | } else { |
| 469 | mProviderAuthority = extras.getString(KEY_LAYOUT_PROVIDER_AUTHORITY); |
| 470 | } |
| 471 | mOpenHelper = DatabaseHelper.createDatabaseHelper( |
| 472 | getContext(), arg, false /* forMigration */); |
| 473 | helper.close(); |
| 474 | LauncherAppState app = LauncherAppState.getInstanceNoCreate(); |
| 475 | if (app == null) return null; |
| 476 | app.getModel().forceReload(); |
| 477 | return null; |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 478 | } |
Sunny Goyal | 7779d62 | 2015-06-11 16:18:39 -0700 | [diff] [blame] | 479 | } |
| 480 | return null; |
| 481 | } |
| 482 | |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 483 | private void onAddOrDeleteOp(SQLiteDatabase db) { |
Pinyao Ting | 26c4e23 | 2020-04-15 22:25:06 -0700 | [diff] [blame] | 484 | mOpenHelper.onAddOrDeleteOp(db); |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 485 | } |
| 486 | |
Sunny Goyal | b1622cc | 2015-06-10 16:00:42 -0700 | [diff] [blame] | 487 | /** |
| 488 | * Deletes any empty folder from the DB. |
| 489 | * @return Ids of deleted folders. |
| 490 | */ |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 491 | private IntArray deleteEmptyFolders() { |
Sunny Goyal | b1622cc | 2015-06-10 16:00:42 -0700 | [diff] [blame] | 492 | SQLiteDatabase db = mOpenHelper.getWritableDatabase(); |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 493 | try (SQLiteTransaction t = new SQLiteTransaction(db)) { |
Sunny Goyal | b1622cc | 2015-06-10 16:00:42 -0700 | [diff] [blame] | 494 | // Select folders whose id do not match any container value. |
| 495 | String selection = LauncherSettings.Favorites.ITEM_TYPE + " = " |
| 496 | + LauncherSettings.Favorites.ITEM_TYPE_FOLDER + " AND " |
| 497 | + LauncherSettings.Favorites._ID + " NOT IN (SELECT " + |
| 498 | LauncherSettings.Favorites.CONTAINER + " FROM " |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 499 | + Favorites.TABLE_NAME + ")"; |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 500 | |
| 501 | IntArray folderIds = LauncherDbUtils.queryIntArray(db, Favorites.TABLE_NAME, |
| 502 | Favorites._ID, selection, null, null); |
Sunny Goyal | d249748 | 2015-09-22 18:24:19 -0700 | [diff] [blame] | 503 | if (!folderIds.isEmpty()) { |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 504 | db.delete(Favorites.TABLE_NAME, Utilities.createDbSelectionQuery( |
Sunny Goyal | b1622cc | 2015-06-10 16:00:42 -0700 | [diff] [blame] | 505 | LauncherSettings.Favorites._ID, folderIds), null); |
| 506 | } |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 507 | t.commit(); |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 508 | return folderIds; |
Sunny Goyal | b1622cc | 2015-06-10 16:00:42 -0700 | [diff] [blame] | 509 | } catch (SQLException ex) { |
| 510 | Log.e(TAG, ex.getMessage(), ex); |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 511 | return new IntArray(); |
Sunny Goyal | b1622cc | 2015-06-10 16:00:42 -0700 | [diff] [blame] | 512 | } |
Sunny Goyal | b1622cc | 2015-06-10 16:00:42 -0700 | [diff] [blame] | 513 | } |
| 514 | |
Adam Cohen | 091440a | 2015-03-18 14:16:05 -0700 | [diff] [blame] | 515 | @Thunk static void addModifiedTime(ContentValues values) { |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 516 | values.put(LauncherSettings.Favorites.MODIFIED, System.currentTimeMillis()); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 517 | } |
| 518 | |
Sunny Goyal | d249748 | 2015-09-22 18:24:19 -0700 | [diff] [blame] | 519 | private void clearFlagEmptyDbCreated() { |
Pinyao Ting | 96186af | 2020-07-20 11:03:39 -0700 | [diff] [blame] | 520 | Utilities.getPrefs(getContext()).edit() |
| 521 | .remove(mOpenHelper.getKey(EMPTY_DATABASE_CREATED)).commit(); |
Sunny Goyal | 33d4438 | 2014-10-16 09:24:19 -0700 | [diff] [blame] | 522 | } |
| 523 | |
Sunny Goyal | 42de82f | 2014-09-26 22:09:29 -0700 | [diff] [blame] | 524 | /** |
Sunny Goyal | 0fe505b | 2014-08-06 09:55:36 -0700 | [diff] [blame] | 525 | * Loads the default workspace based on the following priority scheme: |
Sunny Goyal | b2d46ce | 2015-03-26 11:32:11 -0700 | [diff] [blame] | 526 | * 1) From the app restrictions |
| 527 | * 2) From a package provided by play store |
| 528 | * 3) From a partner configuration APK, already in the system image |
| 529 | * 4) The default configuration for the particular device |
Brian Muramatsu | 5524b49 | 2012-10-02 16:55:54 -0700 | [diff] [blame] | 530 | */ |
Sunny Goyal | d249748 | 2015-09-22 18:24:19 -0700 | [diff] [blame] | 531 | synchronized private void loadDefaultFavoritesIfNecessary() { |
Sunny Goyal | f725824 | 2015-10-19 16:59:07 -0700 | [diff] [blame] | 532 | SharedPreferences sp = Utilities.getPrefs(getContext()); |
Adam Cohen | e25af79 | 2013-06-06 23:08:25 -0700 | [diff] [blame] | 533 | |
Pinyao Ting | 96186af | 2020-07-20 11:03:39 -0700 | [diff] [blame] | 534 | if (sp.getBoolean(mOpenHelper.getKey(EMPTY_DATABASE_CREATED), false)) { |
Chris Wren | 5dee7af | 2013-12-20 17:22:11 -0500 | [diff] [blame] | 535 | Log.d(TAG, "loading default workspace"); |
Michael Jurka | 45355c4 | 2012-10-08 13:21:35 +0200 | [diff] [blame] | 536 | |
Sunny Goyal | 55fddc8 | 2017-04-06 15:02:52 -0700 | [diff] [blame] | 537 | AppWidgetHost widgetHost = mOpenHelper.newLauncherWidgetHost(); |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 538 | AutoInstallsLayout loader = createWorkspaceLoaderFromAppRestriction(widgetHost); |
Sunny Goyal | b2d46ce | 2015-03-26 11:32:11 -0700 | [diff] [blame] | 539 | if (loader == null) { |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 540 | loader = AutoInstallsLayout.get(getContext(),widgetHost, mOpenHelper); |
Sunny Goyal | b2d46ce | 2015-03-26 11:32:11 -0700 | [diff] [blame] | 541 | } |
Sunny Goyal | 0fe505b | 2014-08-06 09:55:36 -0700 | [diff] [blame] | 542 | if (loader == null) { |
Adam Cohen | 9b8f51f | 2014-05-30 15:34:09 -0700 | [diff] [blame] | 543 | final Partner partner = Partner.get(getContext().getPackageManager()); |
| 544 | if (partner != null && partner.hasDefaultLayout()) { |
| 545 | final Resources partnerRes = partner.getResources(); |
Adam Cohen | 4ae96ce | 2014-08-29 15:05:48 -0700 | [diff] [blame] | 546 | int workspaceResId = partnerRes.getIdentifier(Partner.RES_DEFAULT_LAYOUT, |
Adam Cohen | 9b8f51f | 2014-05-30 15:34:09 -0700 | [diff] [blame] | 547 | "xml", partner.getPackageName()); |
Sunny Goyal | 0fe505b | 2014-08-06 09:55:36 -0700 | [diff] [blame] | 548 | if (workspaceResId != 0) { |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 549 | loader = new DefaultLayoutParser(getContext(), widgetHost, |
Sunny Goyal | 3a5a9d1 | 2014-10-01 15:33:41 -0700 | [diff] [blame] | 550 | mOpenHelper, partnerRes, workspaceResId); |
Sunny Goyal | 0fe505b | 2014-08-06 09:55:36 -0700 | [diff] [blame] | 551 | } |
Adam Cohen | 9b8f51f | 2014-05-30 15:34:09 -0700 | [diff] [blame] | 552 | } |
| 553 | } |
Sunny Goyal | 0fe505b | 2014-08-06 09:55:36 -0700 | [diff] [blame] | 554 | |
Sunny Goyal | 9d21968 | 2014-10-23 14:21:02 -0700 | [diff] [blame] | 555 | final boolean usingExternallyProvidedLayout = loader != null; |
Sunny Goyal | 0fe505b | 2014-08-06 09:55:36 -0700 | [diff] [blame] | 556 | if (loader == null) { |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 557 | loader = getDefaultLayoutParser(widgetHost); |
Brian Muramatsu | 5524b49 | 2012-10-02 16:55:54 -0700 | [diff] [blame] | 558 | } |
Sunny Goyal | c6c8fef | 2015-03-04 09:51:18 -0800 | [diff] [blame] | 559 | |
| 560 | // There might be some partially restored DB items, due to buggy restore logic in |
| 561 | // previous versions of launcher. |
Sunny Goyal | e05b08f | 2017-02-23 18:30:22 -0800 | [diff] [blame] | 562 | mOpenHelper.createEmptyDB(mOpenHelper.getWritableDatabase()); |
Michael Jurka | b85f8a4 | 2012-04-25 15:48:32 -0700 | [diff] [blame] | 563 | // Populate favorites table with initial favorites |
Sunny Goyal | 9d21968 | 2014-10-23 14:21:02 -0700 | [diff] [blame] | 564 | if ((mOpenHelper.loadFavorites(mOpenHelper.getWritableDatabase(), loader) <= 0) |
| 565 | && usingExternallyProvidedLayout) { |
| 566 | // Unable to load external layout. Cleanup and load the internal layout. |
Sunny Goyal | e05b08f | 2017-02-23 18:30:22 -0800 | [diff] [blame] | 567 | mOpenHelper.createEmptyDB(mOpenHelper.getWritableDatabase()); |
Sunny Goyal | 9d21968 | 2014-10-23 14:21:02 -0700 | [diff] [blame] | 568 | mOpenHelper.loadFavorites(mOpenHelper.getWritableDatabase(), |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 569 | getDefaultLayoutParser(widgetHost)); |
Sunny Goyal | 9d21968 | 2014-10-23 14:21:02 -0700 | [diff] [blame] | 570 | } |
Sunny Goyal | 33d4438 | 2014-10-16 09:24:19 -0700 | [diff] [blame] | 571 | clearFlagEmptyDbCreated(); |
Michael Jurka | b85f8a4 | 2012-04-25 15:48:32 -0700 | [diff] [blame] | 572 | } |
| 573 | } |
| 574 | |
Sunny Goyal | b2d46ce | 2015-03-26 11:32:11 -0700 | [diff] [blame] | 575 | /** |
| 576 | * Creates workspace loader from an XML resource listed in the app restrictions. |
| 577 | * |
| 578 | * @return the loader if the restrictions are set and the resource exists; null otherwise. |
| 579 | */ |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 580 | private AutoInstallsLayout createWorkspaceLoaderFromAppRestriction(AppWidgetHost widgetHost) { |
Sunny Goyal | b2d46ce | 2015-03-26 11:32:11 -0700 | [diff] [blame] | 581 | Context ctx = getContext(); |
Pinyao Ting | 96186af | 2020-07-20 11:03:39 -0700 | [diff] [blame] | 582 | final String authority; |
| 583 | if (!TextUtils.isEmpty(mProviderAuthority)) { |
| 584 | authority = mProviderAuthority; |
| 585 | } else { |
| 586 | authority = Settings.Secure.getString(ctx.getContentResolver(), |
| 587 | "launcher3.layout.provider"); |
| 588 | } |
Sunny Goyal | c0f03d9 | 2019-03-22 14:13:36 -0700 | [diff] [blame] | 589 | if (TextUtils.isEmpty(authority)) { |
Sunny Goyal | 35ca873 | 2015-04-06 10:45:31 -0700 | [diff] [blame] | 590 | return null; |
| 591 | } |
Sunny Goyal | b2d46ce | 2015-03-26 11:32:11 -0700 | [diff] [blame] | 592 | |
Sunny Goyal | c0f03d9 | 2019-03-22 14:13:36 -0700 | [diff] [blame] | 593 | ProviderInfo pi = ctx.getPackageManager().resolveContentProvider(authority, 0); |
| 594 | if (pi == null) { |
| 595 | Log.e(TAG, "No provider found for authority " + authority); |
| 596 | return null; |
Sunny Goyal | b2d46ce | 2015-03-26 11:32:11 -0700 | [diff] [blame] | 597 | } |
Sunny Goyal | 4b5b0eb | 2019-12-02 17:00:35 -0800 | [diff] [blame] | 598 | Uri uri = getLayoutUri(authority, ctx); |
Sunny Goyal | c0f03d9 | 2019-03-22 14:13:36 -0700 | [diff] [blame] | 599 | try (InputStream in = ctx.getContentResolver().openInputStream(uri)) { |
| 600 | // Read the full xml so that we fail early in case of any IO error. |
| 601 | String layout = new String(IOUtils.toByteArray(in)); |
| 602 | XmlPullParser parser = Xml.newPullParser(); |
| 603 | parser.setInput(new StringReader(layout)); |
| 604 | |
| 605 | Log.d(TAG, "Loading layout from " + authority); |
| 606 | return new AutoInstallsLayout(ctx, widgetHost, mOpenHelper, |
| 607 | ctx.getPackageManager().getResourcesForApplication(pi.applicationInfo), |
| 608 | () -> parser, AutoInstallsLayout.TAG_WORKSPACE); |
| 609 | } catch (Exception e) { |
| 610 | Log.e(TAG, "Error getting layout stream from: " + authority , e); |
| 611 | return null; |
| 612 | } |
Sunny Goyal | b2d46ce | 2015-03-26 11:32:11 -0700 | [diff] [blame] | 613 | } |
| 614 | |
Sunny Goyal | 4b5b0eb | 2019-12-02 17:00:35 -0800 | [diff] [blame] | 615 | public static Uri getLayoutUri(String authority, Context ctx) { |
| 616 | InvariantDeviceProfile grid = LauncherAppState.getIDP(ctx); |
| 617 | return new Uri.Builder().scheme("content").authority(authority).path("launcher_layout") |
| 618 | .appendQueryParameter("version", "1") |
| 619 | .appendQueryParameter("gridWidth", Integer.toString(grid.numColumns)) |
| 620 | .appendQueryParameter("gridHeight", Integer.toString(grid.numRows)) |
Tony Wickham | b87f3cd | 2021-04-07 15:02:37 -0700 | [diff] [blame] | 621 | .appendQueryParameter("hotseatSize", Integer.toString(grid.numDatabaseHotseatIcons)) |
Sunny Goyal | 4b5b0eb | 2019-12-02 17:00:35 -0800 | [diff] [blame] | 622 | .build(); |
| 623 | } |
| 624 | |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 625 | private DefaultLayoutParser getDefaultLayoutParser(AppWidgetHost widgetHost) { |
Adam Cohen | 2782449 | 2017-09-22 17:10:55 -0700 | [diff] [blame] | 626 | InvariantDeviceProfile idp = LauncherAppState.getIDP(getContext()); |
| 627 | int defaultLayout = idp.defaultLayoutId; |
| 628 | |
Sunny Goyal | 337c81f | 2019-12-10 12:19:13 -0800 | [diff] [blame] | 629 | if (getContext().getSystemService(UserManager.class).isDemoUser() |
| 630 | && idp.demoModeLayoutId != 0) { |
Adam Cohen | 2782449 | 2017-09-22 17:10:55 -0700 | [diff] [blame] | 631 | defaultLayout = idp.demoModeLayoutId; |
| 632 | } |
| 633 | |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 634 | return new DefaultLayoutParser(getContext(), widgetHost, |
Sunny Goyal | 9d21968 | 2014-10-23 14:21:02 -0700 | [diff] [blame] | 635 | mOpenHelper, getContext().getResources(), defaultLayout); |
| 636 | } |
| 637 | |
Sunny Goyal | d3849d1 | 2015-10-29 10:28:32 -0700 | [diff] [blame] | 638 | /** |
Sunny Goyal | f076eae | 2016-01-11 12:25:10 -0800 | [diff] [blame] | 639 | * The class is subclassed in tests to create an in-memory db. |
| 640 | */ |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 641 | public static class DatabaseHelper extends NoLocaleSQLiteHelper implements |
| 642 | LayoutParserCallback { |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 643 | private final Context mContext; |
Tracy Zhou | ed5f308 | 2020-04-20 01:13:26 -0700 | [diff] [blame] | 644 | private final boolean mForMigration; |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 645 | private int mMaxItemId = -1; |
| 646 | private int mMaxScreenId = -1; |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 647 | private boolean mBackupTableExists; |
Samuel Fufa | f667a13 | 2020-05-29 14:47:42 -0700 | [diff] [blame] | 648 | private boolean mHotseatRestoreTableExists; |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 649 | |
Tracy Zhou | ed5f308 | 2020-04-20 01:13:26 -0700 | [diff] [blame] | 650 | static DatabaseHelper createDatabaseHelper(Context context, boolean forMigration) { |
| 651 | return createDatabaseHelper(context, null, forMigration); |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 652 | } |
| 653 | |
Tracy Zhou | ed5f308 | 2020-04-20 01:13:26 -0700 | [diff] [blame] | 654 | static DatabaseHelper createDatabaseHelper(Context context, String dbName, |
| 655 | boolean forMigration) { |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 656 | if (dbName == null) { |
| 657 | dbName = MULTI_DB_GRID_MIRATION_ALGO.get() ? InvariantDeviceProfile.INSTANCE.get( |
| 658 | context).dbFile : LauncherFiles.LAUNCHER_DB; |
| 659 | } |
Tracy Zhou | ed5f308 | 2020-04-20 01:13:26 -0700 | [diff] [blame] | 660 | DatabaseHelper databaseHelper = new DatabaseHelper(context, dbName, forMigration); |
Sunny Goyal | 6fb929e | 2015-09-23 11:40:53 -0700 | [diff] [blame] | 661 | // Table creation sometimes fails silently, which leads to a crash loop. |
| 662 | // This way, we will try to create a table every time after crash, so the device |
| 663 | // would eventually be able to recover. |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 664 | if (!tableExists(databaseHelper.getReadableDatabase(), Favorites.TABLE_NAME)) { |
Sunny Goyal | 6fb929e | 2015-09-23 11:40:53 -0700 | [diff] [blame] | 665 | Log.e(TAG, "Tables are missing after onCreate has been called. Trying to recreate"); |
| 666 | // This operation is a no-op if the table already exists. |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 667 | databaseHelper.addFavoritesTable(databaseHelper.getWritableDatabase(), true); |
Sunny Goyal | 6fb929e | 2015-09-23 11:40:53 -0700 | [diff] [blame] | 668 | } |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 669 | if (!MULTI_DB_GRID_MIRATION_ALGO.get()) { |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 670 | databaseHelper.mBackupTableExists = tableExists( |
| 671 | databaseHelper.getReadableDatabase(), Favorites.BACKUP_TABLE_NAME); |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 672 | } |
Samuel Fufa | f667a13 | 2020-05-29 14:47:42 -0700 | [diff] [blame] | 673 | databaseHelper.mHotseatRestoreTableExists = tableExists( |
| 674 | databaseHelper.getReadableDatabase(), Favorites.HYBRID_HOTSEAT_BACKUP_TABLE); |
Sunny Goyal | 6fb929e | 2015-09-23 11:40:53 -0700 | [diff] [blame] | 675 | |
Tracy Zhou | c000045 | 2020-03-17 18:28:38 -0700 | [diff] [blame] | 676 | databaseHelper.initIds(); |
| 677 | return databaseHelper; |
Sunny Goyal | 7eab3cc | 2016-03-18 17:42:55 -0700 | [diff] [blame] | 678 | } |
| 679 | |
| 680 | /** |
Sunny Goyal | c190dbf | 2016-05-05 14:37:05 -0700 | [diff] [blame] | 681 | * Constructor used in tests and for restore. |
Sunny Goyal | 7eab3cc | 2016-03-18 17:42:55 -0700 | [diff] [blame] | 682 | */ |
Tracy Zhou | ed5f308 | 2020-04-20 01:13:26 -0700 | [diff] [blame] | 683 | public DatabaseHelper(Context context, String dbName, boolean forMigration) { |
Tracy Zhou | 7df93d2 | 2020-01-27 13:44:06 -0800 | [diff] [blame] | 684 | super(context, dbName, SCHEMA_VERSION); |
Sunny Goyal | 7eab3cc | 2016-03-18 17:42:55 -0700 | [diff] [blame] | 685 | mContext = context; |
Tracy Zhou | ed5f308 | 2020-04-20 01:13:26 -0700 | [diff] [blame] | 686 | mForMigration = forMigration; |
Sunny Goyal | 7eab3cc | 2016-03-18 17:42:55 -0700 | [diff] [blame] | 687 | } |
| 688 | |
| 689 | protected void initIds() { |
Winson Chung | 3d503fb | 2011-07-13 17:25:49 -0700 | [diff] [blame] | 690 | // In the case where neither onCreate nor onUpgrade gets called, we read the maxId from |
| 691 | // the DB here |
Adam Cohen | dcd297f | 2013-06-18 13:13:40 -0700 | [diff] [blame] | 692 | if (mMaxItemId == -1) { |
| 693 | mMaxItemId = initializeMaxItemId(getWritableDatabase()); |
| 694 | } |
| 695 | if (mMaxScreenId == -1) { |
| 696 | mMaxScreenId = initializeMaxScreenId(getWritableDatabase()); |
Winson Chung | 3d503fb | 2011-07-13 17:25:49 -0700 | [diff] [blame] | 697 | } |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 698 | } |
| 699 | |
| 700 | @Override |
| 701 | public void onCreate(SQLiteDatabase db) { |
Joe Onorato | a30ce8e | 2009-11-11 08:16:49 -0800 | [diff] [blame] | 702 | if (LOGD) Log.d(TAG, "creating new launcher database"); |
Michael Jurka | a8c760d | 2011-04-28 14:59:33 -0700 | [diff] [blame] | 703 | |
Adam Cohen | dcd297f | 2013-06-18 13:13:40 -0700 | [diff] [blame] | 704 | mMaxItemId = 1; |
| 705 | mMaxScreenId = 0; |
Michael Jurka | a8c760d | 2011-04-28 14:59:33 -0700 | [diff] [blame] | 706 | |
Sunny Goyal | 6fb929e | 2015-09-23 11:40:53 -0700 | [diff] [blame] | 707 | addFavoritesTable(db, false); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 708 | |
Sunny Goyal | e87e6ab | 2014-11-21 22:42:53 -0800 | [diff] [blame] | 709 | // Fresh and clean launcher DB. |
| 710 | mMaxItemId = initializeMaxItemId(db); |
Tracy Zhou | ed5f308 | 2020-04-20 01:13:26 -0700 | [diff] [blame] | 711 | if (!mForMigration) { |
| 712 | onEmptyDbCreated(); |
| 713 | } |
Sunny Goyal | f076eae | 2016-01-11 12:25:10 -0800 | [diff] [blame] | 714 | } |
| 715 | |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 716 | protected void onAddOrDeleteOp(SQLiteDatabase db) { |
Pinyao Ting | 26c4e23 | 2020-04-15 22:25:06 -0700 | [diff] [blame] | 717 | if (mBackupTableExists) { |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 718 | dropTable(db, Favorites.BACKUP_TABLE_NAME); |
| 719 | mBackupTableExists = false; |
| 720 | } |
Samuel Fufa | f667a13 | 2020-05-29 14:47:42 -0700 | [diff] [blame] | 721 | if (mHotseatRestoreTableExists) { |
| 722 | dropTable(db, Favorites.HYBRID_HOTSEAT_BACKUP_TABLE); |
| 723 | mHotseatRestoreTableExists = false; |
| 724 | } |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 725 | } |
| 726 | |
Sunny Goyal | f076eae | 2016-01-11 12:25:10 -0800 | [diff] [blame] | 727 | /** |
Pinyao Ting | 96186af | 2020-07-20 11:03:39 -0700 | [diff] [blame] | 728 | * Re-composite given key in respect to database. If the current db is |
| 729 | * {@link LauncherFiles#LAUNCHER_DB}, return the key as-is. Otherwise append the db name to |
| 730 | * given key. e.g. consider key="EMPTY_DATABASE_CREATED", dbName="minimal.db", the returning |
| 731 | * string will be "EMPTY_DATABASE_CREATED@minimal.db". |
| 732 | */ |
| 733 | String getKey(final String key) { |
| 734 | if (TextUtils.equals(getDatabaseName(), LauncherFiles.LAUNCHER_DB)) { |
| 735 | return key; |
| 736 | } |
| 737 | return key + "@" + getDatabaseName(); |
| 738 | } |
| 739 | |
| 740 | /** |
Sunny Goyal | f076eae | 2016-01-11 12:25:10 -0800 | [diff] [blame] | 741 | * Overriden in tests. |
| 742 | */ |
| 743 | protected void onEmptyDbCreated() { |
| 744 | // Set the flag for empty DB |
Pinyao Ting | 96186af | 2020-07-20 11:03:39 -0700 | [diff] [blame] | 745 | Utilities.getPrefs(mContext).edit().putBoolean(getKey(EMPTY_DATABASE_CREATED), true) |
| 746 | .commit(); |
Sunny Goyal | f076eae | 2016-01-11 12:25:10 -0800 | [diff] [blame] | 747 | } |
| 748 | |
Jon Miranda | 2bc6b93 | 2019-03-07 15:24:46 -0800 | [diff] [blame] | 749 | public long getSerialNumberForUser(UserHandle user) { |
Sunny Goyal | 337c81f | 2019-12-10 12:19:13 -0800 | [diff] [blame] | 750 | return UserCache.INSTANCE.get(mContext).getSerialNumberForUser(user); |
Jon Miranda | 2bc6b93 | 2019-03-07 15:24:46 -0800 | [diff] [blame] | 751 | } |
| 752 | |
Sunny Goyal | e8f7d5a | 2016-05-24 11:30:14 -0700 | [diff] [blame] | 753 | public long getDefaultUserSerial() { |
Jon Miranda | 2bc6b93 | 2019-03-07 15:24:46 -0800 | [diff] [blame] | 754 | return getSerialNumberForUser(Process.myUserHandle()); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 755 | } |
| 756 | |
Sunny Goyal | 6fb929e | 2015-09-23 11:40:53 -0700 | [diff] [blame] | 757 | private void addFavoritesTable(SQLiteDatabase db, boolean optional) { |
Sunny Goyal | c190dbf | 2016-05-05 14:37:05 -0700 | [diff] [blame] | 758 | Favorites.addTableToDb(db, getDefaultUserSerial(), optional); |
Sunny Goyal | 6fb929e | 2015-09-23 11:40:53 -0700 | [diff] [blame] | 759 | } |
| 760 | |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 761 | @Override |
Sunny Goyal | 3c7d55b | 2017-04-13 12:01:47 -0700 | [diff] [blame] | 762 | public void onOpen(SQLiteDatabase db) { |
| 763 | super.onOpen(db); |
Sunny Goyal | 05f3088 | 2017-05-03 12:42:18 -0700 | [diff] [blame] | 764 | |
| 765 | File schemaFile = mContext.getFileStreamPath(DOWNGRADE_SCHEMA_FILE); |
| 766 | if (!schemaFile.exists()) { |
| 767 | handleOneTimeDataUpgrade(db); |
Sunny Goyal | 3c7d55b | 2017-04-13 12:01:47 -0700 | [diff] [blame] | 768 | } |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 769 | DbDowngradeHelper.updateSchemaFile(schemaFile, SCHEMA_VERSION, mContext); |
Sunny Goyal | 3c7d55b | 2017-04-13 12:01:47 -0700 | [diff] [blame] | 770 | } |
| 771 | |
| 772 | /** |
Sunny Goyal | 05f3088 | 2017-05-03 12:42:18 -0700 | [diff] [blame] | 773 | * One-time data updated before support of onDowngrade was added. This update is backwards |
| 774 | * compatible and can safely be run multiple times. |
| 775 | * Note: No new logic should be added here after release, as the new logic might not get |
| 776 | * executed on an existing device. |
| 777 | * TODO: Move this to db upgrade path, once the downgrade path is released. |
Sunny Goyal | 3c7d55b | 2017-04-13 12:01:47 -0700 | [diff] [blame] | 778 | */ |
Sunny Goyal | 05f3088 | 2017-05-03 12:42:18 -0700 | [diff] [blame] | 779 | protected void handleOneTimeDataUpgrade(SQLiteDatabase db) { |
| 780 | // Remove "profile extra" |
Sunny Goyal | 337c81f | 2019-12-10 12:19:13 -0800 | [diff] [blame] | 781 | UserCache um = UserCache.INSTANCE.get(mContext); |
Sunny Goyal | 05f3088 | 2017-05-03 12:42:18 -0700 | [diff] [blame] | 782 | for (UserHandle user : um.getUserProfiles()) { |
| 783 | long serial = um.getSerialNumberForUser(user); |
| 784 | String sql = "update favorites set intent = replace(intent, " |
| 785 | + "';l.profile=" + serial + ";', ';') where itemType = 0;"; |
| 786 | db.execSQL(sql); |
Sunny Goyal | 3c7d55b | 2017-04-13 12:01:47 -0700 | [diff] [blame] | 787 | } |
| 788 | } |
| 789 | |
| 790 | @Override |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 791 | public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { |
Winson Chung | c763c4e | 2013-07-19 13:49:06 -0700 | [diff] [blame] | 792 | if (LOGD) Log.d(TAG, "onUpgrade triggered: " + oldVersion); |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 793 | switch (oldVersion) { |
| 794 | // The version cannot be lower that 12, as Launcher3 never supported a lower |
Sunny Goyal | e87e6ab | 2014-11-21 22:42:53 -0800 | [diff] [blame] | 795 | // version of the DB. |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 796 | case 12: |
| 797 | // No-op |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 798 | case 13: { |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 799 | try (SQLiteTransaction t = new SQLiteTransaction(db)) { |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 800 | // Insert new column for holding widget provider name |
| 801 | db.execSQL("ALTER TABLE favorites " + |
| 802 | "ADD COLUMN appWidgetProvider TEXT;"); |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 803 | t.commit(); |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 804 | } catch (SQLException ex) { |
| 805 | Log.e(TAG, ex.getMessage(), ex); |
| 806 | // Old version remains, which means we wipe old data |
| 807 | break; |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 808 | } |
| 809 | } |
| 810 | case 14: { |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 811 | if (!addIntegerColumn(db, Favorites.MODIFIED, 0)) { |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 812 | // Old version remains, which means we wipe old data |
| 813 | break; |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 814 | } |
| 815 | } |
| 816 | case 15: { |
Sunny Goyal | 5d85c44 | 2015-03-10 13:14:47 -0700 | [diff] [blame] | 817 | if (!addIntegerColumn(db, Favorites.RESTORED, 0)) { |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 818 | // Old version remains, which means we wipe old data |
| 819 | break; |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 820 | } |
| 821 | } |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 822 | case 16: |
Sunny Goyal | 10629b0 | 2016-09-01 12:50:11 -0700 | [diff] [blame] | 823 | // No-op |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 824 | case 17: |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 825 | // No-op |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 826 | case 18: |
| 827 | // No-op |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 828 | case 19: { |
| 829 | // Add userId column |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 830 | if (!addIntegerColumn(db, Favorites.PROFILE_ID, getDefaultUserSerial())) { |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 831 | // Old version remains, which means we wipe old data |
| 832 | break; |
| 833 | } |
| 834 | } |
| 835 | case 20: |
| 836 | if (!updateFolderItemsRank(db, true)) { |
| 837 | break; |
| 838 | } |
Sunny Goyal | d2f3819 | 2015-02-25 10:46:34 -0800 | [diff] [blame] | 839 | case 21: |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 840 | // No-op |
Sunny Goyal | d2f3819 | 2015-02-25 10:46:34 -0800 | [diff] [blame] | 841 | case 22: { |
Sunny Goyal | 5d85c44 | 2015-03-10 13:14:47 -0700 | [diff] [blame] | 842 | if (!addIntegerColumn(db, Favorites.OPTIONS, 0)) { |
| 843 | // Old version remains, which means we wipe old data |
| 844 | break; |
| 845 | } |
| 846 | } |
Sunny Goyal | 0b03778 | 2015-04-02 10:27:03 -0700 | [diff] [blame] | 847 | case 23: |
Sunny Goyal | 5c97f51 | 2015-05-19 16:03:28 -0700 | [diff] [blame] | 848 | // No-op |
Sunny Goyal | e2fba6c | 2015-05-12 10:39:59 -0700 | [diff] [blame] | 849 | case 24: |
Tony Mak | 1b6826c | 2018-02-27 15:06:12 +0000 | [diff] [blame] | 850 | // No-op |
Sunny Goyal | 5c97f51 | 2015-05-19 16:03:28 -0700 | [diff] [blame] | 851 | case 25: |
| 852 | convertShortcutsToLauncherActivities(db); |
Sunny Goyal | a9e2f5a | 2016-06-10 12:22:04 -0700 | [diff] [blame] | 853 | case 26: |
| 854 | // QSB was moved to the grid. Clear the first row on screen 0. |
Jon Miranda | 7143ba6 | 2019-03-15 09:00:05 -0700 | [diff] [blame] | 855 | if (FeatureFlags.QSB_ON_FIRST_SCREEN && |
Sunny Goyal | 8ad02b8 | 2016-12-29 13:31:43 -0800 | [diff] [blame] | 856 | !LauncherDbUtils.prepareScreenZeroToHostQsb(mContext, db)) { |
Sunny Goyal | a9e2f5a | 2016-06-10 12:22:04 -0700 | [diff] [blame] | 857 | break; |
| 858 | } |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 859 | case 27: { |
| 860 | // Update the favorites table so that the screen ids are ordered based on |
| 861 | // workspace page rank. |
| 862 | IntArray finalScreens = LauncherDbUtils.queryIntArray(db, "workspaceScreens", |
| 863 | BaseColumns._ID, null, null, "screenRank"); |
| 864 | int[] original = finalScreens.toArray(); |
| 865 | Arrays.sort(original); |
| 866 | String updatemap = ""; |
| 867 | for (int i = 0; i < original.length; i++) { |
| 868 | if (finalScreens.get(i) != original[i]) { |
| 869 | updatemap += String.format(Locale.ENGLISH, " WHEN %1$s=%2$d THEN %3$d", |
| 870 | Favorites.SCREEN, finalScreens.get(i), original[i]); |
| 871 | } |
| 872 | } |
| 873 | if (!TextUtils.isEmpty(updatemap)) { |
| 874 | String query = String.format(Locale.ENGLISH, |
| 875 | "UPDATE %1$s SET %2$s=CASE %3$s ELSE %2$s END WHERE %4$s = %5$d", |
| 876 | Favorites.TABLE_NAME, Favorites.SCREEN, updatemap, |
| 877 | Favorites.CONTAINER, Favorites.CONTAINER_DESKTOP); |
| 878 | db.execSQL(query); |
| 879 | } |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 880 | dropTable(db, "workspaceScreens"); |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 881 | } |
| 882 | case 28: |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 883 | // DB Upgraded successfully |
| 884 | return; |
Chris Wren | d5e66bf | 2013-09-16 14:02:29 -0400 | [diff] [blame] | 885 | } |
| 886 | |
Sunny Goyal | a2cc624 | 2015-01-14 14:23:02 -0800 | [diff] [blame] | 887 | // DB was not upgraded |
| 888 | Log.w(TAG, "Destroying all old data."); |
| 889 | createEmptyDB(db); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 890 | } |
Romain Guy | 7eb9e5e | 2009-12-02 20:10:07 -0800 | [diff] [blame] | 891 | |
Adam Cohen | 9b1d062 | 2014-05-21 19:01:57 -0700 | [diff] [blame] | 892 | @Override |
| 893 | public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) { |
Sunny Goyal | 05f3088 | 2017-05-03 12:42:18 -0700 | [diff] [blame] | 894 | try { |
| 895 | DbDowngradeHelper.parse(mContext.getFileStreamPath(DOWNGRADE_SCHEMA_FILE)) |
| 896 | .onDowngrade(db, oldVersion, newVersion); |
| 897 | } catch (Exception e) { |
| 898 | Log.d(TAG, "Unable to downgrade from: " + oldVersion + " to " + newVersion + |
| 899 | ". Wiping databse.", e); |
| 900 | createEmptyDB(db); |
Sunny Goyal | 3c7d55b | 2017-04-13 12:01:47 -0700 | [diff] [blame] | 901 | } |
Sunny Goyal | 42de82f | 2014-09-26 22:09:29 -0700 | [diff] [blame] | 902 | } |
Adam Cohen | 9b1d062 | 2014-05-21 19:01:57 -0700 | [diff] [blame] | 903 | |
Sunny Goyal | 42de82f | 2014-09-26 22:09:29 -0700 | [diff] [blame] | 904 | /** |
| 905 | * Clears all the data for a fresh start. |
| 906 | */ |
| 907 | public void createEmptyDB(SQLiteDatabase db) { |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 908 | try (SQLiteTransaction t = new SQLiteTransaction(db)) { |
Sunny Goyal | 161a214 | 2018-10-29 14:02:20 -0700 | [diff] [blame] | 909 | dropTable(db, Favorites.TABLE_NAME); |
| 910 | dropTable(db, "workspaceScreens"); |
Sunny Goyal | e05b08f | 2017-02-23 18:30:22 -0800 | [diff] [blame] | 911 | onCreate(db); |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 912 | t.commit(); |
Sunny Goyal | e05b08f | 2017-02-23 18:30:22 -0800 | [diff] [blame] | 913 | } |
Adam Cohen | 9b1d062 | 2014-05-21 19:01:57 -0700 | [diff] [blame] | 914 | } |
| 915 | |
Sunny Goyal | d2f3819 | 2015-02-25 10:46:34 -0800 | [diff] [blame] | 916 | /** |
Sunny Goyal | 55fddc8 | 2017-04-06 15:02:52 -0700 | [diff] [blame] | 917 | * Removes widgets which are registered to the Launcher's host, but are not present |
| 918 | * in our model. |
| 919 | */ |
| 920 | public void removeGhostWidgets(SQLiteDatabase db) { |
| 921 | // Get all existing widget ids. |
| 922 | final AppWidgetHost host = newLauncherWidgetHost(); |
| 923 | final int[] allWidgets; |
| 924 | try { |
Sunny Goyal | 22ca9ec | 2017-05-18 15:03:13 -0700 | [diff] [blame] | 925 | // Although the method was defined in O, it has existed since the beginning of time, |
| 926 | // so it might work on older platforms as well. |
| 927 | allWidgets = host.getAppWidgetIds(); |
| 928 | } catch (IncompatibleClassChangeError e) { |
Sunny Goyal | 55fddc8 | 2017-04-06 15:02:52 -0700 | [diff] [blame] | 929 | Log.e(TAG, "getAppWidgetIds not supported", e); |
| 930 | return; |
| 931 | } |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 932 | final IntSet validWidgets = IntSet.wrap(LauncherDbUtils.queryIntArray(db, |
| 933 | Favorites.TABLE_NAME, Favorites.APPWIDGET_ID, |
| 934 | "itemType=" + Favorites.ITEM_TYPE_APPWIDGET, null, null)); |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 935 | for (int widgetId : allWidgets) { |
| 936 | if (!validWidgets.contains(widgetId)) { |
| 937 | try { |
| 938 | FileLog.d(TAG, "Deleting invalid widget " + widgetId); |
| 939 | host.deleteAppWidgetId(widgetId); |
| 940 | } catch (RuntimeException e) { |
| 941 | // Ignore |
| 942 | } |
| 943 | } |
Sunny Goyal | 55fddc8 | 2017-04-06 15:02:52 -0700 | [diff] [blame] | 944 | } |
| 945 | } |
| 946 | |
| 947 | /** |
Sunny Goyal | 0b03778 | 2015-04-02 10:27:03 -0700 | [diff] [blame] | 948 | * Replaces all shortcuts of type {@link Favorites#ITEM_TYPE_SHORTCUT} which have a valid |
| 949 | * launcher activity target with {@link Favorites#ITEM_TYPE_APPLICATION}. |
| 950 | */ |
Sunny Goyal | 316490e | 2015-06-02 09:38:28 -0700 | [diff] [blame] | 951 | @Thunk void convertShortcutsToLauncherActivities(SQLiteDatabase db) { |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 952 | try (SQLiteTransaction t = new SQLiteTransaction(db); |
| 953 | // Only consider the primary user as other users can't have a shortcut. |
| 954 | Cursor c = db.query(Favorites.TABLE_NAME, |
| 955 | new String[] { Favorites._ID, Favorites.INTENT}, |
| 956 | "itemType=" + Favorites.ITEM_TYPE_SHORTCUT + |
| 957 | " AND profileId=" + getDefaultUserSerial(), |
| 958 | null, null, null, null); |
| 959 | SQLiteStatement updateStmt = db.compileStatement("UPDATE favorites SET itemType=" |
| 960 | + Favorites.ITEM_TYPE_APPLICATION + " WHERE _id=?") |
| 961 | ) { |
Sunny Goyal | 0b03778 | 2015-04-02 10:27:03 -0700 | [diff] [blame] | 962 | final int idIndex = c.getColumnIndexOrThrow(Favorites._ID); |
| 963 | final int intentIndex = c.getColumnIndexOrThrow(Favorites.INTENT); |
| 964 | |
| 965 | while (c.moveToNext()) { |
| 966 | String intentDescription = c.getString(intentIndex); |
| 967 | Intent intent; |
| 968 | try { |
| 969 | intent = Intent.parseUri(intentDescription, 0); |
| 970 | } catch (URISyntaxException e) { |
| 971 | Log.e(TAG, "Unable to parse intent", e); |
| 972 | continue; |
| 973 | } |
| 974 | |
Sunny Goyal | 9dbb27c | 2019-07-17 15:12:56 -0700 | [diff] [blame] | 975 | if (!PackageManagerHelper.isLauncherAppTarget(intent)) { |
Sunny Goyal | 0b03778 | 2015-04-02 10:27:03 -0700 | [diff] [blame] | 976 | continue; |
| 977 | } |
| 978 | |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 979 | int id = c.getInt(idIndex); |
Sunny Goyal | 0b03778 | 2015-04-02 10:27:03 -0700 | [diff] [blame] | 980 | updateStmt.bindLong(1, id); |
Sunny Goyal | c22841b | 2015-07-13 19:59:50 -0700 | [diff] [blame] | 981 | updateStmt.executeUpdateDelete(); |
Sunny Goyal | 0b03778 | 2015-04-02 10:27:03 -0700 | [diff] [blame] | 982 | } |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 983 | t.commit(); |
Sunny Goyal | 0b03778 | 2015-04-02 10:27:03 -0700 | [diff] [blame] | 984 | } catch (SQLException ex) { |
| 985 | Log.w(TAG, "Error deduping shortcuts", ex); |
Sunny Goyal | 0b03778 | 2015-04-02 10:27:03 -0700 | [diff] [blame] | 986 | } |
| 987 | } |
| 988 | |
Adam Cohen | 091440a | 2015-03-18 14:16:05 -0700 | [diff] [blame] | 989 | @Thunk boolean updateFolderItemsRank(SQLiteDatabase db, boolean addRankColumn) { |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 990 | try (SQLiteTransaction t = new SQLiteTransaction(db)) { |
Sunny Goyal | 08f7261 | 2015-01-05 13:41:43 -0800 | [diff] [blame] | 991 | if (addRankColumn) { |
| 992 | // Insert new column for holding rank |
| 993 | db.execSQL("ALTER TABLE favorites ADD COLUMN rank INTEGER NOT NULL DEFAULT 0;"); |
| 994 | } |
| 995 | |
| 996 | // Get a map for folder ID to folder width |
| 997 | Cursor c = db.rawQuery("SELECT container, MAX(cellX) FROM favorites" |
| 998 | + " WHERE container IN (SELECT _id FROM favorites WHERE itemType = ?)" |
| 999 | + " GROUP BY container;", |
| 1000 | new String[] {Integer.toString(LauncherSettings.Favorites.ITEM_TYPE_FOLDER)}); |
| 1001 | |
| 1002 | while (c.moveToNext()) { |
Sunny Goyal | c87775d | 2015-02-10 19:52:36 -0800 | [diff] [blame] | 1003 | db.execSQL("UPDATE favorites SET rank=cellX+(cellY*?) WHERE " |
| 1004 | + "container=? AND cellX IS NOT NULL AND cellY IS NOT NULL;", |
Sunny Goyal | 08f7261 | 2015-01-05 13:41:43 -0800 | [diff] [blame] | 1005 | new Object[] {c.getLong(1) + 1, c.getLong(0)}); |
| 1006 | } |
| 1007 | |
| 1008 | c.close(); |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 1009 | t.commit(); |
Sunny Goyal | 08f7261 | 2015-01-05 13:41:43 -0800 | [diff] [blame] | 1010 | } catch (SQLException ex) { |
| 1011 | // Old version remains, which means we wipe old data |
| 1012 | Log.e(TAG, ex.getMessage(), ex); |
| 1013 | return false; |
Sunny Goyal | 08f7261 | 2015-01-05 13:41:43 -0800 | [diff] [blame] | 1014 | } |
| 1015 | return true; |
| 1016 | } |
| 1017 | |
Sunny Goyal | 5d85c44 | 2015-03-10 13:14:47 -0700 | [diff] [blame] | 1018 | private boolean addIntegerColumn(SQLiteDatabase db, String columnName, long defaultValue) { |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 1019 | try (SQLiteTransaction t = new SQLiteTransaction(db)) { |
Sunny Goyal | 5d85c44 | 2015-03-10 13:14:47 -0700 | [diff] [blame] | 1020 | db.execSQL("ALTER TABLE favorites ADD COLUMN " |
| 1021 | + columnName + " INTEGER NOT NULL DEFAULT " + defaultValue + ";"); |
Sunny Goyal | dbfc901 | 2017-04-17 16:58:36 -0700 | [diff] [blame] | 1022 | t.commit(); |
Kenny Guy | ed13187 | 2014-04-30 03:02:21 +0100 | [diff] [blame] | 1023 | } catch (SQLException ex) { |
Kenny Guy | ed13187 | 2014-04-30 03:02:21 +0100 | [diff] [blame] | 1024 | Log.e(TAG, ex.getMessage(), ex); |
| 1025 | return false; |
Kenny Guy | ed13187 | 2014-04-30 03:02:21 +0100 | [diff] [blame] | 1026 | } |
| 1027 | return true; |
| 1028 | } |
| 1029 | |
Michael Jurka | a8c760d | 2011-04-28 14:59:33 -0700 | [diff] [blame] | 1030 | // Generates a new ID to use for an object in your database. This method should be only |
| 1031 | // called from the main UI thread. As an exception, we do call it when we call the |
| 1032 | // constructor from the worker thread; however, this doesn't extend until after the |
| 1033 | // constructor is called, and we only pass a reference to LauncherProvider to LauncherApp |
| 1034 | // after that point |
Sunny Goyal | 0fe505b | 2014-08-06 09:55:36 -0700 | [diff] [blame] | 1035 | @Override |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 1036 | public int generateNewItemId() { |
Adam Cohen | dcd297f | 2013-06-18 13:13:40 -0700 | [diff] [blame] | 1037 | if (mMaxItemId < 0) { |
| 1038 | throw new RuntimeException("Error: max item id was not initialized"); |
Michael Jurka | a8c760d | 2011-04-28 14:59:33 -0700 | [diff] [blame] | 1039 | } |
Adam Cohen | dcd297f | 2013-06-18 13:13:40 -0700 | [diff] [blame] | 1040 | mMaxItemId += 1; |
| 1041 | return mMaxItemId; |
Michael Jurka | a8c760d | 2011-04-28 14:59:33 -0700 | [diff] [blame] | 1042 | } |
| 1043 | |
Sunny Goyal | 55fddc8 | 2017-04-06 15:02:52 -0700 | [diff] [blame] | 1044 | public AppWidgetHost newLauncherWidgetHost() { |
Sunny Goyal | 64a75aa | 2017-07-03 13:50:52 -0700 | [diff] [blame] | 1045 | return new LauncherAppWidgetHost(mContext); |
Sunny Goyal | 55fddc8 | 2017-04-06 15:02:52 -0700 | [diff] [blame] | 1046 | } |
| 1047 | |
Sunny Goyal | 0fe505b | 2014-08-06 09:55:36 -0700 | [diff] [blame] | 1048 | @Override |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 1049 | public int insertAndCheck(SQLiteDatabase db, ContentValues values) { |
Sunny Goyal | b5b55c8 | 2016-05-10 12:28:59 -0700 | [diff] [blame] | 1050 | return dbInsertAndCheck(this, db, Favorites.TABLE_NAME, null, values); |
Sunny Goyal | 0fe505b | 2014-08-06 09:55:36 -0700 | [diff] [blame] | 1051 | } |
| 1052 | |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 1053 | public void checkId(ContentValues values) { |
| 1054 | int id = values.getAsInteger(Favorites._ID); |
| 1055 | mMaxItemId = Math.max(id, mMaxItemId); |
| 1056 | |
| 1057 | Integer screen = values.getAsInteger(Favorites.SCREEN); |
| 1058 | Integer container = values.getAsInteger(Favorites.CONTAINER); |
| 1059 | if (screen != null && container != null |
| 1060 | && container.intValue() == Favorites.CONTAINER_DESKTOP) { |
| 1061 | mMaxScreenId = Math.max(screen, mMaxScreenId); |
Chris Wren | 5dee7af | 2013-12-20 17:22:11 -0500 | [diff] [blame] | 1062 | } |
| 1063 | } |
| 1064 | |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 1065 | private int initializeMaxItemId(SQLiteDatabase db) { |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 1066 | return getMaxId(db, "SELECT MAX(%1$s) FROM %2$s", Favorites._ID, Favorites.TABLE_NAME); |
Adam Cohen | dcd297f | 2013-06-18 13:13:40 -0700 | [diff] [blame] | 1067 | } |
| 1068 | |
| 1069 | // Generates a new ID to use for an workspace screen in your database. This method |
| 1070 | // should be only called from the main UI thread. As an exception, we do call it when we |
| 1071 | // call the constructor from the worker thread; however, this doesn't extend until after the |
| 1072 | // constructor is called, and we only pass a reference to LauncherProvider to LauncherApp |
| 1073 | // after that point |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 1074 | public int generateNewScreenId() { |
Adam Cohen | dcd297f | 2013-06-18 13:13:40 -0700 | [diff] [blame] | 1075 | if (mMaxScreenId < 0) { |
| 1076 | throw new RuntimeException("Error: max screen id was not initialized"); |
| 1077 | } |
| 1078 | mMaxScreenId += 1; |
| 1079 | return mMaxScreenId; |
| 1080 | } |
| 1081 | |
Sunny Goyal | efb7e84 | 2018-10-04 15:11:00 -0700 | [diff] [blame] | 1082 | private int initializeMaxScreenId(SQLiteDatabase db) { |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 1083 | return getMaxId(db, "SELECT MAX(%1$s) FROM %2$s WHERE %3$s = %4$d", |
| 1084 | Favorites.SCREEN, Favorites.TABLE_NAME, Favorites.CONTAINER, |
| 1085 | Favorites.CONTAINER_DESKTOP); |
Adam Cohen | 7ec3bbf | 2014-07-31 00:09:45 -0700 | [diff] [blame] | 1086 | } |
| 1087 | |
Adam Cohen | 091440a | 2015-03-18 14:16:05 -0700 | [diff] [blame] | 1088 | @Thunk int loadFavorites(SQLiteDatabase db, AutoInstallsLayout loader) { |
Sunny Goyal | 0fe505b | 2014-08-06 09:55:36 -0700 | [diff] [blame] | 1089 | // TODO: Use multiple loaders with fall-back and transaction. |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 1090 | int count = loader.loadLayout(db, new IntArray()); |
Adam Cohen | 71483f4 | 2014-05-15 14:04:01 -0700 | [diff] [blame] | 1091 | |
| 1092 | // Ensure that the max ids are initialized |
| 1093 | mMaxItemId = initializeMaxItemId(db); |
| 1094 | mMaxScreenId = initializeMaxScreenId(db); |
| 1095 | return count; |
| 1096 | } |
Mike Cleron | b87bd16 | 2009-10-30 16:36:56 -0700 | [diff] [blame] | 1097 | } |
Daniel Lehmann | c3a8040 | 2012-04-23 21:35:11 -0700 | [diff] [blame] | 1098 | |
Sunny Goyal | fe4e4b9 | 2015-03-04 10:43:45 -0800 | [diff] [blame] | 1099 | /** |
| 1100 | * @return the max _id in the provided table. |
| 1101 | */ |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 1102 | @Thunk static int getMaxId(SQLiteDatabase db, String query, Object... args) { |
Pinyao Ting | 0646dde | 2020-11-24 11:35:24 -0800 | [diff] [blame] | 1103 | int max = 0; |
| 1104 | try (SQLiteStatement prog = db.compileStatement( |
| 1105 | String.format(Locale.ENGLISH, query, args))) { |
| 1106 | max = (int) DatabaseUtils.longForQuery(prog, null); |
| 1107 | if (max < 0) { |
| 1108 | throw new RuntimeException("Error: could not query max id"); |
| 1109 | } |
| 1110 | } catch (IllegalArgumentException exception) { |
| 1111 | String message = exception.getMessage(); |
| 1112 | if (message.contains("re-open") && message.contains("already-closed")) { |
| 1113 | // Don't crash trying to end a transaction an an already closed DB. See b/173162852. |
| 1114 | } else { |
| 1115 | throw exception; |
| 1116 | } |
Sunny Goyal | fe4e4b9 | 2015-03-04 10:43:45 -0800 | [diff] [blame] | 1117 | } |
Sunny Goyal | c593939 | 2018-12-07 11:43:47 -0800 | [diff] [blame] | 1118 | return max; |
Sunny Goyal | fe4e4b9 | 2015-03-04 10:43:45 -0800 | [diff] [blame] | 1119 | } |
| 1120 | |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 1121 | static class SqlArguments { |
| 1122 | public final String table; |
| 1123 | public final String where; |
| 1124 | public final String[] args; |
| 1125 | |
| 1126 | SqlArguments(Uri url, String where, String[] args) { |
| 1127 | if (url.getPathSegments().size() == 1) { |
| 1128 | this.table = url.getPathSegments().get(0); |
| 1129 | this.where = where; |
| 1130 | this.args = args; |
| 1131 | } else if (url.getPathSegments().size() != 2) { |
| 1132 | throw new IllegalArgumentException("Invalid URI: " + url); |
| 1133 | } else if (!TextUtils.isEmpty(where)) { |
| 1134 | throw new UnsupportedOperationException("WHERE clause not supported: " + url); |
| 1135 | } else { |
| 1136 | this.table = url.getPathSegments().get(0); |
Daniel Lehmann | c3a8040 | 2012-04-23 21:35:11 -0700 | [diff] [blame] | 1137 | this.where = "_id=" + ContentUris.parseId(url); |
The Android Open Source Project | 31dd503 | 2009-03-03 19:32:27 -0800 | [diff] [blame] | 1138 | this.args = null; |
| 1139 | } |
| 1140 | } |
| 1141 | |
| 1142 | SqlArguments(Uri url) { |
| 1143 | if (url.getPathSegments().size() == 1) { |
| 1144 | table = url.getPathSegments().get(0); |
| 1145 | where = null; |
| 1146 | args = null; |
| 1147 | } else { |
| 1148 | throw new IllegalArgumentException("Invalid URI: " + url); |
| 1149 | } |
| 1150 | } |
| 1151 | } |
Adam Cohen | 7296097 | 2014-01-15 18:13:55 -0800 | [diff] [blame] | 1152 | } |