bump package version to 1.1.0
[squeep-indie-auther] / 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 *