1. class
  2. Bow
  3. \
  4. Database
  5. \
  6. Migration
  7. \
  8. SQLGenerator

SQLGenerator

class SQLGenerator (View source)

Traits

NumberColumn
MixedColumn
TextColumn
DateColumn
ConstraintColumn

Methods

SQLGenerator
addFloat(string $column, array $attribute = [])

Add float column

from  NumberColumn
SQLGenerator
addDouble(string $column, array $attribute = [])

Add double column

from  NumberColumn
SQLGenerator
addDoublePrimary(string $column)

Add double primary column

from  NumberColumn
SQLGenerator
addFloatPrimary(string $column)

Add float primary column

from  NumberColumn
SQLGenerator
addIncrement(string $column)

Add increment primary column

from  NumberColumn
SQLGenerator
addInteger(string $column, array $attribute = [])

Add integer column

from  NumberColumn
SQLGenerator
addIntegerPrimary(string $column)

Add integer primary column

from  NumberColumn
SQLGenerator
addBigIncrement(string $column)

Add big increment primary column

from  NumberColumn
SQLGenerator
addTinyInteger(string $column, array $attribute = [])

Add tiny integer column

from  NumberColumn
SQLGenerator
addBigInteger(string $column, array $attribute = [])

Add Big integer column

from  NumberColumn
SQLGenerator
addMediumInteger(string $column, array $attribute = [])

Add Medium integer column

from  NumberColumn
SQLGenerator
addMediumIncrement(string $column)

Add Medium integer column

from  NumberColumn
SQLGenerator
changeFloat(string $column, array $attribute = [])

Change float column

from  NumberColumn
SQLGenerator
changeDouble(string $column, array $attribute = [])

Change double column

from  NumberColumn
SQLGenerator
changeDoublePrimary(string $column)

Change double primary column

from  NumberColumn
SQLGenerator
changeFloatPrimary(string $column)

Change float primary column

from  NumberColumn
SQLGenerator
changeIncrement(string $column)

Change increment primary column

from  NumberColumn
SQLGenerator
changeInteger(string $column, array $attribute = [])

Change integer column

from  NumberColumn
SQLGenerator
changeIntegerPrimary(string $column)

Change integer primary column

from  NumberColumn
SQLGenerator
changeBigIncrement(string $column)

Change big increment primary column

from  NumberColumn
SQLGenerator
changeTinyInteger(string $column, array $attribute = [])

Change tiny integer column

from  NumberColumn
SQLGenerator
changeBigInteger(string $column, array $attribute = [])

Change Big integer column

from  NumberColumn
SQLGenerator
changeMediumInteger(string $column, array $attribute = [])

Change Medium integer column

from  NumberColumn
SQLGenerator
changeMediumIncrement(string $column)

Change Medium integer column

from  NumberColumn
SQLGenerator
addBoolean(string $column, array $attribute = [])

Add boolean column

from  MixedColumn
SQLGenerator
addUuid(string $column, array $attribute = [])

Add UUID column

from  MixedColumn
SQLGenerator
addBinary(string $column, array $attribute = [])

Add BLOB column

from  MixedColumn
SQLGenerator
addIpAddress(string $column, array $attribute = [])

Add ip column

from  MixedColumn
SQLGenerator
addMacAddress(string $column, array $attribute = [])

Add mac column

from  MixedColumn
SQLGenerator
addEnum(string $column, array $attribute = [])

Add enum column

from  MixedColumn
SQLGenerator
changeBoolean(string $column, array $attribute = [])

Change boolean column

from  MixedColumn
SQLGenerator
changeUuid(string $column, array $attribute = [])

Change UUID column

from  MixedColumn
SQLGenerator
changeBinary(string $column, array $attribute = [])

Change BLOB column

from  MixedColumn
SQLGenerator
changeIpAddress(string $column, array $attribute = [])

Change ip column

from  MixedColumn
SQLGenerator
changeMacAddress(string $column, array $attribute = [])

Change mac column

from  MixedColumn
SQLGenerator
changeEnum(string $column, array $attribute = [])

Change enum column

from  MixedColumn
SQLGenerator
addString(string $column, array $attribute = [])

Add string column

from  TextColumn
SQLGenerator
addLongString(string $column, array $attribute = [])

Add string column

from  TextColumn
SQLGenerator
addJson(string $column, array $attribute = [])

Add json column

from  TextColumn
SQLGenerator
addChar(string $column, array $attribute = [])

Add character column

