Home
last modified time | relevance | path

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

123456

/packages/providers/MediaProvider/tests/src/com/android/providers/media/
DDatabaseHelperTest.java821 db.execSQL("CREATE TABLE android_metadata (locale TEXT)"); in createOSchema()
822 db.execSQL("CREATE TABLE thumbnails (_id INTEGER PRIMARY KEY,_data TEXT,image_id INTEGER," in createOSchema()
824 db.execSQL("CREATE TABLE artists (artist_id INTEGER PRIMARY KEY," in createOSchema()
826 db.execSQL("CREATE TABLE albums (album_id INTEGER PRIMARY KEY," in createOSchema()
828 db.execSQL("CREATE TABLE album_art (album_id INTEGER PRIMARY KEY,_data TEXT)"); in createOSchema()
829 db.execSQL("CREATE TABLE videothumbnails (_id INTEGER PRIMARY KEY,_data TEXT," in createOSchema()
831 db.execSQL("CREATE TABLE files (_id INTEGER PRIMARY KEY AUTOINCREMENT," in createOSchema()
844 db.execSQL("CREATE TABLE log (time DATETIME, message TEXT)"); in createOSchema()
846 db.execSQL("CREATE TABLE audio_genres (_id INTEGER PRIMARY KEY,name TEXT NOT NULL)"); in createOSchema()
847 db.execSQL("CREATE TABLE audio_genres_map (_id INTEGER PRIMARY KEY," in createOSchema()
[all …]
/packages/providers/MediaProvider/src/com/android/providers/media/
DLegacyDatabaseHelper.java246 db.execSQL("UPDATE local_metadata SET generation=generation+1;"); in beginTransactionInternal()
386 db.execSQL("DROP TRIGGER IF EXISTS " + c.getString(0)); in makePristineSchema()
395 db.execSQL("DROP VIEW IF EXISTS " + c.getString(0)); in makePristineSchema()
404 db.execSQL("DROP INDEX IF EXISTS " + c.getString(0)); in makePristineSchema()
413 db.execSQL("DROP TABLE IF EXISTS " + c.getString(0)); in makePristineSchema()
437 db.execSQL("CREATE TABLE local_metadata (generation INTEGER DEFAULT 0)"); in createLatestSchema()
438 db.execSQL("INSERT INTO local_metadata VALUES (0)"); in createLatestSchema()
440 db.execSQL("CREATE TABLE android_metadata (locale TEXT)"); in createLatestSchema()
441 db.execSQL("CREATE TABLE thumbnails (_id INTEGER PRIMARY KEY,_data TEXT,image_id INTEGER," in createLatestSchema()
443 db.execSQL("CREATE TABLE album_art (album_id INTEGER PRIMARY KEY,_data TEXT)"); in createLatestSchema()
[all …]
DDatabaseHelper.java779 db.execSQL("UPDATE local_metadata SET generation=generation+1;"); in beginTransactionInternal()
1008 db.execSQL("DROP TRIGGER IF EXISTS " + c.getString(0)); in makePristineSchema()
1017 db.execSQL("DROP VIEW IF EXISTS " + c.getString(0)); in makePristineSchema()
1026 db.execSQL("DROP INDEX IF EXISTS " + c.getString(0)); in makePristineSchema()
1035 db.execSQL("DROP TABLE IF EXISTS " + c.getString(0)); in makePristineSchema()
1059 db.execSQL("CREATE TABLE local_metadata (generation INTEGER DEFAULT 0)"); in createLatestSchema()
1060 db.execSQL("INSERT INTO local_metadata VALUES (0)"); in createLatestSchema()
1062 db.execSQL("CREATE TABLE android_metadata (locale TEXT)"); in createLatestSchema()
1063 db.execSQL("CREATE TABLE thumbnails (_id INTEGER PRIMARY KEY,_data TEXT,image_id INTEGER," in createLatestSchema()
1065 db.execSQL("CREATE TABLE album_art (album_id INTEGER PRIMARY KEY,_data TEXT)"); in createLatestSchema()
[all …]
/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/modules/Bluetooth/android/app/src/com/android/bluetooth/btservice/storage/
DMetadataDatabase.java130 database.execSQL("ALTER TABLE metadata ADD COLUMN `pbap_client_priority` INTEGER");
138 database.execSQL("CREATE TABLE IF NOT EXISTS `metadata_tmp` ("
157 database.execSQL("INSERT INTO metadata_tmp ("
192 database.execSQL("DROP TABLE `metadata`");
193 database.execSQL("ALTER TABLE `metadata_tmp` RENAME TO `metadata`");
202 database.execSQL("CREATE TABLE IF NOT EXISTS `metadata_tmp` ("
224 database.execSQL("INSERT INTO metadata_tmp ("
264 database.execSQL("UPDATE metadata_tmp SET a2dp_connection_policy = 100 "
266 database.execSQL("UPDATE metadata_tmp SET a2dp_sink_connection_policy = 100 "
268 database.execSQL("UPDATE metadata_tmp SET hfp_connection_policy = 100 "
[all …]
/packages/providers/CalendarProvider/tests/src/com/android/providers/calendar/
DCalendarDatabaseHelperTest.java65 db.execSQL("CREATE TABLE Calendars (" + in bootstrapDbVersion50()
87 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON Calendars " + in bootstrapDbVersion50()
94 db.execSQL("CREATE TABLE Events (" + in bootstrapDbVersion50()
131 db.execSQL("CREATE INDEX eventsCalendarIdIndex ON Events (calendar_id);"); in bootstrapDbVersion50()
133 db.execSQL("CREATE TABLE EventsRawTimes (" + in bootstrapDbVersion50()
146 db.execSQL("CREATE TABLE DeletedEvents (" + in bootstrapDbVersion50()
153 db.execSQL("CREATE TABLE Instances (" + in bootstrapDbVersion50()
165 db.execSQL("CREATE INDEX instancesStartDayIndex ON Instances (startDay);"); in bootstrapDbVersion50()
167 db.execSQL("CREATE TABLE CalendarMetaData (" + in bootstrapDbVersion50()
176 db.execSQL("CREATE TABLE BusyBits(" + in bootstrapDbVersion50()
[all …]
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/
DMmsSmsDatabaseHelper.java443 db.execSQL( in updateThreads()
467 db.execSQL( in updateThreads()
495 db.execSQL( in updateThreads()
701 db.execSQL("DROP TABLE IF EXISTS " + MmsProvider.TABLE_WORDS); in createWordsTables()
702 …db.execSQL("CREATE VIRTUAL TABLE words USING FTS3 (_id INTEGER PRIMARY KEY, index_text TEXT, sourc… in createWordsTables()
709 db.execSQL("CREATE TRIGGER IF NOT EXISTS sms_words_update AFTER UPDATE ON sms " in createWordsTables()
712 db.execSQL("CREATE TRIGGER IF NOT EXISTS sms_words_delete AFTER DELETE ON sms " in createWordsTables()
736 db.execSQL("CREATE INDEX IF NOT EXISTS typeThreadIdIndex ON sms" + in createThreadIdIndex()
751 db.execSQL("CREATE INDEX IF NOT EXISTS threadIdDateIndex ON sms" + in createThreadIdDateIndex()
766 db.execSQL("CREATE INDEX IF NOT EXISTS partMidIndex ON part (mid)"); in createPartMidIndex()
[all …]
DCarrierDatabaseHelper.java80 db.execSQL(getStringForCarrierKeyTableCreation(CARRIER_KEY_TABLE)); in onCreate()
84 db.execSQL(getStringForCarrierKeyTableCreation(CARRIER_KEY_TABLE)); in createCarrierTable()
88 db.execSQL("DROP TABLE IF EXISTS " + CARRIER_KEY_TABLE + ";"); in dropCarrierTable()
105 db.execSQL("COMMIT"); in onUpgrade()
112 db.execSQL( in renameCarrierTable()
125 db.execSQL(copyStr); in copyContents()
130 db.execSQL("DROP TABLE IF EXISTS " + TEMPORARY_CARRIER_KEY_TABLE + ";"); in dropTemporaryTable()
DTelephonyProvider.java768 db.execSQL(getStringForSimInfoTableCreation(tableName)); in createSimInfoTable()
775 db.execSQL(getStringForCarrierTableCreation(tableName)); in createCarriersTable()
986 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
993 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
995 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
1001 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
1003 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
1010 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
1012 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
1017 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
[all …]
/packages/providers/MediaProvider/src/com/android/providers/media/photopicker/data/
DPickerDatabaseHelper.java112 db.execSQL("DROP TABLE IF EXISTS " + c.getString(0)); in makePristineSchema()
124 db.execSQL("DROP INDEX IF EXISTS " + c.getString(0)); in makePristineIndexes()
132 db.execSQL("CREATE TABLE media (_id INTEGER PRIMARY KEY AUTOINCREMENT," in createLatestSchema()
149 db.execSQL("CREATE TABLE album_media (_id INTEGER PRIMARY KEY AUTOINCREMENT," in createLatestSchema()
168 db.execSQL("CREATE INDEX local_id_index on media(local_id)"); in createLatestIndexes()
169 db.execSQL("CREATE INDEX cloud_id_index on media(cloud_id)"); in createLatestIndexes()
170 db.execSQL("CREATE INDEX is_visible_index on media(is_visible)"); in createLatestIndexes()
171 db.execSQL("CREATE INDEX date_taken_index on media(date_taken_ms)"); in createLatestIndexes()
172 db.execSQL("CREATE INDEX size_index on media(size_bytes)"); in createLatestIndexes()
173 db.execSQL("CREATE INDEX mime_type_index on media(mime_type)"); in createLatestIndexes()
[all …]
/packages/providers/ContactsProvider/src/com/android/providers/contacts/
DContactsDatabaseHelper.java1114 db.execSQL("DELETE FROM " + Tables.PRESENCE + ";"); in onOpen()
1115 db.execSQL("DELETE FROM " + Tables.AGGREGATED_PRESENCE + ";"); in onOpen()
1154 db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.PRESENCE + " ("+ in createPresenceTables()
1168 db.execSQL("CREATE INDEX IF NOT EXISTS presenceIndex" + " ON " in createPresenceTables()
1170 db.execSQL("CREATE INDEX IF NOT EXISTS presenceIndex2" + " ON " in createPresenceTables()
1173 db.execSQL("CREATE TABLE IF NOT EXISTS " in createPresenceTables()
1181 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_deleted" in createPresenceTables()
1221 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_inserted" in createPresenceTables()
1227 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_updated" in createPresenceTables()
1246 db.execSQL("CREATE TABLE " + Tables.ACCOUNTS + " (" + in onCreate()
[all …]
DCallLogDatabaseHelper.java134 db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + in onCreate()
192 db.execSQL("CREATE TABLE " + Tables.VOICEMAIL_STATUS + " (" + in onCreate()
331 db.execSQL("ALTER TABLE " + Tables.CALLS + " ADD " + Calls.VIA_NUMBER + in upgradeToVersion2()
339 db.execSQL("ALTER TABLE " + Tables.VOICEMAIL_STATUS + " ADD " + Status.SOURCE_TYPE + in upgradeToVersion3()
348 db.execSQL("ALTER TABLE calls ADD backed_up INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
349 db.execSQL("ALTER TABLE calls ADD restored INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
350 db.execSQL("ALTER TABLE calls ADD archived INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
351 db.execSQL("ALTER TABLE calls ADD is_omtp_voicemail INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
358 db.execSQL("ALTER TABLE calls ADD transcription_state INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion5()
367 db.execSQL("ALTER TABLE calls ADD call_screening_component_name TEXT"); in upgradeToVersion6()
[all …]
/packages/modules/OnDevicePersonalization/src/com/android/ondevicepersonalization/services/data/
DOnDevicePersonalizationDbHelper.java73 db.execSQL(VendorSettingsContract.VendorSettingsEntry.CREATE_TABLE_STATEMENT); in onCreate()
76 db.execSQL(QueriesContract.QueriesEntry.CREATE_TABLE_STATEMENT); in onCreate()
77 db.execSQL(EventsContract.EventsEntry.CREATE_TABLE_STATEMENT); in onCreate()
80 db.execSQL(UserDataTables.LocationHistory.CREATE_TABLE_STATEMENT); in onCreate()
81 db.execSQL(UserDataTables.LocationHistory.CREATE_INDEXES_STATEMENT); in onCreate()
82 db.execSQL(UserDataTables.AppUsageHistory.CREATE_TABLE_STATEMENT); in onCreate()
83 db.execSQL(UserDataTables.AppUsageHistory.CREATE_STARTING_TIME_SEC_INDEX_STATEMENT); in onCreate()
84 db.execSQL(UserDataTables.AppUsageHistory.CREATE_ENDING_TIME_SEC_INDEX_STATEMENT); in onCreate()
85 db.execSQL(UserDataTables.AppUsageHistory.CREATE_TOTAL_TIME_USED_SEC_INDEX_STATEMENT); in onCreate()
/packages/providers/TvProvider/tests/src/com/android/providers/tv/
DDatabaseHelperTest.java114 db.execSQL("CREATE TABLE " + TvProvider.CHANNELS_TABLE + " (" in onCreate()
142 db.execSQL("CREATE TABLE " + TvProvider.PROGRAMS_TABLE + " (" in onCreate()
171 db.execSQL("CREATE INDEX " + TvProvider.PROGRAMS_TABLE_PACKAGE_NAME_INDEX + " ON " in onCreate()
174 db.execSQL("CREATE INDEX " + TvProvider.PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " in onCreate()
177 db.execSQL("CREATE INDEX " + TvProvider.PROGRAMS_TABLE_START_TIME_INDEX + " ON " in onCreate()
180 db.execSQL("CREATE INDEX " + TvProvider.PROGRAMS_TABLE_END_TIME_INDEX + " ON " in onCreate()
183 db.execSQL("CREATE TABLE " + TvProvider.WATCHED_PROGRAMS_TABLE + " (" in onCreate()
206 db.execSQL("CREATE INDEX " + TvProvider.WATCHED_PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " in onCreate()
214 db.execSQL("DROP TABLE IF EXISTS " + TvProvider.WATCH_NEXT_PROGRAMS_TABLE); in onDowngrade()
215 db.execSQL("DROP TABLE IF EXISTS " + TvProvider.PREVIEW_PROGRAMS_TABLE); in onDowngrade()
[all …]
/packages/modules/AdServices/adservices/service-core/java/com/android/adservices/data/measurement/migration/
DMigrationHelpers.java54 db.execSQL("PRAGMA foreign_keys=OFF"); in copyAndUpdateTable()
55 db.execSQL(renameTableQuery); in copyAndUpdateTable()
56 db.execSQL(createTableQuery); in copyAndUpdateTable()
70 db.execSQL(dropBackupTable); in copyAndUpdateTable()
84 db.execSQL(insertValuesFromBackupQuery); in copyAndUpdateTable()
85 db.execSQL(dropBackupTable); in copyAndUpdateTable()
86 db.execSQL("PRAGMA foreign_keys=ON"); in copyAndUpdateTable()
102 db.execSQL(String.format("ALTER TABLE %1$s ADD %2$s INTEGER", tableName, columnName)); in addIntColumnIfAbsent()
110 db.execSQL(String.format("ALTER TABLE %1$s ADD %2$s TEXT", tableName, columnName)); in addTextColumnIfAbsent()
DMeasurementDbMigratorV9.java236 db.execSQL(MeasurementTables.CREATE_TABLE_SOURCE_DESTINATION_LATEST); in performMigration()
237 db.execSQL(SOURCE_DESTINATION_CREATE_INDEX_D); in performMigration()
238 db.execSQL(SOURCE_DESTINATION_CREATE_INDEX_S); in performMigration()
239 db.execSQL(MIGRATE_SOURCE_APP_DESTINATION); in performMigration()
240 db.execSQL(MIGRATE_SOURCE_WEB_DESTINATION); in performMigration()
251 db.execSQL(SOURCE_CREATE_INDEX_EI); in alterSourceTable()
252 db.execSQL(SOURCE_CREATE_INDEX_EI_ET); in alterSourceTable()
253 db.execSQL(SOURCE_CREATE_INDEX_ET); in alterSourceTable()
254 db.execSQL(SOURCE_CREATE_INDEX_P_S_ET); in alterSourceTable()
/packages/providers/TvProvider/src/com/android/providers/tv/
DTvProvider.java837 db.execSQL("CREATE TABLE " + CHANNELS_TABLE + " (" in onCreate()
878 db.execSQL("CREATE TABLE " + PROGRAMS_TABLE + " (" in onCreate()
922 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_PACKAGE_NAME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
924 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
926 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_START_TIME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
928 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_END_TIME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
930 db.execSQL("CREATE TABLE " + WATCHED_PROGRAMS_TABLE + " (" in onCreate()
952 db.execSQL("CREATE INDEX " + WATCHED_PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " in onCreate()
954 db.execSQL(CREATE_RECORDED_PROGRAMS_TABLE_SQL); in onCreate()
955 db.execSQL(CREATE_PREVIEW_PROGRAMS_TABLE_SQL); in onCreate()
[all …]
/packages/providers/TelephonyProvider/tests/src/com/android/providers/telephony/
DMmsSmsDatabaseHelperTest.java194 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_PDU + " (" + in createMmsTables()
225 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_ADDR + " (" + in createMmsTables()
233 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_PART + " (" + in createMmsTables()
248 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_RATE + " (" + in createMmsTables()
251 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_DRM + " (" + in createMmsTables()
261 db.execSQL("CREATE TABLE sms (" + in createSmsTables()
276 db.execSQL("CREATE TABLE raw (" + in createSmsTables()
286 db.execSQL("CREATE TABLE attachments (" + in createSmsTables()
291 db.execSQL("CREATE TABLE sr_pending (" + in createSmsTables()
302 db.execSQL("CREATE TABLE canonical_addresses (" + in createCommonTables()
[all …]
DMmsProviderTestable.java64 db.execSQL(CREATE_PDU_TABLE_STR); in onCreate()
65 db.execSQL(CREATE_ADDR_TABLE_STR); in onCreate()
66 db.execSQL(CREATE_PART_TABLE_STR); in onCreate()
67 db.execSQL(CREATE_RATE_TABLE_STR); in onCreate()
68 db.execSQL(CREATE_DRM_TABLE_STR); in onCreate()
/packages/apps/Dialer/java/com/android/dialer/database/
DDialerDatabaseHelper.java115 db.execSQL( in setupTables()
151 db.execSQL( in setupTables()
163 db.execSQL( in setupTables()
176 db.execSQL( in setupTables()
207 db.execSQL("DROP TABLE IF EXISTS " + Tables.PREFIX_TABLE); in dropTables()
208 db.execSQL("DROP TABLE IF EXISTS " + Tables.SMARTDIAL_TABLE); in dropTables()
209 db.execSQL("DROP TABLE IF EXISTS " + Tables.PROPERTIES); in dropTables()
210 db.execSQL("DROP TABLE IF EXISTS " + Tables.FILTERED_NUMBER_TABLE); in dropTables()
211 db.execSQL("DROP TABLE IF EXISTS " + Tables.VOICEMAIL_ARCHIVE_TABLE); in dropTables()
234 db.execSQL("DROP TABLE IF EXISTS " + Tables.FILTERED_NUMBER_TABLE); in onUpgrade()
[all …]
/packages/apps/TV/tests/common/src/com/android/tv/testing/fakes/
DFakeTvProvider.java998 db.execSQL( in onCreate()
1073 db.execSQL( in onCreate()
1149 db.execSQL( in onCreate()
1157 db.execSQL( in onCreate()
1165 db.execSQL( in onCreate()
1173 db.execSQL( in onCreate()
1181 db.execSQL( in onCreate()
1221 db.execSQL( in onCreate()
1229 db.execSQL(CREATE_RECORDED_PROGRAMS_TABLE_SQL); in onCreate()
1230 db.execSQL(CREATE_PREVIEW_PROGRAMS_TABLE_SQL); in onCreate()
[all …]
/packages/apps/Dialer/java/com/android/dialer/calllog/database/
DAnnotatedCallLogDatabaseHelper.java150 db.execSQL(CREATE_TABLE_SQL); in onCreate()
151 db.execSQL(String.format(Locale.US, CREATE_TRIGGER_SQL, maxRows, maxRows)); in onCreate()
152 db.execSQL(CREATE_INDEX_ON_CALL_TYPE_SQL); in onCreate()
153 db.execSQL(CREATE_INDEX_ON_NUMBER_SQL); in onCreate()
175 db.execSQL( in upgradeToV2()
181 db.execSQL( in upgradeToV2()
205 db.execSQL( in upgradeToV4()
/packages/apps/TV/src/com/android/tv/dvr/provider/
DDvrDatabaseHelper.java310 db.execSQL(SQL_CREATE_SCHEDULES_WITH_TIME_OFFSET); in onCreate()
313 db.execSQL(SQL_CREATE_SCHEDULES); in onCreate()
316 db.execSQL(SQL_CREATE_SERIES_RECORDINGS); in onCreate()
323 db.execSQL(SQL_DROP_SCHEDULES); in onUpgrade()
325 db.execSQL(SQL_DROP_SERIES_RECORDINGS); in onUpgrade()
330 db.execSQL( in onUpgrade()
338 db.execSQL("ALTER TABLE " + Schedules.TABLE_NAME + " ADD COLUMN " in onUpgrade()
340 db.execSQL("ALTER TABLE " + Schedules.TABLE_NAME + " ADD COLUMN " in onUpgrade()
349 db.execSQL(buildCreateSchedulesSql(schedulesBackup, COLUMNS_SCHEDULES)); in onDowngrade()
350 db.execSQL("INSERT INTO " + schedulesBackup + in onDowngrade()
[all …]
/packages/apps/SettingsIntelligence/src/com/android/settings/intelligence/search/indexing/
DIndexDatabaseHelper.java201 db.execSQL(CREATE_INDEX_TABLE); in bootstrapDB()
202 db.execSQL(CREATE_META_TABLE); in bootstrapDB()
203 db.execSQL(CREATE_SAVED_QUERIES_TABLE); in bootstrapDB()
204 db.execSQL(CREATE_SITE_MAP_TABLE); in bootstrapDB()
205 db.execSQL(INSERT_BUILD_VERSION); in bootstrapDB()
350 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_META_INDEX); in dropTables()
351 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_PREFS_INDEX); in dropTables()
352 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_SAVED_QUERIES); in dropTables()
353 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_SITE_MAP); in dropTables()
/packages/modules/AdServices/adservices/service-core/java/com/android/adservices/data/measurement/
DMeasurementDbHelper.java124 db.execSQL("PRAGMA foreign_keys=ON"); in onOpen()
175 MeasurementTables.CREATE_STATEMENTS_V6.forEach(db::execSQL); in createV6Schema()
176 Arrays.stream(MeasurementTables.CREATE_INDEXES_V6).forEach(db::execSQL); in createV6Schema()
181 MeasurementTables.CREATE_STATEMENTS.forEach(db::execSQL); in createSchema()
182 Arrays.stream(MeasurementTables.CREATE_INDEXES).forEach(db::execSQL); in createSchema()
209 db.execSQL("PRAGMA foreign_keys=OFF"); in deleteV6TablesFromDatabase()
213 db.execSQL( in deleteV6TablesFromDatabase()
216 db.execSQL("PRAGMA foreign_keys=ON"); in deleteV6TablesFromDatabase()

123456