From 38028b1e7e47b239a4942c851a04c9903fc684c3 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@fakecake.org>
Date: Fri, 9 Sep 2011 11:03:14 +0400
Subject: update feedlist on unread count change, implement feeds_unread view

---
 src/org/fox/ttrss/DatabaseHelper.java | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'src/org/fox/ttrss/DatabaseHelper.java')

diff --git a/src/org/fox/ttrss/DatabaseHelper.java b/src/org/fox/ttrss/DatabaseHelper.java
index 35d564a0..e9d350b9 100644
--- a/src/org/fox/ttrss/DatabaseHelper.java
+++ b/src/org/fox/ttrss/DatabaseHelper.java
@@ -10,7 +10,7 @@ public class DatabaseHelper extends SQLiteOpenHelper {
 
 	private final String TAG = this.getClass().getSimpleName();
 	public static final String DATABASE_NAME = "LocalStorage";
-	public static final int DATABASE_VERSION = 4;
+	public static final int DATABASE_VERSION = 6;
 	
 	public DatabaseHelper(Context context) {
 		super(context, DATABASE_NAME, null, DATABASE_VERSION);
@@ -20,6 +20,7 @@ public class DatabaseHelper extends SQLiteOpenHelper {
 	public void onCreate(SQLiteDatabase db) {
 		db.execSQL("DROP TABLE IF EXISTS feeds;");
 		db.execSQL("DROP TABLE IF EXISTS articles;");
+		db.execSQL("DROP VIEW IF EXISTS feeds_unread;");
 		
 		db.execSQL("CREATE TABLE IF NOT EXISTS feeds (" +
                 BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
@@ -45,6 +46,11 @@ public class DatabaseHelper extends SQLiteOpenHelper {
                 "tags TEXT, " +
                 "content TEXT" +
                 ");");
+		
+		db.execSQL("CREATE VIEW feeds_unread AS SELECT feeds._id AS _id, " +
+				"feeds.title AS title, " +
+				"SUM(articles.unread) AS unread FROM feeds " +
+				"LEFT JOIN articles ON (articles.feed_id = feeds._id) GROUP BY feeds._id, feeds.title;");
 	}
 
 	@Override
-- 
cgit v1.2.3-54-g00ecf