Postgres timestamp column causes sync to fail

[brandantck]

Postgres: v15

config.yml

progress: 
  type: file 

I am trying to sync a table from a Postgres database with the column type:timestamp, and its throwing this error.

This is an example of a row in the database

Seems like the error occurs when its trying to do a json.dumps into the progress.json file.

Edit: Tried with redis but still getting the same error, issue might not lie with writing to progress

[sanders41]

datetime is not json serializable so that is most likely causing the issue. I'm not sure the full context here so this my not be possible but if you can convert your dates to an iso string before dumping it should fix the issue.

An example of how to convert:

condition_start_datetime = datetime.datetime(2010, 4, 1, 0, 0)
converted = condition_start_datetime.isoformat()

[long2ice]

Maybe you can use plugins

[brandantck]

When i run the meilisync refresh command, it doesnt seem to run the plugin pre_event or post_event functions

[long2ice]

Yes, that's a problem...

[brandantck]

Ah okay, so currently, the plugins are only loaded and used on the meilisync start command?

[long2ice]

You can try latest code now