essential_node_db_sql::insert

Constant BLOCK_SOLUTION

Source
pub const BLOCK_SOLUTION: &str = "INSERT OR IGNORE INTO\n    block_solution (block_id, solution_id, solution_index)\nVALUES\n    (\n        (SELECT id FROM block WHERE block.block_address = :block_address LIMIT 1),\n        (SELECT id FROM solution WHERE solution.content_hash = :solution_hash LIMIT 1),\n        :solution_index\n    );\n";
Expand description
INSERT OR IGNORE INTO
    block_solution (block_id, solution_id, solution_index)
VALUES
    (
        (SELECT id FROM block WHERE block.block_address = :block_address LIMIT 1),
        (SELECT id FROM solution WHERE solution.content_hash = :solution_hash LIMIT 1),
        :solution_index
    );