git.squeep.com Git - websub-hub/blob - src/db/sqlite/sql/verification-claim-by-id.sql

   1 --
   2 INSERT INTO verification_in_progress
   3         (id, topic_id, callback, claimant, claim_expires)
   4 SELECT id, topic_id, callback, :claimant AS claimant, strftime('%s', 'now') + :claimTimeoutSeconds AS claim_expires
   5         FROM verification
   6         WHERE id = :verificationId
   7 ON CONFLICT (id) DO UPDATE
   8 SET
   9         claimant = :claimant,
  10         claimed = strftime('%s', 'now'),
  11         claim_expires = strftime('%s', 'now') + :claimTimeoutSeconds