packages/sql-semantics-sqlite/resources/models/Value/UpsertWithOnConflictLpSortlistRpWhereOptDoUpdateSetSetlistWhereOptUpsert_b3d7f7ee.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\UpsertWithOnConflictLpSortlistRpWhereOptDoUpdateSetSetlistWhereOptUpsert_b3d7f7ee $value): string => \SqlSemantics\Statement\Writer::render($value);
13 * $write instanceof \Closure // => true
14 */
15final class UpsertWithOnConflictLpSortlistRpWhereOptDoUpdateSetSetlistWhereOptUpsert_b3d7f7ee 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\SetlistForm $setlist,
26 public readonly \SqlSemantics\Statement\Model\Sqlite\Role\WhereOptForm $where2,
27 public readonly \SqlSemantics\Statement\Model\Sqlite\Role\UpsertForm $upsert,
28 public readonly \SqlSemantics\Statement\Comments $comments = new \SqlSemantics\Statement\Comments(),
29 ) {
30 $this->assert(\SqlSemantics\Statement\Model\Sqlite\Contract\Contracts::contains($sortlist), 'The sortlist must be a generated immutable SQL value.');
31 $this->assert(\SqlSemantics\Statement\Model\Sqlite\Contract\Contracts::contains($where), 'The where must be a generated immutable SQL value.');
32 $this->assert(\SqlSemantics\Statement\Model\Sqlite\Contract\Contracts::contains($setlist), 'The setlist must be a generated immutable SQL value.');
33 $this->assert(\SqlSemantics\Statement\Model\Sqlite\Contract\Contracts::contains($where2), 'The where2 must be a generated immutable SQL value.');
34 $this->assert(\SqlSemantics\Statement\Model\Sqlite\Contract\Contracts::contains($upsert), 'The upsert 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('ON');
44 $writer->comments($this->comments, 1);
45 $writer->append('CONFLICT');
46 $writer->comments($this->comments, 2);
47 $writer->append('(');
48 $writer->comments($this->comments, 3);
49 $this->sortlist->write($writer);
50 $writer->comments($this->comments, 4);
51 $writer->append(')');
52 $writer->comments($this->comments, 5);
53 $this->where->write($writer);
54 $writer->comments($this->comments, 6);
55 $writer->append('DO');
56 $writer->comments($this->comments, 7);
57 $writer->append('UPDATE');
58 $writer->comments($this->comments, 8);
59 $writer->append('SET');
60 $writer->comments($this->comments, 9);
61 $this->setlist->write($writer);
62 $writer->comments($this->comments, 10);
63 $this->where2->write($writer);
64 $writer->comments($this->comments, 11);
65 $this->upsert->write($writer);
66 }
67
68 /**
69 * Returns a copy with a new sortlist, preserving every other field.
70 */
71 public function withSortlist(\SqlSemantics\Statement\Model\Sqlite\Role\SortlistForm $sortlist): self
72 {
73 return new self($sortlist, $this->where, $this->setlist, $this->where2, $this->upsert, $this->comments);
74 }
75
76 /**
77 * Returns a copy with a new where, preserving every other field.
78 */
79 public function withWhere(\SqlSemantics\Statement\Model\Sqlite\Role\WhereOptForm $where): self
80 {
81 return new self($this->sortlist, $where, $this->setlist, $this->where2, $this->upsert, $this->comments);
82 }
83
84 /**
85 * Returns a copy with a new setlist, preserving every other field.
86 */
87 public function withSetlist(\SqlSemantics\Statement\Model\Sqlite\Role\SetlistForm $setlist): self
88 {
89 return new self($this->sortlist, $this->where, $setlist, $this->where2, $this->upsert, $this->comments);
90 }
91
92 /**
93 * Returns a copy with a new where2, preserving every other field.
94 */
95 public function withWhere2(\SqlSemantics\Statement\Model\Sqlite\Role\WhereOptForm $where2): self
96 {
97 return new self($this->sortlist, $this->where, $this->setlist, $where2, $this->upsert, $this->comments);
98 }
99
100 /**
101 * Returns a copy with a new upsert, preserving every other field.
102 */
103 public function withUpsert(\SqlSemantics\Statement\Model\Sqlite\Role\UpsertForm $upsert): self
104 {
105 return new self($this->sortlist, $this->where, $this->setlist, $this->where2, $upsert, $this->comments);
106 }
107
108 /**
109 * Returns a copy with a new comments, preserving every other field.
110 */
111 public function withComments(\SqlSemantics\Statement\Comments $comments): self
112 {
113 return new self($this->sortlist, $this->where, $this->setlist, $this->where2, $this->upsert, $comments);
114 }
115}
116