packages/sql-semantics-postgres/resources/models/Value/DeclareCursorStmtWithDeclareCursorNameCursorOptionsCursorOptHoldForSelectStmt_c4717fe0.php

1<?php
2
3declare(strict_types=1);
4
5namespace SqlSemantics\Statement\Model\PostgreSql\Value;
6
7/**
8 * The DeclareCursorStmt 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\DeclareCursorStmtWithDeclareCursorNameCursorOptionsCursorOptHoldForSelectStmt_c4717fe0 $value): string => \SqlSemantics\Statement\Writer::render($value);
13 *     $write instanceof \Closure // => true
14 */
15final class DeclareCursorStmtWithDeclareCursorNameCursorOptionsCursorOptHoldForSelectStmt_c4717fe0 implements \SqlSemantics\Statement\Model\PostgreSql\Role\DeclareCursorStmtForm, \SqlSemantics\Statement\Model\PostgreSql\Role\ExplainableStmtForm, \SqlSemantics\Statement\Model\PostgreSql\Role\ParseToplevelForm, \SqlSemantics\Statement\Model\PostgreSql\Role\RoutineBodyStmtForm, \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\CursorNameForm $cursorName,
24        public readonly \SqlSemantics\Statement\Model\PostgreSql\Role\CursorOptionsForm $cursorOptions,
25        public readonly \SqlSemantics\Statement\Model\PostgreSql\Role\OptHoldForm $optHold,
26        public readonly \SqlSemantics\Statement\Model\PostgreSql\Role\SelectStmtForm $selectStmt,
27        public readonly \SqlSemantics\Statement\Comments $comments = new \SqlSemantics\Statement\Comments(),
28    ) {
29        $this->assert(\SqlSemantics\Statement\Model\PostgreSql\Contract\Contracts::contains($cursorName), 'The cursorName must be a generated immutable SQL value.');
30        $this->assert(\SqlSemantics\Statement\Model\PostgreSql\Contract\Contracts::contains($cursorOptions), 'The cursorOptions must be a generated immutable SQL value.');
31        $this->assert(\SqlSemantics\Statement\Model\PostgreSql\Contract\Contracts::contains($optHold), 'The optHold must be a generated immutable SQL value.');
32        $this->assert(\SqlSemantics\Statement\Model\PostgreSql\Contract\Contracts::contains($selectStmt), 'The selectStmt must be a generated immutable SQL value.');
33    }
34
35    /**
36     * Writes SQL entirely from this value's fields.
37     */
38    public function write(\SqlSemantics\Statement\Writer $writer): void
39    {
40        $writer->comments($this->comments, 0);
41        $writer->append('DECLARE');
42        $writer->comments($this->comments, 1);
43        $this->cursorName->write($writer);
44        $writer->comments($this->comments, 2);
45        $this->cursorOptions->write($writer);
46        $writer->comments($this->comments, 3);
47        $writer->append('CURSOR');
48        $writer->comments($this->comments, 4);
49        $this->optHold->write($writer);
50        $writer->comments($this->comments, 5);
51        $writer->append('FOR');
52        $writer->comments($this->comments, 6);
53        $this->selectStmt->write($writer);
54    }
55
56    /**
57     * Returns a copy with a new cursorName, preserving every other field.
58     */
59    public function withCursorName(\SqlSemantics\Statement\Model\PostgreSql\Role\CursorNameForm $cursorName): self
60    {
61        return new self($cursorName, $this->cursorOptions, $this->optHold, $this->selectStmt, $this->comments);
62    }
63
64    /**
65     * Returns a copy with a new cursorOptions, preserving every other field.
66     */
67    public function withCursorOptions(\SqlSemantics\Statement\Model\PostgreSql\Role\CursorOptionsForm $cursorOptions): self
68    {
69        return new self($this->cursorName, $cursorOptions, $this->optHold, $this->selectStmt, $this->comments);
70    }
71
72    /**
73     * Returns a copy with a new optHold, preserving every other field.
74     */
75    public function withOptHold(\SqlSemantics\Statement\Model\PostgreSql\Role\OptHoldForm $optHold): self
76    {
77        return new self($this->cursorName, $this->cursorOptions, $optHold, $this->selectStmt, $this->comments);
78    }
79
80    /**
81     * Returns a copy with a new selectStmt, preserving every other field.
82     */
83    public function withSelectStmt(\SqlSemantics\Statement\Model\PostgreSql\Role\SelectStmtForm $selectStmt): self
84    {
85        return new self($this->cursorName, $this->cursorOptions, $this->optHold, $selectStmt, $this->comments);
86    }
87
88    /**
89     * Returns a copy with a new comments, preserving every other field.
90     */
91    public function withComments(\SqlSemantics\Statement\Comments $comments): self
92    {
93        return new self($this->cursorName, $this->cursorOptions, $this->optHold, $this->selectStmt, $comments);
94    }
95}
96