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

   1 --
   2 INSERT INTO resource
   3         (resource_id, secret, description)
   4 VALUES  (:resourceId, :secret, :description)
   5 ON CONFLICT (resource_id) DO UPDATE
   6 SET
   7         secret = COALESCE(EXCLUDED.secret, resource.secret),
   8         description = COALESCE(EXCLUDED.description, resource.description)
   9 RETURNING *