I am trying to seed a uuid using sequilize generateUUID but i get this error Seed file failed with error: sequelize.Utils.generateUUID is not a function TypeError: sequelize.Utils.generateUUID is ...

In sequelize, I want to add a condition in findAndCountAll call in sub-sub child models. If the condition is false, it should impact on parent models and findAndCountAll should return array length ...

In code from 2016 using sequelize ORM, I see model types defined with this pattern: module.exports = function(sequelize, DataTypes) { const Tasks = sequelize.define("Tasks", { id: { ty...

I am saving my database config in dotenv file. I am using sequelize migration which has a config.json file in config folder: { "development": { "username": "root", "password": null, "database...

I've just started using Sequelize and Sequelize CLI Since it's a development time, there are a frequent addition and deletion of columns. What the best the method to add a new column to an existin...

I'm working on a migration using Sequelize. If the migration up method throws an error, the migration is not logged in the database as having completed. So, if I run db:migrate:undo, it instead run...

Can someone suggest how do I set primary key on two columns within the same table. var relation = { 'user_id': { type: DataTypes.INTEGER }, 'organization_id':{ type: DataTypes.INTEGER } } I ...

If we created 2 new migration scripts and ran sequelize-cli db:migrate , both migration scripts will run. Both migrations are also reverted when we ran once the command sequelize-cli db:migra...

I cannot seem to figure out how to seed ARRAY(ENUM) using Sequelize. When I am registering a user via my app, I can create a new user fine, but when I am using the queryInterface.bulkInsert in a se...

I was creating document_types table using following cli command sequelize model:create --name User --attributes name:string, username:string, email:string, password:string

I am trying to use Sequelize js with Serverless, coming from traditional server background, I am confused where/how to run database migrations. Should I create a dedicated function for running mig...

I have the below code and I am having a problem. I'm trying to include the images table... There is a relation between the order and images already, but I don't know why it's showing the error belo...

I created a table with timestamps using sequelize. when I am updating the table, it automatically updates the timestamp (i.e createdAt and updatedAt). but these times are different from my local ti...

I'm using sequelize to acess a postgres database and I want to query for a city and for example include the "Building" table but I want to rename the output to "buildings" and return the http respo...

Hi i having an issue connecting to Google Cloud SQL from GAE. My app is running inside docker container here is the docker file FROM node:8.10.0-alpine ARG NODE_ENV=production ENV NODE_ENV=$NOD...

Are Sequelize migrations supposed to keep your model files in line with your database? I used the sequelize cli to bootstrap a simple project and create a model node_modules/.bin/sequelize model:g...

Env: Postgres: 10.2 Node: 6.11.0 CLI: 2.4.0 ORM: 2.1.3 Model: 'use strict'; module.exports = function(sequelize, DataTypes) { var test = sequelize.define('test', { id: DataTypes.UUID, type...

I am trying to delete all report_details before bulkCreate/insert the new ones. The problem is when there is an error in bulkCreate it does not rollback. It should bring the destroyed report_detail...

I am having a problem retrieving data from database using sequelize js. I am new to NODEJS. I don't know if Promise and Promise.all are built in functions So i install and require npm promise in m...

I am using sequelize cli with sequelize to generate a seeder file for a many to many join table Here I have Users and Collections and User_Collections as the join table I have already created seed...

i am using gulp tasks for migration of database. For testing purpose i am using different database. so i need exactly same database. i am trying to do with sequelize.sync({ force: true }) but its n...

I am trying to run a db migration with the Sequelize CLI tool, but I'm running into an issue where my ENV variables are not being processed by the tool. In the github repo, it says in version 2.0.0...

I'm creating models and migrations for two types, Player and Team that have many to many relationship. I'm using sequelize model:create, but don't see how to specify foreign keys or join tables. s...

I'm using sequelize-cli for migrations and have researched different scenarios but there doesn't seem to be a definite solid answer as to how to self join. I want to have a join table called friend...