Android Open Source - openhds-tablet Queries

From Project

Back to project page openhds-tablet.
License

The source code is released under:
OPENHDS PLATFORM OPENSOURCE LICENSE AGREEMENT Copyright (c) 2013 University of Southern Maine. All rights reserved. Redistribution and use in source and binary forms, with or without mo...
If you think the Android project openhds-tablet listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
Java Source Code

package org.openhds.mobile;
//from   w ww.j a  va 2  s.  c  om
import android.content.ContentResolver;
import android.database.Cursor;
import android.net.Uri;

/**
 * Centralized location to put queries on data to reduce duplication
 */
public class Queries {

    private Queries() {
    }

    public static boolean individualByExtId(ContentResolver resolver, String extId) {
        return queryForSingleRow(resolver, OpenHDS.Individuals.CONTENT_ID_URI_BASE,
                OpenHDS.Individuals.COLUMN_INDIVIDUAL_EXTID, extId);
    }

    private static boolean queryForSingleRow(ContentResolver resolver, Uri uri, String column, String value) {
        Cursor cursor = getCursor(resolver, uri, column, value);
        return isFound(cursor);
    }

    private static Cursor getCursor(ContentResolver resolver, Uri uri, String column, String value) {
        return resolver.query(uri, null, column + " = ?", new String[] { value }, null);
    }

    public static Cursor getIndividualByExtId(ContentResolver resolver, String extId) {
        return getCursor(resolver, OpenHDS.Individuals.CONTENT_ID_URI_BASE,
                OpenHDS.Individuals.COLUMN_INDIVIDUAL_EXTID, extId);
    }

    public static Cursor getIndividualsByResidency(ContentResolver resolver, String extId) {
        return getCursor(resolver, OpenHDS.Individuals.CONTENT_ID_URI_BASE,
                OpenHDS.Individuals.COLUMN_INDIVIDUAL_RESIDENCE, extId);
    }

    private static boolean isFound(Cursor cursor) {
        boolean found = false;
        if (cursor != null) {
            found = cursor.moveToFirst();
            cursor.close();
        }

        return found;
    }

    public static boolean hasLocationByExtId(ContentResolver resolver, String temp) {
        return queryForSingleRow(resolver, OpenHDS.Locations.CONTENT_ID_URI_BASE,
                OpenHDS.Locations.COLUMN_LOCATION_EXTID, temp);
    }

    public static Cursor getLocationByExtId(ContentResolver resolver, String extId) {
        return getCursor(resolver, OpenHDS.Locations.CONTENT_ID_URI_BASE, OpenHDS.Locations.COLUMN_LOCATION_EXTID,
                extId);
    }

    public static Cursor getLocationsByHierachy(ContentResolver resolver, String extId) {
        return getCursor(resolver, OpenHDS.Locations.CONTENT_ID_URI_BASE, OpenHDS.Locations.COLUMN_LOCATION_HIERARCHY,
                extId);
    }

    public static Cursor getHierarchyByExtId(ContentResolver contentResolver, String hierarchy) {
        return getCursor(contentResolver, OpenHDS.HierarchyItems.CONTENT_ID_URI_BASE,
                OpenHDS.HierarchyItems.COLUMN_HIERARCHY_EXTID, hierarchy);
    }

    public static Cursor getHierarchysByLevel(ContentResolver contentResolver, String hierarchyTopLevel) {
        return getCursor(contentResolver, OpenHDS.HierarchyItems.CONTENT_ID_URI_BASE,
                OpenHDS.HierarchyItems.COLUMN_HIERARCHY_LEVEL, hierarchyTopLevel);
    }

    public static Cursor getHierarchysByParent(ContentResolver contentResolver, String extId) {
        return getCursor(contentResolver, OpenHDS.HierarchyItems.CONTENT_ID_URI_BASE,
                OpenHDS.HierarchyItems.COLUMN_HIERARCHY_PARENT, extId);
    }

    public static boolean hasFieldWorker(ContentResolver resolver, String extId, String password) {
        Cursor cursor = resolver.query(OpenHDS.FieldWorkers.CONTENT_ID_URI_BASE,
                new String[] { OpenHDS.FieldWorkers.COLUMN_FIELDWORKER_EXTID },
                OpenHDS.FieldWorkers.COLUMN_FIELDWORKER_EXTID + " = ? AND "
                        + OpenHDS.FieldWorkers.COLUMN_FIELDWORKER_PASSWORD + " = ?", new String[] { extId, password },
                null);
        return isFound(cursor);
    }

    public static Cursor getFieldWorkByExtId(ContentResolver resolver, String extId) {
        return getCursor(resolver, OpenHDS.FieldWorkers.CONTENT_ID_URI_BASE,
                OpenHDS.FieldWorkers.COLUMN_FIELDWORKER_EXTID, extId);
    }

    public static boolean hasSocialGroupByExtId(ContentResolver resolver, String temp) {
        return queryForSingleRow(resolver, OpenHDS.SocialGroups.CONTENT_ID_URI_BASE,
                OpenHDS.SocialGroups.COLUMN_SOCIALGROUP_EXTID, temp);
    }

    public static Cursor getSocialGroupByName(ContentResolver resolver, String groupName) {
        return getCursor(resolver, OpenHDS.SocialGroups.CONTENT_ID_URI_BASE,
                OpenHDS.SocialGroups.COLUMN_SOCIALGROUP_GROUPNAME, groupName);
    }

    public static Cursor getSocialGroupsByIndividualExtId(ContentResolver resolver, String extId) {
        Uri uri = OpenHDS.Individuals.CONTENT_SG_URI_BASE.buildUpon().appendPath(extId).build();
        return resolver.query(uri, null, "x." + OpenHDS.IndividualGroups.COLUMN_INDIVIDUALUUID + " = ?",
                new String[] { extId }, "s." + OpenHDS.SocialGroups._ID);
    }

    public static Cursor allSocialGroups(ContentResolver resolver) {
        return resolver.query(OpenHDS.SocialGroups.CONTENT_ID_URI_BASE, null, null, null, null);
    }

    public static Cursor allRounds(ContentResolver contentResolver) {
        return contentResolver.query(OpenHDS.Rounds.CONTENT_ID_URI_BASE, null, null, null, null);
    }

    public static Cursor allLocations(ContentResolver contentResolver) {
        return contentResolver.query(OpenHDS.Locations.CONTENT_ID_URI_BASE, null, null, null, null);
    }

    public static Cursor getRelationshipByIndividualA(ContentResolver resolver, String extId) {
        return getCursor(resolver, OpenHDS.Relationships.CONTENT_ID_URI_BASE,
                OpenHDS.Relationships.COLUMN_RELATIONSHIP_INDIVIDUAL_A, extId);
    }

    public static Cursor getRelationshipByIndividualB(ContentResolver resolver, String extId) {
        return getCursor(resolver, OpenHDS.Relationships.CONTENT_ID_URI_BASE,
                OpenHDS.Relationships.COLUMN_RELATIONSHIP_INDIVIDUAL_B, extId);
    }
}
Java Source Code List
