ExternalStoreDB.php

Go to the documentation of this file.

<?php
class ExternalStoreDB extends ExternalStoreMedium {
    public function fetchFromURL( $url ) {
        list( $cluster, $id, $itemID ) = $this->parseURL( $url );
        $ret =& $this->fetchBlob( $cluster, $id, $itemID );

        if ( $itemID !== false && $ret !== false ) {
            return $ret->getItem( $itemID );
        }
        return $ret;
    }

    public function batchFetchFromURLs( array $urls ) {
        $batched = $inverseUrlMap = array();
        foreach ( $urls as $url ) {
            list( $cluster, $id, $itemID ) = $this->parseURL( $url );
            $batched[$cluster][$id][] = $itemID;
            // false $itemID gets cast to int, but should be ok
            // since we do === from the $itemID in $batched
            $inverseUrlMap[$cluster][$id][$itemID] = $url;
        }
        $ret = array();
        foreach ( $batched as $cluster => $batchByCluster ) {
            $res = $this->batchFetchBlobs( $cluster, $batchByCluster );
            foreach ( $res as $id => $blob ) {
                foreach ( $batchByCluster[$id] as $itemID ) {
                    $url = $inverseUrlMap[$cluster][$id][$itemID];
                    if ( $itemID === false ) {
                        $ret[$url] = $blob;
                    } else {
                        $ret[$url] = $blob->getItem( $itemID );
                    }
                }
            }
        }
        return $ret;
    }

    public function store( $cluster, $data ) {
        $dbw = $this->getMaster( $cluster );
        $id = $dbw->nextSequenceValue( 'blob_blob_id_seq' );
        $dbw->insert( $this->getTable( $dbw ),
            array( 'blob_id' => $id, 'blob_text' => $data ),
            __METHOD__ );
        $id = $dbw->insertId();
        if ( !$id ) {
            throw new MWException( __METHOD__ . ': no insert ID' );
        }
        if ( $dbw->getFlag( DBO_TRX ) ) {
            $dbw->commit( __METHOD__ );
        }
        return "DB://$cluster/$id";
    }

    function &getLoadBalancer( $cluster ) {
        $wiki = isset( $this->params['wiki'] ) ? $this->params['wiki'] : false;

        return wfGetLBFactory()->getExternalLB( $cluster, $wiki );
    }

    function &getSlave( $cluster ) {
        global $wgDefaultExternalStore;

        $wiki = isset( $this->params['wiki'] ) ? $this->params['wiki'] : false;
        $lb =& $this->getLoadBalancer( $cluster );

        if ( !in_array( "DB://" . $cluster, (array)$wgDefaultExternalStore ) ) {
            wfDebug( "read only external store" );
            $lb->allowLagged( true );
        } else {
            wfDebug( "writable external store" );
        }

        return $lb->getConnection( DB_SLAVE, array(), $wiki );
    }

    function &getMaster( $cluster ) {
        $wiki = isset( $this->params['wiki'] ) ? $this->params['wiki'] : false;
        $lb =& $this->getLoadBalancer( $cluster );
        return $lb->getConnection( DB_MASTER, array(), $wiki );
    }

    function getTable( &$db ) {
        $table = $db->getLBInfo( 'blobs table' );
        if ( is_null( $table ) ) {
            $table = 'blobs';
        }
        return $table;
    }

    function &fetchBlob( $cluster, $id, $itemID ) {
        static $externalBlobCache = array();

        $cacheID = ( $itemID === false ) ? "$cluster/$id" : "$cluster/$id/";
        if ( isset( $externalBlobCache[$cacheID] ) ) {
            wfDebugLog( 'ExternalStoreDB-cache',
                "ExternalStoreDB::fetchBlob cache hit on $cacheID\n" );
            return $externalBlobCache[$cacheID];
        }

        wfDebugLog( 'ExternalStoreDB-cache',
            "ExternalStoreDB::fetchBlob cache miss on $cacheID\n" );

        $dbr =& $this->getSlave( $cluster );
        $ret = $dbr->selectField( $this->getTable( $dbr ),
            'blob_text', array( 'blob_id' => $id ), __METHOD__ );
        if ( $ret === false ) {
            wfDebugLog( 'ExternalStoreDB',
                "ExternalStoreDB::fetchBlob master fallback on $cacheID\n" );
            // Try the master
            $dbw =& $this->getMaster( $cluster );
            $ret = $dbw->selectField( $this->getTable( $dbw ),
                'blob_text', array( 'blob_id' => $id ), __METHOD__ );
            if ( $ret === false ) {
                wfDebugLog( 'ExternalStoreDB',
                    "ExternalStoreDB::fetchBlob master failed to find $cacheID\n" );
            }
        }
        if ( $itemID !== false && $ret !== false ) {
            // Unserialise object; caller extracts item
            $ret = unserialize( $ret );
        }

        $externalBlobCache = array( $cacheID => &$ret );
        return $ret;
    }

    function batchFetchBlobs( $cluster, array $ids ) {
        $dbr = $this->getSlave( $cluster );
        $res = $dbr->select( $this->getTable( $dbr ),
            array( 'blob_id', 'blob_text' ), array( 'blob_id' => array_keys( $ids ) ), __METHOD__ );
        $ret = array();
        if ( $res !== false ) {
            $this->mergeBatchResult( $ret, $ids, $res );
        }
        if ( $ids ) {
            wfDebugLog( __CLASS__, __METHOD__ .
                " master fallback on '$cluster' for: " .
                implode( ',', array_keys( $ids ) ) . "\n" );
            // Try the master
            $dbw = $this->getMaster( $cluster );
            $res = $dbw->select( $this->getTable( $dbr ),
                array( 'blob_id', 'blob_text' ),
                array( 'blob_id' => array_keys( $ids ) ),
                __METHOD__ );
            if ( $res === false ) {
                wfDebugLog( __CLASS__, __METHOD__ . " master failed on '$cluster'\n" );
            } else {
                $this->mergeBatchResult( $ret, $ids, $res );
            }
        }
        if ( $ids ) {
            wfDebugLog( __CLASS__, __METHOD__ .
                " master on '$cluster' failed locating items: " .
                implode( ',', array_keys( $ids ) ) . "\n" );
        }
        return $ret;
    }

    private function mergeBatchResult( array &$ret, array &$ids, $res ) {
        foreach ( $res as $row ) {
            $id = $row->blob_id;
            $itemIDs = $ids[$id];
            unset( $ids[$id] ); // to track if everything is found
            if ( count( $itemIDs ) === 1 && reset( $itemIDs ) === false ) {
                // single result stored per blob
                $ret[$id] = $row->blob_text;
            } else {
                // multi result stored per blob
                $ret[$id] = unserialize( $row->blob_text );
            }
        }
    }

    protected function parseURL( $url ) {
        $path = explode( '/', $url );
        return array(
            $path[2], // cluster
            $path[3], // id
            isset( $path[4] ) ? $path[4] : false // itemID
        );
    }
}