I'm trying to build a simple Node/Express app with Sequelize, but when I try to create a new record in my relational database, I am getting the error Unhandled rejection SequelizeDatabaseError: SQL...

I'm creating a DB model via Sequelize CLI with this command: sequelize model:create --name User --attributes "firstname:string, lastname:string" This creates the corresponding migration script: ...

Any one know how to custom select query on sequelize seeder I have tried two ways, but no one work First attempt up: function(queryInterface, Sequelize) { return queryInterface.sequelize.query...

Is it possible to run only the next migration file with the sequelize-cli? I have been looking through the docs and help-section of the cli, and it does not appear to be such a feature. For insta...

I am trying to get all records from a mysql Database with sequelize and I have tried following approaches: shops.findAndCountAll({ where: { createdAt: { [Op.gte]: moment().subtract(7, 'days').t...

Issue: In order to start in a clean environment for developing stuff for a web app I would appreciate to be able to retrieve some data from an existing DB (let say the 10 first lines of every table...

I have been struggling with the db:seed:all for over an hour now and slowly I am losing my mind about this. I have a simple model: 'use strict'; module.exports = function (sequelize, DataTypes) {...

I have installed Postgres 13 in windows 10. Configured all the right credentials in the environment file of the project. The project uses the below dependencies and it was created in ubuntu. "...

I have added a model and a migration file using this command node_modules/.bin/sequelize model:generate --name User --attributes firstName:string,lastName:string,email:string Now I wanted to ad...

I've two models: user.js 'use strict' module.exports = function(sequelize, DataTypes) { var User = sequelize.define('User', { gid: { type: DataTypes.INTEGER, allowNull: false, prim...

I am new to Sequelize and my current project requires me to use it with migrations. I am familiar with migrations what they do and how. I am coming from Django background where each sub app has mo...

I am trying to use a raw sql query in sequelize and have this code. My table structure is an external_profile that has many connections. const users = await models.sequelize.query("SELECT `Extern...

I want to use sequelize seeders and migrations on my express api and currently all the models are written in typescript using sequelize-typescript I tried adding my first seeder file using typescri...

First off it's my first time with Sequelize so be patient. I'd like to use https://github.com/sequelize/cli along with https://github.com/lorenwest/node-config I want sequelize to be able to "com...

I'm using Node Express with Sequelize and I want to set the defaultValue for the column "date" in the database to todays date. I tried with the following migration, but it didn't work, as it set th...

I'm using the sequelize ORM to fetch data from a PSQL DB. However, when I retrieve something, a whole bunch of data is given. The only data I want is inside 'dataValues'. Of course, I can use objec...

I need to remove the existing foreign key constraint on a column and add a new constraint with same name which refers to primary key of another table. I am getting an error ERROR: Constraint type m...

I manually deleted a migration file name 20171125081136-create-task.js. After deleting the migration file, I ran this command db:migrate:undo:all While running this command I'm getting an erro...

I am setting up a test infrastructure using docker-compose. I want to use the docker-compose option --exit-code-from to return the exit code from the container that is running tests. However, I als...

anyone knows why i am getting this error this is my code "use strict"; const { DataTypes } = require("sequelize/types"); module.exports = { up: async (queryInterface, DataType...

I'm trying to set up the project using Node v14.3 and sequelize. I don't want to use babel-register. Instead of this I set "type": "module" in my package.json and use all ES6 - ES11 features out ...

I am trying to migrate DB using db:migrate function, however I am getting the error printed: ERROR: Cannot read property 'replace' of undefined I have referred to other solutions for this erro...

I tried to find a way to copy/clone instances in Sequelize but without success. Is there any way to do it with a built-in function or without? What I want is to simply copy rows in the database and...

I've been trying to write some seeds for my project, but I've ran into a bit of a snag. I've got a many-to-many relation with my users and roles table. So, when I'm seeding the database I need to ...

I have been searching through Sequelize documentation and forums for the correct syntax and it seems I am doing it the right way, but for some reason the password field is still being returned in t...