I have used sequelize and had to write a custom SELECT query. I also have to perform sorting based on the parameter passed by user. So I decided to use replacements. The query looks something like this: sequelize.query( "SELECT SUM(amount),…
I am trying to connect to Postgres using docker in github actions. Here is my github actions file: name: Carbon Link backend server CI on: push: branches: [ 'develop', 'PC-3-setup-github-actions-on-pr-request' ] pull_request: branches: [ 'develop', 'PC-3-setup-github-actions-on-pr-request' ] jobs: # label…
I have an app with postgres as db, sequelize, and express, and whenever it receives a db query, it just stays there forever, no logging or anything I run postgres in a container which I can connect to through GUI…
I am trying to set my Sequelize associations correctly so that all my "include" data is pulled when I make requests. I have seen the information in the docs relating to this however it is a bit hard to understand…
I have created my first backend server using node, express, sequelize and nodemon. I have also set-up the tables I want and initialise the data I want inputted into set tables when it runs (to save me time inputting it…
I'm trying to deploy a web-app and the database is a MySQL database that I'm connected to via Sequelize. Generally I use PostgreSQL, but the web hosting uses MySQL with access via phpMyAdmin. I have a api & db query…
I am trying to connect a MySQL database which is in a docker container to a node app, which has sequelize installed and is in another container. I have got a bridge network setup between the 2 containers and the…
I am a beginner to Sequelize and the concept of ORMs altogether. I have successfully converted my query to Sequelize findAll() function but it returns unwanted result. The PostgreSQL query works and returns the result perfectly fine. Tables with Relationships:…