SQLiteBuilder Class

Aurora\Database\Schema\Builder Namespace

Interfaces

Properties

connection

Database connection

protected $connection: \Connection

Constructor

__construct

Constructor

Parameters

  • Aurora\Database\Connection $connection — Database connection

Signature

public function __construct(Aurora\Database\Connection $connection)

Methods

__construct

Constructor

Parameters

  • Aurora\Database\Connection $connection — Database connection

Signature

public function __construct(Aurora\Database\Connection $connection)
getTables

Get tables

Return Value

  • array

Signature

public function getTables(): array
getColumns

Get table columns

Parameters

  • string $table — Table name

Return Value

  • array

Signature

public function getColumns(string $table): array
getKeys

Get table keys

Parameters

  • string $table — Table name

Return Value

  • array

Signature

public function getKeys(string $table): array
hasTable

Check if a table exists

Parameters

  • string $name — Table name

Return Value

  • bool

Signature

public function hasTable(string $name): bool
hasColumn

Check if a column exists in the specified table

Parameters

  • string $table — Table name
  • string $name — Column name

Return Value

  • bool

Signature

public function hasColumn(string $table, string $name): bool
hasKey

Check if a key exists in the specified table

Parameters

  • string $table — Table name
  • string $name — Key name

Return Value

  • bool

Signature

public function hasKey(string $table, string $name): bool
createTable

Create a table

Parameters

  • Aurora\Database\Schema\Table $table — Table object

Return Value

  • bool

Signature

public function createTable(Aurora\Database\Schema\Table $table): bool
dropTable

Drop a table

Parameters

  • string $name — Table name

Return Value

  • bool

Signature

public function dropTable(string $name): bool
alterTable

Modify a table

Parameters

  • Aurora\Database\Schema\Table $table — Table object

Return Value

  • bool

Signature

public function alterTable(Aurora\Database\Schema\Table $table): bool
renameTable

Rename a table

Parameters

  • string $from — Current table name
  • string $to — New table name

Return Value

  • bool

Signature

public function renameTable(string $from, string $to)

Go to top