public String getAllItemsIdsForFeedSQL( String ID_SUBSCRIPTION, boolean onlyUnread, boolean onlyStarredItems, SORT_DIRECTION sortDirection) { String buildSQL = "SELECT " + RSS_ITEM_RSSITEM_ID + " FROM " + RSS_ITEM_TABLE + " WHERE subscription_id_subscription IN " + "(SELECT rowid " + "FROM subscription " + "WHERE rowid = " + ID_SUBSCRIPTION + ")"; if (onlyUnread && !onlyStarredItems) buildSQL += " AND " + RSS_ITEM_READ_TEMP + " != 1"; else if (onlyStarredItems) buildSQL += " AND " + RSS_ITEM_STARRED_TEMP + " = 1"; buildSQL += " ORDER BY " + RSS_ITEM_PUBDATE + " " + sortDirection.toString(); return buildSQL; }
@Deprecated public Cursor getAllItemsForFeed( String ID_SUBSCRIPTION, boolean onlyUnread, boolean onlyStarredItems, SORT_DIRECTION sortDirection) { String buildSQL = getAllFeedsSelectStatement() + " FROM " + RSS_ITEM_TABLE + " WHERE subscription_id_subscription IN " + "(SELECT rowid " + "FROM subscription " + "WHERE rowid = " + ID_SUBSCRIPTION + ")"; if (onlyUnread && !onlyStarredItems) buildSQL += " AND " + RSS_ITEM_READ_TEMP + " != 1"; else if (onlyStarredItems) buildSQL += " AND " + RSS_ITEM_STARRED_TEMP + " = 1"; buildSQL += " ORDER BY " + RSS_ITEM_PUBDATE + " " + sortDirection.toString(); if (DATABASE_DEBUG_MODE) Log.d("DB_HELPER", "getAllItemsForFeed SQL: " + buildSQL); return database.rawQuery(buildSQL, null); }
public Cursor getCurrentSelectedRssItems(SORT_DIRECTION sortDirection) { String query1 = getAllFeedsSelectStatement() + " FROM " + RSS_ITEM_TABLE; String query2 = "SELECT " + RSS_CURRENT_VIEW_RSS_ITEM_ID + " FROM " + RSS_CURRENT_VIEW_TABLE; String query = query1 + " WHERE " + RSS_ITEM_RSSITEM_ID + " IN (" + query2 + ")"; // query += " ORDER BY " + RSS_ITEM_PUBDATE + " " + query += " ORDER BY " + RSS_ITEM_PUBDATE + " " + sortDirection.toString(); return database.rawQuery(query, null); }
@Deprecated public Cursor getAllItemsForFolder( String ID_FOLDER, boolean onlyUnread, SORT_DIRECTION sortDirection) { String buildSQL = getAllFeedsSelectStatement() + " FROM " + RSS_ITEM_TABLE; if (!(ID_FOLDER.equals(SubscriptionExpandableListAdapter.ALL_UNREAD_ITEMS) || ID_FOLDER.equals(SubscriptionExpandableListAdapter.ALL_STARRED_ITEMS) || ID_FOLDER.equals( SubscriptionExpandableListAdapter .ALL_ITEMS))) // Wenn nicht Alle Artikel ausgewaehlt wurde (-10) oder (-11) fuer // Starred Feeds { buildSQL += " WHERE subscription_id_subscription IN " + "(SELECT sc.rowid " + "FROM subscription sc " + "JOIN folder f ON sc." + SUBSCRIPTION_FOLDER_ID + " = f.rowid " + "WHERE f.rowid = " + ID_FOLDER + ")"; if (onlyUnread) buildSQL += " AND " + RSS_ITEM_READ_TEMP + " != 1"; } // else if(ID_FOLDER.equals(SubscriptionExpandableListAdapter.ALL_UNREAD_ITEMS) && // onlyUnread)//only unRead should only be null when testing the size of items else if (ID_FOLDER.equals(SubscriptionExpandableListAdapter.ALL_UNREAD_ITEMS)) buildSQL += " WHERE " + RSS_ITEM_STARRED_TEMP + " != 1 AND " + RSS_ITEM_READ_TEMP + " != 1"; // else if(ID_FOLDER.equals(SubscriptionExpandableListAdapter.ALL_UNREAD_ITEMS)) // buildSQL += " WHERE " + RSS_ITEM_STARRED + " != 1"; // else if(ID_FOLDER.equals(SubscriptionExpandableListAdapter.ALL_STARRED_ITEMS) && onlyUnread) // buildSQL += " WHERE " + RSS_ITEM_STARRED_TEMP + " = 1 AND " + RSS_ITEM_READ_TEMP + " != 1"; else if (ID_FOLDER.equals(SubscriptionExpandableListAdapter.ALL_STARRED_ITEMS)) buildSQL += " WHERE " + RSS_ITEM_STARRED_TEMP + " = 1"; buildSQL += " ORDER BY " + RSS_ITEM_PUBDATE + " " + sortDirection.toString(); // buildSQL += " WHERE starred = 1"; if (DATABASE_DEBUG_MODE) Log.d("DB_HELPER", "getAllFeedData SQL: " + buildSQL); return database.rawQuery(buildSQL, null); }