SQLGenerator

SQLGenerator

dropForeign(string|array $name, bool $as_raw = false)

Drop constraints column;

SQLGenerator

addIndex(string $name)

Add table index;

SQLGenerator

dropIndex(string $name)

Drop table index;

SQLGenerator

dropPrimary()

Drop primary column;

SQLGenerator

addUnique(string $name)

Add table unique;

SQLGenerator

dropUnique(string $name)

Drop table unique;

array

getCustomTypeQueries()

Get the custom type for pgsql

from PgsqlCompose

__construct(string $table, string $adapter, string $scope)

SQLGenerator constructor

string

make()

Generate the sql

SQLGenerator

addRaw(string $definition)

Add a raw column definition

SQLGenerator

addColumn(string $name, string $type, array $attribute = [])

Add new column in the table

SQLGenerator

changeColumn(string $name, string $type, array $attribute = [])

Change a column in the table

SQLGenerator

renameColumn(string $name, string $new)

Rename a column in the table

SQLGenerator

dropColumn(string $name)

Drop table column

void

withEngine(string $engine)

Set the engine

string

getEngine()

Get the engine

void

withCollation(string $collation)

Set the collation

string

getCollation()

Get the collation

void

withCharset(string $charset)

Set the charset

string

getCharset()

Get the charset

string

getTable()

Get the define table name

string

setTable(string $table)

Set the define table name

SQLGenerator

setScope(string $scope)

Set the scope

SQLGenerator

setAdapter(string $adapter)

Set the adapter

string

normalizeOfType(string $type)

Normalize the data type

Details

in NumberColumn at line 20
`SQLGenerator addFloat(string $column, array $attribute = [])`

Add float column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 33
`SQLGenerator addDouble(string $column, array $attribute = [])`

Add double column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 45
`SQLGenerator addDoublePrimary(string $column)`

Add double primary column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 57
`SQLGenerator addFloatPrimary(string $column)`

Add float primary column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 69
`SQLGenerator addIncrement(string $column)`

Add increment primary column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 82
`SQLGenerator addInteger(string $column, array $attribute = [])`

Add integer column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 94
`SQLGenerator addIntegerPrimary(string $column)`

Add integer primary column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 106
`SQLGenerator addBigIncrement(string $column)`

Add big increment primary column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 119
`SQLGenerator addTinyInteger(string $column, array $attribute = [])`

Add tiny integer column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 132
`SQLGenerator addBigInteger(string $column, array $attribute = [])`

Add Big integer column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 145
`SQLGenerator addMediumInteger(string $column, array $attribute = [])`

Add Medium integer column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 157
`SQLGenerator addMediumIncrement(string $column)`

Add Medium integer column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 170
`SQLGenerator addSmallInteger(string $column, array $attribute = [])`

Add small integer column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 182
`SQLGenerator addSmallIntegerIncrement(string $column)`

Add Smallint integer column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 195
`SQLGenerator changeFloat(string $column, array $attribute = [])`

Change float column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 208
`SQLGenerator changeDouble(string $column, array $attribute = [])`

Change double column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 220
`SQLGenerator changeDoublePrimary(string $column)`

Change double primary column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 232
`SQLGenerator changeFloatPrimary(string $column)`

Change float primary column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 244
`SQLGenerator changeIncrement(string $column)`

Change increment primary column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 257
`SQLGenerator changeInteger(string $column, array $attribute = [])`

Change integer column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 269
`SQLGenerator changeIntegerPrimary(string $column)`

Change integer primary column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 281
`SQLGenerator changeBigIncrement(string $column)`

Change big increment primary column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 294
`SQLGenerator changeTinyInteger(string $column, array $attribute = [])`

Change tiny integer column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 307
`SQLGenerator changeBigInteger(string $column, array $attribute = [])`

Change Big integer column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 320
`SQLGenerator changeMediumInteger(string $column, array $attribute = [])`

Change Medium integer column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 332
`SQLGenerator changeMediumIncrement(string $column)`

Change Medium integer column

Parameters

string

$column

Return Value

Exceptions

in NumberColumn at line 345
`SQLGenerator changeSmallInteger(string $column, array $attribute = [])`

