search

lathonez / clone-row

Python utility to clone a row in mysql, from a target to source database, field by field
http://lathonez.com/2016/clone-row/
MIT License
7 stars 1 forks source link

[Feature] Type casting to be explicit or throw warnings #15

Open wulfsolter opened 6 years ago

wulfsolter commented 6 years ago

No errors / warnings thrown when casting guest.lastVisit from remote text to local timestamp

lathonez commented 6 years ago

Currently we're just using adding / missing properties to identify differences in the schema: https://github.com/lathonez/clone-row/blob/master/CloneRow.py#L426-L427

We also do explicit encoding checks here https://github.com/lathonez/clone-row/blob/master/CloneRow.py#L109

But we need to extend this to make sure the data types of columns match up too