essential_node_db_sql::query

Constant GET_BLOCK

Source
pub const GET_BLOCK: &str = "SELECT\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.block_address = :block_address\nORDER BY\n    block_solution.solution_index ASC\n";
Expand description
SELECT
    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.block_address = :block_address
ORDER BY
    block_solution.solution_index ASC