DBSiteStore.php

Go to the documentation of this file.

<?php
use Wikimedia\Rdbms\IConnectionProvider;
use Wikimedia\Rdbms\IDatabase;
 
class DBSiteStore implements SiteStore {
    protected $sites = null;
    private $dbProvider;
 
    public function __construct( IConnectionProvider $dbProvider ) {
        $this->dbProvider = $dbProvider;
    }
 
    public function getSites() {
        $this->loadSites();
 
        return $this->sites;
    }
 
    protected function loadSites() {
        $this->sites = new SiteList();
 
        $dbr = $this->dbProvider->getReplicaDatabase();
 
        $res = $dbr->newSelectQueryBuilder()
            ->select( [
                'site_id',
                'site_global_key',
                'site_type',
                'site_group',
                'site_source',
                'site_language',
                'site_protocol',
                'site_domain',
                'site_data',
                'site_forward',
                'site_config',
            ] )
            ->from( 'sites' )
            ->orderBy( 'site_global_key' )
            ->caller( __METHOD__ )->fetchResultSet();
 
        foreach ( $res as $row ) {
            $site = Site::newForType( $row->site_type );
            $site->setGlobalId( $row->site_global_key );
            $site->setInternalId( (int)$row->site_id );
            $site->setForward( (bool)$row->site_forward );
            $site->setGroup( $row->site_group );
            $site->setLanguageCode( $row->site_language === ''
                ? null
                : $row->site_language
            );
            $site->setSource( $row->site_source );
            $site->setExtraData( unserialize( $row->site_data ) );
            $site->setExtraConfig( unserialize( $row->site_config ) );
            $this->sites[] = $site;
        }
 
        // Batch load the local site identifiers.
        $ids = $dbr->newSelectQueryBuilder()
            ->select( [ 'si_site', 'si_type', 'si_key', ] )
            ->from( 'site_identifiers' )
            ->caller( __METHOD__ )->fetchResultSet();
 
        foreach ( $ids as $id ) {
            if ( $this->sites->hasInternalId( $id->si_site ) ) {
                $site = $this->sites->getSiteByInternalId( $id->si_site );
                $site->addLocalId( $id->si_type, $id->si_key );
                $this->sites->setSite( $site );
            }
        }
    }
 
    public function getSite( $globalId ) {
        if ( $this->sites === null ) {
            $this->sites = $this->getSites();
        }
 
        return $this->sites->hasSite( $globalId ) ? $this->sites->getSite( $globalId ) : null;
    }
 
    public function saveSite( Site $site ) {
        return $this->saveSites( [ $site ] );
    }
 
    public function saveSites( array $sites ) {
        if ( !$sites ) {
            return true;
        }
 
        $dbw = $this->dbProvider->getPrimaryDatabase();
 
        $dbw->startAtomic( __METHOD__ );
 
        $internalIds = [];
        $localIds = [];
 
        foreach ( $sites as $site ) {
            if ( $site->getInternalId() !== null ) {
                $internalIds[] = $site->getInternalId();
            }
 
            $fields = [
                // Site data
                'site_global_key' => $site->getGlobalId(), // TODO: check not null
                'site_type' => $site->getType(),
                'site_group' => $site->getGroup(),
                'site_source' => $site->getSource(),
                'site_language' => $site->getLanguageCode() ?? '',
                'site_protocol' => $site->getProtocol(),
                'site_domain' => strrev( $site->getDomain() ?? '' ) . '.',
                'site_data' => serialize( $site->getExtraData() ),
 
                // Site config
                'site_forward' => $site->shouldForward() ? 1 : 0,
                'site_config' => serialize( $site->getExtraConfig() ),
            ];
 
            $rowId = $site->getInternalId();
            if ( $rowId !== null ) {
                $dbw->newUpdateQueryBuilder()
                    ->update( 'sites' )
                    ->set( $fields )
                    ->where( [ 'site_id' => $rowId ] )
                    ->caller( __METHOD__ )->execute();
            } else {
                $dbw->newInsertQueryBuilder()
                    ->insertInto( 'sites' )
                    ->row( $fields )
                    ->caller( __METHOD__ )->execute();
                $rowId = $dbw->insertId();
            }
 
            foreach ( $site->getLocalIds() as $idType => $ids ) {
                foreach ( $ids as $id ) {
                    $localIds[] = [ $rowId, $idType, $id ];
                }
            }
        }
 
        if ( $internalIds !== [] ) {
            $dbw->newDeleteQueryBuilder()
                ->deleteFrom( 'site_identifiers' )
                ->where( [ 'si_site' => $internalIds ] )
                ->caller( __METHOD__ )->execute();
        }
 
        foreach ( $localIds as $localId ) {
            $dbw->newInsertQueryBuilder()
                ->insertInto( 'site_identifiers' )
                ->row( [ 'si_site' => $localId[0], 'si_type' => $localId[1], 'si_key' => $localId[2] ] )
                ->caller( __METHOD__ )->execute();
        }
 
        $dbw->endAtomic( __METHOD__ );
 
        $this->reset();
 
        return true;
    }
 
    public function reset() {
        $this->sites = null;
    }
 
    public function clear() {
        $dbw = $this->dbProvider->getPrimaryDatabase();
 
        $dbw->startAtomic( __METHOD__ );
        $dbw->newDeleteQueryBuilder()
            ->deleteFrom( 'sites' )
            ->where( IDatabase::ALL_ROWS )
            ->caller( __METHOD__ )->execute();
        $dbw->newDeleteQueryBuilder()
            ->deleteFrom( 'site_identifiers' )
            ->where( IDatabase::ALL_ROWS )
            ->caller( __METHOD__ )->execute();
        $dbw->endAtomic( __METHOD__ );
 
        $this->reset();
    }
 
}