classSampleClause

packages/ztd-query-postgres/src/Sql/Sampling/SampleClause.php:17

final class SampleClause

Restricted visibility: declared "@visibility root". Code outside that scope must not name this declaration.

Sample clause operations for PostgreSQL sampling.

Methods§

public function parseSample(
    string $sql,
    list<SqlToken> $tokens,
    array{name: string, start: int, unqualifiedStart: int, end: int} $reference,
    int $sampleIndex,
    SqlToken $referenceToken,
): PgSqlTableSample

source §

Parameters

`$sql`	`string`
`$tokens`	`list<SqlToken>`
`$reference`	`array{name: string, start: int, unqualifiedStart: int, end: int}`
`$sampleIndex`	`int`
`$referenceToken`	`SqlToken`

Returns

PgSqlTableSample

Throws

UnsupportedSqlException

Test cases 1

SampleClauseTest::testParseSample calls

Called from 1

method-call ZtdQuery\Platform\Postgres\Sql\Sampling\PgSqlTableSampleParser::parse() packages/ztd-query-postgres/src/Sql/Sampling/PgSqlTableSampleParser.php:34

Calls 14

static-call PgSqlTableSampleMethod::tryFrom() line 33
function-call strtoupper line 33
new UnsupportedSqlException line 36
method-call SampleTokens::isOpeningParenthesis() line 41
new SampleTokens line 41
method-call SampleTokens::closingParenthesisIndex() line 44
function-call trim line 49
function-call substr line 49
function-call count line 50
static-call SqlTokenStream::tokenize() line 50
static-call PgSqlLexerProfile::create() line 50
method-call SampleClause::repeatable() line 54
method-call SampleClause::aliasSql() line 57
new PgSqlTableSample line 59

public function repeatable(
    string $sql,
    list<SqlToken> $tokens,
    SqlToken $referenceToken,
    int $closeIndex,
): array{seed: string|null, end: int}

source §

Reads the optional REPEATABLE seed following the percentage expression.

Parameters

`$sql`	`string`
`$tokens`	`list<SqlToken>`
`$referenceToken`	`SqlToken`
`$closeIndex`	`int`

Returns

array{seed: string|null, end: int}

Throws

UnsupportedSqlException

Test cases 1

SampleClauseTest::testRepeatablePreservesTheSeedAndClosingOffset calls

Called from 1

method-call ZtdQuery\Platform\Postgres\Sql\Sampling\SampleClause::parseSample() packages/ztd-query-postgres/src/Sql/Sampling/SampleClause.php:54

Calls 10

method-call SampleTokens::sameLevel() line 82
new SampleTokens line 82
method-call SampleTokens::isOpeningParenthesis() line 86
new UnsupportedSqlException line 87
method-call SampleTokens::closingParenthesisIndex() line 89
function-call trim line 94
function-call substr line 94
function-call count line 95
static-call SqlTokenStream::tokenize() line 95
static-call PgSqlLexerProfile::create() line 95

public function aliasSql(
    string $sql,
    list<SqlToken> $tokens,
    array{name: string, start: int, unqualifiedStart: int, end: int} $reference,
    SqlToken $referenceToken,
    SqlToken $sampleToken,
): string

source §

Preserves the alias between a relation or inheritance marker and TABLESAMPLE.

Parameters

`$sql`	`string`
`$tokens`	`list<SqlToken>`
`$reference`	`array{name: string, start: int, unqualifiedStart: int, end: int}`
`$referenceToken`	`SqlToken`
`$sampleToken`	`SqlToken`

Returns

string

Test cases 1

SampleClauseTest::testAliasSqlPreservesTheRelationAlias calls

Called from 1

method-call ZtdQuery\Platform\Postgres\Sql\Sampling\SampleClause::parseSample() packages/ztd-query-postgres/src/Sql/Sampling/SampleClause.php:57

Calls 4

method-call SampleTokens::tokenAfter() line 112
new SampleTokens line 112
function-call trim line 116
function-call substr line 116

Test cases 14§

Test cases that cover or call this symbol, from the coverage report and from the analyzed test sources.

Dedicated tests 3

Other tests reaching this symbol 11

Relations§

Instantiated in 1

new ZtdQuery\Platform\Postgres\Sql\Sampling\PgSqlTableSampleParser::parse() packages/ztd-query-postgres/src/Sql/Sampling/PgSqlTableSampleParser.php:34

Method calls 1

method-call ZtdQuery\Platform\Postgres\Sql\Sampling\PgSqlTableSampleParser::parse() packages/ztd-query-postgres/src/Sql/Sampling/PgSqlTableSampleParser.php:34