essential_node_db_sql::query

Constant LIST_CONTRACTS

source 
pub const LIST_CONTRACTS: &str = "SELECT\n    contract.l2_block_number,\n    contract.salt,\n    contract.content_hash,\n    predicate.predicate\nFROM\n    contract\n    JOIN contract_predicate ON contract.id = contract_predicate.contract_id\n    JOIN predicate ON contract_predicate.predicate_id = predicate.id\nWHERE\n    contract.l2_block_number >= :start_block AND contract.l2_block_number < :end_block\nORDER BY\n    contract.l2_block_number ASC, contract_predicate.id ASC;\n";
Expand description
SELECT
    contract.l2_block_number,
    contract.salt,
    contract.content_hash,
    predicate.predicate
FROM
    contract
    JOIN contract_predicate ON contract.id = contract_predicate.contract_id
    JOIN predicate ON contract_predicate.predicate_id = predicate.id
WHERE
    contract.l2_block_number >= :start_block AND contract.l2_block_number < :end_block
ORDER BY
    contract.l2_block_number ASC, contract_predicate.id ASC;