Change Small integer column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in NumberColumn at line 357
`SQLGenerator changeSmallIntegerPrimary(string $column)`

Change Small integer column

Parameters

string

$column

Return Value

Exceptions

in MixedColumn at line 20
`SQLGenerator addBoolean(string $column, array $attribute = [])`

Add BOOLEAN column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 33
`SQLGenerator addUuid(string $column, array $attribute = [])`

Add UUID column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 65
`SQLGenerator addUuidPrimary(string $column, array $attribute = [])`

Add UUID column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 88
`SQLGenerator addBinary(string $column, array $attribute = [])`

Add BINARY column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 101
`SQLGenerator addTinyBlob(string $column, array $attribute = [])`

Add TINYBLOB column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 114
`SQLGenerator addLongBlob(string $column, array $attribute = [])`

Add LONGBLOB column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 127
`SQLGenerator addMediumBlob(string $column, array $attribute = [])`

Add MEDIUMBLOB column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 140
`SQLGenerator addIpAddress(string $column, array $attribute = [])`

Add ip column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 153
`SQLGenerator addMacAddress(string $column, array $attribute = [])`

Add mac column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 166
`SQLGenerator addEnum(string $column, array $attribute = [])`

Add enum column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 191
`SQLGenerator addCheck(string $column, array $attribute = [])`

Add check column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 206
`SQLGenerator changeBoolean(string $column, array $attribute = [])`

Change boolean column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 219
`SQLGenerator changeUuid(string $column, array $attribute = [])`

Change UUID column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 245
`SQLGenerator changeBinary(string $column, array $attribute = [])`

Change BLOB column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 258
`SQLGenerator changeLongBlob(string $column, array $attribute = [])`

Change TINYBLOB column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 271
`SQLGenerator changeMediumBlob(string $column, array $attribute = [])`

Change MEDIUMBLOB column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 284
`SQLGenerator changeTinyBlob(string $column, array $attribute = [])`

Change TINYBLOB column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 297
`SQLGenerator changeIpAddress(string $column, array $attribute = [])`

Change ip column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 310
`SQLGenerator changeMacAddress(string $column, array $attribute = [])`

Change mac column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 323
`SQLGenerator changeEnum(string $column, array $attribute = [])`

Change enum column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in MixedColumn at line 348
`SQLGenerator changeCheck(string $column, array $attribute = [])`

Change check column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in TextColumn at line 20
`SQLGenerator addString(string $column, array $attribute = [])`

Add string column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in TextColumn at line 33
`SQLGenerator addJson(string $column, array $attribute = [])`

Add json column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in TextColumn at line 46
`SQLGenerator addChar(string $column, array $attribute = [])`

Add character column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in TextColumn at line 59
`SQLGenerator addLongtext(string $column, array $attribute = [])`

Add longtext column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in TextColumn at line 72
`SQLGenerator addText(string $column, array $attribute = [])`

Add text column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in TextColumn at line 85
`SQLGenerator addBlob(string $column, array $attribute = [])`

Add blob column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in TextColumn at line 98
`SQLGenerator changeString(string $column, array $attribute = [])`

Change string column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in TextColumn at line 111
`SQLGenerator changeJson(string $column, array $attribute = [])`

Change json column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in TextColumn at line 124
`SQLGenerator changeChar(string $column, array $attribute = [])`

Change character column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in TextColumn at line 137
`SQLGenerator changeLongtext(string $column, array $attribute = [])`

Change longtext column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in TextColumn at line 150
`SQLGenerator changeText(string $column, array $attribute = [])`

Change text column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in TextColumn at line 163
`SQLGenerator changeBlob(string $column, array $attribute = [])`

Change blob column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in DateColumn at line 20
`SQLGenerator addDatetime(string $column, array $attribute = [])`

Add datetime column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in DateColumn at line 37
`SQLGenerator addDate(string $column, array $attribute = [])`

Add date column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in DateColumn at line 50
`SQLGenerator addTime(string $column, array $attribute = [])`

Add time column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in DateColumn at line 63
`SQLGenerator addYear(string $column, array $attribute = [])`

