All files / src/Utxo/DbSyncUtxoProvider queries.ts

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
26
27
28
29
30
31
32
33
34
35
36
37
41x
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
export const findUtxosByAddresses = `
SELECT 
  tx_outer.address,
  tx_outer.value AS coins,
  tx_outer.index,
  tx_outer.inline_datum_id,
  tx_outer.reference_script_id,
  ENCODE(tx.hash, 'hex') AS tx_id,
  ma_tx_out.quantity AS asset_quantity,
  ENCODE(asset.name,'hex') AS asset_name,
  ENCODE(asset.policy,'hex') AS asset_policy,
  ENCODE(tx_outer.data_hash,'hex') AS data_hash,
  ENCODE(datum.bytes, 'hex') AS inline_datum,
  script.type AS reference_script_type,
  script.json AS reference_script_json,
  ENCODE(script.bytes, 'hex') AS reference_script_bytes
FROM tx_out AS tx_outer
JOIN tx ON tx.id = tx_outer.tx_id 
LEFT JOIN ma_tx_out 
  ON ma_tx_out.tx_out_id = tx_outer.id
LEFT JOIN multi_asset as asset
  ON asset.id = ma_tx_out.ident
LEFT JOIN datum
  ON datum.id = tx_outer.inline_datum_id
LEFT JOIN script
  ON script.id = tx_outer.reference_script_id
WHERE NOT EXISTS
  ( SELECT tx_out.id
  FROM tx_out
  JOIN tx_in on
  tx_out.tx_id = tx_in.tx_out_id AND
  tx_out.index = tx_in.tx_out_index
WHERE tx_outer.id = tx_out.id
  ) AND address = ANY($1)
ORDER BY tx_outer.id, ma_tx_out.id ASC
`;