R6mDtYVY

1package com.example.memokeeper
2
3import android.content.Context
4import android.database.sqlite.SQLiteDatabase
5import android.database.sqlite.SQLiteOpenHelper
6import android.provider.BaseColumns
7
8object TableInfo: BaseColumns {
9    const val TABLE_NAME = "Notes"
10    const val TABLE_COLUMN_TITLE ="title"
11    const val TABLE_COLUMN_MESSAGE = "message"
12}
13
14object BasicCommand{
15    const val SQL_CREATE_TABLE =
16        "CREATE TABLE ${TableInfo.TABLE_NAME} (" +
17                "${BaseColumns._ID} INTEGER PRIMARY KEY" +
18                "${TableInfo.TABLE_COLUMN_TITLE} TEXT NOT NULL" +
19                "${TableInfo.TABLE_COLUMN_MESSAGE} TEXT NOT NULL"
20
21    const val SQL_DELETE_TABLE = "DROP TABLE IF EXISTS ${TableInfo.TABLE_NAME}"
22}
23
24class DataBaseHelper(context: Context): SQLiteOpenHelper(context, TableInfo.TABLE_NAME, null,1){
25    override fun onCreate(db: SQLiteDatabase?) {
26        db?.execSQL(BasicCommand.SQL_CREATE_TABLE)
27    }
28
29    override fun onUpgrade(db: SQLiteDatabase?, oldVersion: Int, newVersion: Int) {
30        db?.execSQL(BasicCommand.SQL_DELETE_TABLE)
31
32            onCreate(db)
33    }
34
35}