From 0dbf6d75cadc21f8b03e1a00052e066c1f555e74 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@fakecake.org>
Date: Sun, 27 Nov 2011 16:20:27 +0300
Subject: drop databasehelper, misc cleanup, suppress some warnings

---
 src/org/fox/ttrss/DatabaseHelper.java | 62 -----------------------------------
 1 file changed, 62 deletions(-)
 delete mode 100644 src/org/fox/ttrss/DatabaseHelper.java

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

diff --git a/src/org/fox/ttrss/DatabaseHelper.java b/src/org/fox/ttrss/DatabaseHelper.java
deleted file mode 100644
index 2b0a1f70..00000000
--- a/src/org/fox/ttrss/DatabaseHelper.java
+++ /dev/null
@@ -1,62 +0,0 @@
-package org.fox.ttrss;
-import android.content.Context;
-import android.database.sqlite.SQLiteDatabase;
-import android.database.sqlite.SQLiteOpenHelper;
-import android.provider.BaseColumns;
-
-
-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 = 7;
-	
-	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("CREATE TABLE IF NOT EXISTS feeds (" +
-                BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
-                "feed_url TEXT, " +
-                "title TEXT, " +
-                "unread INTEGER, " +
-                "has_icon BOOLEAN, " +
-                "cat_id INTEGER, " +
-                "last_updated INTEGER, " +
-                "count 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, " +
-                "excerpt TEXT" +
-                ");");
-		
-		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