diff options
| author | wn_ <invalid@email.com> | 2025-03-04 18:00:28 +0000 |
|---|---|---|
| committer | wn_ <invalid@email.com> | 2025-03-04 18:34:35 +0000 |
| commit | 89b0332d3861ce2d9b37c690a32c98e961d7e219 (patch) | |
| tree | e933c36f22eb1d929406278f3b2a3a60d8467f01 /classes/RPC.php | |
| parent | 532570ca17f1120a4bfc07195080e5e6a3c469fd (diff) | |
Add and use 'Db::now_comparison_qpart()'.
This introduces a helper to build a query part comparing a field against a past datetime (determined by '$now - $some_interval'), eliminating certain boilerplate code.
Diffstat (limited to 'classes/RPC.php')
| -rw-r--r-- | classes/RPC.php | 13 |
1 files changed, 3 insertions, 10 deletions
diff --git a/classes/RPC.php b/classes/RPC.php index 03786beaa..82f85fc11 100644 --- a/classes/RPC.php +++ b/classes/RPC.php @@ -281,11 +281,8 @@ class RPC extends Handler_Protected { } // Test if feed is currently being updated by another process. - if (Config::get(Config::DB_TYPE) == "pgsql") { - $updstart_thresh_qpart = "AND (last_update_started IS NULL OR last_update_started < NOW() - INTERVAL '5 minutes')"; - } else { - $updstart_thresh_qpart = "AND (last_update_started IS NULL OR last_update_started < DATE_SUB(NOW(), INTERVAL 5 MINUTE))"; - } + $updstart_thresh_qpart = 'AND (last_update_started IS NULL OR ' + . Db::past_comparison_qpart('last_update_started', '<', 5, 'minute') . ')'; $random_qpart = Db::sql_random_function(); @@ -528,11 +525,7 @@ class RPC extends Handler_Protected { $data["labels"] = Labels::get_all($_SESSION["uid"]); if (Config::get(Config::LOG_DESTINATION) == 'sql' && $_SESSION['access_level'] >= UserHelper::ACCESS_LEVEL_ADMIN) { - if (Config::get(Config::DB_TYPE) == 'pgsql') { - $log_interval = "created_at > NOW() - interval '1 hour'"; - } else { - $log_interval = "created_at > DATE_SUB(NOW(), INTERVAL 1 HOUR)"; - } + $log_interval = Db::past_comparison_qpart('created_at', '>', 1, 'hour'); $sth = $pdo->prepare("SELECT COUNT(id) AS cid FROM ttrss_error_log |