Page MenuHomeWickedGov Phorge
Files F1425940

migrate-schema2.php
No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

migrate-schema2.php
View Options

<?php
/**
* Script to convert Translate extension database schema to v2
*
* @author Niklas Laxström
* @copyright Copyright © 2011, Niklas Laxström
* @license GPL-2.0-or-later
* @file
*/
// Standard boilerplate to define $IP
if ( getenv( 'MW_INSTALL_PATH' ) !== false ) {
$IP = getenv( 'MW_INSTALL_PATH' );
} else {
$dir = __DIR__;
$IP = "$dir/../../..";
}
require_once "$IP/maintenance/Maintenance.php";
/**
* Script to convert Translate extension database schema to v2.
* Essentially gets rid of revtag_type table, which was unnecessary
* abstraction.
*/
class TSchema2 extends Maintenance {
public function __construct() {
parent::__construct();
$this->addDescription( 'Migrates database schema to version 2.' );
$this->requireExtension( 'Translate' );
}
public function execute() {
$dbw = $this->getDB( DB_PRIMARY );
if ( !$dbw->tableExists( 'revtag', __METHOD__ ) ) {
$this->fatalError( "Table revtag doesn't exist. Translate extension is not installed?" );
}
if ( !$dbw->tableExists( 'revtag_type', __METHOD__ ) ) {
$this->fatalError( "Table revtag_type doesn't exist. Migration is already done." );
}
if ( $dbw->getType() !== 'mysql' ) {
$this->error( 'This migration script only supports mysql. Please help ' .
"us to write routine for {$dbw->getType()}.", 1 );
}
$table = $dbw->tableName( 'revtag' );
$dbw->query( "ALTER TABLE $table MODIFY rt_type varbinary(60) not null", __METHOD__ );
$res = $dbw->newSelectQueryBuilder()
->select( [ 'rtt_id', 'rtt_name' ] )
->from( 'revtag_type' )
->caller( __METHOD__ )
->fetchResultSet();
foreach ( $res as $row ) {
$dbw->newUpdateQueryBuilder()
->update( 'revtag' )
->set( [ 'rt_type' => $row->rtt_name ] )
->where( [ 'rt_type' => (string)$row->rtt_id ] )
->caller( __METHOD__ )
->execute();
}
$dbw->dropTable( 'revtag_type', __METHOD__ );
}
}
$maintClass = TSchema2::class;
require_once RUN_MAINTENANCE_IF_MAIN;

File Metadata

Mime Type
text/x-php
Expires
Sat, May 16, 12:16 (1 d, 18 m)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
9d/be/524a4c6fea59b615021c5d8c2ce5
Default Alt Text
migrate-schema2.php (1 KB)

Event Timeline