MySQLBuilder 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 $table — Table name

Return Value

  • bool

Signature

public function hasTable(string $table): bool
hasColumn

Check if a column exists in the specified table

Parameters

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

Return Value

  • bool

Signature

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

Check if a key exists in the specified table

Parameters

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

Return Value

  • bool

Signature

public function hasKey(string $table, string $key): 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 $table — Table name

Return Value

  • bool

Signature

public function dropTable(string $table)
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)
getColumnAttributes

Get the attributes of the given column

Parameters

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

Return Value

  • object

Signature

protected function getColumnAttributes(string $table, string $column)
packColumn

Pack a Column object into a valid SQL string

Parameters

  • Aurora\Database\Schema\Column $column — Column object

Return Value

  • string

Signature

protected function packColumn(Aurora\Database\Schema\Column $column): string
packKey

Pack a Key object into a valid SQL string

Parameters

  • Aurora\Database\Schema\Key $key — Key object

Return Value

  • string

Signature

protected function packKey(Aurora\Database\Schema\Key $key): string

Go to top