W3cubDocs

/CakePHP 3.8

Interface SqlGeneratorInterface

An interface used by TableSchema objects.

Direct Implementers

Method Summary

  • Generate the SQL statements to add the constraints to the table
  • createSql() public
    Generate the SQL to create the Table.
  • Generate the SQL statements to drop the constraints to the table
  • dropSql() public
    Generate the SQL to drop a table.
  • truncateSql() public
    Generate the SQL statements to truncate a table

Method Detail

addConstraintSql()source public

addConstraintSql( Cake\Database\Connection $connection )

Generate the SQL statements to add the constraints to the table

Parameters

Cake\Database\Connection $connection
The connection to generate SQL for.

Returns

array
SQL to add the constraints.

createSql()source public

createSql( Cake\Database\Connection $connection )

Generate the SQL to create the Table.

Uses the connection to access the schema dialect to generate platform specific SQL.

Parameters

Cake\Database\Connection $connection
The connection to generate SQL for.

Returns

array

List of SQL statements to create the table and the required indexes.


dropConstraintSql()source public

dropConstraintSql( Cake\Database\Connection $connection )

Generate the SQL statements to drop the constraints to the table

Parameters

Cake\Database\Connection $connection
The connection to generate SQL for.

Returns

array
SQL to drop a table.

dropSql()source public

dropSql( Cake\Database\Connection $connection )

Generate the SQL to drop a table.

Uses the connection to access the schema dialect to generate platform specific SQL.

Parameters

Cake\Database\Connection $connection
The connection to generate SQL for.

Returns

array
SQL to drop a table.

truncateSql()source public

truncateSql( Cake\Database\Connection $connection )

Generate the SQL statements to truncate a table

Parameters

Cake\Database\Connection $connection
The connection to generate SQL for.

Returns

array
SQL to truncate a table.

© 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/3.8/class-Cake.Database.Schema.SqlGeneratorInterface.html