W3cubDocs

/CakePHP 4.4

Class Collection

Represents a database schema collection

Used to access information about the tables, and other data in a database.

Namespace: Cake\Database\Schema

Property Summary

  • $_connection protected
    Cake\Database\Connection

    Connection object

  • $_dialect protected
    Cake\Database\Schema\SchemaDialect

    Schema dialect instance.

Method Summary

  • __construct() public

    Constructor.

  • _reflect() protected

    Helper method for running each step of the reflection process.

  • describe() public

    Get the column metadata for a table.

  • listTables() public

    Get the list of tables and views available in the current connection.

  • listTablesWithoutViews() public

    Get the list of tables, excluding any views, available in the current connection.

Method Detail

__construct() public 

__construct(Cake\Database\Connection $connection)

Constructor.

Parameters

Cake\Database\Connection $connection

The connection instance.

_reflect() protected 

_reflect(string $stage, string $name, array<string, mixed> $config, Cake\Database\Schema\TableSchema $schema): void

Helper method for running each step of the reflection process.

Parameters

string $stage

The stage name.

string $name

The table name.

array<string, mixed> $config

The config data.

Cake\Database\Schema\TableSchema $schema

The table schema instance.

Returns

void

Throws

Cake\Database\Exception\DatabaseException
on query failure.

describe() public 

describe(string $name, array<string, mixed> $options = []): Cake\Database\Schema\TableSchema

Get the column metadata for a table.

The name can include a database schema name in the form 'schema.table'.

Caching will be applied if cacheMetadata key is present in the Connection configuration options. Defaults to _cakemodel when true.

Options

  • forceRefresh - Set to true to force rebuilding the cached metadata. Defaults to false.

Parameters

string $name

The name of the table to describe.

array<string, mixed> $options optional

The options to use, see above.

Returns

Cake\Database\Schema\TableSchema

Throws

Cake\Database\Exception\DatabaseException
when table cannot be described.

listTables() public 

listTables(): array<string>

Get the list of tables and views available in the current connection.

Returns

array<string>

listTablesWithoutViews() public 

listTablesWithoutViews(): array<string>

Get the list of tables, excluding any views, available in the current connection.

Returns

array<string>

Property Detail

$_connection protected

Connection object

Type

Cake\Database\Connection

$_dialect protected

Schema dialect instance.

Type

Cake\Database\Schema\SchemaDialect

© 2005–present The Cake Software Foundation, Inc.
Licensed under the MIT License.
CakePHP is a registered trademark of Cake Software Foundation, Inc.
We are not endorsed by or affiliated with CakePHP.
https://api.cakephp.org/4.4/class-Cake.Database.Schema.Collection.html