search

pudo / dataset

Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.
https://dataset.readthedocs.org/
MIT License
4.78k stars 298 forks source link

JSON Partial updates in MySQL with update / upsert #333

Closed d3vr closed 4 years ago

d3vr commented 4 years ago

Hello,

Is there any way to achieve a JSON partial update (using JSON_SET()) in MySQL when using the update / upsert methods ?

Thanks

pudo commented 4 years ago

I don't think there is from the dataset API. Maybe the underlying sqlalchemy library can be used to do this - I'd check their excellent docs!

d3vr commented 4 years ago

Thanks for your reply, so I guess it's out of the scope of dataset, will have a look on sqlalchemy's docs.