Cobain
Explore posts from serversDTDrizzle Team
•Created by Cobain on 4/29/2024 in #help
Delete and insert a record using deleted id in one transaction
Hi! I want to delete a record and use the deleted id to insert another one later in the same table. Is it possible to do so in a single transaction? The problem I'm encountering when doing this is I get a primary key error on insertion.
1 replies
DTDrizzle Team
•Created by Cobain on 4/25/2024 in #help
Struggling with subqueries
I want to basically do this query in drizzle:
SELECT o.id, o.date, t.currency
FROM "Operations" o
LEFT JOIN "Transactions" t ON o."id" = t."operationId"
WHERE o.id IN (
SELECT DISTINCT t."operationId"
FROM "Transactions" t
WHERE t.currency = 'usd'
ORDER BY t."operationId" DESC
LIMIT 8
);
Im using postgres-js and the problem is how to select those operations from the subquery.
This query is just a mock, but the reason to do the subquery is that I have to put conditions on both the operations and the transactions table, and if i just make a join of these queries and put the conditions, i will get the last 8 transactions for example, when what I really want is the last 8 operations and all their related transactions (meaning possibly more than 8 rows), even the ones whose currency isn't 'usd' for example. Doing raw sql it works as intended but I hoped to get it working with drizzle
Suggestions? Thanks in advance
3 replies