-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathHelperClass.java
32 lines (26 loc) · 1.22 KB
/
HelperClass.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
package com.example.codelist;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import androidx.annotation.Nullable;
public class HelperClass extends SQLiteOpenHelper {
public static final String DATABASE_NAME = "codelist.db";
public static final int DATABASE_VERSION = 1;
public HelperClass(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
String CREATE_TABLE = "CREATE TABLE " +
IdentifiersClass.Collection.TABLE_NAME + " (" +
IdentifiersClass.Collection._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
IdentifiersClass.Collection.COLUMN_NAME + " TEXT NOT NULL, " +
IdentifiersClass.Collection.TIMESTAMP + " TIMESTAMP DEFAULT CURRENT_TIMESTAMP" + ");";
sqLiteDatabase.execSQL(CREATE_TABLE);
}
@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
sqLiteDatabase.execSQL("DROP TABLE IF EXISTS " + IdentifiersClass.Collection.TABLE_NAME);
onCreate(sqLiteDatabase);
}
}