sdr/update/model/ModelBase.php5

<?php
abstract class ModelBase extends SDatabaseModel {
    public static $DB_INFO = array(
        // XXX: replace with appropriate credentials for database
        0 => array(
            'host' => 'mysql-be-yes-i-really-mean-prod.shodor.org',
            'user' => 'adm_sdr',
            'name' => 'db_sdr'
        ),
        'adm_sdr' => 'S9W6FMTbdJaR',
        'submit_sdr' => '3KnNwmUs'
    );

    public static $DEPENDENCIES = array(
        'SDRVersionFieldValue' => array(
            'SDRValue' => 'valueId',
            'SDRField' => 'fieldId',
            'SDRVersion' => 'versionId'
        ),
        'SDRDateValue' => array(
            'SDRValue' => 'valueId'
        ),
        'SDRFieldValue' => array(
            'SDRValue' => 'valueId',
            'SDRField' => 'fieldId'
        ),
        'SDRVersionCache' => array(
            'SDRResource' => 'cserdId',
            'SDRVersion' => 'versionId'
        ),
        'SDRSearchWordCount' => array(
            'SDRResource' => 'cserdId',
            'SDRField' => 'fieldId',
            'SDRSearchWord' => 'searchWordId'
        ),
        'SDRResourceCache' => array(
            'SDRVersionCache' => 'pendingVersionId'
        ),
        'SDRTextValue' => array(
            'SDRValue' => 'valueId'
        ),
        'SDRProjectField' => array(
            'SDRProject' => 'projectId',
            'SDRField' => 'fieldId'
        ),
        'SDRIntValue' => array(
            'SDRValue' => 'valueId'
        ),
        'SDRVersion' => array(
            'SDRResource' => 'cserdId',
            'SDRAgent' => 'modifiedAgentId'
        ),
        'SDRResource' => array(
            'SDRProject' => 'primaryProject'
        ),
        'SDRResourceProject' => array(
            'SDRResource' => 'cserdId',
            'SDRProject' => 'projectId'
        )
    );

    public static $REVERSE_DEPENDENCIES = array(
        'SDRVersionCache' => array(
            'SDRResourceCache' => 'pendingVersionId'
        ),
        'SDRVersion' => array(
            'SDRVersionFieldValue' => 'versionId',
            'SDRVersionCache' => 'versionId'
        ),
        'SDRAgent' => array(
            'SDRVersion' => 'modifiedAgentId'
        ),
        'SDRValue' => array(
            'SDRVersionFieldValue' => 'valueId',
            'SDRDateValue' => 'valueId',
            'SDRFieldValue' => 'valueId',
            'SDRTextValue' => 'valueId',
            'SDRIntValue' => 'valueId'
        ),
        'SDRResource' => array(
            'SDRVersionCache' => 'cserdId',
            'SDRSearchWordCount' => 'cserdId',
            'SDRResourceProject' => 'cserdId',
            'SDRVersion' => 'cserdId'
        ),
        'SDRProject' => array(
            'SDRResource' => 'primaryProject',
            'SDRResourceProject' => 'projectId',
            'SDRProjectField' => 'projectId'
        ),
        'SDRField' => array(
            'SDRVersionFieldValue' => 'fieldId',
            'SDRFieldValue' => 'fieldId',
            'SDRSearchWordCount' => 'fieldId',
            'SDRProjectField' => 'fieldId'
        ),
        'SDRSearchWord' => array(
            'SDRSearchWordCount' => 'searchWordId'
        )
    );

    public function __construct() {
        parent::__construct();

        $this->registerDBI(self::getDBI());

        // TODO: add any additional object initialization here...
    }

    public static function init($user = false, $server = false) {
        global $sdr_DB_INFO;

        if(isset($GLOBALS['sdr_DB_INFO'])) {
            self::$DB_INFO = array_merge(self::$DB_INFO, $GLOBALS['sdr_DB_INFO']);
            if(isset($GLOBALS['sdr_DB_INFO'][0])) {
                self::$DB_INFO[0] = array_merge(self::$DB_INFO[0], $GLOBALS['sdr_DB_INFO'][0]);
                unset(self::$DB_INFO[1]);
            }
        }

        if($user === false) {
            if(isset($GLOBALS['sdr_DB_USER']))
                $user = $GLOBALS['sdr_DB_USER'];
            else
                $user = self::$DB_INFO[0]['user'];
        }

        if(!isset(self::$DB_INFO[$user])) {
            self::setStaticError('Unknown database user "' . $user . '" given!');
            return false;
        }

        $pass = self::$DB_INFO[$user];

        if($server === false) {
            if(isset($GLOBALS['sdr_DB_SERVER']))
                $server = $GLOBALS['sdr_DB_SERVER'];
            else
                $server = self::$DB_INFO[0]['host'];
        }

        $name = self::$DB_INFO[0]['name'];

        new DBI2('sdr', $server, $name, $user, $pass);

        // TODO: any additional global initialization here

        return true;
    }

    public static function getDBI() {
        $dbi = DBI2::getDBI('sdr');
        if(!$dbi) {
            if(!self::init())
                return null;
            $dbi = DBI2::getDBI('sdr');
        }
        return $dbi;
    }
}

?>

---