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);
186 // Load initial volume levels into 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
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();
1548 db.execSQL("DROP TABLE IF EXISTS global");
1549 db.execSQL("DROP TABLE IF EXISTS globalIndex1");
1550 db.execSQL("DROP TABLE IF EXISTS system");
1551 db.execSQL("DROP INDEX IF EXISTS systemIndex1");
1552 db.execSQL("DROP TABLE IF EXISTS secure");
1553 db.execSQL("DROP INDEX IF EXISTS secureIndex1");
1554 db.execSQL("DROP TABLE IF EXISTS gservices");
1555 db.execSQL("DROP INDEX IF EXISTS gservicesIndex1");
1556 db.execSQL("DROP TABLE IF EXISTS bluetooth_devices");
1557 db.execSQL("DROP TABLE IF EXISTS bookmarks");
1558 db.execSQL("DROP INDEX IF EXISTS bookmarksIndex1");
1559 db.execSQL("DROP INDEX IF EXISTS bookmarksIndex2");
1560 db.execSQL("DROP TABLE IF EXISTS favorites");
1561 onCreate(db);
1563 db wipes after the fact
1565 db.execSQL("INSERT INTO secure(name,value) values('" +
1575 private void moveSettingsToNewTable(SQLiteDatabase db,
1582 db.beginTransaction();
1584 insertStmt = db.compileStatement("INSERT "
1588 deleteStmt = db.compileStatement("DELETE FROM " + sourceTable + " WHERE name=?");
1597 db.setTransactionSuccessful();
1599 db.endTransaction();
1614 SQLiteDatabase db, String sourceTable, String destTable, String[] prefixesToMove) {
1618 db.beginTransaction();
1620 insertStmt = db.compileStatement("INSERT INTO " + destTable
1623 deleteStmt = db.compileStatement(
1635 db.setTransactionSuccessful();
1637 db.endTransaction();
1647 private void upgradeLockPatternLocation(SQLiteDatabase db) {
1648 Cursor c = db.query(TABLE_SYSTEM, new String[] {"_id", "value"}, "name='lock_pattern'",
1665 db.delete(TABLE_SYSTEM, "name='lock_pattern'", null);
1671 private void upgradeScreenTimeoutFromNever(SQLiteDatabase db) {
1673 Cursor c = db.query(TABLE_SYSTEM, new String[] { "_id", "value" }, "name=? AND value=?",
1681 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
1695 private void upgradeVibrateSettingFromNone(SQLiteDatabase db) {
1696 int vibrateSetting = getIntValueFromSystem(db, Settings.System.VIBRATE_ON, 0);
1708 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
1717 private void upgradeScreenTimeout(SQLiteDatabase db) {
1719 db.beginTransaction();
1722 stmt = db.compileStatement("INSERT OR REPLACE INTO system(name,value)"
1726 db.setTransactionSuccessful();
1728 db.endTransaction();
1734 private void upgradeAutoBrightness(SQLiteDatabase db) {
1735 db.beginTransaction();
1740 db.execSQL("INSERT OR REPLACE INTO system(name,value) values('" +
1742 db.setTransactionSuccessful();
1744 db.endTransaction();
1751 * @param db The database to write the values into
1753 private void loadBookmarks(SQLiteDatabase db) {
1823 db.delete("bookmarks", "shortcut = ?",
1825 db.insert("bookmarks", null, values);
1838 * @param db the database to insert the volume levels into
1840 private void loadVolumeLevels(SQLiteDatabase db) {
1843 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
1892 loadVibrateWhenRingingSetting(db);
1895 private void loadVibrateSetting(SQLiteDatabase db, boolean deleteOld) {
1897 db.execSQL("DELETE FROM system WHERE name='" + Settings.System.VIBRATE_ON + "'");
1902 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
1918 private void loadVibrateWhenRingingSetting(SQLiteDatabase db) {
1922 int vibrateSetting = getIntValueFromSystem(db, Settings.System.VIBRATE_ON,
1928 stmt = db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
1936 private void loadSettings(SQLiteDatabase db) {
1937 loadSystemSettings(db);
1938 loadSecureSettings(db);
1941 loadGlobalSettings(db);
1945 private void loadSystemSettings(SQLiteDatabase db) {
1948 db.compileStatement("INSERT OR IGNORE INTO system(name,value)"
2014 private void loadSecureSettings(SQLiteDatabase db) {
2017 stmt = db.compileStatement("INSERT OR IGNORE INTO secure(name,value)"
2111 private void loadGlobalSettings(SQLiteDatabase db) {
2114 stmt = db.compileStatement("INSERT OR IGNORE INTO global(name,value)"
2283 private int getIntValueFromSystem(SQLiteDatabase db, String name, int defaultValue) {
2284 return getIntValueFromTable(db, TABLE_SYSTEM, name, defaultValue);
2287 private int getIntValueFromTable(SQLiteDatabase db, String table, String name,
2289 String value = getStringValueFromTable(db, table, name, null);
2293 private String getStringValueFromTable(SQLiteDatabase db, String table, String name,
2297 c = db.query(table, new String[] { Settings.System.VALUE }, "name='" + name + "'",
