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

1<?php
2
3declare(strict_types=1);
4
5namespace SqlSemantics\Statement\Model\MySql\Value;
6
7/**
8 * The sp_tail 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\SpTailWithProcedureSymOptIfNotExistsSpNameSpPdparamListSpCChisticsStoredRoutineBody_5e456216 $value): string => \SqlSemantics\Statement\Writer::render($value);
13 *     $write instanceof \Closure // => true
14 */
15final class SpTailWithProcedureSymOptIfNotExistsSpNameSpPdparamListSpCChisticsStoredRoutineBody_5e456216 implements \SqlSemantics\Statement\Model\MySql\Role\DefinerTailForm, \SqlSemantics\Statement\Model\MySql\Role\NoDefinerTailForm, \SqlSemantics\Statement\Model\MySql\Role\SpTailForm
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\OptIfNotExistsForm $optIfNotExists,
24        public readonly \SqlSemantics\Statement\Model\MySql\Role\SpNameForm $spName,
25        public readonly \SqlSemantics\Statement\Model\MySql\Role\SpPdparamListForm $spPdparamList,
26        public readonly \SqlSemantics\Statement\Model\MySql\Role\SpCChisticsForm $spCChistics,
27        public readonly \SqlSemantics\Statement\Model\MySql\Role\StoredRoutineBodyForm $storedRoutineBody,
28        public readonly \SqlSemantics\Statement\Comments $comments = new \SqlSemantics\Statement\Comments(),
29    ) {
30        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optIfNotExists), 'The optIfNotExists must be a generated immutable SQL value.');
31        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($spName), 'The spName must be a generated immutable SQL value.');
32        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($spPdparamList), 'The spPdparamList must be a generated immutable SQL value.');
33        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($spCChistics), 'The spCChistics must be a generated immutable SQL value.');
34        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($storedRoutineBody), 'The storedRoutineBody must be a generated immutable SQL value.');
35    }
36
37    /**
38     * Writes SQL entirely from this value's fields.
39     */
40    public function write(\SqlSemantics\Statement\Writer $writer): void
41    {
42        $writer->comments($this->comments, 0);
43        $writer->append('PROCEDURE');
44        $writer->comments($this->comments, 1);
45        $this->optIfNotExists->write($writer);
46        $writer->comments($this->comments, 2);
47        $this->spName->write($writer);
48        $writer->comments($this->comments, 3);
49        $writer->append('(');
50        $writer->comments($this->comments, 4);
51        $this->spPdparamList->write($writer);
52        $writer->comments($this->comments, 5);
53        $writer->append(')');
54        $writer->comments($this->comments, 6);
55        $this->spCChistics->write($writer);
56        $writer->comments($this->comments, 7);
57        $this->storedRoutineBody->write($writer);
58    }
59
60    /**
61     * Returns a copy with a new optIfNotExists, preserving every other field.
62     */
63    public function withOptIfNotExists(\SqlSemantics\Statement\Model\MySql\Role\OptIfNotExistsForm $optIfNotExists): self
64    {
65        return new self($optIfNotExists, $this->spName, $this->spPdparamList, $this->spCChistics, $this->storedRoutineBody, $this->comments);
66    }
67
68    /**
69     * Returns a copy with a new spName, preserving every other field.
70     */
71    public function withSpName(\SqlSemantics\Statement\Model\MySql\Role\SpNameForm $spName): self
72    {
73        return new self($this->optIfNotExists, $spName, $this->spPdparamList, $this->spCChistics, $this->storedRoutineBody, $this->comments);
74    }
75
76    /**
77     * Returns a copy with a new spPdparamList, preserving every other field.
78     */
79    public function withSpPdparamList(\SqlSemantics\Statement\Model\MySql\Role\SpPdparamListForm $spPdparamList): self
80    {
81        return new self($this->optIfNotExists, $this->spName, $spPdparamList, $this->spCChistics, $this->storedRoutineBody, $this->comments);
82    }
83
84    /**
85     * Returns a copy with a new spCChistics, preserving every other field.
86     */
87    public function withSpCChistics(\SqlSemantics\Statement\Model\MySql\Role\SpCChisticsForm $spCChistics): self
88    {
89        return new self($this->optIfNotExists, $this->spName, $this->spPdparamList, $spCChistics, $this->storedRoutineBody, $this->comments);
90    }
91
92    /**
93     * Returns a copy with a new storedRoutineBody, preserving every other field.
94     */
95    public function withStoredRoutineBody(\SqlSemantics\Statement\Model\MySql\Role\StoredRoutineBodyForm $storedRoutineBody): self
96    {
97        return new self($this->optIfNotExists, $this->spName, $this->spPdparamList, $this->spCChistics, $storedRoutineBody, $this->comments);
98    }
99
100    /**
101     * Returns a copy with a new comments, preserving every other field.
102     */
103    public function withComments(\SqlSemantics\Statement\Comments $comments): self
104    {
105        return new self($this->optIfNotExists, $this->spName, $this->spPdparamList, $this->spCChistics, $this->storedRoutineBody, $comments);
106    }
107}
108