Lines Matching refs:db
68 private static final String DATABASE_NAME = "settings.db";
99 // The owner gets the unadorned db name;
121 private void createSecureTable(SQLiteDatabase db) {
122 db.execSQL("CREATE TABLE secure (" +
127 db.execSQL("CREATE INDEX secureIndex1 ON secure (name);");
130 private void createGlobalTable(SQLiteDatabase db) {
131 db.execSQL("CREATE TABLE global (" +
136 db.execSQL("CREATE INDEX globalIndex1 ON global (name);");
140 public void onCreate(SQLiteDatabase db) {
141 db.execSQL("CREATE TABLE system (" +
146 db.execSQL("CREATE INDEX systemIndex1 ON system (name);");
148 createSecureTable(db);
152 createGlobalTable(db);
155 db.execSQL("CREATE TABLE bluetooth_devices (" +
163 db.execSQL("CREATE TABLE bookmarks (" +
172 db.execSQL("CREATE INDEX bookmarksIndex1 ON bookmarks (folder);");
173 db.execSQL("CREATE INDEX bookmarksIndex2 ON bookmarks (shortcut);");
183 loadBookmarks(db);
187 loadVolumeLevels(db);
190 loadSettings(db);
194 public void onUpgrade(SQLiteDatabase db, int oldVersion, int currentVersion) {
214 loadVibrateSetting(db, true);
222 upgradeLockPatternLocation(db);
226 db.execSQL("UPDATE favorites SET iconResource=0 WHERE iconType=0");
231 db.beginTransaction();
233 db.execSQL("ALTER TABLE favorites ADD spanX INTEGER");
234 db.execSQL("ALTER TABLE favorites ADD spanY INTEGER");
236 db.execSQL("UPDATE favorites SET spanX=1, spanY=1 WHERE itemType<=0");
238 db.execSQL(
241 db.execSQL("UPDATE favorites SET spanX=4, spanY=1 WHERE itemType=1001");
242 db.setTransactionSuccessful();
244 db.endTransaction();
250 db.beginTransaction();
254 db.execSQL("DELETE FROM system WHERE name='network_preference'");
255 db.execSQL("INSERT INTO system ('name', 'value') values ('network_preference', '" +
257 db.setTransactionSuccessful();
259 db.endTransaction();
265 db.beginTransaction();
267 db.execSQL("ALTER TABLE favorites ADD uri TEXT");
268 db.execSQL("ALTER TABLE favorites ADD displayMode INTEGER");
269 db.setTransactionSuccessful();
271 db.endTransaction();
278 db.beginTransaction();
280 createSecureTable(db);
281 db.setTransactionSuccessful();
283 db.endTransaction();
322 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_SECURE, settingsToMove, false);
333 db.beginTransaction();
335 db.execSQL("DELETE FROM system WHERE name='"
340 db.execSQL("INSERT INTO system ('name', 'value') values ('"
343 db.setTransactionSuccessful();
345 db.endTransaction();
357 db.beginTransaction();
359 db.execSQL("UPDATE bookmarks SET folder = '@quicklaunch'");
360 db.execSQL("UPDATE bookmarks SET title = ''");
361 db.setTransactionSuccessful();
363 db.endTransaction();
373 db.beginTransaction();
376 db.execSQL("DELETE FROM system WHERE name='"
378 db.execSQL("DELETE FROM system WHERE name='"
380 stmt = db.compileStatement("INSERT INTO system(name,value)"
383 db.setTransactionSuccessful();
385 db.endTransaction();
396 db.beginTransaction();
398 db.execSQL("INSERT OR IGNORE INTO secure(name,value) values('" +
401 db.setTransactionSuccessful();
403 db.endTransaction();
411 db.beginTransaction();
413 db.execSQL("INSERT INTO system(name,value) values('zoom','2');");
414 db.setTransactionSuccessful();
416 db.endTransaction();
422 db.beginTransaction();
425 stmt = db.compileStatement("INSERT OR IGNORE INTO secure(name,value)"
428 db.setTransactionSuccessful();
430 db.endTransaction();
446 db.beginTransaction();
448 db.execSQL("DELETE FROM system WHERE name='"
454 db.execSQL("INSERT INTO system ('name', 'value') values ('"
457 db.setTransactionSuccessful();
459 db.endTransaction();
465 db.beginTransaction();
468 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
472 db.setTransactionSuccessful();
474 db.endTransaction();
481 db.beginTransaction();
485 db.execSQL("INSERT OR IGNORE INTO secure(name,value) values('" +
487 db.setTransactionSuccessful();
489 db.endTransaction();
496 upgradeAutoBrightness(db);
504 db.beginTransaction();
507 db.execSQL("DELETE FROM system WHERE name='"
509 db.execSQL("DELETE FROM system WHERE name='"
511 stmt = db.compileStatement("INSERT INTO system(name,value)"
514 db.setTransactionSuccessful();
516 db.endTransaction();
526 db.beginTransaction();
529 db.execSQL("DELETE FROM system WHERE name='"
531 stmt = db.compileStatement("INSERT INTO system(name,value)"
534 db.setTransactionSuccessful();
536 db.endTransaction();
546 db.beginTransaction();
549 stmt = db.compileStatement("INSERT INTO system(name,value)"
553 db.setTransactionSuccessful();
555 db.endTransaction();
565 db.beginTransaction();
568 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
572 db.setTransactionSuccessful();
574 db.endTransaction();
584 db.execSQL("DROP TABLE IF EXISTS gservices");
585 db.execSQL("DROP INDEX IF EXISTS gservicesIndex1");
593 db.beginTransaction();
595 db.execSQL("INSERT INTO secure(name,value) values('" +
597 db.execSQL("INSERT INTO secure(name,value) values('" +
599 db.execSQL("INSERT INTO secure(name,value) values('" +
601 db.execSQL("INSERT INTO secure(name,value) values('" +
603 db.setTransactionSuccessful();
605 db.endTransaction();
615 db.beginTransaction();
617 db.execSQL("DELETE FROM system WHERE name='lockscreen.password_type';");
618 db.setTransactionSuccessful();
620 db.endTransaction();
631 db.beginTransaction();
633 db.execSQL("DELETE FROM system WHERE name='lockscreen.password_type';");
634 db.setTransactionSuccessful();
636 db.endTransaction();
653 db.beginTransaction();
656 stmt = db.compileStatement("INSERT INTO system(name,value)"
659 db.setTransactionSuccessful();
661 db.endTransaction();
688 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_SECURE, settingsToMove, false);
694 db.beginTransaction();
697 stmt = db.compileStatement("INSERT INTO system(name,value)"
701 db.setTransactionSuccessful();
703 db.endTransaction();
721 db.beginTransaction();
723 upgradeScreenTimeoutFromNever(db);
724 db.setTransactionSuccessful();
726 db.endTransaction();
738 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_SECURE, settingsToMove, false);
739 db.beginTransaction();
742 stmt = db.compileStatement("INSERT INTO system(name,value)"
747 db.setTransactionSuccessful();
749 db.endTransaction();
759 db.beginTransaction();
762 db.execSQL("DELETE FROM system WHERE name='"
764 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
768 db.setTransactionSuccessful();
770 db.endTransaction();
784 db.beginTransaction();
787 stmt = db.compileStatement("INSERT INTO secure(name,value)"
792 stmt = db.compileStatement("INSERT INTO secure(name,value)"
796 db.setTransactionSuccessful();
798 db.endTransaction();
806 int autoTimeValue = getIntValueFromSystem(db, Settings.System.AUTO_TIME, 0);
807 db.beginTransaction();
810 stmt = db.compileStatement("INSERT INTO system(name,value)" + " VALUES(?,?);");
813 db.setTransactionSuccessful();
815 db.endTransaction();
823 db.beginTransaction();
826 stmt = db.compileStatement("INSERT INTO system(name,value)"
830 db.setTransactionSuccessful();
832 db.endTransaction();
841 // upgradeScreenTimeout(db);
848 // upgradeScreenTimeout(db);
856 // upgradeAutoBrightness(db);
863 db.beginTransaction();
865 db.execSQL("DELETE FROM system WHERE name='"
872 db.execSQL("INSERT INTO system ('name', 'value') values ('"
875 db.setTransactionSuccessful();
877 db.endTransaction();
884 db.beginTransaction();
887 stmt = db.compileStatement("INSERT INTO secure(name,value)"
892 db.setTransactionSuccessful();
894 db.endTransaction();
906 db.beginTransaction();
909 db.execSQL("DELETE FROM system WHERE name='"
911 db.execSQL("DELETE FROM system WHERE name='"
913 stmt = db.compileStatement("INSERT INTO system(name,value)"
916 db.setTransactionSuccessful();
918 db.endTransaction();
927 db.beginTransaction();
937 db.execSQL("DELETE FROM system WHERE name='"
939 db.execSQL("INSERT INTO system ('name', 'value') values ('"
942 db.setTransactionSuccessful();
944 db.endTransaction();
951 db.beginTransaction();
954 stmt = db.compileStatement("INSERT INTO secure(name,value)"
959 db.setTransactionSuccessful();
961 db.endTransaction();
969 db.beginTransaction();
971 db.execSQL("DELETE FROM system WHERE name='"
973 db.setTransactionSuccessful();
975 db.endTransaction();
986 db.beginTransaction();
988 db.execSQL("UPDATE system SET value='" + airplaneRadios + "' " +
990 db.execSQL("UPDATE system SET value='" + toggleableRadios + "' " +
992 db.setTransactionSuccessful();
994 db.endTransaction();
1001 loadBookmarks(db);
1007 db.beginTransaction();
1010 stmt = db.compileStatement("INSERT INTO secure(name,value)"
1014 db.setTransactionSuccessful();
1016 db.endTransaction();
1024 db.beginTransaction();
1027 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
1031 db.setTransactionSuccessful();
1033 db.endTransaction();
1040 upgradeVibrateSettingFromNone(db);
1046 db.beginTransaction();
1049 stmt = db.compileStatement("INSERT INTO secure(name,value) VALUES(?,?);");
1052 db.setTransactionSuccessful();
1054 db.endTransaction();
1060 db.beginTransaction();
1064 c = db.query(TABLE_SECURE, new String[] {"_id", "value"},
1069 stmt = db.compileStatement("INSERT INTO system(name,value)"
1074 db.setTransactionSuccessful();
1076 db.endTransaction();
1087 db.beginTransaction();
1089 db.execSQL("DELETE FROM system WHERE name='"
1091 db.setTransactionSuccessful();
1093 db.endTransaction();
1101 loadVibrateWhenRingingSetting(db);
1108 db.beginTransaction();
1111 stmt = db.compileStatement("INSERT OR REPLACE INTO secure(name,value)"
1115 db.setTransactionSuccessful();
1117 db.endTransaction();
1140 final boolean accessibilityEnabled = getIntValueFromTable(db, TABLE_SECURE,
1142 final boolean touchExplorationEnabled = getIntValueFromTable(db, TABLE_SECURE,
1145 String enabledServices = getStringValueFromTable(db, TABLE_SECURE,
1147 String touchExplorationGrantedServices = getStringValueFromTable(db, TABLE_SECURE,
1153 db.beginTransaction();
1154 stmt = db.compileStatement("INSERT OR REPLACE INTO secure(name,value)"
1159 db.setTransactionSuccessful();
1161 db.endTransaction();
1173 db.beginTransaction();
1176 stmt = db.compileStatement("INSERT OR REPLACE INTO secure(name,value)"
1189 db.setTransactionSuccessful();
1191 db.endTransaction();
1199 db.beginTransaction();
1202 stmt = db.compileStatement("INSERT OR REPLACE INTO secure(name,value)"
1206 db.setTransactionSuccessful();
1208 db.endTransaction();
1218 db.beginTransaction();
1223 createGlobalTable(db);
1225 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_GLOBAL, settingsToMove, false);
1227 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, false);
1229 db.setTransactionSuccessful();
1231 db.endTransaction();
1242 db.beginTransaction();
1245 stmt = db.compileStatement("INSERT INTO secure(name,value) VALUES(?,?);");
1250 stmt = db.compileStatement("INSERT INTO secure(name,value) VALUES(?,?);");
1254 stmt = db.compileStatement("INSERT INTO secure(name,value) VALUES(?,?);");
1259 db.setTransactionSuccessful();
1261 db.endTransaction();
1269 db.beginTransaction();
1282 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, true);
1283 db.setTransactionSuccessful();
1285 db.endTransaction();
1294 db.beginTransaction();
1299 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_GLOBAL, settingsToMove, true);
1301 db.setTransactionSuccessful();
1303 db.endTransaction();
1311 db.beginTransaction();
1318 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, true);
1320 db.setTransactionSuccessful();
1322 db.endTransaction();
1330 db.beginTransaction();
1337 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, true);
1339 db.setTransactionSuccessful();
1341 db.endTransaction();
1349 db.beginTransaction();
1384 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, true);
1385 db.setTransactionSuccessful();
1387 db.endTransaction();
1395 db.beginTransaction();
1403 movePrefixedSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, prefixesToMove);
1405 db.setTransactionSuccessful();
1407 db.endTransaction();
1415 db.beginTransaction();
1435 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_GLOBAL, systemToGlobal, true);
1436 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, secureToGlobal, true);
1438 db.setTransactionSuccessful();
1440 db.endTransaction();
1448 db.beginTransaction();
1452 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_GLOBAL, settingsToMove, true);
1454 db.setTransactionSuccessful();
1456 db.endTransaction();
1465 stmt = db.compileStatement("INSERT OR IGNORE INTO secure(name,value)"
1471 int deviceProvisioned = getIntValueFromTable(db, TABLE_GLOBAL,
1489 db.beginTransaction();
1493 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_GLOBAL, settingsToMove, true);
1495 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, true);
1497 db.setTransactionSuccessful();
1499 db.endTransaction();
1508 db.beginTransaction();
1511 stmt = db.compileStatement("INSERT OR REPLACE INTO global(name,value)"
1515 db.setTransactionSuccessful();
1517 db.endTransaction();
1526 db.beginTransaction();
1529 moveSettingsToNewTable(db, TABLE_SECURE, TABLE_GLOBAL, settingsToMove, true);
1530 db.setTransactionSuccessful();
1532 db.endTransaction();
1545 db.beginTransaction();
1548 stmt = db.compileStatement("INSERT OR REPLACE INTO global(name,value)"
1552 db.setTransactionSuccessful();
1554 db.endTransaction();
1574 db.beginTransaction();
1577 stmt = db.compileStatement("INSERT OR REPLACE INTO global(name,value)"
1581 db.setTransactionSuccessful();
1583 db.endTransaction();
1592 db.beginTransaction();
1595 stmt = db.compileStatement("INSERT OR IGNORE INTO global(name,value)"
1598 db.setTransactionSuccessful();
1600 db.endTransaction();
1608 db.beginTransaction();
1619 moveSettingsToNewTable(db, TABLE_GLOBAL, TABLE_SECURE, globalToSecure, true);
1623 stmt = db.compileStatement("INSERT OR IGNORE INTO secure(name,value)"
1628 db.setTransactionSuccessful();
1630 db.endTransaction();
1637 db.beginTransaction();
1640 stmt = db.compileStatement("INSERT OR REPLACE INTO secure(name,value)"
1644 db.setTransactionSuccessful();
1646 db.endTransaction();
1654 db.beginTransaction();
1657 stmt = db.compileStatement("INSERT OR IGNORE INTO global(name,value)"
1661 db.setTransactionSuccessful();
1663 db.endTransaction();
1672 db.beginTransaction();
1675 stmt = db.compileStatement("INSERT OR IGNORE INTO secure(name,value)"
1680 final int oldShow = getIntValueFromTable(db,
1686 = db.compileStatement("DELETE FROM global WHERE name=?");
1691 db.setTransactionSuccessful();
1693 db.endTransaction();
1702 db.beginTransaction();
1705 stmt = db.compileStatement("INSERT OR REPLACE INTO global(name,value)"
1709 db.setTransactionSuccessful();
1711 db.endTransaction();
1722 db.beginTransaction();
1725 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
1729 db.setTransactionSuccessful();
1731 db.endTransaction();
1738 db.beginTransaction();
1741 stmt = db.compileStatement("INSERT OR IGNORE INTO secure(name,value)"
1745 db.setTransactionSuccessful();
1747 db.endTransaction();
1757 db.beginTransaction();
1760 stmt = db.compileStatement("UPDATE system SET value = ? " +
1766 db.setTransactionSuccessful();
1768 db.endTransaction();
1777 db.beginTransaction();
1780 stmt = db.compileStatement("INSERT OR REPLACE INTO global(name,value)"
1783 db.setTransactionSuccessful();
1785 db.endTransaction();
1797 db.beginTransaction();
1800 stmt = db.compileStatement("UPDATE global SET value = ? "
1806 db.setTransactionSuccessful();
1808 db.endTransaction();
1816 db.beginTransaction();
1819 stmt = db.compileStatement("INSERT OR IGNORE INTO secure(name,value)"
1823 db.setTransactionSuccessful();
1825 db.endTransaction();
1835 db.beginTransaction();
1838 stmt = db.compileStatement("INSERT OR IGNORE INTO global(name,value)"
1842 db.setTransactionSuccessful();
1844 db.endTransaction();
1853 db.beginTransaction();
1856 stmt = db.compileStatement("INSERT OR IGNORE INTO global(name,value)"
1859 db.setTransactionSuccessful();
1861 db.endTransaction();
1869 db.beginTransaction();
1874 moveSettingsToNewTable(db, TABLE_SYSTEM, TABLE_SECURE, systemToSecure, true);
1875 db.setTransactionSuccessful();
1877 db.endTransaction();
1885 db.beginTransaction();
1888 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
1891 db.setTransactionSuccessful();
1893 db.endTransaction();
1903 db.execSQL("DROP TABLE IF EXISTS global");
1904 db.execSQL("DROP TABLE IF EXISTS globalIndex1");
1905 db.execSQL("DROP TABLE IF EXISTS system");
1906 db.execSQL("DROP INDEX IF EXISTS systemIndex1");
1907 db.execSQL("DROP TABLE IF EXISTS secure");
1908 db.execSQL("DROP INDEX IF EXISTS secureIndex1");
1909 db.execSQL("DROP TABLE IF EXISTS gservices");
1910 db.execSQL("DROP INDEX IF EXISTS gservicesIndex1");
1911 db.execSQL("DROP TABLE IF EXISTS bluetooth_devices");
1912 db.execSQL("DROP TABLE IF EXISTS bookmarks");
1913 db.execSQL("DROP INDEX IF EXISTS bookmarksIndex1");
1914 db.execSQL("DROP INDEX IF EXISTS bookmarksIndex2");
1915 db.execSQL("DROP TABLE IF EXISTS favorites");
1916 onCreate(db);
1918 // Added for diagnosing settings.db wipes after the fact
1920 db.execSQL("INSERT INTO secure(name,value) values('" +
1930 private void moveSettingsToNewTable(SQLiteDatabase db,
1937 db.beginTransaction();
1939 insertStmt = db.compileStatement("INSERT "
1943 deleteStmt = db.compileStatement("DELETE FROM " + sourceTable + " WHERE name=?");
1952 db.setTransactionSuccessful();
1954 db.endTransaction();
1969 SQLiteDatabase db, String sourceTable, String destTable, String[] prefixesToMove) {
1973 db.beginTransaction();
1975 insertStmt = db.compileStatement("INSERT INTO " + destTable
1978 deleteStmt = db.compileStatement(
1990 db.setTransactionSuccessful();
1992 db.endTransaction();
2002 private void upgradeLockPatternLocation(SQLiteDatabase db) {
2003 Cursor c = db.query(TABLE_SYSTEM, new String[] {"_id", "value"}, "name='lock_pattern'",
2020 db.delete(TABLE_SYSTEM, "name='lock_pattern'", null);
2026 private void upgradeScreenTimeoutFromNever(SQLiteDatabase db) {
2028 Cursor c = db.query(TABLE_SYSTEM, new String[] { "_id", "value" }, "name=? AND value=?",
2036 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
2050 private void upgradeVibrateSettingFromNone(SQLiteDatabase db) {
2051 int vibrateSetting = getIntValueFromSystem(db, Settings.System.VIBRATE_ON, 0);
2063 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
2072 private void upgradeScreenTimeout(SQLiteDatabase db) {
2074 db.beginTransaction();
2077 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
2081 db.setTransactionSuccessful();
2083 db.endTransaction();
2089 private void upgradeAutoBrightness(SQLiteDatabase db) {
2090 db.beginTransaction();
2095 db.execSQL("INSERT OR REPLACE INTO system(name,value) values('" +
2097 db.setTransactionSuccessful();
2099 db.endTransaction();
2106 * @param db The database to write the values into
2108 private void loadBookmarks(SQLiteDatabase db) {
2178 db.delete("bookmarks", "shortcut = ?",
2180 db.insert("bookmarks", null, values);
2193 * @param db the database to insert the volume levels into
2195 private void loadVolumeLevels(SQLiteDatabase db) {
2198 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
2247 loadVibrateWhenRingingSetting(db);
2250 private void loadVibrateSetting(SQLiteDatabase db, boolean deleteOld) {
2252 db.execSQL("DELETE FROM system WHERE name='" + Settings.System.VIBRATE_ON + "'");
2257 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
2273 private void loadVibrateWhenRingingSetting(SQLiteDatabase db) {
2277 int vibrateSetting = getIntValueFromSystem(db, Settings.System.VIBRATE_ON,
2283 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
2291 private void loadSettings(SQLiteDatabase db) {
2292 loadSystemSettings(db);
2293 loadSecureSettings(db);
2296 loadGlobalSettings(db);
2300 private void loadSystemSettings(SQLiteDatabase db) {
2303 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
2369 private void loadSecureSettings(SQLiteDatabase db) {
2372 stmt = db.compileStatement("INSERT OR IGNORE INTO secure(name,value)"
2484 private void loadGlobalSettings(SQLiteDatabase db) {
2487 stmt = db.compileStatement("INSERT OR IGNORE INTO global(name,value)"
2677 private int getIntValueFromSystem(SQLiteDatabase db, String name, int defaultValue) {
2678 return getIntValueFromTable(db, TABLE_SYSTEM, name, defaultValue);
2681 private int getIntValueFromTable(SQLiteDatabase db, String table, String name,
2683 String value = getStringValueFromTable(db, table, name, null);
2687 private String getStringValueFromTable(SQLiteDatabase db, String table, String name,
2691 c = db.query(table, new String[] { Settings.System.VALUE }, "name='" + name + "'",