renameTable() public method Builds a SQL statement for renaming a DB table. public string renameTable ( $oldName, $newName )$oldName string The table to be renamed. The name will be properly quoted by the method. $newName string The new table name. The name will be properly quoted by the method. return string The SQL statement for renaming a DB table.

renameColumn() public method Builds a SQL statement for renaming a column. public string renameColumn ( $table, $oldName, $newName )$table string The table whose column is to be renamed. The name will be properly quoted by the method. $oldName string The old name of the column. The name will be properly quoted by the method. $newName string The new name of the column. The name will be properly quoted by the method. return string The SQL statement for renaming a DB column.

insert() public method Creates an INSERT SQL statement. For example, $sql = $queryBuilder->insert('user', [ 'name' => 'Sam', 'age' => 30, ], $params); The method will properly escape the table and column names. public string insert ( $table, $columns, &$params )$table string The table that new rows will be inserted into. $columns array The column data (name => value) to be inserted into the table. $params array The binding parameters that will be generated by

hasOffset() protected method Checks to see if the given offset is effective. protected boolean hasOffset ( $offset )$offset mixed The given offset return boolean Whether the offset is effective

hasLimit() protected method Checks to see if the given limit is effective. protected boolean hasLimit ( $limit )$limit mixed The given limit return boolean Whether the limit is effective

getColumnType() public method Converts an abstract column type into a physical column type. The conversion is done using the type map specified in $typeMap. The following abstract column types are supported (using MySQL as an example to explain the corresponding physical types): pk: an auto-incremental primary key type, will be converted into "int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY" bigpk: an auto-incremental primary key type, will be converted into "bigint(20) NOT NULL AUTO_INCREMEN

dropTable() public method Builds a SQL statement for dropping a DB table. public string dropTable ( $table )$table string The table to be dropped. The name will be properly quoted by the method. return string The SQL statement for dropping a DB table.

dropPrimaryKey() public method Builds a SQL statement for removing a primary key constraint to an existing table. public string dropPrimaryKey ( $name, $table )$name string The name of the primary key constraint to be removed. $table string The table that the primary key constraint will be removed from. return string The SQL statement for removing a primary key constraint from an existing table.

dropIndex() public method Builds a SQL statement for dropping an index. public string dropIndex ( $name, $table )$name string The name of the index to be dropped. The name will be properly quoted by the method. $table string The table whose index is to be dropped. The name will be properly quoted by the method. return string The SQL statement for dropping an index.

dropForeignKey() public method Builds a SQL statement for dropping a foreign key constraint. public string dropForeignKey ( $name, $table )$name string The name of the foreign key constraint to be dropped. The name will be properly quoted by the method. $table string The table whose foreign is to be dropped. The name will be properly quoted by the method. return string The SQL statement for dropping a foreign key constraint.