Advertisement
andoird213

Hale - Content Provider Test

Apr 2nd, 2013
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.18 KB | None | 0 0
  1. package com.andreww.hale;
  2.  
  3. import android.content.ContentProvider;
  4. import android.content.ContentValues;
  5. import android.database.Cursor;
  6. import android.database.sqlite.SQLiteDatabase;
  7. import android.database.sqlite.SQLiteOpenHelper;
  8. import android.net.Uri;
  9. import android.util.Log;
  10.  
  11.  
  12. public class FoodEntryProvider extends ContentProvider {
  13.  
  14.     private SQLiteOpenHelper mOpenHelper;
  15.     private static final String DBNAME = "hale";
  16.     private static final String TABLE_FOOD = "food_entries";
  17.     private SQLiteDatabase db;
  18.    
  19.     @Override
  20.     public boolean onCreate() {
  21.         mOpenHelper = new SQLiteOpenHelper(getContext(), DBNAME, null, Hale.DATABASE_VERSION) {
  22.             @Override
  23.             public void onCreate(SQLiteDatabase db) { }
  24.             @Override
  25.             public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  26.                 if(newVersion <= oldVersion) {
  27.                     return;
  28.                 }
  29.                 Log.i("FoodEntryProvider", "Upgrading database from version " + oldVersion +
  30.                         " to " + newVersion + ", which will destroy all old data");
  31.                 db.execSQL("DROP TABLE IF EXISTS " + TABLE_FOOD);
  32.             }
  33.         };
  34.         db = mOpenHelper.getWritableDatabase();
  35.         db.execSQL("CREATE TABLE IF NOT EXISTS " + TABLE_FOOD + "(" +
  36.                         "food TEXT," +
  37.                         "calories INTEGER," +
  38.                         "protein INTEGER," +
  39.                         "sugar INTEGER," +
  40.                         "date INTEGER);");
  41.         return true;
  42.     }
  43.  
  44.     @Override
  45.     public String getType(Uri uri) {
  46.         return null;
  47.     }
  48.    
  49.     @Override
  50.     public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
  51.         return db.query(TABLE_FOOD, projection, selection, selectionArgs, null, null, sortOrder);
  52.     }
  53.    
  54.     @Override
  55.     public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) {
  56.         return db.update(TABLE_FOOD, values, selection, selectionArgs);
  57.     }
  58.  
  59.     @Override
  60.     public Uri insert(Uri uri, ContentValues values) {
  61.         db.insert(TABLE_FOOD, null, values);
  62.         return null;
  63.     }
  64.    
  65.     @Override
  66.     public int delete(Uri uri, String selection, String[] selectionArgs) {
  67.         return db.delete(TABLE_FOOD, selection, selectionArgs);
  68.     }
  69. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement