How to use MySQL JSON datatype with Sequelize

Question

I'm trying to use MySQL 5.7 with Sequelize, and I want to use the JSON datatype for the attributes field on my users table to keep track of user attributes such as home_phone, mobile_phone, work_phone, address and several other attributes/settings that every user may or may not have.

I've been able to locate the documentation for performing selects here: http://docs.sequelizejs.com/manual/tutorial/querying.html#json.

I'm struggling to find documentation on how I would perform create, update and delete.

I guess I could always just do a raw query, but is there a sequelize way to do this?

Update 1

I'm specifically looking for how to perform a query like this in sequelize:

update Users 
set user_attributes = JSON_SET(user_attributes, "$.phone", "5554443333") 
where id=7;

Faris · Accepted Answer · 2018-11-30 22:36:22Z

6

Use Sequelize.fn method:

User.update({
  user_attributes: Sequelize.fn("JSON_SET", Sequelize.col('user_attributes'), "$.phone", "5554443333")
}, {
  where: {id: 7}
})

answered Nov 30, 2018 at 22:36

Faris

2412 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

How to use MySQL JSON datatype with Sequelize

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