essential_node_db_sql::insert

Constant CONTRACT_PREDICATE

source 
pub const CONTRACT_PREDICATE: &str = "INSERT OR IGNORE INTO\n    contract_predicate (contract_id, predicate_id)\nVALUES\n    (\n        (SELECT id FROM contract WHERE content_hash = :contract_hash LIMIT 1),\n        (SELECT id FROM predicate WHERE content_hash = :predicate_hash LIMIT 1)\n    );\n";
Expand description
INSERT OR IGNORE INTO
    contract_predicate (contract_id, predicate_id)
VALUES
    (
        (SELECT id FROM contract WHERE content_hash = :contract_hash LIMIT 1),
        (SELECT id FROM predicate WHERE content_hash = :predicate_hash LIMIT 1)
    );