vMpL8LPF

1package com.example.android.randomrhyme.data;
2
3        import android.content.Context;
4        import android.database.sqlite.SQLiteDatabase;
5        import android.database.sqlite.SQLiteOpenHelper;
6
7public class PoemsDbHelper extends SQLiteOpenHelper{
8
9    private static final String DATABASE_NAME = "favorite_poems.db";
10
11    private static final int DATABASE_VERSION = 1;
12
13    public PoemsDbHelper (Context context) {
14        super(context, DATABASE_NAME, null, DATABASE_VERSION );
15    }
16
17    @Override
18    public void onCreate(SQLiteDatabase sqLiteDatabase) {
19        final String SQL_CREATE_POEMS_TABLE = "CREATE TABLE " + PoemsContract.PoemEntry.TABLE_NAME + " (" +
20                PoemsContract.PoemEntry._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
21                PoemsContract.PoemEntry.COLUMN_POEM_BODY_TEXT + " TEXT NOT NULL, " +
22                PoemsContract.PoemEntry.COLUMN_AUTHOR + " TEXT NOT NULL, " +
23                PoemsContract.PoemEntry.COLUMN_POEM_TITLE + " TEXT NOT NULL " +
24                "); ";
25
26        sqLiteDatabase.execSQL(SQL_CREATE_POEMS_TABLE);
27    }
28
29
30
31    @Override
32    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int oldVersion, int newVersion) {
33        sqLiteDatabase.execSQL("DROP TABLE IF EXISTS " + PoemsContract.PoemEntry.TABLE_NAME);
34        onCreate(sqLiteDatabase);
35    }
36
37    //public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1)
38}