git.squeep.com Git - websub-hub/blob - src/db/postgres/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)::text::interval,
   7         $(leaseSecondsMin)::text::interval,
   8         $(leaseSecondsMax)::text::interval,
   9         $(publisherValidationUrl)
  10 ) ON CONFLICT (url) DO UPDATE
  11 SET
  12         is_deleted = false,
  13         lease_seconds_preferred = $(leaseSecondsPreferred)::text::interval,
  14         lease_seconds_min = $(leaseSecondsMin)::text::interval,
  15         lease_seconds_max = $(leaseSecondsMax)::text::interval,
  16         publisher_validation_url = $(publisherValidationUrl)
  17 RETURNING id