Skip to content

Instantly share code, notes, and snippets.

@alphamikle
Created February 11, 2021 18:22
Show Gist options
  • Save alphamikle/aa8563642cc59c4d6282af704c421c65 to your computer and use it in GitHub Desktop.
Save alphamikle/aa8563642cc59c4d6282af704c421c65 to your computer and use it in GitHub Desktop.
START TRANSACTION
// ...
SELECT "User"."id" AS "User_id", "User"."name" AS "User_name", "User"."defaultPurseId" AS "User_defaultPurseId"
FROM "user" "User"
WHERE "User"."id" IN ($1)
START TRANSACTION // <-- this transaction from appServiceV2 😩
UPDATE "purse"
SET "balance" = $2
WHERE "id" IN ($1)
COMMIT
SELECT "Purse"."id" AS "Purse_id", "Purse"."balance" AS "Purse_balance", "Purse"."userId" AS "Purse_userId"
FROM "purse" "Purse"
WHERE "Purse"."id" IN ($1)
UPDATE "purse"
SET "balance" = $2
WHERE "id" IN ($1)
COMMIT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment