Skip to content

SQLite

Properties

modifiers

protected string[] $modifiers

autoincrement

protected string $autoincrement

nopk

private bool $nopk

Methods

handleTypeInteger

protected handleTypeInteger(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeTime

protected handleTypeTime(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeTimestamp

protected handleTypeTimestamp(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleModifierAutoincrement

public handleModifierAutoincrement(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handlePrimaryKey

public handlePrimaryKey(\Qubus\Expressive\Schema\CreateTable $schema): string

Parameters:

Parameter Type Description
$schema \Qubus\Expressive\Schema\CreateTable

handleEngine

protected handleEngine(\Qubus\Expressive\Schema\CreateTable $schema): string

Parameters:

Parameter Type Description
$schema \Qubus\Expressive\Schema\CreateTable

handleAddUnique

protected handleAddUnique(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleAddIndex

protected handleAddIndex(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

currentDatabase

public currentDatabase(?string $dsn = null): array

Parameters:

Parameter Type Description
$dsn ?string

getTables

public getTables(string $database): array

Parameters:

Parameter Type Description
$database string

getColumns

public getColumns(string $database, string $table): array

Parameters:

Parameter Type Description
$database string
$table string

renameTable

public renameTable(string $current, string $new): array

Parameters:

Parameter Type Description
$current string
$new string

Inherited methods

__construct

public __construct(\Qubus\Expressive\Connection $connection): mixed

Parameters:

Parameter Type Description
$connection \Qubus\Expressive\Connection

setOptions

public setOptions(array $options): $this

Parameters:

Parameter Type Description
$options array

wrap

protected wrap(string $name): string

Parameters:

Parameter Type Description
$name string

wrapArray

protected wrapArray(string[] $value, string $separator = ', '): string

Parameters:

Parameter Type Description
$value string[]
$separator string

value

protected value(float|bool|int|string|null $value): float|int|string

Parameters:

Parameter Type Description
$value float|bool|int|string|null

handleColumns

protected handleColumns(\Qubus\Expressive\Schema\BaseColumn[] $columns): string

Parameters:

Parameter Type Description
$columns \Qubus\Expressive\Schema\BaseColumn[]

handleColumnType

protected handleColumnType(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleColumnModifiers

protected handleColumnModifiers(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeInteger

protected handleTypeInteger(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeFloat

protected handleTypeFloat(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeDouble

protected handleTypeDouble(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeDecimal

protected handleTypeDecimal(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeBoolean

protected handleTypeBoolean(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeBinary

protected handleTypeBinary(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeText

protected handleTypeText(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeString

protected handleTypeString(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeFixed

protected handleTypeFixed(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeTime

protected handleTypeTime(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeTimestamp

protected handleTypeTimestamp(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeDate

protected handleTypeDate(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleTypeDateTime

protected handleTypeDateTime(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleModifierUnsigned

protected handleModifierUnsigned(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleModifierNullable

protected handleModifierNullable(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleModifierDefault

protected handleModifierDefault(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handleModifierAutoincrement

protected handleModifierAutoincrement(\Qubus\Expressive\Schema\BaseColumn $column): string

Parameters:

Parameter Type Description
$column \Qubus\Expressive\Schema\BaseColumn

handlePrimaryKey

protected handlePrimaryKey(\Qubus\Expressive\Schema\CreateTable $schema): string

Parameters:

Parameter Type Description
$schema \Qubus\Expressive\Schema\CreateTable

handleUniqueKeys

protected handleUniqueKeys(\Qubus\Expressive\Schema\CreateTable $schema): string

Parameters:

Parameter Type Description
$schema \Qubus\Expressive\Schema\CreateTable

handleIndexKeys

protected handleIndexKeys(\Qubus\Expressive\Schema\CreateTable $schema): string[]

Parameters:

Parameter Type Description
$schema \Qubus\Expressive\Schema\CreateTable

handleForeignKeys

protected handleForeignKeys(\Qubus\Expressive\Schema\CreateTable $schema): string

Parameters:

Parameter Type Description
$schema \Qubus\Expressive\Schema\CreateTable

handleEngine

protected handleEngine(\Qubus\Expressive\Schema\CreateTable $schema): string

Parameters:

Parameter Type Description
$schema \Qubus\Expressive\Schema\CreateTable

handleDropPrimaryKey

protected handleDropPrimaryKey(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleDropUniqueKey

protected handleDropUniqueKey(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleDropIndex

protected handleDropIndex(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleDropForeignKey

protected handleDropForeignKey(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleDropColumn

protected handleDropColumn(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleRenameColumn

protected handleRenameColumn(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleModifyColumn

protected handleModifyColumn(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleAddColumn

protected handleAddColumn(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleAddPrimary

protected handleAddPrimary(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleAddUnique

protected handleAddUnique(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleAddIndex

protected handleAddIndex(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleAddForeign

protected handleAddForeign(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleSetDefaultValue

protected handleSetDefaultValue(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

handleDropDefaultValue

protected handleDropDefaultValue(\Qubus\Expressive\Schema\AlterTable $table, mixed $data): string

Parameters:

Parameter Type Description
$table \Qubus\Expressive\Schema\AlterTable
$data mixed

getParams

public getParams(): array

currentDatabase

public currentDatabase(string|null $dsn = null): array

Parameters:

Parameter Type Description
$dsn string|null

renameTable

public renameTable(string $current, string $new): array

Parameters:

Parameter Type Description
$current string
$new string

getTables

public getTables(string $database): array

Parameters:

Parameter Type Description
$database string

getColumns

public getColumns(string $database, string $table): array

Parameters:

Parameter Type Description
$database string
$table string

create

public create(\Qubus\Expressive\Schema\CreateTable $schema): array

Parameters:

Parameter Type Description
$schema \Qubus\Expressive\Schema\CreateTable

alter

public alter(\Qubus\Expressive\Schema\AlterTable $schema): array

Parameters:

Parameter Type Description
$schema \Qubus\Expressive\Schema\AlterTable

drop

public drop(string $table): array

Parameters:

Parameter Type Description
$table string

truncate

public truncate(string $table): array

Parameters:

Parameter Type Description
$table string

Automatically generated on 2025-10-13