//设置package包名称以及导入依赖的类
package com.nullpointerbay.dbtest

import android.content.Context
import android.database.sqlite.{SQLiteDatabase, SQLiteOpenHelper}
import com.fortysevendeg.mvessel.AndroidDriver
import slick.driver.SQLiteDriver.api._
import SlickDatabaseHelper._

class SlickDatabaseHelper(context: Context)
  extends SQLiteOpenHelper(context, databaseName, null, databaseVersion)
    with SlickDatabaseConfig {

  val driverName = "com.fortysevendeg.mvessel.AndroidDriver"


  lazy val database = {
    val sqliteDatabase = getReadableDatabase
    AndroidDriver.register()
    Database.forURL(
      url = "jdbc:sqlite:" + sqliteDatabase.getPath,
      driver = driverName)
  }

  override def onCreate(sqliteDatabase: SQLiteDatabase): Unit = {
    todoTable.schema.create.statements foreach sqliteDatabase.execSQL
  }

  override def onUpgrade(db: SQLiteDatabase, oldVersion: Int, newVersion: Int): Unit =
    throw new IllegalStateException("Can't make an upgrade")
}

object SlickDatabaseHelper {

  val databaseName = "slick.db"

  val databaseVersion = 1

} 

//设置package包名称以及导入依赖的类
package com.rainm.scanote.db

import android.content.Context
import android.database.sqlite.{SQLiteDatabase, SQLiteOpenHelper}
import com.rainm.scanote.model.SimpleNote


object DBHelper {
  val DB_VERSION = 0x1
  var DB_NAME = "action_note_db"

  def setDbName(dbName: String): Unit = {
    DB_NAME = dbName
  }
}

class DBHelper(context: Context)
  extends SQLiteOpenHelper(context, DBHelper.DB_NAME, null, DBHelper.DB_VERSION) {

  override def onUpgrade(db: SQLiteDatabase, oldVersion: Int, newVersion: Int): Unit = {
    //TODO: add upgrade code here.
  }

  override def onCreate(db: SQLiteDatabase): Unit = {
    db.execSQL("CREATE TABLE IF NOT EXISTS " + SimpleNote.TABLE_NAME + SimpleNote.DDL)
  }
}