Spaces:
No application file
No application file
File size: 1,838 Bytes
d2897cd |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 |
<?php
declare(strict_types=1);
namespace Mautic\Migrations;
use Doctrine\DBAL\Schema\Schema;
use Mautic\CoreBundle\Doctrine\PreUpAssertionMigration;
final class Version20231206152313 extends PreUpAssertionMigration
{
protected function preUpAssertions(): void
{
$this->skipAssertion(function (Schema $schema) {
return $schema->getTable($this->getTableName())->hasIndex($this->getSentIndexName());
}, sprintf('Index %s already exists', $this->getSentIndexName()));
$this->skipAssertion(function (Schema $schema) {
return $schema->getTable($this->getTableName())->hasIndex($this->getIsReadIndexName());
}, sprintf('Index %s already exists', $this->getIsReadIndexName()));
}
public function up(Schema $schema): void
{
$this->addSql(sprintf('ALTER TABLE %s ADD INDEX %s (lead_id, date_sent), ADD INDEX %s (email_id, is_read)', $this->getTableName(), $this->getSentIndexName(), $this->getIsReadIndexName()));
}
public function postUp(Schema $schema): void
{
$this->dropIndex(['lead_id']);
$this->dropIndex(['email_id']);
}
private function getTableName(): string
{
return "{$this->prefix}email_stats";
}
private function getSentIndexName(): string
{
return "{$this->prefix}stat_email_lead_id_date_sent";
}
private function getIsReadIndexName(): string
{
return "{$this->prefix}stat_email_email_id_is_read";
}
/**
* @param string[] $columnNames
*/
private function dropIndex(array $columnNames): void
{
try {
$this->connection->executeStatement(sprintf('DROP INDEX %s ON %s', $this->generatePropertyName('email_stats', 'idx', $columnNames), $this->getTableName()));
} catch (\Throwable) {
}
}
}
|