Windwalker\Database\Command\AbstractTable

class AbstractTable (View source)

Class DatabaseTable

Methods

__construct(string $table, AbstractDatabaseDriver $db)

Constructor.

AbstractTable

create(callable|Schema $callback, bool $ifNotExists = true, array $options = array())

create

AbstractTable

update(callable|Schema $schema)

update

$this

save(callable|Schema $schema, bool $ifNotExists = true, array $options = array())

save

AbstractTable

drop(bool $ifExists = true, string $option = '')

drop

boolean

exists()

exists

$this

rename(string $newName, boolean $returnNew = true)

rename

AbstractTable

lock()

Locks a table in the database.

AbstractTable

unlock()

unlock

AbstractTable

truncate()

Method to truncate a table.

array|boolean

getDetail()

getDetail

array

getColumns(bool $refresh = false)

Get table columns.

mixed

getColumnDetails(bool $refresh = false)

getColumnDetails

stdClass

getColumnDetail(string $column)

getColumnDetail

boolean

hasColumn(string $column)

hasColumn

AbstractTable

addColumn(string $name, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())

addColumn

AbstractTable

dropColumn(string $name)

dropColumn

AbstractTable

modifyColumn(string|Column $name, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())

modifyColumn

AbstractTable

changeColumn(string $oldName, string|Column $newName, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())

changeColumn

AbstractTable

addIndex(string $type, array $columns = array(), string $name = null, string $comment = null, array $options = array())

addIndex

AbstractTable

dropIndex(string $name)

dropIndex

array

getIndexes()

getIndexes

boolean

hasIndex(string $name)

hasIndex

string

getName()

Method to get property Table

AbstractTable

setName(string $name)

Method to set property table

AbstractDatabaseDriver

getDriver()

Method to get property Db

AbstractTable

setDriver(AbstractDatabaseDriver $db)

Method to set property db

Schema

getSchema()

getSchema

AbstractDatabase

getDatabase()

Method to get property Database

AbstractTable

setDatabase(AbstractDatabase $database)

Method to set property database

DataType

getDataType()

getTypeMapper

AbstractTable

reset()

reset

Details

at line line 64
`__construct(string $table, AbstractDatabaseDriver $db)`

Constructor.

Parameters

string	$table
AbstractDatabaseDriver	$db

at line line 80
`abstract AbstractTable create(callable|Schema $callback, bool $ifNotExists = true, array $options = array())`

create

Parameters

callable\|Schema	$callback
bool	$ifNotExists
array	$options

string	$name
string	$type
bool	$signed
bool	$allowNull
string	$default
string	$comment
array	$options

string\|Column	$name
string	$type
bool	$signed
bool	$allowNull
string	$default
string	$comment
array	$options

string	$oldName
string\|Column	$newName
string	$type
bool	$signed
bool	$allowNull
string	$default
string	$comment
array	$options

AbstractTable

Methods

Details

at line line 64 __construct(string $table, AbstractDatabaseDriver $db)

Parameters

at line line 80 abstract AbstractTable create(callable|Schema $callback, bool $ifNotExists = true, array $options = array())

Parameters

Return Value

at line line 89 AbstractTable update(callable|Schema $schema)

Parameters

Return Value

at line line 115 $this save(callable|Schema $schema, bool $ifNotExists = true, array $options = array())

Parameters

Return Value

at line line 142 AbstractTable drop(bool $ifExists = true, string $option = '')

Parameters

Return Value

at line line 158 boolean exists()

Return Value

at line line 173 abstract $this rename(string $newName, boolean $returnNew = true)

Parameters

Return Value

at line line 183 AbstractTable lock()

Return Value

Exceptions

at line line 197 AbstractTable unlock()

Return Value

Exceptions

at line line 212 AbstractTable truncate()

Return Value

Exceptions

at line line 224 array|boolean getDetail()

Return Value

at line line 236 array getColumns(bool $refresh = false)

Parameters

Return Value

at line line 248 abstract mixed getColumnDetails(bool $refresh = false)

Parameters

Return Value

at line line 257 stdClass getColumnDetail(string $column)

Parameters

Return Value

at line line 271 boolean hasColumn(string $column)

Parameters

Return Value

at line line 289 abstract AbstractTable addColumn(string $name, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())

Parameters

Return Value

at line line 298 AbstractTable dropColumn(string $name)

Parameters

Return Value

at line line 327 abstract AbstractTable modifyColumn(string|Column $name, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())

Parameters

Return Value

at line line 343 abstract AbstractTable changeColumn(string $oldName, string|Column $newName, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())

Parameters

Return Value

at line line 356 abstract AbstractTable addIndex(string $type, array $columns = array(), string $name = null, string $comment = null, array $options = array())

Parameters

Return Value

at line line 365 abstract AbstractTable dropIndex(string $name)

Parameters

Return Value

at line line 372 abstract array getIndexes()

Return Value

at line line 381 boolean hasIndex(string $name)

Parameters

Return Value

at line line 401 string getName()

Return Value

at line line 418 AbstractTable setName(string $name)

Parameters

Return Value

at line line 430 AbstractDatabaseDriver getDriver()

Return Value

at line line 442 AbstractTable setDriver(AbstractDatabaseDriver $db)

Parameters

Return Value

at line line 454 Schema getSchema()

Return Value

at line line 64
`__construct(string $table, AbstractDatabaseDriver $db)`

at line line 80
`abstract AbstractTable create(callable|Schema $callback, bool $ifNotExists = true, array $options = array())`

at line line 89
`AbstractTable update(callable|Schema $schema)`

at line line 115
`$this save(callable|Schema $schema, bool $ifNotExists = true, array $options = array())`

at line line 142
`AbstractTable drop(bool $ifExists = true, string $option = '')`

at line line 158
`boolean exists()`

at line line 173
`abstract $this rename(string $newName, boolean $returnNew = true)`

at line line 183
`AbstractTable lock()`

at line line 197
`AbstractTable unlock()`

at line line 212
`AbstractTable truncate()`

at line line 224
`array|boolean getDetail()`

at line line 236
`array getColumns(bool $refresh = false)`

at line line 248
`abstract mixed getColumnDetails(bool $refresh = false)`

at line line 257
`stdClass getColumnDetail(string $column)`

at line line 271
`boolean hasColumn(string $column)`

at line line 289
`abstract AbstractTable addColumn(string $name, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())`

at line line 298
`AbstractTable dropColumn(string $name)`

at line line 327
`abstract AbstractTable modifyColumn(string|Column $name, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())`

at line line 343
`abstract AbstractTable changeColumn(string $oldName, string|Column $newName, string $type = 'text', bool $signed = true, bool $allowNull = true, string $default = '', string $comment = '', array $options = array())`

at line line 356
`abstract AbstractTable addIndex(string $type, array $columns = array(), string $name = null, string $comment = null, array $options = array())`

at line line 365
`abstract AbstractTable dropIndex(string $name)`

at line line 372
`abstract array getIndexes()`

at line line 381
`boolean hasIndex(string $name)`

at line line 401
`string getName()`

at line line 418
`AbstractTable setName(string $name)`

at line line 430
`AbstractDatabaseDriver getDriver()`

at line line 442
`AbstractTable setDriver(AbstractDatabaseDriver $db)`

at line line 454
`Schema getSchema()`

at line line 490
`AbstractDatabase getDatabase()`

at line line 502
`AbstractTable setDatabase(AbstractDatabase $database)`

at line line 519
`DataType getDataType()`

at line line 579
`AbstractTable reset()`