Home
last modified time | relevance | path

Searched refs:execSQL (Results 1 – 25 of 45) 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.java68 mDatabase.execSQL("create table t (i int);"); in testDatabaseIsCorrupt()
78 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/core/tests/coretests/src/android/database/sqlite/
DSQLiteDatabaseTest.java98 mDatabase.execSQL("CREATE TABLE `t1` (`c1` INTEGER NOT NULL PRIMARY KEY, data TEXT)"); in testStatementDDLEvictsCache()
104 mDatabase.execSQL("ALTER TABLE `t1` RENAME TO `t1_old`"); in testStatementDDLEvictsCache()
105 mDatabase.execSQL("CREATE TABLE `t1` (`c1` INTEGER NOT NULL PRIMARY KEY)"); in testStatementDDLEvictsCache()
117 mDatabase.execSQL("CREATE TABLE `t1` (`c1` INTEGER NOT NULL PRIMARY KEY, data TEXT)"); in testStressDDLEvicts()
125 mDatabase.execSQL("ALTER TABLE `t1` RENAME TO `t1_old`"); in testStressDDLEvicts()
126 mDatabase.execSQL("CREATE TABLE `t1` (`c1` INTEGER NOT NULL " in testStressDDLEvicts()
130 mDatabase.execSQL("DROP TABLE `t1`"); in testStressDDLEvicts()
131 mDatabase.execSQL("ALTER TABLE `t1_old` RENAME TO `t1`"); in testStressDDLEvicts()
159 mDatabase.execSQL("CREATE TABLE t1 (i int, d double, t text);"); in createComplexDatabase()
289 database.execSQL(String.format("INSERT INTO t1 (i) VALUES (%d)", n++)); in concurrentImmediateWriter()
[all …]
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()
207 mDatabase.execSQL("CREATE TABLE t1 (i int);"); in testSchemaChangeCursor()
208 mDatabase.execSQL("INSERT INTO t1 (i) VALUES (2)"); in testSchemaChangeCursor()
209 mDatabase.execSQL("INSERT INTO t1 (i) VALUES (3)"); in testSchemaChangeCursor()
210 mDatabase.execSQL("INSERT INTO t1 (i) VALUES (5)"); in testSchemaChangeCursor()
219 mDatabase.execSQL("ALTER TABLE t1 ADD COLUMN j int"); in testSchemaChangeCursor()
DSQLiteRawStatementTest.java86 mDatabase.execSQL("CREATE TABLE t1 (i int);"); in createSimpleDatabase()
87 mDatabase.execSQL("INSERT INTO t1 (i) VALUES (2)"); in createSimpleDatabase()
88 mDatabase.execSQL("INSERT INTO t1 (i) VALUES (3)"); in createSimpleDatabase()
110 mDatabase.execSQL("CREATE TABLE t1 (i int, d double, t text, l int);"); in createComplexDatabase()
135 mDatabase.execSQL("CREATE TABLE t1 (" + sp.toString() + ")"); in createWideDatabase()
976 mDatabase.execSQL("CREATE TABLE t1 (i int, j int);"); in testUnicode()
977 mDatabase.execSQL("INSERT INTO t1 (i, j) VALUES (2, 20)"); in testUnicode()
978 mDatabase.execSQL("INSERT INTO t1 (i, j) VALUES (3, 30)"); in testUnicode()
/frameworks/base/services/core/java/com/android/server/locksettings/recoverablekeystore/storage/
DRecoverableKeyStoreDbHelper.java126 db.execSQL(SQL_CREATE_KEYS_ENTRY); in onCreate()
127 db.execSQL(SQL_CREATE_USER_METADATA_ENTRY_FOR_V7); in onCreate()
128 db.execSQL(SQL_CREATE_RECOVERY_SERVICE_METADATA_ENTRY); in onCreate()
129 db.execSQL(SQL_CREATE_ROOT_OF_TRUST_ENTRY); in onCreate()
188 db.execSQL(SQL_DELETE_KEYS_ENTRY); in dropAllKnownTables()
189 db.execSQL(SQL_DELETE_USER_METADATA_ENTRY); in dropAllKnownTables()
190 db.execSQL(SQL_DELETE_RECOVERY_SERVICE_METADATA_ENTRY); in dropAllKnownTables()
191 db.execSQL(SQL_DELETE_ROOT_OF_TRUST_ENTRY); in dropAllKnownTables()
206 db.execSQL(SQL_CREATE_ROOT_OF_TRUST_ENTRY); in upgradeDbForVersion4()
247 db.execSQL(alterStr + ";"); in addColumnToTable()
/frameworks/base/packages/SettingsProvider/src/com/android/providers/settings/
DDatabaseHelper.java173 db.execSQL("CREATE TABLE secure (" + in createSecureTable()
178 db.execSQL("CREATE INDEX secureIndex1 ON secure (name);"); in createSecureTable()
182 db.execSQL("CREATE TABLE global (" + in createGlobalTable()
187 db.execSQL("CREATE INDEX globalIndex1 ON global (name);"); in createGlobalTable()
192 db.execSQL("CREATE TABLE system (" + in onCreate()
197 db.execSQL("CREATE INDEX systemIndex1 ON system (name);"); in onCreate()
206 db.execSQL("CREATE TABLE bluetooth_devices (" + in onCreate()
214 db.execSQL("CREATE TABLE bookmarks (" + in onCreate()
223 db.execSQL("CREATE INDEX bookmarksIndex1 ON bookmarks (folder);"); in onCreate()
224 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/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/opt/net/ims/tests/src/com/android/ims/rcs/uce/eab/
DEabProviderTestable.java93 db.execSQL(SQL_CREATE_CONTACT_TABLE); in onCreate()
94 db.execSQL(SQL_CREATE_COMMON_TABLE); in onCreate()
95 db.execSQL(SQL_CREATE_PRESENCE_TUPLE_TABLE); in onCreate()
96 db.execSQL(SQL_CREATE_OPTIONS_TABLE); in onCreate()
/frameworks/opt/net/ims/src/java/com/android/ims/rcs/uce/eab/
DEabProvider.java403 db.execSQL(SQL_CREATE_CONTACT_TABLE); in onCreate()
404 db.execSQL(SQL_CREATE_COMMON_TABLE); in onCreate()
405 db.execSQL(SQL_CREATE_PRESENCE_TUPLE_TABLE); in onCreate()
406 db.execSQL(SQL_CREATE_OPTIONS_TABLE); in onCreate()
414 sqLiteDatabase.execSQL("ALTER TABLE " + EAB_CONTACT_TABLE_NAME + " ADD COLUMN " in onUpgrade()
432 sqLiteDatabase.execSQL(createTempTableCommand); in onUpgrade()
435 sqLiteDatabase.execSQL("INSERT INTO temp (" in onUpgrade()
452 sqLiteDatabase.execSQL("DROP TABLE " + EAB_COMMON_TABLE_NAME + ";"); in onUpgrade()
455 sqLiteDatabase.execSQL("ALTER TABLE temp RENAME TO " + EAB_COMMON_TABLE_NAME + ";"); in onUpgrade()
460 sqLiteDatabase.execSQL("ALTER TABLE " + EAB_COMMON_TABLE_NAME + " ADD COLUMN " in onUpgrade()
/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/apct-tests/perftests/core/src/android/database/
DSQLiteDatabasePerfTest.java84 mDatabase.execSQL("CREATE TABLE T1 " in createOrOpenTestDatabase()
86 mDatabase.execSQL("CREATE TABLE T2 (" in createOrOpenTestDatabase()
355 mDatabase.execSQL(statements[i], new Object[] {i, i, "T1Value" + i, i * 1.1});
362 mDatabase.execSQL("DELETE FROM T1");
377 mDatabase.execSQL("INSERT INTO T1 VALUES (?, ?, ?, ?)", insertsArgs);
533 mDatabase.execSQL("INSERT INTO T1 VALUES (?, ?, ?, ?)",
543 mDatabase.execSQL("INSERT INTO T2 VALUES (?, ?, ?)",
DCursorWindowPerfTest.java57 sDatabase.execSQL(helper.createSql()); in setup()
61 sDatabase.execSQL(insert, helper.createItem(0)); in setup()
/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.java91 db.execSQL(CREATE_TABLE_SOUND_MODEL); in onCreate()
98 db.execSQL("DROP TABLE IF EXISTS " + SoundModelContract.TABLE); in onUpgrade()
104 db.execSQL("ALTER TABLE " + SoundModelContract.TABLE + " ADD COLUMN " in onUpgrade()
130 db.execSQL("DROP TABLE IF EXISTS " + SoundModelContract.TABLE); in onUpgrade()
150 db.execSQL("ALTER TABLE " + SoundModelContract.TABLE + " ADD COLUMN " in onUpgrade()
/frameworks/base/services/voiceinteraction/java/com/android/server/soundtrigger/
DSoundTriggerDbHelper.java67 db.execSQL(CREATE_TABLE_ST_SOUND_MODEL); in onCreate()
75 db.execSQL("ALTER TABLE " + GenericSoundModelContract.TABLE + " ADD COLUMN " in onUpgrade()
/frameworks/base/services/core/java/com/android/server/net/watchlist/
DWatchlistReportDbHelper.java114 db.execSQL(CREATE_TABLE_MODEL); in onCreate()
120 db.execSQL("DROP TABLE IF EXISTS " + WhiteListReportContract.TABLE); in onUpgrade()

12