List of usage examples for android.support.v4.content CursorLoader setSelectionArgs
public void setSelectionArgs(String[] selectionArgs)
From source file:com.amsterdam.marktbureau.makkelijkemarkt.VervangerDialogActivity.java
/** * Load the koopman(nen) that the selected vervanger can work for * @param id/*w ww.j a v a 2 s . c o m*/ * @param args * @return */ @Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { CursorLoader loader = new CursorLoader(this); loader.setUri(MakkelijkeMarktProvider.mUriVervangerJoined); loader.setSelection(MakkelijkeMarktProvider.mTableVervanger + "." + MakkelijkeMarktProvider.Vervanger.COL_VERVANGER_ID + " = ? "); loader.setSelectionArgs(new String[] { String.valueOf(mVervangerId) }); return loader; }
From source file:com.readystatesoftware.chuck.internal.ui.TransactionListFragment.java
@Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { CursorLoader loader = new CursorLoader(getContext()); loader.setUri(ChuckContentProvider.TRANSACTION_URI); if (!TextUtils.isEmpty(currentFilter)) { if (TextUtils.isDigitsOnly(currentFilter)) { loader.setSelection("responseCode LIKE ?"); loader.setSelectionArgs(new String[] { currentFilter + "%" }); } else {//from ww w .j a v a 2s. c om loader.setSelection("path LIKE ?"); loader.setSelectionArgs(new String[] { "%" + currentFilter + "%" }); } } loader.setProjection(HttpTransaction.PARTIAL_PROJECTION); loader.setSortOrder("requestDate DESC"); return loader; }
From source file:ca.marklauman.dominionpicker.MarketActivity.java
@Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { CursorLoader c = new CursorLoader(this); c.setUri(CardList.URI);/* w ww .j a v a 2s. c o m*/ String[] strChoices = new String[choices.length]; for (int i = 0; i < choices.length; i++) strChoices[i] = "" + choices[i]; c.setSelectionArgs(strChoices); String selection = ""; for (long ignored : choices) selection += " OR " + CardList._ID + "=?"; c.setSelection(selection.substring(4)); return c; }
From source file:com.amsterdam.marktbureau.makkelijkemarkt.DrawerFragment.java
/** * Create a loader to get the total amount of dagvergunnigen for today * @param id/*from www . ja v a 2 s . c o m*/ * @param args * @return */ @Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { // get the id of selected markt from the shared preferences SharedPreferences settings = PreferenceManager.getDefaultSharedPreferences(getContext()); int marktId = settings.getInt(getContext().getString(R.string.sharedpreferences_key_markt_id), 0); // get the date of today for the dag param SimpleDateFormat dagSdf = new SimpleDateFormat(getString(R.string.date_format_dag)); String dag = dagSdf.format(new Date()); // create the loader CursorLoader loader = new CursorLoader(getActivity()); loader.setUri(MakkelijkeMarktProvider.mUriDagvergunning); loader.setSelection(MakkelijkeMarktProvider.Dagvergunning.COL_MARKT_ID + " = ? AND " + MakkelijkeMarktProvider.Dagvergunning.COL_DAG + " = ? "); loader.setSelectionArgs(new String[] { String.valueOf(marktId), dag }); return loader; }
From source file:com.amsterdam.marktbureau.makkelijkemarkt.DagvergunningFragmentOverzicht.java
/** * Create the cursor loader that will load the koopman from the database */// w ww . j a v a2 s .c om @Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { // load the koopman with given id if (mKoopmanId != -1) { CursorLoader loader = new CursorLoader(getActivity()); loader.setUri(MakkelijkeMarktProvider.mUriKoopmanJoined); loader.setSelection( MakkelijkeMarktProvider.mTableKoopman + "." + MakkelijkeMarktProvider.Koopman.COL_ID + " = ? "); loader.setSelectionArgs(new String[] { String.valueOf(mKoopmanId), }); return loader; } return null; }
From source file:com.amsterdam.marktbureau.makkelijkemarkt.NotitiesFragment.java
/** * Get the non-removed notities for selected markt and dag * @param id// ww w . ja v a2 s. c o m * @param args * @return */ @Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { // create the loader that will load the notities with joined table data for selected // markt for today sorted descending on aanmaak tijd CursorLoader loader = new CursorLoader(getActivity()); loader.setUri(MakkelijkeMarktProvider.mUriNotitie); loader.setSelection(MakkelijkeMarktProvider.Notitie.COL_VERWIJDERD + " = ? AND " + MakkelijkeMarktProvider.Notitie.COL_MARKT_ID + " = ? AND " + MakkelijkeMarktProvider.Notitie.COL_DAG + " = ?"); loader.setSelectionArgs( new String[] { "0", args.getString(getString(R.string.sharedpreferences_key_markt_id), null), args.getString(getString(R.string.sharedpreferences_key_date_today), "") }); loader.setSortOrder(MakkelijkeMarktProvider.Notitie.COL_AANGEMAAKT_DATUMTIJD + " DESC"); return loader; }
From source file:com.amsterdam.marktbureau.makkelijkemarkt.DagvergunningenFragment.java
/** * Create a cursor loader to get the dagvergunningen from the db * @param id unique id for this loader/*from w ww . j a v a 2 s . c om*/ * @param args the markt id and dag arguments for setting the selection * @return a cursor loader ready to be started */ @Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { // create the loader that will load the dagvergunningen with joined table data for selected // markt for today sorted descending on aanmaak tijd CursorLoader loader = new CursorLoader(getActivity()); loader.setUri(MakkelijkeMarktProvider.mUriDagvergunningJoined); loader.setSelection(MakkelijkeMarktProvider.mTableDagvergunning + "." + MakkelijkeMarktProvider.Dagvergunning.COL_MARKT_ID + " = ? AND " + MakkelijkeMarktProvider.Dagvergunning.COL_DAG + " = ?"); loader.setSelectionArgs( new String[] { args.getString(getString(R.string.sharedpreferences_key_markt_id), null), args.getString(getString(R.string.sharedpreferences_key_date_today), "") }); loader.setSortOrder(MakkelijkeMarktProvider.Dagvergunning.COL_AANMAAK_DATUMTIJD + " DESC"); return loader; }
From source file:ca.marklauman.dominionpicker.SupplyActivity.java
@Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { // Display the loading icon, hide the resources resView.setVisibility(View.GONE); adapter.changeCursor(null);/*from w ww . ja va2 s.co m*/ // Basic loader CursorLoader c = new CursorLoader(this); c.setUri(CardList.URI); // Selection string (sql WHERE clause) String sel = ""; for (long ignored : supply.cards) sel += " OR " + CardList._ID + "=?"; sel = sel.substring(4); c.setSelection(sel); // Selection arguments (the numbers) String[] selArgs = new String[supply.cards.length]; for (int i = 0; i < supply.cards.length; i++) selArgs[i] = "" + supply.cards[i]; c.setSelectionArgs(selArgs); return c; }
From source file:com.amsterdam.marktbureau.makkelijkemarkt.DagvergunningFragmentKoopman.java
/** * Create the cursor loader that will load the koopman from the database */// w ww . j a va 2 s . co m @Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { // load the koopman with given id in the arguments bundle and where doorgehaald is false if (mKoopmanId != -1) { CursorLoader loader = new CursorLoader(getActivity()); loader.setUri(MakkelijkeMarktProvider.mUriKoopmanJoined); loader.setSelection( MakkelijkeMarktProvider.mTableKoopman + "." + MakkelijkeMarktProvider.Koopman.COL_ID + " = ? "); loader.setSelectionArgs(new String[] { String.valueOf(mKoopmanId) }); return loader; } return null; }
From source file:com.silentcircle.contacts.list.PhoneNumberListAdapter.java
/** * Configure {@code loader} and {@code uriBuilder} according to {@code directoryId} and {@code * filter}./* w w w . ja v a 2 s. co m*/ */ private void applyFilter(CursorLoader loader, Uri.Builder uriBuilder, long directoryId, ContactListFilter filter) { if (filter == null || directoryId != Directory.DEFAULT) { return; } final StringBuilder selection = new StringBuilder(); final List<String> selectionArgs = new ArrayList<String>(); switch (filter.filterType) { // case ContactListFilter.FILTER_TYPE_CUSTOM: { // selection.append(RawContacts.IN_VISIBLE_GROUP + "=1"); // selection.append(" AND " + RawContacts.HAS_PHONE_NUMBER + "=1"); // break; // } case ContactListFilter.FILTER_TYPE_ACCOUNT: { filter.addAccountQueryParameterToUrl(uriBuilder); break; } // case ContactListFilter.FILTER_TYPE_ALL_ACCOUNTS: case ContactListFilter.FILTER_TYPE_DEFAULT: break; // No selection needed. case ContactListFilter.FILTER_TYPE_WITH_PHONE_NUMBERS_ONLY: break; // This adapter is always "phone only", so no selection needed either. default: Log.w(TAG, "Unsupported filter type came " + "(type: " + filter.filterType + ", toString: " + filter + ")" + " showing all contacts."); // No selection. break; } loader.setSelection(selection.toString()); loader.setSelectionArgs(selectionArgs.toArray(new String[0])); }