projects
/
websub-hub
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
71efac9
)
include topic cache fields in db responses
author
Justin Wind
<justin.wind+git@gmail.com>
Tue, 5 Apr 2022 17:29:09 +0000
(10:29 -0700)
committer
Justin Wind
<justin.wind+git@gmail.com>
Tue, 5 Apr 2022 17:29:09 +0000
(10:29 -0700)
src/db/postgres/sql/topic-get-by-id.sql
patch
|
blob
|
history
src/db/postgres/sql/topic-get-by-url.sql
patch
|
blob
|
history
src/db/sqlite/sql/topic-get-by-id.sql
patch
|
blob
|
history
src/db/sqlite/sql/topic-get-by-url.sql
patch
|
blob
|
history
diff --git
a/src/db/postgres/sql/topic-get-by-id.sql
b/src/db/postgres/sql/topic-get-by-id.sql
index aa18336c2246a79481b43a1f9493d6ec9fa85350..598b6756b83f3dffe44079ab84d95463cd585696 100644
(file)
--- a/
src/db/postgres/sql/topic-get-by-id.sql
+++ b/
src/db/postgres/sql/topic-get-by-id.sql
@@
-15,6
+15,8
@@
SELECT
content_fetch_attempts_since_success,
content_updated,
content_hash,
content_fetch_attempts_since_success,
content_updated,
content_hash,
- content_type
+ content_type,
+ http_etag,
+ http_last_modified
FROM topic
WHERE id = $(topicId)
FROM topic
WHERE id = $(topicId)
diff --git
a/src/db/postgres/sql/topic-get-by-url.sql
b/src/db/postgres/sql/topic-get-by-url.sql
index adc9ffbc47722e01ce054b9ec547ba6fb14818bc..13aa67c9373bf0c2f2b5c48aa44744ec18e80291 100644
(file)
--- a/
src/db/postgres/sql/topic-get-by-url.sql
+++ b/
src/db/postgres/sql/topic-get-by-url.sql
@@
-15,6
+15,8
@@
SELECT
content_fetch_attempts_since_success,
content_updated,
content_hash,
content_fetch_attempts_since_success,
content_updated,
content_hash,
- content_type
+ content_type,
+ http_etag,
+ http_last_modified
FROM topic
WHERE url = $(topicUrl)
FROM topic
WHERE url = $(topicUrl)
diff --git
a/src/db/sqlite/sql/topic-get-by-id.sql
b/src/db/sqlite/sql/topic-get-by-id.sql
index 86ea7ed81341691eceda765c646c564a12256724..4c1affd243b44cf39a23ed311f45e7bd759be42e 100644
(file)
--- a/
src/db/sqlite/sql/topic-get-by-id.sql
+++ b/
src/db/sqlite/sql/topic-get-by-id.sql
@@
-15,6
+15,8
@@
SELECT
content_fetch_attempts_since_success,
content_updated,
content_hash,
content_fetch_attempts_since_success,
content_updated,
content_hash,
- content_type
+ content_type,
+ http_etag,
+ http_last_modified
FROM topic
WHERE id = :topicId
FROM topic
WHERE id = :topicId
diff --git
a/src/db/sqlite/sql/topic-get-by-url.sql
b/src/db/sqlite/sql/topic-get-by-url.sql
index d0f554852f298e2e30f7ac0f245f9b64f06570ad..b6e9c21da388e240087ae243e949883a0533d620 100644
(file)
--- a/
src/db/sqlite/sql/topic-get-by-url.sql
+++ b/
src/db/sqlite/sql/topic-get-by-url.sql
@@
-15,6
+15,8
@@
SELECT
content_fetch_attempts_since_success,
content_updated,
content_hash,
content_fetch_attempts_since_success,
content_updated,
content_hash,
- content_type
+ content_type,
+ http_etag,
+ http_last_modified
FROM topic
WHERE url = :topicUrl
FROM topic
WHERE url = :topicUrl