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 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_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 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_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 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_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 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_type
+       content_type,
+       http_etag,
+       http_last_modified
 FROM topic
 WHERE url = :topicUrl