I send requests using postman. And when I send request “POST” for create product (or another requests: GET, PUT , etc), I have problem: I can’t figure out how I can send a query to my database to get this right. I use express, sequelize and sequelize-cli, mysql2. And also i have migrations f…
Tag: sequelize.js
How to fill the middle table of an n:m association with the methode fooInstance.createBar() with Sequelize
I want to fill the data into a N:M jointure table with the methods provided by sequelize. As my data is in allowNull: false, i can’t add the data afterward :/ Here an exemple of code/BDD: my table a: my table b: my table c: I want to be able to do something like this: How can i achieve something
How to seed a one file only with sequelize-cli?
sequqlize-cli db:seed:all is working fine, but how to seed only one file? Tried to db:seed:[name-that-i-gave-with-create-command] and db:seed:[full-path-to-seed-file.js] but it doesnt work. It outputs nothing. Docs say sequelize db:seed Run specified seeder But how to do that? Answer To run a specific seed in…
Model Include option to return attributes as single value with defined alias instead of an object with properties
I have 2 models: Property Account A Property hasOne Account Property Account On a findAll query I have This returns an object for each item like; However, what I aim to achieve is something like, The current MySQL query is as follows; I need to update the aliases used from; to How can I achieve this? It seems…
Apply filters to a list and show data
Front-end: After return(): Service.js: Controller.js: So, this page of my web-app serves to show a list of all the companies saved in my database. I created a filter that allows you to show only those of a certain type, via findByType. I would like to insert other filters such as: findByRevenue, findByEmploye…
Why sequelize ignore the references property?
I using sequelize: I have two tables in my sql database: user and task. task_user_id in task table has references to user table: So why when I run findAll function I don’t get the user details inside the object I’m getting? Maybe something missing in my code? task.ts: user.ts: Answer In order to r…
Error [ERR_UNSUPPORTED_DIR_IMPORT]: Directory import when attempting to start Nodejs App locally
I’m caught in a bit of a loop trying to deploy my app to Heroku. My import statements (e.g. import cors from ‘cors’) seem to prevent the app from launching in production, due to the “Cannot Load ES6 Modules in Common JS” error. Locally it runs just fine. However, when I attempt t…
How to display Sequelize validation error messages in Express API
I have this Organization model used in a Node.js/Express API with Sequelize ORM running MySQL. When I violate the 2-100 character rule under validation in the first code example below I get the classic err item from the catch block in the second code example, which doesn’t contain any information about …
AuthenticationController always throws error, TypeError: Cannot read property ‘create’ of undefined
I have an issue with the Authenticati onController used with sequelize and sqlite When I test the POST request using postman, it always gives status 400 with the response { error: ‘Something is wrong’ } This is the log ::1 – – [21/Jul/2020:15:40:33 +0000] “POST /register HTTP/1.1…
Sequelize CLI migration error “Cannot read property ‘type’ of undefined” when creating table with db:migrate
I’m running yarn sequelize db:migrate to create the table in the database using a postgres image in the docker and returns the following message: Configuration of the .sequelizerc file: Code to create the table in the file migrations.js: OS: Linux Focal Fossa 20.04 LTS Would anyone know what the possibl…