Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const getAllWords = (filterParam) => {
- if (filterParam.alphabet) {
- const { alphabet, _offset } = filterParam;
- return new Promise((res, rej) => {
- const GET_ALL_WORD_BY_ALPHABET = `SELECT * FROM words WHERE word_name LIKE ? LIMIT ? OFFSET ?`;
- db.all(
- GET_ALL_WORD_BY_ALPHABET,
- [alphabet + "%", 12, _offset],
- (err, rows) => {
- if (err) {
- rej({
- status: 500,
- message: err,
- });
- }
- db.all(
- `SELECT * FROM words WHERE word_name LIKE ?`,
- [alphabet + "%"],
- (err, totalRows) => {
- if (err) {
- rej({
- status: 500,
- message: err,
- });
- }
- res({ totalRows, rows });
- }
- );
- }
- );
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement