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