Home
last modified time | relevance | path

Searched refs:sql (Results 1 – 9 of 9) sorted by relevance

/cts/tests/tests/database/src/android/database/cts/
DDatabaseCursorTest.java125 String sql = "INSERT INTO test (s, d, l, b) VALUES (?,?,?,?)"; in testBlob() local
126 mDatabase.execSQL(sql, args); in testBlob()
261 StringBuilder sql = new StringBuilder(2100); in testLargeField() local
262 sql.append("INSERT INTO test (data) VALUES ('"); in testLargeField()
268 sql.append(randomString); in testLargeField()
269 sql.append("');"); in testLargeField()
270 mDatabase.execSQL(sql.toString()); in testLargeField()
349 StringBuilder sql = new StringBuilder(2100); in testManyRowsTxt() local
350 sql.append("INSERT INTO test (data) VALUES ('"); in testManyRowsTxt()
356 sql.append(randomString); in testManyRowsTxt()
[all …]
DMergeCursorTest.java102 String sql = "INSERT INTO " + TABLE5_NAME + " (" + TEXT_COLUMN_NAME + ") VALUES ('TEXT')"; in testCursorSwiching() local
103 mDatabase.execSQL(sql); in testCursorSwiching()
318 String sql = "INSERT INTO " + tablename + " (string_text, double_number, int_number," in buildDatabaseWithTestValues() local
320 mDatabase.execSQL(sql, args); in buildDatabaseWithTestValues()
322 sql = "INSERT INTO " + tablename + " (string_text) VALUES ('" + COLUMN_FOR_NULL_TEST + "')"; in buildDatabaseWithTestValues()
323 mDatabase.execSQL(sql); in buildDatabaseWithTestValues()
341 String sql = "Create TABLE " + tableName + " (_id INTEGER PRIMARY KEY, " + columnNames in createTable() local
343 mDatabase.execSQL(sql); in createTable()
DCursorWrapperTest.java311 String sql = "INSERT INTO test2 (string_text, double_number, int_number, blob_data)" in testGettingValues() local
313 mDatabase.execSQL(sql, args); in testGettingValues()
348 sql = "INSERT INTO test2 (string_text) VALUES ('" + STRING_TEXT2 + "')"; in testGettingValues()
349 mDatabase.execSQL(sql); in testGettingValues()
DCursorJoinerTest.java227 String sql = "Create TABLE " + tableName + " (_id INTEGER PRIMARY KEY, " + columnNames in createTable() local
229 mDatabase.execSQL(sql); in createTable()
DDatabaseUtilsTest.java123 String sql = "INSERT INTO " + TABLE_NAME + " (name, age, address) VALUES (?, ?, ?);"; in testBindObjectToProgram() local
124 SQLiteStatement statement = mDatabase.compileStatement(sql); in testBindObjectToProgram()
/cts/tests/tests/database/src/android/database/sqlite/cts/
DSQLiteQueryBuilderTest.java84 String sql = sqliteQueryBuilder.buildQuery(new String[] { "age", "address" }, in testSetDistinct() local
88 assertEquals(expected, sql); in testSetDistinct()
94 sql = sqliteQueryBuilder.buildQuery(new String[] { "age", "address" }, in testSetDistinct()
98 assertEquals(expected, sql); in testSetDistinct()
104 sql = sqliteQueryBuilder.buildQuery(new String[] { "age", "address" }, in testSetDistinct()
109 assertEquals(expected, sql); in testSetDistinct()
123 String sql = sqliteQueryBuilder.buildQuery(new String[] { "EmployeeName", "EmployeeAge" }, in testSetProjectionMap() local
126 assertEquals(expected, sql); in testSetProjectionMap()
128 sql = sqliteQueryBuilder.buildQuery(null, // projectionIn is null in testSetProjectionMap()
130 assertTrue(sql.matches("SELECT (age|name|address), (age|name|address), (age|name|address) " in testSetProjectionMap()
[all …]
DSQLiteStatementTest.java225 String sql = "SELECT data FROM blob_test WHERE _id = " + 2; in testSimpleQueryForBlobFileDescriptorSuccessNull() local
226 SQLiteStatement stm = mDatabase.compileStatement(sql); in testSimpleQueryForBlobFileDescriptorSuccessNull()
245 String sql = "SELECT data FROM blob_test WHERE _id = " + i; in doTestSimpleQueryForBlobFileDescriptorSuccess() local
246 SQLiteStatement stm = mDatabase.compileStatement(sql); in doTestSimpleQueryForBlobFileDescriptorSuccess()
254 String sql = "SELECT data FROM blob_test WHERE _id = ?"; in testSimpleQueryForBlobFileDescriptorSuccessParam() local
255 SQLiteStatement stm = mDatabase.compileStatement(sql); in testSimpleQueryForBlobFileDescriptorSuccessParam()
264 String sql = "SELECT data FROM blob_test WHERE _id = 100"; in testGetBlobFailureNoParam() local
265 SQLiteStatement stm = mDatabase.compileStatement(sql); in testGetBlobFailureNoParam()
284 String sql = "SELECT data FROM blob_test WHERE _id = ?"; in testGetBlobFailureParam() local
285 SQLiteStatement stm = mDatabase.compileStatement(sql); in testGetBlobFailureParam()
DSQLiteDatabaseTest.java348 String sql = "INSERT INTO test (name, age, address) VALUES (?, ?, ?);"; in testCompileStatement() local
349 SQLiteStatement insertStatement = mDatabase.compileStatement(sql); in testCompileStatement()
834 String sql = "SELECT name, month FROM employee WHERE salary > ?;"; in testQuery() local
835 cursor = mDatabase.rawQuery(sql, new String[] { "2000" }); in testQuery()
848 cursor = mDatabase.rawQueryWithFactory(factory, sql, new String[] { "2000" }, null); in testQuery()
971 String sql = "SELECT data FROM test ORDER BY data COLLATE LOCALIZED ASC"; in testSetLocale() local
972 Cursor cursor = mDatabase.rawQuery(sql, null); in testSetLocale()
1081 String sql = "INSERT INTO test (i) VALUES (?);"; in testGroupConcat() local
1082 SQLiteStatement insertStatement = mDatabase.compileStatement(sql); in testGroupConcat()
1119 String sql = "INSERT INTO test VALUES (?, ?);"; in testSchemaChanges() local
[all …]
DSQLiteCursorTest.java263 String sql = "Create TABLE " + tableName + " (_id INTEGER PRIMARY KEY, " in createTable() local
265 mDatabase.execSQL(sql); in createTable()