/** * @description Get messages of a user * @param {string} userId - The id of the user. * @param {Object} options - Options of the request. * @example * gladys.message.get('f6cc6e0c-1b48-4b59-8ac7-9a0ad2e0ed3c', options); */ async function get(userId, options) { const optionsWithDefault = Object.assign({}, DEFAULT_OPTIONS, options); const queryParams = { attributes: optionsWithDefault.fields, limit: optionsWithDefault.take, offset: optionsWithDefault.skip, order: [[optionsWithDefault.order_by, optionsWithDefault.order_dir]], where: { [Op.or]: [{ sender_id: userId }, { receiver_id: userId }], }, }; const messages = await db.Message.findAll(queryParams); const plainMessages = messages.map((message) => message.get({ plain: true })); return plainMessages; }
[Op.or]: [ Sequelize.where(Sequelize.fn('lower', Sequelize.col('t_device.name')), { [Op.like]: `%${optionsWithDefault.search}%`,
const claimAvailability = async (name) => { const claimAddresses = additionalClaimAddresses || []; claimAddresses.push(primaryClaimAddress); // find any records where the name is used return chainquery.claim .findAll({ attributes: ['claim_address'], where : { name, claim_address: { [Op.or]: claimAddresses, }, }, }) .then(result => { return (result.length <= 0); }) .catch(error => { throw error; }); }
User.create({ name: req.body.name, username: req.body.username, email: req.body.email, password: bcrypt.hashSync(req.body.password, 8) }).then(user => { Role.findAll({ where: { name: { [Op.or]: req.body.roles } } }).then(roles => { user.setRoles(roles).then(() => { res.send("User registered successfully!"); }); }).catch(err => { res.status(500).send("Error -> " + err); }); }).catch(err => { res.status(500).send("Fail! Error -> " + err); })