DbHelper.java

package com.mysite.utilities;

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

import com.mysite.models.Article;
import com.mysite.models.Photo;
import com.mysite.models.Section;

public class DbHelper extends SQLiteOpenHelper
{

    private static final String DATABASE_NAME = "mysite.news.db";
    private static final int DATABASE_VERSION = 29;

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

    @Override
    public void onCreate(SQLiteDatabase database)
    {
        database.execSQL(Article.TABLE_CREATE);
        database.execSQL(Photo.TABLE_CREATE);
        database.execSQL(Section.TABLE_CREATE);
        database.execSQL(Section.POPULATE_TABLE);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
    {
        Log.w(DbHelper.class.getName(),
                "Upgrading database from version " + oldVersion + " to " + newVersion + ", which will destroy all old data");
        db.execSQL("DROP TABLE IF EXISTS " + Article.TABLE);
        db.execSQL("DROP TABLE IF EXISTS " + Photo.TABLE);
        db.execSQL("DROP TABLE IF EXISTS " + Section.TABLE);
        onCreate(db);
    }

}