update feedlist on unread count change, implement feeds_unread view

1 files changed, 7 insertions, 1 deletions

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