move object_user_visits cleanup into garbage_collector, fixes #3113

Closes #3113

Merge request studip/studip!2278

1 files changed, 34 insertions, 0 deletions

diff --git a/db/migrations/5.5.1_tic_3113_remove_cronjob.php b/db/migrations/5.5.1_tic_3113_remove_cronjob.php
new file mode 100644
index 0000000..d883f2e
--- /dev/null
+++ b/db/migrations/5.5.1_tic_3113_remove_cronjob.php
@@ -0,0 +1,34 @@
+<?php
+
+class Tic3113RemoveCronjob extends Migration
+{
+    public function description()
+    {
+        return 'Removes the cleanup cronjob for the table "object_user_visits"';
+    }
+
+    public function up()
+    {
+        $query = 'DELETE `cronjobs_tasks`, `cronjobs_schedules`, `cronjobs_logs`
+                  FROM `cronjobs_tasks`
+                  LEFT JOIN `cronjobs_schedules` USING (`task_id`)
+                  LEFT JOIN `cronjobs_logs` USING (`schedule_id`)
+                  WHERE `filename` = :filename';
+
+        DBManager::get()->execute($query, [
+            ':filename' => 'lib/cronjobs/clean_object_user_visits.php'
+        ]);
+    }
+
+    public function down()
+    {
+        $query = 'INSERT INTO `cronjobs_tasks` (`task_id`, `filename`, `class`)
+                  VALUES (:task_id, :filename, :class)';
+
+        DBManager::get()->execute($query, [
+            ':task_id'  => '7cb4134a91bd985263fd570c7560ad72',
+            ':filename' => 'lib/cronjobs/clean_object_user_visits.php',
+            ':class'    => 'CleanObjectUserVisits',
+        ]);
+    }
+}