Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.andreww.hale;
- import android.content.ContentProvider;
- import android.content.ContentValues;
- import android.database.Cursor;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteOpenHelper;
- import android.net.Uri;
- import android.util.Log;
- public class FoodEntryProvider extends ContentProvider {
- private SQLiteOpenHelper mOpenHelper;
- private static final String DBNAME = "hale";
- private static final String TABLE_FOOD = "food_entries";
- private SQLiteDatabase db;
- @Override
- public boolean onCreate() {
- mOpenHelper = new SQLiteOpenHelper(getContext(), DBNAME, null, Hale.DATABASE_VERSION) {
- @Override
- public void onCreate(SQLiteDatabase db) { }
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- if(newVersion <= oldVersion) {
- return;
- }
- Log.i("FoodEntryProvider", "Upgrading database from version " + oldVersion +
- " to " + newVersion + ", which will destroy all old data");
- db.execSQL("DROP TABLE IF EXISTS " + TABLE_FOOD);
- }
- };
- db = mOpenHelper.getWritableDatabase();
- db.execSQL("CREATE TABLE IF NOT EXISTS " + TABLE_FOOD + "(" +
- "food TEXT," +
- "calories INTEGER," +
- "protein INTEGER," +
- "sugar INTEGER," +
- "date INTEGER);");
- return true;
- }
- @Override
- public String getType(Uri uri) {
- return null;
- }
- @Override
- public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
- return db.query(TABLE_FOOD, projection, selection, selectionArgs, null, null, sortOrder);
- }
- @Override
- public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) {
- return db.update(TABLE_FOOD, values, selection, selectionArgs);
- }
- @Override
- public Uri insert(Uri uri, ContentValues values) {
- db.insert(TABLE_FOOD, null, values);
- return null;
- }
- @Override
- public int delete(Uri uri, String selection, String[] selectionArgs) {
- return db.delete(TABLE_FOOD, selection, selectionArgs);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement