public int numberOfRows() { SQLiteDatabase db = this.getReadableDatabase(); int numRows = (int) DatabaseUtils.queryNumEntries(db, CARS_TABLE_NAME); return numRows; }
@Test public void testQuote() { assertThat(DatabaseUtils.sqlEscapeString("foobar")).isEqualTo("'foobar'"); assertThat(DatabaseUtils.sqlEscapeString("Rich's")).isEqualTo("'Rich''s'"); }
@Test public void testQuoteWithBuilder() { StringBuilder builder = new StringBuilder(); DatabaseUtils.appendEscapedSQLString(builder, "foobar"); assertThat(builder.toString()).isEqualTo("'foobar'"); builder = new StringBuilder(); DatabaseUtils.appendEscapedSQLString(builder, "Blundell's"); assertThat(builder.toString()).isEqualTo("'Blundell''s'"); } }
public static void logTableDump(SQLiteDatabase db, String tablename) { Cursor cursor = db.query(tablename, null, null, null, null, null, null); try { String dump = DatabaseUtils.dumpCursorToString(cursor); DaoLog.d(dump); } finally { cursor.close(); } }
@Override public long longForQuery(String query, String[] selectionArgs) { return DatabaseUtils.longForQuery(database, query, selectionArgs); }
@Override public int getType(int columnIndex) { return DatabaseUtils.getTypeOfObject(results[0][columnIndex]); }
public static void logTableDump(SQLiteDatabase db, String tablename) { Cursor cursor = db.query(tablename, null, null, null, null, null, null); try { String dump = DatabaseUtils.dumpCursorToString(cursor); DaoLog.d(dump); } finally { cursor.close(); } }
/** * Counts number of rows of the prefix table. */ @VisibleForTesting int countPrefixTableRows(SQLiteDatabase db) { return (int)DatabaseUtils.longForQuery(db, "SELECT COUNT(1) FROM " + Tables.PREFIX_TABLE, null); }
@Override public int getType(int columnIndex) { return DatabaseUtils.getTypeOfObject(results[0][columnIndex]); }
public int numberOfRows() { SQLiteDatabase db = this.getReadableDatabase(); int numRows = (int) DatabaseUtils.queryNumEntries(db, CONTACTS_TABLE_NAME); return numRows; }
builder.appendWhere( TrayContract.Preferences.Columns.KEY + " = " + DatabaseUtils.sqlEscapeString(uri.getPathSegments().get(2))); DatabaseUtils.sqlEscapeString(uri.getPathSegments().get(1)));
/** * Append a chunk to the WHERE clause of the query. All chunks appended are surrounded * by parenthesis and ANDed with the selection passed to {@link #query}. The final * WHERE clause looks like: * * WHERE (<append chunk 1><append chunk2>) AND (<query() selection parameter>) * * @param inWhere the chunk of text to append to the WHERE clause. it will be escaped * to avoid SQL injection attacks */ public void appendWhereEscapeString(String inWhere) { if (mWhereClause == null) { mWhereClause = new StringBuilder(inWhere.length() + 16); } if (mWhereClause.length() == 0) { mWhereClause.append('('); } DatabaseUtils.appendEscapedSQLString(mWhereClause, inWhere); }
public static void logTableDump(SQLiteDatabase db, String tablename) { Cursor cursor = db.query(tablename, null, null, null, null, null, null); try { String dump = DatabaseUtils.dumpCursorToString(cursor); DaoLog.d(dump); } finally { cursor.close(); } }
public int update(SQLiteDatabase db, long rowId, Object data) { if (DatabaseUtils.longForQuery(db, QUERY_COUNT_SYNC_STATE_ROWS, new String[]{Long.toString(rowId)}) < 1) { return 0; } db.execSQL("UPDATE " + SYNC_STATE_TABLE + " SET " + SyncStateContract.Columns.DATA + "=?" + " WHERE " + SyncStateContract.Columns._ID + "=" + rowId, new Object[]{data}); // assume a row was modified since we know it exists return 1; }
@Override public int getType(int columnIndex) { return DatabaseUtils.getTypeOfObject(results[0][columnIndex]); }
final long items = DatabaseUtils.queryNumEntries(sqlDb, table, selection, selectionArgs);
public static String getSQLValue(Object value) { return (value instanceof Number) ? String.valueOf(value) : DatabaseUtils.sqlEscapeString(String.valueOf(value)); }
/** * Appending the LIKE operator clause. * * @param expr the former operand. * @return this statement. */ public Statement like(String expr) { statement.append(" LIKE "); appendEscapedSQLString(statement, expr); return this; }
public static void logTableDump(SQLiteDatabase db, String tablename) { Cursor cursor = db.query(tablename, null, null, null, null, null, null); try { String dump = DatabaseUtils.dumpCursorToString(cursor); DaoLog.d(dump); } finally { cursor.close(); } }
public void onDatabaseOpened(SQLiteDatabase db) { long version = DatabaseUtils.longForQuery(db, "SELECT " + SYNC_STATE_META_VERSION_COLUMN + " FROM " + SYNC_STATE_META_TABLE, null); if (version != DB_VERSION) { createDatabase(db); } }