Is there a way to check if android SQLite DB has been changed in anyway?
too be used in this sort of format:
i.e
if (isChanged){
POST data
}else{
Log.i("no changes")
}
Thanks
-
Do you mean schema change, like new table, column add/drop? or data inside sqlite file change?Prakash– Prakash2014-02-04 22:55:04 +00:00Commented Feb 4, 2014 at 22:55
-
Seems like an XY problem. What is a "change"? Why do you need to know? Answers will vary depending on your goal (ie: checking for schema changes, checking for an updated job queue, checking for third party data forgery).rutter– rutter2014-02-04 22:55:43 +00:00Commented Feb 4, 2014 at 22:55
-
@rutter trying to sync local android SQLite with online MySQL.Chris Mowbray– Chris Mowbray2014-02-04 22:58:29 +00:00Commented Feb 4, 2014 at 22:58
-
@Prakash any changes data change as is new record, deleted record or edited recordChris Mowbray– Chris Mowbray2014-02-04 22:59:26 +00:00Commented Feb 4, 2014 at 22:59
Add a comment
|
2 Answers
An easy solution: you can create a windows service or just publish a .xml file containig a checksum <checksum>3203025</checksum>
http://prueba.agenciareforma.com/appiphone/android/checksumdb.xml
<?xml version="1.0" encoding="UTF-8"?>
<mobiledb>
<nombre>Stiri IASI</nombre>
<urlDB>http://jorgesys.com/appiphone/android/stiridb.db</urlDB>
<checksum>3203025</checksum>
</mobiledb>
checksum changes when changes into the db have been applied http://jorgesys.com/appiphone/android/stiridb.db has changed.
Then check if the actual checksum is different to the last, so download the db with the new changes.
an example:
//method readUrlDatabaseChecksum(), download and parse the currently value of checksum from the .xml file
String checksumDB = readUrlDatabaseChecksum();
//method readDBChecksum(), get the stored value (preferences or db) of the las checksum.
String lastDBChecksum = readDBChecksum(); //dbm.obtenerCheckSum(seccion.getId());;
//If the values are different proceed to download the new version of the Database.
if(!checksumFeed.equals(checksumDB)){
Log.i(TAG, "*** Downloading new Database!");
//method downloadDatabase(), download the new version of the database.
downloadDatabase();
//method saveDBChecksum(), save the new value (preferences or db) of the las checksum.
saveDBChecksum();
}else{
Log.i(TAG, "*** Database hasn´t changed!");
}
Comments
I didn't find any API for that yet, but another option would be get MD5 value of sqlite file and compare with last MD5.
