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);
}
