packages/sql-semantics-postgres/resources/models/Value/SimpleSelectWithSelectDistinctClauseTargetListIntoClauseFromClauseWhereClauseGroupClauseHav_83a4cbe8.php
1<?php
2
3declare(strict_types=1);
4
5namespace SqlSemantics\Statement\Model\PostgreSql\Value;
6
7/**
8 * The simple_select 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\PostgreSql\Value\SimpleSelectWithSelectDistinctClauseTargetListIntoClauseFromClauseWhereClauseGroupClauseHav_83a4cbe8 $value): string => \SqlSemantics\Statement\Writer::render($value);
13 * $write instanceof \Closure // => true
14 */
15final class SimpleSelectWithSelectDistinctClauseTargetListIntoClauseFromClauseWhereClauseGroupClauseHav_83a4cbe8 implements \SqlSemantics\Statement\Model\PostgreSql\Role\ExplainableStmtForm, \SqlSemantics\Statement\Model\PostgreSql\Role\PreparableStmtForm, \SqlSemantics\Statement\Model\PostgreSql\Role\RuleActionListForm, \SqlSemantics\Statement\Model\PostgreSql\Role\RuleActionMultiForm, \SqlSemantics\Statement\Model\PostgreSql\Role\RuleActionStmtForm, \SqlSemantics\Statement\Model\PostgreSql\Role\RuleActionStmtOrEmptyForm, \SqlSemantics\Statement\Model\PostgreSql\Role\SelectStmtForm, \SqlSemantics\Statement\Model\PostgreSql\Role\InsertRestForm, \SqlSemantics\Statement\Model\PostgreSql\Role\ParseToplevelForm, \SqlSemantics\Statement\Model\PostgreSql\Role\RoutineBodyStmtForm, \SqlSemantics\Statement\Model\PostgreSql\Role\SelectClauseForm, \SqlSemantics\Statement\Model\PostgreSql\Role\SelectNoParensForm, \SqlSemantics\Statement\Model\PostgreSql\Role\SimpleSelectForm, \SqlSemantics\Statement\Model\PostgreSql\Role\StmtForm, \SqlSemantics\Statement\Model\PostgreSql\Role\StmtmultiForm, \SqlSemantics\Statement\Model\PostgreSql\Role\ToplevelStmtForm, \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\PostgreSql\Role\DistinctClauseForm $distinct,
24 public readonly \SqlSemantics\Statement\Model\PostgreSql\Role\TargetListForm $projections,
25 public readonly \SqlSemantics\Statement\Model\PostgreSql\Role\IntoClauseForm $intoClause,
26 public readonly \SqlSemantics\Statement\Model\PostgreSql\Role\FromClauseForm $from,
27 public readonly \SqlSemantics\Statement\Model\PostgreSql\Role\WhereClauseForm $where,
28 public readonly \SqlSemantics\Statement\Model\PostgreSql\Role\GroupClauseForm $groupBy,
29 public readonly \SqlSemantics\Statement\Model\PostgreSql\Role\HavingClauseForm $having,
30 public readonly \SqlSemantics\Statement\Model\PostgreSql\Role\WindowClauseForm $windowClause,
31 public readonly \SqlSemantics\Statement\Comments $comments = new \SqlSemantics\Statement\Comments(),
32 ) {
33 $this->assert(\SqlSemantics\Statement\Model\PostgreSql\Contract\Contracts::contains($distinct), 'The distinct must be a generated immutable SQL value.');
34 $this->assert(\SqlSemantics\Statement\Model\PostgreSql\Contract\Contracts::contains($projections), 'The projections must be a generated immutable SQL value.');
35 $this->assert(\SqlSemantics\Statement\Model\PostgreSql\Contract\Contracts::contains($intoClause), 'The intoClause must be a generated immutable SQL value.');
36 $this->assert(\SqlSemantics\Statement\Model\PostgreSql\Contract\Contracts::contains($from), 'The from must be a generated immutable SQL value.');
37 $this->assert(\SqlSemantics\Statement\Model\PostgreSql\Contract\Contracts::contains($where), 'The where must be a generated immutable SQL value.');
38 $this->assert(\SqlSemantics\Statement\Model\PostgreSql\Contract\Contracts::contains($groupBy), 'The groupBy must be a generated immutable SQL value.');
39 $this->assert(\SqlSemantics\Statement\Model\PostgreSql\Contract\Contracts::contains($having), 'The having must be a generated immutable SQL value.');
40 $this->assert(\SqlSemantics\Statement\Model\PostgreSql\Contract\Contracts::contains($windowClause), 'The windowClause must be a generated immutable SQL value.');
41 }
42
43 /**
44 * Writes SQL entirely from this value's fields.
45 */
46 public function write(\SqlSemantics\Statement\Writer $writer): void
47 {
48 $writer->comments($this->comments, 0);
49 $writer->append('SELECT');
50 $writer->comments($this->comments, 1);
51 $this->distinct->write($writer);
52 $writer->comments($this->comments, 2);
53 $this->projections->write($writer);
54 $writer->comments($this->comments, 3);
55 $this->intoClause->write($writer);
56 $writer->comments($this->comments, 4);
57 $this->from->write($writer);
58 $writer->comments($this->comments, 5);
59 $this->where->write($writer);
60 $writer->comments($this->comments, 6);
61 $this->groupBy->write($writer);
62 $writer->comments($this->comments, 7);
63 $this->having->write($writer);
64 $writer->comments($this->comments, 8);
65 $this->windowClause->write($writer);
66 }
67
68 /**
69 * Returns a copy with a new distinct, preserving every other field.
70 */
71 public function withDistinct(\SqlSemantics\Statement\Model\PostgreSql\Role\DistinctClauseForm $distinct): self
72 {
73 return new self($distinct, $this->projections, $this->intoClause, $this->from, $this->where, $this->groupBy, $this->having, $this->windowClause, $this->comments);
74 }
75
76 /**
77 * Returns a copy with a new projections, preserving every other field.
78 */
79 public function withProjections(\SqlSemantics\Statement\Model\PostgreSql\Role\TargetListForm $projections): self
80 {
81 return new self($this->distinct, $projections, $this->intoClause, $this->from, $this->where, $this->groupBy, $this->having, $this->windowClause, $this->comments);
82 }
83
84 /**
85 * Returns a copy with a new intoClause, preserving every other field.
86 */
87 public function withIntoClause(\SqlSemantics\Statement\Model\PostgreSql\Role\IntoClauseForm $intoClause): self
88 {
89 return new self($this->distinct, $this->projections, $intoClause, $this->from, $this->where, $this->groupBy, $this->having, $this->windowClause, $this->comments);
90 }
91
92 /**
93 * Returns a copy with a new from, preserving every other field.
94 */
95 public function withFrom(\SqlSemantics\Statement\Model\PostgreSql\Role\FromClauseForm $from): self
96 {
97 return new self($this->distinct, $this->projections, $this->intoClause, $from, $this->where, $this->groupBy, $this->having, $this->windowClause, $this->comments);
98 }
99
100 /**
101 * Returns a copy with a new where, preserving every other field.
102 */
103 public function withWhere(\SqlSemantics\Statement\Model\PostgreSql\Role\WhereClauseForm $where): self
104 {
105 return new self($this->distinct, $this->projections, $this->intoClause, $this->from, $where, $this->groupBy, $this->having, $this->windowClause, $this->comments);
106 }
107
108 /**
109 * Returns a copy with a new groupBy, preserving every other field.
110 */
111 public function withGroupBy(\SqlSemantics\Statement\Model\PostgreSql\Role\GroupClauseForm $groupBy): self
112 {
113 return new self($this->distinct, $this->projections, $this->intoClause, $this->from, $this->where, $groupBy, $this->having, $this->windowClause, $this->comments);
114 }
115
116 /**
117 * Returns a copy with a new having, preserving every other field.
118 */
119 public function withHaving(\SqlSemantics\Statement\Model\PostgreSql\Role\HavingClauseForm $having): self
120 {
121 return new self($this->distinct, $this->projections, $this->intoClause, $this->from, $this->where, $this->groupBy, $having, $this->windowClause, $this->comments);
122 }
123
124 /**
125 * Returns a copy with a new windowClause, preserving every other field.
126 */
127 public function withWindowClause(\SqlSemantics\Statement\Model\PostgreSql\Role\WindowClauseForm $windowClause): self
128 {
129 return new self($this->distinct, $this->projections, $this->intoClause, $this->from, $this->where, $this->groupBy, $this->having, $windowClause, $this->comments);
130 }
131
132 /**
133 * Returns a copy with a new comments, preserving every other field.
134 */
135 public function withComments(\SqlSemantics\Statement\Comments $comments): self
136 {
137 return new self($this->distinct, $this->projections, $this->intoClause, $this->from, $this->where, $this->groupBy, $this->having, $this->windowClause, $comments);
138 }
139}
140