1 files changed, 39 insertions, 2 deletions
diff --git a/app/src/main/java/net/lacolaco/smileessence/Application.kt b/app/src/main/java/net/lacolaco/smileessence/Application.kt
index 17c6e6d6..375336f4 100644
--- a/app/src/main/java/net/lacolaco/smileessence/Application.kt
+++ b/app/src/main/java/net/lacolaco/smileessence/Application.kt
@@ -1,19 +1,23 @@
 package net.lacolaco.smileessence
 
+import android.content.Context
+import android.database.sqlite.SQLiteDatabase
+import android.database.sqlite.SQLiteOpenHelper
 import android.support.annotation.StringRes
 import android.widget.Toast
 import com.squareup.leakcanary.LeakCanary
-import net.lacolaco.smileessence.data.DbHelper
 
 class Application : android.app.Application() {
+    private lateinit var dbOpenHelper: DbOpenHelper
+
     override fun onCreate() {
         super.onCreate()
         if (LeakCanary.isInAnalyzerProcess(this))
             return
         LeakCanary.install(this)
 
+        dbOpenHelper = DbOpenHelper(this)
         instance = this
-        DbHelper.setup(this)
         World.load()
     }
 
@@ -30,5 +34,38 @@ class Application : android.app.Application() {
         }
 
         var currentWorld: World? = null
+
+        val db
+            get() = instance.dbOpenHelper.writableDatabase!!
+    }
+
+    private class DbOpenHelper(context: Context) : SQLiteOpenHelper(context, DATABASE_NAME, null, DATABASE_VERSION) {
+        override fun onCreate(db: SQLiteDatabase) {
+            // Schema v1
+            db.execSQL("""
+            CREATE TABLE profiles (
+                id                  INTEGER PRIMARY KEY,
+                oauth_token         TEXT NOT NULL,
+                oauth_token_secret  TEXT NOT NULL,
+                screen_name         TEXT NOT NULL,
+                profile_image_url   TEXT NOT NULL,
+                theme               INTEGER NOT NULL,
+                theme_color         INTEGER NOT NULL,
+                page_infos          TEXT NOT NULL
+            )
+            """)
+            onUpgrade(db, 1, DATABASE_VERSION)
+        }
+
+        override fun onUpgrade(db: SQLiteDatabase, oldVersion: Int, newVersion: Int) {
+            if (oldVersion < 1) {
+            }
+        }
+
+        companion object {
+            private val DATABASE_NAME = "main.db"
+            private val DATABASE_VERSION = 1
+        }
     }
+
 }