Home
last modified time | relevance | path

Searched refs:execSQL (Results 1 – 25 of 61) sorted by relevance

123

/packages/providers/CalendarProvider/src/com/android/providers/calendar/
DCalendarDatabaseHelper.java361 db.execSQL("CREATE TEMPORARY TABLE state_backup(_sync_account TEXT, " in upgradeSyncState()
363 db.execSQL("INSERT INTO state_backup SELECT _sync_account, _sync_account_type, data" in upgradeSyncState()
367 db.execSQL("DROP TABLE " + Tables.SYNC_STATE + ";"); in upgradeSyncState()
369 db.execSQL("INSERT INTO " + Tables.SYNC_STATE + "(" in upgradeSyncState()
374 db.execSQL("DROP TABLE state_backup;"); in upgradeSyncState()
399 db.execSQL("CREATE TABLE " + Tables.EVENTS_RAW_TIMES + " (" + in bootstrapDB()
409 db.execSQL("CREATE TABLE " + Tables.INSTANCES + " (" + in bootstrapDB()
424 db.execSQL("CREATE INDEX instancesStartDayIndex ON " + Tables.INSTANCES + " (" + in bootstrapDB()
432 db.execSQL("CREATE TABLE " + Tables.ATTENDEES + " (" + in bootstrapDB()
444 db.execSQL("CREATE INDEX attendeesEventIdIndex ON " + Tables.ATTENDEES + " (" + in bootstrapDB()
[all …]
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/
DMmsSmsDatabaseHelper.java342 db.execSQL( in updateThread()
358 db.execSQL( in updateThread()
403 db.execSQL("UPDATE threads SET error=" + setError + in updateThread()
563 …db.execSQL("CREATE VIRTUAL TABLE words USING FTS3 (_id INTEGER PRIMARY KEY, index_text TEXT, sourc… in createWordsTables()
570 db.execSQL("CREATE TRIGGER sms_words_update AFTER UPDATE ON sms BEGIN UPDATE words " + in createWordsTables()
573 db.execSQL("CREATE TRIGGER sms_words_delete AFTER DELETE ON sms BEGIN DELETE FROM " + in createWordsTables()
588 db.execSQL("CREATE INDEX IF NOT EXISTS typeThreadIdIndex ON sms" + in createThreadIdIndex()
598 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_PDU + " (" + in createMmsTables()
637 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_ADDR + " (" + in createMmsTables()
645 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_PART + " (" + in createMmsTables()
[all …]
DTelephonyProvider.java251 db.execSQL("CREATE TABLE " + SIMINFO_TABLE + "(" in createSimInfoTable()
283 db.execSQL("CREATE TABLE " + tableName + in createCarriersTable()
506 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
513 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
515 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
521 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
523 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
530 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
532 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
537 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
[all …]
DHbpcdLookupDatabaseHelper.java108 db.execSQL("CREATE TABLE " + HbpcdLookupProvider.TABLE_MCC_IDD + in onCreate()
113 db.execSQL("CREATE TABLE " + HbpcdLookupProvider.TABLE_MCC_LOOKUP_TABLE + in onCreate()
125 db.execSQL("CREATE TABLE " + HbpcdLookupProvider.TABLE_MCC_SID_CONFLICT + in onCreate()
130 db.execSQL("CREATE TABLE " + HbpcdLookupProvider.TABLE_MCC_SID_RANGE + in onCreate()
136 db.execSQL("CREATE TABLE " + HbpcdLookupProvider.TABLE_NANP_AREA_CODE + in onCreate()
140 db.execSQL("CREATE TABLE " + HbpcdLookupProvider.TABLE_ARBITRARY_MCC_SID_MATCH + in onCreate()
/packages/apps/Email/provider_src/com/android/email/provider/
DDBHelper.java215 db.execSQL("create trigger message_count_message_insert after insert on " + in createMessageCountTriggers()
223 db.execSQL("create trigger message_count_message_delete after delete on " + in createMessageCountTriggers()
231 db.execSQL("create trigger message_count_message_move after update of " + in createMessageCountTriggers()
249 db.execSQL("create table " + Credential.TABLE_NAME + s); in createCredentialsTable()
250 db.execSQL(TRIGGER_HOST_AUTH_DELETE); in createCredentialsTable()
254 db.execSQL("drop trigger message_delete_duplicates_on_insert"); in dropDeleteDuplicateMessagesTrigger()
276 db.execSQL("create trigger message_delete_duplicates_on_insert before insert on " in createDeleteDuplicateMessagesTrigger()
341 db.execSQL("create table " + Message.TABLE_NAME + createString); in createMessageTable()
342 db.execSQL("create table " + Message.UPDATED_TABLE_NAME + altCreateString); in createMessageTable()
343 db.execSQL("create table " + Message.DELETED_TABLE_NAME + altCreateString); in createMessageTable()
[all …]
/packages/providers/ContactsProvider/src/com/android/providers/contacts/
DContactsDatabaseHelper.java1119 db.execSQL("ATTACH DATABASE ':memory:' AS " + DATABASE_PRESENCE + ";"); in onOpen()
1120 db.execSQL("CREATE TABLE IF NOT EXISTS " + DATABASE_PRESENCE + "." + Tables.PRESENCE + " ("+ in onOpen()
1134 db.execSQL("CREATE INDEX IF NOT EXISTS " + DATABASE_PRESENCE + ".presenceIndex" + " ON " in onOpen()
1136 db.execSQL("CREATE INDEX IF NOT EXISTS " + DATABASE_PRESENCE + ".presenceIndex2" + " ON " in onOpen()
1139 db.execSQL("CREATE TABLE IF NOT EXISTS " in onOpen()
1147 db.execSQL("CREATE TRIGGER " + DATABASE_PRESENCE + "." + Tables.PRESENCE + "_deleted" in onOpen()
1187 db.execSQL("CREATE TRIGGER " + DATABASE_PRESENCE + "." + Tables.PRESENCE + "_inserted" in onOpen()
1193 db.execSQL("CREATE TRIGGER " + DATABASE_PRESENCE + "." + Tables.PRESENCE + "_updated" in onOpen()
1213 db.execSQL("CREATE TABLE " + Tables.ACCOUNTS + " (" + in onCreate()
1221 db.execSQL("CREATE TABLE " + Tables.CONTACTS + " (" + in onCreate()
[all …]
DCallLogDatabaseHelper.java113 db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + in onCreate()
157 db.execSQL("CREATE TABLE " + Tables.VOICEMAIL_STATUS + " (" + in onCreate()
233 db.execSQL("ALTER TABLE " + Tables.CALLS + " ADD " + Calls.VIA_NUMBER + in upgradeToVersion2()
241 db.execSQL("ALTER TABLE " + Tables.VOICEMAIL_STATUS + " ADD " + Status.SOURCE_TYPE + in upgradeToVersion3()
301 contacts.execSQL("DROP TABLE " + LegacyConstants.CALLS_LEGACY + ";"); in migrateFromLegacyTables()
302 contacts.execSQL("DROP TABLE " + LegacyConstants.VOICEMAIL_STATUS_LEGACY + ";"); in migrateFromLegacyTables()
345 getWritableDatabase().execSQL("DELETE FROM " + Tables.CALLS); in wipeForTest()
DLegacyApiSupport.java596 db.execSQL("DROP VIEW IF EXISTS " + LegacyTables.PEOPLE + ";"); in createViews()
597 db.execSQL("CREATE VIEW " + LegacyTables.PEOPLE + " AS SELECT " + in createViews()
604 db.execSQL("DROP VIEW IF EXISTS " + LegacyTables.ORGANIZATIONS + ";"); in createViews()
605 db.execSQL("CREATE VIEW " + LegacyTables.ORGANIZATIONS + " AS SELECT " + in createViews()
628 db.execSQL("DROP VIEW IF EXISTS " + LegacyTables.CONTACT_METHODS + ";"); in createViews()
629 db.execSQL("CREATE VIEW " + LegacyTables.CONTACT_METHODS + " AS SELECT " + in createViews()
653 db.execSQL("DROP VIEW IF EXISTS " + LegacyTables.PHONES + ";"); in createViews()
654 db.execSQL("CREATE VIEW " + LegacyTables.PHONES + " AS SELECT DISTINCT " + in createViews()
680 db.execSQL("DROP VIEW IF EXISTS " + LegacyTables.EXTENSIONS + ";"); in createViews()
681 db.execSQL("CREATE VIEW " + LegacyTables.EXTENSIONS + " AS SELECT " + in createViews()
[all …]
/packages/providers/MediaProvider/src/com/android/providers/media/
DMediaProvider.java787 db.execSQL("DROP TABLE IF EXISTS images"); in updateDatabase()
788 db.execSQL("DROP TRIGGER IF EXISTS images_cleanup"); in updateDatabase()
789 db.execSQL("DROP TABLE IF EXISTS thumbnails"); in updateDatabase()
790 db.execSQL("DROP TRIGGER IF EXISTS thumbnails_cleanup"); in updateDatabase()
791 db.execSQL("DROP TABLE IF EXISTS audio_meta"); in updateDatabase()
792 db.execSQL("DROP TABLE IF EXISTS artists"); in updateDatabase()
793 db.execSQL("DROP TABLE IF EXISTS albums"); in updateDatabase()
794 db.execSQL("DROP TABLE IF EXISTS album_art"); in updateDatabase()
795 db.execSQL("DROP VIEW IF EXISTS artist_info"); in updateDatabase()
796 db.execSQL("DROP VIEW IF EXISTS album_info"); in updateDatabase()
[all …]
/packages/providers/CalendarProvider/tests/src/com/android/providers/calendar/
DCalendarDatabaseHelperTest.java55 db.execSQL("CREATE TABLE Calendars (" + in bootstrapDbVersion50()
77 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON Calendars " + in bootstrapDbVersion50()
84 db.execSQL("CREATE TABLE Events (" + in bootstrapDbVersion50()
121 db.execSQL("CREATE INDEX eventsCalendarIdIndex ON Events (calendar_id);"); in bootstrapDbVersion50()
123 db.execSQL("CREATE TABLE EventsRawTimes (" + in bootstrapDbVersion50()
136 db.execSQL("CREATE TABLE DeletedEvents (" + in bootstrapDbVersion50()
143 db.execSQL("CREATE TABLE Instances (" + in bootstrapDbVersion50()
155 db.execSQL("CREATE INDEX instancesStartDayIndex ON Instances (startDay);"); in bootstrapDbVersion50()
157 db.execSQL("CREATE TABLE CalendarMetaData (" + in bootstrapDbVersion50()
166 db.execSQL("CREATE TABLE BusyBits(" + in bootstrapDbVersion50()
[all …]
/packages/apps/Dialer/src/com/android/dialer/database/
DDialerDatabaseHelper.java397 db.execSQL("CREATE TABLE " + Tables.SMARTDIAL_TABLE + " (" in setupTables()
415 db.execSQL("CREATE TABLE " + Tables.PREFIX_TABLE + " (" in setupTables()
421 db.execSQL("CREATE TABLE " + Tables.PROPERTIES + " (" in setupTables()
429 db.execSQL("CREATE TABLE " + Tables.FILTERED_NUMBER_TABLE + " (" in setupTables()
449 db.execSQL("DROP TABLE IF EXISTS " + Tables.PREFIX_TABLE); in dropTables()
450 db.execSQL("DROP TABLE IF EXISTS " + Tables.SMARTDIAL_TABLE); in dropTables()
451 db.execSQL("DROP TABLE IF EXISTS " + Tables.PROPERTIES); in dropTables()
452 db.execSQL("DROP TABLE IF EXISTS " + Tables.FILTERED_NUMBER_TABLE); in dropTables()
453 db.execSQL("DROP TABLE IF EXISTS " + Tables.VOICEMAIL_ARCHIVE_TABLE); in dropTables()
475 db.execSQL("DROP TABLE IF EXISTS " + Tables.FILTERED_NUMBER_TABLE); in onUpgrade()
[all …]
/packages/providers/TvProvider/src/com/android/providers/tv/
DTvProvider.java411 db.execSQL("CREATE TABLE " + CHANNELS_TABLE + " (" in onCreate()
444 db.execSQL("CREATE TABLE " + PROGRAMS_TABLE + " (" in onCreate()
479 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_PACKAGE_NAME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
481 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
483 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_START_TIME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
485 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_END_TIME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
487 db.execSQL("CREATE TABLE " + WATCHED_PROGRAMS_TABLE + " (" in onCreate()
509 db.execSQL("CREATE INDEX " + WATCHED_PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " in onCreate()
511 db.execSQL(CREATE_RECORDED_PROGRAMS_TABLE_SQL); in onCreate()
519 db.execSQL("DROP TABLE IF EXISTS " + DELETED_CHANNELS_TABLE); in onUpgrade()
[all …]
/packages/apps/Messaging/src/com/android/messaging/datamodel/
DDatabaseHelper.java655 db.execSQL(createViewSql); in rebuildView()
662 db.execSQL(dropPrefix + viewName); in dropView()
677 db.execSQL(sql); in rebuildAllViews()
698 db.execSQL(dropPrefix + tableName); in dropAllTables()
729 db.execSQL(dropPrefix + triggerName); in dropAllTriggers()
773 db.execSQL(dropPrefix + indexName); in dropAllIndexes()
789 db.execSQL(sql); in createDatabase()
793 db.execSQL(sql); in createDatabase()
797 db.execSQL(sql); in createDatabase()
801 db.execSQL(sql); in createDatabase()
[all …]
DDatabaseWrapper.java423 public void execSQL(final String sql, final String[] bindArgs) { in execSQL() method in DatabaseWrapper
430 mDatabase.execSQL(sql, bindArgs); in execSQL()
441 public void execSQL(final String sql) { in execSQL() method in DatabaseWrapper
448 mDatabase.execSQL(sql); in execSQL()
/packages/inputmethods/LatinIME/java/src/com/android/inputmethod/dictionarypack/
DMetadataDbHelper.java208 db.execSQL(METADATA_CREATE_CLIENT_TABLE); in createClientTable()
228 db.execSQL(METADATA_TABLE_CREATE); in onCreate()
234 db.execSQL("SELECT " + RAW_CHECKSUM_COLUMN + " FROM " in addRawChecksumColumnUnlessPresent()
238 db.execSQL("ALTER TABLE " + METADATA_TABLE_NAME + " ADD COLUMN " in addRawChecksumColumnUnlessPresent()
245 db.execSQL("SELECT " + RETRY_COUNT_COLUMN + " FROM " in addRetryCountColumnUnlessPresent()
249 db.execSQL("ALTER TABLE " + METADATA_TABLE_NAME + " ADD COLUMN " in addRetryCountColumnUnlessPresent()
286 db.execSQL("DROP TABLE IF EXISTS " + CLIENT_TABLE_NAME); in onUpgrade()
295 db.execSQL("DROP TABLE IF EXISTS " + METADATA_TABLE_NAME); in onUpgrade()
296 db.execSQL("DROP TABLE IF EXISTS " + CLIENT_TABLE_NAME); in onUpgrade()
328 db.execSQL("DROP TABLE IF EXISTS " + METADATA_TABLE_NAME); in onDowngrade()
[all …]
/packages/apps/Settings/src/com/android/settings/search/
DIndexDatabaseHelper.java158 db.execSQL(CREATE_INDEX_TABLE); in bootstrapDB()
159 db.execSQL(CREATE_META_TABLE); in bootstrapDB()
160 db.execSQL(CREATE_SAVED_QUERIES_TABLE); in bootstrapDB()
161 db.execSQL(INSERT_BUILD_VERSION); in bootstrapDB()
235 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_META_INDEX); in dropTables()
236 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_PREFS_INDEX); in dropTables()
237 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_SAVED_QUERIES); in dropTables()
/packages/apps/DeskClock/src/com/android/deskclock/provider/
DClockDatabaseHelper.java73 db.execSQL("CREATE TABLE " + ALARMS_TABLE_NAME + " (" + in createAlarmsTable()
87 db.execSQL("CREATE TABLE " + INSTANCES_TABLE_NAME + " (" + in createInstanceTable()
126 db.execSQL(insertMe + DEFAULT_ALARM_1); in onCreate()
127 db.execSQL(insertMe + DEFAULT_ALARM_2); in onCreate()
136 db.execSQL("DROP TABLE IF EXISTS " + SELECTED_CITIES_TABLE_NAME + ";"); in onUpgrade()
141 db.execSQL("DROP TABLE IF EXISTS " + INSTANCES_TABLE_NAME + ";"); in onUpgrade()
190 db.execSQL("DROP TABLE IF EXISTS " + OLD_ALARMS_TABLE_NAME + ";"); in onUpgrade()
/packages/apps/Launcher3/src/com/android/launcher3/
DLauncherProvider.java601 db.execSQL("CREATE TABLE " + ifNotExists + TABLE_FAVORITES + " (" + in addFavoritesTable()
631 db.execSQL("CREATE TABLE " + ifNotExists + TABLE_WORKSPACE_SCREENS + " (" + in addWorkspacesTable()
649 db.execSQL(removeOrphanedDesktopItems); in removeOrphanedItems()
666 db.execSQL(removeOrphanedFolderItems); in removeOrphanedItems()
689 db.execSQL("ALTER TABLE favorites " + in onUpgrade()
704 db.execSQL("ALTER TABLE favorites " + in onUpgrade()
706 db.execSQL("ALTER TABLE workspaceScreens " + in onUpgrade()
792 db.execSQL("DROP TABLE IF EXISTS " + TABLE_FAVORITES); in createEmptyDB()
793 db.execSQL("DROP TABLE IF EXISTS " + TABLE_WORKSPACE_SCREENS); in createEmptyDB()
878 db.execSQL("DROP TABLE IF EXISTS " + TABLE_WORKSPACE_SCREENS); in recreateWorkspaceTable()
[all …]
/packages/providers/BlockedNumberProvider/src/com/android/providers/blockednumber/
DBlockedNumberDatabaseHelper.java55 db.execSQL("DROP TABLE IF EXISTS blocked"); in onUpgrade()
61 db.execSQL("CREATE TABLE " + Tables.BLOCKED_NUMBERS + " (" + in createTables()
67 db.execSQL("CREATE INDEX blocked_number_idx_original ON " + Tables.BLOCKED_NUMBERS + in createTables()
69 db.execSQL("CREATE INDEX blocked_number_idx_e164 ON " + Tables.BLOCKED_NUMBERS + " (" + in createTables()
105 getWritableDatabase().execSQL("DELETE FROM " + Tables.BLOCKED_NUMBERS); in wipeForTest()
/packages/providers/ContactsProvider/tests/src/com/android/providers/contacts/
DSynchronousContactsProvider2.java196 db.execSQL("UPDATE raw_contacts SET aggregation_mode=0,aggregation_needed=1;");
200 db.execSQL("DELETE FROM raw_contacts WHERE _id > " + rowId + ";");
218 db.execSQL("replace into SQLITE_SEQUENCE (name,seq) values('raw_contacts', 42)");
219 db.execSQL("replace into SQLITE_SEQUENCE (name,seq) values('contacts', 2009)");
220 db.execSQL("replace into SQLITE_SEQUENCE (name,seq) values('data', 777)");
/packages/apps/Messaging/src/com/android/messaging/sms/
DApnDatabase.java308 db.execSQL("DROP TABLE IF EXISTS " + APN_TABLE + ";"); in rebuildTables()
309 db.execSQL(APN_TABLE_SQL); in rebuildTables()
356 db.execSQL("DROP TABLE IF EXISTS " + APN_TABLE); in forceBuildAndLoadApnTables()
361 db.execSQL(APN_TABLE_SQL); in forceBuildAndLoadApnTables()
371 db.execSQL("DROP TABLE IF EXISTS " + APN_TABLE); in clearTables()
372 db.execSQL(APN_TABLE_SQL); in clearTables()
/packages/apps/CellBroadcastReceiver/src/com/android/cellbroadcastreceiver/
DCellBroadcastDatabaseHelper.java63 db.execSQL("CREATE TABLE " + TABLE_NAME + " (" in onCreate()
89 db.execSQL("CREATE INDEX IF NOT EXISTS deliveryTimeIndex ON " + TABLE_NAME in createDeliveryTimeIndex()
127 db.execSQL("DROP TABLE IF EXISTS " + TEMP_TABLE_NAME); in onUpgrade()
128 db.execSQL("ALTER TABLE " + TABLE_NAME + " RENAME TO " + TEMP_TABLE_NAME); in onUpgrade()
145 db.execSQL("DROP TABLE " + TEMP_TABLE_NAME); in onUpgrade()
/packages/providers/ContactsProvider/src/com/android/providers/contacts/database/
DContactsTableUtil.java46 db.execSQL("CREATE INDEX contacts_has_phone_index ON " + table + " (" + in createIndexes()
50 db.execSQL("CREATE INDEX contacts_name_raw_contact_id_index ON " + table + " (" + in createIndexes()
54 db.execSQL(MoreDatabaseUtils.buildCreateIndexSql(table, in createIndexes()
78 db.execSQL(buildUpdateLastUpdateSql(rawContactIds)); in updateContactLastUpdateByRawContactId()
/packages/apps/Gallery2/src/com/android/gallery3d/gadget/
DWidgetDatabaseHelper.java101 db.execSQL("CREATE TABLE " + TABLE_WIDGETS + " (" in onCreate()
173 db.execSQL("DROP TABLE IF EXISTS photos"); in onUpgrade()
174 db.execSQL("DROP TABLE IF EXISTS " + TABLE_WIDGETS); in onUpgrade()
182 db.execSQL("ALTER TABLE widgets ADD COLUMN relativePath TEXT"); in onUpgrade()
/packages/apps/TV/usbtuner/src/com/android/usbtuner/
DUsbTunerPreferenceProvider.java119 db.execSQL("CREATE TABLE " + PREFERENCES_TABLE + " (" in onCreate()
125 db.execSQL("CREATE INDEX " + PREFERENCES_TABLE_ID_INDEX + " ON " + PREFERENCES_TABLE in onCreate()
127 db.execSQL("CREATE INDEX " + PREFERENCES_TABLE_KEY_INDEX + " ON " + PREFERENCES_TABLE in onCreate()

123