Lines Matching refs:db
126 SQLiteDatabase db = mOpenHelper.getWritableDatabase(); in query() local
127 Cursor result = qb.query(db, projection, args.where, args.args, null, null, sortOrder); in query()
134 SQLiteDatabase db, String table, String nullColumnHack, ContentValues values) { in dbInsertAndCheck() argument
138 return db.insert(table, nullColumnHack, values); in dbInsertAndCheck()
141 private static void deleteId(SQLiteDatabase db, long id) { in deleteId() argument
144 db.delete(args.table, args.where, args.args); in deleteId()
151 SQLiteDatabase db = mOpenHelper.getWritableDatabase(); in insert() local
152 final long rowId = dbInsertAndCheck(mOpenHelper, db, args.table, null, initialValues); in insert()
165 SQLiteDatabase db = mOpenHelper.getWritableDatabase(); in bulkInsert() local
166 db.beginTransaction(); in bulkInsert()
170 if (dbInsertAndCheck(mOpenHelper, db, args.table, null, values[i]) < 0) { in bulkInsert()
174 db.setTransactionSuccessful(); in bulkInsert()
176 db.endTransaction(); in bulkInsert()
187 SQLiteDatabase db = mOpenHelper.getWritableDatabase(); in delete() local
188 int count = db.delete(args.table, args.where, args.args); in delete()
198 SQLiteDatabase db = mOpenHelper.getWritableDatabase(); in update() local
199 int count = db.update(args.table, values, args.where, args.args); in update()
304 final SQLiteDatabase db = mOpenHelper.getWritableDatabase(); in deleteDatabase() local
305 final File dbFile = new File(db.getPath()); in deleteDatabase()
351 public void onCreate(SQLiteDatabase db) { in onCreate() argument
361 db.execSQL("CREATE TABLE favorites (" + in onCreate()
389 if (!convertDatabase(db)) { in onCreate()
403 private boolean convertDatabase(SQLiteDatabase db) { in convertDatabase() argument
421 converted = copyFromCursor(db, cursor) > 0; in convertDatabase()
434 convertWidgets(db); in convertDatabase()
440 private int copyFromCursor(SQLiteDatabase db, Cursor c) { in copyFromCursor() argument
478 db.beginTransaction(); in copyFromCursor()
483 if (dbInsertAndCheck(this, db, TABLE_FAVORITES, null, rows[i]) < 0) { in copyFromCursor()
489 db.setTransactionSuccessful(); in copyFromCursor()
491 db.endTransaction(); in copyFromCursor()
498 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { in onUpgrade() argument
504 db.beginTransaction(); in onUpgrade()
507 db.execSQL("ALTER TABLE favorites " + in onUpgrade()
509 db.setTransactionSuccessful(); in onUpgrade()
515 db.endTransaction(); in onUpgrade()
520 convertWidgets(db); in onUpgrade()
538 db.beginTransaction(); in onUpgrade()
540 db.execSQL("UPDATE favorites SET screen=(screen + 1);"); in onUpgrade()
541 db.setTransactionSuccessful(); in onUpgrade()
546 db.endTransaction(); in onUpgrade()
550 if (updateContactsShortcuts(db)) { in onUpgrade()
557 convertWidgets(db); in onUpgrade()
565 normalizeIcons(db); in onUpgrade()
573 mMaxId = initializeMaxId(db); in onUpgrade()
577 loadFavorites(db, R.xml.update_workspace); in onUpgrade()
588 updateContactsShortcuts(db); in onUpgrade()
594 if (addProfileColumn(db)) { in onUpgrade()
601 db.execSQL("DROP TABLE IF EXISTS " + TABLE_FAVORITES); in onUpgrade()
602 onCreate(db); in onUpgrade()
606 private boolean addProfileColumn(SQLiteDatabase db) { in addProfileColumn() argument
607 db.beginTransaction(); in addProfileColumn()
616 db.execSQL("ALTER TABLE favorites " + in addProfileColumn()
619 db.setTransactionSuccessful(); in addProfileColumn()
626 db.endTransaction(); in addProfileColumn()
630 private boolean updateContactsShortcuts(SQLiteDatabase db) { in updateContactsShortcuts() argument
636 db.beginTransaction(); in updateContactsShortcuts()
639 c = db.query(TABLE_FAVORITES, in updateContactsShortcuts()
685 db.update(TABLE_FAVORITES, values, updateWhere, null); in updateContactsShortcuts()
696 db.setTransactionSuccessful(); in updateContactsShortcuts()
701 db.endTransaction(); in updateContactsShortcuts()
710 private void normalizeIcons(SQLiteDatabase db) { in normalizeIcons() argument
713 db.beginTransaction(); in normalizeIcons()
718 update = db.compileStatement("UPDATE favorites " in normalizeIcons()
721 c = db.rawQuery("SELECT _id, icon FROM favorites WHERE iconType=" + in normalizeIcons()
752 db.setTransactionSuccessful(); in normalizeIcons()
756 db.endTransaction(); in normalizeIcons()
779 private long initializeMaxId(SQLiteDatabase db) { in initializeMaxId() argument
780 Cursor c = db.rawQuery("SELECT MAX(_id) FROM favorites", null); in initializeMaxId()
803 private void convertWidgets(SQLiteDatabase db) { in convertWidgets() argument
815 db.beginTransaction(); in convertWidgets()
818 c = db.query(TABLE_FAVORITES, new String[] { Favorites._ID, Favorites.ITEM_TYPE }, in convertWidgets()
850 db.update(TABLE_FAVORITES, values, updateWhere, null); in convertWidgets()
872 db.setTransactionSuccessful(); in convertWidgets()
876 db.endTransaction(); in convertWidgets()
907 private int loadFavorites(SQLiteDatabase db, int workspaceResourceId) { in loadFavorites() argument
960 long id = addAppShortcut(db, values, a, packageManager, intent); in loadFavorites()
963 added = addSearchWidget(db, values); in loadFavorites()
965 added = addClockWidget(db, values); in loadFavorites()
967 added = addAppWidget(parser, attrs, type, db, values, a, packageManager); in loadFavorites()
969 long id = addUriShortcut(db, values, a); in loadFavorites()
980 long folderId = addFolder(db, values); in loadFavorites()
1000 addAppShortcut(db, values, ar, packageManager, intent); in loadFavorites()
1005 long id = addUriShortcut(db, values, ar); in loadFavorites()
1020 deleteId(db, folderId); in loadFavorites()
1022 deleteId(db, folderItems.get(0)); in loadFavorites()
1041 private long addAppShortcut(SQLiteDatabase db, ContentValues values, TypedArray a, in addAppShortcut() argument
1068 if (dbInsertAndCheck(this, db, TABLE_FAVORITES, null, values) < 0) { in addAppShortcut()
1078 private long addFolder(SQLiteDatabase db, ContentValues values) { in addFolder() argument
1084 if (dbInsertAndCheck(this, db, TABLE_FAVORITES, null, values) <= 0) { in addFolder()
1117 private boolean addSearchWidget(SQLiteDatabase db, ContentValues values) { in addSearchWidget() argument
1119 return addAppWidget(db, values, cn, 4, 1, null); in addSearchWidget()
1122 private boolean addClockWidget(SQLiteDatabase db, ContentValues values) { in addClockWidget() argument
1125 return addAppWidget(db, values, cn, 2, 2, null); in addClockWidget()
1129 SQLiteDatabase db, ContentValues values, TypedArray a, in addAppWidget() argument
1182 return addAppWidget(db, values, cn, spanX, spanY, extras); in addAppWidget()
1188 private boolean addAppWidget(SQLiteDatabase db, ContentValues values, ComponentName cn, in addAppWidget() argument
1201 dbInsertAndCheck(this, db, TABLE_FAVORITES, null, values); in addAppWidget()
1223 private long addUriShortcut(SQLiteDatabase db, ContentValues values, in addUriShortcut() argument
1257 if (dbInsertAndCheck(this, db, TABLE_FAVORITES, null, values) < 0) { in addUriShortcut()