On 22 Jul 2011, at 10:47pm, Kent Tenney wrote: > I can't add data, the db belongs to another app, I just watch. > >> [snip] > > I don't care about any of the particulars you describe, only:
Okay that's not so bad. > updated = [] > for row in rows: > if row[newer] != row[older]: > updated.append(row) Since you cannot touch the other app's tables your best approach is probably to keep your own copy of the app's tables. Either an exact copy or, as you described, a hash of the result of SELECT * of each row. Then you just have three operations to notice the three kinds of changes: two SELECT ... JOINs (or SELECT ... EXCEPT) to spot new rows and deleted rows, and a comparison of hashes to spot UPDATEs. Then you rewrite your hashes so you're ready for next time. Good luck with it. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
