PHP Класс SQLBuilder\Universal\Syntax\Column

См. также: http://www.postgresql.org/docs/9.3/interactive/datatype.html MySQL Data Types:
См. также: http://dev.mysql.com/doc/refman/5.6/en/data-types.html MySQL Reference reference_definition: REFERENCES tbl_name (index_col_name,...) [MATCH FULL | MATCH PARTIAL | MATCH SIMPLE] [ON DELETE reference_option] [ON UPDATE reference_option] reference_option: RESTRICT | CASCADE | SET NULL | NO ACTION
Наследование: implements SQLBuilder\ToSqlInterface
Показать файл Открыть проект Примеры использования класса

Открытые свойства

Свойство Тип Описание
$enum is only used when isa = enum
$isa
$name column name
$notNull Null is set to true by default. (I know MySQL set this as default if you don't specify the not null constraint)
$onUpdate right now this is only for timestamp column
$primary primary
$set is only used when isa = set
$type
$unsigned unsigned

Защищенные свойства (Protected)

Свойство Тип Описание
$attributeTypes array
$attributes array The default attributes for a column.

Открытые методы

Метод Описание
__call ( $method, $args )
__construct ( $name = NULL, $type = NULL, array $extraAttributes = [] )
__get ( $name )
__get_state ( )
__isset ( $name )
__set ( $name, $value )
__set_state ( array $stash )
autoIncrement ( )
bigint ( $length = NULL )
binary ( $length = NULL )
bit ( $length = 1 )
blob ( )
bool ( )
boolean ( )
buildAutoIncrementClause ( BaseDriver $driver )
buildDefaultClause ( BaseDriver $driver )
buildDefinitionSql ( BaseDriver $driver, SQLBuilder\ArgumentArray $args )
buildDefinitionSqlForModify ( BaseDriver $driver, SQLBuilder\ArgumentArray $args )
buildEnumClause ( BaseDriver $driver )
buildNullClause ( BaseDriver $driver ) ***** Clause builder *****
buildPgSQLDefinitionSql ( BaseDriver $driver, SQLBuilder\ArgumentArray $args )
buildPrimaryKeyClause ( BaseDriver $driver )
buildSetClause ( BaseDriver $driver )
buildTimeZoneClause ( BaseDriver $driver )
buildTypeClause ( BaseDriver $driver )
buildTypeName ( BaseDriver $driver )
buildUniqueClause ( BaseDriver $driver )
buildUnsignedClause ( BaseDriver $driver )
char ( $length )
date ( ) ********************************************** DateTime related types ***********************************************
datetime ( )
decimal ( $length = NULL, $decimals = NULL )
double ( $length = NULL, $decimals = NULL ) PgSQL supports double, real.
enum ( $a )
float ( $length = NULL, $decimals = NULL )
getAttribute ( string $name ) Which should be something like getAttribute($name)
getName ( )
getType ( )
int ( $length = NULL )
integer ( $length = NULL )
isa ( $isa )
longblob ( )
longtext ( )
mediumInt ( $length = NULL )
mediumblob ( )
mediumtext ( )
name ( $name )
notNull ( )
null ( )
nullDefined ( )
numeric ( $length = NULL, $decimals = NULL )
point ( ) POINT type
primary ( $primary = true )
real ( $length = NULL, $decimals = NULL )
serial ( ) serial type
set ( $a )
setAttribute ( $name, $value )
setAttributeStash ( array $attributes )
setAttributes ( array $attributes )
smallInt ( $length = NULL )
text ( )
time ( $timezone = true )
timestamp ( $timezone = true ) mysql timestamp automatic initialization
timezone ( $bool = true )
tinyInt ( $length = NULL )
tinyblob ( )
toSql ( BaseDriver $driver, SQLBuilder\ArgumentArray $args )
type ( $type )
unsigned ( $unsigned = true )
varchar ( $length )
year ( )

Защищенные методы

Метод Описание
setLengthInfo ( $length, $decimals = NULL ) ******************************************************************* PROTECTED METHODS (internal use) *********************************************************************

Описание методов

__call() публичный Метод

public __call ( $method, $args )

__construct() публичный Метод

public __construct ( $name = NULL, $type = NULL, array $extraAttributes = [] )
$extraAttributes array

__get() публичный Метод

public __get ( $name )

__get_state() публичный Метод

public __get_state ( )

__isset() публичный Метод

public __isset ( $name )

__set() публичный Метод

public __set ( $name, $value )

__set_state() публичный статический Метод

public static __set_state ( array $stash )
$stash array

autoIncrement() публичный Метод

public autoIncrement ( )

bigint() публичный Метод

public bigint ( $length = NULL )

binary() публичный Метод

public binary ( $length = NULL )

bit() публичный Метод

public bit ( $length = 1 )

blob() публичный Метод

public blob ( )

bool() публичный Метод

public bool ( )

boolean() публичный Метод

public boolean ( )

buildAutoIncrementClause() публичный Метод

public buildAutoIncrementClause ( BaseDriver $driver )
$driver SQLBuilder\Driver\BaseDriver

buildDefaultClause() публичный Метод

public buildDefaultClause ( BaseDriver $driver )
$driver SQLBuilder\Driver\BaseDriver

buildDefinitionSql() публичный Метод

public buildDefinitionSql ( BaseDriver $driver, SQLBuilder\ArgumentArray $args )
$driver SQLBuilder\Driver\BaseDriver
$args SQLBuilder\ArgumentArray

buildDefinitionSqlForModify() публичный Метод

public buildDefinitionSqlForModify ( BaseDriver $driver, SQLBuilder\ArgumentArray $args )
$driver SQLBuilder\Driver\BaseDriver
$args SQLBuilder\ArgumentArray

buildEnumClause() публичный Метод

public buildEnumClause ( BaseDriver $driver )
$driver SQLBuilder\Driver\BaseDriver

buildNullClause() публичный Метод

***** Clause builder *****
public buildNullClause ( BaseDriver $driver )
$driver SQLBuilder\Driver\BaseDriver

buildPgSQLDefinitionSql() публичный Метод

public buildPgSQLDefinitionSql ( BaseDriver $driver, SQLBuilder\ArgumentArray $args )
$driver SQLBuilder\Driver\BaseDriver
$args SQLBuilder\ArgumentArray

buildPrimaryKeyClause() публичный Метод

public buildPrimaryKeyClause ( BaseDriver $driver )
$driver SQLBuilder\Driver\BaseDriver

buildSetClause() публичный Метод

public buildSetClause ( BaseDriver $driver )
$driver SQLBuilder\Driver\BaseDriver

buildTimeZoneClause() публичный Метод

public buildTimeZoneClause ( BaseDriver $driver )
$driver SQLBuilder\Driver\BaseDriver

buildTypeClause() публичный Метод

public buildTypeClause ( BaseDriver $driver )
$driver SQLBuilder\Driver\BaseDriver

buildTypeName() публичный Метод

public buildTypeName ( BaseDriver $driver )
$driver SQLBuilder\Driver\BaseDriver

buildUniqueClause() публичный Метод

public buildUniqueClause ( BaseDriver $driver )
$driver SQLBuilder\Driver\BaseDriver

buildUnsignedClause() публичный Метод

public buildUnsignedClause ( BaseDriver $driver )
$driver SQLBuilder\Driver\BaseDriver

char() публичный Метод

public char ( $length )

date() публичный Метод

********************************************** DateTime related types ***********************************************
public date ( )

datetime() публичный Метод

public datetime ( )

decimal() публичный Метод

public decimal ( $length = NULL, $decimals = NULL )

double() публичный Метод

XXX: support for 'Infinity' '-Infinity' 'NaN'. MySQL supports float, real, double: float(3), float, real, real(10) MySQL permits a nonstandard syntax: FLOAT(M,D) or REAL(M,D) or DOUBLE PRECISION(M,D). Here, “(M,D)” means than values can be stored with up to M digits in total, of which D digits may be after the decimal point. For example, a column defined as FLOAT(7,4) will look like -999.9999 when displayed. MySQL performs rounding when storing values, so if you insert 999.00009 into a FLOAT(7,4) column, the approximate result is 999.0001.
См. ссылку: XXX: we should handle exceptions when number is out-of-range:
См. ссылку: http://dev.mysql.com/doc/refman/5.0/en/out-of-range-and-overflow.html
public double ( $length = NULL, $decimals = NULL )

enum() публичный Метод

public enum ( $a )

float() публичный Метод

public float ( $length = NULL, $decimals = NULL )

getAttribute() публичный Метод

Which should be something like getAttribute($name)
public getAttribute ( string $name )
$name string attribute name

getName() публичный Метод

public getName ( )

getType() публичный Метод

public getType ( )

int() публичный Метод

public int ( $length = NULL )

integer() публичный Метод

public integer ( $length = NULL )

isa() публичный Метод

public isa ( $isa )

longblob() публичный Метод

public longblob ( )

longtext() публичный Метод

public longtext ( )

mediumInt() публичный Метод

public mediumInt ( $length = NULL )

mediumblob() публичный Метод

public mediumblob ( )

mediumtext() публичный Метод

public mediumtext ( )

name() публичный Метод

public name ( $name )

notNull() публичный Метод

public notNull ( )

null() публичный Метод

public null ( )

nullDefined() публичный Метод

public nullDefined ( )

numeric() публичный Метод

public numeric ( $length = NULL, $decimals = NULL )

point() публичный Метод

POINT type
public point ( )

primary() публичный Метод

public primary ( $primary = true )

real() публичный Метод

public real ( $length = NULL, $decimals = NULL )

serial() публичный Метод

for postgresql-only
public serial ( )

set() публичный Метод

public set ( $a )

setAttribute() публичный Метод

public setAttribute ( $name, $value )

setAttributeStash() публичный Метод

public setAttributeStash ( array $attributes )
$attributes array

setAttributes() публичный Метод

public setAttributes ( array $attributes )
$attributes array

setLengthInfo() защищенный Метод

******************************************************************* PROTECTED METHODS (internal use) *********************************************************************
protected setLengthInfo ( $length, $decimals = NULL )

smallInt() публичный Метод

public smallInt ( $length = NULL )

text() публичный Метод

public text ( )

time() публичный Метод

public time ( $timezone = true )

timestamp() публичный Метод

mysql timestamp automatic initialization
См. также: http://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
public timestamp ( $timezone = true )

timezone() публичный Метод

public timezone ( $bool = true )

tinyInt() публичный Метод

public tinyInt ( $length = NULL )

tinyblob() публичный Метод

public tinyblob ( )

toSql() публичный Метод

public toSql ( BaseDriver $driver, SQLBuilder\ArgumentArray $args )
$driver SQLBuilder\Driver\BaseDriver
$args SQLBuilder\ArgumentArray

type() публичный Метод

public type ( $type )

unsigned() публичный Метод

public unsigned ( $unsigned = true )

varchar() публичный Метод

public varchar ( $length )

year() публичный Метод

public year ( )

Описание свойств

$attributeTypes защищенное свойство

protected array $attributeTypes
Результат array

$attributes защищенное свойство

The default attributes for a column.
protected array $attributes
Результат array

$enum публичное свойство

is only used when isa = enum
public $enum

$isa публичное свойство

public $isa

$name публичное свойство

column name
public $name

$notNull публичное свойство

Null is set to true by default. (I know MySQL set this as default if you don't specify the not null constraint)
public $notNull

$onUpdate публичное свойство

right now this is only for timestamp column
public $onUpdate

$primary публичное свойство

primary
public $primary

$set публичное свойство

is only used when isa = set
public $set

$type публичное свойство

public $type

$unsigned публичное свойство

unsigned
public $unsigned