Constant BLOCK

Source
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
    );