class Schema

Traits

Properties

static $debug

Methods

static 
setMigrationFilePath(string $filePath)

No description

from  Utils
static 
getMigrationFilePath()

No description

from  Utils
static 
isDetailExists(string $hash)

No description

from  Utils
static 
createMigrationDetail(string $filePath)

No description

from  Utils
static 
getLastVersion()

No description

from  Utils
debug()

No description

from  Utils
static 
checkTable(string $tableName)

No description

from  Utils
static 
repairTable(string $tableName)

No description

from  Utils
PDOStatement
getTableDetail(string $tableName)

No description

from  Detail
PDOStatement
getColumnDetail(string $tableName, string $columnName)

No description

from  Detail
array
getTableColumn(string $tableName, bool $fetchAll = false)

No description

from  Detail
static bool
hasTable(string $tableName)

CHeck if table is exists or not

from  Detail
static bool
hasColumn(string $tableName, string $columnName)

Check if column exists or not

from  Detail
column(string $column)

This method relate with Schema::table('')

from  Detail
array
columns(bool $fetchAll = false)

Same as column, but this method will give you more raw information about column in some table

from  Detail
static array
tables()

Get all table data from current database

from  Detail
bool
isAutoIncrement()

Get boolean result about table and column Auto Increment status

from  Detail
bool
isTemporary()

No description

from  Detail
bool
isEmpty()

No description

from  Detail
bool
isNull()

No description

from  Detail
bool
isUnique()

No description

from  Detail
bool
isPrimary()

No description

from  Detail
bool
isFullText()

No description

from  Detail
bool
isExists()

No description

from  Detail
static 
connection(string $connectionName = 'SLiMS')

No description

static void
getInstance()

Use singleton pattern

void
structureCreate(string $tableName, Closure $callBack)

Create and table schema with Blueprint as designer based on rdbms grammar

Schema|string
structureTable(string $tableName, Closure $callBack = '')

Modify existing table

void
structureDrop(string $tableName)

Drop table just type table name and drop it.

void
structureDropColumn(string $tableName, string $columnName)

Drop column table just type table and column name then drop it.

void
structureTruncate(string $tableName)

Emptying table

string
__call($method, $arguments)

Magic method to call data via scoped property or structure method

static 
__callStatic($method, $arguments)

No description

Details

in Utils at line 18
static setMigrationFilePath(string $filePath)

No description

Parameters

string $filePath

in Utils at line 23
static getMigrationFilePath()

No description

in Utils at line 28
static isDetailExists(string $hash)

No description

Parameters

string $hash

in Utils at line 36
static createMigrationDetail(string $filePath)

No description

Parameters

string $filePath

in Utils at line 49
static getLastVersion()

No description

in Utils at line 56
debug()

No description

in Utils at line 61
static checkTable(string $tableName)

No description

Parameters

string $tableName

in Utils at line 69
static repairTable(string $tableName)

No description

Parameters

string $tableName

in Detail at line 59
PDOStatement getTableDetail(string $tableName)

No description

Parameters

string $tableName

Return Value

PDOStatement

in Detail at line 77
PDOStatement getColumnDetail(string $tableName, string $columnName)

No description

Parameters

string $tableName
string $columnName

Return Value

PDOStatement

in Detail at line 95
array getTableColumn(string $tableName, bool $fetchAll = false)

No description

Parameters

string $tableName
bool $fetchAll

Return Value

array

in Detail at line 119
static bool hasTable(string $tableName)

CHeck if table is exists or not

Parameters

string $tableName

Return Value

bool

in Detail at line 131
static bool hasColumn(string $tableName, string $columnName)

Check if column exists or not

Parameters

string $tableName
string $columnName

Return Value

bool

in Detail at line 142
Schema column(string $column)

This method relate with Schema::table('')

Parameters

string $column

Return Value

Schema

in Detail at line 156
array columns(bool $fetchAll = false)

Same as column, but this method will give you more raw information about column in some table

Parameters

bool $fetchAll

Return Value

array

in Detail at line 166
static array tables()

Get all table data from current database

Return Value

array

in Detail at line 189
bool isAutoIncrement()

Get boolean result about table and column Auto Increment status

Return Value

bool

in Detail at line 198
bool isTemporary()

No description

Return Value

bool

in Detail at line 206
bool isEmpty()

No description

Return Value

bool

in Detail at line 214
bool isNull()

No description

Return Value

bool

in Detail at line 222
bool isUnique()

No description

Return Value

bool

in Detail at line 230
bool isPrimary()

No description

Return Value

bool

in Detail at line 238
bool isFullText()

No description

Return Value

bool

in Detail at line 246
bool isExists()

No description

Return Value

bool

at line 45
static connection(string $connectionName = 'SLiMS')

No description

Parameters

string $connectionName

at line 57
static void getInstance()

Use singleton pattern

Return Value

void

at line 73
void structureCreate(string $tableName, Closure $callBack)

Create and table schema with Blueprint as designer based on rdbms grammar

Parameters

string $tableName
Closure $callBack

Return Value

void

at line 99
Schema|string structureTable(string $tableName, Closure $callBack = '')

Modify existing table

Parameters

string $tableName
Closure $callBack

Return Value

Schema|string

at line 128
void structureDrop(string $tableName)

Drop table just type table name and drop it.

Parameters

string $tableName

Return Value

void

at line 140
void structureDropColumn(string $tableName, string $columnName)

Drop column table just type table and column name then drop it.

Parameters

string $tableName
string $columnName

Return Value

void

at line 151
void structureTruncate(string $tableName)

Emptying table

Parameters

string $tableName

Return Value

void

at line 163
string __call($method, $arguments)

Magic method to call data via scoped property or structure method

Parameters

$method
$arguments

Return Value

string

at line 185
static __callStatic($method, $arguments)

No description

Parameters

$method
$arguments