package com.philosophicalhacker.philhackernews.data.cache;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
/**
*
* Created by MattDupree on 7/18/15.
*/
public class HackerNewsDatabaseOpenHelper extends SQLiteOpenHelper {
public HackerNewsDatabaseOpenHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + HackerNewsData.Items.TABLE_NAME
+ "(" + HackerNewsData.Items._ID + " INTEGER PRIMARY KEY, "
+ HackerNewsData.Items.TYPE + " TEXT, "
+ HackerNewsData.Items.SCORE + " INTEGER, "
+ HackerNewsData.Items.TITLE + " TEXT, "
+ HackerNewsData.Items.AUTHOR + " TEXT, "
+ HackerNewsData.Items.URL + " TEXT, "
+ HackerNewsData.Items.TEXT + " TEXT, "
+ HackerNewsData.Items.COMMENTS + " TEXT, "
+ HackerNewsData.Items.PARENT + " INTEGER, "
+ HackerNewsData.Items.DELETED + " INTEGER)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}