PHP 클래스 Cake\Database\Schema\SqliteSchema

상속: extends Cake\Database\Schema\BaseSchema

보호된 프로퍼티들

프로퍼티	타입	설명
$_constraintsIdMap	array	Array containing the foreign keys constraints names Necessary for composite foreign keys to be handled

공개 메소드들

메소드	설명
addConstraintSql ( Table $table )	{@inheritDoc}
columnSql ( Table $table, $name )	{@inheritDoc}
constraintSql ( Table $table, $name )	{@inheritDoc}
convertColumnDescription ( Table $table, $row )	{@inheritDoc}
convertForeignKeyDescription ( Table $table, $row )	{@inheritDoc}
convertIndexDescription ( Table $table, $row )	{@inheritDoc}
createTableSql ( Table $table, $columns, $constraints, $indexes )	{@inheritDoc}
describeColumnSql ( $tableName, $config )	{@inheritDoc}
describeForeignKeySql ( $tableName, $config )	{@inheritDoc}
describeIndexSql ( $tableName, $config )	{@inheritDoc}
dropConstraintSql ( Table $table )	{@inheritDoc}
hasSequences ( ) : boolean	Returns whether there is any table in this connection to SQLite containing sequences
indexSql ( Table $table, $name )	{@inheritDoc}
listTablesSql ( $config )	{@inheritDoc}
truncateTableSql ( Table $table )	{@inheritDoc}

보호된 메소드들

메소드	설명
_convertColumn ( string $column ) : array	Convert a column definition to the abstract types.
_defaultValue ( string \| null $default ) : string \| null	Manipulate the default value.

메소드 상세

_convertColumn() 보호된 메소드

The returned type will be a type that Cake\Database\Type can handle.

protected _convertColumn ( string $column ) : array
$column	string	The column type + length
리턴	array	Array of column information.

_defaultValue() 보호된 메소드

Sqlite includes quotes and bared NULLs in default values. We need to remove those.

protected _defaultValue ( string \| null $default ) : string \| null
$default	string \| null	The default value.
리턴	string \| null

addConstraintSql() 공개 메소드

SQLite can not properly handle adding a constraint to an existing table. This method is no-op

public addConstraintSql ( Table $table )
$table	Table

columnSql() 공개 메소드

{@inheritDoc}

public columnSql ( Table $table, $name )
$table	Table

constraintSql() 공개 메소드

Note integer primary keys will return ''. This is intentional as Sqlite requires that integer primary keys be defined in the column definition.

public constraintSql ( Table $table, $name )
$table	Table

convertColumnDescription() 공개 메소드

{@inheritDoc}

public convertColumnDescription ( Table $table, $row )
$table	Table

convertForeignKeyDescription() 공개 메소드

{@inheritDoc}

public convertForeignKeyDescription ( Table $table, $row )
$table	Table

convertIndexDescription() 공개 메소드

Since SQLite does not have a way to get metadata about all indexes at once, additional queries are done here. Sqlite constraint names are not stable, and the names for constraints will not match those used to create the table. This is a limitation in Sqlite's metadata features.

public convertIndexDescription ( Table $table, $row )
$table	Table

createTableSql() 공개 메소드

{@inheritDoc}

public createTableSql ( Table $table, $columns, $constraints, $indexes )
$table	Table

describeColumnSql() 공개 메소드

{@inheritDoc}

public describeColumnSql ( $tableName, $config )

describeForeignKeySql() 공개 메소드

{@inheritDoc}

public describeForeignKeySql ( $tableName, $config )

describeIndexSql() 공개 메소드

{@inheritDoc}

public describeIndexSql ( $tableName, $config )

dropConstraintSql() 공개 메소드

SQLite can not properly handle dropping a constraint to an existing table. This method is no-op

public dropConstraintSql ( Table $table )
$table	Table

hasSequences() 공개 메소드

Returns whether there is any table in this connection to SQLite containing sequences

public hasSequences ( ) : boolean
리턴	boolean

indexSql() 공개 메소드

{@inheritDoc}

public indexSql ( Table $table, $name )
$table	Table

listTablesSql() 공개 메소드

{@inheritDoc}

public listTablesSql ( $config )

truncateTableSql() 공개 메소드

{@inheritDoc}

public truncateTableSql ( Table $table )
$table	Table

프로퍼티 상세

$_constraintsIdMap 보호되어 있는 프로퍼티

Array containing the foreign keys constraints names Necessary for composite foreign keys to be handled

protected array $_constraintsIdMap
리턴	array