You need to install the mysql npm module: npm install mysql The reason sequelize doesn’t have the mysql module as its own dependency is because it can be used with other databases such as postgres or sqlite.
You should set the returning option: Model.bulkCreate(values, {returning: true})
you should change config.json file to a config.js module and make sure to require the dotenv at the very top. require(‘dotenv’).config(); // this is important! module.exports = { “development”: { “username”: process.env.DB_USERNAME, “password”: process.env.DB_PASSWORD, “database”: process.env.DB_DATABASE, “host”: process.env.DB_HOST, “dialect”: “mysql” }, “test”: { “username”: “root”, “password”: null, “database”: “database_test”, “host”: “127.0.0.1”, “dialect”: “mysql” }, “production”: …
You can use Sequelize.fn to wrap it appropriately: instance.updateAttributes({syncedAt: sequelize.fn(‘NOW’)}); Here’s a full working example: ‘use strict’; var Sequelize = require(‘sequelize’); var sequelize = new Sequelize(/*database*/’test’, /*username*/’test’, /*password*/’test’, {host: ‘localhost’, dialect: ‘postgres’}); var model = sequelize.define(‘model’, { syncedAt: {type: Sequelize.DATE} }); sequelize.sync({force: true}) .then(function () { return model.create({}); }) .then(function () { return model.find({}); }) …
Yes, the methods can be chained. In your case you just perform the addIndex after createTable method return queryInterface.createTable(‘Todos’, { // columns… }).then(() => queryInterface.addIndex(‘Todos’, [‘author_id’, ‘title’])) .then(() => { // perform further operations if needed });
This issue has been fixed on Sequelize 3.0.1, the primary key of the included models must be excluded with attributes: [] and the aggregation must be done on the main model (infos in this github issue). Thus for my use case, the code is the following models.contracts.findAll({ attributes: [‘id’, [models.sequelize.fn(‘sum’, models.sequelize.col(‘payments.payment_amount’)), ‘total_cost’]], include: [ { …
using: required:false sentences： Shop.findAll({ where:{id:shopId}, include:[ { model:ShopAd, as:’ads’, where:{ is_valid:1, is_vertify:1}, required:false } ] }) .success(function(result) { callback(result); });
You can simple use the type UUIDV4 that comes with Sequelize. Here is more details : UUIDV4 For example making this definition: id: { type: Sequelize.UUID, defaultValue: Sequelize.UUIDV4, allowNull: false, primaryKey: true } This is not using the Sequelize CLI but you can use that native UUIDV4 by manually changing that.
Normally Sequelize.js adapt itself with the database. So the autoincrement attribute corresponds to a serial type in PostgreSQL. I already worked with Sequelize and what I remember is that you don’t need to specify an id as a primary key. Sequelize will do it for you. Try to not add an id attribute and see …
I may have a reasonable solution. I am sure it could be written more cleanly though. For this example I’m using Postgres, the answer would be slightly different for MySQL. I’m heavily borrowing from this answer: node-postgres create database In database.js I have the following init function var Sequelize = require(‘sequelize’), pg = require(‘pg’); module.exports.init …