\Phinx\Db\AdapterPdoAdapter

__construct()

__construct(array  $options, \think\console\Input  $input = null, \think\console\Output  $output = null) 

Class Constructor.

Parameters

setOptions()

setOptions(array  $options) : \Phinx\Db\Adapter\AdapterInterface

Set adapter configuration options.

Parameters

Returns

getOptions()

getOptions() : array

Get all adapter options.

Returns

hasOption()

hasOption(string  $name) : boolean

Check if an option has been set.

Parameters

Returns

getOption()

getOption(string  $name) : mixed

Get a single adapter option, or null if the option does not exist.

Parameters

Returns

setInput()

setInput(\think\console\Input  $input) : \Phinx\Db\Adapter\AdapterInterface

Sets the console input.

Parameters

Returns

getInput()

getInput() : \think\console\Input

Gets the console input.

Returns

setOutput()

setOutput(\think\console\Output  $output) : \Phinx\Db\Adapter\AdapterInterface

Sets the console output.

Parameters

Returns

getOutput()

getOutput() : \think\console\Output

Gets the console output.

Returns

setSchemaTableName()

setSchemaTableName(string  $schemaTableName) : \Phinx\Db\Adapter\PdoAdapter

Sets the schema table name.

Parameters

Returns

getSchemaTableName()

getSchemaTableName() : string

Gets the schema table name.

Returns

setConnection()

setConnection(\PDO  $connection) : \Phinx\Db\Adapter\AdapterInterface

Sets the database connection.

Parameters

Returns

getConnection()

getConnection() : \PDO

Gets the database connection

Returns

setCommandStartTime()

setCommandStartTime(integer  $time) : \Phinx\Db\Adapter\AdapterInterface

Sets the command start time

Parameters

Returns

getCommandStartTime()

getCommandStartTime() : integer

Gets the command start time

Returns

startCommandTimer()

startCommandTimer() : void

Start timing a command.

endCommandTimer()

endCommandTimer() : void

Stop timing the current command and write the elapsed time to the output.

writeCommand()

writeCommand(string  $command, array  $args = array()) : void

Write a Phinx command to the output.

Parameters

connect()

connect() : void

Initializes the database connection.

disconnect()

disconnect() : void

Closes the database connection.

execute()

execute(string  $sql) : integer

Executes a SQL statement and returns the number of affected rows.

Parameters

Returns

query()

query(string  $sql) : array

Executes a SQL statement and returns the result as an array.

Parameters

Returns

fetchRow()

fetchRow(string  $sql) : array

Executes a query and returns only one row as an array.

Parameters

Returns

fetchAll()

fetchAll(string  $sql) : array

Executes a query and returns an array of rows.

Parameters

Returns

insert()

insert(\Phinx\Db\Table  $table, array  $row) : void

Inserts data into a table.

Parameters

getVersions()

getVersions() : array

Get all migrated version numbers.

Returns

getVersionLog()

getVersionLog() : array

Get all migration log entries, indexed by version number.

Returns

migrated()

migrated(\Phinx\Migration\MigrationInterface  $migration, string  $direction, integer  $startTime, integer  $endTime) : \Phinx\Db\Adapter\AdapterInterface

Records a migration being run.

Parameters

Returns

toggleBreakpoint()

toggleBreakpoint(\Phinx\Migration\MigrationInterface  $migration) : \Phinx\Db\Adapter\AdapterInterface

Toggle a migration breakpoint.

Parameters

Returns

resetAllBreakpoints()

resetAllBreakpoints() : integer

Reset all migration breakpoints.

Returns

The number of breakpoints reset

hasSchemaTable()

hasSchemaTable() : boolean

Does the schema table exist?

Returns

createSchemaTable()

createSchemaTable() : void

Creates the schema table.

getAdapterType()

getAdapterType() : string

Returns the adapter type.

Returns

getColumnTypes()

getColumnTypes() : array

Returns an array of the supported Phinx column types.

Returns

isValidColumnType()

isValidColumnType(\Phinx\Db\Table\Column  $column) : boolean

Checks that the given column is of a supported type.

Parameters

Returns

castToBool()

castToBool(mixed  $value) : mixed

Cast a value to a boolean appropriate for the adapter.

Parameters

Returns