• Home
• Piwik
• Updater
• Migration
• Db
• Factory

PHP Class Piwik\Updater\Migration\Db\Factory

Show file Open project: piwik/piwik

Public Methods

Method	Description
__construct ( )
addColumn ( string $table, string $columnName, string $columnType, string | null $placeColumnAfter = null ) : AddColumn	Adds a new database table column to an existing table.
addColumns ( string $table, array $columns, string | null $placeColumnAfter = null ) : AddColumns	Adds multiple new database table columns to an existing table at once.
addIndex ( string $table, string[] | string $columnNames, string $indexName = '' ) : AddIndex	Adds an index to an existing database table.
addPrimaryKey ( string $table, string[] | string $columnNames ) : AddPrimaryKey	Adds a primary key to an existing database table.
addUniqueKey ( string $table, string[] | string $columnNames, string $indexName = '' ) : AddIndex	Adds a unique key to an existing database table.
batchInsert ( string $table, string[] $columnNames, array $values, boolean $throwException = false, string $charset = 'utf8' ) : BatchInsert	Performs a batch insert into a specific table using either LOAD DATA INFILE or plain INSERTs, as a fallback. On MySQL, LOAD DATA INFILE is 20x faster than a series of plain INSERTs.
boundSql ( string $sql, array $bind, integer | int[] $errorCodesToIgnore = [] ) : BoundSql	Performs a custom SQL query that uses bound parameters during the update.
changeColumn ( string $table, string $oldColumnName, string $newColumnName, string $columnType ) : ChangeColumn	Changes the column name and column type of an existing database table column.
changeColumnType ( string $table, string $columnName, string $columnType ) : ChangeColumnType	Changes the type of an existing database table column.
changeColumnTypes ( string $table, array $columns ) : ChangeColumnTypes	Changes the type of multiple existing database table columns at the same time.
createTable ( string $table, array $columnNames, string | string[] $primaryKey = [] ) : CreateTable	Creates a new database table.
dropColumn ( string $table, string $columnName ) : DropColumn	Drops an existing database table column.
dropIndex ( string $table, string $indexName ) : DropIndex	Drops an existing index from a database table.
dropTable ( string $table ) : DropTable	Drops an existing database table.
insert ( string $table, array $columnValuePairs ) : Insert	Inserts a new record / row into an existing database table.
sql ( string $sql, integer | int[] $errorCodesToIgnore = [] ) : Sql	Performs a custom SQL query during the update.

Private Methods

Method	Description
prefixTable ( $table )

Method Details