pub const BLOCK_SOLUTION_SET: &str = "INSERT OR IGNORE INTO\n block_solution_set (block_id, solution_set_id, solution_set_index)\nVALUES\n (\n (SELECT id FROM block WHERE block.block_address = :block_address LIMIT 1),\n (SELECT id FROM solution_set WHERE solution_set.content_addr = :solution_set_addr LIMIT 1),\n :solution_set_index\n );\n";
Expand description
INSERT OR IGNORE INTO
block_solution_set (block_id, solution_set_id, solution_set_index)
VALUES
(
(SELECT id FROM block WHERE block.block_address = :block_address LIMIT 1),
(SELECT id FROM solution_set WHERE solution_set.content_addr = :solution_set_addr LIMIT 1),
:solution_set_index
);