Using Transaction with if-else in prepared statement
| От | Hui Jackson |
|---|---|
| Тема | Using Transaction with if-else in prepared statement |
| Дата | |
| Msg-id | CAHXAyjx-2MhO0zoCt3Vr_2AW6sFVjN0tgDo_GPVg=DVCzQDQMQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Using Transaction with if-else in prepared statement
Re: Using Transaction with if-else in prepared statement |
| Список | pgsql-sql |
I am trying to make transaction in nodejs
Error (node:10044) UnhandledPromiseRejectionWarning: error: bind message supplies 3 parameters, but prepared statement "" requires 0
The logic will be check if sufficient coin in sender's amount, if sufficient then do transaction.
I am new to postgres, not sure if this is a right way to do so, if you have a better solution, please let me know, thank you.
const coin = 10
const senderId = 1
const receiverId = 2
await pgPool.query(`
DO $$
BEGIN
if (SELECT coin from app_user where id = $1) >= $3 THEN
UPDATE app_user set coin = coin - $3 where id = $1;
UPDATE app_user set coin = coin + $3 where id = $2;
INSERT INTO coin_history(sender_id, receiver_id, amount) VALUES ($1, $2, $3)
END IF;
END;
$$`,[senderId, receiverId, coin]);
В списке pgsql-sql по дате отправления: