migrate-schema2.php

Go to the documentation of this file.

<?php
// 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";

class TSchema2 extends Maintenance {

    public function __construct() {
        parent::__construct();
        $this->mDescription = 'Migrates database schema to version 2.';
    }

    public function execute() {
        $dbw = wfGetDB( DB_MASTER );
        if ( !$dbw->tableExists( 'revtag' ) ) {
            $this->error( "Table revtag doesn't exist. Translate extension is not installed?", 1 );
        }

        if ( !$dbw->tableExists( 'revtag_type' ) ) {
            $this->error( "Table revtag_type doesn't exist. Migration is already done.", 1 );
        }

        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->select(
            'revtag_type',
            array( 'rtt_id', 'rtt_name' ),
            array(),
            __METHOD__
        );

        foreach ( $res as $row ) {
            $dbw->update(
                'revtag',
                array( 'rt_type' => $row->rtt_name ),
                array( 'rt_type' => (string)$row->rtt_id ),
                __METHOD__
            );
        }

        $dbw->dropTable( 'revtag_type', __METHOD__ );
    }
}

$maintClass = 'TSchema2';
require_once DO_MAINTENANCE;