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.

1 files changed, 1 insertions, 8 deletions

diff --git a/update.php b/update.php
index d2a1287d1..471e323c8 100755
--- a/update.php
+++ b/update.php
@@ -33,14 +33,7 @@
 	}
 
 	function cleanup_tags(int $days = 14, int $limit = 1000): int {
-
-		$days = (int) $days;
-
-		if (Config::get(Config::DB_TYPE) == "pgsql") {
-			$interval_query = "e.date_updated < NOW() - INTERVAL '$days days'";
-		} else /*if (Config::get(Config::DB_TYPE) == "mysql") */ {
-			$interval_query = "e.date_updated < DATE_SUB(NOW(), INTERVAL $days DAY)";
-		}
+		$interval_query = Db::past_comparison_qpart('e.date_updated', '<', $days, 'day');
 
 		$tags_deleted = 0;
 		$limit_part = 500;