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

1<?php
2
3declare(strict_types=1);
4
5namespace SqlSemantics\Statement\Model\MySql\Value;
6
7/**
8 * The sp_unlabeled_control 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\SpUnlabeledControlWithLoopSymSpProcStmts1EndLoopSym_06472eeb $value): string => \SqlSemantics\Statement\Writer::render($value);
13 *     $write instanceof \Closure // => true
14 */
15final class SpUnlabeledControlWithLoopSymSpProcStmts1EndLoopSym_06472eeb implements \SqlSemantics\Statement\Model\MySql\Role\EvSqlStmtForm, \SqlSemantics\Statement\Model\MySql\Role\EvSqlStmtInnerForm, \SqlSemantics\Statement\Model\MySql\Role\SpProcStmtForm, \SqlSemantics\Statement\Model\MySql\Role\SpProcStmtUnlabeledForm, \SqlSemantics\Statement\Model\MySql\Role\SpUnlabeledControlForm, \SqlSemantics\Statement\Model\MySql\Role\StoredRoutineBodyForm
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\SpProcStmts1Form $spProcStmts1,
24        public readonly \SqlSemantics\Statement\Comments $comments = new \SqlSemantics\Statement\Comments(),
25    ) {
26        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($spProcStmts1), 'The spProcStmts1 must be a generated immutable SQL value.');
27    }
28
29    /**
30     * Writes SQL entirely from this value's fields.
31     */
32    public function write(\SqlSemantics\Statement\Writer $writer): void
33    {
34        $writer->comments($this->comments, 0);
35        $writer->append('LOOP');
36        $writer->comments($this->comments, 1);
37        $this->spProcStmts1->write($writer);
38        $writer->comments($this->comments, 2);
39        $writer->append('END');
40        $writer->comments($this->comments, 3);
41        $writer->append('LOOP');
42    }
43
44    /**
45     * Returns a copy with a new spProcStmts1, preserving every other field.
46     */
47    public function withSpProcStmts1(\SqlSemantics\Statement\Model\MySql\Role\SpProcStmts1Form $spProcStmts1): self
48    {
49        return new self($spProcStmts1, $this->comments);
50    }
51
52    /**
53     * Returns a copy with a new comments, preserving every other field.
54     */
55    public function withComments(\SqlSemantics\Statement\Comments $comments): self
56    {
57        return new self($this->spProcStmts1, $comments);
58    }
59}
60