Example usage for android.support.v4.content CursorLoader setSelection

List of usage examples for android.support.v4.content CursorLoader setSelection

Introduction

In this page you can find the example usage for android.support.v4.content CursorLoader setSelection.

Prototype

public void setSelection(String selection) 

Source Link

Usage

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);
}