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