YZ
Thanks, sorry for my english, i use google translator most of the time
You are welcome
Size: a a a
2019 September 17
2019 September 18
Y
YZ
Hi, only english/russian
Y
How can I change that name with the one that returns by default
YZ
Can you show a query for find?
YZ
YZ
Or create correct association and use by name
YZ
2019 September 19
FP
Hi guys
FP
I've some doubts about a query (I'm really newbie to node.js and sequelize)
FP
could you help me? It's a really simple query, but I'm confusing
FP
I've two tables: User 1:1 Admin
FP
db['gymUser'].associate = (models) => {
db['gymUser'].hasOne(models.gymAdmin, {
foreignKey: 'gymUserId',
targetKey: 'id'
});
}
db['gymAdmin'].associate = (models) => {
db['gymAdmin'].belongsTo(models.gymUser, {
foreignKey: 'id',
});
}
db['gymUser'].hasOne(models.gymAdmin, {
foreignKey: 'gymUserId',
targetKey: 'id'
});
}
db['gymAdmin'].associate = (models) => {
db['gymAdmin'].belongsTo(models.gymUser, {
foreignKey: 'id',
});
}
FP
Now, I would like to get all users that isn't admins and all admins
FP
async getAdmins() {
let where = {
gymUserId: {
[Sequelize.Op.ne]: null
}
}
return GymUser.findAll({
include: [{
model: GymAdmin,
where: where
}]
})
}
let where = {
gymUserId: {
[Sequelize.Op.ne]: null
}
}
return GymUser.findAll({
include: [{
model: GymAdmin,
where: where
}]
})
}
FP
How can I get all users that isn't admins?
YZ
You nned to add condition in where
FP
You nned to add condition in where
Which condition? Do you have an idea?