From 08397a47af403d64a012a7961e7444254ccaa9a2 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.volgo-balt.ru>
Date: Tue, 19 Jun 2012 14:18:00 +0400
Subject: categorize source files

---
 src/org/fox/ttrss/util/DatabaseHelper.java | 67 ++++++++++++++++++++++++++++++
 1 file changed, 67 insertions(+)
 create mode 100644 src/org/fox/ttrss/util/DatabaseHelper.java

(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
new file mode 100644
index 00000000..b8560589
--- /dev/null
+++ b/src/org/fox/ttrss/util/DatabaseHelper.java
@@ -0,0 +1,67 @@
+package org.fox.ttrss.util;
+import android.content.Context;
+import android.database.sqlite.SQLiteDatabase;
+import android.database.sqlite.SQLiteOpenHelper;
+import android.provider.BaseColumns;
+
+
+public class DatabaseHelper extends SQLiteOpenHelper {
+
+	@SuppressWarnings("unused")
+	private final String TAG = this.getClass().getSimpleName();
+	public static final String DATABASE_NAME = "OfflineStorage.db";
+	public static final int DATABASE_VERSION = 2;
+	
+	public DatabaseHelper(Context context) {
+		super(context, DATABASE_NAME, null, DATABASE_VERSION);
+	}
+	
+	@Override
+	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("DROP TRIGGER IF EXISTS articles_set_modified;");
+		
+		db.execSQL("CREATE TABLE IF NOT EXISTS feeds (" +
+                BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
+                "feed_url TEXT, " +
+                "title TEXT, " +
+                "has_icon BOOLEAN, " +
+                "cat_id INTEGER" +
+                ");");                
+
+		db.execSQL("CREATE TABLE IF NOT EXISTS articles (" +
+                BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
+                "unread BOOLEAN, " +
+                "marked BOOLEAN, " +
+                "published BOOLEAN, " +
+                "updated INTEGER, " +
+                "is_updated BOOLEAN, " +
+                "title TEXT, " +
+                "link TEXT, " +
+                "feed_id INTEGER, " +
+                "tags TEXT, " +
+                "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 " +
+				"LEFT JOIN articles ON (articles.feed_id = feeds."+BaseColumns._ID+") " +
+				"GROUP BY feeds."+BaseColumns._ID+", feeds.title;");
+	}
+
+	@Override
+	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
+		onCreate(db);
+	}
+
+}
-- 
cgit v1.2.3-54-g00ecf