zend-blog-3-backend

Version20230613040158.php
116 строк · 8.0 Кб
Перенос по словам
1
<?php
2

3
declare(strict_types=1);
4

5
namespace Application\Migrations;
6

7
use Doctrine\DBAL\Schema\Schema;
8
use Doctrine\Migrations\AbstractMigration;
9

10
/**
11
 * Auto-generated Migration: Please modify to your needs!
12
 */
13
final class Version20230613040158 extends AbstractMigration
14
{
15
    public function up(Schema $schema): void
16
    {
17
        // this up() migration is auto-generated, please modify it to your needs
18
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
19

20
        /* SQL-query for search
21
            SELECT
22
                src.user_agent,
23
                src.is_bot,
24
                (src.t_cnt + src.tt_cnt) AS cnt,
25
                src.created_at
26
            FROM (
27
            SELECT
28
                ta.user_agent,
29
                ta.is_bot,
30
                ta.created_at,
31
                COUNT(DISTINCT t.id) AS t_cnt,
32
                COUNT(DISTINCT tt.id) AS tt_cnt
33
            FROM tracking_agent AS ta
34
            LEFT JOIN tracking AS t ON ta.id = t.user_agent_id
35
            LEFT JOIN tracking_archive AS tt ON ta.id = tt.user_agent_id
36
            WHERE ta.user_agent LIKE '%client%'
37
            GROUP BY ta.id) AS src
38
            ORDER BY cnt DESC
39
            SQL;
40
        */
41

42
        $this->addSql('UPDATE tracking_agent SET is_bot = 0 WHERE user_agent LIKE \'%yandex%\'');
43
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%yandex.com/bots%\'');
44
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent = \'\'');
45
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'java%\'');
46
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%yacy.net/bot%\'');
47
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'hotjava%\'');
48
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'Apache-HttpClient%\'');
49
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%femtosearchbot%\'');
50
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%crawler%\'');
51
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%inoreader.com%\'');
52
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%fetch%\'');
53
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%curl/%\'');
54
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%wget%\'');
55
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%python%\'');
56
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%parser%\'');
57
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%ruby/%\'');
58
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Go-http-client%\'');
59
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%petalbot%\'');
60
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent = \'ALittle Client\'');
61
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%dreamwidth.org%\'');
62
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%SemrushBot%\'');
63
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%liferea%\'');
64
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%zoominfobot%\'');
65
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%tt-rss.org%\'');
66
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Datanyze%\'');
67
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%DataForSeoBot%\'');
68
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%DotBot%\'');
69
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Applebot%\'');
70
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%FlipboardRSS%\'');
71
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%crawlson%\'');
72
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Barkrowler%\'');
73
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%BorneoBot%\'');
74
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%seznam%\'');
75
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%SeekportBot%\'');
76
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%serpstatbot%\'');
77
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%AspiegelBot%\'');
78
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%amazonbot%\'');
79
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%IndeedBot%\'');
80
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%awario.com/bots%\'');
81
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%neevabot%\'');
82
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Googlebot%\'');
83
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%LinkpadBot%\'');
84
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Keybot%\'');
85
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Timpibot%\'');
86
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%MojeekBot%\'');
87
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%SenutoBot%\'');
88
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Cliqzbot%\'');
89
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%FlfBaldrBot%\'');
90
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%DuckDuckBot%\'');
91
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%RedirectBot%\'');
92
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%inetdex.com/bot%\'');
93
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%WebwikiBot%\'');
94
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%PaperLiBot%\'');
95
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Clarabot%\'');
96
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Discordbot%\'');
97
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%DuckDuckGo-Favicons-Bot%\'');
98
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Mail.RU_Bot%\'');
99
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%BSbot%\'');
100
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Twitterbot%\'');
101
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Pandalytics%\'');
102
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent = \'labjs.pro/bot\'');
103
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%2ip bot%\'');
104
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%Qwantify%\'');
105
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%bot@linkfluence.com%\'');
106
        $this->addSql('UPDATE tracking_agent SET is_bot = 1 WHERE user_agent LIKE \'%BUbiNG%\'');
107
    }
108

109
    public function down(Schema $schema): void
110
    {
111
        // this down() migration is auto-generated, please modify it to your needs
112
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
113

114
        $this->addSql('SELECT NOW()');
115
    }
116
}
117
zend-blog-3-backend

Использование cookies
