Enhance SQL Query to Perform Insert or Update in a Single Operation

[jibedoubleve]

Refactoring

This code can be updated to use the update or create query in SQLite

    private class Sql
    {
        // ...
        public const string UpdateDbVersion = "update settings set s_value = '{0}' where lower(s_key) = 'db_version'";
       // ...
    }

How to

Here's an example:

INSERT INTO settings (s_key, s_value)
VALUES ('db_version', '{0}')
ON CONFLICT(s_key) DO UPDATE SET
    s_value = '{0}'
WHERE lower(s_key) = 'db_version';