3B8frmYT

1package com.example.arch.todo;
2
3public class DbOpenHelper extends SQLiteOpenHelper {
4
5    private static final String TAG = "DtabaseConnectHelper";
6    private static final String DATABASE_NAME = "";
7    private static final String TODO_TABLE_NAME = "mst_todo";
8    private static final int DATABASE_VERSION = 1;
9
10    public DbOpenHelper(Context context){
11        super(context, DATABASE_NAME, null, DATABASE_VERSION);
12    }
13
14    @Override
15    public void onCreate(SQLiteDatabase db){
16        createToDoTable(db);
17    }
18    /*
19    * Update ToDo Table
20    * This method execute when application was upgraded
21    * Change the database configuration
22    * */
23    @Override
24    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
25        db.execSQL("DROP TABLE IF EXISTS " + TODO_TABLE_NAME + ";");
26        onCreate(db);
27
28    }
29    /*
30    * Initialize process create ToDo Table
31    * */
32    private void createToDoTable(SQLiteDatabase db){
33        String sql = "CREATE TABLE mst_todo ( "
34                + " id int(11) NOT NULL COMMENT'Tasku ID' AUTO_INCREMENT, "
35                + "Title text NOT NULL COMMENT"Title", "
36                + "created_at timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT"Create Time", "
37                + "update_at timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT"Update Time", "
38                + "delflg tinyint(3) NOT NULL DEFAULT 0 COMMENT"Delete Flagg", "
39                + "PRIMARY KEY (id); ";
40        db.execSQL(sql);
41        Log.i(TAG,"Created mst_todo table");
42    }
43}