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

   1 --
   2 INSERT INTO subscription
   3         (topic_id, callback, verified, expires, secret, http_remote_addr, http_from)
   4 VALUES
   5         (:topicId, :callback, strftime('%s', 'now'), strftime('%s', 'now') + :leaseSeconds, :secret, :httpRemoteAddr, :httpFrom)
   6 ON CONFLICT (topic_id, callback) DO UPDATE
   7 SET
   8         verified = strftime('%s', 'now'),
   9         expires = strftime('%s', 'now') + :leaseSeconds,
  10         secret = :secret,
  11         http_remote_addr = :httpRemoteAddr,
  12         http_from = :httpFrom