classSqliteIdentifierQuoter

packages/ztd-query-sqlite/src/Sql/SqliteIdentifierQuoter.php:16

final class SqliteIdentifierQuoter
    implements IdentifierQuoter

SQLite implementation of IdentifierQuoter.

Uses double-quote quoting ("identifier"). Strips surrounding double quotes to prevent double-quoting, then escapes any remaining embedded double quotes by doubling them.

Methods§

public function quote(string $identifier): string

source §

Quotes a SQLite identifier, escaping embedded delimiters.

Parameters

$identifier string

Returns

string

Test cases 18

SqliteIdentifierQuoterTest::testContainment calls
SqliteIdentifierQuoterTest::testDeterminism calls
SqliteIdentifierQuoterTest::testQuoteAlreadyQuotedIdentifier calls
SqliteIdentifierQuoterTest::testQuoteAlreadyQuotedWithEscapedQuotes calls
SqliteIdentifierQuoterTest::testQuotedIdentifierContainsOriginalName calls
SqliteIdentifierQuoterTest::testQuoteEmptyQuotedIdentifier calls
SqliteIdentifierQuoterTest::testQuoteEscapesEmbeddedQuoteExactly calls
SqliteIdentifierQuoterTest::testQuoteEscapesQuoteCharacterInIdentifier calls
SqliteIdentifierQuoterTest::testQuoteIdentifierWithDoubleQuotes calls
SqliteIdentifierQuoterTest::testQuoteIdentifierWithSpaces calls
SqliteIdentifierQuoterTest::testQuoteIsDeterministic calls
SqliteIdentifierQuoterTest::testQuoteProducesExactResult calls
SqliteIdentifierQuoterTest::testQuoteReturnsNonEmptyString calls
SqliteIdentifierQuoterTest::testQuoteSimpleIdentifier calls
SqliteIdentifierQuoterTest::testQuoteSingleCharIdentifier calls
SqliteIdentifierQuoterTest::testQuoteSingleDoubleQuote calls
SqliteIdentifierQuoterTest::testQuoteStartsAndEndsWithDoubleQuote calls
SqliteIdentifierQuoterTest::testQuoteWrapsIdentifier calls

Called from 6

method-call ZtdQuery\Platform\Sqlite\Rewrite\FullText\MatchExpressionRewriter::expressionEdit() packages/ztd-query-sqlite/src/Rewrite/FullText/MatchExpressionRewriter.php:64
method-call ZtdQuery\Platform\Sqlite\Rewrite\Transformer\InsertSelectRenderer::render() packages/ztd-query-sqlite/src/Rewrite/Transformer/InsertSelectRenderer.php:43
method-call ZtdQuery\Platform\Sqlite\Rewrite\Transformer\InsertSelectRenderer::render() packages/ztd-query-sqlite/src/Rewrite/Transformer/InsertSelectRenderer.php:51
method-call ZtdQuery\Platform\Sqlite\Rewrite\Transformer\InsertSelectRenderer::render() packages/ztd-query-sqlite/src/Rewrite/Transformer/InsertSelectRenderer.php:57
method-call ZtdQuery\Platform\Sqlite\Rewrite\Transformer\InsertSelectRenderer::render() packages/ztd-query-sqlite/src/Rewrite/Transformer/InsertSelectRenderer.php:60
method-call ZtdQuery\Platform\Sqlite\Shadow\Mutation\Table\Alter\AlteredTableProjection::quote() packages/ztd-query-sqlite/src/Shadow/Mutation/Table/Alter/AlteredTableProjection.php:86

Calls 3

function-call strlen line 25
function-call substr line 26
function-call str_replace line 27

Test cases 55§

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

Dedicated tests 18

SqliteIdentifierQuoterTest::testContainment calls
SqliteIdentifierQuoterTest::testDeterminism calls
SqliteIdentifierQuoterTest::testQuoteAlreadyQuotedIdentifier calls
SqliteIdentifierQuoterTest::testQuoteAlreadyQuotedWithEscapedQuotes calls
SqliteIdentifierQuoterTest::testQuotedIdentifierContainsOriginalName calls
SqliteIdentifierQuoterTest::testQuoteEmptyQuotedIdentifier calls
SqliteIdentifierQuoterTest::testQuoteEscapesEmbeddedQuoteExactly calls
SqliteIdentifierQuoterTest::testQuoteEscapesQuoteCharacterInIdentifier calls
SqliteIdentifierQuoterTest::testQuoteIdentifierWithDoubleQuotes calls
SqliteIdentifierQuoterTest::testQuoteIdentifierWithSpaces calls
SqliteIdentifierQuoterTest::testQuoteIsDeterministic calls
SqliteIdentifierQuoterTest::testQuoteProducesExactResult calls
SqliteIdentifierQuoterTest::testQuoteReturnsNonEmptyString calls
SqliteIdentifierQuoterTest::testQuoteSimpleIdentifier calls
SqliteIdentifierQuoterTest::testQuoteSingleCharIdentifier calls
SqliteIdentifierQuoterTest::testQuoteSingleDoubleQuote calls
SqliteIdentifierQuoterTest::testQuoteStartsAndEndsWithDoubleQuote calls
SqliteIdentifierQuoterTest::testQuoteWrapsIdentifier calls

Other tests reaching this symbol 37

