PHP OA_DB::getDsn方法代码示例

 function alterDatabaseActionTable()
 {
     $this->oSchema = MDB2_Schema::factory(OA_DB::singleton(OA_DB::getDsn()));
     $prefix = $GLOBALS['_MAX']['CONF']['table']['prefix'];
     OA_DB::setCaseSensitive();
     $aPrev = $this->oSchema->getDefinitionFromDatabase(array($prefix . 'database_action'));
     OA_DB::disableCaseSensitive();
     $aCurr = $this->_getLatestDatabaseActionSchema($prefix);
     $aChanges = $this->oSchema->compareDefinitions($aCurr, $aPrev);
     if (is_array($aChanges) && count($aChanges) > 0) {
         if (isset($aChanges['tables']['change'][$prefix . 'database_action'])) {
             if (isset($aChanges['tables']['change'][$prefix . 'database_action']['indexes']['add']['database_action_pkey'])) {
                 unset($aChanges['tables']['change'][$prefix . 'database_action']['indexes']['add']['database_action_pkey']);
                 unset($aChanges['tables']['change'][$prefix . 'database_action']['indexes']['change']);
             }
             if (isset($aChanges['tables']['change'][$prefix . 'database_action']['add']['database_action_id'])) {
                 $result = $this->oSchema->alterDatabase($aCurr, $aPrev, $aChanges);
                 if (PEAR::isError($result)) {
                     $this->oUpgrade->oLogger->logError($result->getUserInfo());
                     return false;
                 }
                 $this->oUpgrade->oLogger->log('database_action table schema successfully upgraded');
                 return true;
             }
         }
     }
     $this->oUpgrade->oLogger->log('database_action table schema upgrade unnecessary');
     return true;
 }

 function setUp()
 {
     $this->oDbh = OA_DB::singleton(OA_DB::getDsn());
     $this->oTable = new OA_DB_Table();
     $this->oTable->init(MAX_PATH . '/lib/OA/Upgrade/tests/data/migration_test_1.xml');
     $this->aDefinition = $this->oTable->aDefinition;
 }

 function removeDashboardColumns()
 {
     $this->oSchema = MDB2_Schema::factory(OA_DB::singleton(OA_DB::getDsn()));
     $prefix = $GLOBALS['_MAX']['CONF']['table']['prefix'];
     $table = 'preference';
     $aColumns = array('ad_clicks_sum', 'ad_views_sum', 'ad_clicks_per_second', 'ad_views_per_second', 'ad_cs_data_last_sent', 'ad_cs_data_last_sent', 'ad_cs_data_last_received');
     OA_DB::setCaseSensitive();
     $aDef = $this->oSchema->getDefinitionFromDatabase(array($prefix . $table));
     OA_DB::disableCaseSensitive();
     if (is_array($aDef) && count($aDef) > 0) {
         $aTask['remove'] = array();
         if (isset($aDef['tables'][$prefix . $table])) {
             foreach ($aColumns as $column) {
                 if (isset($aDef['tables'][$prefix . $table]['fields'][$column])) {
                     $aTask['remove'][$column] = array();
                     $this->oUpgrade->oLogger->logOnly("preference.{$column} found");
                 }
             }
         }
         if (count($aTask['remove'] > 0)) {
             $result = $this->oSchema->db->manager->alterTable($prefix . $table, $aTask, false);
         }
     }
     $this->oUpgrade->oLogger->logOnly('preference table schema upgrade for dashboard unnecessary');
     return true;
 }

 function init($aParams)
 {
     $this->className = get_class($this);
     $this->oDBUpgrade = $aParams[0];
     $this->_log('****************************************');
     $this->oDbh = OA_DB::singleton(OA_DB::getDsn());
     return true;
 }

 function _getAuditObject($classToTest)
 {
     $oAuditor = new $classToTest();
     $oDbh = OA_DB::singleton(OA_DB::getDsn());
     $oAuditor->prefix = $GLOBALS['_MAX']['CONF']['table']['prefix'];
     $oAuditor->oDbh = $oDbh;
     return $oAuditor;
 }

 function test_putComponentGroupVersion()
 {
     $oVerCtrl = new OA_Version_Controller();
     $oVerCtrl->init(OA_DB::singleton(OA_DB::getDsn()));
     $this->assertEqual($oVerCtrl->putComponentGroupVersion('plugin_test', 1001), 1001, 'error inserting plugin version');
     $this->assertEqual($oVerCtrl->putComponentGroupVersion('plugin_test', 1002), 1002, 'error updating plugin version');
     $this->assertNotEqual($oVerCtrl->getComponentGroupVersion('plugin_test'), 1001, 'wrong plugin version retrieved');
     $this->_deleteTestRecord('plugin_test');
 }

 function _setupDataObjectOptionsOLD()
 {
     static $needsSetup;
     if (isset($needsSetup)) {
         return;
     }
     $needsSetup = false;
     // Set DB_DataObject options
     $MAX_ENT_DIR = MAX_PATH . '/lib/max/Dal/DataObjects';
     $options =& PEAR::getStaticProperty('DB_DataObject', 'options');
     $options = array('database' => OA_DB::getDsn(), 'schema_location' => $MAX_ENT_DIR, 'class_location' => $MAX_ENT_DIR, 'require_prefix' => $MAX_ENT_DIR . '/', 'class_prefix' => 'DataObjects_', 'debug' => 0, 'production' => 0);
 }

 /**
  * A method to disconnect a database connection resource.
  *
  * @static
  * @param string $dsn Optional database DSN details - disconnects from the
  *                    database defined by the configuration file otherwise.
  *                    See {@link OA_DB::getDsn()} for format.
  * @return void
  */
 static function disconnect($dsn)
 {
     $aConf = $GLOBALS['_MAX']['CONF'];
     // Get the DSN, if not set
     $dsn = is_null($dsn) ? OA_DB::getDsn() : $dsn;
     // Create an MD5 checksum of the DSN
     $dsnMd5 = md5($dsn);
     // Does this database connection already exist?
     $aConnections = array_keys($GLOBALS['_OA']['CONNECTIONS']);
     if (count($aConnections) > 0 && in_array($dsnMd5, $aConnections)) {
         $GLOBALS['_OA']['CONNECTIONS'][$dsnMd5]->disconnect();
         unset($GLOBALS['_OA']['CONNECTIONS'][$dsnMd5]);
     }
 }

 /**
  * create the empty database
  *
  * @return boolean
  */
 function _createDatabase($aDsn = '')
 {
     if ($aDsn) {
         $this->aDsn = $aDsn;
     }
     $GLOBALS['_MAX']['CONF']['database'] = $this->aDsn['database'];
     $GLOBALS['_MAX']['CONF']['table']['prefix'] = $this->aDsn['table']['prefix'];
     $GLOBALS['_MAX']['CONF']['table']['type'] = $this->aDsn['table']['type'];
     // Try connecting to the database
     $this->oDbh =& OA_DB::singleton(OA_DB::getDsn($this->aDsn));
     if (PEAR::isError($this->oDbh)) {
         $GLOBALS['_OA']['CONNECTIONS'] = array();
         $GLOBALS['_MDB2_databases'] = array();
         if (PEAR::isError($result)) {
             $this->oLogger->logError($result->getMessage());
             $this->oLogger->logErrorUnlessEmpty($result->getUserInfo());
             return false;
         }
         //attempt to create DB
         $result = OA_DB::createDatabase($this->aDsn['database']['name']);
         if (PEAR::isError($result)) {
             $this->oLogger->logError($result->getMessage());
             $this->oLogger->logErrorUnlessEmpty($result->getUserInfo());
             return false;
         }
         $this->oDbh = OA_DB::changeDatabase($this->aDsn['database']['name']);
         if (PEAR::isError($this->oDbh)) {
             $this->oLogger->logError($this->oDbh->getMessage());
             $this->oLogger->logErrorUnlessEmpty($this->getUserInfo());
             $this->oDbh = null;
             return false;
         }
         $this->oLogger->log('Database created ' . $this->aDsn['database']['name']);
         $this->can_drop_database = true;
     }
     $result = OA_DB::createFunctions();
     if (PEAR::isError($result)) {
         $this->oLogger->logError($result->getMessage());
         return false;
     }
     return true;
 }

 /**
  * php5 class constructor
  *
  * @param string The XML schema file we are working on
  */
 function __construct($file_schema = 'tables_core.xml', $file_changes = '', $path_schema)
 {
     $this->oLogger = new OA_UpgradeLogger();
     $this->oLogger->setLogFile('schema.log');
     if (empty($path_schema)) {
         $path_schema = '/etc/';
     }
     if (!empty($path_schema) && substr($path_schema, 0, 1) != '/') {
         $path_schema = '/' . $path_schema;
     }
     if (!empty($path_schema) && substr($path_schema, strlen($path_schema) - 4, 4) != 'etc/') {
         $path_schema = $path_schema . 'etc/';
     }
     $this->path_schema_final = MAX_PATH . $path_schema;
     $this->path_schema_trans = MAX_PATH . '/var/';
     $this->path_changes_final = MAX_PATH . $path_schema . 'changes/';
     $this->path_changes_trans = MAX_PATH . '/var/';
     if ($path_schema == '/etc/') {
         $this->path_dbo = MAX_PATH . '/lib/max/Dal/DataObjects/';
     } else {
         $this->path_dbo = $this->path_schema_final . 'DataObjects/';
     }
     //$this->path_links_final = MAX_PATH.'/lib/max/Dal/DataObjects/';
     $this->path_links_final = $this->path_dbo;
     $this->path_links_trans = MAX_PATH . '/var/';
     $file_changes = $file_changes ? $file_changes : 'changes_' . $file_schema;
     $file_links = 'db_schema.links.ini';
     $this->schema_final = $this->path_schema_final . $file_schema;
     $this->schema_trans = $this->path_schema_trans . $file_schema;
     $this->oLogger->log($this->schema_final);
     $this->use_links = $file_schema == 'tables_core.xml';
     if ($this->use_links) {
         $this->links_final = $this->path_links_final . $file_links;
         $this->links_trans = $this->path_links_trans . $file_links;
     }
     $this->changes_final = $this->path_changes_final . $file_changes;
     $this->changes_trans = $this->path_changes_trans . $file_changes;
     $this->oLogger->log($this->changes_final);
     if ($this->use_links) {
         $this->aFile_perms = array($this->path_schema_trans, $this->path_changes_final, $this->path_changes_trans, $this->path_links_trans, $this->links_final, $this->schema_final, MAX_SCHEMA_LOG, MAX_PATH . '/www/devel/');
     } else {
         $this->aFile_perms = array($this->path_schema_trans, $this->path_changes_final, $this->path_changes_trans, $this->schema_final, MAX_SCHEMA_LOG, MAX_PATH . '/www/devel/');
     }
     $this->aDump_options = array('output_mode' => 'file', 'output' => $this->schema_trans, 'end_of_line' => "\n", 'xsl_file' => "xsl/mdb2_schema.xsl", 'custom_tags' => array('version' => '', 'status' => 'transitional'));
     $this->oSchema = MDB2_Schema::factory(OA_DB::singleton(OA_DB::getDsn()), $this->aDump_options);
     $this->dd_file = 'etc/dd.generic.xml';
     $this->aDD_definition = $this->oSchema->parseDictionaryDefinitionFile($this->dd_file);
     ksort($this->aDD_definition);
     //$this->aXMLRPCServer = array('path'=>'/upms/xmlrpc.php', 'host'=>'localhost','port'=>'80');
 }

 /**
  * A method to generate a lock id.
  *
  * @access protected
  *
  * @param string The lock name.
  * @return string The lock id.
  */
 function _getId($sName)
 {
     $aConf = $GLOBALS['_MAX']['CONF'];
     $sId = sha1($this->oDbh->getDsn() . '/' . $aConf['table']['prefix']);
     return "OA_{$sName}.{$sId}";
 }

