essential_node_db_sql::insert

Constant DEC_VAR

source
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
    );