classCatalogQuery

packages/sql-fixture/src/Platform/PostgreSql/Schema/CatalogQuery.php:15

final class CatalogQuery

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

Reads PostgreSQL column and primary-key metadata for schema reflection.

Methods§

public function columns(
    PDO $pdo,
    string $schema,
    string $table,
): list<array{column_name: string, data_type: string, character_maximum_length: ?string, numeric_precision: ?string, numeric_scale: ?string, is_nullable: string, column_default: ?string, udt_name: string}>

source §

Reads columns in their declared ordinal order.

Parameters

`$pdo`	`PDO`
`$schema`	`string`
`$table`	`string`

Returns

list<array{column_name: string, data_type: string, character_maximum_length: ?string, numeric_precision: ?string, numeric_scale: ?string, is_nullable: string, column_default: ?string, udt_name: string}>

Test cases 1

CatalogQueryTest::testColumnsRetainsDatabaseOrdinalOrder calls

Called from 2

Calls 2

method-call PDO::prepare() line 24
class-const PDO::FETCH_ASSOC() line 37

public function primaryKeys(PDO $pdo, string $schema, string $table): list<string>

source §

Reads primary-key names, returning none when the catalog rejects lookup.

Parameters

`$pdo`	`PDO`
`$schema`	`string`
`$table`	`string`

Returns

list<string>

Test cases 1

CatalogQueryTest::testPrimaryKeysReadsAQualifiedTemporarySchema calls

Called from 1

method-call SqlFixture\Platform\PostgreSql\Schema\CatalogDdl::reconstructCreateTable() packages/sql-fixture/src/Platform/PostgreSql/Schema/CatalogDdl.php:35

Calls 3

method-call PDO::prepare() line 48
class-const PDO::FETCH_ASSOC() line 61
function-call array_map line 66

Test cases 12§

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

Dedicated tests 2

Other tests reaching this symbol 10

Relations§

Instantiated in 3

Method calls 3