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