DEV Community: Cory Allen

How to handle a Sequelize promise within a for loop?

Cory Allen — Sat, 17 Sep 2022 01:48:30 +0000

I am having trouble querying within Express with Sequelize. I am first querying all QuizAttempts by a user, and then I am querying Articles to refrence the article name to match it to the quiz attempt. (Joins are way over my head). My problem is, I am getting "null" returned when I console.log "Article Data".

exports.home = async (req, res) => {

    const quizAttempts = await QuizAttempts.findAll({
        raw: true,
        where: {
            user_id: req.user.id
        }
    }).then(async (data) => {
        for (let i = 0; i < data.length; i++) {
            const queryName = await Articles.findOne({
                raw: true,
                where: {
                    id: data[i].article_id
                }
            }).then((articleData) => {
                console.log(articleData);
            })
        }
    })
}

I've been told to use Promise.all() in this particular case but I am not fully understanding how I would do so while still retaining the value of i. Any help is appreciated!

Quick logic question... Express, Sequelize, & Handlebars

Cory Allen — Wed, 14 Sep 2022 23:07:24 +0000

Having a tough time working out some logic. I don't know if it's because my brain is fried or what, but here is what I'm trying to do.

I have a table named "Questions", this table contains questions over an article. Fields are as follows: id, article_is, questions, answer1, answer2, answer3, answer4, correct_answer, explanations.

I would like to query 5 questions for the article and display them on the page obviously (this i can do). However, I am having "Writers block" persay with how to handle the form information with the Sequelize query. My query in my controller looks as follows:

exports.article_review = (req, res) => {
    Questions.findAll({
        limit: 5,
        where: {
            article_id: req.params.id
        },
        raw: true
    }).then(function(data) {

            res.render('article-review', {
                title: "Test your knowledge",
                questions: data,
                id: req.params.id
            })
    })
}

For the life of me I cannot think of a way to appropriately process the form, compare each answer to each question to correct_answer, and display the results on the page. Any input would be great! Also, I'm sure the answer is simple, I've just been elbows deep in this project for 12+ hours a day for the last week.

Sequelize, Express.js, & Handlebars.js being turds?

Cory Allen — Tue, 13 Sep 2022 14:45:01 +0000

My brain is sizzling, either I am overlooking a tiny detail or this is supposed to work and doesn't for whatever reason. Just trying to render by findAll() query to the page using handlebars. Here's what I have.

Controller:

const library = require('../models/Library');
exports.manage_library = (req, res) => {
    Library.findAll()
        .then(function(data) {
            res.render('manage-library', {
                title: "Manage Website",
                user: req.user,
                data: data
            })
        });
}

View:

                    {{#each data}}
                        <div class="list-group-item d-flex justify-content-between">
                        <div><strong>{{this.name}}</strong></div>
                        <div>
                            <a href="/edit-category/{{this.id}}" class="btn btn-sm btn-warning"><i class="bi bi-pencil"></i></a>
                            <a href="/delete-category/{{this.id}}" class="btn btn-sm btn-danger"><i class="bi bi-trash3"></i></a>
                        </div>
                    </div>
                    {{/each}}

I am new to Node & Express, this is my first serious project so forgive me if I am overlooking something minor. Basically, the above code renders the appripriate amount of list-group-item but I cannot display actual data within the list-group-item.

What the glorp am I doing wrong?! 👽