Android Open Source - apps-android-commons Campaigns Content Provider

• Back to App/mirror  ↑

From Project

Back to project page apps-android-commons.

License

The source code is released under:

Apache License

Java Source Code

package org.wikimedia.commons.campaigns;
//  w w  w  .j  a v  a  2 s  . co m
import android.content.ContentProvider;
import android.content.ContentValues;
import android.content.UriMatcher;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteQueryBuilder;
import android.net.Uri;
import android.text.TextUtils;
import android.util.Log;
import org.wikimedia.commons.CommonsApplication;
import org.wikimedia.commons.data.DBOpenHelper;

public class CampaignsContentProvider extends ContentProvider{

    private static final int CAMPAIGNS = 1;
    private static final int CAMPAIGNS_ID = 2;

    public static final String AUTHORITY = "org.wikimedia.commons.campaigns.contentprovider";
    private static final String BASE_PATH = "campiagns";

    public static final Uri BASE_URI = Uri.parse("content://" + AUTHORITY + "/" + BASE_PATH);

    private static final UriMatcher uriMatcher = new UriMatcher(UriMatcher.NO_MATCH);
    static {
        uriMatcher.addURI(AUTHORITY, BASE_PATH, CAMPAIGNS);
        uriMatcher.addURI(AUTHORITY, BASE_PATH + "/#", CAMPAIGNS_ID);
    }


    public static Uri uriForId(int id) {
        return Uri.parse(BASE_URI.toString() + "/" + id);
    }

    private DBOpenHelper dbOpenHelper;
    @Override
    public boolean onCreate() {
        dbOpenHelper = ((CommonsApplication)this.getContext().getApplicationContext()).getDbOpenHelper();
        return false;
    }

    @Override
    public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
        SQLiteQueryBuilder queryBuilder = new SQLiteQueryBuilder();
        queryBuilder.setTables(Campaign.Table.TABLE_NAME);

        int uriType = uriMatcher.match(uri);

        SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
        Cursor cursor;

        switch(uriType) {
            case CAMPAIGNS:
                cursor = queryBuilder.query(db, projection, selection, selectionArgs, null, null, sortOrder);
                break;
            case CAMPAIGNS_ID:
                cursor = queryBuilder.query(db,
                        Campaign.Table.ALL_FIELDS,
                        "_id = ?",
                        new String[] { uri.getLastPathSegment() },
                        null,
                        null,
                        sortOrder
                );
                break;
            default:
                throw new IllegalArgumentException("Unknown URI" + uri);
        }

        cursor.setNotificationUri(getContext().getContentResolver(), uri);

        return cursor;
    }

    @Override
    public String getType(Uri uri) {
        return null;
    }

    @Override
    public Uri insert(Uri uri, ContentValues contentValues) {
        int uriType = uriMatcher.match(uri);
        SQLiteDatabase sqlDB = dbOpenHelper.getWritableDatabase();
        long id = 0;
        switch (uriType) {
            case CAMPAIGNS:
                sqlDB.beginTransaction();
                // if the campaign already exists, rip it out and then re-insert
                if(campaignExists(sqlDB, contentValues)) {
                    sqlDB.delete(
                            Campaign.Table.TABLE_NAME,
                            Campaign.Table.COLUMN_NAME + " = ?",
                            new String[]{contentValues.getAsString(Campaign.Table.COLUMN_NAME)}
                    );
                }
                id = sqlDB.insert(Campaign.Table.TABLE_NAME, null, contentValues);
                sqlDB.endTransaction();
                break;
            default:
                throw new IllegalArgumentException("Unknown URI: " + uri);
        }
        getContext().getContentResolver().notifyChange(uri, null);
        return Uri.parse(BASE_URI + "/" + id);
    }

    @Override
    public int delete(Uri uri, String s, String[] strings) {
        int rows = 0;
        int uriType = uriMatcher.match(uri);

        SQLiteDatabase db = dbOpenHelper.getReadableDatabase();

        switch(uriType) {
            case CAMPAIGNS_ID:
                rows = db.delete(Campaign.Table.TABLE_NAME,
                        "_id = ?",
                        new String[] { uri.getLastPathSegment() }
                );
                break;
            default:
                throw new IllegalArgumentException("Unknown URI" + uri);
        }
        getContext().getContentResolver().notifyChange(uri, null);
        return rows;
    }

    private boolean campaignExists(SQLiteDatabase db, ContentValues campaign) {
        Cursor cr = db.query(
                Campaign.Table.TABLE_NAME,
                new String[]{Campaign.Table.COLUMN_NAME},
                Campaign.Table.COLUMN_NAME + " = ?",
                new String[]{campaign.getAsString(Campaign.Table.COLUMN_NAME)},
                "", "", ""
        );
        return cr != null && cr.getCount() != 0;
    }

    @Override
    public int bulkInsert(Uri uri, ContentValues[] values) {
        Log.d("Commons", "Hello, bulk insert!");
        int uriType = uriMatcher.match(uri);
        SQLiteDatabase sqlDB = dbOpenHelper.getWritableDatabase();
        sqlDB.beginTransaction();
        switch (uriType) {
            case CAMPAIGNS:
                for(ContentValues value: values) {
                    Log.d("Commons", "Inserting! " + value.toString());
                    // if the campaign already exists, rip it out and then re-insert
                    if(campaignExists(sqlDB, value)) {
                        sqlDB.delete(
                                Campaign.Table.TABLE_NAME,
                                Campaign.Table.COLUMN_NAME + " = ?",
                                new String[]{value.getAsString(Campaign.Table.COLUMN_NAME)}
                        );
                    }
                    sqlDB.insert(Campaign.Table.TABLE_NAME, null, value);
                }
                break;
            default:
                throw new IllegalArgumentException("Unknown URI: " + uri);
        }
        sqlDB.setTransactionSuccessful();
        sqlDB.endTransaction();
        getContext().getContentResolver().notifyChange(uri, null);
        return values.length;
    }

    @Override
    public int update(Uri uri, ContentValues contentValues, String selection, String[] selectionArgs) {
        /*
        SQL Injection warnings: First, note that we're not exposing this to the outside world (exported="false")
        Even then, we should make sure to sanitize all user input appropriately. Input that passes through ContentValues
        should be fine. So only issues are those that pass in via concating.

        In here, the only concat created argument is for id. It is cast to an int, and will error out otherwise.
         */
        int uriType = uriMatcher.match(uri);
        SQLiteDatabase sqlDB = dbOpenHelper.getWritableDatabase();
        int rowsUpdated = 0;
        switch (uriType) {
            case CAMPAIGNS:
                rowsUpdated = sqlDB.update(Campaign.Table.TABLE_NAME,
                        contentValues,
                        selection,
                        selectionArgs);
                break;
            case CAMPAIGNS_ID:
                int id = Integer.valueOf(uri.getLastPathSegment());

                if (TextUtils.isEmpty(selection)) {
                    rowsUpdated = sqlDB.update(Campaign.Table.TABLE_NAME,
                            contentValues,
                            Campaign.Table.COLUMN_ID + " = ?",
                            new String[] { String.valueOf(id) } );
                } else {
                    throw new IllegalArgumentException("Parameter `selection` should be empty when updating an ID");
                }
                break;
            default:
                throw new IllegalArgumentException("Unknown URI: " + uri + " with type " + uriType);
        }
        getContext().getContentResolver().notifyChange(uri, null);
        return rowsUpdated;
    }
}

Java Source Code List

• Back to App/mirror  ↑