classPgSqlPartitionParser

public function parseKey(string $sql): ?TablePartitionKey

Reads a CREATE TABLE partition strategy and its key expressions.

Test cases 5

• PgSqlPartitionParserTest::testIgnoresNestedPartitionKeywordsWhenFindingTopLevelClauses calls
• PgSqlPartitionParserTest::testParentTableRejectsMalformedPartitionClauses calls
• PgSqlPartitionParserTest::testParseKeyParsesRangePartitionKeyAndBounds calls
• PgSqlPartitionParserTest::testParsesAllKeyStrategies calls
• PgSqlPartitionParserTest::testSkipsIncompleteKeywordPairBeforeThePartitionClause calls

Called from 3

• method-call ZtdQuery\Platform\Postgres\Schema\Definition\TableFields::definition() packages/ztd-query-postgres/src/Schema/Definition/TableFields.php:146
• method-call ZtdQuery\Platform\Postgres\Schema\Reflection\Catalog\PartitionKeys::reflect() packages/ztd-query-postgres/src/Schema/Reflection/Catalog/PartitionKeys.php:47
• method-call ZtdQuery\Platform\Postgres\Shadow\Mutation\Table\TableMutationResolver::resolvePartition() packages/ztd-query-postgres/src/Shadow/Mutation/Table/TableMutationResolver.php:153

Calls 11

• static-call SqlTokenStream::tokenize() line 24
• static-call PgSqlLexerProfile::create() line 24
• method-call ClauseTokens::keywordPairIndex() line 26
• new ClauseTokens line 26
• class-const TablePartitionStrategy::Range() line 36
• class-const TablePartitionStrategy::List() line 37
• class-const TablePartitionStrategy::Hash() line 38
• method-call ClauseTokens::closingParenthesisIndex() line 46
• function-call substr line 52
• function-call in_array line 54
• new TablePartitionKey line 58

public function parentTable(string $sql): ?string

Returns the parent relation named in a PARTITION OF clause.

Test cases 2

• PgSqlPartitionParserTest::testNormalizesUnquotedParentNamesAndPreservesQuotedNames calls
• PgSqlPartitionParserTest::testParentTableRejectsMalformedPartitionClauses calls

Called from 1

• method-call ZtdQuery\Platform\Postgres\Shadow\Mutation\Table\TableMutationResolver::resolveCreateTable() packages/ztd-query-postgres/src/Shadow/Mutation/Table/TableMutationResolver.php:62

Calls 5

• static-call SqlTokenStream::tokenize() line 66
• static-call PgSqlLexerProfile::create() line 66
• method-call ClauseTokens::keywordPairIndex() line 68
• new ClauseTokens line 68
• method-call ClauseTokens::qualifiedIdentifierAt() line 73

public function parseRelation(
    string $sql,
    TablePartitionKey $parentKey,
): ?TablePartitionRelation

Resolves a child partition and its predicate using the parent partition key.

Test cases 10

• PgSqlPartitionParserTest::testIgnoresNestedPartitionKeywordsWhenFindingTopLevelClauses calls
• PgSqlPartitionParserTest::testListPredicatesDistinguishValuesNullAndWhitespace calls
• PgSqlPartitionParserTest::testParentTableRejectsMalformedPartitionClauses calls
• PgSqlPartitionParserTest::testParseKeyParsesRangePartitionKeyAndBounds calls
• PgSqlPartitionParserTest::testParseRelationParsesListPartitionIncludingNull calls
• PgSqlPartitionParserTest::testParsesDefaultPartition calls
• PgSqlPartitionParserTest::testParsesFiniteMultiColumnRangeAsRowComparison calls
• PgSqlPartitionParserTest::testParsesUnboundedRange calls
• PgSqlPartitionParserTest::testRejectsHashAndMixedUnboundedRangeInsteadOfGuessing calls
• PgSqlPartitionParserTest::testRejectsMalformedBoundsIndependently calls

Called from 1

• method-call ZtdQuery\Platform\Postgres\Shadow\Mutation\Table\TableMutationResolver::resolvePartition() packages/ztd-query-postgres/src/Shadow/Mutation/Table/TableMutationResolver.php:147

Calls 13

• static-call SqlTokenStream::tokenize() line 81
• static-call PgSqlLexerProfile::create() line 81
• method-call ClauseTokens::keywordPairIndex() line 83
• new ClauseTokens line 83
• method-call ClauseTokens::qualifiedIdentifierAt() line 87
• method-call ClauseTokens::keywordIndex() line 92
• new TablePartitionRelation line 95
• class-const TablePartitionStrategy::Range() line 102
• method-call BoundPredicate::rangePredicate() line 102
• new BoundPredicate line 102
• class-const TablePartitionStrategy::List() line 103
• method-call BoundPredicate::listPredicate() line 103
• class-const TablePartitionStrategy::Hash() line 104