git.squeep.com Git - squeep-indie-auther/blob - src/db/sqlite/sql/scope-upsert.sql

   1 --
   2 INSERT INTO scope (
   3         scope,
   4         description,
   5         application,
   6         is_manually_added
   7 ) VALUES (
   8         :scope,
   9         CASE WHEN :application IS NULL THEN '' ELSE :application END,
  10         CASE WHEN :description IS NULL THEN '' ELSE :description END,
  11         COALESCE(:manuallyAdded, false)
  12 ) ON CONFLICT (scope) DO UPDATE
  13 SET
  14         application = COALESCE(:application, EXCLUDED.application),
  15         description = COALESCE(:description, EXCLUDED.description),
  16         is_manually_added = EXCLUDED.is_manually_added OR COALESCE(:manuallyAdded, false)