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
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
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
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
addForeign(string $name, array $attributes = [])

Add Foreign KEY constraints

from  ConstraintColumn
SQLGenerator
dropForeign(string $name)

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
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 18
SQLGenerator addFloat(string $column, array $attribute = [])

Add float column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add double column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add double primary column

Parameters

string $column

Return Value

SQLGenerator

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

Add float primary column

Parameters

string $column

Return Value

SQLGenerator

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

Add increment primary column

Parameters

string $column

Return Value

SQLGenerator

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

Add integer column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add integer primary column

Parameters

string $column

Return Value

SQLGenerator

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

Add big increment primary column

Parameters

string $column

Return Value

SQLGenerator

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

Add tiny integer column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add Big integer column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add Medium integer column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add Medium integer column

Parameters

string $column

Return Value

SQLGenerator

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

Add boolean column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add UUID column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add BLOB column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add ip column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add mac column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add string column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add string column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add json column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add character column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add longtext column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add text column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add blob column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add datetime column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add date column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add time column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add year column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

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

Add timestamp column

Parameters

string $column
array $attribute

Return Value

SQLGenerator

in DateColumn at line 80
SQLGenerator addTimestamps()

Add default timestamps

Return Value

SQLGenerator

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

Add Foreign KEY constraints

Parameters

string $name
array $attributes

Return Value

SQLGenerator

in ConstraintColumn at line 62
SQLGenerator dropForeign(string $name)

Drop constraintes column;

Parameters

string $name

Return Value

SQLGenerator

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

Add table index;

Parameters

string $name

Return Value

SQLGenerator

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

Drop table index;

Parameters

string $name

Return Value

SQLGenerator

in ConstraintColumn at line 115
SQLGenerator dropPrimary()

Drop primary column;

Return Value

SQLGenerator

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

Add table unique;

Parameters

string $name

Return Value

SQLGenerator

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

Drop table unique;

Parameters

string $name

Return Value

SQLGenerator

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

SQLGenerator constructor

Parameters

string $table
string $adapter
string $scope

at line 97
string make()

Generate the sql

Return Value

string

at line 115
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 dropColumn(string $name)

Drop table column

Parameters

string $name

Return Value

SQLGenerator

at line 210
void withEngine(string $engine)

Set the engine

Parameters

string $engine

Return Value

void

at line 220
string getEngine()

Get the engine

Return Value

string

at line 232
void withCollation(string $collation)

Set the collation

Parameters

string $collation

Return Value

void

at line 242
string getCollation()

Get the collation

Return Value

string

at line 254
void withCharset(string $charset)

Set the charset

Parameters

string $charset

Return Value

void

at line 264
string getCharset()

Get the charset

Return Value

string

at line 274
string getTable()

Get the define table name

Return Value

string

at line 370
SQLGenerator setScope(string $scope)

Set the scope

Parameters

string $scope

Return Value

SQLGenerator

at line 383
SQLGenerator setAdapter(string $adapter)

Set the adapter

Parameters

string $adapter

Return Value

SQLGenerator