Advertisement
Grossos

async deleteRowById(id)

Dec 27th, 2023
949
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  async deleteRowById(id) {
  2.         try {
  3.             id = parseInt(id, 10);
  4.             const response = await new Promise((resolve, reject) => {
  5.                 // must be improved
  6.                 const query = `DELETE FROM votes WHERE server_id = ${id};`;
  7.  
  8.                 connection.query(query, [id], (err, result) => {
  9.                     if (err) reject(new Error(err.message));
  10.                     resolve(result.affectedRows);
  11.                     return reject;
  12.                 })
  13.             });
  14.             return response === 1 ? true : false;
  15.         } catch (err) {
  16.             console.log(error);
  17.             return false;
  18.         } finally {
  19.             id = parseInt(id, 10);
  20.             const response = await new Promise((resolve, reject) => {
  21.                 const query = `DELETE FROM servers WHERE id = ${id};`;
  22.  
  23.                 connection.query(query, [id], (err, result) => {
  24.                     if (err) reject(new Error(err.message));
  25.                     resolve(result.affectedRows);
  26.                     return reject;
  27.                 })
  28.             });
  29.             return response === 1 ? true : false;
  30.         }
  31.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement