essential_node_db_sql::insert

Constant FAILED_BLOCK

source
pub const FAILED_BLOCK: &str = "INSERT \n    OR IGNORE INTO failed_block (block_id, solution_id)\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    );\n";
Expand description
INSERT 
    OR IGNORE INTO failed_block (block_id, solution_id)
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)
    );