| /packages/providers/CalendarProvider/tests/src/com/android/providers/calendar/ |
| CalendarDatabaseHelperTest.java | 55 db.execSQL("CREATE TABLE Calendars (" +
77 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON Calendars " +
84 db.execSQL("CREATE TABLE Events (" +
121 db.execSQL("CREATE INDEX eventsCalendarIdIndex ON Events (calendar_id);");
123 db.execSQL("CREATE TABLE EventsRawTimes (" +
136 db.execSQL("CREATE TABLE DeletedEvents (" +
143 db.execSQL("CREATE TABLE Instances (" +
155 db.execSQL("CREATE INDEX instancesStartDayIndex ON Instances (startDay);");
157 db.execSQL("CREATE TABLE CalendarMetaData (" +
166 db.execSQL("CREATE TABLE BusyBits("
[all...] |
| /packages/providers/CalendarProvider/src/com/android/providers/calendar/ |
| CalendarDatabaseHelper.java | 361 db.execSQL("CREATE TEMPORARY TABLE state_backup(_sync_account TEXT, "
363 db.execSQL("INSERT INTO state_backup SELECT _sync_account, _sync_account_type, data"
367 db.execSQL("DROP TABLE " + Tables.SYNC_STATE + ";");
369 db.execSQL("INSERT INTO " + Tables.SYNC_STATE + "("
374 db.execSQL("DROP TABLE state_backup;");
399 db.execSQL("CREATE TABLE " + Tables.EVENTS_RAW_TIMES + " (" +
409 db.execSQL("CREATE TABLE " + Tables.INSTANCES + " (" +
424 db.execSQL("CREATE INDEX instancesStartDayIndex ON " + Tables.INSTANCES + " (" +
432 db.execSQL("CREATE TABLE " + Tables.ATTENDEES + " (" +
444 db.execSQL("CREATE INDEX attendeesEventIdIndex ON " + Tables.ATTENDEES + " ("
[all...] |
| /packages/providers/TelephonyProvider/src/com/android/providers/telephony/ |
| MmsSmsDatabaseHelper.java | 307 db.execSQL(
323 db.execSQL(
368 db.execSQL("UPDATE threads SET error=" + setError +
528 db.execSQL("CREATE VIRTUAL TABLE words USING FTS3 (_id INTEGER PRIMARY KEY, index_text TEXT, source_id INTEGER, table_to_use INTEGER);");
535 db.execSQL("CREATE TRIGGER sms_words_update AFTER UPDATE ON sms BEGIN UPDATE words " +
538 db.execSQL("CREATE TRIGGER sms_words_delete AFTER DELETE ON sms BEGIN DELETE FROM " +
553 db.execSQL("CREATE INDEX IF NOT EXISTS typeThreadIdIndex ON sms" +
563 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_PDU + " (" +
599 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_ADDR + " (" +
607 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_PART + " ("
[all...] |
| /frameworks/base/core/tests/coretests/src/android/database/ |
| DatabasePerformanceTests.java | 215 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))");
221 mDatabase.execSQL(statements[i]);
248 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))");
249 mDatabase.execSQL("CREATE INDEX i1c ON t1(c)");
255 mDatabase.execSQL(statements[i]);
276 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))");
280 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
316 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))");
320 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
354 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))")
[all...] |
| NewDatabasePerformanceTests.java | 124 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))");
129 mDatabase.execSQL(statements[i]);
156 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))");
157 mDatabase.execSQL("CREATE INDEX i1c ON t1(c)");
162 mDatabase.execSQL(statements[i]);
183 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))");
187 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
222 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))");
226 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
259 .execSQL("CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100))")
[all...] |
| DatabaseStressTest.java | 52 mDatabase.execSQL("CREATE TABLE IF NOT EXISTS test (_id INTEGER PRIMARY KEY, data TEXT);");
71 mDatabase.execSQL("INSERT INTO test (data) VALUES (?)", strArr);
72 mDatabase.execSQL("delete from test;");
93 mDatabase.execSQL("INSERT INTO test (data) VALUES (?)", strArr);
|
| DatabaseStatementTest.java | 72 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
74 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
75 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
76 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
93 mDatabase.execSQL("CREATE TABLE test (num INTEGER NOT NULL, str TEXT NOT NULL);");
94 mDatabase.execSQL("INSERT INTO test VALUES (1234, 'hello');");
130 mDatabase.execSQL("CREATE TABLE test (num INTEGER);");
152 mDatabase.execSQL("CREATE TABLE test (num TEXT);");
174 mDatabase.execSQL("CREATE TABLE test (num INTEGER);");
196 mDatabase.execSQL("CREATE TABLE test (num TEXT, value TEXT);")
[all...] |
| DatabaseCursorTest.java | 82 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
84 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
85 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
86 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
92 mDatabase.execSQL(
110 mDatabase.execSQL(sql, args);
130 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data REAL);");
237 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
248 mDatabase.execSQL(sql.toString());
293 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data INT);")
[all...] |
| DatabaseGeneralTest.java | 85 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
87 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
88 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
89 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
116 mDatabase.execSQL("CREATE TABLE phones (num TEXT);");
117 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('911');");
118 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('5555');");
119 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('+" + PHONE_NUMBER + "');");
321 mDatabase.execSQL("CREATE TABLE guess (numi INTEGER, numf FLOAT, str TEXT);");
322 mDatabase.execSQL(
[all...] |
| DatabaseLocaleTest.java | 49 mDatabase.execSQL(
55 mDatabase.execSQL("INSERT INTO test (data) VALUES('" + s + "');");
114 mDatabase.execSQL("INSERT INTO test(id, data) VALUES(1, '" + expectedString + "')");
|
| /packages/apps/Email/src/com/android/email/provider/ |
| DBHelper.java | 193 db.execSQL("create trigger message_count_message_insert after insert on " +
201 db.execSQL("create trigger message_count_message_delete after delete on " +
209 db.execSQL("create trigger message_count_message_move after update of " +
221 db.execSQL("drop trigger message_delete_duplicates_on_insert");
243 db.execSQL("create trigger message_delete_duplicates_on_insert before insert on "
308 db.execSQL("create table " + Message.TABLE_NAME + createString);
309 db.execSQL("create table " + Message.UPDATED_TABLE_NAME + altCreateString);
310 db.execSQL("create table " + Message.DELETED_TABLE_NAME + altCreateString);
321 db.execSQL(createIndex(Message.TABLE_NAME, columnName));
327 db.execSQL("create trigger message_delete before delete on " + Message.TABLE_NAME
[all...] |
| /packages/providers/MediaProvider/src/com/android/providers/media/ |
| MediaProvider.java | [all...] |
| /frameworks/ml/bordeaux/service/src/android/bordeaux/services/ |
| AggregatorStorage.java | 45 db.execSQL(mTableCmd);
53 db.execSQL("DROP TABLE IF EXISTS " + mTableName);
|
| /packages/providers/ContactsProvider/src/com/android/providers/contacts/ |
| ContactsDatabaseHelper.java | [all...] |
| /cts/tests/tests/database/src/android/database/sqlite/cts/ |
| DatabaseStatementTest.java | 73 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
75 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
76 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
77 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
94 mDatabase.execSQL("CREATE TABLE test (num INTEGER NOT NULL, str TEXT NOT NULL);");
95 mDatabase.execSQL("INSERT INTO test VALUES (1234, 'hello');");
131 mDatabase.execSQL("CREATE TABLE test (num INTEGER);");
153 mDatabase.execSQL("CREATE TABLE test (num TEXT);");
175 mDatabase.execSQL("CREATE TABLE test (num INTEGER);");
197 mDatabase.execSQL("CREATE TABLE test (num TEXT, value TEXT);")
[all...] |
| SQLiteCursorTest.java | 147 mDatabase.execSQL(DELETE_1);
155 mDatabase.execSQL(DELETE_2);
167 mDatabase.execSQL("create table testRequery2 (i int);");
168 mDatabase.execSQL("insert into testRequery2 values(1);");
169 mDatabase.execSQL("insert into testRequery2 values(2);");
177 mDatabase.execSQL("insert into testRequery2 values(3);");
222 mDatabase.execSQL(sql);
227 mDatabase.execSQL("INSERT INTO " + tableName + "(number_1) VALUES ('" + i + "');");
|
| SQLiteProgramTest.java | 53 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, text1 TEXT, text2 TEXT, " +
55 mDatabase.execSQL("INSERT INTO test (text1, text2, num1, num2, image) " +
57 mDatabase.execSQL("INSERT INTO test (text1, text2, num1, num2, image) " +
123 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, text1 TEXT, text2 TEXT, " +
153 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, text1 TEXT, text2 TEXT, " +
|
| SQLiteDatabaseTest.java | 164 mDatabase.execSQL("CREATE TABLE test (num INTEGER);");
165 mDatabase.execSQL("INSERT INTO test (num) VALUES (0)");
167 // test execSQL without any explicit transactions.
273 mDatabase.execSQL("UPDATE test SET num = " + num);
326 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, "
367 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, "
369 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Mike', 20, 'LA');");
370 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Jack', 30, 'London');");
371 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Jim', 35, 'Chicago');");
407 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Mike', 20, 'LA');")
[all...] |
| SQLiteQueryBuilderTest.java | 124 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, " +
126 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Mike', '20', 'LA');");
127 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('jack', '40', 'LA');");
402 mDatabase.execSQL("CREATE TABLE x (v INTEGER);");
404 mDatabase.execSQL("INSERT INTO x VALUES (?)", new Object[] { i });
460 mDatabase.execSQL("CREATE TABLE employee (_id INTEGER PRIMARY KEY, " +
462 mDatabase.execSQL("INSERT INTO employee (name, month, salary) " +
464 mDatabase.execSQL("INSERT INTO employee (name, month, salary) " +
466 mDatabase.execSQL("INSERT INTO employee (name, month, salary) " +
468 mDatabase.execSQL("INSERT INTO employee (name, month, salary) "
[all...] |
| /packages/providers/ContactsProvider/src/com/android/providers/contacts/database/ |
| ContactsTableUtil.java | 46 db.execSQL("CREATE INDEX contacts_has_phone_index ON " + table + " (" +
50 db.execSQL("CREATE INDEX contacts_name_raw_contact_id_index ON " + table + " (" +
54 db.execSQL(MoreDatabaseUtils.buildCreateIndexSql(table,
78 db.execSQL(buildUpdateLastUpdateSql(rawContactIds));
|
| DeletedContactsTableUtil.java | 38 db.execSQL("CREATE TABLE " + ContactsDatabaseHelper.Tables.DELETED_CONTACTS + " (" +
44 db.execSQL(MoreDatabaseUtils.buildCreateIndexSql(
|
| /packages/apps/DeskClock/src/com/android/deskclock/provider/ |
| ClockDatabaseHelper.java | 72 db.execSQL("CREATE TABLE " + ALARMS_TABLE_NAME + " (" +
86 db.execSQL("CREATE TABLE " + INSTANCES_TABLE_NAME + " (" +
105 db.execSQL("CREATE TABLE " + CITIES_TABLE_NAME + " (" +
138 db.execSQL(insertMe + DEFAULT_ALARM_1);
139 db.execSQL(insertMe + DEFAULT_ALARM_2);
150 db.execSQL("DROP TABLE IF EXISTS " + INSTANCES_TABLE_NAME + ";");
151 db.execSQL("DROP TABLE IF EXISTS " + CITIES_TABLE_NAME + ";");
200 db.execSQL("DROP TABLE IF EXISTS " + OLD_ALARMS_TABLE_NAME + ";");
|
| /external/robolectric/src/test/java/com/xtremelabs/robolectric/shadows/ |
| DatabaseTestBase.java | 31 database.execSQL("CREATE TABLE table_name (\n" +
39 database.execSQL("CREATE TABLE rawtable (\n" +
47 database.execSQL("CREATE TABLE exectable (\n" +
351 database.execSQL("INSERT INTO table_name (id, name) VALUES(1234, 'Chuck');");
370 database.execSQL("CREATE TABLE `routine` (`id` INTEGER PRIMARY KEY AUTOINCREMENT , `name` VARCHAR , `lastUsed` INTEGER DEFAULT 0 , UNIQUE (`name`)) ", new Object[]{});
371 database.execSQL("INSERT INTO `routine` (`name` ,`lastUsed` ) VALUES (?,?)", new Object[]{"Leg Press", 0});
372 database.execSQL("INSERT INTO `routine` (`name` ,`lastUsed` ) VALUES (?,?)", new Object[]{"Bench Press", 1});
393 database.execSQL("INSERT INTO table_name;"); // invalid SQL
398 database.execSQL("insert into exectable (first_column) values (?);", null);
403 database.execSQL("insert into exectable (first_column) values ('sdfsfs');", null)
[all...] |
| /frameworks/ex/common/java/com/android/common/content/ |
| SyncStateContentProviderHelper.java | 55 db.execSQL("DROP TABLE IF EXISTS " + SYNC_STATE_TABLE);
56 db.execSQL("CREATE TABLE " + SYNC_STATE_TABLE + " ("
64 db.execSQL("DROP TABLE IF EXISTS " + SYNC_STATE_META_TABLE);
65 db.execSQL("CREATE TABLE " + SYNC_STATE_META_TABLE + " ("
105 db.execSQL("UPDATE " + SYNC_STATE_TABLE
|
| /packages/providers/ContactsProvider/tests/src/com/android/providers/contacts/ |
| SynchronousContactsProvider2.java | 189 db.execSQL("UPDATE raw_contacts SET aggregation_mode=0,aggregation_needed=1;");
193 db.execSQL("DELETE FROM raw_contacts WHERE _id > " + rowId + ";");
211 db.execSQL("replace into SQLITE_SEQUENCE (name,seq) values('raw_contacts', 42)");
212 db.execSQL("replace into SQLITE_SEQUENCE (name,seq) values('contacts', 2009)");
213 db.execSQL("replace into SQLITE_SEQUENCE (name,seq) values('data', 777)");
|
