packages/sql-semantics-mysql/resources/models/Value/CreateWithCreateUserOptIfNotExistsClearPrivilegesGrantListRequireClauseConnectOptions_85d2fc69.php
1<?php
2
3declare(strict_types=1);
4
5namespace SqlSemantics\Statement\Model\MySql\Value;
6
7/**
8 * The create 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\CreateWithCreateUserOptIfNotExistsClearPrivilegesGrantListRequireClauseConnectOptions_85d2fc69 $value): string => \SqlSemantics\Statement\Writer::render($value);
13 * $write instanceof \Closure // => true
14 */
15final class CreateWithCreateUserOptIfNotExistsClearPrivilegesGrantListRequireClauseConnectOptions_85d2fc69 implements \SqlSemantics\Statement\Model\MySql\Role\CreateForm, \SqlSemantics\Statement\Model\MySql\Role\EvSqlStmtForm, \SqlSemantics\Statement\Model\MySql\Role\EvSqlStmtInnerForm, \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\StatementForm, \SqlSemantics\Statement\Model\MySql\Role\StoredRoutineBodyForm, \SqlSemantics\Statement\Model\MySql\Role\VerbClauseForm, \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 string $user,
24 public readonly \SqlSemantics\Statement\Model\MySql\Role\OptIfNotExistsForm $optIfNotExists,
25 public readonly \SqlSemantics\Statement\Model\MySql\Role\ClearPrivilegesForm $clearPrivileges,
26 public readonly \SqlSemantics\Statement\Model\MySql\Role\GrantListForm $grantList,
27 public readonly \SqlSemantics\Statement\Model\MySql\Role\RequireClauseForm $requireClause,
28 public readonly \SqlSemantics\Statement\Model\MySql\Role\ConnectOptionsForm $connectOptions,
29 public readonly \SqlSemantics\Statement\Model\MySql\Role\OptAccountLockPasswordExpireOptionsForm $optAccountLockPasswordExpireOptions,
30 public readonly \SqlSemantics\Statement\Comments $comments = new \SqlSemantics\Statement\Comments(),
31 ) {
32 $this->assertMatchesPattern($user, \SqlSemantics\Statement\Model\MySql\Contract\Contracts::SPELLINGS['USER'], 'The user must be a complete USER lexical spelling.');
33 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optIfNotExists), 'The optIfNotExists must be a generated immutable SQL value.');
34 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($clearPrivileges), 'The clearPrivileges must be a generated immutable SQL value.');
35 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($grantList), 'The grantList must be a generated immutable SQL value.');
36 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($requireClause), 'The requireClause must be a generated immutable SQL value.');
37 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($connectOptions), 'The connectOptions must be a generated immutable SQL value.');
38 $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optAccountLockPasswordExpireOptions), 'The optAccountLockPasswordExpireOptions 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('CREATE');
48 $writer->comments($this->comments, 1);
49 $writer->append($this->user);
50 $writer->comments($this->comments, 2);
51 $this->optIfNotExists->write($writer);
52 $writer->comments($this->comments, 3);
53 $this->clearPrivileges->write($writer);
54 $writer->comments($this->comments, 4);
55 $this->grantList->write($writer);
56 $writer->comments($this->comments, 5);
57 $this->requireClause->write($writer);
58 $writer->comments($this->comments, 6);
59 $this->connectOptions->write($writer);
60 $writer->comments($this->comments, 7);
61 $this->optAccountLockPasswordExpireOptions->write($writer);
62 }
63
64 /**
65 * Returns a copy with a new user, preserving every other field.
66 */
67 public function withUser(string $user): self
68 {
69 return new self($user, $this->optIfNotExists, $this->clearPrivileges, $this->grantList, $this->requireClause, $this->connectOptions, $this->optAccountLockPasswordExpireOptions, $this->comments);
70 }
71
72 /**
73 * Returns a copy with a new optIfNotExists, preserving every other field.
74 */
75 public function withOptIfNotExists(\SqlSemantics\Statement\Model\MySql\Role\OptIfNotExistsForm $optIfNotExists): self
76 {
77 return new self($this->user, $optIfNotExists, $this->clearPrivileges, $this->grantList, $this->requireClause, $this->connectOptions, $this->optAccountLockPasswordExpireOptions, $this->comments);
78 }
79
80 /**
81 * Returns a copy with a new clearPrivileges, preserving every other field.
82 */
83 public function withClearPrivileges(\SqlSemantics\Statement\Model\MySql\Role\ClearPrivilegesForm $clearPrivileges): self
84 {
85 return new self($this->user, $this->optIfNotExists, $clearPrivileges, $this->grantList, $this->requireClause, $this->connectOptions, $this->optAccountLockPasswordExpireOptions, $this->comments);
86 }
87
88 /**
89 * Returns a copy with a new grantList, preserving every other field.
90 */
91 public function withGrantList(\SqlSemantics\Statement\Model\MySql\Role\GrantListForm $grantList): self
92 {
93 return new self($this->user, $this->optIfNotExists, $this->clearPrivileges, $grantList, $this->requireClause, $this->connectOptions, $this->optAccountLockPasswordExpireOptions, $this->comments);
94 }
95
96 /**
97 * Returns a copy with a new requireClause, preserving every other field.
98 */
99 public function withRequireClause(\SqlSemantics\Statement\Model\MySql\Role\RequireClauseForm $requireClause): self
100 {
101 return new self($this->user, $this->optIfNotExists, $this->clearPrivileges, $this->grantList, $requireClause, $this->connectOptions, $this->optAccountLockPasswordExpireOptions, $this->comments);
102 }
103
104 /**
105 * Returns a copy with a new connectOptions, preserving every other field.
106 */
107 public function withConnectOptions(\SqlSemantics\Statement\Model\MySql\Role\ConnectOptionsForm $connectOptions): self
108 {
109 return new self($this->user, $this->optIfNotExists, $this->clearPrivileges, $this->grantList, $this->requireClause, $connectOptions, $this->optAccountLockPasswordExpireOptions, $this->comments);
110 }
111
112 /**
113 * Returns a copy with a new optAccountLockPasswordExpireOptions, preserving every other field.
114 */
115 public function withOptAccountLockPasswordExpireOptions(\SqlSemantics\Statement\Model\MySql\Role\OptAccountLockPasswordExpireOptionsForm $optAccountLockPasswordExpireOptions): self
116 {
117 return new self($this->user, $this->optIfNotExists, $this->clearPrivileges, $this->grantList, $this->requireClause, $this->connectOptions, $optAccountLockPasswordExpireOptions, $this->comments);
118 }
119
120 /**
121 * Returns a copy with a new comments, preserving every other field.
122 */
123 public function withComments(\SqlSemantics\Statement\Comments $comments): self
124 {
125 return new self($this->user, $this->optIfNotExists, $this->clearPrivileges, $this->grantList, $this->requireClause, $this->connectOptions, $this->optAccountLockPasswordExpireOptions, $comments);
126 }
127}
128