Searched refs:db (Results 1 - 25 of 43) sorted by relevance

12

/packages/apps/QuickSearchBox/src/com/android/quicksearchbox/util/
H A DSQLiteTransaction.java29 * @param db A writable database.
32 protected abstract boolean performTransaction(SQLiteDatabase db); argument
38 public void run(SQLiteDatabase db) { argument
39 db.beginTransaction();
41 if (performTransaction(db)) {
42 db.setTransactionSuccessful();
45 db.endTransaction();
/packages/providers/CalendarProvider/src/com/android/providers/calendar/
H A DCalendarDatabaseHelper.java51 private static final String DATABASE_NAME = "calendar.db";
145 public void onOpen(SQLiteDatabase db) { argument
146 mSyncState.onDatabaseOpened(db);
148 mCalendarsInserter = new DatabaseUtils.InsertHelper(db, "Calendars");
149 mEventsInserter = new DatabaseUtils.InsertHelper(db, "Events");
150 mEventsRawTimesInserter = new DatabaseUtils.InsertHelper(db, "EventsRawTimes");
151 mInstancesInserter = new DatabaseUtils.InsertHelper(db, "Instances");
152 mAttendeesInserter = new DatabaseUtils.InsertHelper(db, "Attendees");
153 mRemindersInserter = new DatabaseUtils.InsertHelper(db, "Reminders");
154 mCalendarAlertsInserter = new DatabaseUtils.InsertHelper(db, "CalendarAlert
172 upgradeSyncState(SQLiteDatabase db) argument
202 onCreate(SQLiteDatabase db) argument
206 bootstrapDB(SQLiteDatabase db) argument
410 createCalendarMetaDataTable(SQLiteDatabase db) argument
419 createCalendarCacheTable(SQLiteDatabase db) argument
438 onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) argument
547 recreateMetaDataAndInstances(SQLiteDatabase db) argument
568 upgradeToVersion69(SQLiteDatabase db) argument
707 upgradeToVersion66(SQLiteDatabase db) argument
714 upgradeToVersion65(SQLiteDatabase db) argument
719 upgradeToVersion64(SQLiteDatabase db) argument
724 upgradeToVersion63(SQLiteDatabase db) argument
729 upgradeToVersion62(SQLiteDatabase db) argument
798 upgradeToVersion61(SQLiteDatabase db) argument
802 upgradeToVersion60(SQLiteDatabase db) argument
844 upgradeToVersion59(SQLiteDatabase db) argument
857 upgradeToVersion57(SQLiteDatabase db) argument
871 upgradeToVersion56(SQLiteDatabase db) argument
908 upgradeResync(SQLiteDatabase db) argument
931 upgradeToVersion55(SQLiteDatabase db) argument
952 upgradeToVersion54(SQLiteDatabase db) argument
958 upgradeToVersion53(SQLiteDatabase db) argument
965 upgradeToVersion52(SQLiteDatabase db) argument
1024 upgradeToVersion51(SQLiteDatabase db) argument
1045 dropTables(SQLiteDatabase db) argument
1098 createEventsView(SQLiteDatabase db) argument
[all...]
H A DMetaData.java79 SQLiteDatabase db = mOpenHelper.getReadableDatabase();
80 db.beginTransaction();
85 readLocked(db);
90 db.setTransactionSuccessful();
92 db.endTransaction();
113 SQLiteDatabase db = mOpenHelper.getReadableDatabase();
114 readLocked(db);
128 private void readLocked(SQLiteDatabase db) { argument
134 Cursor cursor = db.query("CalendarMetaData", sCalendarMetaDataProjection,
169 SQLiteDatabase db
[all...]
H A DCalendarCache.java84 SQLiteDatabase db = mOpenHelper.getReadableDatabase();
85 db.beginTransaction();
87 writeDataLocked(db, key, value);
88 db.setTransactionSuccessful();
93 db.endTransaction();
101 * @param db the database (must not be null)
106 protected void writeDataLocked(SQLiteDatabase db, String key, String value) argument
108 if (null == db) {
120 db.replace(DATABASE_NAME, null /* null column hack */, values);
131 SQLiteDatabase db
145 readDataLocked(SQLiteDatabase db, String key) argument
[all...]
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/
H A DMmsSmsDatabaseHelper.java210 static final String DATABASE_NAME = "mmssms.db";
228 public static void updateThread(SQLiteDatabase db, long thread_id) { argument
230 updateAllThreads(db, null, null);
237 int rows = db.delete("threads",
248 db.execSQL(
264 db.execSQL(
292 Cursor c = db.rawQuery(query, null);
302 c = db.rawQuery(errorQuery, null);
309 db.execSQL("UPDATE threads SET error=" + setError +
319 public static void updateAllThreads(SQLiteDatabase db, Strin argument
343 deleteOneSms(SQLiteDatabase db, int message_id) argument
365 onCreate(SQLiteDatabase db) argument
377 populateWordsTable(SQLiteDatabase db) argument
446 createWordsTables(SQLiteDatabase db) argument
474 createIndices(SQLiteDatabase db) argument
478 createThreadIdIndex(SQLiteDatabase db) argument
487 createMmsTables(SQLiteDatabase db) argument
556 createMmsTriggers(SQLiteDatabase db) argument
592 createSmsTables(SQLiteDatabase db) argument
646 createCommonTables(SQLiteDatabase db) argument
699 createCommonTriggers(SQLiteDatabase db) argument
898 onUpgrade(SQLiteDatabase db, int oldVersion, int currentVersion) argument
1106 dropAll(SQLiteDatabase db) argument
1125 upgradeDatabaseToVersion41(SQLiteDatabase db) argument
1139 upgradeDatabaseToVersion42(SQLiteDatabase db) argument
1145 upgradeDatabaseToVersion43(SQLiteDatabase db) argument
1156 upgradeDatabaseToVersion44(SQLiteDatabase db) argument
1163 upgradeDatabaseToVersion45(SQLiteDatabase db) argument
1171 upgradeDatabaseToVersion53(SQLiteDatabase db) argument
1184 upgradeDatabaseToVersion46(SQLiteDatabase db) argument
1242 upgradeDatabaseToVersion47(SQLiteDatabase db) argument
1249 upgradeDatabaseToVersion48(SQLiteDatabase db) argument
1254 upgradeDatabaseToVersion51(SQLiteDatabase db) argument
1274 updateThreadsAttachmentColumn(SQLiteDatabase db) argument
[all...]
H A DTelephonyProvider.java51 private static final String DATABASE_NAME = "telephony.db";
119 public void onCreate(SQLiteDatabase db) { argument
121 db.execSQL("CREATE TABLE " + CARRIERS_TABLE +
140 initDatabase(db);
143 private void initDatabase(SQLiteDatabase db) { argument
151 loadApns(db, parser);
176 loadApns(db, confparser);
188 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { argument
202 db.execSQL("ALTER TABLE " + CARRIERS_TABLE +
269 * @param db th
273 loadApns(SQLiteDatabase db, XmlPullParser parser) argument
293 insertAddingDefaults(SQLiteDatabase db, String table, ContentValues row) argument
[all...]
/packages/providers/ContactsProvider/tests/src/com/android/providers/contacts/
H A DSynchronousContactsProvider2.java132 SQLiteDatabase db = getDatabaseHelper().getWritableDatabase();
133 db.execSQL("UPDATE raw_contacts SET aggregation_mode=0,aggregation_needed=1;");
135 db.compileStatement("SELECT _id FROM raw_contacts LIMIT 1 OFFSET " + maxContact)
137 db.execSQL("DELETE FROM raw_contacts WHERE _id > " + rowId + ";");
141 SQLiteDatabase db = getDatabaseHelper().getReadableDatabase();
142 return db.compileStatement("SELECT COUNT(*) FROM raw_contacts").simpleQueryForLong();
146 SQLiteDatabase db = getDatabaseHelper().getReadableDatabase();
147 return db.compileStatement("SELECT COUNT(*) FROM contacts").simpleQueryForLong();
153 SQLiteDatabase db = getDatabaseHelper().getWritableDatabase();
154 db
[all...]
/packages/providers/MediaProvider/src/com/android/providers/media/
H A DMediaProvider.java182 public void onCreate(final SQLiteDatabase db) { argument
183 updateDatabase(db, mInternal, 0, DATABASE_VERSION);
191 public void onUpgrade(final SQLiteDatabase db, final int oldV, final int newV) { argument
192 updateDatabase(db, mInternal, oldV, newV);
201 public void onOpen(SQLiteDatabase db) { argument
205 File file = new File(db.getPath());
356 * @param db Database
359 private static void updateDatabase(SQLiteDatabase db, boolean internal, argument
382 db.execSQL("DROP TABLE IF EXISTS images");
383 db
952 sanityCheck(SQLiteDatabase db, int fromVersion) argument
971 recreateAudioView(SQLiteDatabase db) argument
994 updateBucketNames(SQLiteDatabase db, String tableName) argument
1025 updateDisplayName(SQLiteDatabase db, String tableName) argument
1478 doAudioSearch(SQLiteDatabase db, SQLiteQueryBuilder qb, Uri uri, String[] projectionIn, String selection, String[] selectionArgs, String sort, int mode, String limit) argument
1645 playlistBulkInsert(SQLiteDatabase db, Uri uri, ContentValues values[]) argument
2360 movePlaylistEntry(SQLiteDatabase db, long playlist, int from, int to) argument
2477 SQLiteDatabase db; field in class:MediaProvider.ThumbData
2483 makeThumbAsync(SQLiteDatabase db, String path, long album_id) argument
2613 getAlbumArtOutputUri(SQLiteDatabase db, long album_id, Uri albumart_uri) argument
2675 getThumb(SQLiteDatabase db, String path, long album_id, Uri albumart_uri) argument
2792 getKeyIdForName(SQLiteDatabase db, String table, String keyField, String nameField, String rawName, String cacheName, String path, int albumHash, String artist, HashMap<String, Long> cache, Uri srcuri) argument
[all...]
/packages/apps/Email/src/com/android/email/provider/
H A DEmailProvider.java58 protected static final String DATABASE_NAME = "EmailProvider.db";
59 protected static final String BODY_DATABASE_NAME = "EmailProviderBody.db";
290 static void createMessageTable(SQLiteDatabase db) { argument
327 db.execSQL("create table " + Message.TABLE_NAME + createString);
328 db.execSQL("create table " + Message.UPDATED_TABLE_NAME + altCreateString);
329 db.execSQL("create table " + Message.DELETED_TABLE_NAME + altCreateString);
340 db.execSQL(createIndex(Message.TABLE_NAME, columnName));
346 db.execSQL("create trigger message_delete before delete on " + Message.TABLE_NAME +
354 db.execSQL("create trigger unread_message_insert before insert on " + Message.TABLE_NAME +
362 db
392 resetMessageTable(SQLiteDatabase db, int oldVersion, int newVersion) argument
402 createAccountTable(SQLiteDatabase db) argument
434 resetAccountTable(SQLiteDatabase db, int oldVersion, int newVersion) argument
442 createHostAuthTable(SQLiteDatabase db) argument
456 resetHostAuthTable(SQLiteDatabase db, int oldVersion, int newVersion) argument
464 createMailboxTable(SQLiteDatabase db) argument
491 resetMailboxTable(SQLiteDatabase db, int oldVersion, int newVersion) argument
499 createAttachmentTable(SQLiteDatabase db) argument
517 resetAttachmentTable(SQLiteDatabase db, int oldVersion, int newVersion) argument
525 createBodyTable(SQLiteDatabase db) argument
539 upgradeBodyTable(SQLiteDatabase db, int oldVersion, int newVersion) argument
650 onCreate(SQLiteDatabase db) argument
656 onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) argument
661 onOpen(SQLiteDatabase db) argument
674 onCreate(SQLiteDatabase db) argument
685 onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) argument
788 onOpen(SQLiteDatabase db) argument
[all...]
/packages/apps/Gallery3D/src/com/cooliris/picasa/
H A DPicasaContentProvider.java73 public static final String DATABASE_NAME = "picasa.db";
81 public void onCreate(SQLiteDatabase db) { argument
82 PhotoEntry.SCHEMA.createTables(db);
83 AlbumEntry.SCHEMA.createTables(db);
84 UserEntry.SCHEMA.createTables(db);
88 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { argument
91 PhotoEntry.SCHEMA.dropTables(db);
92 AlbumEntry.SCHEMA.dropTables(db);
93 UserEntry.SCHEMA.dropTables(db);
94 onCreate(db);
455 deleteUser(SQLiteDatabase db, String account) argument
478 deleteAlbum(SQLiteDatabase db, long albumId) argument
486 deleteAlbumPhotos(SQLiteDatabase db, long albumId) argument
504 deletePhoto(SQLiteDatabase db, long photoId) argument
522 public SQLiteDatabase db; field in class:PicasaContentProvider.SyncContext
[all...]
H A DEntrySchema.java82 private void logExecSql(SQLiteDatabase db, String sql) { argument
84 db.execSQL(sql);
169 public Cursor queryAll(SQLiteDatabase db) { argument
170 return db.query(mTableName, mProjection, null, null, null, null, null);
173 public boolean queryWithId(SQLiteDatabase db, long id, Entry entry) { argument
174 Cursor cursor = db.query(mTableName, mProjection, "_id=?", new String[] { Long.toString(id) }, null, null, null);
184 public long insertOrReplace(SQLiteDatabase db, Entry entry) { argument
191 long id = db.replace(mTableName, "_id", values);
196 public boolean deleteWithId(SQLiteDatabase db, long id) { argument
197 return db
200 createTables(SQLiteDatabase db) argument
327 dropTables(SQLiteDatabase db) argument
345 deleteAll(SQLiteDatabase db) argument
[all...]
/packages/apps/Launcher2/src/com/android/launcher2/
H A DLauncherProvider.java66 private static final String DATABASE_NAME = "launcher.db";
109 SQLiteDatabase db = mOpenHelper.getWritableDatabase();
110 Cursor result = qb.query(db, projection, args.where, args.args, null, null, sortOrder);
120 SQLiteDatabase db = mOpenHelper.getWritableDatabase();
121 final long rowId = db.insert(args.table, null, initialValues);
134 SQLiteDatabase db = mOpenHelper.getWritableDatabase();
135 db.beginTransaction();
139 if (db.insert(args.table, null, values[i]) < 0) return 0;
141 db.setTransactionSuccessful();
143 db
208 onCreate(SQLiteDatabase db) argument
244 convertDatabase(SQLiteDatabase db) argument
281 copyFromCursor(SQLiteDatabase db, Cursor c) argument
339 onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) argument
417 updateContactsShortcuts(SQLiteDatabase db) argument
484 normalizeIcons(SQLiteDatabase db) argument
545 convertWidgets(SQLiteDatabase db) argument
627 loadFavorites(SQLiteDatabase db) argument
689 addAppShortcut(SQLiteDatabase db, ContentValues values, TypedArray a, PackageManager packageManager, Intent intent) argument
750 addSearchWidget(SQLiteDatabase db, ContentValues values) argument
755 addClockWidget(SQLiteDatabase db, ContentValues values) argument
761 addAppWidget(SQLiteDatabase db, ContentValues values, TypedArray a, PackageManager packageManager) argument
795 addAppWidget(SQLiteDatabase db, ContentValues values, ComponentName cn, int spanX, int spanY) argument
819 addUriShortcut(SQLiteDatabase db, ContentValues values, TypedArray a) argument
[all...]
/packages/providers/ContactsProvider/src/com/android/providers/contacts/
H A DContactsDatabaseHelper.java79 private static final String DATABASE_NAME = "contacts2.db";
521 public void onOpen(SQLiteDatabase db) { argument
522 mSyncState.onDatabaseOpened(db);
525 mMimetypeQuery = db.compileStatement("SELECT " + MimetypesColumns._ID + " FROM "
527 mPackageQuery = db.compileStatement("SELECT " + PackagesColumns._ID + " FROM "
529 mContactIdQuery = db.compileStatement("SELECT " + RawContacts.CONTACT_ID + " FROM "
531 mAggregationModeQuery = db.compileStatement("SELECT " + RawContacts.AGGREGATION_MODE
533 mMimetypeInsert = db.compileStatement("INSERT INTO " + Tables.MIMETYPES + "("
535 mPackageInsert = db.compileStatement("INSERT INTO " + Tables.PACKAGES + "("
538 mDataMimetypeQuery = db
639 onCreate(SQLiteDatabase db) argument
977 createContactsTriggers(SQLiteDatabase db) argument
1058 createContactsIndexes(SQLiteDatabase db) argument
1080 createContactsViews(SQLiteDatabase db) argument
1245 createGroupsView(SQLiteDatabase db) argument
1274 createContactEntitiesView(SQLiteDatabase db) argument
1340 onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) argument
1512 upgradeToVersion202(SQLiteDatabase db) argument
1550 upgradeToVersion203(SQLiteDatabase db) argument
1626 upgradeToVersion205(SQLiteDatabase db) argument
1702 upgradeStructuredNamesToVersion205(SQLiteDatabase db, SQLiteStatement rawContactUpdate, NameSplitter splitter) argument
1816 upgradeOrganizationsToVersion205(SQLiteDatabase db, SQLiteStatement rawContactUpdate, NameSplitter splitter) argument
1879 upgrateToVersion206(SQLiteDatabase db) argument
1906 upgradeToVersion300(SQLiteDatabase db) argument
1975 upgradeEmailToVersion303(SQLiteDatabase db) argument
2011 upgradeNicknameToVersion303(SQLiteDatabase db) argument
2040 upgradeToVersion304(SQLiteDatabase db) argument
2047 upgradeToVersion306(SQLiteDatabase db) argument
2098 upgradeToVersion307(SQLiteDatabase db) argument
2105 upgradeToVersion308(SQLiteDatabase db) argument
2115 rebuildNameLookup(SQLiteDatabase db) argument
2151 rebuildSortKeys(SQLiteDatabase db, ContactsProvider2 provider) argument
2164 insertNameLookup(SQLiteDatabase db) argument
2232 insertStructuredNameLookup(SQLiteDatabase db, SQLiteStatement nameLookupInsert) argument
2276 insertOrganizationLookup(SQLiteDatabase db, SQLiteStatement nameLookupInsert) argument
2317 insertEmailLookup(SQLiteDatabase db, SQLiteStatement nameLookupInsert) argument
2356 insertNicknameLookup(SQLiteDatabase db, SQLiteStatement nameLookupInsert) argument
2423 lookupMimeTypeId(SQLiteDatabase db, String mimeType) argument
2447 updateSqliteStats(SQLiteDatabase db) argument
2498 updateIndexStats(SQLiteDatabase db, String table, String index, String stats) argument
2817 loadNicknameLookupTable(SQLiteDatabase db) argument
[all...]
H A DContactAggregator.java208 SQLiteDatabase db = mDbHelper.getReadableDatabase();
212 mAggregatedPresenceReplace = db.compileStatement(
220 mRawContactCountQuery = db.compileStatement(
226 mContactDelete = db.compileStatement(
230 mAggregatedPresenceDelete = db.compileStatement(
234 mMarkForAggregation = db.compileStatement(
240 mPhotoIdUpdate = db.compileStatement(
245 mDisplayNameUpdate = db.compileStatement(
250 mLookupKeyUpdate = db.compileStatement(
255 mHasPhoneNumberUpdate = db
331 aggregateInTransaction(SQLiteDatabase db) argument
413 onRawContactInsert(SQLiteDatabase db, long rawContactId) argument
424 aggregateContact(SQLiteDatabase db, long rawContactId, long currentContactId) argument
460 aggregateContact(SQLiteDatabase db, long rawContactId, long currentContactId, MatchCandidateList candidates, ContactMatcher matcher, ContentValues values) argument
599 prefetchAggregationExceptionIds(SQLiteDatabase db) argument
647 pickBestMatchBasedOnExceptions(SQLiteDatabase db, long rawContactId, ContactMatcher matcher) argument
710 pickBestMatchBasedOnData(SQLiteDatabase db, long rawContactId, MatchCandidateList candidates, ContactMatcher matcher) argument
729 pickBestMatchBasedOnSecondaryData(SQLiteDatabase db, long rawContactId, MatchCandidateList candidates, ContactMatcher matcher) argument
774 loadNameMatchCandidates(SQLiteDatabase db, long rawContactId, MatchCandidateList candidates, boolean structuredNameBased) argument
797 updateMatchScoresBasedOnDataMatches(SQLiteDatabase db, long rawContactId, MatchCandidateList candidates, ContactMatcher matcher) argument
837 updateMatchScoresBasedOnNameMatches(SQLiteDatabase db, long rawContactId, ContactMatcher matcher) argument
882 updateMatchScoresBasedOnEmailMatches(SQLiteDatabase db, long rawContactId, ContactMatcher matcher) argument
924 updateMatchScoresBasedOnPhoneMatches(SQLiteDatabase db, long rawContactId, ContactMatcher matcher) argument
946 lookupApproximateNameMatches(SQLiteDatabase db, MatchCandidateList candidates, ContactMatcher matcher) argument
987 matchAllCandidates(SQLiteDatabase db, String selection, MatchCandidateList candidates, ContactMatcher matcher, int algorithm, String limit) argument
1111 computeAggregateData(SQLiteDatabase db, long contactId, SQLiteStatement statement) argument
1120 computeAggregateData(final SQLiteDatabase db, String sql, String[] sqlArgs, SQLiteStatement statement) argument
1309 updatePhotoId(SQLiteDatabase db, long rawContactId) argument
1376 updateDisplayNameForRawContact(SQLiteDatabase db, long rawContactId) argument
1385 updateDisplayNameForContact(SQLiteDatabase db, long contactId) argument
1427 updateHasPhoneNumber(SQLiteDatabase db, long rawContactId) argument
1456 updateLookupKeyForRawContact(SQLiteDatabase db, long rawContactId) argument
1465 updateLookupKeyForContact(SQLiteDatabase db, long contactId) argument
1531 queryMatchingContacts(SQLiteQueryBuilder qb, SQLiteDatabase db, long contactId, String[] projection, List<MatchScore> bestMatches, int maxSuggestions, String filter) argument
1625 findMatchingContacts(final SQLiteDatabase db, long contactId) argument
1651 updateMatchScoresForSuggestionsBasedOnDataMatches(SQLiteDatabase db, long rawContactId, MatchCandidateList candidates, ContactMatcher matcher) argument
[all...]
H A DSocialProvider.java180 final SQLiteDatabase db = mDbHelper.getWritableDatabase();
182 db.beginTransaction();
203 threadPublished = getThreadPublished(db, inReplyTo, published);
209 id = db.insert(Tables.ACTIVITIES, Activities.RAW_ID, values);
213 adjustReplyTimestamps(db, values.getAsString(Activities.RAW_ID), published);
216 db.setTransactionSuccessful();
218 db.endTransaction();
227 private long getThreadPublished(SQLiteDatabase db, String rawId, long defaultValue) { argument
231 final Cursor c = db.query(Tables.ACTIVITIES,
246 return getThreadPublished(db, inReplyT
256 adjustReplyTimestamps(SQLiteDatabase db, String inReplyTo, long threadPublished) argument
[all...]
/packages/apps/AlarmClock/src/com/android/alarmclock/
H A DAlarmProvider.java46 private static final String DATABASE_NAME = "alarms.db";
54 public void onCreate(SQLiteDatabase db) { argument
55 db.execSQL("CREATE TABLE alarms (" +
70 db.execSQL(insertMe + "(7, 0, 127, 0, 0, 1, '', '');");
71 db.execSQL(insertMe + "(8, 30, 31, 0, 0, 1, '', '');");
72 db.execSQL(insertMe + "(9, 00, 0, 0, 0, 1, '', '');");
76 public void onUpgrade(SQLiteDatabase db, int oldVersion, int currentVersion) { argument
81 db.execSQL("DROP TABLE IF EXISTS alarms");
82 onCreate(db);
115 SQLiteDatabase db
[all...]
/packages/providers/DrmProvider/src/com/android/providers/drm/
H A DDrmProvider.java57 private static final String DATABASE_NAME = "drm.db";
68 public void onCreate(final SQLiteDatabase db) { argument
69 createTables(db);
76 public void onOpen(final SQLiteDatabase db) { argument
77 super.onOpen(db);
91 public void onUpgrade(final SQLiteDatabase db, argument
96 dropTables(db);
97 createTables(db);
111 private void createTables(SQLiteDatabase db) { argument
112 db
132 dropTables(SQLiteDatabase db) argument
[all...]
/packages/apps/DeskClock/src/com/android/deskclock/
H A DAlarmProvider.java46 private static final String DATABASE_NAME = "alarms.db";
54 public void onCreate(SQLiteDatabase db) { argument
55 db.execSQL("CREATE TABLE alarms (" +
70 db.execSQL(insertMe + "(8, 30, 31, 0, 0, 1, '', '');");
71 db.execSQL(insertMe + "(9, 00, 96, 0, 0, 1, '', '');");
75 public void onUpgrade(SQLiteDatabase db, int oldVersion, int currentVersion) { argument
80 db.execSQL("DROP TABLE IF EXISTS alarms");
81 onCreate(db);
114 SQLiteDatabase db = mOpenHelper.getReadableDatabase();
115 Cursor ret = qb.query(db, projectionI
[all...]
/packages/providers/UserDictionaryProvider/src/com/android/providers/userdictionary/
H A DUserDictionaryProvider.java50 private static final String DATABASE_NAME = "user_dict.db";
75 public void onCreate(SQLiteDatabase db) { argument
76 db.execSQL("CREATE TABLE " + USERDICT_TABLE_NAME + " ("
86 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { argument
89 db.execSQL("DROP TABLE IF EXISTS " + USERDICT_TABLE_NAME);
90 onCreate(db);
133 SQLiteDatabase db = mOpenHelper.getReadableDatabase();
134 Cursor c = qb.query(db, projection, selection, selectionArgs, null, null, orderBy);
183 SQLiteDatabase db = mOpenHelper.getWritableDatabase();
184 long rowId = db
[all...]
/packages/apps/Gallery/src/com/android/camera/
H A DPhotoAppWidgetProvider.java87 private static final String DATABASE_NAME = "launcher.db";
100 public void onCreate(SQLiteDatabase db) { argument
101 db.execSQL("CREATE TABLE " + TABLE_PHOTOS + " (" +
108 public void onUpgrade(SQLiteDatabase db, int oldVersion, argument
114 db.execSQL("DROP TABLE IF EXISTS " + TABLE_PHOTOS);
115 onCreate(db);
139 SQLiteDatabase db = getWritableDatabase();
140 db.insertOrThrow(PhotoDatabaseHelper.TABLE_PHOTOS, null,
168 SQLiteDatabase db = getReadableDatabase();
171 c = db
[all...]
/packages/apps/Gallery3D/src/com/cooliris/media/
H A DPhotoAppWidgetProvider.java83 private static final String DATABASE_NAME = "launcher.db";
96 public void onCreate(SQLiteDatabase db) { argument
97 db.execSQL("CREATE TABLE " + TABLE_PHOTOS + " (" + FIELD_APPWIDGET_ID + " INTEGER PRIMARY KEY," + FIELD_PHOTO_BLOB
102 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { argument
107 db.execSQL("DROP TABLE IF EXISTS " + TABLE_PHOTOS);
108 onCreate(db);
131 SQLiteDatabase db = getWritableDatabase();
132 db.insertOrThrow(PhotoDatabaseHelper.TABLE_PHOTOS, null, values);
157 SQLiteDatabase db = getReadableDatabase();
159 c = db
[all...]
/packages/apps/QuickSearchBox/src/com/android/quicksearchbox/
H A DShortcutRepositoryImplLog.java46 * # sqlite3 /data/data/com.android.quicksearchbox/databases/qsb-log.db
55 private static final String DB_NAME = "qsb-log.db";
91 * @param context Used to create / open db
216 SQLiteDatabase db = mOpenHelper.getReadableDatabase();
217 Cursor cursor = db.rawQuery(HAS_HISTORY_QUERY, null);
229 public boolean performTransaction(SQLiteDatabase db) {
230 db.delete(ClickLog.TABLE_NAME, null, null);
231 db.delete(Shortcuts.TABLE_NAME, null, null);
232 db.delete(SourceStats.TABLE_NAME, null, null);
280 SQLiteDatabase db
713 onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) argument
722 dropTables(SQLiteDatabase db) argument
749 onOpen(SQLiteDatabase db) argument
755 onCreate(SQLiteDatabase db) argument
[all...]
/packages/apps/Bluetooth/src/com/android/bluetooth/opp/
H A DBluetoothOppProvider.java62 private static final String DB_NAME = "btopp.db";
128 public void onCreate(final SQLiteDatabase db) { argument
130 createTable(db);
133 //TODO: use this function to check garbage transfer left in db, for example,
140 * @Override public void onOpen(final SQLiteDatabase db) {
141 * super.onOpen(db); }
152 public void onUpgrade(final SQLiteDatabase db, int oldV, final int newV) { argument
165 dropTable(db);
166 createTable(db);
171 private void createTable(SQLiteDatabase db) { argument
189 dropTable(SQLiteDatabase db) argument
[all...]
/packages/apps/IM/src/com/android/im/provider/
H A DImpsProvider.java77 private static final String DATABASE_NAME = "imps.db";
250 public void onCreate(SQLiteDatabase db) { argument
254 db.execSQL("CREATE TABLE " + TABLE_PROVIDERS + " (" +
262 db.execSQL("CREATE TABLE " + TABLE_ACCOUNTS + " (" +
275 createContactsTables(db);
276 createMessageChatTables(db, true /* create show_ts column */);
278 db.execSQL("CREATE TABLE " + TABLE_AVATARS + " (" +
288 db.execSQL("CREATE TABLE " + TABLE_PROVIDER_SETTINGS + " (" +
296 db.execSQL("create TABLE " + TABLE_BRANDING_RESOURCE_MAP_CACHE + " (" +
304 db
339 onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) argument
478 destroyOldTables(SQLiteDatabase db) argument
497 createContactsTables(SQLiteDatabase db) argument
578 createMessageChatTables(SQLiteDatabase db, boolean addShowTsColumnForMessagesTable) argument
640 createInMemoryMessageTables(SQLiteDatabase db, String tablePrefix) argument
661 onOpen(SQLiteDatabase db) argument
2360 getContactId(final SQLiteDatabase db, final String accountId, final String contact) argument
2535 deleteWithSelection(SQLiteDatabase db, String tableName, String selection, String[] selectionArgs) argument
[all...]
/packages/inputmethods/LatinIME/java/src/com/android/inputmethod/latin/
H A DAutoDictionary.java59 private static final String DATABASE_NAME = "auto_dict.db";
73 /** Name of the words table in the auto_dict.db */
159 // Write a null frequency if it is to be deleted from the db
173 // Create a new map for writing new entries into while the old one is written to db
188 public void onCreate(SQLiteDatabase db) { argument
189 db.execSQL("CREATE TABLE " + AUTODICT_TABLE_NAME + " ("
198 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { argument
201 db.execSQL("DROP TABLE IF EXISTS " + AUTODICT_TABLE_NAME);
202 onCreate(db);
212 SQLiteDatabase db
[all...]

Completed in 482 milliseconds

12