essential_node_db_sql::query

Constant LIST_UNCHECKED_BLOCKS

Source
pub const LIST_UNCHECKED_BLOCKS: &str = "SELECT\n    block.block_address,\n    block.number,\n    block.timestamp_secs,\n    block.timestamp_nanos,\n    solution.content_hash\nFROM\n    block\n    LEFT JOIN block_solution ON block.id = block_solution.block_id\n    LEFT JOIN solution ON block_solution.solution_id = solution.id\nWHERE\n    block.number >= :start_block AND block.number < :end_block\n    AND\n    NOT EXISTS (SELECT 1 FROM failed_block WHERE block_id = block.id)\nORDER BY\n    block.number ASC,\n    block.block_address ASC,\n    block_solution.solution_index ASC\n";
Expand description
SELECT
    block.block_address,
    block.number,
    block.timestamp_secs,
    block.timestamp_nanos,
    solution.content_hash
FROM
    block
    LEFT JOIN block_solution ON block.id = block_solution.block_id
    LEFT JOIN solution ON block_solution.solution_id = solution.id
WHERE
    block.number >= :start_block AND block.number < :end_block
    AND
    NOT EXISTS (SELECT 1 FROM failed_block WHERE block_id = block.id)
ORDER BY
    block.number ASC,
    block.block_address ASC,
    block_solution.solution_index ASC