Lines Matching refs:db
65 private static final String DATABASE_NAME = "settings.db";
96 // The owner gets the unadorned db name;
119 private void createSecureTable(SQLiteDatabase db) {
120 db.execSQL("CREATE TABLE secure (" +
125 db.execSQL("CREATE INDEX secureIndex1 ON secure (name);");
128 private void createGlobalTable(SQLiteDatabase db) {
129 db.execSQL("CREATE TABLE global (" +
134 db.execSQL("CREATE INDEX globalIndex1 ON global (name);");
138 public void onCreate(SQLiteDatabase db) {
139 db.execSQL("CREATE TABLE system (" +
144 db.execSQL("CREATE INDEX systemIndex1 ON system (name);");
146 createSecureTable(db);
150 createGlobalTable(db);
153 db.execSQL("CREATE TABLE bluetooth_devices (" +
161 db.execSQL("CREATE TABLE bookmarks (" +
170 db.execSQL("CREATE INDEX bookmarksIndex1 ON bookmarks (folder);");
171 db.execSQL("CREATE INDEX bookmarksIndex2 ON bookmarks (shortcut);");
174 loadBookmarks(db);
177 loadVolumeLevels(db);
180 loadSettings(db);
184 public void onUpgrade(SQLiteDatabase db, int oldVersion, int currentVersion) {
204 loadVibrateSetting(db, true);
212 upgradeLockPatternLocation(db);
216 db.execSQL("UPDATE favorites SET iconResource=0 WHERE iconType=0");
221 db.beginTransaction();
223 db.execSQL("ALTER TABLE favorites ADD spanX INTEGER");
224 db.execSQL("ALTER TABLE favorites ADD spanY INTEGER");
226 db.execSQL("UPDATE favorites SET spanX=1, spanY=1 WHERE itemType<=0");
228 db.execSQL(
231 db.execSQL("UPDATE favorites SET spanX=4, spanY=1 WHERE itemType=1001");
232 db.setTransactionSuccessful();
234 db.endTransaction();
240 db.beginTransaction();
244 db.execSQL("DELETE FROM system WHERE name='network_preference'");
245 db.execSQL("INSERT INTO system ('name', 'value') values ('network_preference', '" +
247 db.setTransactionSuccessful();
249 db.endTransaction();
255 db.beginTransaction();
257 db.execSQL("ALTER TABLE favorites ADD uri TEXT");
258 db.execSQL("ALTER TABLE favorites ADD displayMode INTEGER");
259 db.setTransactionSuccessful();
261 db.endTransaction();
268 db.beginTransaction();
270 createSecureTable(db);
271 db.setTransactionSuccessful();
273 db.endTransaction();
312 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_SECURE, settingsToMove, false);
323 db.beginTransaction();
325 db.execSQL("DELETE FROM system WHERE name='"
330 db.execSQL("INSERT INTO system ('name', 'value') values ('"
333 db.setTransactionSuccessful();
335 db.endTransaction();
347 db.beginTransaction();
349 db.execSQL("UPDATE bookmarks SET folder = '@quicklaunch'");
350 db.execSQL("UPDATE bookmarks SET title = ''");
351 db.setTransactionSuccessful();
353 db.endTransaction();
363 db.beginTransaction();
366 db.execSQL("DELETE FROM system WHERE name='"
368 db.execSQL("DELETE FROM system WHERE name='"
370 stmt = db.compileStatement("INSERT INTO system(name,value)"
373 db.setTransactionSuccessful();
375 db.endTransaction();
386 db.beginTransaction();
388 db.execSQL("INSERT OR IGNORE INTO secure(name,value) values('" +
391 db.setTransactionSuccessful();
393 db.endTransaction();
401 db.beginTransaction();
403 db.execSQL("INSERT INTO system(name,value) values('zoom','2');");
404 db.setTransactionSuccessful();
406 db.endTransaction();
412 db.beginTransaction();
415 stmt = db.compileStatement("INSERT OR IGNORE INTO secure(name,value)"
418 db.setTransactionSuccessful();
420 db.endTransaction();
436 db.beginTransaction();
438 db.execSQL("DELETE FROM system WHERE name='"
444 db.execSQL("INSERT INTO system ('name', 'value') values ('"
447 db.setTransactionSuccessful();
449 db.endTransaction();
455 db.beginTransaction();
458 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
462 db.setTransactionSuccessful();
464 db.endTransaction();
471 db.beginTransaction();
475 db.execSQL("INSERT OR IGNORE INTO secure(name,value) values('" +
477 db.setTransactionSuccessful();
479 db.endTransaction();
486 upgradeAutoBrightness(db);
494 db.beginTransaction();
497 db.execSQL("DELETE FROM system WHERE name='"
499 db.execSQL("DELETE FROM system WHERE name='"
501 stmt = db.compileStatement("INSERT INTO system(name,value)"
504 db.setTransactionSuccessful();
506 db.endTransaction();
516 db.beginTransaction();
519 db.execSQL("DELETE FROM system WHERE name='"
521 stmt = db.compileStatement("INSERT INTO system(name,value)"
524 db.setTransactionSuccessful();
526 db.endTransaction();
536 db.beginTransaction();
539 stmt = db.compileStatement("INSERT INTO system(name,value)"
543 db.setTransactionSuccessful();
545 db.endTransaction();
555 db.beginTransaction();
558 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
562 db.setTransactionSuccessful();
564 db.endTransaction();
574 db.execSQL("DROP TABLE IF EXISTS gservices");
575 db.execSQL("DROP INDEX IF EXISTS gservicesIndex1");
583 db.beginTransaction();
585 db.execSQL("INSERT INTO secure(name,value) values('" +
587 db.execSQL("INSERT INTO secure(name,value) values('" +
589 db.execSQL("INSERT INTO secure(name,value) values('" +
591 db.execSQL("INSERT INTO secure(name,value) values('" +
593 db.setTransactionSuccessful();
595 db.endTransaction();
605 db.beginTransaction();
607 db.execSQL("DELETE FROM system WHERE name='lockscreen.password_type';");
608 db.setTransactionSuccessful();
610 db.endTransaction();
621 db.beginTransaction();
623 db.execSQL("DELETE FROM system WHERE name='lockscreen.password_type';");
624 db.setTransactionSuccessful();
626 db.endTransaction();
643 db.beginTransaction();
646 stmt = db.compileStatement("INSERT INTO system(name,value)"
649 db.setTransactionSuccessful();
651 db.endTransaction();
678 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_SECURE, settingsToMove, false);
684 db.beginTransaction();
687 stmt = db.compileStatement("INSERT INTO system(name,value)"
691 db.setTransactionSuccessful();
693 db.endTransaction();
711 db.beginTransaction();
713 upgradeScreenTimeoutFromNever(db);
714 db.setTransactionSuccessful();
716 db.endTransaction();
728 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_SECURE, settingsToMove, false);
729 db.beginTransaction();
732 stmt = db.compileStatement("INSERT INTO system(name,value)"
737 db.setTransactionSuccessful();
739 db.endTransaction();
749 db.beginTransaction();
752 db.execSQL("DELETE FROM system WHERE name='"
754 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
758 db.setTransactionSuccessful();
760 db.endTransaction();
774 db.beginTransaction();
777 stmt = db.compileStatement("INSERT INTO secure(name,value)"
782 stmt = db.compileStatement("INSERT INTO secure(name,value)"
786 db.setTransactionSuccessful();
788 db.endTransaction();
796 int autoTimeValue = getIntValueFromSystem(db, Settings.System.AUTO_TIME, 0);
797 db.beginTransaction();
800 stmt = db.compileStatement("INSERT INTO system(name,value)" + " VALUES(?,?);");
803 db.setTransactionSuccessful();
805 db.endTransaction();
813 db.beginTransaction();
816 stmt = db.compileStatement("INSERT INTO system(name,value)"
820 db.setTransactionSuccessful();
822 db.endTransaction();
831 // upgradeScreenTimeout(db);
838 // upgradeScreenTimeout(db);
846 // upgradeAutoBrightness(db);
853 db.beginTransaction();
855 db.execSQL("DELETE FROM system WHERE name='"
862 db.execSQL("INSERT INTO system ('name', 'value') values ('"
865 db.setTransactionSuccessful();
867 db.endTransaction();
874 db.beginTransaction();
877 stmt = db.compileStatement("INSERT INTO secure(name,value)"
882 db.setTransactionSuccessful();
884 db.endTransaction();
896 db.beginTransaction();
899 db.execSQL("DELETE FROM system WHERE name='"
901 db.execSQL("DELETE FROM system WHERE name='"
903 stmt = db.compileStatement("INSERT INTO system(name,value)"
906 db.setTransactionSuccessful();
908 db.endTransaction();
917 db.beginTransaction();
927 db.execSQL("DELETE FROM system WHERE name='"
929 db.execSQL("INSERT INTO system ('name', 'value') values ('"
932 db.setTransactionSuccessful();
934 db.endTransaction();
941 db.beginTransaction();
944 stmt = db.compileStatement("INSERT INTO secure(name,value)"
949 db.setTransactionSuccessful();
951 db.endTransaction();
959 db.beginTransaction();
961 db.execSQL("DELETE FROM system WHERE name='"
963 db.setTransactionSuccessful();
965 db.endTransaction();
976 db.beginTransaction();
978 db.execSQL("UPDATE system SET value='" + airplaneRadios + "' " +
980 db.execSQL("UPDATE system SET value='" + toggleableRadios + "' " +
982 db.setTransactionSuccessful();
984 db.endTransaction();
991 loadBookmarks(db);
997 db.beginTransaction();
1000 stmt = db.compileStatement("INSERT INTO secure(name,value)"
1004 db.setTransactionSuccessful();
1006 db.endTransaction();
1014 db.beginTransaction();
1017 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
1021 db.setTransactionSuccessful();
1023 db.endTransaction();
1030 upgradeVibrateSettingFromNone(db);
1036 db.beginTransaction();
1039 stmt = db.compileStatement("INSERT INTO secure(name,value) VALUES(?,?);");
1042 db.setTransactionSuccessful();
1044 db.endTransaction();
1050 db.beginTransaction();
1054 c = db.query(TABLE_SECURE, new String[] {"_id", "value"},
1059 stmt = db.compileStatement("INSERT INTO system(name,value)"
1064 db.setTransactionSuccessful();
1066 db.endTransaction();
1077 db.beginTransaction();
1079 db.execSQL("DELETE FROM system WHERE name='"
1081 db.setTransactionSuccessful();
1083 db.endTransaction();
1091 loadVibrateWhenRingingSetting(db);
1098 db.beginTransaction();
1101 stmt = db.compileStatement("INSERT OR REPLACE INTO secure(name,value)"
1105 db.setTransactionSuccessful();
1107 db.endTransaction();
1130 final boolean accessibilityEnabled = getIntValueFromTable(db, TABLE_SECURE,
1132 final boolean touchExplorationEnabled = getIntValueFromTable(db, TABLE_SECURE,
1135 String enabledServices = getStringValueFromTable(db, TABLE_SECURE,
1137 String touchExplorationGrantedServices = getStringValueFromTable(db, TABLE_SECURE,
1143 db.beginTransaction();
1144 stmt = db.compileStatement("INSERT OR REPLACE INTO secure(name,value)"
1149 db.setTransactionSuccessful();
1151 db.endTransaction();
1163 db.beginTransaction();
1166 stmt = db.compileStatement("INSERT OR REPLACE INTO secure(name,value)"
1179 db.setTransactionSuccessful();
1181 db.endTransaction();
1189 db.beginTransaction();
1192 stmt = db.compileStatement("INSERT OR REPLACE INTO secure(name,value)"
1196 db.setTransactionSuccessful();
1198 db.endTransaction();
1208 db.beginTransaction();
1213 createGlobalTable(db);
1215 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_GLOBAL, settingsToMove, false);
1217 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, false);
1219 db.setTransactionSuccessful();
1221 db.endTransaction();
1232 db.beginTransaction();
1235 stmt = db.compileStatement("INSERT INTO secure(name,value) VALUES(?,?);");
1240 stmt = db.compileStatement("INSERT INTO secure(name,value) VALUES(?,?);");
1244 stmt = db.compileStatement("INSERT INTO secure(name,value) VALUES(?,?);");
1249 db.setTransactionSuccessful();
1251 db.endTransaction();
1259 db.beginTransaction();
1272 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, true);
1273 db.setTransactionSuccessful();
1275 db.endTransaction();
1284 db.beginTransaction();
1289 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_GLOBAL, settingsToMove, true);
1291 db.setTransactionSuccessful();
1293 db.endTransaction();
1301 db.beginTransaction();
1308 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, true);
1310 db.setTransactionSuccessful();
1312 db.endTransaction();
1320 db.beginTransaction();
1327 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, true);
1329 db.setTransactionSuccessful();
1331 db.endTransaction();
1339 db.beginTransaction();
1374 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, true);
1375 db.setTransactionSuccessful();
1377 db.endTransaction();
1385 db.beginTransaction();
1393 movePrefixedSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, prefixesToMove);
1395 db.setTransactionSuccessful();
1397 db.endTransaction();
1405 db.beginTransaction();
1425 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_GLOBAL, systemToGlobal, true);
1426 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, secureToGlobal, true);
1428 db.setTransactionSuccessful();
1430 db.endTransaction();
1438 db.beginTransaction();
1442 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_GLOBAL, settingsToMove, true);
1444 db.setTransactionSuccessful();
1446 db.endTransaction();
1455 stmt = db.compileStatement("INSERT OR IGNORE INTO secure(name,value)"
1461 int deviceProvisioned = getIntValueFromTable(db, TABLE_GLOBAL,
1479 db.beginTransaction();
1484 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_GLOBAL, settingsToMove, true);
1486 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, true);
1488 db.setTransactionSuccessful();
1490 db.endTransaction();
1502 db.execSQL("DROP TABLE IF EXISTS global");
1503 db.execSQL("DROP TABLE IF EXISTS globalIndex1");
1504 db.execSQL("DROP TABLE IF EXISTS system");
1505 db.execSQL("DROP INDEX IF EXISTS systemIndex1");
1506 db.execSQL("DROP TABLE IF EXISTS secure");
1507 db.execSQL("DROP INDEX IF EXISTS secureIndex1");
1508 db.execSQL("DROP TABLE IF EXISTS gservices");
1509 db.execSQL("DROP INDEX IF EXISTS gservicesIndex1");
1510 db.execSQL("DROP TABLE IF EXISTS bluetooth_devices");
1511 db.execSQL("DROP TABLE IF EXISTS bookmarks");
1512 db.execSQL("DROP INDEX IF EXISTS bookmarksIndex1");
1513 db.execSQL("DROP INDEX IF EXISTS bookmarksIndex2");
1514 db.execSQL("DROP TABLE IF EXISTS favorites");
1515 onCreate(db);
1517 // Added for diagnosing settings.db wipes after the fact
1519 db.execSQL("INSERT INTO secure(name,value) values('" +
1529 private void moveSettingsToNewTable(SQLiteDatabase db,
1536 db.beginTransaction();
1538 insertStmt = db.compileStatement("INSERT "
1542 deleteStmt = db.compileStatement("DELETE FROM " + sourceTable + " WHERE name=?");
1551 db.setTransactionSuccessful();
1553 db.endTransaction();
1568 SQLiteDatabase db, String sourceTable, String destTable, String[] prefixesToMove) {
1572 db.beginTransaction();
1574 insertStmt = db.compileStatement("INSERT INTO " + destTable
1577 deleteStmt = db.compileStatement(
1589 db.setTransactionSuccessful();
1591 db.endTransaction();
1601 private void upgradeLockPatternLocation(SQLiteDatabase db) {
1602 Cursor c = db.query(TABLE_SYSTEM, new String[] {"_id", "value"}, "name='lock_pattern'",
1619 db.delete(TABLE_SYSTEM, "name='lock_pattern'", null);
1625 private void upgradeScreenTimeoutFromNever(SQLiteDatabase db) {
1627 Cursor c = db.query(TABLE_SYSTEM, new String[] { "_id", "value" }, "name=? AND value=?",
1635 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
1649 private void upgradeVibrateSettingFromNone(SQLiteDatabase db) {
1650 int vibrateSetting = getIntValueFromSystem(db, Settings.System.VIBRATE_ON, 0);
1662 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
1671 private void upgradeScreenTimeout(SQLiteDatabase db) {
1673 db.beginTransaction();
1676 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
1680 db.setTransactionSuccessful();
1682 db.endTransaction();
1688 private void upgradeAutoBrightness(SQLiteDatabase db) {
1689 db.beginTransaction();
1694 db.execSQL("INSERT OR REPLACE INTO system(name,value) values('" +
1696 db.setTransactionSuccessful();
1698 db.endTransaction();
1705 * @param db The database to write the values into
1707 private void loadBookmarks(SQLiteDatabase db) {
1777 db.delete("bookmarks", "shortcut = ?",
1779 db.insert("bookmarks", null, values);
1792 * @param db the database to insert the volume levels into
1794 private void loadVolumeLevels(SQLiteDatabase db) {
1797 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
1846 loadVibrateWhenRingingSetting(db);
1849 private void loadVibrateSetting(SQLiteDatabase db, boolean deleteOld) {
1851 db.execSQL("DELETE FROM system WHERE name='" + Settings.System.VIBRATE_ON + "'");
1856 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
1872 private void loadVibrateWhenRingingSetting(SQLiteDatabase db) {
1876 int vibrateSetting = getIntValueFromSystem(db, Settings.System.VIBRATE_ON,
1882 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
1890 private void loadSettings(SQLiteDatabase db) {
1891 loadSystemSettings(db);
1892 loadSecureSettings(db);
1895 loadGlobalSettings(db);
1899 private void loadSystemSettings(SQLiteDatabase db) {
1902 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
1968 private void loadSecureSettings(SQLiteDatabase db) {
1971 stmt = db.compileStatement("INSERT OR IGNORE INTO secure(name,value)"
2065 private void loadGlobalSettings(SQLiteDatabase db) {
2068 stmt = db.compileStatement("INSERT OR IGNORE INTO global(name,value)"
2235 private int getIntValueFromSystem(SQLiteDatabase db, String name, int defaultValue) {
2236 return getIntValueFromTable(db, TABLE_SYSTEM, name, defaultValue);
2239 private int getIntValueFromTable(SQLiteDatabase db, String table, String name,
2241 String value = getStringValueFromTable(db, table, name, null);
2245 private String getStringValueFromTable(SQLiteDatabase db, String table, String name,
2249 c = db.query(table, new String[] { Settings.System.VALUE }, "name='" + name + "'",