From bf6655a534a6775d30cafa67bd801276bda1d98d Mon Sep 17 00:00:00 2001
From: polo <ordipolo@gmx.fr>
Date: Tue, 13 Aug 2024 23:45:21 +0200
Subject: =?UTF-8?q?VERSION=200.2=20doctrine=20ORM=20et=20entit=C3=A9s?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 .../SQL/Builder/CreateSchemaObjectsSQLBuilder.php  | 73 +++++++++++++++++
 .../src/SQL/Builder/DefaultSelectSQLBuilder.php    | 94 ++++++++++++++++++++++
 .../SQL/Builder/DropSchemaObjectsSQLBuilder.php    | 54 +++++++++++++
 .../dbal/src/SQL/Builder/SelectSQLBuilder.php      | 14 ++++
 4 files changed, 235 insertions(+)
 create mode 100644 vendor/doctrine/dbal/src/SQL/Builder/CreateSchemaObjectsSQLBuilder.php
 create mode 100644 vendor/doctrine/dbal/src/SQL/Builder/DefaultSelectSQLBuilder.php
 create mode 100644 vendor/doctrine/dbal/src/SQL/Builder/DropSchemaObjectsSQLBuilder.php
 create mode 100644 vendor/doctrine/dbal/src/SQL/Builder/SelectSQLBuilder.php

(limited to 'vendor/doctrine/dbal/src/SQL/Builder')

