Home
last modified time | relevance | path

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

123

/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.java91 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);"); in populateDefaultTable()
93 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');"); in populateDefaultTable()
94 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');"); in populateDefaultTable()
95 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');"); in populateDefaultTable()
122 mDatabase.execSQL("CREATE TABLE phones (num TEXT);"); in testPhoneNumbersEqual()
123 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('911');"); in testPhoneNumbersEqual()
124 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('5555');"); in testPhoneNumbersEqual()
125 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('+" + PHONE_NUMBER + "');"); in testPhoneNumbersEqual()
350 mDatabase.execSQL("CREATE TABLE guess (numi INTEGER, numf FLOAT, str TEXT);"); in testCopyString()
351 mDatabase.execSQL( in testCopyString()
[all …]
DDatabaseCursorTest.java83 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);"); in populateDefaultTable()
85 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');"); in populateDefaultTable()
86 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');"); in populateDefaultTable()
87 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');"); in populateDefaultTable()
93 mDatabase.execSQL( in testBlob()
111 mDatabase.execSQL(sql, args); in testBlob()
131 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data REAL);"); in testRealColumns()
238 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);"); in testLargeField()
249 mDatabase.execSQL(sql.toString()); in testLargeField()
294 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/support/work/workmanager/src/main/java/androidx/work/impl/
DWorkDatabaseMigrations.java70 database.execSQL(CREATE_SYSTEM_ID_INFO);
71 database.execSQL(MIGRATE_ALARM_INFO_TO_SYSTEM_ID_INFO);
72 database.execSQL(REMOVE_ALARM_INFO);
73 database.execSQL("INSERT INTO worktag(tag, work_spec_id) "
85 database.execSQL(CREATE_ALARM_INFO);
86 database.execSQL(MIGRATE_SYSTEM_ID_INFO_TO_ALARM_INFO);
87 database.execSQL(REMOVE_SYSTEM_ID_INFO);
/frameworks/base/services/core/java/com/android/server/locksettings/recoverablekeystore/storage/
DRecoverableKeyStoreDbHelper.java107 db.execSQL(SQL_CREATE_KEYS_ENTRY); in onCreate()
108 db.execSQL(SQL_CREATE_USER_METADATA_ENTRY); in onCreate()
109 db.execSQL(SQL_CREATE_RECOVERY_SERVICE_METADATA_ENTRY); in onCreate()
110 db.execSQL(SQL_CREATE_ROOT_OF_TRUST_ENTRY); in onCreate()
144 db.execSQL(SQL_DELETE_KEYS_ENTRY); in dropAllKnownTables()
145 db.execSQL(SQL_DELETE_USER_METADATA_ENTRY); in dropAllKnownTables()
146 db.execSQL(SQL_DELETE_RECOVERY_SERVICE_METADATA_ENTRY); in dropAllKnownTables()
147 db.execSQL(SQL_DELETE_ROOT_OF_TRUST_ENTRY); in dropAllKnownTables()
162 db.execSQL(SQL_CREATE_ROOT_OF_TRUST_ENTRY); in upgradeDbForVersion4()
179 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/support/room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/migration/
DMigrationKotlinTest.kt206 database.execSQL("CREATE TABLE Entity4 (`id` INTEGER, `name` TEXT," in failedForeignKey()
247 database.execSQL("CREATE TABLE IF NOT EXISTS `Entity2` (`id` INTEGER NOT NULL," in migrate()
254 database.execSQL("ALTER TABLE " + MigrationDbKotlin.Entity2.TABLE_NAME in migrate()
261 database.execSQL("CREATE TABLE IF NOT EXISTS `Entity3` (`id` INTEGER NOT NULL," in migrate()
268 database.execSQL("CREATE TABLE IF NOT EXISTS `Entity3_New` (`id` INTEGER NOT NULL," in migrate()
270 database.execSQL("INSERT INTO Entity3_New(`id`, `name`) " in migrate()
272 database.execSQL("DROP TABLE Entity3") in migrate()
273 database.execSQL("ALTER TABLE Entity3_New RENAME TO Entity3") in migrate()
279 database.execSQL("DROP TABLE " + MigrationDbKotlin.Entity3.TABLE_NAME) in migrate()
285 database.execSQL("CREATE TABLE IF NOT EXISTS " in migrate()
[all …]
/frameworks/support/room/compiler/src/test/data/databasewriter/output/
DComplexDatabase.java33 …_db.execSQL("CREATE TABLE IF NOT EXISTS `User` (`uid` INTEGER NOT NULL, `name` TEXT, `lastName` TE… in createOpenHelper()
34 …_db.execSQL("CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TE… in createOpenHelper()
35 …_db.execSQL("INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, \"cd8098a1e968… in createOpenHelper()
40 _db.execSQL("DROP TABLE IF EXISTS `User`"); in createOpenHelper()
100 _db.execSQL("DELETE FROM `User`"); in clearAllTables()
106 _db.execSQL("VACUUM"); in clearAllTables()
/frameworks/base/services/core/java/com/android/server/accounts/
DAccountsDb.java205 db.execSQL("CREATE TABLE " + TABLE_ACCOUNTS + " ( " in onCreate()
212 db.execSQL("CREATE TABLE " + TABLE_AUTHTOKENS + " ( " in onCreate()
219 db.execSQL("CREATE TABLE " + TABLE_EXTRAS + " ( " in onCreate()
230 db.execSQL("" in createAccountsDeletionTrigger()
248 db.execSQL("DROP TABLE IF EXISTS " + TABLE_META); in onUpgrade()
249 db.execSQL("DROP TABLE IF EXISTS " + TABLE_SHARED_ACCOUNTS); in onUpgrade()
251 db.execSQL("DROP TRIGGER IF EXISTS " + TABLE_ACCOUNTS + "Delete"); in onUpgrade()
253 db.execSQL("DROP TABLE IF EXISTS " + TABLE_GRANTS); in onUpgrade()
254 db.execSQL("DROP TABLE IF EXISTS " + TABLE_DEBUG); in onUpgrade()
513 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/support/room/integration-tests/testapp/src/androidTest/java/androidx/room/integration/testapp/migration/
DMigrationTest.java210 database.execSQL("CREATE TABLE Entity4 (`id` INTEGER NOT NULL," in failedForeignKey()
368 database.execSQL("CREATE TABLE IF NOT EXISTS `Entity2` ("
377 database.execSQL("ALTER TABLE " + MigrationDb.Entity2.TABLE_NAME
385 database.execSQL("CREATE TABLE IF NOT EXISTS `Entity3` (`id` INTEGER NOT NULL,"
393 database.execSQL("CREATE TABLE IF NOT EXISTS `Entity3_New` (`id` INTEGER NOT NULL,"
395 database.execSQL("INSERT INTO Entity3_New(`id`, `name`) "
397 database.execSQL("DROP TABLE Entity3");
398 database.execSQL("ALTER TABLE Entity3_New RENAME TO Entity3");
405 database.execSQL("DROP TABLE " + MigrationDb.Entity3.TABLE_NAME);
412 database.execSQL("CREATE TABLE IF NOT EXISTS " + MigrationDb.Entity4.TABLE_NAME
[all …]
/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.java52 mDatabase.execSQL("CREATE TABLE " + TABLE_NAME + " (i int, j int);"); in setUp()
69 mDatabase.execSQL("CREATE TABLE " + testTable + " (col1 int, desc text not null);"); in testFillWindow()
160 mDatabase.execSQL("CREATE TABLE Tst (Txt BLOB NOT NULL);"); in testCustomWindowSize()
164 mDatabase.execSQL("INSERT INTO Tst VALUES (?)", new Object[]{testArr}); in testCustomWindowSize()
/frameworks/support/work/workmanager/src/androidTest/java/androidx/work/
DWorkDatabaseMigrationTest.java126 database.execSQL(INSERT_ALARM_INFO, new Object[]{workSpecId1, 1}); in testMigrationVersion1To2()
127 database.execSQL(INSERT_ALARM_INFO, new Object[]{workSpecId2, 2}); in testMigrationVersion1To2()
172 database.execSQL(INSERT_SYSTEM_ID_INFO, new Object[]{workSpecId1, 1}); in testMigrationVersion2To1()
173 database.execSQL(INSERT_SYSTEM_ID_INFO, new Object[]{workSpecId2, 2}); in testMigrationVersion2To1()
211 database.execSQL(INSERT_ALARM_INFO, new Object[]{workSpecId1, 1}); in testMigrationVersion1To2To1()
212 database.execSQL(INSERT_ALARM_INFO, new Object[]{workSpecId2, 2}); in testMigrationVersion1To2To1()
/frameworks/base/apct-tests/perftests/core/src/android/database/
DSQLiteDatabasePerfTest.java61 mDatabase.execSQL("CREATE TABLE T1 " in setUp()
63 mDatabase.execSQL("CREATE TABLE T2 (" in setUp()
223 mDatabase.execSQL("INSERT INTO T1 VALUES (?, ?, ?, ?)", insertsArgs); in testDelete()
256 mDatabase.execSQL("INSERT INTO T1 VALUES (?, ?, ?, ?)", in insertT1TestDataSet()
266 mDatabase.execSQL("INSERT INTO T2 VALUES (?, ?, ?)", in insertT2TestDataSet()
DCursorWindowPerfTest.java56 sDatabase.execSQL(helper.createSql()); in setup()
60 sDatabase.execSQL(insert, helper.createItem(0)); in setup()
/frameworks/support/persistence/db-framework/src/main/java/androidx/sqlite/db/framework/
DFrameworkSQLiteDatabase.java241 public void execSQL(String sql) throws SQLException {
242 mDelegate.execSQL(sql);
246 public void execSQL(String sql, Object[] bindArgs) throws SQLException {
247 mDelegate.execSQL(sql, bindArgs);
/frameworks/support/persistence/db/src/main/java/androidx/sqlite/db/
DSupportSQLiteDatabase.java377 void execSQL(String sql) throws SQLException; in execSQL() method
395 void execSQL(String sql, Object[] bindArgs) throws SQLException; in execSQL() method
/frameworks/support/room/runtime/src/main/java/androidx/room/
DInvalidationTracker.java156 database.execSQL("PRAGMA temp_store = MEMORY;"); in internalInit()
157 database.execSQL("PRAGMA recursive_triggers='ON';"); in internalInit()
158 database.execSQL(CREATE_VERSION_TABLE_SQL); in internalInit()
186 writableDb.execSQL(stringBuilder.toString()); in stopTrackingTable()
206 writableDb.execSQL(stringBuilder.toString()); in startTrackingTable()
/frameworks/support/room/integration-tests/testapp/src/androidTest/java/androidx/room/integration/testapp/test/
DIdentityDetectionTest.java68 db.execSQL("UPDATE " + Room.MASTER_TABLE_NAME + " SET `identity_hash` = ?" in reOpenChangedHash()
88 db.execSQL("DROP TABLE " + Room.MASTER_TABLE_NAME); in reOpenMasterTableDropped()

123