essential_node_db_sql::insert

Constant PUB_VAR

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