Map updated_at to another column

[chevdor]

Hello,

I would like to use the 'sync' feature but my table does not have an 'updated_at' column. It has a similar column with another name: 'Timestamp'. How can I tell mongify to check out another column for the sync date ?

[anlek]

Might be a bug, @hammady any thoughts on this?

[hammady]

Currently the name of the field is hard-coded to updated_at. A workaround is to create a view of your table with only the Timestamp changed to updated_at.

[srizviOfficial]

any progress on it

[anlek]

Sorry @srizviOfficial, I have no ability to work on Mongify at this moment, maybe in a few months I'll be able to take this on. However, the floor is open for a PR, it's most likely a simple tweak to do.

[romafederico]

Hey guys! Any workarounds on this issue?

[kunalmestri9]

Have you tried , https://www.npmjs.com/package/pre-sync-mongify

I had the same issue i solved it with this.

But I will suggest that you should try on test environment first.

It basically updates all the tables in the MYSQL And sets up some triggers on Update.

[anlek]

Wow, that's interesting 👍 However, it wouldn't be hard to extract the option for the update_at column in the sync code. I'm unable to take it on but am willing to review anyone's code that would want to try to take it on.