classQueryExpressionWithWithClauseQueryExpressionBodyOptOrderClauseOptLimitClause_f3d9f9a0

packages/sql-semantics-mysql/resources/models/Value/QueryExpressionWithWithClauseQueryExpressionBodyOptOrderClauseOptLimitClause_f3d9f9a0.php:15

final class QueryExpressionWithWithClauseQueryExpressionBodyOptOrderClauseOptLimitClause_f3d9f9a0
    implements AsCreateQueryExpressionForm, EvSqlStmtForm, EvSqlStmtInnerForm, ExplainableStmtForm, InsertFromSubqueryForm, InsertQueryExpressionForm, OptCreatePartitioningEtcForm, OptCreateTableOptionsEtcForm, OptDuplicateAsQeForm, QueryExpressionForm, QueryExpressionWithOptLockingClausesForm, SelectStmtForm, SimpleStatementForm, SimpleStatementOrBeginForm, SpProcStmtForm, SpProcStmtStatementForm, StoredRoutineBodyForm, Command
    uses Assertion

Public API: explicitly declared with @visibility public.

The query_expression SQL value; generated by bin/build-models.php.

Accept a structured SQL valuedoctest

$write = static fn (\SqlSemantics\Statement\Model\MySql\Value\QueryExpressionWithWithClauseQueryExpressionBodyOptOrderClauseOptLimitClause_f3d9f9a0 $value): string => \SqlSemantics\Statement\Writer::render($value);
    $write instanceof \Closure // => true

Properties§

public WithClauseForm $with

source §

public QueryExpressionBodyForm $queryExpressionBody

source §

public OptOrderClauseForm $orderBy

source §

public OptLimitClauseForm $optLimitClause

source §

public Comments $comments = new \SqlSemantics\Statement\Comments()

source §

Methods§

public function __construct(
    public WithClauseForm $with,
    public QueryExpressionBodyForm $queryExpressionBody,
    public OptOrderClauseForm $orderBy,
    public OptLimitClauseForm $optLimitClause,
    public Comments $comments = new \SqlSemantics\Statement\Comments(),
)

source §

Supplies the SQL values of this form; comments are kept by the position of the symbol each precedes.

Parameters

`$with`	`WithClauseForm`
`$queryExpressionBody`	`QueryExpressionBodyForm`
`$orderBy`	`OptOrderClauseForm`
`$optLimitClause`	`OptLimitClauseForm`
`$comments`	`Comments`

Calls 3

new Comments line 27
method-call QueryExpressionWithWithClauseQueryExpressionBodyOptOrderClauseOptLimitClause_f3d9f9a0::assert() line 29
static-call Contracts::contains() line 29

public function write(Writer $writer): void

source §

Writes SQL entirely from this value's fields.

Parameters

$writer Writer

Calls 5

method-call Writer::comments() line 40
method-call WithClauseForm::write() line 41
method-call QueryExpressionBodyForm::write() line 43
method-call OptOrderClauseForm::write() line 45
method-call OptLimitClauseForm::write() line 47

public function withWith(WithClauseForm $with): self

source §

Returns a copy with a new with, preserving every other field.

Parameters

$with WithClauseForm

Returns

self

Calls 1

new self line 55

public function withQueryExpressionBody(QueryExpressionBodyForm $queryExpressionBody): self

source §

Returns a copy with a new queryExpressionBody, preserving every other field.

Parameters

$queryExpressionBody QueryExpressionBodyForm

Returns

self

Calls 1

new self line 63

public function withOrderBy(OptOrderClauseForm $orderBy): self

source §

Returns a copy with a new orderBy, preserving every other field.

Parameters

$orderBy OptOrderClauseForm

Returns

self

Calls 1

new self line 71

public function withOptLimitClause(OptLimitClauseForm $optLimitClause): self

source §

Returns a copy with a new optLimitClause, preserving every other field.

Parameters

$optLimitClause OptLimitClauseForm

Returns

self

Calls 1

new self line 79

public function withComments(Comments $comments): self

source §

Returns a copy with a new comments, preserving every other field.

Parameters

$comments Comments

Returns

self

Calls 1

new self line 87