diff options
| author | Andrew Dolgov <fox@madoka.volgo-balt.ru> | 2011-12-06 12:38:08 +0300 |
|---|---|---|
| committer | Andrew Dolgov <fox@madoka.volgo-balt.ru> | 2011-12-06 12:38:08 +0300 |
| commit | d4b6e34b98bb56d0495ea2bd7d9dfb12d45920c6 (patch) | |
| tree | 5a8512724a1e7bbb38e185e93b985b81348bcca8 /src/org | |
| parent | 815e40a698057cd8260d962bb7ec83d2bcf8d5ba (diff) | |
add modified trigger
Diffstat (limited to 'src/org')
| -rw-r--r-- | src/org/fox/ttrss/DatabaseHelper.java | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/src/org/fox/ttrss/DatabaseHelper.java b/src/org/fox/ttrss/DatabaseHelper.java index 8939ffa3..dbdf110a 100644 --- a/src/org/fox/ttrss/DatabaseHelper.java +++ b/src/org/fox/ttrss/DatabaseHelper.java @@ -9,7 +9,7 @@ public class DatabaseHelper extends SQLiteOpenHelper { private final String TAG = this.getClass().getSimpleName();
public static final String DATABASE_NAME = "OfflineStorage.db";
- public static final int DATABASE_VERSION = 1;
+ public static final int DATABASE_VERSION = 2;
public DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
@@ -20,6 +20,7 @@ public class DatabaseHelper extends SQLiteOpenHelper { db.execSQL("DROP TABLE IF EXISTS feeds;");
db.execSQL("DROP TABLE IF EXISTS articles;");
db.execSQL("DROP VIEW IF EXISTS feeds_unread;");
+ db.execSQL("DROP TRIGGER IF EXISTS articles_set_modified;");
db.execSQL("CREATE TABLE IF NOT EXISTS feeds (" +
BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
@@ -40,10 +41,16 @@ public class DatabaseHelper extends SQLiteOpenHelper { "link TEXT, " +
"feed_id INTEGER, " +
"tags TEXT, " +
- "content TEXT," +
- "selected BOOLEAN" +
+ "content TEXT, " +
+ "selected BOOLEAN, " +
+ "modified BOOLEAN" +
");");
+ db.execSQL("CREATE TRIGGER articles_set_modified UPDATE OF marked, published, unread ON articles " +
+ "BEGIN " +
+ " UPDATE articles SET modified = 1 WHERE " + BaseColumns._ID + " = " + "OLD." + BaseColumns._ID + "; " +
+ "END;");
+
db.execSQL("CREATE VIEW feeds_unread AS SELECT feeds."+BaseColumns._ID+" AS "+BaseColumns._ID+", " +
"feeds.title AS title, " +
"SUM(articles.unread) AS unread FROM feeds " +
|