Interface SchemaInterface
An interface used by TableSchema objects.
Direct Implementers
Indirect Implementers
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 or not 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 $attrs )
Add a column to the table.
Attributes
Columns can have several attributes:
typeThe type of the column. This should be one of CakePHP's abstract types.lengthThe length of the column.precisionThe number of decimal places to store for float and decimal types.defaultThe default value of the column.nullWhether or not the column can hold nulls.fixedWhether or not the column is a fixed length column. This is only present/valid with string columns.unsignedWhether or not 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:
commentThe comment for the column.
Parameters
- string $name
- The name of the column
- array|string $attrs
- The attributes for the column.
Returns
$this
baseColumnType() public ¶
baseColumnType( string $column )
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
The base type name
defaultValues() public ¶
defaultValues( )
Get a hash of columns and their default values.
Returns
getColumn() public ¶
getColumn( string $name )
Get column data in the table.
Parameters
- string $name
- The column name.
Returns
Column data or null.
getColumnType() public ¶
getColumnType( string $name )
Returns column type or null if a column does not exist.
Parameters
- string $name
- The column to get the type of.
Returns
getOptions() public ¶
getOptions( )
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
An array of options.
hasColumn() public ¶
hasColumn( string $name )
Returns true if a column exists in the schema.
Parameters
- string $name
- Column name.
Returns
isNullable() public ¶
isNullable( string $name )
Check whether or not a field is nullable
Missing columns are nullable.
Parameters
- string $name
- The column to get the type of.
Returns
Whether or not the field is nullable.
removeColumn() public ¶
removeColumn( string $name )
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 )
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 $options )
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 $options
- The options to set, or null to read options.
Returns
$this