| /cts/tests/tests/database/src/android/database/sqlite/cts/ |
| SQLiteSecurityTest.java | 58 mDatabase.execSQL("CREATE VIRTUAL TABLE ft USING fts3;");
59 mDatabase.execSQL("INSERT INTO ft_content VALUES(1,'aback');");
60 mDatabase.execSQL("INSERT INTO ft_content VALUES(2,'abaft');");
61 mDatabase.execSQL("INSERT INTO ft_content VALUES(3,'abandon');");
62 mDatabase.execSQL("INSERT INTO ft_segdir VALUES(0,0,0,0,'0 29',X"
67 mDatabase.execSQL("SELECT * FROM ft WHERE ft MATCH 'abandon';");
76 mDatabase.execSQL("CREATE VIRTUAL TABLE ft USING fts3;");
77 mDatabase.execSQL("INSERT INTO ft_segments VALUES(1,"
79 mDatabase.execSQL("INSERT INTO ft_segments VALUES(2,"
81 mDatabase.execSQL("INSERT INTO ft_segments VALUES(3,
[all...] |
| 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 | 150 mDatabase.execSQL(DELETE_1);
158 mDatabase.execSQL(DELETE_2);
170 mDatabase.execSQL("create table testRequery2 (i int);");
171 mDatabase.execSQL("insert into testRequery2 values(1);");
172 mDatabase.execSQL("insert into testRequery2 values(2);");
180 mDatabase.execSQL("insert into testRequery2 values(3);");
217 mDatabase.execSQL("CREATE TABLE Tst (Txt BLOB NOT NULL);");
221 mDatabase.execSQL("INSERT INTO Tst VALUES (?)", new Object[]{testArr});
238 mDatabase.execSQL("CREATE TABLE Tst (Num Integer NOT NULL);");
241 mDatabase.execSQL("INSERT INTO Tst VALUES (?)", new Object[]{i})
[all...] |
| SQLiteDatabaseTest.java | 174 mDatabase.execSQL("CREATE TABLE test (num INTEGER);");
175 mDatabase.execSQL("INSERT INTO test (num) VALUES (0)");
177 // test execSQL without any explicit transactions.
283 mDatabase.execSQL("UPDATE test SET num = " + num);
336 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, "
377 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, "
379 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Mike', 20, 'LA');");
380 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Jack', 30, 'London');");
381 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Jim', 35, 'Chicago');");
417 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Mike', 20, 'LA');")
[all...] |
| 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, " +
|
| SQLiteStatementTest.java | 71 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
75 mDatabase.execSQL("CREATE TABLE blob_test (_id INTEGER PRIMARY KEY, data BLOB)");
167 mDatabase.execSQL("CREATE TABLE test (num INTEGER NOT NULL, str TEXT NOT NULL);");
168 mDatabase.execSQL("INSERT INTO test VALUES (1234, 'hello');");
191 mDatabase.execSQL("CREATE TABLE test (num INTEGER NOT NULL, str TEXT NOT NULL);");
192 mDatabase.execSQL("INSERT INTO test VALUES (1234, 'hello');");
|
| SQLiteQueryBuilderTest.java | 147 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, " +
149 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Mike', '20', 'LA');");
150 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('jack', '40', 'LA');");
448 mDatabase.execSQL("CREATE TABLE x (v INTEGER);");
450 mDatabase.execSQL("INSERT INTO x VALUES (?)", new Object[] { i });
651 mDatabase.execSQL("DROP TABLE IF EXISTS employee;");
652 mDatabase.execSQL("CREATE TABLE employee (_id INTEGER PRIMARY KEY, " +
654 mDatabase.execSQL("INSERT INTO employee (name, month, salary) " +
656 mDatabase.execSQL("INSERT INTO employee (name, month, salary) " +
658 mDatabase.execSQL("INSERT INTO employee (name, month, salary) "
[all...] |
| /external/robolectric-shadows/robolectric/src/test/java/org/robolectric/shadows/ |
| SQLiteDatabaseTest.java | 39 database.execSQL("CREATE TABLE table_name (\n" +
47 database.execSQL("CREATE TABLE rawtable (\n" +
55 database.execSQL("CREATE TABLE exectable (\n" +
63 database.execSQL("CREATE TABLE blob_table (\n" +
348 database.execSQL("INSERT INTO table_name (id, name) VALUES(1234, 'Chuck');");
365 database.execSQL("CREATE TABLE `routine` (`id` INTEGER PRIMARY KEY AUTOINCREMENT , `name` VARCHAR , `lastUsed` INTEGER DEFAULT 0 , UNIQUE (`name`)) ", new Object[]{});
366 database.execSQL("INSERT INTO `routine` (`name` ,`lastUsed` ) VALUES (?,?)", new Object[]{"Leg Press", 0});
367 database.execSQL("INSERT INTO `routine` (`name` ,`lastUsed` ) VALUES (?,?)", new Object[]{"Bench Press", 1});
391 database.execSQL("INSERT INTO table_name;"); // invalid SQL
396 database.execSQL("insert into exectable (first_column) values (?);", null)
[all...] |
| ShadowSimpleCursorAdapterTest.java | 64 database.execSQL("CREATE TABLE table_name(_id INT PRIMARY KEY, name VARCHAR(255));");
74 database.execSQL(insert);
|
| ShadowSQLiteConnectionTest.java | 71 database.execSQL("insert into routine(name) values ('??????? ???????')");
72 database.execSQL("insert into routine(name) values ('Hand press 1')");
73 database.execSQL("insert into routine(name) values ('hand press 2')");
74 database.execSQL("insert into routine(name) values ('Hand press 3')");
135 database.execSQL("insert into routine(name) values ('Hand press 1')");
152 database.execSQL("insert into routine(name) values ('??????? ???????')");
|
| SQLiteCursorTest.java | 26 database.execSQL("CREATE TABLE table_name(" +
207 database.execSQL(sql, new Object[]{byteData});
224 database.execSQL(sql, new Object[]{s});
277 database.execSQL(sql, new Object[]{byteData});
289 database.execSQL(sql, new Object[]{byteData});
317 database.execSQL("update table_name set name = '1.2'");
327 database.execSQL("update table_name set name = '1.2'");
433 database.execSQL(sql, new Object[]{byteData});
449 database.execSQL(sql);
471 database.execSQL(insert)
[all...] |
| /cts/tests/tests/database/src/android/database/cts/ |
| DatabaseUtilsTest.java | 63 mDatabase.execSQL("CREATE TABLE " + TABLE_NAME + " (_id INTEGER PRIMARY KEY, " +
65 mDatabase.execSQL(
67 mDatabase.execSQL(
160 mDatabase.execSQL("INSERT INTO " + TABLE_NAME + " (name, age, address)" +
180 mDatabase.execSQL("INSERT INTO " + TABLE_NAME + " (name, age, address)" +
199 mDatabase.execSQL("INSERT INTO " + TABLE_NAME + " (name, age, address)" +
228 mDatabase.execSQL("INSERT INTO " + TABLE_NAME + " (name, age, address)" +
257 mDatabase.execSQL("INSERT INTO " + TABLE_NAME + " (name, age, address)" +
270 mDatabase.execSQL("INSERT INTO boolean_test (value)" +
272 mDatabase.execSQL("INSERT INTO boolean_test (value)"
[all...] |
| DatabaseCursorTest.java | 98 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
100 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
101 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
102 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
108 mDatabase.execSQL(
126 mDatabase.execSQL(sql, args);
148 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data REAL);");
259 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
270 mDatabase.execSQL(sql.toString());
320 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data INT);")
[all...] |
| CursorWrapperTest.java | 299 mDatabase.execSQL("CREATE TABLE test2 (_id INTEGER PRIMARY KEY, string_text TEXT,"
313 mDatabase.execSQL(sql, args);
349 mDatabase.execSQL(sql);
356 mDatabase.execSQL("DROP TABLE test2");
460 database.execSQL("DELETE FROM test1 WHERE number = " + value + ";");
464 database.execSQL("INSERT INTO test1 (number) VALUES ('" + value + "');");
490 mDatabase.execSQL("CREATE TABLE test1 (_id INTEGER PRIMARY KEY, number TEXT);");
491 mDatabase.execSQL("INSERT INTO test1 (number) VALUES ('" + FIRST_NUMBER + "');");
492 mDatabase.execSQL("INSERT INTO test1 (number) VALUES ('" + SECOND_NUMBER + "');");
|
| MergeCursorTest.java | 100 mDatabase.execSQL("CREATE TABLE " + TABLE5_NAME + " (_id INTEGER PRIMARY KEY,"
103 mDatabase.execSQL(sql);
291 mDatabase.execSQL("INSERT INTO " + TABLE1_NAME + " (number_1) VALUES ('" + TEST_VALUE1
297 mDatabase.execSQL("INSERT INTO " + TABLE2_NAME + " (number_1) VALUES ('" + TEST_VALUE2
314 mDatabase.execSQL("CREATE TABLE " + tablename + " (_id INTEGER PRIMARY KEY,"
320 mDatabase.execSQL(sql, args);
323 mDatabase.execSQL(sql);
343 mDatabase.execSQL(sql);
348 mDatabase.execSQL("INSERT INTO " + tableName + "(number_1) VALUES ('"
|
| CursorJoinerTest.java | 229 mDatabase.execSQL(sql);
234 mDatabase.execSQL("INSERT INTO " + tableName + "(number) VALUES ('"
240 mDatabase.execSQL("INSERT INTO " + tableName + "(number) VALUES ('" + value + "');");
244 mDatabase.execSQL("DELETE FROM " + tableName + " WHERE number = '" + value + "';");
|
| /frameworks/base/apct-tests/perftests/core/src/android/database/ |
| SQLiteDatabasePerfTest.java | 62 mDatabase.execSQL("CREATE TABLE T1 "
64 mDatabase.execSQL("CREATE TABLE T2 ("
224 mDatabase.execSQL("INSERT INTO T1 VALUES (?, ?, ?, ?)", insertsArgs);
257 mDatabase.execSQL("INSERT INTO T1 VALUES (?, ?, ?, ?)",
267 mDatabase.execSQL("INSERT INTO T2 VALUES (?, ?, ?)",
|
| CursorWindowPerfTest.java | 57 sDatabase.execSQL(helper.createSql());
61 sDatabase.execSQL(insert, helper.createItem(0));
|
| /development/samples/training/threadsample/src/com/example/android/threadsample/ |
| DataProvider.java | 157 db.execSQL("DROP TABLE IF EXISTS " + DataProviderContract.PICTUREURL_TABLE_NAME);
158 db.execSQL("DROP TABLE IF EXISTS " + DataProviderContract.DATE_TABLE_NAME);
171 db.execSQL(CREATE_PICTUREURL_TABLE_SQL);
172 db.execSQL(CREATE_DATE_TABLE_SQL);
|
| /cts/hostsidetests/appsecurity/test-apps/AppWithData/src/com/android/cts/appwithdata/ |
| CreatePrivateDataTest.java | 181 db.execSQL("CREATE TABLE " + DB_TABLE_NAME + " ("
188 db.execSQL("DROP TABLE IF EXISTS " + DB_TABLE_NAME);
|
| /cts/tests/tests/widget/src/android/widget/cts/ |
| CursorTreeAdapterTest.java | 88 mDatabase.execSQL("CREATE TABLE group_table (_id INTEGER PRIMARY KEY, name TEXT);");
89 mDatabase.execSQL("INSERT INTO group_table (name) VALUES ('" + GROUP_ONE + "');");
90 mDatabase.execSQL("INSERT INTO group_table (name) VALUES ('" + GROUP_TWO + "');");
95 mDatabase.execSQL("CREATE TABLE child1 (_id INTEGER PRIMARY KEY, value TEXT);");
96 mDatabase.execSQL("INSERT INTO child1 (value) VALUES ('" + CHILD_VALUE_ONE + "');");
97 mDatabase.execSQL("INSERT INTO child1 (value) VALUES ('" + CHILD_VALUE_TWO + "');");
106 mDatabase.execSQL("CREATE TABLE child2 (_id INTEGER PRIMARY KEY, value TEXT);");
107 mDatabase.execSQL("INSERT INTO child2 (value) VALUES ('" + CHILD_VALUE_THREE + "');");
|
| /developers/build/prebuilts/gradle/SpeedTracker/Application/src/main/java/com/example/android/wearable/speedtracker/db/ |
| LocationDbHelper.java | 70 db.execSQL(SQL_CREATE_ENTRIES);
75 db.execSQL(SQL_DELETE_ENTRIES);
|
| /developers/samples/android/wearable/wear/SpeedTracker/Application/src/main/java/com/example/android/wearable/speedtracker/db/ |
| LocationDbHelper.java | 70 db.execSQL(SQL_CREATE_ENTRIES);
75 db.execSQL(SQL_DELETE_ENTRIES);
|
| /development/samples/MySampleRss/src/com/example/codelab/rssexample/ |
| RssContentProvider.java | 82 db.execSQL(sql);
94 db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE_NAME + ";");
|
| /development/samples/SearchableDictionary/src/com/example/android/searchabledict/ |
| DictionaryDatabase.java | 183 mDatabase.execSQL(FTS_TABLE_CREATE);
240 db.execSQL("DROP TABLE IF EXISTS " + FTS_VIRTUAL_TABLE);
|
