packages/sql-semantics-sqlite/resources/models/Value/UpsertWithOnConflictLpSortlistRpWhereOptDoNothingUpsert_820f0d71.php

1<?php
2
3declare(strict_types=1);
4
5namespace SqlSemantics\Statement\Model\Sqlite\Value;
6
7/**
8 * The upsert 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\Sqlite\Value\UpsertWithOnConflictLpSortlistRpWhereOptDoNothingUpsert_820f0d71 $value): string => \SqlSemantics\Statement\Writer::render($value);
13 *     $write instanceof \Closure // => true
14 */
15final class UpsertWithOnConflictLpSortlistRpWhereOptDoNothingUpsert_820f0d71 implements \SqlSemantics\Statement\Model\Sqlite\Role\UpsertForm
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\Sqlite\Role\SortlistForm $sortlist,
24        public readonly \SqlSemantics\Statement\Model\Sqlite\Role\WhereOptForm $where,
25        public readonly \SqlSemantics\Statement\Model\Sqlite\Role\UpsertForm $upsert,
26        public readonly \SqlSemantics\Statement\Comments $comments = new \SqlSemantics\Statement\Comments(),
27    ) {
28        $this->assert(\SqlSemantics\Statement\Model\Sqlite\Contract\Contracts::contains($sortlist), 'The sortlist must be a generated immutable SQL value.');
29        $this->assert(\SqlSemantics\Statement\Model\Sqlite\Contract\Contracts::contains($where), 'The where must be a generated immutable SQL value.');
30        $this->assert(\SqlSemantics\Statement\Model\Sqlite\Contract\Contracts::contains($upsert), 'The upsert must be a generated immutable SQL value.');
31    }
32
33    /**
34     * Writes SQL entirely from this value's fields.
35     */
36    public function write(\SqlSemantics\Statement\Writer $writer): void
37    {
38        $writer->comments($this->comments, 0);
39        $writer->append('ON');
40        $writer->comments($this->comments, 1);
41        $writer->append('CONFLICT');
42        $writer->comments($this->comments, 2);
43        $writer->append('(');
44        $writer->comments($this->comments, 3);
45        $this->sortlist->write($writer);
46        $writer->comments($this->comments, 4);
47        $writer->append(')');
48        $writer->comments($this->comments, 5);
49        $this->where->write($writer);
50        $writer->comments($this->comments, 6);
51        $writer->append('DO');
52        $writer->comments($this->comments, 7);
53        $writer->append('NOTHING');
54        $writer->comments($this->comments, 8);
55        $this->upsert->write($writer);
56    }
57
58    /**
59     * Returns a copy with a new sortlist, preserving every other field.
60     */
61    public function withSortlist(\SqlSemantics\Statement\Model\Sqlite\Role\SortlistForm $sortlist): self
62    {
63        return new self($sortlist, $this->where, $this->upsert, $this->comments);
64    }
65
66    /**
67     * Returns a copy with a new where, preserving every other field.
68     */
69    public function withWhere(\SqlSemantics\Statement\Model\Sqlite\Role\WhereOptForm $where): self
70    {
71        return new self($this->sortlist, $where, $this->upsert, $this->comments);
72    }
73
74    /**
75     * Returns a copy with a new upsert, preserving every other field.
76     */
77    public function withUpsert(\SqlSemantics\Statement\Model\Sqlite\Role\UpsertForm $upsert): self
78    {
79        return new self($this->sortlist, $this->where, $upsert, $this->comments);
80    }
81
82    /**
83     * Returns a copy with a new comments, preserving every other field.
84     */
85    public function withComments(\SqlSemantics\Statement\Comments $comments): self
86    {
87        return new self($this->sortlist, $this->where, $this->upsert, $comments);
88    }
89}
90