From 4f1c690e91f5f37aa24c336180120e451f87822a Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 22 Jun 2012 15:05:50 +0400 Subject: initial support for categories in offline mode layout tweaks --- src/org/fox/ttrss/util/DatabaseHelper.java | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'src/org/fox/ttrss/util/DatabaseHelper.java') diff --git a/src/org/fox/ttrss/util/DatabaseHelper.java b/src/org/fox/ttrss/util/DatabaseHelper.java index 345e0782..501aadd1 100644 --- a/src/org/fox/ttrss/util/DatabaseHelper.java +++ b/src/org/fox/ttrss/util/DatabaseHelper.java @@ -60,9 +60,22 @@ public class DatabaseHelper extends SQLiteOpenHelper { db.execSQL("CREATE VIEW feeds_unread AS SELECT feeds."+BaseColumns._ID+" AS "+BaseColumns._ID+", " + "feeds.title AS title, " + + "cat_id, " + "SUM(articles.unread) AS unread FROM feeds " + "LEFT JOIN articles ON (articles.feed_id = feeds."+BaseColumns._ID+") " + "GROUP BY feeds."+BaseColumns._ID+", feeds.title;"); + + //sqlite> select categories._id,categories.title,sum(articles.unread) from categories left j + //oin feeds on (feeds.cat_id = categories._id) left join articles on (articles.feed_id = fee + //ds._id) group by categories._id; + + db.execSQL("CREATE VIEW cats_unread AS SELECT categories."+BaseColumns._ID+" AS "+BaseColumns._ID+", " + + "categories.title AS title, " + + "SUM(articles.unread) AS unread FROM categories " + + "LEFT JOIN feeds ON (feeds.cat_id = categories."+BaseColumns._ID+") "+ + "LEFT JOIN articles ON (articles.feed_id = feeds."+BaseColumns._ID+") " + + "GROUP BY categories."+BaseColumns._ID+", categories.title;"); + } @Override -- cgit v1.2.3-54-g00ecf