Телеграмм чат группы sequelize страница 184

Size: a a a

Sequelize - community (eng/ru)

99 membersпожаловаться на группу

2019 September 19

Yaroslav Zhymkov in Sequelize - community (eng/ru)

If you need only no admin user, why does you need admin table?

источник

09:17пожаловаться #1

Francesco Pace in Sequelize - community (eng/ru)

I've these queries from SQL syntax

// Admins
SELECT *
FROM gym_user u
WHERE EXISTS (SELECT * FROM gym_admin a
WHERE a.gym_user_id = u.id);

// Simple users
SELECT *
FROM gym_user u
WHERE NOT EXISTS (SELECT * FROM gym_admin a
WHERE a.gym_user_id = u.id);

источник

09:17пожаловаться #2

Yaroslav Zhymkov in Sequelize - community (eng/ru)

Francesco Pace

I've some doubts about a query (I'm really newbie to node.js and sequelize)

Better read manual before practise

источник

09:17пожаловаться #3

Yaroslav Zhymkov in Sequelize - community (eng/ru)

Francesco Pace

async getAdmins() {
let where = {
gymUserId: {
[Sequelize.Op.ne]: null
}
}
return GymUser.findAll({
include: [{
model: GymAdmin,
where: where
}]
})
}

You need check like this but check that userId in admin table is null

источник

09:19пожаловаться #4

Francesco Pace in Sequelize - community (eng/ru)

You're right

источник

10:23пожаловаться #5

Francesco Pace in Sequelize - community (eng/ru)

I've done

источник

10:23пожаловаться #6

Francesco Pace in Sequelize - community (eng/ru)

but with a RAW Query, all works

источник

10:23пожаловаться #7

Francesco Pace in Sequelize - community (eng/ru)

For example:
—————-
let where = {
gymUserId: {
[Sequelize.Op.ne]: null
}
}
return GymUser.findAll({
include: [{
model: GymAdmin,
required: false,
where: where
}]
})

—————
SELECT *
FROM gym_user AS gymUser
LEFT OUTER JOIN gym_admin AS gymAdmin
ON gymUser.id = gymAdmin.gym_user_id
AND gymAdmin.gym_user_id IS NOT NULL;

источник

10:24пожаловаться #8

Francesco Pace in Sequelize - community (eng/ru)

I've to change "AND" clause to "WHERE", in this way:
SELECT *
FROM gym_user AS