Batch Delete items with Content Provider in Android

Question

I'm trying to batch delete some items in a table.

    String ids = { "1", "2", "3" };

    mContentResolver.delete(uri, MyTables._ID + "=?", ids);

However I keep getting this following error

java.lang.IllegalArgumentException: Too many bind arguments. 3 arguments were provided but the statement needs 1 arguments.

score 21 · Answer 1 · answered Apr 02 '14 at 21:36

You can use ContentProviderOperation for batch deletion/insertion/update in one transaction. It's much nicer you don't have to concatenate strings. It also should be very efficient. For deletion:

    ArrayList<ContentProviderOperation> operations = new ArrayList<ContentProviderOperation>();
    ContentProviderOperation operation;

    for (Item item : items) {

        operation = ContentProviderOperation
                .newDelete(ItemsColumns.CONTENT_URI)
                .withSelection(ItemsColumns.UID + " = ?", new String[]{item.getUid()})
                .build();

        operations.add(operation);
    }

    try {
        contentResolver.applyBatch(Contract.AUTHORITY, operations);
    } catch (RemoteException e) {

    } catch (OperationApplicationException e) {

    }

Correct, I have this query whether `BulkInsert` is faster that `ApplyBatch` — Anuj, Feb 18 '15 at 20:27

score 10 · Accepted Answer · answered Jul 12 '12 at 19:04

10

The error occurs because you have a single placeholder (?) in your where clause, while you pass three arguments. You should do:

String ids = { "1", "2", "3" };

mContentResolver.delete(uri, MyTables._ID + "=? OR " + MyTables._ID + "=? OR " + MyTables._ID + "=?", ids);

I do not know if SQLite supports the IN clause, if so you could also do:

String ids = { "1, 2, 3" };

mContentResolver.delete(uri, MyTables._ID + " IN (?)", ids);

answered Jul 12 '12 at 19:04

Jan-Henk

4,864
1
24
38

Thanks Jan. I guess I had a fundamental misunderstanding of how the selectionArgs worked. My ids can be variable in size. So your second solution looks more appealing. However, I'm afraid that doesn't seem to work either. I suppose I could just check my size and loop to construct that where clase, but that doesn't seem nice :( – Frank Sposaro Jul 12 '12 at 19:12

score 0 · Answer 3 · answered Dec 02 '17 at 15:06

0

String sqlCommand = String.format("DELETE FROM %s WHERE %s IN (%s);", TABLE_NAME, KEY_ID, 1,2,3);

db.execSQL(sqlCommand);

answered Dec 02 '17 at 15:06

Pawan Chaurasiya

881
2
16
30

Batch Delete items with Content Provider in Android

3 Answers3

Linked