essential_node_db_sql::update

Constant STATE

source 
pub const STATE: &str = "INSERT INTO state (contract_id, key, value)\nSELECT id, :key, :value\nFROM contract\nWHERE content_hash = :contract_hash\nON CONFLICT (contract_id, key) DO UPDATE SET value = EXCLUDED.value;\n";
Expand description
INSERT INTO state (contract_id, key, value)
SELECT id, :key, :value
FROM contract
WHERE content_hash = :contract_hash
ON CONFLICT (contract_id, key) DO UPDATE SET value = EXCLUDED.value;