Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It is a limitation of <code>ContentProvider</code>. If you are not exposing your data to other applications you can use your custom database adapter implementation with methods and queries straight hitting your requirements.</p> <p><code>bulkInsert()</code> won't help in this situation as it inserts rows only into one table at once. But take a look at <a href="http://developer.android.com/reference/android/content/ContentProvider.html#applyBatch%28java.util.ArrayList%3Candroid.content.ContentProviderOperation%3E%29" rel="nofollow noreferrer">ContentProvider.applyBatch()</a> method and <a href="http://developer.android.com/reference/android/content/ContentProviderOperation.html" rel="nofollow noreferrer">ContentProviderOperation</a>, <a href="http://developer.android.com/reference/android/content/ContentProviderOperation.Builder.html" rel="nofollow noreferrer">ContentProviderOperation.Builder</a> classes (you may need <code>withValueBackReference()</code> for one-to-many inserting).</p> <p>These links should help you understand how to use them:</p> <p><a href="http://www.grokkingandroid.com/better-performance-with-contentprovideroperation/" rel="nofollow noreferrer">http://www.grokkingandroid.com/better-performance-with-contentprovideroperation/</a> <a href="http://www.grokkingandroid.com/androids-contentprovideroperation-withbackreference-explained/" rel="nofollow noreferrer">http://www.grokkingandroid.com/androids-contentprovideroperation-withbackreference-explained/</a> <a href="https://stackoverflow.com/questions/4655291/semantics-of-withvaluebackreference">What are the semantics of withValueBackReference?</a></p> <p>But notice, using <code>ContentProviderOperation</code> is much slower than <code>bulkInsert()</code> if you are inserting many rows at once, as it parses <code>Uri</code> (string comparisions) each time the operation is going to be performed. Doing this way you still have to expose Uri for inserting into child table.</p> <p>If you decide to use <code>applyBatch()</code>, overwrite it in your provider so it performs all operations in one transaction, so you retain consistency in data and speed up database operations:</p> <pre><code>@Override public ContentProviderResult[] applyBatch(ArrayList&lt;ContentProviderOperation&gt; operations) throws OperationApplicationException { final SQLiteDatabase db = mOpenHelper.getWritableDatabase(); db.beginTransaction(); try { ContentProviderResult[] results = super.applyBatch(operations); db.setTransactionSuccessful(); return results; } finally { db.endTransaction(); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POinserting to multiple tables with ContentProvider
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USbiegleux
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COso the only way of not exposing child tables is using `applyBatch` ?
      singulars
      1. PO
      1. USGal Ben-Haim
    2. COYou still need to define uri for inserting into child table, that's the way ContentProvider is acessed (you can throw IllegalArgumentException for query() operation on child table if you want to disallow querying child tables), acces to content providers is based on Uris and providers are primarily used for one table, they have limitations when it comes to relationships between tables, but there is nothing wrong in exposing separate uri for inserting into child table, posted applyBatch() method helps you prepare your operations and execute them in one transaction
      singulars
      1. PO
      1. USbiegleux
    3. COit's a trade-off using content provider instead of own database adapter implementation
      singulars
      1. PO
      1. USbiegleux
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload