Android Update SQL Database Contents

Question

I have a relatively small Table in a SQL database in my Android app (around 15 or 20 rows). Every so often I want to be able to do a complete re-sync of the database with an online JSON file, so that:

Rows in the JSON file that are not in the database are added
Rows in the JSON file and in the database are updated
Rows in the database that are not in the JSON file are deleted

What's the best way to do something like this?

Darren Kopp · Accepted Answer · 2011-06-10 20:53:43Z

1

1 & 2 are quite easy, use Insert or Replace statement. The third one there's no real easy way to do that short of getting all the id's from the database then removing all the id's from the json file, then running deletes on the id's you have left.

answered Jun 10, 2011 at 20:53

Darren Kopp

77.8k9 gold badges81 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Android Update SQL Database Contents

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related