from  TextColumn
SQLGenerator
addLongtext(string $column, array $attribute = [])

Add longtext column

from  TextColumn
SQLGenerator
addText(string $column, array $attribute = [])

Add text column

from  TextColumn
SQLGenerator
addBlob(string $column, array $attribute = [])

Add blob column

from  TextColumn
SQLGenerator
changeString(string $column, array $attribute = [])

Change string column

from  TextColumn
SQLGenerator
changeLongString(string $column, array $attribute = [])

Change string column

from  TextColumn
SQLGenerator
changeJson(string $column, array $attribute = [])

Change json column

from  TextColumn
SQLGenerator
changeChar(string $column, array $attribute = [])

Change character column

from  TextColumn
SQLGenerator
changeLongtext(string $column, array $attribute = [])

Change longtext column

from  TextColumn
SQLGenerator
changeText(string $column, array $attribute = [])

Change text column

from  TextColumn
SQLGenerator
changeBlob(string $column, array $attribute = [])

Change blob column

from  TextColumn
SQLGenerator
addDatetime(string $column, array $attribute = [])

Add datetime column

from  DateColumn
SQLGenerator
addDate(string $column, array $attribute = [])

Add date column

from  DateColumn
SQLGenerator
addTime(string $column, array $attribute = [])

Add time column

from  DateColumn
SQLGenerator
addYear(string $column, array $attribute = [])

Add year column

from  DateColumn
SQLGenerator
addTimestamp(string $column, array $attribute = [])

Add timestamp column

from  DateColumn
SQLGenerator
addTimestamps()

Add default timestamps

from  DateColumn
SQLGenerator
changeDatetime(string $column, array $attribute = [])

Change datetime column

from  DateColumn
SQLGenerator
changeDate(string $column, array $attribute = [])

Change date column

from  DateColumn
SQLGenerator
changeTime(string $column, array $attribute = [])

Change time column

from  DateColumn
SQLGenerator
changeYear(string $column, array $attribute = [])

Change year column

from  DateColumn
SQLGenerator
changeTimestamp(string $column, array $attribute = [])

Change timestamp column

from  DateColumn
SQLGenerator
changeTimestamps()

Change default timestamps

from  DateColumn
SQLGenerator
addForeign(string $name, array $attributes = [])

Add Foreign KEY constraints

from  ConstraintColumn
SQLGenerator
dropForeign(string $name, bool $as_raw = false)

Drop constraintes column;

from  ConstraintColumn
SQLGenerator
addIndex(string $name)

Add table index;

from  ConstraintColumn
SQLGenerator
dropIndex(string $name)

Drop table index;

from  ConstraintColumn
SQLGenerator
dropPrimary()

Drop primary column;

from  ConstraintColumn
SQLGenerator
addUnique(string $name)

Add table unique;

from  ConstraintColumn
SQLGenerator
dropUnique(string $name)

Drop table unique;

from  ConstraintColumn
__construct(string $table, string $adapter = 'mysql', string $scope = 'create')

SQLGenerator constructor

string
make()

Generate the sql

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

Add new column in the table

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

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

SQLGenerator
setScope(string $scope)

Set the scope

SQLGenerator
setAdapter(string $adapter)

Set the adapter

Details

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

Add float column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add double column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

in NumberColumn at line 37
SQLGenerator addDoublePrimary(string $column)

Add double primary column

Parameters

string $column

Return Value

SQLGenerator

in NumberColumn at line 48
SQLGenerator addFloatPrimary(string $column)

Add float primary column

Parameters

string $column

Return Value

SQLGenerator

in NumberColumn at line 59
SQLGenerator addIncrement(string $column)

Add increment primary column

Parameters

string $column

Return Value

SQLGenerator

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

Add integer column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

in NumberColumn at line 82
SQLGenerator addIntegerPrimary(string $column)

Add integer primary column

Parameters

string $column

Return Value

SQLGenerator

in NumberColumn at line 93
SQLGenerator addBigIncrement(string $column)

Add big increment primary column

Parameters

string $column

Return Value

SQLGenerator

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

Add tiny integer column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add Big integer column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add Medium integer column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

in NumberColumn at line 140
SQLGenerator addMediumIncrement(string $column)

Add Medium integer column

Parameters

string $column

Return Value

SQLGenerator

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

Change float column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change double column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

in NumberColumn at line 175
SQLGenerator changeDoublePrimary(string $column)

Change double primary column

Parameters

string $column

Return Value

SQLGenerator

in NumberColumn at line 186
SQLGenerator changeFloatPrimary(string $column)

