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

1<?php
2
3declare(strict_types=1);
4
5namespace SqlSemantics\Statement\Model\MySql\Value;
6
7/**
8 * The query_specification 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\QuerySpecificationWithSelectSymSelectOptionsSelectItemListIntoClauseOptFromClauseOptWhereClauseOp_64027ed6 $value): string => \SqlSemantics\Statement\Writer::render($value);
13 *     $write instanceof \Closure // => true
14 */
15final class QuerySpecificationWithSelectSymSelectOptionsSelectItemListIntoClauseOptFromClauseOptWhereClauseOp_64027ed6 implements \SqlSemantics\Statement\Model\MySql\Role\QueryExpressionBodyForm, \SqlSemantics\Statement\Model\MySql\Role\QueryPrimaryForm, \SqlSemantics\Statement\Model\MySql\Role\QuerySpecificationForm, \SqlSemantics\Statement\Model\MySql\Role\SubselectForm
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\SelectOptionsForm $options,
24        public readonly \SqlSemantics\Statement\Model\MySql\Role\SelectItemListForm $projections,
25        public readonly \SqlSemantics\Statement\Model\MySql\Role\IntoClauseForm $intoClause,
26        public readonly \SqlSemantics\Statement\Model\MySql\Role\OptFromClauseForm $from,
27        public readonly \SqlSemantics\Statement\Model\MySql\Role\OptWhereClauseForm $where,
28        public readonly \SqlSemantics\Statement\Model\MySql\Role\OptGroupClauseForm $optGroupClause,
29        public readonly \SqlSemantics\Statement\Model\MySql\Role\OptHavingClauseForm $optHavingClause,
30        public readonly \SqlSemantics\Statement\Model\MySql\Role\OptWindowClauseForm $optWindowClause,
31        public readonly \SqlSemantics\Statement\Model\MySql\Role\OptQualifyClauseForm $optQualifyClause,
32        public readonly \SqlSemantics\Statement\Comments $comments = new \SqlSemantics\Statement\Comments(),
33    ) {
34        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($options), 'The options must be a generated immutable SQL value.');
35        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($projections), 'The projections must be a generated immutable SQL value.');
36        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($intoClause), 'The intoClause must be a generated immutable SQL value.');
37        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($from), 'The from must be a generated immutable SQL value.');
38        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($where), 'The where must be a generated immutable SQL value.');
39        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optGroupClause), 'The optGroupClause must be a generated immutable SQL value.');
40        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optHavingClause), 'The optHavingClause must be a generated immutable SQL value.');
41        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optWindowClause), 'The optWindowClause must be a generated immutable SQL value.');
42        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optQualifyClause), 'The optQualifyClause must be a generated immutable SQL value.');
43    }
44
45    /**
46     * Writes SQL entirely from this value's fields.
47     */
48    public function write(\SqlSemantics\Statement\Writer $writer): void
49    {
50        $writer->comments($this->comments, 0);
51        $writer->append('SELECT');
52        $writer->comments($this->comments, 1);
53        $this->options->write($writer);
54        $writer->comments($this->comments, 2);
55        $this->projections->write($writer);
56        $writer->comments($this->comments, 3);
57        $this->intoClause->write($writer);
58        $writer->comments($this->comments, 4);
59        $this->from->write($writer);
60        $writer->comments($this->comments, 5);
61        $this->where->write($writer);
62        $writer->comments($this->comments, 6);
63        $this->optGroupClause->write($writer);
64        $writer->comments($this->comments, 7);
65        $this->optHavingClause->write($writer);
66        $writer->comments($this->comments, 8);
67        $this->optWindowClause->write($writer);
68        $writer->comments($this->comments, 9);
69        $this->optQualifyClause->write($writer);
70    }
71
72    /**
73     * Returns a copy with a new options, preserving every other field.
74     */
75    public function withOptions(\SqlSemantics\Statement\Model\MySql\Role\SelectOptionsForm $options): self
76    {
77        return new self($options, $this->projections, $this->intoClause, $this->from, $this->where, $this->optGroupClause, $this->optHavingClause, $this->optWindowClause, $this->optQualifyClause, $this->comments);
78    }
79
80    /**
81     * Returns a copy with a new projections, preserving every other field.
82     */
83    public function withProjections(\SqlSemantics\Statement\Model\MySql\Role\SelectItemListForm $projections): self
84    {
85        return new self($this->options, $projections, $this->intoClause, $this->from, $this->where, $this->optGroupClause, $this->optHavingClause, $this->optWindowClause, $this->optQualifyClause, $this->comments);
86    }
87
88    /**
89     * Returns a copy with a new intoClause, preserving every other field.
90     */
91    public function withIntoClause(\SqlSemantics\Statement\Model\MySql\Role\IntoClauseForm $intoClause): self
92    {
93        return new self($this->options, $this->projections, $intoClause, $this->from, $this->where, $this->optGroupClause, $this->optHavingClause, $this->optWindowClause, $this->optQualifyClause, $this->comments);
94    }
95
96    /**
97     * Returns a copy with a new from, preserving every other field.
98     */
99    public function withFrom(\SqlSemantics\Statement\Model\MySql\Role\OptFromClauseForm $from): self
100    {
101        return new self($this->options, $this->projections, $this->intoClause, $from, $this->where, $this->optGroupClause, $this->optHavingClause, $this->optWindowClause, $this->optQualifyClause, $this->comments);
102    }
103
104    /**
105     * Returns a copy with a new where, preserving every other field.
106     */
107    public function withWhere(\SqlSemantics\Statement\Model\MySql\Role\OptWhereClauseForm $where): self
108    {
109        return new self($this->options, $this->projections, $this->intoClause, $this->from, $where, $this->optGroupClause, $this->optHavingClause, $this->optWindowClause, $this->optQualifyClause, $this->comments);
110    }
111
112    /**
113     * Returns a copy with a new optGroupClause, preserving every other field.
114     */
115    public function withOptGroupClause(\SqlSemantics\Statement\Model\MySql\Role\OptGroupClauseForm $optGroupClause): self
116    {
117        return new self($this->options, $this->projections, $this->intoClause, $this->from, $this->where, $optGroupClause, $this->optHavingClause, $this->optWindowClause, $this->optQualifyClause, $this->comments);
118    }
119
120    /**
121     * Returns a copy with a new optHavingClause, preserving every other field.
122     */
123    public function withOptHavingClause(\SqlSemantics\Statement\Model\MySql\Role\OptHavingClauseForm $optHavingClause): self
124    {
125        return new self($this->options, $this->projections, $this->intoClause, $this->from, $this->where, $this->optGroupClause, $optHavingClause, $this->optWindowClause, $this->optQualifyClause, $this->comments);
126    }
127
128    /**
129     * Returns a copy with a new optWindowClause, preserving every other field.
130     */
131    public function withOptWindowClause(\SqlSemantics\Statement\Model\MySql\Role\OptWindowClauseForm $optWindowClause): self
132    {
133        return new self($this->options, $this->projections, $this->intoClause, $this->from, $this->where, $this->optGroupClause, $this->optHavingClause, $optWindowClause, $this->optQualifyClause, $this->comments);
134    }
135
136    /**
137     * Returns a copy with a new optQualifyClause, preserving every other field.
138     */
139    public function withOptQualifyClause(\SqlSemantics\Statement\Model\MySql\Role\OptQualifyClauseForm $optQualifyClause): self
140    {
141        return new self($this->options, $this->projections, $this->intoClause, $this->from, $this->where, $this->optGroupClause, $this->optHavingClause, $this->optWindowClause, $optQualifyClause, $this->comments);
142    }
143
144    /**
145     * Returns a copy with a new comments, preserving every other field.
146     */
147    public function withComments(\SqlSemantics\Statement\Comments $comments): self
148    {
149        return new self($this->options, $this->projections, $this->intoClause, $this->from, $this->where, $this->optGroupClause, $this->optHavingClause, $this->optWindowClause, $this->optQualifyClause, $comments);
150    }
151}
152