@Override public long longForQuery(String query, String[] selectionArgs) { return DatabaseUtils.longForQuery(database, query, selectionArgs); }
/** * 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); }
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; }
public int getRecommendationMigrationState() { try { return (int) DatabaseUtils.longForQuery(getReadableDatabase(), "SELECT state FROM rec_migration", null); } catch (SQLiteDoneException e) { return 0; } }
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); } }
private int getRecommendationMigrationState() { try { return (int) DatabaseUtils.longForQuery(getReadableDatabase(), "SELECT state FROM rec_migration", null); } catch (SQLiteDoneException e) { return 0; } }
public long getMessageCount(String conversationId) { AVIMMessage lastBreakPointMessage = this.getLatestMessageWithBreakpoint(conversationId, true); SQLiteDatabase db = dbHelper.getReadableDatabase(); long messageCount = 0; if (lastBreakPointMessage == null) { messageCount = DatabaseUtils.longForQuery(db, "select count(*) from " + MESSAGE_TABLE + " where " + COLUMN_CONVERSATION_ID + " = ?", new String[] {conversationId}); } else { messageCount = DatabaseUtils.longForQuery( db, "select count(*) from " + MESSAGE_TABLE + " where " + COLUMN_CONVERSATION_ID + " = ? and (" + COLUMN_TIMESTAMP + " > ? or ( " + COLUMN_TIMESTAMP + " = ? and " + COLUMN_MESSAGE_ID + " >= ? )) order by " + SQL.ORDER_BY_TIMESTAMP_DESC_THEN_MESSAGE_ID_DESC, new String[] {conversationId, String.valueOf(lastBreakPointMessage.timestamp), String.valueOf(lastBreakPointMessage.timestamp), lastBreakPointMessage.messageId}); } return messageCount; }
public long countForQuery(String query, String[] selectionArgs) { if (StringUtil.isEmpty(query)) { return 0l; } SQLiteDatabase db = dbHelper.getReadableDatabase(); return DatabaseUtils.longForQuery(db, query, selectionArgs); }