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

   1 -- claim a specific topic needing the content fetched
   2 INSERT INTO topic_fetch_in_progress (id, claimant, claimed, claim_expires)
   3 VALUES (:topicId, :claimant, strftime('%s', 'now'), strftime('%s', 'now') + :claimTimeoutSeconds)
   4 ON CONFLICT (id) DO UPDATE
   5 SET
   6         claimant = :claimant,
   7         claimed = strftime('%s', 'now'),
   8         claim_expires = strftime('%s', 'now') + :claimTimeoutSeconds