Initial release

[websub-hub] / src / db / sqlite / sql / topic-attempts-increment.sql

diff --git a/src/db/sqlite/sql/topic-attempts-increment.sql b/src/db/sqlite/sql/topic-attempts-increment.sql
new file mode 100644 (file)
index 0000000..fae888f
--- /dev/null
+++ b/src/db/sqlite/sql/topic-attempts-increment.sql
@@ -0,0 +1,6 @@
+--
+UPDATE topic SET
+       content_fetch_attempts_since_success = content_fetch_attempts_since_success + 1,
+       content_fetch_next_attempt = strftime('%s', 'now') + :nextAttemptDelaySeconds
+WHERE
+       id = :topicId