How do I use the Sequelize.Op & Sequelize.literal? about hapi-sequelizejs HOT 2 CLOSED

I think this is a sequelize specific question, but maybe this helps you:

Use .getDb() to get the sequelize instance.

db.getModel(sequelizeModel).findAll({
     $and: [
          sequelize.where(sequelize.col('attachment_types'), '@>', sequelize.literal('[{id:2}]::jsonb'));
    ]
});

Also check the docs http://docs.sequelizejs.com/manual/tutorial/querying.html#jsonb.

The upgrade is currently stopped, haven't much time to work on it 😞 .

from hapi-sequelizejs.

Thanks for the help.
I thought you might want to add notes to the readme.
I found the solution. The critical point is to use the db.sequelize from hapi-sequelizejs, otherwise it doesn't work.
Also the Operators (http://docs.sequelizejs.com/manual/tutorial/querying.html#operators) don't seem to be accessable so we have to just include them directly.

                db.getModel(model).findAll({
                    where: {
                        attachment_types: { '@>': db.sequelize.literal('\'[{"id":3}]\'::jsonb') }
                    }
                })
                    .then((qry) => {
                        return reply(qry);
                    })
                    .catch((err) => {
                        return reply({ err });
                    });

So to use raw queries it is
db.sequelize
.query('select * ...')
.spread((results, metadata) => {
// Results will be an empty array and metadata will contain the number of affected rows.
console.log(results);
console.log(metadata);
});

Best Regards,
Jonathan

from hapi-sequelizejs.