Gitee
\
Acme
app
admin
controller
model
validate
index
controller
Composer
Autoload
Monolog
Formatter
Handler
Curl
FingersCrossed
Slack
SyslogUdp
Processor
Phinx
Db
Adapter
Table
Migration
Seed
Util
Psr
Log
Test
tests
think
angular
captcha
composer
helper
hash
image
gif
migration
command
migrate
seed
db
mongo
oracle
queue
command
connector
driver
job
sae
testing
command
view
driver
worker
third
Workerman
Connection
Events
React
Lib
Protocols

\Phinx\MigrationMigrationInterface

Migration interface

Summary

Methods
Constants
up()
down()
setAdapter()
getAdapter()
setInput()
getInput()
setOutput()
getOutput()
getName()
setVersion()
getVersion()
execute()
query()
fetchRow()
fetchAll()
insert()
createDatabase()
dropDatabase()
hasTable()
table()
CHANGE
UP
DOWN
No protected methods found
N/A
No private methods found
N/A

Constants

CHANGE

CHANGE = 'change' : string

UP

UP = 'up' : string

DOWN

DOWN = 'down' : string

Methods

up()

up() : void

Migrate Up

down()

down() : void

Migrate Down

setInput()

setInput(\think\console\Input  $input) : \Phinx\Migration\MigrationInterface

Sets the input object to be used in migration object

Parameters

\think\console\Input $input

Returns

\Phinx\Migration\MigrationInterface

getInput()

getInput() : \think\console\Input

Gets the input object to be used in migration object

Returns

\think\console\Input

setOutput()

setOutput(\think\console\Output  $output) : \Phinx\Migration\MigrationInterface

Sets the output object to be used in migration object

Parameters

\think\console\Output $output

Returns

\Phinx\Migration\MigrationInterface

getOutput()

getOutput() : \think\console\Output

Gets the output object to be used in migration object

Returns

\think\console\Output

getName()

getName() : string

Gets the name.

Returns

string

setVersion()

setVersion(float  $version) : \Phinx\Migration\MigrationInterface

Sets the migration version number.

Parameters

float $version

Version

Returns

\Phinx\Migration\MigrationInterface

getVersion()

getVersion() : float

Gets the migration version number.

Returns

float

execute()

execute(string  $sql) : integer

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

Parameters

string $sql

SQL

Returns

integer

query()

query(string  $sql) : array

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

Parameters

string $sql

SQL

Returns

array

fetchRow()

fetchRow(string  $sql) : array

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

Parameters

string $sql

SQL

Returns

array

fetchAll()

fetchAll(string  $sql) : array

Executes a query and returns an array of rows.

Parameters

string $sql

SQL

Returns

array

insert()

insert(string  $tableName, array  $data) : void

Insert data into a table.

Parameters

string $tableName
array $data

createDatabase()

createDatabase(string  $name, array  $options) : void

Create a new database.

Parameters

string $name

Database Name
array $options

Options

dropDatabase()

dropDatabase(string  $name) : void

Drop a database.

Parameters

string $name

Database Name

hasTable()

hasTable(string  $tableName) : boolean

Checks to see if a table exists.

Parameters

string $tableName

Table Name

Returns

boolean

table()

table(string  $tableName, array  $options) : \Phinx\Db\Table

Returns an instance of the <code>\Table</code> class.

You can use this class to create and manipulate tables.

Parameters

string $tableName

Table Name
array $options

Options

Returns

\Phinx\Db\Table