vGYAAPcD

1package com.example.moviecatalogue.dbmovie.movie;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7import com.example.moviecatalogue.dbmovie.movie.DbContractMovie;
8
9public class DatabaseMovieHelper extends SQLiteOpenHelper {
10
11    private static final String DATABASE = DbContractMovie.DB;
12    private static final int DATABASE_VERSION = 1;
13
14
15    public DatabaseMovieHelper(Context context) {
16        super(context,DATABASE,null,DATABASE_VERSION );
17        SQLiteDatabase database =getWritableDatabase();
18        onCreate(database);
19    }
20    private static final String CREATE_TABLE_MOVIE ="CREATE TABLE IF NOT EXISTS " + DbContractMovie.DataEntry.TABLE_NAME_MOVIE + " (" +
21            DbContractMovie.DataEntry._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
22            DbContractMovie.DataEntry.COLUMN_MOVIE_ID + " INTEGER NOT NULL," +
23            DbContractMovie.DataEntry.COLUMN_VOTE_COUNT_MOVIE + " INTEGER NOT NULL," +
24            DbContractMovie.DataEntry.COLUMN_VOTE_AVERAGE_MOVIE + " DOUBLE NOT NULL," +
25            DbContractMovie.DataEntry.COLUMN_TITLE_MOVIE + " TEXT NOT NULL," +
26            DbContractMovie.DataEntry.COLUMN_POPULARITY_MOVIE + " DOUBLE NOT NULL," +
27            DbContractMovie.DataEntry.COLUMN_POSTER_PATH_MOVIE + " TEXT NOT NULL," +
28            DbContractMovie.DataEntry.COLUMN_BACKDROP_PATH_MOVIE + " TEXT NOT NULL," +
29            DbContractMovie.DataEntry.COLUMN_ORIGINAL_TITLE_MOVIE + " TEXT NOT NULL," +
30            DbContractMovie.DataEntry.COLUMN_OVERVIEW_MOVIE + " TEXT NOT NULL," +
31            DbContractMovie.DataEntry.COLUMN_RELEASE_DATE_MOVIE + " TEXT NOT NULL);";
32
33
34    @Override
35    public void onCreate(SQLiteDatabase sqLiteDatabase) {
36        try {
37            sqLiteDatabase.execSQL(CREATE_TABLE_MOVIE);
38        }catch (Exception e){
39            e.printStackTrace();
40        }
41    }
42
43    @Override
44    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
45        String sql_drop_table_movie = "DROP TABLE IF EXISTS " + DbContractMovie.DataEntry.TABLE_NAME_MOVIE;
46        sqLiteDatabase.execSQL(sql_drop_table_movie);
47        onCreate(sqLiteDatabase);
48    }
49}