function save_scenario($basename, $conf)
{
    $dsn = OA_DB::getDsn($conf);
    $dbh =& OA_DB::singleton($dsn);
    $conf['simdb']['version'] = get_max_version($dbh, $conf);
    $versname = $conf['simdb']['version'] . '_' . $basename;
    $sql = get_sql_truncate() . strip_prefix(get_sql_insert($dbh, $conf), $conf['table']['prefix']);
    $maintenance_startdate = date('Y-m-d h:i:s', strtotime("+1 hour", strtotime($conf['startdate'])));
    $sql .= "INSERT INTO `log_maintenance_statistics` (`log_maintenance_statistics_id`, `start_run`, `end_run`, `duration`, `adserver_run_type`, `search_run_type`, `tracker_run_type`, `updated_to`) VALUES (1, '{$maintenance_startdate}', '{$maintenance_startdate}', 0, 2, NULL, NULL, '{$maintenance_startdate}');";
    $sql .= $conf['scenario']['resetpriority'] ? "UPDATE `ad_zone_assoc` SET priority=0;\n" : '';
    sim_write_file('/' . FOLDER_DATA, $versname . '.sql', $sql);
    // create request set
    $conf['scenario']['day'] = date('Y-m-d', strtotime($conf['scenario']['startdate']));
    $conf['scenario']['hour'] = date('G', strtotime($conf['scenario']['startdate']));
    $php = file_get_contents(TPL_PATH . '/scenario_config.php.txt');
    foreach ($conf['request'] as $k => $v) {
        $php = str_replace("conf[request][{$k}]", '"' . $v . '"', $php);
    }
    foreach ($conf['scenario'] as $k => $v) {
        $php = str_replace("conf[scenario][{$k}]", '"' . $v . '"', $php);
    }
    foreach ($conf['simdb'] as $k => $v) {
        $php = str_replace("conf[simdb][{$k}]", '"' . $v . '"', $php);
    }
    foreach ($conf['database'] as $k => $v) {
        $php = str_replace("conf[database][{$k}]", '"' . $v . '"', $php);
    }
    sim_write_file('/' . FOLDER_DATA, $versname . '.php', $php);
    // create child class
    $php = file_get_contents(TPL_PATH . '/scenario_class.php.txt');
    $php = str_replace("<#versname>", $versname, $php);
    $php = str_replace("<#basename>", $basename, $php);
    sim_write_file('/' . FOLDER_SAVE, $basename . '.php', $php);
}

 /**
  * Disconnects from the database server
  *
  * @return boolean
  * @static
  */
 function disconnect()
 {
     $ret = true;
     // reset DataObject cache
     $dsn = OA_DB::getDsn();
     $dsn_md5 = md5($dsn);
     global $_DB_DATAOBJECT;
     if (isset($_DB_DATAOBJECT['CONNECTIONS'][$dsn_md5])) {
         $dbh =& $_DB_DATAOBJECT['CONNECTIONS'][$dsn_md5];
         if (!PEAR::isError($dbh)) {
             $ret = $dbh->disconnect();
         }
         unset($_DB_DATAOBJECT['CONNECTIONS'][$dsn_md5]);
     }
     return $ret;
 }

 /**
  * instantiate the mdb2_schema object
  */
 function initMDB2Schema()
 {
     $result = MDB2_Schema::factory(OA_DB::singleton(OA_DB::getDsn()));
     if (!$this->_isPearError($result, 'failed to instantiate MDB2_Schema')) {
         $this->oSchema = $result;
         $this->portability = $this->oSchema->db->getOption('portability');
         $this->_setupSQLStatements();
         $this->oTable = new OA_DB_Table();
     }
 }