Advertisement
Guest User

Untitled

a guest
Jun 9th, 2022
35
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. const getAllWords = (filterParam) => {
  2.   if (filterParam.alphabet) {
  3.     const { alphabet, _offset } = filterParam;
  4.     return new Promise((res, rej) => {
  5.       const GET_ALL_WORD_BY_ALPHABET = `SELECT * FROM words WHERE word_name LIKE ? LIMIT ? OFFSET ?`;
  6.       db.all(
  7.         GET_ALL_WORD_BY_ALPHABET,
  8.         [alphabet + "%", 12, _offset],
  9.         (err, rows) => {
  10.           if (err) {
  11.             rej({
  12.               status: 500,
  13.               message: err,
  14.             });
  15.           }
  16.           db.all(
  17.             `SELECT * FROM words WHERE word_name LIKE ?`,
  18.             [alphabet + "%"],
  19.             (err, totalRows) => {
  20.               if (err) {
  21.                 rej({
  22.                   status: 500,
  23.                   message: err,
  24.                 });
  25.               }
  26.               res({ totalRows, rows });
  27.             }
  28.           );
  29.         }
  30.       );
  31.     });
  32.   }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement