diff options
| author | Andrew Dolgov <fox@madoka.volgo-balt.ru> | 2012-06-22 15:05:50 +0400 |
|---|---|---|
| committer | Andrew Dolgov <fox@madoka.volgo-balt.ru> | 2012-06-22 15:05:50 +0400 |
| commit | 4f1c690e91f5f37aa24c336180120e451f87822a (patch) | |
| tree | cab434e02a8b09632e1c97fdd097fe765e845dd5 /src/org/fox/ttrss/util/DatabaseHelper.java | |
| parent | 3063d86667f1738d600308b152092ac494538336 (diff) | |
initial support for categories in offline mode
layout tweaks
Diffstat (limited to 'src/org/fox/ttrss/util/DatabaseHelper.java')
| -rw-r--r-- | src/org/fox/ttrss/util/DatabaseHelper.java | 13 |
1 files changed, 13 insertions, 0 deletions
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
|