For anyone finding this later on it’s now possible to explicitely define what the database field should be named: var User = sequelize.define(‘user’, { isAdmin: { type: DataTypes.BOOLEAN, field: ‘is_admin’ } });
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.
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 … Read more
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
Another way is to add a default scope to the User model. Add this in the model’s options object defaultScope: { attributes: { exclude: [‘password’] }, } Or you can create a separate scope to use it only in certain queries. Add this in the model’s options object scopes: { withoutPassword: { attributes: { exclude: … Read more
(More or less) formal docs and API reference can be found at https://sequelize.org/docs/v6/core-concepts/model-basics/#model-synchronization To your question: force: true adds a DROP TABLE IF EXISTS before trying to create the table – if you force, existing tables will be overwritten.