packages/sql-semantics-mysql/resources/models/Value/QueryExpressionWithWithClauseQueryExpressionBodyOptOrderClauseOptLimitClause_f3d9f9a0.php

1<?php
2
3declare(strict_types=1);
4
5namespace SqlSemantics\Statement\Model\MySql\Value;
6
7/**
8 * The query_expression SQL value; generated by bin/build-models.php.
9 *
10 * @visibility public
11 * @example Accept a structured SQL value
12 *     $write = static fn (\SqlSemantics\Statement\Model\MySql\Value\QueryExpressionWithWithClauseQueryExpressionBodyOptOrderClauseOptLimitClause_f3d9f9a0 $value): string => \SqlSemantics\Statement\Writer::render($value);
13 *     $write instanceof \Closure // => true
14 */
15final class QueryExpressionWithWithClauseQueryExpressionBodyOptOrderClauseOptLimitClause_f3d9f9a0 implements \SqlSemantics\Statement\Model\MySql\Role\AsCreateQueryExpressionForm, \SqlSemantics\Statement\Model\MySql\Role\EvSqlStmtForm, \SqlSemantics\Statement\Model\MySql\Role\EvSqlStmtInnerForm, \SqlSemantics\Statement\Model\MySql\Role\ExplainableStmtForm, \SqlSemantics\Statement\Model\MySql\Role\InsertFromSubqueryForm, \SqlSemantics\Statement\Model\MySql\Role\InsertQueryExpressionForm, \SqlSemantics\Statement\Model\MySql\Role\OptCreatePartitioningEtcForm, \SqlSemantics\Statement\Model\MySql\Role\OptCreateTableOptionsEtcForm, \SqlSemantics\Statement\Model\MySql\Role\OptDuplicateAsQeForm, \SqlSemantics\Statement\Model\MySql\Role\QueryExpressionForm, \SqlSemantics\Statement\Model\MySql\Role\QueryExpressionWithOptLockingClausesForm, \SqlSemantics\Statement\Model\MySql\Role\SelectStmtForm, \SqlSemantics\Statement\Model\MySql\Role\SimpleStatementForm, \SqlSemantics\Statement\Model\MySql\Role\SimpleStatementOrBeginForm, \SqlSemantics\Statement\Model\MySql\Role\SpProcStmtForm, \SqlSemantics\Statement\Model\MySql\Role\SpProcStmtStatementForm, \SqlSemantics\Statement\Model\MySql\Role\StoredRoutineBodyForm, \SqlSemantics\Statement\Command
16{
17    use \SqlSemantics\Statement\Assertion;
18
19    /**
20     * Supplies the SQL values of this form; comments are kept by the position of the symbol each precedes.
21     */
22    public function __construct(
23        public readonly \SqlSemantics\Statement\Model\MySql\Role\WithClauseForm $with,
24        public readonly \SqlSemantics\Statement\Model\MySql\Role\QueryExpressionBodyForm $queryExpressionBody,
25        public readonly \SqlSemantics\Statement\Model\MySql\Role\OptOrderClauseForm $orderBy,
26        public readonly \SqlSemantics\Statement\Model\MySql\Role\OptLimitClauseForm $optLimitClause,
27        public readonly \SqlSemantics\Statement\Comments $comments = new \SqlSemantics\Statement\Comments(),
28    ) {
29        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($with), 'The with must be a generated immutable SQL value.');
30        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($queryExpressionBody), 'The queryExpressionBody must be a generated immutable SQL value.');
31        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($orderBy), 'The orderBy must be a generated immutable SQL value.');
32        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optLimitClause), 'The optLimitClause must be a generated immutable SQL value.');
33    }
34
35    /**
36     * Writes SQL entirely from this value's fields.
37     */
38    public function write(\SqlSemantics\Statement\Writer $writer): void
39    {
40        $writer->comments($this->comments, 0);
41        $this->with->write($writer);
42        $writer->comments($this->comments, 1);
43        $this->queryExpressionBody->write($writer);
44        $writer->comments($this->comments, 2);
45        $this->orderBy->write($writer);
46        $writer->comments($this->comments, 3);
47        $this->optLimitClause->write($writer);
48    }
49
50    /**
51     * Returns a copy with a new with, preserving every other field.
52     */
53    public function withWith(\SqlSemantics\Statement\Model\MySql\Role\WithClauseForm $with): self
54    {
55        return new self($with, $this->queryExpressionBody, $this->orderBy, $this->optLimitClause, $this->comments);
56    }
57
58    /**
59     * Returns a copy with a new queryExpressionBody, preserving every other field.
60     */
61    public function withQueryExpressionBody(\SqlSemantics\Statement\Model\MySql\Role\QueryExpressionBodyForm $queryExpressionBody): self
62    {
63        return new self($this->with, $queryExpressionBody, $this->orderBy, $this->optLimitClause, $this->comments);
64    }
65
66    /**
67     * Returns a copy with a new orderBy, preserving every other field.
68     */
69    public function withOrderBy(\SqlSemantics\Statement\Model\MySql\Role\OptOrderClauseForm $orderBy): self
70    {
71        return new self($this->with, $this->queryExpressionBody, $orderBy, $this->optLimitClause, $this->comments);
72    }
73
74    /**
75     * Returns a copy with a new optLimitClause, preserving every other field.
76     */
77    public function withOptLimitClause(\SqlSemantics\Statement\Model\MySql\Role\OptLimitClauseForm $optLimitClause): self
78    {
79        return new self($this->with, $this->queryExpressionBody, $this->orderBy, $optLimitClause, $this->comments);
80    }
81
82    /**
83     * Returns a copy with a new comments, preserving every other field.
84     */
85    public function withComments(\SqlSemantics\Statement\Comments $comments): self
86    {
87        return new self($this->with, $this->queryExpressionBody, $this->orderBy, $this->optLimitClause, $comments);
88    }
89}
90