CloneDatabase.php

Go to the documentation of this file.

<?php
class CloneDatabase {
    private $newTablePrefix = '';
 
    private $oldTablePrefix = '';
 
    private $tablesToClone = array();
 
    private $dropCurrentTables = true;
 
    private $useTemporaryTables = true;
 
    public function __construct( DatabaseBase $db, array $tablesToClone,
        $newTablePrefix, $oldTablePrefix = '', $dropCurrentTables = true
    ) {
        $this->db = $db;
        $this->tablesToClone = $tablesToClone;
        $this->newTablePrefix = $newTablePrefix;
        $this->oldTablePrefix = $oldTablePrefix ? $oldTablePrefix : $this->db->tablePrefix();
        $this->dropCurrentTables = $dropCurrentTables;
    }
 
    public function useTemporaryTables( $u = true ) {
        $this->useTemporaryTables = $u;
    }
 
    public function cloneTableStructure() {
        foreach ( $this->tablesToClone as $tbl ) {
            # Clean up from previous aborted run.  So that table escaping
            # works correctly across DB engines, we need to change the pre-
            # fix back and forth so tableName() works right.
 
            self::changePrefix( $this->oldTablePrefix );
            $oldTableName = $this->db->tableName( $tbl, 'raw' );
 
            self::changePrefix( $this->newTablePrefix );
            $newTableName = $this->db->tableName( $tbl, 'raw' );
 
            if ( $this->dropCurrentTables
                && !in_array( $this->db->getType(), array( 'postgres', 'oracle' ) )
            ) {
                $this->db->dropTable( $tbl, __METHOD__ );
                wfDebug( __METHOD__ . " dropping {$newTableName}\n" );
                //Dropping the oldTable because the prefix was changed
            }
 
            # Create new table
            wfDebug( __METHOD__ . " duplicating $oldTableName to $newTableName\n" );
            $this->db->duplicateTableStructure( $oldTableName, $newTableName, $this->useTemporaryTables );
        }
    }
 
    public function destroy( $dropTables = false ) {
        if ( $dropTables ) {
            self::changePrefix( $this->newTablePrefix );
            foreach ( $this->tablesToClone as $tbl ) {
                $this->db->dropTable( $tbl );
            }
        }
        self::changePrefix( $this->oldTablePrefix );
    }
 
    public static function changePrefix( $prefix ) {
        global $wgDBprefix;
        wfGetLBFactory()->forEachLB( array( 'CloneDatabase', 'changeLBPrefix' ), array( $prefix ) );
        $wgDBprefix = $prefix;
    }
 
    public static function changeLBPrefix( $lb, $prefix ) {
        $lb->forEachOpenConnection( array( 'CloneDatabase', 'changeDBPrefix' ), array( $prefix ) );
    }
 
    public static function changeDBPrefix( $db, $prefix ) {
        $db->tablePrefix( $prefix );
    }
}