Insert several rows from 1st table to the 2nd with ContentProvider

Question

I wonder how to implement this with ContentProvider? I insert several rows from table to another with single select statment:

insert into table1 (field1, field2,...) 
     select field1, field2... from table2 where ...

If I should use insert method, I cannot get this several new id..

edit: If this is insert method what Uri I should return?

Tarun · Answer 1 · 2013-08-12T12:39:20.723

0

Call execSql

@Override
public Uri insert(Uri uri, ContentValues initialValues) {
  switch (sUriMatcher.match(uri)){
    case URI_1:
     SQLiteDatabase db = mOpenHelper.getWritableDatabase();
     db.execSql("insert into table1 (field1, field2,...) 
     select field1, field2... from table2 where ...");
     return uri;
}

edited Aug 12 '13 at 12:39

answered Aug 12 '13 at 05:24

Tarun

13,727
8
42
57

this you example have to return uri "public Uri insert..." of newly inserted row for the ContentProvider to watch db changes.. – Foenix Aug 12 '13 at 12:18
You can return the same URI passed to insert. Updated my answer. – Tarun Aug 12 '13 at 12:38
There is no problem if you return the same URI. – Tarun Aug 12 '13 at 14:33

Insert several rows from 1st table to the 2nd with ContentProvider

1 Answers1