mise en place de l'héritage 3, patch bug doctrine

1 files changed, 55 insertions, 0 deletions

diff --git a/patched fetchTableColumns.txt b/patched fetchTableColumns.txt
new file mode 100644
index 0000000..d677034
--- /dev/null
+++ b/patched fetchTableColumns.txt
@@ -0,0 +1,55 @@
+<?php
+// replace fetchTableColumns by this one in vendor/doctrine/dbal/src/Schema/SQLiteSchemaManager.php at line 466
+
+protected function fetchTableColumns(string $databaseName, ?string $tableName = null): array
+{
+    $rows = parent::fetchTableColumns($databaseName, $tableName);
+
+    $sqlByTable = $pkColumnNamesByTable = $foreignKeyColumnsByTable = $result = [];
+
+    foreach ($rows as $row) {
+        $tableName = $row['table_name'];
+
+        $sqlByTable[$tableName] ??= $this->getCreateTableSQL($tableName);
+
+        if ($row['pk'] !== 0 && $row['pk'] !== '0') {
+            $pkColumnNamesByTable[$tableName][] = $row['name'];
+        }
+    }
+
+    // -----
+    $foreignKeyRows = $this->connection->fetchAllAssociative(
+        <<<'SQL'
+        SELECT t.name AS table_name,
+               p."from" AS column_name
+          FROM sqlite_master t
+          JOIN pragma_foreign_key_list(t.name) p
+         WHERE t.type = 'table'
+        SQL,
+    );
+
+    foreach ($foreignKeyRows as $foreignKeyRow) {
+        $foreignKeyColumnsByTable[$foreignKeyRow['table_name']]
+            [$foreignKeyRow['column_name']] = true;
+    }
+    // -----
+
+    foreach ($rows as $row) {
+        $tableName  = $row['table_name'];
+        $columnName = $row['name'];
+        $tableSQL   = $sqlByTable[$tableName];
+
+        $result[] = array_merge($row, [
+        // -----
+            'autoincrement' => isset($pkColumnNamesByTable[$tableName])
+                && $pkColumnNamesByTable[$tableName] === [$columnName]
+                && $row['type'] === 'INTEGER'
+                && ! isset($foreignKeyColumnsByTable[$tableName][$columnName]),
+        // -----
+            'collation' => $this->parseColumnCollationFromSQL($columnName, $tableSQL),
+            'comment' => $this->parseColumnCommentFromSQL($columnName, $tableSQL),
+        ]);
+    }
+
+    return $result;
+}
\ No newline at end of file