MysqlQueries
in package
implements
DataBaseQueries
Class that gathers all the needed SQL sentences by the database engine
Tags
Interfaces, Classes, Traits and Enums
- DataBaseQueries
- Interface to manage the SQL statements needed by the database
Table of Contents
- sql2Int() : string
- Returns the needed SQL to convert a column to integer
- sqlAddConstraint() : string
- Returns the SQL needed to add a constraint to a table
- sqlAlterAddColumn() : string
- Returns the SQL needed to add a column to a table
- sqlAlterColumnDefault() : string
- Returns the needed SQL to alter a column default constraint
- sqlAlterColumnNull() : string
- SQL statement to alter a null constraint in a table column
- sqlAlterModifyColumn() : string
- Returns the SQL needed to alter a column in a table
- sqlColumns() : string
- Returns the SQL needed to get the list of columns in a table
- sqlConstraints() : string
- Returns the SQL needed to get the list of constraints in a table
- sqlConstraintsExtended() : string
- Returns the SQL needed to get the list of advanced constraints in a table
- sqlCreateTable() : string
- Returns the SQL needed to create a table with the given structure
- sqlDropConstraint() : string
- Returns the SQL needed to remove a constraint from a table
- sqlDropTable() : string
- SQL statement to drop a given table
- sqlIndexes() : string
- Returns the SQL needed to get the list of indexes in a table
- sqlLastValue() : string
- Returns the SQL to get last ID assigned when performing an INSERT in the database
- sqlTableConstraints() : string
- Generates the needed SQL to establish the given constraints
- fixPostgresql() : string
- Removes PostgreSQL's problematic code
- getConstraints() : string
- Returns a string with the columns constraints
- getTypeAndConstraints() : string
- Generates the SQL with the field type and the DEFAULT and null constraints
Methods
sql2Int()
Returns the needed SQL to convert a column to integer
public
sql2Int(string $colName) : string
Parameters
- $colName : string
Return values
string —sqlAddConstraint()
Returns the SQL needed to add a constraint to a table
public
sqlAddConstraint(string $tableName, string $constraintName, string $sql) : string
Parameters
- $tableName : string
- $constraintName : string
- $sql : string
Return values
string —sqlAlterAddColumn()
Returns the SQL needed to add a column to a table
public
sqlAlterAddColumn(string $tableName, array<string|int, mixed> $colData) : string
Parameters
- $tableName : string
- $colData : array<string|int, mixed>
Return values
string —sqlAlterColumnDefault()
Returns the needed SQL to alter a column default constraint
public
sqlAlterColumnDefault(string $tableName, array<string|int, mixed> $colData) : string
Parameters
- $tableName : string
- $colData : array<string|int, mixed>
Return values
string —sqlAlterColumnNull()
SQL statement to alter a null constraint in a table column
public
sqlAlterColumnNull(string $tableName, array<string|int, mixed> $colData) : string
Parameters
- $tableName : string
- $colData : array<string|int, mixed>
Return values
string —sqlAlterModifyColumn()
Returns the SQL needed to alter a column in a table
public
sqlAlterModifyColumn(string $tableName, array<string|int, mixed> $colData) : string
Parameters
- $tableName : string
- $colData : array<string|int, mixed>
Return values
string —sqlColumns()
Returns the SQL needed to get the list of columns in a table
public
sqlColumns(string $tableName) : string
Parameters
- $tableName : string
Return values
string —sqlConstraints()
Returns the SQL needed to get the list of constraints in a table
public
sqlConstraints(string $tableName) : string
Parameters
- $tableName : string
Return values
string —sqlConstraintsExtended()
Returns the SQL needed to get the list of advanced constraints in a table
public
sqlConstraintsExtended(string $tableName) : string
Parameters
- $tableName : string
Return values
string —sqlCreateTable()
Returns the SQL needed to create a table with the given structure
public
sqlCreateTable(string $tableName, array<string|int, mixed> $columns, array<string|int, mixed> $constraints) : string
Parameters
- $tableName : string
- $columns : array<string|int, mixed>
- $constraints : array<string|int, mixed>
Return values
string —sqlDropConstraint()
Returns the SQL needed to remove a constraint from a table
public
sqlDropConstraint(string $tableName, array<string|int, mixed> $colData) : string
Parameters
- $tableName : string
- $colData : array<string|int, mixed>
Return values
string —sqlDropTable()
SQL statement to drop a given table
public
sqlDropTable(string $tableName) : string
Parameters
- $tableName : string
Return values
string —sqlIndexes()
Returns the SQL needed to get the list of indexes in a table
public
sqlIndexes(string $tableName) : string
Parameters
- $tableName : string
Return values
string —sqlLastValue()
Returns the SQL to get last ID assigned when performing an INSERT in the database
public
sqlLastValue() : string
Return values
string —sqlTableConstraints()
Generates the needed SQL to establish the given constraints
public
sqlTableConstraints(array<string|int, mixed> $xmlCons) : string
Parameters
- $xmlCons : array<string|int, mixed>
Return values
string —fixPostgresql()
Removes PostgreSQL's problematic code
private
fixPostgresql(string $sql) : string
Parameters
- $sql : string
Return values
string —getConstraints()
Returns a string with the columns constraints
private
getConstraints(array<string|int, mixed> $colData) : string
Parameters
- $colData : array<string|int, mixed>
Return values
string —getTypeAndConstraints()
Generates the SQL with the field type and the DEFAULT and null constraints
private
getTypeAndConstraints(array<string|int, mixed> $colData) : string
Parameters
- $colData : array<string|int, mixed>