RewriteTarget::__invoke calls
SemanticsTarget::__invoke calls
ClassAliasesTest::testFormerParameterTypeAcceptsTheNewTransformerBeforeTheFormerNameIsUsed calls
ClassAliasesTest::testNewParameterTypeAcceptsTheFormerTransformerBeforeTheNewNameIsUsed calls
MatchExpressionRewriterTest::testExpressionEditProjectsAllDocumentColumns calls
MatchExpressionRewriterTest::testExpressionEditRejectsAnUnknownDocument calls
SqliteFullTextSearchRewriterTest calls
SqliteGeneratedColumnProjectorTest calls
SqliteRewriterTest calls
StatementRewriterTest calls
DeleteTransformerTest calls
InsertProjectionBuilderTest calls
InsertSelectRendererTest calls
InsertTransformerTest calls
ShadowCteRendererTest::testGenerateCteRejectsEmptyUnknownSchemas calls
ShadowCteRendererTest::testGenerateCteRendersTypedFixturesExecutableBySqlite calls
ShadowCteRendererTest::testRenderEmptyTableRetainsTypedZeroRowProjection calls
ShadowCteRendererTest::testRenderFallbackNullCastUsesText calls
ShadowCteRendererTest::testRenderRowPreservesColumnOrderAndMissingValues calls
ShadowCteRendererTest::testWrapCteQuotesTheProvidedTableAndProjectsGeneratedColumns calls
SelectTransformerTest::testExplicitCastRendererAndQuoter calls
SqliteTransformerTest calls
UpdateTransformerTest calls
SqliteNativeUpsertProjectorTest calls
UpsertConflictPredicateTest::testConflictPredicateCombinesCompositeAndAlternateKeys calls
UpsertConflictPredicateTest::testQualifiedEscapesAliasAndColumn calls
UpsertExpressionBinderTest::testBindExpressionBindsIncomingExistingAndUnqualifiedColumns calls
UpsertExpressionBinderTest::testIdentifierUnquotesEscapedNames calls
UpsertExpressionBinderTest::testIsIdentifierDistinguishesColumnNames calls
UpsertExpressionBinderTest::testSubqueryTokenIndexesMarksOnlyNestedQueryTokens calls
AddColumnResolverTest calls
AlteredTableProjectionTest calls
DropColumnResolverTest calls
RenameResolverTest calls
TableMutationResolverTest calls
SqliteMutationResolverTest calls
SqliteSessionFactoryTest calls

Relations§

Instantiated in 6

new ZtdQuery\Platform\Sqlite\Rewrite\FullText\SqliteFullTextSearchRewriter::__construct() packages/ztd-query-sqlite/src/Rewrite/FullText/SqliteFullTextSearchRewriter.php:24
new ZtdQuery\Platform\Sqlite\Rewrite\GeneratedColumn\SqliteGeneratedColumnProjector::__construct() packages/ztd-query-sqlite/src/Rewrite/GeneratedColumn/SqliteGeneratedColumnProjector.php:23
new ZtdQuery\Platform\Sqlite\Rewrite\Transformer\InsertSelectRenderer::__construct() packages/ztd-query-sqlite/src/Rewrite/Transformer/InsertSelectRenderer.php:24
new ZtdQuery\Platform\Sqlite\Rewrite\Transformer\SelectTransformer::__construct() packages/ztd-query-sqlite/src/Rewrite/Transformer/SelectTransformer.php:51
new ZtdQuery\Platform\Sqlite\Rewrite\Upsert\SqliteNativeUpsertProjector::__construct() packages/ztd-query-sqlite/src/Rewrite/Upsert/SqliteNativeUpsertProjector.php:31
new ZtdQuery\Platform\Sqlite\Shadow\Mutation\Table\Alter\AlteredTableProjection::quote() packages/ztd-query-sqlite/src/Shadow/Mutation/Table/Alter/AlteredTableProjection.php:86

Method calls 6

method-call ZtdQuery\Platform\Sqlite\Rewrite\FullText\MatchExpressionRewriter::expressionEdit() packages/ztd-query-sqlite/src/Rewrite/FullText/MatchExpressionRewriter.php:64
method-call ZtdQuery\Platform\Sqlite\Rewrite\Transformer\InsertSelectRenderer::render() packages/ztd-query-sqlite/src/Rewrite/Transformer/InsertSelectRenderer.php:43
method-call ZtdQuery\Platform\Sqlite\Rewrite\Transformer\InsertSelectRenderer::render() packages/ztd-query-sqlite/src/Rewrite/Transformer/InsertSelectRenderer.php:51
method-call ZtdQuery\Platform\Sqlite\Rewrite\Transformer\InsertSelectRenderer::render() packages/ztd-query-sqlite/src/Rewrite/Transformer/InsertSelectRenderer.php:57
method-call ZtdQuery\Platform\Sqlite\Rewrite\Transformer\InsertSelectRenderer::render() packages/ztd-query-sqlite/src/Rewrite/Transformer/InsertSelectRenderer.php:60
method-call ZtdQuery\Platform\Sqlite\Shadow\Mutation\Table\Alter\AlteredTableProjection::quote() packages/ztd-query-sqlite/src/Shadow/Mutation/Table/Alter/AlteredTableProjection.php:86

Type declarations 3

type ZtdQuery\Platform\Sqlite\Rewrite\FullText\MatchExpressionRewriter packages/ztd-query-sqlite/src/Rewrite/FullText/MatchExpressionRewriter.php:27
type ZtdQuery\Platform\Sqlite\Rewrite\FullText\SqliteFullTextSearchRewriter packages/ztd-query-sqlite/src/Rewrite/FullText/SqliteFullTextSearchRewriter.php:16
type ZtdQuery\Platform\Sqlite\Rewrite\Transformer\InsertSelectRenderer packages/ztd-query-sqlite/src/Rewrite/Transformer/InsertSelectRenderer.php:16