pub const BLOCK: &str = "INSERT\n OR IGNORE INTO block (\n block_address,\n parent_block_id,\n number,\n timestamp_secs,\n timestamp_nanos\n )\nVALUES\n (\n :block_address,\n (\n SELECT\n COALESCE(\n (\n SELECT\n id\n FROM\n block\n WHERE\n block_address = :parent_block_address\n ),\n 0 -- Default to for big bang block to it\'s own parent\n )\n ),\n :number,\n :timestamp_secs,\n :timestamp_nanos\n );";
Expand description
INSERT
OR IGNORE INTO block (
block_address,
parent_block_id,
number,
timestamp_secs,
timestamp_nanos
)
VALUES
(
:block_address,
(
SELECT
COALESCE(
(
SELECT
id
FROM
block
WHERE
block_address = :parent_block_address
),
0 -- Default to for big bang block to it's own parent
)
),
:number,
:timestamp_secs,
:timestamp_nanos
);