Home
last modified time | relevance | path

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

12

/frameworks/base/core/tests/coretests/src/android/database/
DNewDatabasePerformanceTests.java166 mDatabase.execSQL("CREATE TABLE " + t + "(a INTEGER, b INTEGER, c VARCHAR(100))"); in testRun()
167 mDatabase.execSQL("INSERT INTO " + t + " VALUES(" + i + "," + i + ",'" in testRun()
190 mDatabase.execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in prepareForTest()
195 mDatabase.execSQL(mStatements[i]); in testRun()
217 mDatabase.execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in prepareForTest()
218 mDatabase.execSQL("CREATE INDEX i1c ON t1(c)"); in prepareForTest()
223 mDatabase.execSQL(mStatements[i]); in testRun()
241 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in prepareForTest()
245 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'" in prepareForTest()
277 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in prepareForTest()
[all …]
DDatabaseGeneralTest.java92 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);"); in populateDefaultTable()
94 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');"); in populateDefaultTable()
95 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');"); in populateDefaultTable()
96 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');"); in populateDefaultTable()
123 mDatabase.execSQL("CREATE TABLE phones (num TEXT);"); in testPhoneNumbersEqual()
124 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('911');"); in testPhoneNumbersEqual()
125 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('5555');"); in testPhoneNumbersEqual()
126 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('+" + PHONE_NUMBER + "');"); in testPhoneNumbersEqual()
351 mDatabase.execSQL("CREATE TABLE guess (numi INTEGER, numf FLOAT, str TEXT);"); in testCopyString()
352 mDatabase.execSQL( in testCopyString()
[all …]
DDatabaseCursorTest.java80 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);"); in populateDefaultTable()
82 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');"); in populateDefaultTable()
83 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');"); in populateDefaultTable()
84 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');"); in populateDefaultTable()
90 mDatabase.execSQL( in testBlob()
108 mDatabase.execSQL(sql, args); in testBlob()
128 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data REAL);"); in testRealColumns()
235 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);"); in testLargeField()
246 mDatabase.execSQL(sql.toString()); in testLargeField()
291 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data INT);"); in testManyRowsLong()
[all …]
DDatabaseStatementTest.java72 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);"); in populateDefaultTable()
74 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');"); in populateDefaultTable()
75 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');"); in populateDefaultTable()
76 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');"); in populateDefaultTable()
93 mDatabase.execSQL("CREATE TABLE test (num INTEGER NOT NULL, str TEXT NOT NULL);"); in testSimpleQuery()
94 mDatabase.execSQL("INSERT INTO test VALUES (1234, 'hello');"); in testSimpleQuery()
130 mDatabase.execSQL("CREATE TABLE test (num INTEGER);"); in testStatementLongBinding()
152 mDatabase.execSQL("CREATE TABLE test (num TEXT);"); in testStatementStringBinding()
174 mDatabase.execSQL("CREATE TABLE test (num INTEGER);"); in testStatementClearBindings()
196 mDatabase.execSQL("CREATE TABLE test (num TEXT, value TEXT);"); in testSimpleStringBinding()
[all …]
DDatabaseStressTest.java52 mDatabase.execSQL("CREATE TABLE IF NOT EXISTS test (_id INTEGER PRIMARY KEY, data TEXT);"); in setUp()
71 mDatabase.execSQL("INSERT INTO test (data) VALUES (?)", strArr); in testSingleThreadInsertDelete()
72 mDatabase.execSQL("delete from test;"); in testSingleThreadInsertDelete()
93 mDatabase.execSQL("INSERT INTO test (data) VALUES (?)", strArr); in testOutOfSpace()
DDatabaseLocaleTest.java49 mDatabase.execSQL( in setUp()
55 mDatabase.execSQL("INSERT INTO test (data) VALUES('" + s + "');"); in insertStrings()
114 mDatabase.execSQL("INSERT INTO test(id, data) VALUES(1, '" + expectedString + "')"); in testHoge()
DDatabaseErrorHandlerTest.java66 mDatabase.execSQL("create table t (i int);"); in testDatabaseIsCorrupt()
75 mDatabase.execSQL("select * from t;"); in testDatabaseIsCorrupt()
/frameworks/base/services/tests/servicestests/src/com/android/server/accounts/
DPreNTestDatabaseHelper.java40 db.execSQL("CREATE TABLE accounts ( " in onCreate()
46 db.execSQL("INSERT INTO accounts (name, type, password) VALUES " in onCreate()
49 db.execSQL("CREATE TABLE authtokens ( " in onCreate()
55 db.execSQL("INSERT INTO authtokens (accounts_id, type, authtoken) VALUES " in onCreate()
58 db.execSQL("CREATE TABLE grants ( " in onCreate()
64 db.execSQL("CREATE TABLE extras ( " in onCreate()
71 db.execSQL("CREATE TABLE meta ( " in onCreate()
75 db.execSQL("" in onCreate()
/frameworks/base/services/core/java/com/android/server/locksettings/recoverablekeystore/storage/
DRecoverableKeyStoreDbHelper.java109 db.execSQL(SQL_CREATE_KEYS_ENTRY); in onCreate()
110 db.execSQL(SQL_CREATE_USER_METADATA_ENTRY); in onCreate()
111 db.execSQL(SQL_CREATE_RECOVERY_SERVICE_METADATA_ENTRY); in onCreate()
112 db.execSQL(SQL_CREATE_ROOT_OF_TRUST_ENTRY); in onCreate()
156 db.execSQL(SQL_DELETE_KEYS_ENTRY); in dropAllKnownTables()
157 db.execSQL(SQL_DELETE_USER_METADATA_ENTRY); in dropAllKnownTables()
158 db.execSQL(SQL_DELETE_RECOVERY_SERVICE_METADATA_ENTRY); in dropAllKnownTables()
159 db.execSQL(SQL_DELETE_ROOT_OF_TRUST_ENTRY); in dropAllKnownTables()
174 db.execSQL(SQL_CREATE_ROOT_OF_TRUST_ENTRY); in upgradeDbForVersion4()
207 db.execSQL(alterStr + ";"); in addColumnToTable()
/frameworks/base/packages/SettingsProvider/src/com/android/providers/settings/
DDatabaseHelper.java175 db.execSQL("CREATE TABLE secure (" + in createSecureTable()
180 db.execSQL("CREATE INDEX secureIndex1 ON secure (name);"); in createSecureTable()
184 db.execSQL("CREATE TABLE global (" + in createGlobalTable()
189 db.execSQL("CREATE INDEX globalIndex1 ON global (name);"); in createGlobalTable()
194 db.execSQL("CREATE TABLE system (" + in onCreate()
199 db.execSQL("CREATE INDEX systemIndex1 ON system (name);"); in onCreate()
208 db.execSQL("CREATE TABLE bluetooth_devices (" + in onCreate()
216 db.execSQL("CREATE TABLE bookmarks (" + in onCreate()
225 db.execSQL("CREATE INDEX bookmarksIndex1 ON bookmarks (folder);"); in onCreate()
226 db.execSQL("CREATE INDEX bookmarksIndex2 ON bookmarks (shortcut);"); in onCreate()
[all …]
/frameworks/base/services/core/java/com/android/server/accounts/
DAccountsDb.java210 db.execSQL("CREATE TABLE " + TABLE_ACCOUNTS + " ( " in onCreate()
217 db.execSQL("CREATE TABLE " + TABLE_AUTHTOKENS + " ( " in onCreate()
224 db.execSQL("CREATE TABLE " + TABLE_EXTRAS + " ( " in onCreate()
235 db.execSQL("" in createAccountsDeletionTrigger()
253 db.execSQL("DROP TABLE IF EXISTS " + TABLE_META); in onUpgrade()
254 db.execSQL("DROP TABLE IF EXISTS " + TABLE_SHARED_ACCOUNTS); in onUpgrade()
256 db.execSQL("DROP TRIGGER IF EXISTS " + TABLE_ACCOUNTS + "Delete"); in onUpgrade()
258 db.execSQL("DROP TABLE IF EXISTS " + TABLE_GRANTS); in onUpgrade()
259 db.execSQL("DROP TABLE IF EXISTS " + TABLE_DEBUG); in onUpgrade()
525 db.execSQL("CREATE TABLE " + TABLE_ACCOUNTS + " ( " in onCreate()
[all …]
/frameworks/base/services/backup/java/com/android/server/backup/encryption/storage/
DBackupEncryptionDbHelper.java58 db.execSQL(SQL_DROP_TERTIARY_KEYS_ENTRY); in resetDatabase()
64 db.execSQL(SQL_CREATE_TERTIARY_KEYS_ENTRY); in onCreate()
69 db.execSQL(SQL_DROP_TERTIARY_KEYS_ENTRY); in onUpgrade()
75 db.execSQL(SQL_DROP_TERTIARY_KEYS_ENTRY); in onDowngrade()
/frameworks/ex/common/java/com/android/common/content/
DSyncStateContentProviderHelper.java55 db.execSQL("DROP TABLE IF EXISTS " + SYNC_STATE_TABLE); in createDatabase()
56 db.execSQL("CREATE TABLE " + SYNC_STATE_TABLE + " (" in createDatabase()
64 db.execSQL("DROP TABLE IF EXISTS " + SYNC_STATE_META_TABLE); in createDatabase()
65 db.execSQL("CREATE TABLE " + SYNC_STATE_META_TABLE + " (" in createDatabase()
105 db.execSQL("UPDATE " + SYNC_STATE_TABLE in update()
/frameworks/base/core/tests/coretests/src/android/app/activity/
DLocalProvider.java67 db.execSQL("CREATE TABLE " + TABLE_DATA_NAME + " (" + in onCreate()
73 db.execSQL(getInsertCommand(TEXT1, INTEGER1)); in onCreate()
74 db.execSQL(getInsertCommand(TEXT2, INTEGER2)); in onCreate()
88 db.execSQL("DROP TABLE IF EXISTS data"); in onUpgrade()
/frameworks/base/core/tests/coretests/src/android/database/sqlite/
DSQLiteCursorTest.java53 mDatabase.execSQL("CREATE TABLE " + TABLE_NAME + " (i int, j int);"); in setUp()
70 mDatabase.execSQL("CREATE TABLE " + testTable + " (col1 int, desc text not null);"); in testFillWindow()
161 mDatabase.execSQL("CREATE TABLE Tst (Txt BLOB NOT NULL);"); in testCustomWindowSize()
165 mDatabase.execSQL("INSERT INTO Tst VALUES (?)", new Object[]{testArr}); in testCustomWindowSize()
/frameworks/base/apct-tests/perftests/core/src/android/database/
DSQLiteDatabasePerfTest.java62 mDatabase.execSQL("CREATE TABLE T1 " in setUp()
64 mDatabase.execSQL("CREATE TABLE T2 (" in setUp()
224 mDatabase.execSQL("INSERT INTO T1 VALUES (?, ?, ?, ?)", insertsArgs); in testDelete()
257 mDatabase.execSQL("INSERT INTO T1 VALUES (?, ?, ?, ?)", in insertT1TestDataSet()
267 mDatabase.execSQL("INSERT INTO T2 VALUES (?, ?, ?)", in insertT2TestDataSet()
DCursorWindowPerfTest.java57 sDatabase.execSQL(helper.createSql()); in setup()
61 sDatabase.execSQL(insert, helper.createItem(0)); in setup()
/frameworks/base/services/voiceinteraction/java/com/android/server/soundtrigger/
DSoundTriggerDbHelper.java68 db.execSQL(CREATE_TABLE_ST_SOUND_MODEL); in onCreate()
74 db.execSQL("DROP TABLE IF EXISTS " + GenericSoundModelContract.TABLE); in onUpgrade()
/frameworks/base/tests/LocationTracker/src/com/android/locationtracker/data/
DTrackerProvider.java62 db.execSQL(queryBuilder.toString()); in onCreate()
72 db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME); in onUpgrade()
/frameworks/base/core/tests/coretests/src/android/content/
DMemoryFileProvider.java72 db.execSQL("CREATE TABLE data (" + in onCreate()
90 db.execSQL("DROP TABLE IF EXISTS data"); in onUpgrade()
/frameworks/base/services/voiceinteraction/java/com/android/server/voiceinteraction/
DDatabaseHelper.java85 db.execSQL(CREATE_TABLE_SOUND_MODEL); in onCreate()
92 db.execSQL("DROP TABLE IF EXISTS " + SoundModelContract.TABLE); in onUpgrade()
98 db.execSQL("ALTER TABLE " + SoundModelContract.TABLE + " ADD COLUMN " in onUpgrade()
124 db.execSQL("DROP TABLE IF EXISTS " + SoundModelContract.TABLE); in onUpgrade()
/frameworks/base/services/tests/servicestests/src/com/android/server/locksettings/recoverablekeystore/storage/
DRecoverableKeyStoreDbHelperTest.java117 mDatabase.execSQL(SQL_CREATE_V2_TABLE_KEYS); in createV2Tables()
118 mDatabase.execSQL(SQL_CREATE_V2_TABLE_USER_METADATA); in createV2Tables()
119 mDatabase.execSQL(SQL_CREATE_V2_TABLE_RECOVERY_SERVICE_METADATA); in createV2Tables()
/frameworks/base/services/core/java/com/android/server/net/watchlist/
DWatchlistReportDbHelper.java116 db.execSQL(CREATE_TABLE_MODEL); in onCreate()
122 db.execSQL("DROP TABLE IF EXISTS " + WhiteListReportContract.TABLE); in onUpgrade()
/frameworks/base/packages/MtpDocumentsProvider/src/com/android/mtp/
DMtpDatabase.java720 db.execSQL(QUERY_CREATE_DOCUMENTS); in onCreate()
721 db.execSQL(QUERY_CREATE_ROOT_EXTRA); in onCreate()
722 db.execSQL(QUERY_CREATE_LAST_BOOT_COUNT); in onCreate()
727 db.execSQL("DROP TABLE IF EXISTS " + TABLE_DOCUMENTS); in onUpgrade()
728 db.execSQL("DROP TABLE IF EXISTS " + TABLE_ROOT_EXTRA); in onUpgrade()
729 db.execSQL("DROP TABLE IF EXISTS " + TABLE_LAST_BOOT_COUNT); in onUpgrade()
/frameworks/base/core/java/android/content/
DSearchRecentSuggestionsProvider.java150 db.execSQL(builder.toString()); in onCreate()
157 db.execSQL("DROP TABLE IF EXISTS suggestions"); in onUpgrade()

12