private void saveNewShopToDatabase() { Uri table = FireworkProvider.SHOPS; ContentValues values = new ContentValues(1); values.put(FireworkProvider.COL_SHOP_NAME, "MyNewShop" + System.currentTimeMillis()); values.put(FireworkProvider.COL_SHOP_POSTCODE, "LN11YA"); getActivity().getContentResolver().insert(table, values); }
/** * See /assets/migrations/1_SETUP.SQL for the database creation */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); /** * You can save multiple ways - this is just an example of using Uri's * do not normally do this on the UI Thread */ saveNewShopToDatabase(); /** * You can retrieve from the database multiple ways - this is just an example of using Uri's */ retrieveShopsFromDatabase(); }
/** * See /assets/migrations/1_SETUP.SQL for the database creation */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); /** * You can save multiple ways - this is just an example of using Uri's * do not normally do this on the UI Thread */ saveNewShopToDatabase(); /** * You can retrieve from the database multiple ways - this is just an example of using Uri's */ retrieveShopsFromDatabase(); }
private void retrieveShopsFromDatabase() { getActivity().getSupportLoaderManager() .initLoader(R.id.loader_shop, null, new LoaderManager.LoaderCallbacks<Cursor>() { @Override public Loader<Cursor> onCreateLoader(int i, Bundle bundle) { return new ShopCursorLoader(getActivity()); } @Override public void onLoadFinished(Loader<Cursor> cursorLoader, Cursor cursor) { if (!cursor.moveToFirst()) { Log.d("demo", "Nothing in DB, returning early"); return; } do { String shopName = cursor.getString(cursor.getColumnIndex("name")); String shopPostcode = cursor.getString(cursor.getColumnIndex("postcode")); Log.d("demo", "Found shop: " + shopName); Log.d("demo", "Found postcode: " + shopPostcode); } while (cursor.moveToNext()); } @Override public void onLoaderReset(Loader<Cursor> cursorLoader) { } }); }
private void saveNewShopToDatabase() { ContentValues values = new ContentValues(1); DB.Shop.setName("MyNewShop" + System.currentTimeMillis(), values); DB.Shop.setPostcode("LN11YA", values); getActivity().getContentResolver().insert(FireworkProvider.SHOPS, values); }
private void retrieveShopsFromDatabase() { getActivity().getLoaderManager() .initLoader(R.id.loader_shop, null, new LoaderManager.LoaderCallbacks<Cursor>() { @Override public Loader<Cursor> onCreateLoader(int i, Bundle bundle) { return new ShopCursorLoader(getActivity()); } @Override public void onLoadFinished(Loader<Cursor> cursorLoader, Cursor cursor) { if (!cursor.moveToFirst()) { Log.d("demo", "Nothing in DB, returning early"); } do { Log.d("demo", "Found shop: " + DB.Shop.getName(cursor)); Log.d("demo", "Found postcode: " + DB.Shop.getPostcode(cursor)); } while (cursor.moveToNext()); } @Override public void onLoaderReset(Loader<Cursor> cursorLoader) { } }); }