1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
let batchUpdateSql=`
update
transaction
set
is_free=tmp.is_free ,
is_stable=tmp.is_stable ,
is_fork=tmp.is_fork ,
is_invalid=tmp.is_invalid ,
is_fail=tmp.is_fail ,
is_on_mc=tmp.is_on_mc
from
(values " +
"('B5956299E1BC73B23A56D4CC1C58D42F2D494808FBDEE073259B48F571CCE97C',false,false,false,false,false,false)," +
"('5F2B6FA741A33CDD506C5E150E37FCC73842082B24948A7159DFEB4C07500A08',false,false,false,false,false,false)" +
")
as tmp
(hash,is_free,is_stable,is_fork,is_invalid,is_fail,is_on_mc)
where
transaction.hash = tmp.hash
`;
pgclient.query(batchUpdateSql, (res) => {
//ROLLBACK
console.log(res);
});
|