packages/sql-semantics-mysql/resources/models/Value/AlterWithAlterDefinerOptEventSymSpNameEvAlterOnScheduleCompletionOptEvRenameToOptEvS_dfabb8a0.php
1<?php
2
3declare(strict_types=1);
4
5namespace SqlSemantics\Statement\Model\MySql\Value;
6
7/**
8 * The alter 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\AlterWithAlterDefinerOptEventSymSpNameEvAlterOnScheduleCompletionOptEvRenameToOptEvS_dfabb8a0 $value): string => \SqlSemantics\Statement\Writer::render($value);
13 * $write instanceof \Closure // => true
14 */
15final class AlterWithAlterDefinerOptEventSymSpNameEvAlterOnScheduleCompletionOptEvRenameToOptEvS_dfabb8a0 implements \SqlSemantics\Statement\Model\MySql\Role\AlterForm, \SqlSemantics\Statement\Model\MySql\Role\EvSqlStmtForm, \SqlSemantics\Statement\Model\MySql\Role\EvSqlStmtInnerForm, \SqlSemantics\Statement\Model\MySql\Role\SpProcStmtForm, \SqlSemantics\Statement\Model\MySql\Role\SpProcStmtStatementForm, \SqlSemantics\Statement\Model\MySql\Role\StatementForm, \SqlSemantics\Statement\Model\MySql\Role\StoredRoutineBodyForm, \SqlSemantics\Statement\Model\MySql\Role\VerbClauseForm
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\DefinerOptForm $definerOpt,
24 public readonly \SqlSemantics\Statement\Model\MySql\Role\SpNameForm $spName,
25 public readonly \SqlSemantics\Statement\Model\MySql\Role\EvAlterOnScheduleCompletionForm $evAlterOnScheduleCompletion,
26 public readonly \SqlSemantics\Statement\Model\MySql\Role\OptEvRenameToForm $optEvRenameTo,
27 public readonly \SqlSemantics\Statement\Model\MySql\Role\OptEvStatusForm $optEvStatus,
28 public readonly \SqlSemantics\Statement\Model\MySql\Role\OptEvCommentForm $optEvComment,
29 public readonly \SqlSemantics\Statement\Model\MySql\Role\OptEvSqlStmtForm $optEvSqlStmt,
30 public readonly \SqlSemantics\Statement\Comments $comments = new \SqlSemantics\Statement\Comments(),
31 ) {
32 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($definerOpt), 'The definerOpt must be a generated immutable SQL value.');
33 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($spName), 'The spName must be a generated immutable SQL value.');
34 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($evAlterOnScheduleCompletion), 'The evAlterOnScheduleCompletion must be a generated immutable SQL value.');
35 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optEvRenameTo), 'The optEvRenameTo must be a generated immutable SQL value.');
36 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optEvStatus), 'The optEvStatus must be a generated immutable SQL value.');
37 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optEvComment), 'The optEvComment must be a generated immutable SQL value.');
38 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optEvSqlStmt), 'The optEvSqlStmt must be a generated immutable SQL value.');
39 }
40
41 /**
42 * Writes SQL entirely from this value's fields.
43 */
44 public function write(\SqlSemantics\Statement\Writer $writer): void
45 {
46 $writer->comments($this->comments, 0);
47 $writer->append('ALTER');
48 $writer->comments($this->comments, 1);
49 $this->definerOpt->write($writer);
50 $writer->comments($this->comments, 2);
51 $writer->append('EVENT');
52 $writer->comments($this->comments, 3);
53 $this->spName->write($writer);
54 $writer->comments($this->comments, 4);
55 $this->evAlterOnScheduleCompletion->write($writer);
56 $writer->comments($this->comments, 5);
57 $this->optEvRenameTo->write($writer);
58 $writer->comments($this->comments, 6);
59 $this->optEvStatus->write($writer);
60 $writer->comments($this->comments, 7);
61 $this->optEvComment->write($writer);
62 $writer->comments($this->comments, 8);
63 $this->optEvSqlStmt->write($writer);
64 }
65
66 /**
67 * Returns a copy with a new definerOpt, preserving every other field.
68 */
69 public function withDefinerOpt(\SqlSemantics\Statement\Model\MySql\Role\DefinerOptForm $definerOpt): self
70 {
71 return new self($definerOpt, $this->spName, $this->evAlterOnScheduleCompletion, $this->optEvRenameTo, $this->optEvStatus, $this->optEvComment, $this->optEvSqlStmt, $this->comments);
72 }
73
74 /**
75 * Returns a copy with a new spName, preserving every other field.
76 */
77 public function withSpName(\SqlSemantics\Statement\Model\MySql\Role\SpNameForm $spName): self
78 {
79 return new self($this->definerOpt, $spName, $this->evAlterOnScheduleCompletion, $this->optEvRenameTo, $this->optEvStatus, $this->optEvComment, $this->optEvSqlStmt, $this->comments);
80 }
81
82 /**
83 * Returns a copy with a new evAlterOnScheduleCompletion, preserving every other field.
84 */
85 public function withEvAlterOnScheduleCompletion(\SqlSemantics\Statement\Model\MySql\Role\EvAlterOnScheduleCompletionForm $evAlterOnScheduleCompletion): self
86 {
87 return new self($this->definerOpt, $this->spName, $evAlterOnScheduleCompletion, $this->optEvRenameTo, $this->optEvStatus, $this->optEvComment, $this->optEvSqlStmt, $this->comments);
88 }
89
90 /**
91 * Returns a copy with a new optEvRenameTo, preserving every other field.
92 */
93 public function withOptEvRenameTo(\SqlSemantics\Statement\Model\MySql\Role\OptEvRenameToForm $optEvRenameTo): self
94 {
95 return new self($this->definerOpt, $this->spName, $this->evAlterOnScheduleCompletion, $optEvRenameTo, $this->optEvStatus, $this->optEvComment, $this->optEvSqlStmt, $this->comments);
96 }
97
98 /**
99 * Returns a copy with a new optEvStatus, preserving every other field.
100 */
101 public function withOptEvStatus(\SqlSemantics\Statement\Model\MySql\Role\OptEvStatusForm $optEvStatus): self
102 {
103 return new self($this->definerOpt, $this->spName, $this->evAlterOnScheduleCompletion, $this->optEvRenameTo, $optEvStatus, $this->optEvComment, $this->optEvSqlStmt, $this->comments);
104 }
105
106 /**
107 * Returns a copy with a new optEvComment, preserving every other field.
108 */
109 public function withOptEvComment(\SqlSemantics\Statement\Model\MySql\Role\OptEvCommentForm $optEvComment): self
110 {
111 return new self($this->definerOpt, $this->spName, $this->evAlterOnScheduleCompletion, $this->optEvRenameTo, $this->optEvStatus, $optEvComment, $this->optEvSqlStmt, $this->comments);
112 }
113
114 /**
115 * Returns a copy with a new optEvSqlStmt, preserving every other field.
116 */
117 public function withOptEvSqlStmt(\SqlSemantics\Statement\Model\MySql\Role\OptEvSqlStmtForm $optEvSqlStmt): self
118 {
119 return new self($this->definerOpt, $this->spName, $this->evAlterOnScheduleCompletion, $this->optEvRenameTo, $this->optEvStatus, $this->optEvComment, $optEvSqlStmt, $this->comments);
120 }
121
122 /**
123 * Returns a copy with a new comments, preserving every other field.
124 */
125 public function withComments(\SqlSemantics\Statement\Comments $comments): self
126 {
127 return new self($this->definerOpt, $this->spName, $this->evAlterOnScheduleCompletion, $this->optEvRenameTo, $this->optEvStatus, $this->optEvComment, $this->optEvSqlStmt, $comments);
128 }
129}
130