@@ -26,7 +26,7 @@ discard block |
||
26 | 26 | $dir = '/'; |
27 | 27 | |
28 | 28 | if (isset($_GET['dir'])) { |
29 | - $dir = (string)$_GET['dir']; |
|
29 | + $dir = (string)$_GET['dir']; |
|
30 | 30 | } |
31 | 31 | |
32 | 32 | OCP\JSON::checkLoggedIn(); |
@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | |
35 | 35 | // send back json |
36 | 36 | try { |
37 | - OCP\JSON::success(array('data' => \OCA\Files\Helper::buildFileStorageStatistics($dir))); |
|
37 | + OCP\JSON::success(array('data' => \OCA\Files\Helper::buildFileStorageStatistics($dir))); |
|
38 | 38 | } catch (\OCP\Files\NotFoundException $e) { |
39 | - OCP\JSON::error(['data' => ['message' => 'Folder not found']]); |
|
39 | + OCP\JSON::error(['data' => ['message' => 'Folder not found']]); |
|
40 | 40 | } |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | $files_list = json_decode($files); |
38 | 38 | // in case we get only a single file |
39 | 39 | if (!is_array($files_list)) { |
40 | - $files_list = array($files); |
|
40 | + $files_list = array($files); |
|
41 | 41 | } |
42 | 42 | |
43 | 43 | /** |
@@ -46,9 +46,9 @@ discard block |
||
46 | 46 | * alphanumeric characters |
47 | 47 | */ |
48 | 48 | if(isset($_GET['downloadStartSecret']) |
49 | - && !isset($_GET['downloadStartSecret'][32]) |
|
50 | - && preg_match('!^[a-zA-Z0-9]+$!', $_GET['downloadStartSecret']) === 1) { |
|
51 | - setcookie('ocDownloadStarted', $_GET['downloadStartSecret'], time() + 20, '/'); |
|
49 | + && !isset($_GET['downloadStartSecret'][32]) |
|
50 | + && preg_match('!^[a-zA-Z0-9]+$!', $_GET['downloadStartSecret']) === 1) { |
|
51 | + setcookie('ocDownloadStarted', $_GET['downloadStartSecret'], time() + 20, '/'); |
|
52 | 52 | } |
53 | 53 | |
54 | 54 | $server_params = array( 'head' => \OC::$server->getRequest()->getMethod() == 'HEAD' ); |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | * Http range requests support |
58 | 58 | */ |
59 | 59 | if (isset($_SERVER['HTTP_RANGE'])) { |
60 | - $server_params['range'] = \OC::$server->getRequest()->getHeader('Range'); |
|
60 | + $server_params['range'] = \OC::$server->getRequest()->getHeader('Range'); |
|
61 | 61 | } |
62 | 62 | |
63 | 63 | OC_Files::get($dir, $files_list, $server_params); |
@@ -27,22 +27,22 @@ |
||
27 | 27 | namespace OCA\Files; |
28 | 28 | |
29 | 29 | class App { |
30 | - /** |
|
31 | - * @var \OCP\INavigationManager |
|
32 | - */ |
|
33 | - private static $navigationManager; |
|
30 | + /** |
|
31 | + * @var \OCP\INavigationManager |
|
32 | + */ |
|
33 | + private static $navigationManager; |
|
34 | 34 | |
35 | - /** |
|
36 | - * Returns the app's navigation manager |
|
37 | - * |
|
38 | - * @return \OCP\INavigationManager |
|
39 | - */ |
|
40 | - public static function getNavigationManager() { |
|
41 | - // TODO: move this into a service in the Application class |
|
42 | - if (self::$navigationManager === null) { |
|
43 | - self::$navigationManager = new \OC\NavigationManager(); |
|
44 | - } |
|
45 | - return self::$navigationManager; |
|
46 | - } |
|
35 | + /** |
|
36 | + * Returns the app's navigation manager |
|
37 | + * |
|
38 | + * @return \OCP\INavigationManager |
|
39 | + */ |
|
40 | + public static function getNavigationManager() { |
|
41 | + // TODO: move this into a service in the Application class |
|
42 | + if (self::$navigationManager === null) { |
|
43 | + self::$navigationManager = new \OC\NavigationManager(); |
|
44 | + } |
|
45 | + return self::$navigationManager; |
|
46 | + } |
|
47 | 47 | |
48 | 48 | } |
@@ -29,23 +29,23 @@ |
||
29 | 29 | use OCP\Util; |
30 | 30 | |
31 | 31 | class SettingsController extends Controller { |
32 | - public function __construct($appName, IRequest $request) { |
|
33 | - parent::__construct($appName, $request); |
|
34 | - } |
|
32 | + public function __construct($appName, IRequest $request) { |
|
33 | + parent::__construct($appName, $request); |
|
34 | + } |
|
35 | 35 | |
36 | - /** |
|
37 | - * @param string $maxUploadSize |
|
38 | - * @return JSONResponse |
|
39 | - */ |
|
40 | - public function setMaxUploadSize($maxUploadSize) { |
|
41 | - $setMaxSize = \OC_Files::setUploadLimit(Util::computerFileSize($maxUploadSize)); |
|
36 | + /** |
|
37 | + * @param string $maxUploadSize |
|
38 | + * @return JSONResponse |
|
39 | + */ |
|
40 | + public function setMaxUploadSize($maxUploadSize) { |
|
41 | + $setMaxSize = \OC_Files::setUploadLimit(Util::computerFileSize($maxUploadSize)); |
|
42 | 42 | |
43 | - if ($setMaxSize === false) { |
|
44 | - return new JSONResponse([], Http::STATUS_BAD_REQUEST); |
|
45 | - } else { |
|
46 | - return new JSONResponse([ |
|
47 | - 'maxUploadSize' => Util::humanFileSize($setMaxSize) |
|
48 | - ]); |
|
49 | - } |
|
50 | - } |
|
43 | + if ($setMaxSize === false) { |
|
44 | + return new JSONResponse([], Http::STATUS_BAD_REQUEST); |
|
45 | + } else { |
|
46 | + return new JSONResponse([ |
|
47 | + 'maxUploadSize' => Util::humanFileSize($setMaxSize) |
|
48 | + ]); |
|
49 | + } |
|
50 | + } |
|
51 | 51 | } |
@@ -35,51 +35,51 @@ |
||
35 | 35 | */ |
36 | 36 | class DeleteOrphanedFiles extends Command { |
37 | 37 | |
38 | - const CHUNK_SIZE = 200; |
|
38 | + const CHUNK_SIZE = 200; |
|
39 | 39 | |
40 | - /** |
|
41 | - * @var IDBConnection |
|
42 | - */ |
|
43 | - protected $connection; |
|
40 | + /** |
|
41 | + * @var IDBConnection |
|
42 | + */ |
|
43 | + protected $connection; |
|
44 | 44 | |
45 | - public function __construct(IDBConnection $connection) { |
|
46 | - $this->connection = $connection; |
|
47 | - parent::__construct(); |
|
48 | - } |
|
45 | + public function __construct(IDBConnection $connection) { |
|
46 | + $this->connection = $connection; |
|
47 | + parent::__construct(); |
|
48 | + } |
|
49 | 49 | |
50 | - protected function configure() { |
|
51 | - $this |
|
52 | - ->setName('files:cleanup') |
|
53 | - ->setDescription('cleanup filecache'); |
|
54 | - } |
|
50 | + protected function configure() { |
|
51 | + $this |
|
52 | + ->setName('files:cleanup') |
|
53 | + ->setDescription('cleanup filecache'); |
|
54 | + } |
|
55 | 55 | |
56 | - public function execute(InputInterface $input, OutputInterface $output) { |
|
57 | - $deletedEntries = 0; |
|
56 | + public function execute(InputInterface $input, OutputInterface $output) { |
|
57 | + $deletedEntries = 0; |
|
58 | 58 | |
59 | - $query = $this->connection->getQueryBuilder(); |
|
60 | - $query->select('fc.fileid') |
|
61 | - ->from('filecache', 'fc') |
|
62 | - ->where($query->expr()->isNull('s.numeric_id')) |
|
63 | - ->leftJoin('fc', 'storages', 's', $query->expr()->eq('fc.storage', 's.numeric_id')) |
|
64 | - ->setMaxResults(self::CHUNK_SIZE); |
|
59 | + $query = $this->connection->getQueryBuilder(); |
|
60 | + $query->select('fc.fileid') |
|
61 | + ->from('filecache', 'fc') |
|
62 | + ->where($query->expr()->isNull('s.numeric_id')) |
|
63 | + ->leftJoin('fc', 'storages', 's', $query->expr()->eq('fc.storage', 's.numeric_id')) |
|
64 | + ->setMaxResults(self::CHUNK_SIZE); |
|
65 | 65 | |
66 | - $deleteQuery = $this->connection->getQueryBuilder(); |
|
67 | - $deleteQuery->delete('filecache') |
|
68 | - ->where($deleteQuery->expr()->eq('fileid', $deleteQuery->createParameter('objectid'))); |
|
66 | + $deleteQuery = $this->connection->getQueryBuilder(); |
|
67 | + $deleteQuery->delete('filecache') |
|
68 | + ->where($deleteQuery->expr()->eq('fileid', $deleteQuery->createParameter('objectid'))); |
|
69 | 69 | |
70 | - $deletedInLastChunk = self::CHUNK_SIZE; |
|
71 | - while ($deletedInLastChunk === self::CHUNK_SIZE) { |
|
72 | - $deletedInLastChunk = 0; |
|
73 | - $result = $query->execute(); |
|
74 | - while ($row = $result->fetch()) { |
|
75 | - $deletedInLastChunk++; |
|
76 | - $deletedEntries += $deleteQuery->setParameter('objectid', (int) $row['fileid']) |
|
77 | - ->execute(); |
|
78 | - } |
|
79 | - $result->closeCursor(); |
|
80 | - } |
|
70 | + $deletedInLastChunk = self::CHUNK_SIZE; |
|
71 | + while ($deletedInLastChunk === self::CHUNK_SIZE) { |
|
72 | + $deletedInLastChunk = 0; |
|
73 | + $result = $query->execute(); |
|
74 | + while ($row = $result->fetch()) { |
|
75 | + $deletedInLastChunk++; |
|
76 | + $deletedEntries += $deleteQuery->setParameter('objectid', (int) $row['fileid']) |
|
77 | + ->execute(); |
|
78 | + } |
|
79 | + $result->closeCursor(); |
|
80 | + } |
|
81 | 81 | |
82 | - $output->writeln("$deletedEntries orphaned file cache entries deleted"); |
|
83 | - } |
|
82 | + $output->writeln("$deletedEntries orphaned file cache entries deleted"); |
|
83 | + } |
|
84 | 84 | |
85 | 85 | } |
@@ -42,305 +42,305 @@ |
||
42 | 42 | |
43 | 43 | class Scan extends Base { |
44 | 44 | |
45 | - /** @var IUserManager $userManager */ |
|
46 | - private $userManager; |
|
47 | - /** @var float */ |
|
48 | - protected $execTime = 0; |
|
49 | - /** @var int */ |
|
50 | - protected $foldersCounter = 0; |
|
51 | - /** @var int */ |
|
52 | - protected $filesCounter = 0; |
|
45 | + /** @var IUserManager $userManager */ |
|
46 | + private $userManager; |
|
47 | + /** @var float */ |
|
48 | + protected $execTime = 0; |
|
49 | + /** @var int */ |
|
50 | + protected $foldersCounter = 0; |
|
51 | + /** @var int */ |
|
52 | + protected $filesCounter = 0; |
|
53 | 53 | |
54 | - public function __construct(IUserManager $userManager) { |
|
55 | - $this->userManager = $userManager; |
|
56 | - parent::__construct(); |
|
57 | - } |
|
54 | + public function __construct(IUserManager $userManager) { |
|
55 | + $this->userManager = $userManager; |
|
56 | + parent::__construct(); |
|
57 | + } |
|
58 | 58 | |
59 | - protected function configure() { |
|
60 | - parent::configure(); |
|
59 | + protected function configure() { |
|
60 | + parent::configure(); |
|
61 | 61 | |
62 | - $this |
|
63 | - ->setName('files:scan') |
|
64 | - ->setDescription('rescan filesystem') |
|
65 | - ->addArgument( |
|
66 | - 'user_id', |
|
67 | - InputArgument::OPTIONAL | InputArgument::IS_ARRAY, |
|
68 | - 'will rescan all files of the given user(s)' |
|
69 | - ) |
|
70 | - ->addOption( |
|
71 | - 'path', |
|
72 | - 'p', |
|
73 | - InputArgument::OPTIONAL, |
|
74 | - 'limit rescan to this path, eg. --path="/alice/files/Music", the user_id is determined by the path and the user_id parameter and --all are ignored' |
|
75 | - ) |
|
76 | - ->addOption( |
|
77 | - 'quiet', |
|
78 | - 'q', |
|
79 | - InputOption::VALUE_NONE, |
|
80 | - 'suppress any output' |
|
81 | - ) |
|
82 | - ->addOption( |
|
83 | - 'verbose', |
|
84 | - '-v|vv|vvv', |
|
85 | - InputOption::VALUE_NONE, |
|
86 | - 'verbose the output' |
|
87 | - ) |
|
88 | - ->addOption( |
|
89 | - 'all', |
|
90 | - null, |
|
91 | - InputOption::VALUE_NONE, |
|
92 | - 'will rescan all files of all known users' |
|
93 | - )->addOption( |
|
94 | - 'unscanned', |
|
95 | - null, |
|
96 | - InputOption::VALUE_NONE, |
|
97 | - 'only scan files which are marked as not fully scanned' |
|
98 | - ); |
|
99 | - } |
|
62 | + $this |
|
63 | + ->setName('files:scan') |
|
64 | + ->setDescription('rescan filesystem') |
|
65 | + ->addArgument( |
|
66 | + 'user_id', |
|
67 | + InputArgument::OPTIONAL | InputArgument::IS_ARRAY, |
|
68 | + 'will rescan all files of the given user(s)' |
|
69 | + ) |
|
70 | + ->addOption( |
|
71 | + 'path', |
|
72 | + 'p', |
|
73 | + InputArgument::OPTIONAL, |
|
74 | + 'limit rescan to this path, eg. --path="/alice/files/Music", the user_id is determined by the path and the user_id parameter and --all are ignored' |
|
75 | + ) |
|
76 | + ->addOption( |
|
77 | + 'quiet', |
|
78 | + 'q', |
|
79 | + InputOption::VALUE_NONE, |
|
80 | + 'suppress any output' |
|
81 | + ) |
|
82 | + ->addOption( |
|
83 | + 'verbose', |
|
84 | + '-v|vv|vvv', |
|
85 | + InputOption::VALUE_NONE, |
|
86 | + 'verbose the output' |
|
87 | + ) |
|
88 | + ->addOption( |
|
89 | + 'all', |
|
90 | + null, |
|
91 | + InputOption::VALUE_NONE, |
|
92 | + 'will rescan all files of all known users' |
|
93 | + )->addOption( |
|
94 | + 'unscanned', |
|
95 | + null, |
|
96 | + InputOption::VALUE_NONE, |
|
97 | + 'only scan files which are marked as not fully scanned' |
|
98 | + ); |
|
99 | + } |
|
100 | 100 | |
101 | - public function checkScanWarning($fullPath, OutputInterface $output) { |
|
102 | - $normalizedPath = basename(\OC\Files\Filesystem::normalizePath($fullPath)); |
|
103 | - $path = basename($fullPath); |
|
101 | + public function checkScanWarning($fullPath, OutputInterface $output) { |
|
102 | + $normalizedPath = basename(\OC\Files\Filesystem::normalizePath($fullPath)); |
|
103 | + $path = basename($fullPath); |
|
104 | 104 | |
105 | - if ($normalizedPath !== $path) { |
|
106 | - $output->writeln("\t<error>Entry \"" . $fullPath . '" will not be accessible due to incompatible encoding</error>'); |
|
107 | - } |
|
108 | - } |
|
105 | + if ($normalizedPath !== $path) { |
|
106 | + $output->writeln("\t<error>Entry \"" . $fullPath . '" will not be accessible due to incompatible encoding</error>'); |
|
107 | + } |
|
108 | + } |
|
109 | 109 | |
110 | - protected function scanFiles($user, $path, $verbose, OutputInterface $output, $backgroundScan = false) { |
|
111 | - $connection = $this->reconnectToDatabase($output); |
|
112 | - $scanner = new \OC\Files\Utils\Scanner($user, $connection, \OC::$server->getLogger()); |
|
113 | - # check on each file/folder if there was a user interrupt (ctrl-c) and throw an exception |
|
114 | - # printout and count |
|
115 | - if ($verbose) { |
|
116 | - $scanner->listen('\OC\Files\Utils\Scanner', 'scanFile', function ($path) use ($output) { |
|
117 | - $output->writeln("\tFile <info>$path</info>"); |
|
118 | - $this->filesCounter += 1; |
|
119 | - if ($this->hasBeenInterrupted()) { |
|
120 | - throw new \Exception('ctrl-c'); |
|
121 | - } |
|
122 | - }); |
|
123 | - $scanner->listen('\OC\Files\Utils\Scanner', 'scanFolder', function ($path) use ($output) { |
|
124 | - $output->writeln("\tFolder <info>$path</info>"); |
|
125 | - $this->foldersCounter += 1; |
|
126 | - if ($this->hasBeenInterrupted()) { |
|
127 | - throw new \Exception('ctrl-c'); |
|
128 | - } |
|
129 | - }); |
|
130 | - $scanner->listen('\OC\Files\Utils\Scanner', 'StorageNotAvailable', function (StorageNotAvailableException $e) use ($output) { |
|
131 | - $output->writeln("Error while scanning, storage not available (" . $e->getMessage() . ")"); |
|
132 | - }); |
|
133 | - # count only |
|
134 | - } else { |
|
135 | - $scanner->listen('\OC\Files\Utils\Scanner', 'scanFile', function () use ($output) { |
|
136 | - $this->filesCounter += 1; |
|
137 | - if ($this->hasBeenInterrupted()) { |
|
138 | - throw new \Exception('ctrl-c'); |
|
139 | - } |
|
140 | - }); |
|
141 | - $scanner->listen('\OC\Files\Utils\Scanner', 'scanFolder', function () use ($output) { |
|
142 | - $this->foldersCounter += 1; |
|
143 | - if ($this->hasBeenInterrupted()) { |
|
144 | - throw new \Exception('ctrl-c'); |
|
145 | - } |
|
146 | - }); |
|
147 | - } |
|
148 | - $scanner->listen('\OC\Files\Utils\Scanner', 'scanFile', function($path) use ($output) { |
|
149 | - $this->checkScanWarning($path, $output); |
|
150 | - }); |
|
151 | - $scanner->listen('\OC\Files\Utils\Scanner', 'scanFolder', function($path) use ($output) { |
|
152 | - $this->checkScanWarning($path, $output); |
|
153 | - }); |
|
110 | + protected function scanFiles($user, $path, $verbose, OutputInterface $output, $backgroundScan = false) { |
|
111 | + $connection = $this->reconnectToDatabase($output); |
|
112 | + $scanner = new \OC\Files\Utils\Scanner($user, $connection, \OC::$server->getLogger()); |
|
113 | + # check on each file/folder if there was a user interrupt (ctrl-c) and throw an exception |
|
114 | + # printout and count |
|
115 | + if ($verbose) { |
|
116 | + $scanner->listen('\OC\Files\Utils\Scanner', 'scanFile', function ($path) use ($output) { |
|
117 | + $output->writeln("\tFile <info>$path</info>"); |
|
118 | + $this->filesCounter += 1; |
|
119 | + if ($this->hasBeenInterrupted()) { |
|
120 | + throw new \Exception('ctrl-c'); |
|
121 | + } |
|
122 | + }); |
|
123 | + $scanner->listen('\OC\Files\Utils\Scanner', 'scanFolder', function ($path) use ($output) { |
|
124 | + $output->writeln("\tFolder <info>$path</info>"); |
|
125 | + $this->foldersCounter += 1; |
|
126 | + if ($this->hasBeenInterrupted()) { |
|
127 | + throw new \Exception('ctrl-c'); |
|
128 | + } |
|
129 | + }); |
|
130 | + $scanner->listen('\OC\Files\Utils\Scanner', 'StorageNotAvailable', function (StorageNotAvailableException $e) use ($output) { |
|
131 | + $output->writeln("Error while scanning, storage not available (" . $e->getMessage() . ")"); |
|
132 | + }); |
|
133 | + # count only |
|
134 | + } else { |
|
135 | + $scanner->listen('\OC\Files\Utils\Scanner', 'scanFile', function () use ($output) { |
|
136 | + $this->filesCounter += 1; |
|
137 | + if ($this->hasBeenInterrupted()) { |
|
138 | + throw new \Exception('ctrl-c'); |
|
139 | + } |
|
140 | + }); |
|
141 | + $scanner->listen('\OC\Files\Utils\Scanner', 'scanFolder', function () use ($output) { |
|
142 | + $this->foldersCounter += 1; |
|
143 | + if ($this->hasBeenInterrupted()) { |
|
144 | + throw new \Exception('ctrl-c'); |
|
145 | + } |
|
146 | + }); |
|
147 | + } |
|
148 | + $scanner->listen('\OC\Files\Utils\Scanner', 'scanFile', function($path) use ($output) { |
|
149 | + $this->checkScanWarning($path, $output); |
|
150 | + }); |
|
151 | + $scanner->listen('\OC\Files\Utils\Scanner', 'scanFolder', function($path) use ($output) { |
|
152 | + $this->checkScanWarning($path, $output); |
|
153 | + }); |
|
154 | 154 | |
155 | - try { |
|
156 | - if ($backgroundScan) { |
|
157 | - $scanner->backgroundScan($path); |
|
158 | - }else { |
|
159 | - $scanner->scan($path); |
|
160 | - } |
|
161 | - } catch (ForbiddenException $e) { |
|
162 | - $output->writeln("<error>Home storage for user $user not writable</error>"); |
|
163 | - $output->writeln("Make sure you're running the scan command only as the user the web server runs as"); |
|
164 | - } catch (\Exception $e) { |
|
165 | - if ($e->getMessage() !== 'ctrl-c') { |
|
166 | - $output->writeln('<error>Exception while scanning: ' . $e->getMessage() . "\n" . $e->getTraceAsString() . '</error>'); |
|
167 | - } |
|
168 | - return; |
|
169 | - } |
|
170 | - } |
|
155 | + try { |
|
156 | + if ($backgroundScan) { |
|
157 | + $scanner->backgroundScan($path); |
|
158 | + }else { |
|
159 | + $scanner->scan($path); |
|
160 | + } |
|
161 | + } catch (ForbiddenException $e) { |
|
162 | + $output->writeln("<error>Home storage for user $user not writable</error>"); |
|
163 | + $output->writeln("Make sure you're running the scan command only as the user the web server runs as"); |
|
164 | + } catch (\Exception $e) { |
|
165 | + if ($e->getMessage() !== 'ctrl-c') { |
|
166 | + $output->writeln('<error>Exception while scanning: ' . $e->getMessage() . "\n" . $e->getTraceAsString() . '</error>'); |
|
167 | + } |
|
168 | + return; |
|
169 | + } |
|
170 | + } |
|
171 | 171 | |
172 | 172 | |
173 | - protected function execute(InputInterface $input, OutputInterface $output) { |
|
174 | - $inputPath = $input->getOption('path'); |
|
175 | - if ($inputPath) { |
|
176 | - $inputPath = '/' . trim($inputPath, '/'); |
|
177 | - list (, $user,) = explode('/', $inputPath, 3); |
|
178 | - $users = array($user); |
|
179 | - } else if ($input->getOption('all')) { |
|
180 | - $users = $this->userManager->search(''); |
|
181 | - } else { |
|
182 | - $users = $input->getArgument('user_id'); |
|
183 | - } |
|
173 | + protected function execute(InputInterface $input, OutputInterface $output) { |
|
174 | + $inputPath = $input->getOption('path'); |
|
175 | + if ($inputPath) { |
|
176 | + $inputPath = '/' . trim($inputPath, '/'); |
|
177 | + list (, $user,) = explode('/', $inputPath, 3); |
|
178 | + $users = array($user); |
|
179 | + } else if ($input->getOption('all')) { |
|
180 | + $users = $this->userManager->search(''); |
|
181 | + } else { |
|
182 | + $users = $input->getArgument('user_id'); |
|
183 | + } |
|
184 | 184 | |
185 | - # no messaging level option means: no full printout but statistics |
|
186 | - # $quiet means no print at all |
|
187 | - # $verbose means full printout including statistics |
|
188 | - # -q -v full stat |
|
189 | - # 0 0 no yes |
|
190 | - # 0 1 yes yes |
|
191 | - # 1 -- no no (quiet overrules verbose) |
|
192 | - $verbose = $input->getOption('verbose'); |
|
193 | - $quiet = $input->getOption('quiet'); |
|
194 | - # restrict the verbosity level to VERBOSITY_VERBOSE |
|
195 | - if ($output->getVerbosity()>OutputInterface::VERBOSITY_VERBOSE) { |
|
196 | - $output->setVerbosity(OutputInterface::VERBOSITY_VERBOSE); |
|
197 | - } |
|
198 | - if ($quiet) { |
|
199 | - $verbose = false; |
|
200 | - } |
|
185 | + # no messaging level option means: no full printout but statistics |
|
186 | + # $quiet means no print at all |
|
187 | + # $verbose means full printout including statistics |
|
188 | + # -q -v full stat |
|
189 | + # 0 0 no yes |
|
190 | + # 0 1 yes yes |
|
191 | + # 1 -- no no (quiet overrules verbose) |
|
192 | + $verbose = $input->getOption('verbose'); |
|
193 | + $quiet = $input->getOption('quiet'); |
|
194 | + # restrict the verbosity level to VERBOSITY_VERBOSE |
|
195 | + if ($output->getVerbosity()>OutputInterface::VERBOSITY_VERBOSE) { |
|
196 | + $output->setVerbosity(OutputInterface::VERBOSITY_VERBOSE); |
|
197 | + } |
|
198 | + if ($quiet) { |
|
199 | + $verbose = false; |
|
200 | + } |
|
201 | 201 | |
202 | - # check quantity of users to be process and show it on the command line |
|
203 | - $users_total = count($users); |
|
204 | - if ($users_total === 0) { |
|
205 | - $output->writeln("<error>Please specify the user id to scan, \"--all\" to scan for all users or \"--path=...\"</error>"); |
|
206 | - return; |
|
207 | - } else { |
|
208 | - if ($users_total > 1) { |
|
209 | - $output->writeln("\nScanning files for $users_total users"); |
|
210 | - } |
|
211 | - } |
|
202 | + # check quantity of users to be process and show it on the command line |
|
203 | + $users_total = count($users); |
|
204 | + if ($users_total === 0) { |
|
205 | + $output->writeln("<error>Please specify the user id to scan, \"--all\" to scan for all users or \"--path=...\"</error>"); |
|
206 | + return; |
|
207 | + } else { |
|
208 | + if ($users_total > 1) { |
|
209 | + $output->writeln("\nScanning files for $users_total users"); |
|
210 | + } |
|
211 | + } |
|
212 | 212 | |
213 | - $this->initTools(); |
|
213 | + $this->initTools(); |
|
214 | 214 | |
215 | - $user_count = 0; |
|
216 | - foreach ($users as $user) { |
|
217 | - if (is_object($user)) { |
|
218 | - $user = $user->getUID(); |
|
219 | - } |
|
220 | - $path = $inputPath ? $inputPath : '/' . $user; |
|
221 | - $user_count += 1; |
|
222 | - if ($this->userManager->userExists($user)) { |
|
223 | - # add an extra line when verbose is set to optical separate users |
|
224 | - if ($verbose) {$output->writeln(""); } |
|
225 | - $output->writeln("Starting scan for user $user_count out of $users_total ($user)"); |
|
226 | - # full: printout data if $verbose was set |
|
227 | - $this->scanFiles($user, $path, $verbose, $output, $input->getOption('unscanned')); |
|
228 | - } else { |
|
229 | - $output->writeln("<error>Unknown user $user_count $user</error>"); |
|
230 | - } |
|
231 | - # check on each user if there was a user interrupt (ctrl-c) and exit foreach |
|
232 | - if ($this->hasBeenInterrupted()) { |
|
233 | - break; |
|
234 | - } |
|
235 | - } |
|
215 | + $user_count = 0; |
|
216 | + foreach ($users as $user) { |
|
217 | + if (is_object($user)) { |
|
218 | + $user = $user->getUID(); |
|
219 | + } |
|
220 | + $path = $inputPath ? $inputPath : '/' . $user; |
|
221 | + $user_count += 1; |
|
222 | + if ($this->userManager->userExists($user)) { |
|
223 | + # add an extra line when verbose is set to optical separate users |
|
224 | + if ($verbose) {$output->writeln(""); } |
|
225 | + $output->writeln("Starting scan for user $user_count out of $users_total ($user)"); |
|
226 | + # full: printout data if $verbose was set |
|
227 | + $this->scanFiles($user, $path, $verbose, $output, $input->getOption('unscanned')); |
|
228 | + } else { |
|
229 | + $output->writeln("<error>Unknown user $user_count $user</error>"); |
|
230 | + } |
|
231 | + # check on each user if there was a user interrupt (ctrl-c) and exit foreach |
|
232 | + if ($this->hasBeenInterrupted()) { |
|
233 | + break; |
|
234 | + } |
|
235 | + } |
|
236 | 236 | |
237 | - # stat: printout statistics if $quiet was not set |
|
238 | - if (!$quiet) { |
|
239 | - $this->presentStats($output); |
|
240 | - } |
|
241 | - } |
|
237 | + # stat: printout statistics if $quiet was not set |
|
238 | + if (!$quiet) { |
|
239 | + $this->presentStats($output); |
|
240 | + } |
|
241 | + } |
|
242 | 242 | |
243 | - /** |
|
244 | - * Initialises some useful tools for the Command |
|
245 | - */ |
|
246 | - protected function initTools() { |
|
247 | - // Start the timer |
|
248 | - $this->execTime = -microtime(true); |
|
249 | - // Convert PHP errors to exceptions |
|
250 | - set_error_handler([$this, 'exceptionErrorHandler'], E_ALL); |
|
251 | - } |
|
243 | + /** |
|
244 | + * Initialises some useful tools for the Command |
|
245 | + */ |
|
246 | + protected function initTools() { |
|
247 | + // Start the timer |
|
248 | + $this->execTime = -microtime(true); |
|
249 | + // Convert PHP errors to exceptions |
|
250 | + set_error_handler([$this, 'exceptionErrorHandler'], E_ALL); |
|
251 | + } |
|
252 | 252 | |
253 | - /** |
|
254 | - * Processes PHP errors as exceptions in order to be able to keep track of problems |
|
255 | - * |
|
256 | - * @see https://secure.php.net/manual/en/function.set-error-handler.php |
|
257 | - * |
|
258 | - * @param int $severity the level of the error raised |
|
259 | - * @param string $message |
|
260 | - * @param string $file the filename that the error was raised in |
|
261 | - * @param int $line the line number the error was raised |
|
262 | - * |
|
263 | - * @throws \ErrorException |
|
264 | - */ |
|
265 | - public function exceptionErrorHandler($severity, $message, $file, $line) { |
|
266 | - if (!(error_reporting() & $severity)) { |
|
267 | - // This error code is not included in error_reporting |
|
268 | - return; |
|
269 | - } |
|
270 | - throw new \ErrorException($message, 0, $severity, $file, $line); |
|
271 | - } |
|
253 | + /** |
|
254 | + * Processes PHP errors as exceptions in order to be able to keep track of problems |
|
255 | + * |
|
256 | + * @see https://secure.php.net/manual/en/function.set-error-handler.php |
|
257 | + * |
|
258 | + * @param int $severity the level of the error raised |
|
259 | + * @param string $message |
|
260 | + * @param string $file the filename that the error was raised in |
|
261 | + * @param int $line the line number the error was raised |
|
262 | + * |
|
263 | + * @throws \ErrorException |
|
264 | + */ |
|
265 | + public function exceptionErrorHandler($severity, $message, $file, $line) { |
|
266 | + if (!(error_reporting() & $severity)) { |
|
267 | + // This error code is not included in error_reporting |
|
268 | + return; |
|
269 | + } |
|
270 | + throw new \ErrorException($message, 0, $severity, $file, $line); |
|
271 | + } |
|
272 | 272 | |
273 | - /** |
|
274 | - * @param OutputInterface $output |
|
275 | - */ |
|
276 | - protected function presentStats(OutputInterface $output) { |
|
277 | - // Stop the timer |
|
278 | - $this->execTime += microtime(true); |
|
279 | - $output->writeln(""); |
|
273 | + /** |
|
274 | + * @param OutputInterface $output |
|
275 | + */ |
|
276 | + protected function presentStats(OutputInterface $output) { |
|
277 | + // Stop the timer |
|
278 | + $this->execTime += microtime(true); |
|
279 | + $output->writeln(""); |
|
280 | 280 | |
281 | - $headers = [ |
|
282 | - 'Folders', 'Files', 'Elapsed time' |
|
283 | - ]; |
|
281 | + $headers = [ |
|
282 | + 'Folders', 'Files', 'Elapsed time' |
|
283 | + ]; |
|
284 | 284 | |
285 | - $this->showSummary($headers, null, $output); |
|
286 | - } |
|
285 | + $this->showSummary($headers, null, $output); |
|
286 | + } |
|
287 | 287 | |
288 | - /** |
|
289 | - * Shows a summary of operations |
|
290 | - * |
|
291 | - * @param string[] $headers |
|
292 | - * @param string[] $rows |
|
293 | - * @param OutputInterface $output |
|
294 | - */ |
|
295 | - protected function showSummary($headers, $rows, OutputInterface $output) { |
|
296 | - $niceDate = $this->formatExecTime(); |
|
297 | - if (!$rows) { |
|
298 | - $rows = [ |
|
299 | - $this->foldersCounter, |
|
300 | - $this->filesCounter, |
|
301 | - $niceDate, |
|
302 | - ]; |
|
303 | - } |
|
304 | - $table = new Table($output); |
|
305 | - $table |
|
306 | - ->setHeaders($headers) |
|
307 | - ->setRows([$rows]); |
|
308 | - $table->render(); |
|
309 | - } |
|
288 | + /** |
|
289 | + * Shows a summary of operations |
|
290 | + * |
|
291 | + * @param string[] $headers |
|
292 | + * @param string[] $rows |
|
293 | + * @param OutputInterface $output |
|
294 | + */ |
|
295 | + protected function showSummary($headers, $rows, OutputInterface $output) { |
|
296 | + $niceDate = $this->formatExecTime(); |
|
297 | + if (!$rows) { |
|
298 | + $rows = [ |
|
299 | + $this->foldersCounter, |
|
300 | + $this->filesCounter, |
|
301 | + $niceDate, |
|
302 | + ]; |
|
303 | + } |
|
304 | + $table = new Table($output); |
|
305 | + $table |
|
306 | + ->setHeaders($headers) |
|
307 | + ->setRows([$rows]); |
|
308 | + $table->render(); |
|
309 | + } |
|
310 | 310 | |
311 | 311 | |
312 | - /** |
|
313 | - * Formats microtime into a human readable format |
|
314 | - * |
|
315 | - * @return string |
|
316 | - */ |
|
317 | - protected function formatExecTime() { |
|
318 | - list($secs, $tens) = explode('.', sprintf("%.1f", ($this->execTime))); |
|
312 | + /** |
|
313 | + * Formats microtime into a human readable format |
|
314 | + * |
|
315 | + * @return string |
|
316 | + */ |
|
317 | + protected function formatExecTime() { |
|
318 | + list($secs, $tens) = explode('.', sprintf("%.1f", ($this->execTime))); |
|
319 | 319 | |
320 | - # if you want to have microseconds add this: . '.' . $tens; |
|
321 | - return date('H:i:s', $secs); |
|
322 | - } |
|
320 | + # if you want to have microseconds add this: . '.' . $tens; |
|
321 | + return date('H:i:s', $secs); |
|
322 | + } |
|
323 | 323 | |
324 | - /** |
|
325 | - * @return \OCP\IDBConnection |
|
326 | - */ |
|
327 | - protected function reconnectToDatabase(OutputInterface $output) { |
|
328 | - /** @var Connection | IDBConnection $connection*/ |
|
329 | - $connection = \OC::$server->getDatabaseConnection(); |
|
330 | - try { |
|
331 | - $connection->close(); |
|
332 | - } catch (\Exception $ex) { |
|
333 | - $output->writeln("<info>Error while disconnecting from database: {$ex->getMessage()}</info>"); |
|
334 | - } |
|
335 | - while (!$connection->isConnected()) { |
|
336 | - try { |
|
337 | - $connection->connect(); |
|
338 | - } catch (\Exception $ex) { |
|
339 | - $output->writeln("<info>Error while re-connecting to database: {$ex->getMessage()}</info>"); |
|
340 | - sleep(60); |
|
341 | - } |
|
342 | - } |
|
343 | - return $connection; |
|
344 | - } |
|
324 | + /** |
|
325 | + * @return \OCP\IDBConnection |
|
326 | + */ |
|
327 | + protected function reconnectToDatabase(OutputInterface $output) { |
|
328 | + /** @var Connection | IDBConnection $connection*/ |
|
329 | + $connection = \OC::$server->getDatabaseConnection(); |
|
330 | + try { |
|
331 | + $connection->close(); |
|
332 | + } catch (\Exception $ex) { |
|
333 | + $output->writeln("<info>Error while disconnecting from database: {$ex->getMessage()}</info>"); |
|
334 | + } |
|
335 | + while (!$connection->isConnected()) { |
|
336 | + try { |
|
337 | + $connection->connect(); |
|
338 | + } catch (\Exception $ex) { |
|
339 | + $output->writeln("<info>Error while re-connecting to database: {$ex->getMessage()}</info>"); |
|
340 | + sleep(60); |
|
341 | + } |
|
342 | + } |
|
343 | + return $connection; |
|
344 | + } |
|
345 | 345 | |
346 | 346 | } |
@@ -34,29 +34,29 @@ |
||
34 | 34 | * @package OCA\Files |
35 | 35 | */ |
36 | 36 | class Capabilities implements ICapability { |
37 | - /** @var IConfig */ |
|
38 | - protected $config; |
|
37 | + /** @var IConfig */ |
|
38 | + protected $config; |
|
39 | 39 | |
40 | - /** |
|
41 | - * Capabilities constructor. |
|
42 | - * |
|
43 | - * @param IConfig $config |
|
44 | - */ |
|
45 | - public function __construct(IConfig $config) { |
|
46 | - $this->config = $config; |
|
47 | - } |
|
40 | + /** |
|
41 | + * Capabilities constructor. |
|
42 | + * |
|
43 | + * @param IConfig $config |
|
44 | + */ |
|
45 | + public function __construct(IConfig $config) { |
|
46 | + $this->config = $config; |
|
47 | + } |
|
48 | 48 | |
49 | - /** |
|
50 | - * Return this classes capabilities |
|
51 | - * |
|
52 | - * @return array |
|
53 | - */ |
|
54 | - public function getCapabilities() { |
|
55 | - return [ |
|
56 | - 'files' => [ |
|
57 | - 'bigfilechunking' => true, |
|
58 | - 'blacklisted_files' => $this->config->getSystemValue('blacklisted_files', ['.htaccess']), |
|
59 | - ], |
|
60 | - ]; |
|
61 | - } |
|
49 | + /** |
|
50 | + * Return this classes capabilities |
|
51 | + * |
|
52 | + * @return array |
|
53 | + */ |
|
54 | + public function getCapabilities() { |
|
55 | + return [ |
|
56 | + 'files' => [ |
|
57 | + 'bigfilechunking' => true, |
|
58 | + 'blacklisted_files' => $this->config->getSystemValue('blacklisted_files', ['.htaccess']), |
|
59 | + ], |
|
60 | + ]; |
|
61 | + } |
|
62 | 62 | } |
@@ -30,29 +30,29 @@ |
||
30 | 30 | */ |
31 | 31 | class CleanupFileLocks extends TimedJob { |
32 | 32 | |
33 | - /** |
|
34 | - * Default interval in minutes |
|
35 | - * |
|
36 | - * @var int $defaultIntervalMin |
|
37 | - **/ |
|
38 | - protected $defaultIntervalMin = 5; |
|
33 | + /** |
|
34 | + * Default interval in minutes |
|
35 | + * |
|
36 | + * @var int $defaultIntervalMin |
|
37 | + **/ |
|
38 | + protected $defaultIntervalMin = 5; |
|
39 | 39 | |
40 | - /** |
|
41 | - * sets the correct interval for this timed job |
|
42 | - */ |
|
43 | - public function __construct() { |
|
44 | - $this->interval = $this->defaultIntervalMin * 60; |
|
45 | - } |
|
40 | + /** |
|
41 | + * sets the correct interval for this timed job |
|
42 | + */ |
|
43 | + public function __construct() { |
|
44 | + $this->interval = $this->defaultIntervalMin * 60; |
|
45 | + } |
|
46 | 46 | |
47 | - /** |
|
48 | - * Makes the background job do its work |
|
49 | - * |
|
50 | - * @param array $argument unused argument |
|
51 | - */ |
|
52 | - public function run($argument) { |
|
53 | - $lockingProvider = \OC::$server->getLockingProvider(); |
|
54 | - if($lockingProvider instanceof DBLockingProvider) { |
|
55 | - $lockingProvider->cleanExpiredLocks(); |
|
56 | - } |
|
57 | - } |
|
47 | + /** |
|
48 | + * Makes the background job do its work |
|
49 | + * |
|
50 | + * @param array $argument unused argument |
|
51 | + */ |
|
52 | + public function run($argument) { |
|
53 | + $lockingProvider = \OC::$server->getLockingProvider(); |
|
54 | + if($lockingProvider instanceof DBLockingProvider) { |
|
55 | + $lockingProvider->cleanExpiredLocks(); |
|
56 | + } |
|
57 | + } |
|
58 | 58 | } |
@@ -32,123 +32,123 @@ |
||
32 | 32 | */ |
33 | 33 | class DeleteOrphanedItems extends TimedJob { |
34 | 34 | |
35 | - const CHUNK_SIZE = 200; |
|
36 | - |
|
37 | - /** @var \OCP\IDBConnection */ |
|
38 | - protected $connection; |
|
39 | - |
|
40 | - /** @var \OCP\ILogger */ |
|
41 | - protected $logger; |
|
42 | - |
|
43 | - /** |
|
44 | - * Default interval in minutes |
|
45 | - * |
|
46 | - * @var int $defaultIntervalMin |
|
47 | - **/ |
|
48 | - protected $defaultIntervalMin = 60; |
|
49 | - |
|
50 | - /** |
|
51 | - * sets the correct interval for this timed job |
|
52 | - */ |
|
53 | - public function __construct() { |
|
54 | - $this->interval = $this->defaultIntervalMin * 60; |
|
55 | - $this->connection = \OC::$server->getDatabaseConnection(); |
|
56 | - $this->logger = \OC::$server->getLogger(); |
|
57 | - } |
|
58 | - |
|
59 | - /** |
|
60 | - * Makes the background job do its work |
|
61 | - * |
|
62 | - * @param array $argument unused argument |
|
63 | - */ |
|
64 | - public function run($argument) { |
|
65 | - $this->cleanSystemTags(); |
|
66 | - $this->cleanUserTags(); |
|
67 | - $this->cleanComments(); |
|
68 | - $this->cleanCommentMarkers(); |
|
69 | - } |
|
70 | - |
|
71 | - /** |
|
72 | - * Deleting orphaned system tag mappings |
|
73 | - * |
|
74 | - * @param string $table |
|
75 | - * @param string $idCol |
|
76 | - * @param string $typeCol |
|
77 | - * @return int Number of deleted entries |
|
78 | - */ |
|
79 | - protected function cleanUp($table, $idCol, $typeCol) { |
|
80 | - $deletedEntries = 0; |
|
81 | - |
|
82 | - $query = $this->connection->getQueryBuilder(); |
|
83 | - $query->select('t1.' . $idCol) |
|
84 | - ->from($table, 't1') |
|
85 | - ->where($query->expr()->eq($typeCol, $query->expr()->literal('files'))) |
|
86 | - ->andWhere($query->expr()->isNull('t2.fileid')) |
|
87 | - ->leftJoin('t1', 'filecache', 't2', $query->expr()->eq($query->expr()->castColumn('t1.' . $idCol, IQueryBuilder::PARAM_INT), 't2.fileid')) |
|
88 | - ->groupBy('t1.' . $idCol) |
|
89 | - ->setMaxResults(self::CHUNK_SIZE); |
|
90 | - |
|
91 | - $deleteQuery = $this->connection->getQueryBuilder(); |
|
92 | - $deleteQuery->delete($table) |
|
93 | - ->where($deleteQuery->expr()->eq($idCol, $deleteQuery->createParameter('objectid'))); |
|
94 | - |
|
95 | - $deletedInLastChunk = self::CHUNK_SIZE; |
|
96 | - while ($deletedInLastChunk === self::CHUNK_SIZE) { |
|
97 | - $result = $query->execute(); |
|
98 | - $deletedInLastChunk = 0; |
|
99 | - while ($row = $result->fetch()) { |
|
100 | - $deletedInLastChunk++; |
|
101 | - $deletedEntries += $deleteQuery->setParameter('objectid', (int) $row[$idCol]) |
|
102 | - ->execute(); |
|
103 | - } |
|
104 | - $result->closeCursor(); |
|
105 | - } |
|
106 | - |
|
107 | - return $deletedEntries; |
|
108 | - } |
|
109 | - |
|
110 | - /** |
|
111 | - * Deleting orphaned system tag mappings |
|
112 | - * |
|
113 | - * @return int Number of deleted entries |
|
114 | - */ |
|
115 | - protected function cleanSystemTags() { |
|
116 | - $deletedEntries = $this->cleanUp('systemtag_object_mapping', 'objectid', 'objecttype'); |
|
117 | - $this->logger->debug("$deletedEntries orphaned system tag relations deleted", ['app' => 'DeleteOrphanedItems']); |
|
118 | - return $deletedEntries; |
|
119 | - } |
|
120 | - |
|
121 | - /** |
|
122 | - * Deleting orphaned user tag mappings |
|
123 | - * |
|
124 | - * @return int Number of deleted entries |
|
125 | - */ |
|
126 | - protected function cleanUserTags() { |
|
127 | - $deletedEntries = $this->cleanUp('vcategory_to_object', 'objid', 'type'); |
|
128 | - $this->logger->debug("$deletedEntries orphaned user tag relations deleted", ['app' => 'DeleteOrphanedItems']); |
|
129 | - return $deletedEntries; |
|
130 | - } |
|
131 | - |
|
132 | - /** |
|
133 | - * Deleting orphaned comments |
|
134 | - * |
|
135 | - * @return int Number of deleted entries |
|
136 | - */ |
|
137 | - protected function cleanComments() { |
|
138 | - $deletedEntries = $this->cleanUp('comments', 'object_id', 'object_type'); |
|
139 | - $this->logger->debug("$deletedEntries orphaned comments deleted", ['app' => 'DeleteOrphanedItems']); |
|
140 | - return $deletedEntries; |
|
141 | - } |
|
142 | - |
|
143 | - /** |
|
144 | - * Deleting orphaned comment read markers |
|
145 | - * |
|
146 | - * @return int Number of deleted entries |
|
147 | - */ |
|
148 | - protected function cleanCommentMarkers() { |
|
149 | - $deletedEntries = $this->cleanUp('comments_read_markers', 'object_id', 'object_type'); |
|
150 | - $this->logger->debug("$deletedEntries orphaned comment read marks deleted", ['app' => 'DeleteOrphanedItems']); |
|
151 | - return $deletedEntries; |
|
152 | - } |
|
35 | + const CHUNK_SIZE = 200; |
|
36 | + |
|
37 | + /** @var \OCP\IDBConnection */ |
|
38 | + protected $connection; |
|
39 | + |
|
40 | + /** @var \OCP\ILogger */ |
|
41 | + protected $logger; |
|
42 | + |
|
43 | + /** |
|
44 | + * Default interval in minutes |
|
45 | + * |
|
46 | + * @var int $defaultIntervalMin |
|
47 | + **/ |
|
48 | + protected $defaultIntervalMin = 60; |
|
49 | + |
|
50 | + /** |
|
51 | + * sets the correct interval for this timed job |
|
52 | + */ |
|
53 | + public function __construct() { |
|
54 | + $this->interval = $this->defaultIntervalMin * 60; |
|
55 | + $this->connection = \OC::$server->getDatabaseConnection(); |
|
56 | + $this->logger = \OC::$server->getLogger(); |
|
57 | + } |
|
58 | + |
|
59 | + /** |
|
60 | + * Makes the background job do its work |
|
61 | + * |
|
62 | + * @param array $argument unused argument |
|
63 | + */ |
|
64 | + public function run($argument) { |
|
65 | + $this->cleanSystemTags(); |
|
66 | + $this->cleanUserTags(); |
|
67 | + $this->cleanComments(); |
|
68 | + $this->cleanCommentMarkers(); |
|
69 | + } |
|
70 | + |
|
71 | + /** |
|
72 | + * Deleting orphaned system tag mappings |
|
73 | + * |
|
74 | + * @param string $table |
|
75 | + * @param string $idCol |
|
76 | + * @param string $typeCol |
|
77 | + * @return int Number of deleted entries |
|
78 | + */ |
|
79 | + protected function cleanUp($table, $idCol, $typeCol) { |
|
80 | + $deletedEntries = 0; |
|
81 | + |
|
82 | + $query = $this->connection->getQueryBuilder(); |
|
83 | + $query->select('t1.' . $idCol) |
|
84 | + ->from($table, 't1') |
|
85 | + ->where($query->expr()->eq($typeCol, $query->expr()->literal('files'))) |
|
86 | + ->andWhere($query->expr()->isNull('t2.fileid')) |
|
87 | + ->leftJoin('t1', 'filecache', 't2', $query->expr()->eq($query->expr()->castColumn('t1.' . $idCol, IQueryBuilder::PARAM_INT), 't2.fileid')) |
|
88 | + ->groupBy('t1.' . $idCol) |
|
89 | + ->setMaxResults(self::CHUNK_SIZE); |
|
90 | + |
|
91 | + $deleteQuery = $this->connection->getQueryBuilder(); |
|
92 | + $deleteQuery->delete($table) |
|
93 | + ->where($deleteQuery->expr()->eq($idCol, $deleteQuery->createParameter('objectid'))); |
|
94 | + |
|
95 | + $deletedInLastChunk = self::CHUNK_SIZE; |
|
96 | + while ($deletedInLastChunk === self::CHUNK_SIZE) { |
|
97 | + $result = $query->execute(); |
|
98 | + $deletedInLastChunk = 0; |
|
99 | + while ($row = $result->fetch()) { |
|
100 | + $deletedInLastChunk++; |
|
101 | + $deletedEntries += $deleteQuery->setParameter('objectid', (int) $row[$idCol]) |
|
102 | + ->execute(); |
|
103 | + } |
|
104 | + $result->closeCursor(); |
|
105 | + } |
|
106 | + |
|
107 | + return $deletedEntries; |
|
108 | + } |
|
109 | + |
|
110 | + /** |
|
111 | + * Deleting orphaned system tag mappings |
|
112 | + * |
|
113 | + * @return int Number of deleted entries |
|
114 | + */ |
|
115 | + protected function cleanSystemTags() { |
|
116 | + $deletedEntries = $this->cleanUp('systemtag_object_mapping', 'objectid', 'objecttype'); |
|
117 | + $this->logger->debug("$deletedEntries orphaned system tag relations deleted", ['app' => 'DeleteOrphanedItems']); |
|
118 | + return $deletedEntries; |
|
119 | + } |
|
120 | + |
|
121 | + /** |
|
122 | + * Deleting orphaned user tag mappings |
|
123 | + * |
|
124 | + * @return int Number of deleted entries |
|
125 | + */ |
|
126 | + protected function cleanUserTags() { |
|
127 | + $deletedEntries = $this->cleanUp('vcategory_to_object', 'objid', 'type'); |
|
128 | + $this->logger->debug("$deletedEntries orphaned user tag relations deleted", ['app' => 'DeleteOrphanedItems']); |
|
129 | + return $deletedEntries; |
|
130 | + } |
|
131 | + |
|
132 | + /** |
|
133 | + * Deleting orphaned comments |
|
134 | + * |
|
135 | + * @return int Number of deleted entries |
|
136 | + */ |
|
137 | + protected function cleanComments() { |
|
138 | + $deletedEntries = $this->cleanUp('comments', 'object_id', 'object_type'); |
|
139 | + $this->logger->debug("$deletedEntries orphaned comments deleted", ['app' => 'DeleteOrphanedItems']); |
|
140 | + return $deletedEntries; |
|
141 | + } |
|
142 | + |
|
143 | + /** |
|
144 | + * Deleting orphaned comment read markers |
|
145 | + * |
|
146 | + * @return int Number of deleted entries |
|
147 | + */ |
|
148 | + protected function cleanCommentMarkers() { |
|
149 | + $deletedEntries = $this->cleanUp('comments_read_markers', 'object_id', 'object_type'); |
|
150 | + $this->logger->debug("$deletedEntries orphaned comment read marks deleted", ['app' => 'DeleteOrphanedItems']); |
|
151 | + return $deletedEntries; |
|
152 | + } |
|
153 | 153 | |
154 | 154 | } |