All files / src/Metadata queries.ts

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
43x
 
 
 
 
 
 
 
 
 
43x
 
 
 
 
 
 
 
 
 
export const findTxMetadataByTxHashes = `
SELECT
  key,
  bytes,
  hash AS tx_id
FROM tx_metadata AS meta
JOIN tx ON tx_id = tx.id
WHERE hash = ANY($1)
ORDER BY meta.id ASC`;
 
export const findTxMetadataByTxIds = `
SELECT
  key,
  bytes,
  hash AS tx_id
FROM tx_metadata AS meta
JOIN tx ON tx_id = tx.id
WHERE tx.id = ANY($1)
ORDER BY meta.id ASC`;