essential_builder_db::sql::insert

Constant SUBMISSION

source 
pub const SUBMISSION: &str = "INSERT INTO submission (solution_id, timestamp_secs, timestamp_nanos)\nVALUES (\n    (\n        SELECT id\n        FROM solution\n        WHERE content_addr = :solution_addr\n        LIMIT 1\n    ),\n    :timestamp_secs,\n    :timestamp_nanos\n)\n";
Expand description
INSERT INTO submission (solution_id, timestamp_secs, timestamp_nanos)
VALUES (
    (
        SELECT id
        FROM solution
        WHERE content_addr = :solution_addr
        LIMIT 1
    ),
    :timestamp_secs,
    :timestamp_nanos
)