MVs4cWRU

1package com.example.movieapi4;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7
8public class SqliteHelper extends SQLiteOpenHelper {
9    private static final String DATABASE_NAME = "catalogue_movie";
10    private static final int DATABASE_VERSION = 1;
11
12    public SqliteHelper(Context context) {
13        super(context, DATABASE_NAME, null, DATABASE_VERSION);
14        // TODO Auto-generated constructor stub
15    }
16    private static final String CREATE_TABLE_MOVIE = "CREATE TABLE favorite_movie (id_fav INTEGER PRIMARY KEY NOT NULL, title TEXT," +
17            "backdrop TEXT, poster TEXT, release_date TEXT, vote REAL, overview TEXT )";
18
19
20    @Override
21    public void onCreate(SQLiteDatabase db) {
22        // TODO Auto-generated method stub
23//        db.execSQL(
24//                "CREATE TABLE prodi (prodi_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, nama_prodi TEXT," +
25//                        "deskripsi_prodi TEXT );"
26//        );
27        db.execSQL(CREATE_TABLE_MOVIE);
28    }
29
30
31    @Override
32    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
33        // TODO Auto-generated method stub
34        // Drop older table if existed
35        db.execSQL("DROP TABLE IF EXISTS favorite_movie");
36
37    }
38}