DatabaseHelper.java

package com.zendev.movieapp.database;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseHelper extends SQLiteOpenHelper {

    public static String DATABASE_NAME = "dbmovies";

    private static final int DATABASE_VERSION = 1;

    private static final String SQL_CREATE_TABLE_MOVIES = String.format("CREATE TABLE %s"
                    + " (%s INTEGER PRIMARY KEY," +
                    " %s TEXT NOT NULL," +
                    " %s TEXT NOT NULL," +
                    " %s TEXT NOT NULL," +
                    " %s TEXT NOT NULL," +
                    " %s TEXT NOT NULL," +
                    " %s TEXT NOT NULL," +
                    " %s TEXT NOT NULL)",
            DatabaseMovieContract.TABLE_MOVIES,
            DatabaseMovieContract.MoviesColumns._ID,
            DatabaseMovieContract.MoviesColumns.TITLE,
            DatabaseMovieContract.MoviesColumns.RELEASE_DATE,
            DatabaseMovieContract.MoviesColumns.OVERVIEW,
            DatabaseMovieContract.MoviesColumns.LANGUAGE,
            DatabaseMovieContract.MoviesColumns.POSTER,
            DatabaseMovieContract.MoviesColumns.RATING,
            DatabaseMovieContract.MoviesColumns.POPULARITY
    );

    private static final String SQL_CREATE_TABLE_TVSHOW = String.format("CREATE TABLE %s"
                    + " (%s INTEGER PRIMARY KEY," +
                    " %s TEXT NOT NULL," +
                    " %s TEXT NOT NULL," +
                    " %s TEXT NOT NULL," +
                    " %s TEXT NOT NULL," +
                    " %s TEXT NOT NULL," +
                    " %s TEXT NOT NULL," +
                    " %s TEXT NOT NULL)",
            DatabaseTvShowContract.TABLE_TVSHOW,
            DatabaseTvShowContract.TvShowColumns._ID,
            DatabaseTvShowContract.TvShowColumns.NAME,
            DatabaseTvShowContract.TvShowColumns.RELEASE_DATE,
            DatabaseTvShowContract.TvShowColumns.OVERVIEW,
            DatabaseTvShowContract.TvShowColumns.LANGUAGE,
            DatabaseTvShowContract.TvShowColumns.POSTER,
            DatabaseTvShowContract.TvShowColumns.RATING,
            DatabaseTvShowContract.TvShowColumns.POPULARITY
    );

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(SQL_CREATE_TABLE_MOVIES);
        db.execSQL(SQL_CREATE_TABLE_TVSHOW);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + DatabaseMovieContract.TABLE_MOVIES);
        db.execSQL("DROP TABLE IF EXISTS " + DatabaseTvShowContract.TABLE_TVSHOW);
        onCreate(db);
    }
}