KbrpB8Rx

1package com.brunonlemanski.shops.database;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6import com.brunonlemanski.shops.database.DbAdapter.*;
7
8public class DbHelper extends SQLiteOpenHelper {
9
10    //------------------------------------------------------ Constants
11    /**
12     * Database name.
13     */
14    public static final String DATABASE_NAME = "shopslist.db";
15
16    /**
17     * Database version.
18     */
19    public static final int DATABASE_VERSION = 1;
20
21
22    //------------------------------------------------------ Constructor
23    /**
24     * Class constructor.
25     * @param context
26     */
27    public DbHelper(Context context) {
28        super(context, DATABASE_NAME, null, DATABASE_VERSION);
29    }
30
31
32    //------------------------------------------------------ Methods
33    /**
34     * Create method - creating table in database.
35     * @param db Your database.
36     */
37    @Override
38    public void onCreate(SQLiteDatabase db) {
39
40        final String SQL_CREATE_SHOPLIST_TABLE = "CREATE TABLE " +
41                DbEntry.TABLE_NAME + " (" +
42                DbEntry._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
43                DbEntry.COLUMN_NAME + " TEXT NOT NULL, " +
44                DbEntry.COLUMN_DESC + " TEXT NOT NULL, " +
45                DbEntry.COLUMN_RADIUS + " TEXT NOT NULL, " +
46                DbEntry.COLUMN_LOCATION + " TEXT NOT NULL, " +
47                DbEntry.COLUMN_TIMESTAMP + " TIMESTAMP DEFAULT CURRENT_TIMESTAMP" +
48                ");";
49
50        db.execSQL(SQL_CREATE_SHOPLIST_TABLE);
51    }
52
53    /**
54     * Update method - updating line in database.
55     * @param db Your database.
56     * @param oldVersion Database before changes.
57     * @param newVersion Database after changes.
58     */
59    @Override
60    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
61
62        db.execSQL("DROP TABLE IF EXISTS " + DbEntry.TABLE_NAME);
63        onCreate(db);
64    }
65}