essential_node_db_sql::query

Constant GET_CONTRACT_PREDICATES

source 
pub const GET_CONTRACT_PREDICATES: &str = "SELECT\n    predicate.predicate\nFROM\n    contract_predicate\n    JOIN contract ON contract_predicate.contract_id = contract.id\n    JOIN predicate ON contract_predicate.predicate_id = predicate.id\nWHERE\n    contract.content_hash = :contract_hash\nORDER BY\n    contract_predicate.id ASC;\n";
Expand description
SELECT
    predicate.predicate
FROM
    contract_predicate
    JOIN contract ON contract_predicate.contract_id = contract.id
    JOIN predicate ON contract_predicate.predicate_id = predicate.id
WHERE
    contract.content_hash = :contract_hash
ORDER BY
    contract_predicate.id ASC;