essential_node_db_sql::update

Constant DELETE_STATE

source
pub const DELETE_STATE: &str = "DELETE FROM\n    state\nWHERE\n    contract_id = (\n        SELECT\n            contract.id\n        FROM\n            contract\n        WHERE\n            contract.content_hash = :contract_hash\n    )\n    AND KEY = :key;\n";
Expand description
DELETE FROM
    state
WHERE
    contract_id = (
        SELECT
            contract.id
        FROM
            contract
        WHERE
            contract.content_hash = :contract_hash
    )
    AND KEY = :key;