Home
last modified time | relevance | path

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

12

/frameworks/base/core/tests/coretests/src/android/database/
DNewDatabasePerformanceTests.java124 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in setUp()
129 mDatabase.execSQL(statements[i]); in testRun()
156 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in setUp()
157 mDatabase.execSQL("CREATE INDEX i1c ON t1(c)"); in setUp()
162 mDatabase.execSQL(statements[i]); in testRun()
183 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in setUp()
187 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'" in setUp()
222 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in setUp()
226 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'" in setUp()
259 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in setUp()
[all …]
DDatabasePerformanceTests.java215 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in setUp()
221 mDatabase.execSQL(statements[i]); in run()
248 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in setUp()
249 mDatabase.execSQL("CREATE INDEX i1c ON t1(c)"); in setUp()
255 mDatabase.execSQL(statements[i]); in run()
276 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in setUp()
280 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'" in setUp()
316 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in setUp()
320 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'" in setUp()
354 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))"); in setUp()
[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 …]
DDatabaseGeneralTest.java85 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);"); in populateDefaultTable()
87 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');"); in populateDefaultTable()
88 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');"); in populateDefaultTable()
89 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');"); in populateDefaultTable()
116 mDatabase.execSQL("CREATE TABLE phones (num TEXT);"); in testPhoneNumbersEqual()
117 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('911');"); in testPhoneNumbersEqual()
118 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('5555');"); in testPhoneNumbersEqual()
119 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('+" + PHONE_NUMBER + "');"); in testPhoneNumbersEqual()
321 mDatabase.execSQL("CREATE TABLE guess (numi INTEGER, numf FLOAT, str TEXT);"); in testCopyString()
322 mDatabase.execSQL( in testCopyString()
[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/packages/SettingsProvider/src/com/android/providers/settings/
DDatabaseHelper.java179 db.execSQL("CREATE TABLE secure (" + in createSecureTable()
184 db.execSQL("CREATE INDEX secureIndex1 ON secure (name);"); in createSecureTable()
188 db.execSQL("CREATE TABLE global (" + in createGlobalTable()
193 db.execSQL("CREATE INDEX globalIndex1 ON global (name);"); in createGlobalTable()
198 db.execSQL("CREATE TABLE system (" + in onCreate()
203 db.execSQL("CREATE INDEX systemIndex1 ON system (name);"); in onCreate()
212 db.execSQL("CREATE TABLE bluetooth_devices (" + in onCreate()
220 db.execSQL("CREATE TABLE bookmarks (" + in onCreate()
229 db.execSQL("CREATE INDEX bookmarksIndex1 ON bookmarks (folder);"); in onCreate()
230 db.execSQL("CREATE INDEX bookmarksIndex2 ON bookmarks (shortcut);"); in onCreate()
[all …]
/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/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/ml/bordeaux/service/src/android/bordeaux/services/
DAggregatorStorage.java45 db.execSQL(mTableCmd); in onCreate()
53 db.execSQL("DROP TABLE IF EXISTS " + mTableName); in onUpgrade()
DBordeauxSessionStorage.java71 db.execSQL(DATABASE_CREATE); in onCreate()
79 db.execSQL("DROP TABLE IF EXISTS " + SESSION_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/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/core/tests/coretests/src/android/database/sqlite/
DSQLiteCursorTest.java45 mDatabase.execSQL("CREATE TABLE " + TABLE_NAME + " (i int, j int);"); in setUp()
63 mDatabase.execSQL("CREATE TABLE " + testTable + " (col1 int, desc text not null);"); in testFillWindow()
/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/packages/MtpDocumentsProvider/src/com/android/mtp/
DMtpDatabase.java719 db.execSQL(QUERY_CREATE_DOCUMENTS); in onCreate()
720 db.execSQL(QUERY_CREATE_ROOT_EXTRA); in onCreate()
721 db.execSQL(QUERY_CREATE_LAST_BOOT_COUNT); in onCreate()
726 db.execSQL("DROP TABLE IF EXISTS " + TABLE_DOCUMENTS); in onUpgrade()
727 db.execSQL("DROP TABLE IF EXISTS " + TABLE_ROOT_EXTRA); in onUpgrade()
728 db.execSQL("DROP TABLE IF EXISTS " + TABLE_LAST_BOOT_COUNT); in onUpgrade()
/frameworks/base/core/java/android/content/
DSearchRecentSuggestionsProvider.java148 db.execSQL(builder.toString()); in onCreate()
155 db.execSQL("DROP TABLE IF EXISTS suggestions"); in onUpgrade()
/frameworks/opt/telephony/tests/telephonytests/src/com/android/internal/telephony/
DFakeSmsContentProvider.java53 db.execSQL("CREATE TABLE raw (" + in onCreate()
/frameworks/base/core/java/android/database/sqlite/
DSQLiteDatabase.java875 execSQL("PRAGMA user_version = " + version); in setVersion()
924 execSQL("PRAGMA page_size = " + numBytes); in setPageSize()
1607 public void execSQL(String sql) throws SQLException { in execSQL() method in SQLiteDatabase
1654 public void execSQL(String sql, Object[] bindArgs) throws SQLException { in execSQL() method in SQLiteDatabase
/frameworks/support/samples/Support4Demos/src/com/example/android/supportv4/app/
DLoaderThrottleSupport.java137 db.execSQL("CREATE TABLE " + MainTable.TABLE_NAME + " (" in onCreate()
158 db.execSQL("DROP TABLE IF EXISTS notes"); in onUpgrade()

12