Here’s what I think you’re looking for. db.connections.update({ user: data.username, chatroomID: data.chatroomID }, { where: { socketID: socket.id }, returning: true, plain: true }) .then(function (result) { console.log(result); // result = [x] or [x, y] // [x] if you’re not using Postgres // [x, y] if you are using Postgres }); From Sequelize docs: The … Read more
Just pass in ‘TIMESTAMP’ string to your type module.exports = { up: function (queryInterface, Sequelize) { return queryInterface.createTable(‘users’, { id: { type: Sequelize.INTEGER, primaryKey: true, autoIncrement: true }, created_at: { type: ‘TIMESTAMP’, defaultValue: Sequelize.literal(‘CURRENT_TIMESTAMP’), allowNull: false }, updated_at: { type: ‘TIMESTAMP’, defaultValue: Sequelize.literal(‘CURRENT_TIMESTAMP’), allowNull: false } }); } };
Found an answer to my question, I just need to add the subQuery = false so that the limit and offset will not be evaluated to sub query. And the offset and limit is also in the end of the query. offset:((page-1)*limit), limit : limit, subQuery:false
Sequelize Docs: Nested Eager Loading Example Issue.find({ include: [ { model: Invite, include: [Group] } ] });
The ENUM values in a schema can be found in the rawAttributes property of the model. var Model = sequelize.define(‘model’, { states: { type: Sequelize.ENUM, values: [‘active’, ‘pending’, ‘deleted’] } }); console.log(Model.rawAttributes.states.values); // logs [‘active’, ‘pending’, ‘deleted’] in console
@dankohn is correct and that will work but it is safer to use the following: Post.findAll({ limit: 10, order: [[‘updatedAt’, ‘DESC’]]}); as this will escape updatedAt and validate DESC against a list of valid direction parameters
Before I had the same problem, and solved when I understood the functioning of settings Sequelize. Straight to the point! Suppose we have two objects: Person and Father var Person = sequelize.define(‘Person’, { name: Sequelize.STRING }); var Father = sequelize.define(‘Father’, { age: Sequelize.STRING, //The magic start here personId: { type: Sequelize.INTEGER, references: ‘persons’, // <<< … Read more
You can specify distinct for one or more attributes using Sequelize.fn Project.findAll({ attributes: [ // specify an array where the first element is the SQL function and the second is the alias [Sequelize.fn(‘DISTINCT’, Sequelize.col(‘country’)) ,’country’], // specify any additional columns, e.g. country_code // ‘country_code’ ] }).then(function(country) { })
UPDATE: New version There are now separate distinct and col options. The docs for distinct state: Apply COUNT(DISTINCT(col)) on primary key or on options.col. You want something along the lines of: MyModel.count({ include: …, where: …, distinct: true, col: ‘Product.id’ }) .then(function(count) { // count is an integer }); Original Post (As mentioned in the … Read more
The error is caused by using the sequelize import object. Instead you should use Node’s built in CommonJS require function. So change this line in your models/index.js: const model = sequelize[‘import’](path.join(__dirname, file)) to: const model = require(path.join(__dirname, file))(sequelize, Sequelize.DataTypes) You can also just regenerate the models directory and readd your models without the old index.js … Read more