diff --git a/vendor/doctrine/dbal/src/SQL/Builder/CreateSchemaObjectsSQLBuilder.php b/vendor/doctrine/dbal/src/SQL/Builder/CreateSchemaObjectsSQLBuilder.php
new file mode 100644
index 0000000..5f6a77a
--- /dev/null
+++ b/vendor/doctrine/dbal/src/SQL/Builder/CreateSchemaObjectsSQLBuilder.php
@@ -0,0 +1,73 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\SQL\Builder;
+
+use Doctrine\DBAL\Platforms\AbstractPlatform;
+use Doctrine\DBAL\Schema\Schema;
+use Doctrine\DBAL\Schema\Sequence;
+use Doctrine\DBAL\Schema\Table;
+
+use function array_merge;
+
+final class CreateSchemaObjectsSQLBuilder
+{
+    public function __construct(private readonly AbstractPlatform $platform)
+    {
+    }
+
+    /** @return list<string> */
+    public function buildSQL(Schema $schema): array
+    {
+        return array_merge(
+            $this->buildNamespaceStatements($schema->getNamespaces()),
+            $this->buildSequenceStatements($schema->getSequences()),
+            $this->buildTableStatements($schema->getTables()),
+        );
+    }
+
+    /**
+     * @param list<string> $namespaces
+     *
+     * @return list<string>
+     */
+    private function buildNamespaceStatements(array $namespaces): array
+    {
+        $statements = [];
+
+        if ($this->platform->supportsSchemas()) {
+            foreach ($namespaces as $namespace) {
+                $statements[] = $this->platform->getCreateSchemaSQL($namespace);
+            }
+        }
+
+        return $statements;
+    }
+
+    /**
+     * @param list<Table> $tables
+     *
+     * @return list<string>
+     */
+    private function buildTableStatements(array $tables): array
+    {
+        return $this->platform->getCreateTablesSQL($tables);
+    }
+
+    /**
+     * @param list<Sequence> $sequences
+     *
+     * @return list<string>
+     */
+    private function buildSequenceStatements(array $sequences): array
+    {
+        $statements = [];
+
+        foreach ($sequences as $sequence) {
+            $statements[] = $this->platform->getCreateSequenceSQL($sequence);
+        }
+
+        return $statements;
+    }
+}
diff --git a/vendor/doctrine/dbal/src/SQL/Builder/DefaultSelectSQLBuilder.php b/vendor/doctrine/dbal/src/SQL/Builder/DefaultSelectSQLBuilder.php
new file mode 100644
index 0000000..a30120e
--- /dev/null
+++ b/vendor/doctrine/dbal/src/SQL/Builder/DefaultSelectSQLBuilder.php
@@ -0,0 +1,94 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\SQL\Builder;
+
+use Doctrine\DBAL\Exception;
+use Doctrine\DBAL\Platforms\AbstractPlatform;
+use Doctrine\DBAL\Platforms\Exception\NotSupported;
+use Doctrine\DBAL\Query\ForUpdate\ConflictResolutionMode;
+use Doctrine\DBAL\Query\SelectQuery;
+
+use function count;
+use function implode;
+
+final class DefaultSelectSQLBuilder implements SelectSQLBuilder
+{
+    /** @internal The SQL builder should be instantiated only by database platforms. */
+    public function __construct(
+        private readonly AbstractPlatform $platform,
+        private readonly ?string $forUpdateSQL,
+        private readonly ?string $skipLockedSQL,
+    ) {
+    }
+
+    /** @throws Exception */
+    public function buildSQL(SelectQuery $query): string
+    {
+        $parts = ['SELECT'];
+
+        if ($query->isDistinct()) {
+            $parts[] = 'DISTINCT';
+        }
+
+        $parts[] = implode(', ', $query->getColumns());
+
+        $from = $query->getFrom();
+
+        if (count($from) > 0) {
+            $parts[] = 'FROM ' . implode(', ', $from);
+        }
+
+        $where = $query->getWhere();
+
+        if ($where !== null) {
+            $parts[] = 'WHERE ' . $where;
+        }
+
+        $groupBy = $query->getGroupBy();
+
+        if (count($groupBy) > 0) {
+            $parts[] = 'GROUP BY ' . implode(', ', $groupBy);
+        }
+
+        $having = $query->getHaving();
+
+        if ($having !== null) {
+            $parts[] = 'HAVING ' . $having;
+        }
+
+        $orderBy = $query->getOrderBy();
+
+        if (count($orderBy) > 0) {
+            $parts[] = 'ORDER BY ' . implode(', ', $orderBy);
+        }
+
+        $sql   = implode(' ', $parts);
+        $limit = $query->getLimit();
+
+        if ($limit->isDefined()) {
+            $sql = $this->platform->modifyLimitQuery($sql, $limit->getMaxResults(), $limit->getFirstResult());
+        }
+
+        $forUpdate = $query->getForUpdate();
+
+        if ($forUpdate !== null) {
+            if ($this->forUpdateSQL === null) {
+                throw NotSupported::new('FOR UPDATE');
+            }
+
+            $sql .= ' ' . $this->forUpdateSQL;
+
+            if ($forUpdate->getConflictResolutionMode() === ConflictResolutionMode::SKIP_LOCKED) {
+                if ($this->skipLockedSQL === null) {
+                    throw NotSupported::new('SKIP LOCKED');
+                }
+
+                $sql .= ' ' . $this->skipLockedSQL;
+            }
+        }
+
+        return $sql;
+    }
+}
diff --git a/vendor/doctrine/dbal/src/SQL/Builder/DropSchemaObjectsSQLBuilder.php b/vendor/doctrine/dbal/src/SQL/Builder/DropSchemaObjectsSQLBuilder.php
new file mode 100644
index 0000000..c038489
--- /dev/null
+++ b/vendor/doctrine/dbal/src/SQL/Builder/DropSchemaObjectsSQLBuilder.php
@@ -0,0 +1,54 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\SQL\Builder;
+
+use Doctrine\DBAL\Platforms\AbstractPlatform;
+use Doctrine\DBAL\Schema\Schema;
+use Doctrine\DBAL\Schema\Sequence;
+use Doctrine\DBAL\Schema\Table;
+
+use function array_merge;
+
+final class DropSchemaObjectsSQLBuilder
+{
+    public function __construct(private readonly AbstractPlatform $platform)
+    {
+    }
+
+    /** @return list<string> */
+    public function buildSQL(Schema $schema): array
+    {
+        return array_merge(
+            $this->buildSequenceStatements($schema->getSequences()),
+            $this->buildTableStatements($schema->getTables()),
+        );
+    }
+
+    /**
+     * @param list<Table> $tables
+     *
+     * @return list<string>
+     */
+    private function buildTableStatements(array $tables): array
+    {
+        return $this->platform->getDropTablesSQL($tables);
+    }
+
+    /**
+     * @param list<Sequence> $sequences
+     *
+     * @return list<string>
+     */
+    private function buildSequenceStatements(array $sequences): array
+    {
+        $statements = [];
+
+        foreach ($sequences as $sequence) {
+            $statements[] = $this->platform->getDropSequenceSQL($sequence->getQuotedName($this->platform));
+        }
+
+        return $statements;
+    }
+}
diff --git a/vendor/doctrine/dbal/src/SQL/Builder/SelectSQLBuilder.php b/vendor/doctrine/dbal/src/SQL/Builder/SelectSQLBuilder.php
new file mode 100644
index 0000000..c013f96
--- /dev/null
+++ b/vendor/doctrine/dbal/src/SQL/Builder/SelectSQLBuilder.php
@@ -0,0 +1,14 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Doctrine\DBAL\SQL\Builder;
+
+use Doctrine\DBAL\Exception;
+use Doctrine\DBAL\Query\SelectQuery;
+
+interface SelectSQLBuilder
+{
+    /** @throws Exception */
+    public function buildSQL(SelectQuery $query): string;
+}
-- 
cgit v1.2.3