All Questions
11,926
questions
0
votes
1
answer
19
views
How do I search an entry in database by the same search phrase for two separate models with reference in sequelize?
I'm trying to make a search in a database for invoices. In the server request handler I have only one thing: searchPhrase. So I have to search invoice by serial number of the invoice, and also by ...
- 123
0
votes
0
answers
32
views
Error connecting to the database: getaddrinfo ENOTFOUND when trying to connect to mysql container using node js
and I keep getting this error when trying to connect to my mysql image through in node.js project
Error connecting to the database: getaddrinfo ENOTFOUND 98b6c7aeb8af
I can access the container fine ...
0
votes
0
answers
12
views
Deploy MERN app on cpanel and whm using physical server
I am trying to install my development project on server for production throw cpanel and whm, server is physical and I am using ubuntu, what is the steps, without affecting any other deployed websites, ...
0
votes
0
answers
25
views
I am unable to filter data in many to many relationship in sequelize
I have three tables/models in sequelize, Teachers, Classes, and Divisions. I have established many to many relationship between Teachers and Divisions. and One to Many relationship between Classes and ...
- 23
0
votes
0
answers
91
views
Nest js, TypeOrm Connection close issue
I'm using NestJs, and Typeorm (MySQL driver). From time to time I get the 'Connection lost: The server closed the connection.' error.
The server that I'm using closes the connection after 10-15 ...
- 71
0
votes
1
answer
30
views
Sequelize query to filter records created one year ago based on created_at date
I'm working with Sequelize in a Node.js application and need to write a query that retrieves data where the created_at date is exactly one year old.
Here's the current query I'm using:
const newGrants ...
0
votes
0
answers
14
views
How to solve many-to-many relationship for inserting an element in Sequelize?
I have the following tables in my MySQL database:
CREATE TABLE idi_ma_products (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(200),
image VARCHAR(255),
created_date DATE,
...
0
votes
0
answers
17
views
Trouble Generating Tables Automatically in Nodejs Using Sequelize mySQL 2
I'm encountering an issue where I'm unable to automatically create an "employee" table using Sequelize in my Node.js application. Strangely, while my "user" table gets created ...
0
votes
0
answers
36
views
Multiple http requests to backend with nodejs and sequelize
I am developing a service in NodeJS using Express and Sequelize as ORM. I am also using the Serverless Offline plugin to emulate AWS Lambdas and I also deploy my backend in AWS Lambdas. My question is ...
- 1
0
votes
1
answer
181
views
Inconsistent behavior with Sequelize .forEach() in MySQL vs. SQLite when updating records
I encountered a strange behavior with Sequelize when using MySQL. This script creates a table with one column and then seeds a record into this table. It then uses .forEach() and for (const ... of ...)...
- 656
0
votes
0
answers
39
views
import SQL data into a database using Node.js and Sequelize
optimizing the execution time for inserting a large volume of data into the database using Sequelize
Initially, I was running around 20,000 queries individually through Sequelize, but it was taking ...
- 1
0
votes
0
answers
12
views
Connect VPS Server with my mysql database [duplicate]
I have hostinger VPS server and there I uploaded the node.js code with all its necessary modules. But when I try to connect with database using GET API, It gives error
{ "success": false, ...
0
votes
1
answer
23
views
Getting error in fetching data with Sequelize for Mysql Database (Backend Node.js)
I am using Sequelize ORM with mysql database for nodejs application. Somewhere I am stuck with one api whose job is just to show list based on the queryparam values. Issue is when I am not applying ...
0
votes
0
answers
28
views
Sequelize findAndCountAll with literal count and having clause and subquery getting column not found on subquery column for count,
Sequelize findAndCountAll with having clause and subquery getting column not found on subquery column for count,
tried subQuery:false and subQuery:true but not worked,
tried with finAll but i need ...
- 3
1
vote
1
answer
88
views
Prisma One to Many relation not visible in database and connect option not working
this is Prisma Schema
generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "mysql"
url = env("DATABASE_URL")
relationMode = ...
