CakePHP
  • Documentation
    • Book
    • API
    • Videos
    • Reporting Security Issues
    • Privacy Policy
    • Logos & Trademarks
  • Business Solutions
  • Swag
  • Road Trip
  • Team
  • Community
    • Community
    • Get Involved
    • Issues (Github)
    • Bakery
    • Featured Resources
    • Training
    • Meetups
    • My CakePHP
    • CakeFest
    • Newsletter
    • Linkedin
    • YouTube
    • Facebook
    • Twitter
    • Mastodon
    • Help & Support
    • Forum
    • Stack Overflow
    • IRC
    • Slack
    • Paid Support
CakePHP

C CakePHP 4.4 Strawberry API

  • Project:
    • CakePHP
      • CakePHP
      • Authentication
      • Authorization
      • Chronos
      • Elastic Search
      • Queue
  • Version:
    • 4.4
      • 5.2
      • 5.1
      • 5.0
      • 4.6
      • 4.5
      • 4.4
      • 4.3
      • 4.2
      • 4.1
      • 4.0
      • 3.10
      • 3.9
      • 3.8
      • 3.7
      • 3.6
      • 3.5
      • 3.4
      • 3.3
      • 3.2
      • 3.1
      • 3.0
      • 2.10
      • 2.9
      • 2.8
      • 2.7
      • 2.6
      • 2.5
      • 2.4
      • 2.3
      • 2.2
      • 2.1
      • 2.0
      • 1.3
      • 1.2

Namespaces

  • Global
  • Cake
    • Auth
    • Cache
    • Collection
    • Command
    • Console
    • Controller
    • Core
    • Database
    • Datasource
      • Exception
      • Locator
      • Paging
    • Error
    • Event
    • Filesystem
    • Form
    • Http
    • I18n
    • Log
    • Mailer
    • Network
    • ORM
    • Routing
    • Shell
    • TestSuite
    • Utility
    • Validation
    • View

Interface SchemaInterface

An interface used by TableSchema objects.

Namespace: Cake\Datasource

Method Summary

  • addColumn() public

    Add a column to the table.

  • baseColumnType() public

    Returns the base type name for the provided column. This represent the database type a more complex class is based upon.

  • columns() public

    Get the column names in the table.

  • defaultValues() public

    Get a hash of columns and their default values.

  • getColumn() public

    Get column data in the table.

  • getColumnType() public

    Returns column type or null if a column does not exist.

  • getOptions() public

    Gets the options for a table.

  • hasColumn() public

    Returns true if a column exists in the schema.

  • isNullable() public

    Check whether a field is nullable

  • name() public

    Get the name of the table.

  • removeColumn() public

    Remove a column from the table schema.

  • setColumnType() public

    Sets the type of a column.

  • setOptions() public

    Sets the options for a table.

  • typeMap() public

    Returns an array where the keys are the column names in the schema and the values the database type they have.

Method Detail

addColumn() ¶ public

addColumn(string $name, array<string, mixed>|string $attrs): $this

Add a column to the table.

Attributes

Columns can have several attributes:

  • type The type of the column. This should be one of CakePHP's abstract types.
  • length The length of the column.
  • precision The number of decimal places to store for float and decimal types.
  • default The default value of the column.
  • null Whether the column can hold nulls.
  • fixed Whether the column is a fixed length column. This is only present/valid with string columns.
  • unsigned Whether the column is an unsigned column. This is only present/valid for integer, decimal, float columns.

In addition to the above keys, the following keys are implemented in some database dialects, but not all:

  • comment The comment for the column.
Parameters
string $name

The name of the column

array<string, mixed>|string $attrs

The attributes for the column or the type name.

Returns
$this

baseColumnType() ¶ public

baseColumnType(string $column): string|null

Returns the base type name for the provided column. This represent the database type a more complex class is based upon.

Parameters
string $column

The column name to get the base type from

Returns
string|null

columns() ¶ public

columns(): array<string>

Get the column names in the table.

Returns
array<string>

defaultValues() ¶ public

defaultValues(): array<string, mixed>

Get a hash of columns and their default values.

Returns
array<string, mixed>

getColumn() ¶ public

getColumn(string $name): array<string, mixed>|null

Get column data in the table.

Parameters
string $name

The column name.

Returns
array<string, mixed>|null

getColumnType() ¶ public

getColumnType(string $name): string|null

Returns column type or null if a column does not exist.

Parameters
string $name

The column to get the type of.

Returns
string|null

getOptions() ¶ public

getOptions(): array<string, mixed>

Gets the options for a table.

Table options allow you to set platform specific table level options. For example the engine type in MySQL.

Returns
array<string, mixed>

hasColumn() ¶ public

hasColumn(string $name): bool

Returns true if a column exists in the schema.

Parameters
string $name

Column name.

Returns
bool

isNullable() ¶ public

isNullable(string $name): bool

Check whether a field is nullable

Missing columns are nullable.

Parameters
string $name

The column to get the type of.

Returns
bool

name() ¶ public

name(): string

Get the name of the table.

Returns
string

removeColumn() ¶ public

removeColumn(string $name): $this

Remove a column from the table schema.

If the column is not defined in the table, no error will be raised.

Parameters
string $name

The name of the column

Returns
$this

setColumnType() ¶ public

setColumnType(string $name, string $type): $this

Sets the type of a column.

Parameters
string $name

The column to set the type of.

string $type

The type to set the column to.

Returns
$this

setOptions() ¶ public

setOptions(array<string, mixed> $options): $this

Sets the options for a table.

Table options allow you to set platform specific table level options. For example the engine type in MySQL.

Parameters
array<string, mixed> $options

The options to set, or null to read options.

Returns
$this

typeMap() ¶ public

typeMap(): array<string, string>

Returns an array where the keys are the column names in the schema and the values the database type they have.

Returns
array<string, string>
OpenHub
Pingping
Linode
  • Business Solutions
  • Showcase
  • Documentation
  • Book
  • API
  • Videos
  • Reporting Security Issues
  • Privacy Policy
  • Logos & Trademarks
  • Community
  • Get Involved
  • Issues (Github)
  • Bakery
  • Featured Resources
  • Training
  • Meetups
  • My CakePHP
  • CakeFest
  • Newsletter
  • Linkedin
  • YouTube
  • Facebook
  • Twitter
  • Mastodon
  • Help & Support
  • Forum
  • Stack Overflow
  • IRC
  • Slack
  • Paid Support

Generated using CakePHP API Docs