essential_node_db_sql::insert

Constant SOLUTION_DATA

Source
pub const SOLUTION_DATA: &str = "INSERT\n    OR IGNORE INTO solution_data (solution_id, data_index, contract_addr, predicate_addr)\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, :contract_addr, :predicate_addr\n    )";
Expand description
INSERT
    OR IGNORE INTO solution_data (solution_id, data_index, contract_addr, predicate_addr)
VALUES
    (
        (
            SELECT
                id
            FROM
                solution
            WHERE
                content_hash = :solution_hash
            LIMIT
                1
        ), :data_index, :contract_addr, :predicate_addr
    )