essential_node_db_sql::insert

Constant MUTATION

source
pub const MUTATION: &str = "INSERT\n    OR IGNORE INTO mutation (\n        solution_id,\n        data_index,\n        mutation_index,\n        contract_ca,\n        key,\n        value\n    )\nVALUES\n    (\n        (\n            SELECT\n                id\n            FROM\n                solution\n            WHERE\n                content_hash = :solution_hash\n            LIMIT\n                1\n        ), :data_index, :mutation_index, :contract_ca, :key, :value\n    );";
Expand description
INSERT
    OR IGNORE INTO mutation (
        solution_id,
        data_index,
        mutation_index,
        contract_ca,
        key,
        value
    )
VALUES
    (
        (
            SELECT
                id
            FROM
                solution
            WHERE
                content_hash = :solution_hash
            LIMIT
                1
        ), :data_index, :mutation_index, :contract_ca, :key, :value
    );