8 files changed, 270 insertions, 0 deletions

diff --git a/vendor/doctrine/dbal/src/Platforms/MySQL/CharsetMetadataProvider.php b/vendor/doctrine/dbal/src/Platforms/MySQL/CharsetMetadataProvider.php
new file mode 100644
index 0000000..665543e
--- /dev/null
+++ b/vendor/doctrine/dbal/src/Platforms/MySQL/CharsetMetadataProvider.php
@@ -0,0 +1,11 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\Platforms\MySQL;
+
+/** @internal */
+interface CharsetMetadataProvider
+{
+    public function getDefaultCharsetCollation(string $charset): ?string;
+}
diff --git a/vendor/doctrine/dbal/src/Platforms/MySQL/CharsetMetadataProvider/CachingCharsetMetadataProvider.php b/vendor/doctrine/dbal/src/Platforms/MySQL/CharsetMetadataProvider/CachingCharsetMetadataProvider.php
new file mode 100644
index 0000000..dadc841
--- /dev/null
+++ b/vendor/doctrine/dbal/src/Platforms/MySQL/CharsetMetadataProvider/CachingCharsetMetadataProvider.php
@@ -0,0 +1,29 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\Platforms\MySQL\CharsetMetadataProvider;
+
+use Doctrine\DBAL\Platforms\MySQL\CharsetMetadataProvider;
+
+use function array_key_exists;
+
+/** @internal */
+final class CachingCharsetMetadataProvider implements CharsetMetadataProvider
+{
+    /** @var array<string,?string> */
+    private array $cache = [];
+
+    public function __construct(private readonly CharsetMetadataProvider $charsetMetadataProvider)
+    {
+    }
+
+    public function getDefaultCharsetCollation(string $charset): ?string
+    {
+        if (array_key_exists($charset, $this->cache)) {
+            return $this->cache[$charset];
+        }
+
+        return $this->cache[$charset] = $this->charsetMetadataProvider->getDefaultCharsetCollation($charset);
+    }
+}
diff --git a/vendor/doctrine/dbal/src/Platforms/MySQL/CharsetMetadataProvider/ConnectionCharsetMetadataProvider.php b/vendor/doctrine/dbal/src/Platforms/MySQL/CharsetMetadataProvider/ConnectionCharsetMetadataProvider.php
new file mode 100644
index 0000000..65b63df
--- /dev/null
+++ b/vendor/doctrine/dbal/src/Platforms/MySQL/CharsetMetadataProvider/ConnectionCharsetMetadataProvider.php
@@ -0,0 +1,37 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\Platforms\MySQL\CharsetMetadataProvider;
+
+use Doctrine\DBAL\Connection;
+use Doctrine\DBAL\Exception;
+use Doctrine\DBAL\Platforms\MySQL\CharsetMetadataProvider;
+
+/** @internal */
+final class ConnectionCharsetMetadataProvider implements CharsetMetadataProvider
+{
+    public function __construct(private readonly Connection $connection)
+    {
+    }
+
+    /** @throws Exception */
+    public function getDefaultCharsetCollation(string $charset): ?string
+    {
+        $collation = $this->connection->fetchOne(
+            <<<'SQL'
+            SELECT DEFAULT_COLLATE_NAME
+            FROM information_schema.CHARACTER_SETS
+            WHERE CHARACTER_SET_NAME = ?;
+            SQL
+            ,
+            [$charset],
+        );
+
+        if ($collation !== false) {
+            return $collation;
+        }
+
+        return null;
+    }
+}
diff --git a/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider.php b/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider.php
new file mode 100644
index 0000000..d52ca74
--- /dev/null
+++ b/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider.php
@@ -0,0 +1,11 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\Platforms\MySQL;
+
+/** @internal */
+interface CollationMetadataProvider
+{
+    public function getCollationCharset(string $collation): ?string;
+}
diff --git a/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider/CachingCollationMetadataProvider.php b/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider/CachingCollationMetadataProvider.php
new file mode 100644
index 0000000..0c99aa3
--- /dev/null
+++ b/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider/CachingCollationMetadataProvider.php
@@ -0,0 +1,29 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\Platforms\MySQL\CollationMetadataProvider;
+
+use Doctrine\DBAL\Platforms\MySQL\CollationMetadataProvider;
+
+use function array_key_exists;
+
+/** @internal */
+final class CachingCollationMetadataProvider implements CollationMetadataProvider
+{
+    /** @var array<string,?string> */
+    private array $cache = [];
+
+    public function __construct(private readonly CollationMetadataProvider $collationMetadataProvider)
+    {
+    }
+
+    public function getCollationCharset(string $collation): ?string
+    {
+        if (array_key_exists($collation, $this->cache)) {
+            return $this->cache[$collation];
+        }
+
+        return $this->cache[$collation] = $this->collationMetadataProvider->getCollationCharset($collation);
+    }
+}
diff --git a/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider/ConnectionCollationMetadataProvider.php b/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider/ConnectionCollationMetadataProvider.php
new file mode 100644
index 0000000..fcd9995
--- /dev/null
+++ b/vendor/doctrine/dbal/src/Platforms/MySQL/CollationMetadataProvider/ConnectionCollationMetadataProvider.php
@@ -0,0 +1,37 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\Platforms\MySQL\CollationMetadataProvider;
+
+use Doctrine\DBAL\Connection;
+use Doctrine\DBAL\Exception;
+use Doctrine\DBAL\Platforms\MySQL\CollationMetadataProvider;
+
+/** @internal */
+final class ConnectionCollationMetadataProvider implements CollationMetadataProvider
+{
+    public function __construct(private readonly Connection $connection)
+    {
+    }
+
+    /** @throws Exception */
+    public function getCollationCharset(string $collation): ?string
+    {
+        $charset = $this->connection->fetchOne(
+            <<<'SQL'
+SELECT CHARACTER_SET_NAME
+FROM information_schema.COLLATIONS
+WHERE COLLATION_NAME = ?;
+SQL
+            ,
+            [$collation],
+        );
+
+        if ($charset !== false) {
+            return $charset;
+        }
+
+        return null;
+    }
+}
diff --git a/vendor/doctrine/dbal/src/Platforms/MySQL/Comparator.php b/vendor/doctrine/dbal/src/Platforms/MySQL/Comparator.php
new file mode 100644
index 0000000..ebe025d
--- /dev/null
+++ b/vendor/doctrine/dbal/src/Platforms/MySQL/Comparator.php
@@ -0,0 +1,93 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\Platforms\MySQL;
+
+use Doctrine\DBAL\Platforms\AbstractMySQLPlatform;
+use Doctrine\DBAL\Schema\Comparator as BaseComparator;
+use Doctrine\DBAL\Schema\Table;
+use Doctrine\DBAL\Schema\TableDiff;
+
+use function array_diff_assoc;
+
+/**
+ * Compares schemas in the context of MySQL platform.
+ *
+ * In MySQL, unless specified explicitly, the column's character set and collation are inherited from its containing
+ * table. So during comparison, an omitted value and the value that matches the default value of table in the
+ * desired schema must be considered equal.
+ */
+class Comparator extends BaseComparator
+{
+    /** @internal The comparator can be only instantiated by a schema manager. */
+    public function __construct(
+        AbstractMySQLPlatform $platform,
+        private readonly CharsetMetadataProvider $charsetMetadataProvider,
+        private readonly CollationMetadataProvider $collationMetadataProvider,
+        private readonly DefaultTableOptions $defaultTableOptions,
+    ) {
+        parent::__construct($platform);
+    }
+
+    public function compareTables(Table $oldTable, Table $newTable): TableDiff
+    {
+        return parent::compareTables(
+            $this->normalizeTable($oldTable),
+            $this->normalizeTable($newTable),
+        );
+    }
+
+    private function normalizeTable(Table $table): Table
+    {
+        $charset   = $table->getOption('charset');
+        $collation = $table->getOption('collation');
+
+        if ($charset === null && $collation !== null) {
+            $charset = $this->collationMetadataProvider->getCollationCharset($collation);
+        } elseif ($charset !== null && $collation === null) {
+            $collation = $this->charsetMetadataProvider->getDefaultCharsetCollation($charset);
+        } elseif ($charset === null && $collation === null) {
+            $charset   = $this->defaultTableOptions->getCharset();
+            $collation = $this->defaultTableOptions->getCollation();
+        }
+
+        $tableOptions = [
+            'charset'   => $charset,
+            'collation' => $collation,
+        ];
+
+        $table = clone $table;
+
+        foreach ($table->getColumns() as $column) {
+            $originalOptions   = $column->getPlatformOptions();
+            $normalizedOptions = $this->normalizeOptions($originalOptions);
+
+            $overrideOptions = array_diff_assoc($normalizedOptions, $tableOptions);
+
+            if ($overrideOptions === $originalOptions) {
+                continue;
+            }
+
+            $column->setPlatformOptions($overrideOptions);
+        }
+
+        return $table;
+    }
+
+    /**
+     * @param array<string,string> $options
+     *
+     * @return array<string,string|null>
+     */
+    private function normalizeOptions(array $options): array
+    {
+        if (isset($options['charset']) && ! isset($options['collation'])) {
+            $options['collation'] = $this->charsetMetadataProvider->getDefaultCharsetCollation($options['charset']);
+        } elseif (isset($options['collation']) && ! isset($options['charset'])) {
+            $options['charset'] = $this->collationMetadataProvider->getCollationCharset($options['collation']);
+        }
+
+        return $options;
+    }
+}
diff --git a/vendor/doctrine/dbal/src/Platforms/MySQL/DefaultTableOptions.php b/vendor/doctrine/dbal/src/Platforms/MySQL/DefaultTableOptions.php
new file mode 100644
index 0000000..ede3ba2
--- /dev/null
+++ b/vendor/doctrine/dbal/src/Platforms/MySQL/DefaultTableOptions.php
@@ -0,0 +1,23 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\Platforms\MySQL;
+
+/** @internal */
+final class DefaultTableOptions
+{
+    public function __construct(private readonly string $charset, private readonly string $collation)
+    {
+    }
+
+    public function getCharset(): string
+    {
+        return $this->charset;
+    }
+
+    public function getCollation(): string
+    {
+        return $this->collation;
+    }
+}