u8E73zSB

1package com.example.mynotesapp.db
2
3import android.content.Context
4import android.database.sqlite.SQLiteDatabase
5import android.database.sqlite.SQLiteOpenHelper
6import com.example.mynotesapp.db.DatabaseContract.NoteColumns.Companion.TABLE_NAME
7
8internal class DatabaseHelper(context: Context) : SQLiteOpenHelper(context, DATABASE_NAME, null, DATABASE_VERSION) {
9
10    companion object{
11
12        private const val DATABASE_NAME = "dbnoteapp"
13
14        private const val DATABASE_VERSION = 1
15
16        private const val SQL_CREATE_TABLE_NOTE = "CREATE TABLE $TABLE_NAME" +
17                " (${DatabaseContract.NoteColumns._ID} INTEGER PRIMARY KEY AUTOINCREMENT," +
18                " ${DatabaseContract.NoteColumns.TITLE} TEXT NOT NULL," +
19                " ${DatabaseContract.NoteColumns.DESCRIPTION} TEXT NOT NULL," +
20                " ${DatabaseContract.NoteColumns.DATE} TEXT NOT NULL)"
21    }
22
23    override fun onCreate(db: SQLiteDatabase?) {
24        db?.execSQL(SQL_CREATE_TABLE_NOTE)
25    }
26
27    override fun onUpgrade(db: SQLiteDatabase?, oldVersion: Int, newVersion: Int) {
28        db?.execSQL("DROP TABLE IF EXISTS $TABLE_NAME")
29        onCreate(db)
30    }
31}