git.squeep.com Git - websub-hub/blob - src/db/sqlite/sql/topic-upsert.sql

   1 --
   2 INSERT INTO topic
   3         (url, lease_seconds_preferred, lease_seconds_min, lease_seconds_max, publisher_validation_url)
   4 VALUES (
   5         :url,
   6         :leaseSecondsPreferred,
   7         :leaseSecondsMin,
   8         :leaseSecondsMax,
   9         :publisherValidationUrl
  10 ) ON CONFLICT (url) DO UPDATE
  11 SET
  12         is_deleted = 0,
  13         lease_seconds_preferred = :leaseSecondsPreferred,
  14         lease_seconds_min = :leaseSecondsMin,
  15         lease_seconds_max = :leaseSecondsMax,
  16         publisher_validation_url = :publisherValidationUrl
  17 RETURNING id