PHP RedBeanDatabase::getDatabaseInfoFromDsnString方法代码示例

 public function testGetDatabaseInfoFromConnectionString()
 {
     $dsn = 'mysql:host=localhost;port=3306;dbname=zurmo';
     // Not Coding Standard
     $databaseConnectionInfo = RedBeanDatabase::getDatabaseInfoFromDsnString($dsn);
     $compareData = array('databaseType' => 'mysql', 'databaseHost' => 'localhost', 'databasePort' => '3306', 'databaseName' => 'zurmo');
     $this->assertEquals($compareData, $databaseConnectionInfo);
     $dsn = 'mysql:host=127.0.0.1;dbname=zurmo';
     // Not Coding Standard
     $databaseConnectionInfo = RedBeanDatabase::getDatabaseInfoFromDsnString($dsn);
     $compareData = array('databaseType' => 'mysql', 'databaseHost' => '127.0.0.1', 'databasePort' => '3306', 'databaseName' => 'zurmo');
     $this->assertEquals($compareData, $databaseConnectionInfo);
     $dsn = 'mysql:host=localhost;dbname=zurmo;port=3306;';
     // Not Coding Standard
     $databaseConnectionInfo = RedBeanDatabase::getDatabaseInfoFromDsnString($dsn);
     $compareData = array('databaseType' => 'mysql', 'databaseHost' => 'localhost', 'databasePort' => '3306', 'databaseName' => 'zurmo');
     $this->assertEquals($compareData, $databaseConnectionInfo);
     $dsn = 'mysql:host=localhost;';
     // Not Coding Standard
     try {
         $databaseConnectionInfo = RedBeanDatabase::getDatabaseInfoFromDsnString($dsn);
         $this->fail();
     } catch (NotSupportedException $e) {
     }
 }

 public function __construct()
 {
     parent::__construct();
     list(, $this->temporaryDatabaseHostname, $this->temporaryDatabasePort, $this->temporaryDatabaseName) = array_values(RedBeanDatabase::getDatabaseInfoFromDsnString(Yii::app()->tempDb->connectionString));
     $this->temporaryDatabaseUsername = Yii::app()->tempDb->username;
     $this->temporaryDatabasePassword = Yii::app()->tempDb->password;
     $this->superUserPassword = 'super';
 }

 public function __construct()
 {
     parent::__construct();
     list(, $this->temporaryDatabaseHostname, $this->temporaryDatabasePort, $this->temporaryDatabaseName) = array_values(RedBeanDatabase::getDatabaseInfoFromDsnString(Yii::app()->tempDb->connectionString));
     $this->temporaryDatabaseUsername = Yii::app()->tempDb->username;
     $this->temporaryDatabasePassword = Yii::app()->tempDb->password;
     $this->superUserPassword = 'super';
     $this->databaseBackupTestFile = INSTANCE_ROOT . '/protected/runtime/databaseBackupTest.sql';
 }

 public function setUp()
 {
     parent::setUp();
     list(, $this->databaseHostname, $this->databasePort, $this->databaseName) = array_values(RedBeanDatabase::getDatabaseInfoFromDsnString(Yii::app()->db->connectionString));
     $this->databaseUsername = Yii::app()->db->username;
     $this->databasePassword = Yii::app()->db->password;
     $this->superUserPassword = 'super';
     $this->instanceRoot = INSTANCE_ROOT;
     $this->perInstanceFile = "{$this->instanceRoot}/protected/config/perInstanceTest.php";
     $this->debugFile = "{$this->instanceRoot}/protected/config/debugTest.php";
     if (is_file($this->perInstanceFile)) {
         $this->perInstanceConfigContents = file_get_contents($this->perInstanceFile);
         unlink($this->perInstanceFile);
     }
     if (is_file($this->debugFile)) {
         $this->debugConfigContents = file_get_contents($this->debugFile);
         unlink($this->debugFile);
     }
     Yii::app()->gameHelper->muteScoringModelsOnSave();
 }

 /**
  * Execute the action.
  * @param array command line parameters specific for this command
  */
 public function run($args)
 {
     set_time_limit('3600');
     if (!isset($args[0])) {
         $this->usageError('You must specify an action.');
     } else {
         $action = $args[0];
     }
     if (!isset($args[1])) {
         $this->usageError('You must specify a path to the file.');
     } else {
         $filePath = $args[1];
     }
     if (count($args) != 2 && count($args) != 8) {
         $this->usageError('Invalid number of arguments.');
     }
     if (count($args) == 8) {
         $databaseType = $args[2];
         $databaseHost = $args[3];
         $databaseName = $args[4];
         $databasePort = $args[5];
         $databaseUsername = $args[6];
         $databasePassword = $args[7];
     } else {
         $databaseConnectionInfo = RedBeanDatabase::getDatabaseInfoFromDsnString(Yii::app()->db->connectionString);
         $databaseType = $databaseConnectionInfo['databaseType'];
         $databaseHost = $databaseConnectionInfo['databaseHost'];
         $databaseName = $databaseConnectionInfo['databaseName'];
         $databasePort = $databaseConnectionInfo['databasePort'];
         $databaseUsername = Yii::app()->db->username;
         $databasePassword = Yii::app()->db->password;
     }
     if (!Yii::app()->isApplicationInMaintenanceMode()) {
         $this->usageError('Please set $maintenanceMode = true in the perInstance.php config file.');
     }
     if (!function_exists('exec')) {
         $this->usageError('exec() command is not available in PHP environment.');
     }
     try {
         $template = "{message}\n";
         $messageStreamer = new MessageStreamer($template);
         $messageStreamer->setExtraRenderBytes(0);
         $messageStreamer->add(' ');
         if ($action == 'backup') {
             $this->backupDatabase($filePath, $messageStreamer, $databaseType, $databaseHost, $databaseName, $databasePort, $databaseUsername, $databasePassword);
         } elseif ($action == 'restore') {
             $this->restoreDatabase($filePath, $messageStreamer, $databaseType, $databaseHost, $databaseName, $databasePort, $databaseUsername, $databasePassword);
         } else {
             $this->usageError('Invalid action. Valid values are "backup" and "restore".');
         }
     } catch (Exception $e) {
         $messageStreamer->add(Zurmo::t('Commands', 'An error occur during database backup/restore: {message}', array('{message}' => $e->getMessage())));
     }
 }

 public static function checkServicesAfterInstallationAndGetResultsDataForDisplay()
 {
     $servicesToCheck = self::getServicesToCheckAfterInstallation();
     $form = new InstallSettingsForm();
     list(, $form->databaseHostname, $form->databasePort, $form->databaseName) = array_values(RedBeanDatabase::getDatabaseInfoFromDsnString(Yii::app()->db->connectionString));
     $form->databaseUsername = Yii::app()->db->username;
     $form->databasePassword = Yii::app()->db->password;
     return static::processServicesAndGetResultsData($servicesToCheck, $form);
 }

 /**
  * Check whether db supports load local infile or not.
  * public due to usage in benchmarks
  * @return bool
  */
 public static function databaseSupportsLoadLocalInFile()
 {
     list($databaseType, $databaseHostname, $databasePort) = array_values(RedBeanDatabase::getDatabaseInfoFromDsnString(Yii::app()->db->connectionString));
     return InstallUtil::checkDatabaseLoadLocalInFile($databaseType, $databaseHostname, Yii::app()->db->username, Yii::app()->db->password, $databasePort);
 }