From: Justin Wind <justin.wind+git@gmail.com>
Date: Tue, 5 Apr 2022 17:29:09 +0000 (-0700)
Subject: include topic cache fields in db responses
X-Git-Tag: v1.3.7^2~3
X-Git-Url: http://git.squeep.com/?p=websub-hub;a=commitdiff_plain;h=76dd4f22c9798de72645d960e7603e6c73595199

include topic cache fields in db responses
---

diff --git a/src/db/postgres/sql/topic-get-by-id.sql b/src/db/postgres/sql/topic-get-by-id.sql
index aa18336..598b675 100644
--- 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_type
+	content_type,
+	http_etag,
+	http_last_modified
 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 adc9ffb..13aa67c 100644
--- 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_type
+	content_type,
+	http_etag,
+	http_last_modified
 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 86ea7ed..4c1affd 100644
--- 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_type
+	content_type,
+	http_etag,
+	http_last_modified
 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 d0f5548..b6e9c21 100644
--- 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_type
+	content_type,
+	http_etag,
+	http_last_modified
 FROM topic
 WHERE url = :topicUrl