Change float primary column

Parameters

string $column

Return Value

SQLGenerator

in NumberColumn at line 197
SQLGenerator changeIncrement(string $column)

Change increment primary column

Parameters

string $column

Return Value

SQLGenerator

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

Change integer column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

in NumberColumn at line 220
SQLGenerator changeIntegerPrimary(string $column)

Change integer primary column

Parameters

string $column

Return Value

SQLGenerator

in NumberColumn at line 231
SQLGenerator changeBigIncrement(string $column)

Change big increment primary column

Parameters

string $column

Return Value

SQLGenerator

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

Change tiny integer column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change Big integer column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change Medium integer column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

in NumberColumn at line 278
SQLGenerator changeMediumIncrement(string $column)

Change Medium integer column

Parameters

string $column

Return Value

SQLGenerator

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

Add boolean column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add UUID column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add BLOB column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add ip column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add mac column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add enum column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change boolean column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change UUID column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change BLOB column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change ip column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change mac column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change enum column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add string column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

in TextColumn at line 26
SQLGenerator addLongString(string $column, array $attribute = [])

Add string column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add json column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add character column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add longtext column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add text column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add blob column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change string column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

in TextColumn at line 110
SQLGenerator changeLongString(string $column, array $attribute = [])

Change string column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change json column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change character column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change longtext column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change text column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change blob column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add datetime column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add date column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add time column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add year column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add timestamp column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

in DateColumn at line 76
SQLGenerator addTimestamps()

Add default timestamps

Return Value

SQLGenerator

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

Change datetime column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change date column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change time column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change year column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Change timestamp column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

in DateColumn at line 158
SQLGenerator changeTimestamps()

Change default timestamps

Return Value

SQLGenerator

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

Add Foreign KEY constraints

Parameters

string $name
array $attributes

Return Value

SQLGenerator

in ConstraintColumn at line 59
SQLGenerator dropForeign(string $name, bool $as_raw = false)

Drop constraintes column;

Parameters

string $name
bool $as_raw

Return Value

SQLGenerator

in ConstraintColumn at line 79
SQLGenerator addIndex(string $name)

Add table index;

Parameters

string $name

Return Value

SQLGenerator

in ConstraintColumn at line 98
SQLGenerator dropIndex(string $name)

Drop table index;

Parameters

string $name

Return Value

SQLGenerator

in ConstraintColumn at line 114
SQLGenerator dropPrimary()

Drop primary column;

Return Value

SQLGenerator

in ConstraintColumn at line 127
SQLGenerator addUnique(string $name)

Add table unique;

Parameters

string $name

Return Value

SQLGenerator

in ConstraintColumn at line 146
SQLGenerator dropUnique(string $name)

Drop table unique;

Parameters

string $name

Return Value

SQLGenerator

at line 75
__construct(string $table, string $adapter = 'mysql', string $scope = 'create')

SQLGenerator constructor

Parameters

string $table
string $adapter
string $scope

at line 95
string make()

Generate the sql

Return Value

string

at line 113
SQLGenerator addColumn(string $name, string $type, array $attributes = [])

Add new column in the table

Parameters

string $name
string $type
array $attributes

Return Value

SQLGenerator

at line 138
SQLGenerator changeColumn(string $name, string $type, array $attributes = [])

Change a column in the table

Parameters

string $name
string $type
array $attributes

Return Value

SQLGenerator

at line 158
SQLGenerator renameColumn(string $name, string $new)

Rename a column in the table

Parameters

string $name
string $new

Return Value

SQLGenerator

at line 176
SQLGenerator dropColumn(string $name)

Drop table column

Parameters

string $name

Return Value

SQLGenerator

at line 298
void withEngine(string $engine)

Set the engine

Parameters

string $engine

Return Value

void

at line 308
string getEngine()

Get the engine

Return Value

string

at line 320
void withCollation(string $collation)

Set the collation

Parameters

string $collation

Return Value

void

at line 330
string getCollation()

Get the collation

Return Value

string

at line 342
void withCharset(string $charset)

Set the charset

Parameters

string $charset

Return Value

void

at line 352
string getCharset()

Get the charset

Return Value

string

at line 362
string getTable()

Get the define table name

Return Value

string

at line 472
SQLGenerator setScope(string $scope)

Set the scope

Parameters

string $scope

Return Value

SQLGenerator

at line 485
SQLGenerator setAdapter(string $adapter)

Set the adapter

Parameters

string $adapter

Return Value

SQLGenerator