sqlite - Android Async Task execution -


in android async tasks, code executed sequentially, or there optimizations? ask because experienced strange behaviour batch of contentprovideroperations execute in asynct task. asking doinbackground method other 2 executed on ui thread.

edit: strange behaviour following: have 3 tables, 1 has primary key foreign key int other two, , other 2 independent between each other. when want delete go first deleting rows of independent tables in order remove foreign key constraint in first one, can delete there well. inserting other way around, first create row in 1st table, create primary key other 2 can reference, , create row in other two.

all of put in batch of content provider operation, constraint failed response.

edit2: of in single thread, in doinbackground of single asynctask , here code ( problem 1 has fk other two:

for (actionsyncmodel ac : res.actions_table) {                     uri deleteuri = actioncontract.action.content_uri                             .buildupon()                             .appendpath(integer.tostring(ac.oldid)).build();                     string temp = deleteuri.tostring();                     log.i("action delete ->>>> ", temp);                     batch.add(contentprovideroperation.newdelete(deleteuri)                             .build());                     getcontentresolver().delete(deleteuri, null, null);                 }                  (journalattachmentsyncmodel js : res.attach_table) {                      uri deleteuri = journalattachmentcontract.journalattachment.content_uri                             .buildupon()                             .appendpath(integer.tostring(js.oldid)).build();                     string temp = deleteuri.tostring();                     log.i("attach delete ->>>>", temp);                     batch.add(contentprovideroperation.newdelete(deleteuri)                             .build());                     getcontentresolver().delete(deleteuri, null, null);                 }                  (problemsyncmodel pro : res.problems_table) {                      uri deleteuri = problemcontract.problem.content_uri                             .buildupon()                             .appendpath(integer.tostring(pro.oldid))                             .build();                     string temp = deleteuri.tostring();                     log.i("problem delete->>>>", temp);                     batch.add(contentprovideroperation.newdelete(deleteuri)                             .build());                     getcontentresolver().delete(deleteuri, null, null);                 }

thank you

from code above, seems batch operation not execute in end. need getcontentresolver().applybatch(...) run in bath. otherwise, deletes executed independently in individual transaction instead of single transaction.

but may not explain constraint error. may more schema.


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more