ExpressJS - Sequelize - Query Results Not Populated in Object

Question

I have a route set up that conducts the following sql query:

Executing (default): SELECT `id`, `pattern`, `color`, `imageUrl`, `imageSource` FROM `images` AS `images` WHERE `images`.`pattern` = 'solid' AND `images`.`color` = 'navy-blue';

which when tested on my local database works and provides results, but I can't seem to populate my image object to then be used within my view. I feel like I'm passing it as a function parameter in the wrong place, but I'm not sure and my console.log(image); is not coming back with a response.

router.get('/:pattern/:color/result', function(req, res, image){

    console.log(req.params.color);
    console.log(req.params.pattern);

    Images.findAll({ 
        where: {
            pattern: req.params.pattern,
            color: req.params.color
        },
        attributes: ['id', 'pattern', 'color', 'imageUrl', 'imageSource']
    }),
        console.log(image);
        //console.log(doc.descriptions_id);
        res.render('pages/result.hbs', {
            pattern : req.params.pattern,
            color : req.params.color,
            image : image
        })
});

Here is my model:

var Sequelize      = require('sequelize');
var sequelize = new Sequelize('db', 'admin', 'test', {
    host: 'localhost',
    port: 3306,
    dialect: 'mysql'
});


var Images = sequelize.define('images', {
    pattern: {
        type: Sequelize.STRING,
        field: 'pattern'
    },
    color: {
        type: Sequelize.STRING,
        field: 'color'
    },
    imageUrl: {
        type: Sequelize.STRING,
        field: 'imageUrl'
    },
    imageSource: {
        type: Sequelize.STRING,
        field: 'imageSource'
    },
    description_id: {
        type: Sequelize.INTEGER,
        field: 'description_id'
    }
});

module.exports = Images;

Rudolf Manusachi · Accepted Answer · 2015-10-16 12:37:39Z

2

You should use Promises

router.get('/:pattern/:color/result', function(req, res, image){
  console.log(req.params.color);
  console.log(req.params.pattern);

  Images.findAll({ 
    where: {
        pattern: req.params.pattern,
        color: req.params.color
    },
    attributes: ['id', 'pattern', 'color', 'imageUrl', 'imageSource']
  }).then(function(image){
    console.log(image);
    //console.log(doc.descriptions_id);
    res.render('pages/result.hbs', {
        pattern : req.params.pattern,
        color : req.params.color,
        image : image
    })
  });
});

answered Oct 16, 2015 at 12:37

Rudolf Manusachi

2,3562 gold badges20 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ExpressJS - Sequelize - Query Results Not Populated in Object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related