More "item" traces removed

[friendica.git] / src / Worker / Expire.php

diff --git a/src/Worker/Expire.php b/src/Worker/Expire.php
index 70a4f913a4a19f33d69469da3f2bd693da29f264..31c0af0397ae039e689e18e1977be4058840b588 100644 (file)
--- a/src/Worker/Expire.php
+++ b/src/Worker/Expire.php
@@ -44,31 +44,27 @@ class Expire
                        Logger::log('Delete expired items', Logger::DEBUG);
                        // physically remove anything that has been deleted for more than two months
                        $condition = ["`deleted` AND `changed` < UTC_TIMESTAMP() - INTERVAL 60 DAY"];
-                       $rows = DBA::select('item', ['id', 'guid', 'uri-id', 'uid'],  $condition);
-                       while ($row = DBA::fetch($rows)) {
+                       $rows = Post::select(['id', 'guid', 'uri-id', 'uid'],  $condition);
+                       while ($row = Post::fetch($rows)) {
                                Logger::info('Delete expired item', ['id' => $row['id'], 'guid' => $row['guid']]);
                                DBA::delete('item', ['id' => $row['id']]);
                                Post\User::delete(['uri-id' => $row['uri-id'], 'uid' => $row['uid']]);
+                               Post\ThreadUser::delete(['uri-id' => $row['uri-id'], 'uid' => $row['uid']]);
                        }
                        DBA::close($rows);
 
                        Logger::info('Deleting orphaned post-content - start');
                        /// @todo Replace "item with "post-user" in the future when "item" is removed
-                       $condition = ["NOT EXISTS (SELECT `uri-id` FROM `item` WHERE `item`.`uri-id` = `post-content`.`uri-id`)"];
+                       $condition = ["NOT EXISTS (SELECT `uri-id` FROM `post-user` WHERE `post-user`.`uri-id` = `post-content`.`uri-id`)"];
                        DBA::delete('post-content', $condition);
                        Logger::info('Orphaned post-content deleted', ['rows' => DBA::affectedRows()]);
 
                        Logger::info('Deleting orphaned post-thread - start');
                        /// @todo Replace "item with "post-user" in the future when "item" is removed
-                       $condition = ["NOT EXISTS (SELECT `uri-id` FROM `item` WHERE `item`.`uri-id` = `post-thread`.`uri-id`)"];
+                       $condition = ["NOT EXISTS (SELECT `uri-id` FROM `post-user` WHERE `post-user`.`uri-id` = `post-thread`.`uri-id`)"];
                        DBA::delete('post-thread', $condition);
                        Logger::info('Orphaned item content deleted', ['rows' => DBA::affectedRows()]);
 
-                       // make this optional as it could have a performance impact on large sites
-                       if (intval(DI::config()->get('system', 'optimize_items'))) {
-                               DBA::e("OPTIMIZE TABLE `item`");
-                       }
-
                        Logger::log('Delete expired items - done', Logger::DEBUG);
                        return;
                } elseif (intval($param) > 0) {