Add year column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in DateColumn at line 76
`SQLGenerator addTimestamp(string $column, array $attribute = [])`

Add timestamp column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in DateColumn at line 87
`SQLGenerator addTimestamps()`

Add default timestamps

Return Value

Exceptions

in DateColumn at line 110
`SQLGenerator changeDatetime(string $column, array $attribute = [])`

Change datetime column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in DateColumn at line 127
`SQLGenerator changeDate(string $column, array $attribute = [])`

Change date column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in DateColumn at line 140
`SQLGenerator changeTime(string $column, array $attribute = [])`

Change time column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in DateColumn at line 153
`SQLGenerator changeYear(string $column, array $attribute = [])`

Change year column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in DateColumn at line 166
`SQLGenerator changeTimestamp(string $column, array $attribute = [])`

Change timestamp column

Parameters

string	$column
array	$attribute

Return Value

Exceptions

in DateColumn at line 177
`SQLGenerator changeTimestamps()`

Change default timestamps

Return Value

Exceptions

in ConstraintColumn at line 18
`SQLGenerator addForeign(string $name, array $attributes = [])`

Add Foreign KEY constraints

Parameters

string	$name
array	$attributes

Return Value

in ConstraintColumn at line 82
`SQLGenerator dropForeign(string|array $name, bool $as_raw = false)`

Drop constraints column;

Parameters

string\|array	$name
bool	$as_raw

Return Value

in ConstraintColumn at line 106
`SQLGenerator addIndex(string $name)`

Add table index;

Parameters

string

$name

Return Value

in ConstraintColumn at line 129
`SQLGenerator dropIndex(string $name)`

Drop table index;

Parameters

string

$name

Return Value

in ConstraintColumn at line 149
`SQLGenerator dropPrimary()`

Drop primary column;

Return Value

in ConstraintColumn at line 162
`SQLGenerator addUnique(string $name)`

Add table unique;

Parameters

string

$name

Return Value

in ConstraintColumn at line 185
`SQLGenerator dropUnique(string $name)`

Drop table unique;

Parameters

string

$name

Return Value

in PgsqlCompose at line 21
`array getCustomTypeQueries()`

Get the custom type for pgsql

Return Value

array

at line 78
`__construct(string $table, string $adapter, string $scope)`

SQLGenerator constructor

Parameters

string	$table
string	$adapter
string	$scope

at line 93
`string make()`

Generate the sql

Return Value

string

at line 107
`SQLGenerator addRaw(string $definition)`

Add a raw column definition

Parameters

string

$definition

Return Value

at line 123
`SQLGenerator addColumn(string $name, string $type, array $attribute = [])`

Add new column in the table

Parameters

string	$name
string	$type
array	$attribute

Return Value

Exceptions

at line 148
`SQLGenerator changeColumn(string $name, string $type, array $attribute = [])`

Change a column in the table

Parameters

string	$name
string	$type
array	$attribute

Return Value

Exceptions

at line 167
`SQLGenerator renameColumn(string $name, string $new)`

Rename a column in the table

Parameters

string	$name
string	$new

Return Value

at line 190
`SQLGenerator dropColumn(string $name)`

Drop table column

Parameters

string

$name

Return Value

at line 209
`void withEngine(string $engine)`

Set the engine

Parameters

string

$engine

Return Value

void

at line 219
`string getEngine()`

Get the engine

Return Value

string

at line 230
`void withCollation(string $collation)`

Set the collation

Parameters

string

$collation

Return Value

void

at line 240
`string getCollation()`

Get the collation

Return Value

string

at line 251
`void withCharset(string $charset)`

Set the charset

Parameters

string

$charset

Return Value

void

at line 261
`string getCharset()`

Get the charset

Return Value

string

at line 271
`string getTable()`

Get the define table name

Return Value

string

at line 282
`string setTable(string $table)`

Set the define table name

Parameters

string

$table

Return Value

string

at line 318
`SQLGenerator setScope(string $scope)`

Set the scope

Parameters

string

$scope

Return Value

at line 331
`SQLGenerator setAdapter(string $adapter)`

Set the adapter

Parameters

string

$adapter

Return Value