On Fri, Jul 22, 2011 at 5:06 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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.
Thanks! Kent > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users