Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- I want this code to return the array of students that is generated by going through the SELECT statement.
- Due to db.each going off on its own thread, the `students` array it populates is in a different scope
- to the one I declare which is returned empty before the db.each finishes.
- How do I get the `return` to return the data?
- */
- searchStudents: ({term}) => {
- var lessons = ['maths', 'English'];
- var students = [];
- console.log (students);
- db.each(`SELECT * FROM students`, (err, row) => {
- if (err) {
- console.error(err.message);
- } else {
- student = new Student (row.id, row.name, lessons, row.password, row.attendence);
- students.push (student);
- console.log(row.id + "\t" + row.name + "\t" + row.password);
- }
- });
- console.log (students);
- return students;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement