updateRole: (req) => {
return new Promise((resolve, reject) => {
const sql = `UPDATE role
SET position = (?),
open_webcam =(?),
open_micro =(?),
open_share_screen =(?),
send_message =(?),
see_user_ip =(?),
kick_user =(?),
ban_user=(?),
send_private=(?),
can_be_invisible=(?),
edit_message=(?)
where room = (?)
AND role =(?)`;
const values = [req.data.position ,
req.data.open_webcam,
req.data.open_micro,
req.data.open_share_screen,
req.data.send_message,
req.data.see_user_ip,
req.data.kick_user,
req.data.ban_user,
req.data.send_private,
req.data.can_be_invisble,
req.data.edit_message,
req.room,
req.data.role
];
poolQuery(sql, values)
.then((value) => {
console.log(value.affectedRows)
if (value.affectedRows === 1)
resolve({message:'reussis'})
})
.catch((err) => reject(err));
});
},
}