enumDialect

packages/sql-semantics-postgres/src/Dialect.php:15

enum Dialect: string
    implements Dialect

Public API: explicitly declared with @visibility public.

Selects the PostgreSql implementation installed with this package.

Reconstruct SQL using this database packagedoctest

$semantics = new \SqlSemantics\Facade\Semantics(\SqlSemantics\Platform\PostgreSql\Dialect::PostgreSql);
    $semantics->analyze('DROP TABLE example')->toString() // => 'DROP TABLE example'

Cases§

case PostgreSql = 'postgresql'

source §

Methods§

public function platform(): Platform

source §

Supplies this database's parser, models, and semantic policies.

Returns

Platform

Test cases 1

PlatformTest::testAnalyzeRoundTripsCompleteStatements calls

Calls 1

new Platform line 24

Test cases 181§

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

Dedicated tests 1

DialectTest::testPlatformBelongsToThisDatabase calls

Other tests reaching this symbol 180

SemanticsBench::setUp calls
StatementBench::benchRoundTrip calls
SchemaAnalyzerTest::testReadPreservesCompatibilitySyntaxErrors calls
ValueReaderTest::testFromFileLoadsTheDatabasePackageVocabulary calls
ColumnPropertiesTest::testAutoIncrementDoesNotInspectDefaultExpressionIdentifiers calls
ColumnPropertiesTest::testCollationKeepsQuotedNames calls
ColumnPropertiesTest::testGenerationDoesNotConfuseDefaultCastsWithGeneratedColumns calls
ColumnPropertiesTest::testGenerationDoesNotTreatNamedDefaultsAsComputedColumns calls
ColumnPropertiesTest::testGenerationPreservesVirtualAndIdentityKinds calls
ColumnReaderTest::testReadPreservesDeclaredNullabilityIndependentlyOfUsage calls
ConstraintReaderTest::testReadNamedForeignKey calls
ConstraintReaderTest::testReferencesPreservesCompositeForeignKeyOrder calls
DialectParserTest::testParseUsesTheRequestedGrammarAndRetainsSql calls
DialectParserTest::testRejectsAnUnavailableGrammarRelease calls
DialectParserTest::testVersionReturnsTheResolvedRelease calls
IdentifiersTest::providerIdentifiers calls
IdentifiersTest::testEqualDistinguishesQuotedPostgresCase calls
IdentifiersTest::testNamePreservesQuotedPostgresCaseAndFoldsUnquotedNames calls
IdentifiersTest::testPartsDoesNotSplitDotsInsideQuotedIdentifiers calls
SchemaChangesTest::testDropAppliesInDeclarationOrder calls
SchemaChangesTest::testDropDoesNotRemoveAQualifiedNamesake calls
SchemaChangesTest::testDropHandlesMultipleTargetsAndConditionalCreation calls
SchemaChangesTest::testDropRejectsMissingUnconditionalTargets calls
SchemaChangesTest::testDropRejectsUnresolvedCatalogQualification calls
SchemaReaderTest::testPrimaryKeysRejectsMissingColumn calls
SchemaReaderTest::testReadDeclaredKeysDefaultsAndChecks calls
SchemaReaderTest::testTableRejectsDuplicateDeclarations calls
StatementListTest::testReadPreservesStatementBoundaries calls
StatementListTest::testRejectsAnotherParsersRoot calls
TokenGroupsTest::testConstraintHeaderSeparatesQuotedNames calls
TokenGroupsTest::testNamesPreservesQuotedCommas calls
TypeReaderTest::providerCanonicalTypes calls
TypeReaderTest::testCanonicalRejectsUnsupportedDomainNames calls
TypeReaderTest::testReadPreservesDecimalPrecisionAndScale calls
BinderTest::testBindPreservesSourceTextAndExpressionNodeIdentity calls
BinderTest::testBindPropagatesSyntaxErrors calls
BinderTest::testBindRejectsMissingDeclarations calls
BinderTest::testBindResetsStatementIdentitiesWhenReusingTheBinder calls
BinderTest::testBindSelfJoinPreservesOccurrenceIdentityAndNullProvenance calls
BinderTest::testBindUsesTheSchemasDefaultNamespace calls
BoundRelationTest::testKeepsScopeAndRelationAtTheSameStage calls
ExpressionBinderTest::testBindsParenthesesAndUnaryOperators calls
ExpressionBinderTest::testCallRetainsNestedCoalesceInputs calls
ExpressionBinderTest::testOperationPreservesOperatorPrecedence calls
ExpressionBinderTest::testTokenRejectsUnmodeledTerminals calls
ExpressionRulesTest::testArithmeticHandlesNegativePostgresIntegerBoundaries calls
ExpressionRulesTest::testCallNullIfCanIntroduceNullWithoutAnOuterJoin calls
ExpressionRulesTest::testCoerceRecordsPostgresCommonTypeConversions calls
ExpressionRulesTest::testOperatorNullTestsAreNeverNullable calls
ExpressionRulesTest::testPredicateRejectsNonBooleanPostgresInputs calls
FromBinderTest::testBindCrossJoinHasNoMatchPredicate calls
FromBinderTest::testJoinedBindsOnBeforeIntroducingThisJoinsNulls calls
FromBinderTest::testJoinPropagatesNestedOuterJoinProvenance calls
FromBinderTest::testKindRecognizesRightAndRejectsNatural calls
FromBinderTest::testRelationFullJoinExtendsBothSides calls
FromBinderTest::testTableRejectsAliasColumnLists calls
LiteralBinderTest::testBindParametersRemainExplicitlyUnknownWithoutBindings calls
LiteralBinderTest::testIntegerClassifiesPostgresWidthsWithoutPhpOverflow calls
LiteralBinderTest::testIntegerResolvesDecimalBoundaries calls
LiteralBinderTest::testTypeNameRetainsLiteralCategoriesAndRejectsIdentifiers calls
NullFactsTest::testCoalesceRequiresANonNullOperandToGuaranteeAValue calls
NullFactsTest::testExtensionsRetainsAllNullableOperandCauses calls
NullFactsTest::testStrictAndCoalesceFacts calls
NullFactsTest::testStrictComparisonPropagatesNullButBooleanOrDoesNot calls
ProjectionBinderTest::testBindExpandsUnqualifiedStarInFromOrder calls
ProjectionBinderTest::testItemExpandsStarsAndPreservesDuplicateNames calls
ProjectionBinderTest::testItemResolvesBarePostgresUnknownLiteralsAsText calls
ProjectionBinderTest::testStarRejectsAnUnknownQualifier calls
ScopeTest::testColumnRejectsAmbiguousUnqualifiedNames calls
ScopeTest::testCombineRejectsDuplicateAliases calls
ScopeTest::testExtendDoesNotMutateTheInputScope calls
ScopeTest::testMatchesAliasHidesOriginalTableName calls
ScopeTest::testRejectsReferencesOutsideJoinOperands calls
SelectBinderTest::testBindConstantQueriesWithoutARelation calls
SelectModifiersBinderTest::testOrderingResolvesAliasesAndDirection calls
SelectModifiersBinderTest::testPaginationRejectsFetchWithTiesRatherThanDroppingItsMeaning calls
SelectModifiersBinderTest::testRejectsOutOfRangeOrderPosition calls
SelectModifiersBinderTest::testSortExpressionResolvesPositionsAndNullPlacement calls
SyntaxGuardTest::testSelectRejectsUnmodeledConstructs calls
TableResolverTest::testRejectsMissingTablesInsteadOfInventingColumns calls
TableResolverTest::testResolvesQualifiedDeclarations calls
TypeResolutionTest::testBooleanUsesDialectSpecificResultTypes calls
TypeResolutionTest::testCommonPromotesIntegerOperands calls
TypeResolutionTest::testRejectsUnmodeledCoercion calls
BoundSelectTest::testRetainsRowDependenciesAbsentFromValueLineage calls
ColumnBindingTest::testRetainsDeclarationIdentity calls
ExpressionKindTest::testDistinguishesNullHandlingOperations calls
ExpressionTest::testLineageDeduplicatesByOccurrenceAndColumn calls
JoinTest::testRetainsTheMatchTree calls
OrderingTest::testKeepsSortDirectionSeparateFromTheExpression calls
OutputColumnTest::testDoesNotInventEngineSpecificExpressionLabels calls
TableUseTest::testSeparatesAliasesSharingOneDeclaration calls
PlatformTest::testDefaultSchemaUsesTheLanguageNamespace calls
PlatformTest::testNamesDecodeQuotedIdentifiers calls
PlatformTest::testQueryKeepsProjectionOrder calls
PlatformTest::testSchemaKeepsDeclarations calls
PlatformTest::testStatementNamesIdentifyTheParserRoot calls
PlatformTest::testSyntaxRecognizesSelectBody calls
PlatformTest::testTypesRetainDialectIdentity calls
PlatformTest::testValuesReconstructsUsingTheParserRelease calls
NameRulesTest::testEqualUsesColumnCaseRules calls
NameRulesTest::testKeyUsesTheSameColumnIdentity calls
NameRulesTest::testRelationEqualUsesTableCaseRules calls
QueryRulesTest::testProjectionItemsPreserveOutputOrder calls
QueryRulesTest::testProjectionTokensExpandQualifiedStar calls
QueryRulesTest::testRelationResolvesAnAlias calls
SchemaRulesTest::testPrimaryNotNullPromotesAnIntegerKey calls
SchemaRulesTest::testQualifyPreservesExplicitNamespaces calls
SchemaRulesTest::testSchemaNodeRetainsOriginalDeclaration calls
SchemaRulesTest::testTableKeyDistinguishesNames calls
SchemaRulesTest::testValidateAcceptsOrdinaryDeclarations calls
TypeRulesTest::testAffinityUsesDeclaredTypePrecedence calls
TypeRulesTest::testArithmeticRetainsLanguageSemantics calls
TypeRulesTest::testBooleanNamesPredicateResult calls
TypeRulesTest::testCoalescePreservesOperands calls
TypeRulesTest::testCommonPreservesHomogeneousType calls
TypeRulesTest::testIntegerModelsLargeMagnitude calls
TypeRulesTest::testPredicateAcceptsBooleanResults calls
TypeRulesTest::testProjectPreservesTypedValues calls
TypeRulesTest::testReadPreservesModifiers calls
TypeRulesTest::testTypeNameClassifiesIntegerToken calls
ColumnDefinitionTest::testKeepsDefaultsAsOriginalSyntax calls
ColumnDefinitionTest::testWithNullabilityPreservesAllTypedAttributes calls
ColumnGenerationTest::testIdentityKeepsItsOptionsWithoutAComputation calls
InvariantTest::testElementsPreservesImmutableSemanticGraphs calls
InvariantTest::testMembersPreservesDeclarationOrder calls
InvariantTest::testNamesPreservesCompositeKeyOrder calls
InvariantTest::testTablePreservesAValidCompositeForeignKey calls
TableConstraintTest::testRetainsCompositeKeyOrder calls
TableDefinitionTest::testQualifiesUnqualifiedNamesWithTheResolutionContext calls
SchemaBuilderTest::testBuildAcceptsSeparateSqlStringsInDeclarationOrder calls
SchemaBuilderTest::testBuildDoesNotAccumulatePreviousDeclarations calls
SchemaBuilderTest::testBuildKeepsExplicitlyQualifiedDeclarations calls
SchemaBuilderTest::testBuildPropagatesInvalidDdlSyntax calls
SchemaBuilderTest::testBuildRejectsConflictingDeclarationsAcrossSqlStrings calls
SchemaBuilderTest::testBuildRetainsTheResolvedLanguageAndNamespace calls
SchemaBuilderTest::testRejectsAnUnavailableGrammarRelease calls
SchemaTest::testRetainsTheDialectAndAllDeclarations calls
SchemaTest::testWithTablesLeavesThePreviousStateIntact calls
SchemaTest::testAnalyzeIsIndependentAcrossCalls calls
SchemaTest::testAnalyzePreservesAnExplicitZeroColumnTable calls
SchemaTest::testAnalyzePreservesStateProperties calls
SchemaTest::testAnalyzeRejectsDuplicateStateIdentities calls
NameRulesTest calls
PlatformTest::testAnalyzeRoundTripsCompleteStatements calls
PlatformTest::testDefaultSchemaUsesTheLanguageNamespace calls
PlatformTest::testNamesDecodeQuotedIdentifiers calls
PlatformTest::testParserPreservesTheSelectedVersion calls
PlatformTest::testQueryKeepsProjectionOrder calls
PlatformTest::testSchemaKeepsDeclarations calls
PlatformTest::testStatementNamesIdentifyTheParserRoot calls
PlatformTest::testSyntaxRecognizesSelectBody calls
PlatformTest::testTypesRetainDialectIdentity calls
PlatformTest::testValuesReconstructsUsingTheParserRelease calls
QueryRulesTest::testJoinedTracksNullableInput calls
QueryRulesTest::testOrderingNodesPreserveDirection calls
QueryRulesTest::testProjectionItemsPreserveOutputOrder calls
QueryRulesTest::testProjectionTokensExpandQualifiedStar calls
QueryRulesTest::testRelationResolvesAnAlias calls
SchemaRulesTest::testColumnNodesPreserveOrder calls
SchemaRulesTest::testOptionsRetainsStructuredTableChoices calls
SchemaRulesTest::testPrimaryNotNullPromotesAnIntegerKey calls
SchemaRulesTest::testPrimaryOptionsNotNullAccountsForTablePolicy calls
SchemaRulesTest::testQualifyPreservesExplicitNamespaces calls
SchemaRulesTest::testSchemaNodeRetainsOriginalDeclaration calls
SchemaRulesTest::testTableKeyDistinguishesNames calls
SchemaRulesTest::testValidateAcceptsOrdinaryDeclarations calls
StatementTest::testToStringSeparatesAPrefixOperatorFromANegatedOperand calls
StatementTest::testWithCommandKeepsTheCommentsAroundTheCommand calls
TypeRulesTest::testAffinityUsesDeclaredTypePrecedence calls
TypeRulesTest::testArithmeticRetainsLanguageSemantics calls
TypeRulesTest::testBooleanNamesPredicateResult calls
TypeRulesTest::testCanonicalResolvesInteger calls
TypeRulesTest::testCoalescePreservesOperands calls
TypeRulesTest::testCommonPreservesHomogeneousType calls
TypeRulesTest::testIntegerModelsLargeMagnitude calls
TypeRulesTest::testPredicateAcceptsBooleanResults calls
TypeRulesTest::testProjectPreservesTypedValues calls
TypeRulesTest::testReadPreservesModifiers calls
TypeRulesTest::testTypeNameClassifiesIntegerToken calls