List of usage examples for android.support.v4.content CursorLoader setSelection
public void setSelection(String selection)
From source file:com.amsterdam.marktbureau.makkelijkemarkt.VervangerDialogActivity.java
/** * Load the koopman(nen) that the selected vervanger can work for * @param id//from www.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.amsterdam.marktbureau.makkelijkemarkt.DrawerFragment.java
/** * Create a loader to get the total amount of dagvergunnigen for today * @param id/*from ww w. j a v a2 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.NotitiesFragment.java
/** * Get the non-removed notities for selected markt and dag * @param id//from www . j a va2 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 o m*/ * @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: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 va2 s . 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:com.amsterdam.marktbureau.makkelijkemarkt.DagvergunningFragmentOverzicht.java
/** * Create the cursor loader that will load the koopman from the database *//*from w w w . j a v a 2s . com*/ @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: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 w w . j a v a 2 s .c om // 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:ca.marklauman.dominionpicker.MarketActivity.java
@Override public Loader<Cursor> onCreateLoader(int id, Bundle args) { CursorLoader c = new CursorLoader(this); c.setUri(CardList.URI);/* w w w. ja v a 2 s . 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.DagvergunningFragmentKoopman.java
/** * Create the cursor loader that will load the koopman from the database */// w w w . ja v a 2 s . com @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.ScDefaultContactListAdapter.java
@Override public void configureLoader(CursorLoader loader, long directoryId) { if (loader instanceof ProfileAndContactsLoader) { ((ProfileAndContactsLoader) loader).setLoadProfile(shouldIncludeProfile()); }//from w w w.ja v a 2 s. c o m ContactListFilter filter = getFilter(); if (isSearchMode()) { String query = getQueryString(); if (query == null) { query = ""; } query = query.trim(); if (TextUtils.isEmpty(query)) { // Regardless of the directory, we don't want anything returned, // so let's just send a "nothing" query to the local directory. loader.setUri(RawContacts.CONTENT_URI); loader.setProjection(getProjection(false)); loader.setSelection("0"); } else { Builder builder = RawContacts.CONTENT_FILTER_URI.buildUpon(); builder.appendPath(query); // Builder will encode the query builder.appendQueryParameter(ScContactsContract.DIRECTORY_PARAM_KEY, String.valueOf(directoryId)); if (directoryId != Directory.DEFAULT && directoryId != Directory.LOCAL_INVISIBLE) { builder.appendQueryParameter(ScContactsContract.LIMIT_PARAM_KEY, String.valueOf(getDirectoryResultLimit())); } builder.appendQueryParameter(SearchSnippetColumns.SNIPPET_ARGS_PARAM_KEY, SNIPPET_ARGS); builder.appendQueryParameter(SearchSnippetColumns.DEFERRED_SNIPPETING_KEY, "1"); loader.setUri(builder.build()); loader.setProjection(getProjection(true)); } } else { configureUri(loader, directoryId, filter); loader.setProjection(getProjection(false)); configureSelection(loader, directoryId, filter); } String sortOrder; if (getSortOrder() == ScContactsContract.Preferences.SORT_ORDER_PRIMARY) { sortOrder = RawContacts.SORT_KEY_PRIMARY; } else { sortOrder = RawContacts.SORT_KEY_ALTERNATIVE; } loader.setSortOrder(sortOrder); }