Size: a a a

Sequelize - community (eng/ru)

2019 August 05

GP

Gilberto Pérez in Sequelize - community (eng/ru)
Hi guys. I have a doubt relations in sequelize. I have the User and Role model. In the associations I have User.belongsTo (models.Role, {foreignKey: 'roleId'}) but when I try to make a findAll () for example, it is looking for RoleId and roleId fields, of which it only finds the roleId and gives me error.
источник

YZ

Yaroslav Zhymkov in Sequelize - community (eng/ru)
What error?
источник

GP

Gilberto Pérez in Sequelize - community (eng/ru)
It looking for RoleId field and it does not exist

"id", "firstName", "lastName", "email", "password", "dni", "dniType", "imageUrl", "dateOfBirth", "gender", "status", "note", "createdAt", "updatedAt", "RoleId", "roleId" FROM "Users" AS "User";
источник

YZ

Yaroslav Zhymkov in Sequelize - community (eng/ru)
Show text of error
источник

GP

Gilberto Pérez in Sequelize - community (eng/ru)
источник

G

GG in Sequelize - community (eng/ru)
show your code model
источник

GP

Gilberto Pérez in Sequelize - community (eng/ru)
источник

GP

Gilberto Pérez in Sequelize - community (eng/ru)
This Role Model
источник

GP

Gilberto Pérez in Sequelize - community (eng/ru)
источник

GP

Gilberto Pérez in Sequelize - community (eng/ru)
This is User Model
источник

GP

Gilberto Pérez in Sequelize - community (eng/ru)
I am using migrations too, but I don't think that influences the error
источник

GP

Gilberto Pérez in Sequelize - community (eng/ru)
источник

G

GG in Sequelize - community (eng/ru)
может быть вы не правильно сделали миграции, проверьте в самом postgresql существуют ли там такие поля RoleId, roleId
источник

GP

Gilberto Pérez in Sequelize - community (eng/ru)
Only exist roleId
источник

G

GG in Sequelize - community (eng/ru)
источник

G

GG in Sequelize - community (eng/ru)
maybe need used "as" ?
источник

GP

Gilberto Pérez in Sequelize - community (eng/ru)
let me try
источник

G

GG in Sequelize - community (eng/ru)
🤔🤷‍♂️
источник

YZ

Yaroslav Zhymkov in Sequelize - community (eng/ru)
Understand
источник

YZ

Yaroslav Zhymkov in Sequelize - community (eng/ru)
You have error
источник