VMCVHn0g

1object TableInfo : BaseColumns {
2    //Opis tabeli
3    const val TABLE_NAME = "Notes"
4    const val TABLE_COLUMN_ACTIVITY = "name"
5    const val TABLE_COLUMN_START ="start"
6    const val TABLE_COLUMN_END = "end"
7    const val TABLE_COLUMN_INFORMATION = "informations"
8    const val TABLE_COLUMN_DATE = "date"
9}
10    //Podstawowe komendy SQL
11object BasicComand{
12    const val SQL_CREATE_TABLE =
13        "CREATE TABLE ${TableInfo.TABLE_NAME} (" +
14                "${BaseColumns._ID} INTEGER PRIMARY KEY,"+
15                "${TableInfo.TABLE_COLUMN_ACTIVITY} TEXT NOT NULL," +
16                "${TableInfo.TABLE_COLUMN_START} TEXT NOT NULL," +
17                "${TableInfo.TABLE_COLUMN_END} TEXT NOT NULL," +
18                "${TableInfo.TABLE_COLUMN_INFORMATION} TEXT NOT NULL,"+
19                "${TableInfo.TABLE_COLUMN_DATE} 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,2){
25    override fun onCreate(db: SQLiteDatabase?) {
26        db?.execSQL(BasicComand.SQL_CREATE_TABLE)
27
28    }
29
30    override fun onUpgrade(db: SQLiteDatabase?, p1: Int, p2: Int) {
31        db?.execSQL(BasicComand.SQL_DELETE_TABLE)
32        onCreate(db)
33    }
34
35
36}