diff options
| author | Andrew Dolgov <fox@fakecake.org> | 2025-03-08 11:58:11 +0000 |
|---|---|---|
| committer | Andrew Dolgov <fox@fakecake.org> | 2025-03-08 11:58:11 +0000 |
| commit | 1fc4eed6cd9d887b52ea09bab6bd1ff75c79c25c (patch) | |
| tree | 5291f35577606b4ca3984fa770aba6b2a989a636 /classes/Digest.php | |
| parent | 9983954bf1e303a9c3136c199c1c08c4f4ed0eef (diff) | |
| parent | 89b0332d3861ce2d9b37c690a32c98e961d7e219 (diff) | |
Merge branch 'feature/time-comparison-gen' into 'master'
Add and use 'Db::past_comparison_qpart()'.
See merge request tt-rss/tt-rss!105
Diffstat (limited to 'classes/Digest.php')
| -rw-r--r-- | classes/Digest.php | 12 |
1 files changed, 2 insertions, 10 deletions
diff --git a/classes/Digest.php b/classes/Digest.php index 3ce2693f3..05b735510 100644 --- a/classes/Digest.php +++ b/classes/Digest.php @@ -7,11 +7,7 @@ class Digest Debug::log("Sending digests, batch of max $user_limit users, headline limit = $limit"); - if (Config::get(Config::DB_TYPE) == "pgsql") { - $interval_qpart = "last_digest_sent < NOW() - INTERVAL '1 days'"; - } else /* if (Config::get(Config::DB_TYPE) == "mysql") */ { - $interval_qpart = "last_digest_sent < DATE_SUB(NOW(), INTERVAL 1 DAY)"; - } + $interval_qpart = Db::past_comparison_qpart('last_digest_sent', '<', 1, 'day'); $pdo = Db::pdo(); @@ -107,11 +103,7 @@ class Digest $affected_ids = array(); - if (Config::get(Config::DB_TYPE) == "pgsql") { - $interval_qpart = "ttrss_entries.date_updated > NOW() - INTERVAL '$days days'"; - } else /* if (Config::get(Config::DB_TYPE) == "mysql") */ { - $interval_qpart = "ttrss_entries.date_updated > DATE_SUB(NOW(), INTERVAL $days DAY)"; - } + $interval_qpart = Db::past_comparison_qpart('ttrss_entries.date_updated', '>', $days, 'day'); $pdo = Db::pdo(); |