Untitled

 avatar
unknown
plain_text
a year ago
1.8 kB
2
Indexable
   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));
            });
        },

    }