I have working query: It returns total count for all columns that has code=1081 and 1082 in “Region” table. In “Region” table there is “code” row that has 5 different codes. It’s a primary key to GeograpicalAdministrativeAreas table. I need to calculate for each colum…
Tag: sequelize.js
How to use group by in sql? (I need sequelize)
I have But it fails with this error: Works fine without GROUP BY Answer The GROUP BY statement groups rows that have the same values into summary rows, in your case, it is the country_code. It is often used with aggregate functions (COUNT(), MAX(), MIN(), SUM(), AVG()) to group the result-set by one or more c…
Converting a SQL query to SEQUELIZE
I am trying to wrap my head around creating this sequelize query. I have been able to create 2 separate queries where the ‘order by filter’ works and ‘aliases’ work, but not combined. This is what i currenty have in sequelize Answer You just need to use fn twice: in order and in attrib…
Sequelize: Avoid Race Condition When Updating Field with Unique Value?
I have a field in my postgres db called authorizedUserNumber. This field is set by default to 0, and does not auto-increment, because it is only asigned when a user has been fully onboarded. Okay, so let’s say a new user has been fully onboarded and I want to assign a unique number to the field authoriz…
Sequelize how to return result as a 2D array instead of array of objects?
I am using Sequelize query() method as follows: Because I am selecting two columns with identical names (colname), in the result, I am getting something like: [{ “colname”: “val1” }, { “colname”: “val2” }…], and this array contains values only from the col…
Sequelize : How to query posts list from user id list?
To learn a little bit how a back end application works i’m currently creating a small instagram-like app using nodejs and sequelize (reactjs for the front). I have 3 SQL tables : Users id (pk) username email password Posts id (pk) userId (fk) message mediaUrl Following id (pk) userId (fk) followingId (f…
Nest Postgresql Sequelize one-to-one Error with ForeignKey
My Table Has one-to-one connection with table But when i try add some data in second table< i got an Error – Nest error insert or update on table “checkingResults” violates foreign key constraint “checkingResults_resultId_fkey” What happened? I try any thing… And how i r…
Sequelize raw query update array of objects as replacements
I am using sequelize (postgres) and I need to properly escape a query like this: Sample input.pets: Does anyone have an idea how to achieve this with replacements? I have found a thread on github which suggested something like this: However, a 2d array is being used here not an array of objects. Is there a wa…
How can I convert SQL-query to Sequelize?
I have this SQL query: It returns the last message in the given chat. But I don’t understand at all how to execute this moment IN (SELECT MAX(messages.id) FROM messages GROUP BY messages.chatId)) AS lastMessage ON chats.id = lastMessage.chatId in Sequelize… Answer You can use Sequelize.literal lik…
Sequelize – How to get reviews for post with likes count for each review
I have a function like this. It receives comments on the post. And it doesn’t work – it makes endless requests. If we remove this line, the function returns one comment with counted likes. And if you remove this block: … then the function will return an ARRAY of comments. Why does the like c…