SQLAlchemy: JSON_ARRAY_APPEND?

Question

I need to update a JSON type column in a MySQL database using JSON_ARRAY_APPEND. I can't just use python's .append() because this operation needs to occur on the database level to avoid race conditions.

Is this possible to do with SQLAlchemy?

jorzel · Accepted Answer · 2021-12-08 08:42:31Z

1

Yes, you can use database builtin functions thanks to func:

from sqlalchemy import func

func.json_array_append(...)

answered Dec 8, 2021 at 8:42

jorzel

1,3461 gold badge8 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLAlchemy: JSON_ARRAY_APPEND?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related