I'm trying to use the ARRAY datatype for Sequelize (Node.js SQL ORM) with PostgreSQL. However I'm not exactly sure how to utilize it. I know how to set it on th
I already have my server application written in Node, PostgreSQL, Sequelize using Fastify. Now I would like to use TypeScript. Can anyone tell me how to begin
I am using Sequelize to map objects to my already existing database, in this database they didnt use the auto-generated timestamps, they did their own datetime
I am trying to insert multiple rows on 2 related tables using sequelize with mysql. Based on sequelize transaction cannot insert because of foreign key? I trie
I have created my models using the sequelize-auto package and used them in my controllers const sequelize = require('../database/db'); var models = require("../
I am trying to generate a query using QueryGenerator.selectQuery. let query = models.sequelize.dialect.QueryGenerator.selectQuery('table', { include: [{
I want to set the status of Cars model to done based on JobCard Model status Cars.update({ status: 'done' }, {
i am trying to create select with "custom" attribute. Everything is working fine except that the "custom" attribute is not included. Query is generated correctl
I'm trying to docerize my NodeJS API together with a MySQL image. Before the initial run, I want to run Sequelize migrations and seeds to have the tables up and
Provided that you're looking for something based on its primary key and don't want to include any additional options, does it matter whether you use findOne or
Heroku recently posted a list of some good tips for postgres. I was most intreged by the Track the Source of Your Queries section. I was curious if this was som
I want to make restful app in nodejs Server: centos 7 64x Database: postgresql Additional: express, sequelize Table: datetime with timezone When I selecting r
I am having Product table with following columns [id, name, CategoryId] and Category table with [id, name] Product Model:- module.exports = function(sequelize,
I'm trying to use Sequelize and node js to connect to a MS Sql server database and i have the following error when i try to test the post route in Postman: "Con
I have been trying to implement Admin Bro with my existing mysql sequelized database. I get plain Admin panel and it works fine, however when i try to fetch db
I am new to node.js and sequelize. I have already built a mysql db with sequelize that matches my needs for the actual project. Then I searched for possibiliti
I try to create a table using sequelize it goes fine with no error but instead of creating a table is show this message as a result Executing (default): SELECT
I try to create a table using sequelize it goes fine with no error but instead of creating a table is show this message as a result Executing (default): SELECT
I'm creating a Node apps with sequelize mysql To create table I usually using command with npx sequelize-cli model:generate --name ...... etc. It turns out my
In my model there is a Users table, and a UserPhones table. User.id is a foreign key in UserPhones. module.exports = (sequelize, DataTypes) => { const Use