Rymapt / ethoscope

a platform from monitoring animal behaviour in real time from a raspberry pi
http://gilestrolab.github.io/ethoscope/
GNU General Public License v3.0
0 stars 2 forks source link

Fix DB converter to be able to do delta copies #58

Closed mark-grimes closed 6 years ago

mark-grimes commented 6 years ago

Changes MySQLdbConverter so that it will check how many rows are in the destination, and skip that many rows in the source. This way it only copies rows that have been added since the last time it was run.

This will cause problems if any new rows are not at the end of the table(s) though - if you have rows inserted part way through existing data then the output will have duplicate and missing entries.

Note this doesn't do anything to speed up the download.