]> git.mxchange.org Git - friendica.git/blob - src/Worker/UpdateGServers.php
New table "post-counts" to precalculate the counts
[friendica.git] / src / Worker / UpdateGServers.php
1 <?php
2 /**
3  * @copyright Copyright (C) 2010-2023, the Friendica project
4  *
5  * @license GNU AGPL version 3 or any later version
6  *
7  * This program is free software: you can redistribute it and/or modify
8  * it under the terms of the GNU Affero General Public License as
9  * published by the Free Software Foundation, either version 3 of the
10  * License, or (at your option) any later version.
11  *
12  * This program is distributed in the hope that it will be useful,
13  * but WITHOUT ANY WARRANTY; without even the implied warranty of
14  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
15  * GNU Affero General Public License for more details.
16  *
17  * You should have received a copy of the GNU Affero General Public License
18  * along with this program.  If not, see <https://www.gnu.org/licenses/>.
19  *
20  */
21
22 namespace Friendica\Worker;
23
24 use Friendica\Core\Logger;
25 use Friendica\Core\Worker;
26 use Friendica\Database\DBA;
27 use Friendica\DI;
28 use Friendica\Model\Contact;
29 use Friendica\Model\GServer;
30 use Friendica\Util\DateTimeFormat;
31 use Friendica\Util\Strings;
32
33 class UpdateGServers
34 {
35         /**
36          * Updates a defined number of servers
37          */
38         public static function execute()
39         {
40                 $update_limit = DI::config()->get('system', 'gserver_update_limit');
41                 if (empty($update_limit)) {
42                         return;
43                 }
44
45                 $updating = Worker::countWorkersByCommand('UpdateGServer');
46                 $limit = $update_limit - $updating;
47                 if ($limit <= 0) {
48                         Logger::info('The number of currently running jobs exceed the limit');
49                         return;
50                 }
51
52                 $total = DBA::count('gserver');
53                 $condition = ["NOT `blocked` AND `next_contact` < ? AND (`nurl` != ? OR `url` != ?)",  DateTimeFormat::utcNow(), '', ''];
54                 $outdated = DBA::count('gserver', $condition);
55                 Logger::info('Server status', ['total' => $total, 'outdated' => $outdated, 'updating' => $limit]);
56
57                 $gservers = DBA::select('gserver', ['id', 'url', 'nurl', 'failed', 'created', 'last_contact'], $condition, ['limit' => $limit]);
58                 if (!DBA::isResult($gservers)) {
59                         return;
60                 }
61
62                 $count = 0;
63                 while ($gserver = DBA::fetch($gservers)) {
64                         if (DI::config()->get('system', 'update_active_contacts') && !Contact::exists(['gsid' => $gserver['id'], 'local-data' => true])) {
65                                 $next_update = GServer::getNextUpdateDate(!$gserver['failed'], $gserver['created'], $gserver['last_contact']);
66                                 Logger::debug('Skip server without contacts with local data', ['url' => $gserver['url'], 'failed' => $gserver['failed'], 'next_update' => $next_update]);
67                                 GServer::update(['next_contact' => $next_update], ['nurl' => $gserver['nurl']]);
68                                 continue;
69                         }
70
71                         // Sometimes the "nurl" and "url" doesn't seem to fit, see https://forum.friendi.ca/display/ec054ce7-155f-c94d-6159-f50372664245
72                         // There are duplicated "url" but not "nurl". So we check both addresses instead of just overwriting them,
73                         // since that would mean loosing data.
74                         if (!empty($gserver['url'])) {
75                                 if (UpdateGServer::add(Worker::PRIORITY_LOW, $gserver['url'])) {
76                                         $count++;
77                                 }
78                         }
79                         if (!empty($gserver['nurl']) && ($gserver['nurl'] != Strings::normaliseLink($gserver['url']))) {
80                                 if (UpdateGServer::add(Worker::PRIORITY_LOW, $gserver['nurl'])) {
81                                         $count++;
82                                 }
83                         }
84                         Worker::coolDown();
85                 }
86                 DBA::close($gservers);
87                 Logger::info('Updated servers', ['count' => $count]);
88         }
89 }