DbOpenHelperFood.java

package com.andreww.hale;

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

public class DbOpenHelperFood extends SQLiteOpenHelper {


    private static final String DATABASE_NAME = "hale.db";
    private static final int DATABASE_VERSION = 5;

    public static final String TABLE_FOOD = "food_entries";
    public static final String ROWID = "_id";

    private SQLiteDatabase mDatabase;

    private static final String TABLE_FOOD_CREATE = "CREATE TABLE " + TABLE_FOOD + "(" +
            ROWID + " integer PRIMARY KEY autoincrement," +
            "food TEXT," +
            "calories INTEGER," +
            "protein INTEGER," +
            "sugar INTEGER," +
            "date INTEGER," +
            "water INTEGER);";

    public DbOpenHelperFood(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
        mDatabase = this.getWritableDatabase();
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(TABLE_FOOD_CREATE);

    }

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

    public Cursor getAllData () {

        String mGetData = "SELECT * FROM " + TABLE_FOOD;
        return mDatabase.rawQuery(mGetData, null);

    }

}