PHP CDbConnection::setActive方法代码示例

 public function openConnection()
 {
     $dsn = "mysql:host={$this->host};port={$this->port};";
     $this->db = new CDbConnection($dsn);
     $this->db->setAttribute(PDO::ATTR_TIMEOUT, $this->connectionTimeout);
     $this->db->setActive(true);
 }

 /**
  * Open Sphinx persistent connection.
  *
  * @throws ESphinxException if client is already connected.
  * @throws ESphinxException if client has connection error.
  * @link http://sphinxsearch.com/docs/current.html#api-func-open
  */
 public function openConnection()
 {
     $dsn = "mysql:host={$this->server};port={$this->port};";
     $this->db = new ESphinxQlDbConnection($dsn);
     $this->db->setAttribute(PDO::ATTR_TIMEOUT, $this->connectionTimeout);
     $this->db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
     $this->db->setActive(true);
 }

 public function fork()
 {
     $this->b2b_DbConnection->setActive(false);
     $this->oneC_DbConnection->setActive(false);
     $pid = pcntl_fork();
     $this->b2b_DbConnection->setActive(true);
     $this->oneC_DbConnection->setActive(true);
     return $pid;
 }

 /**
  * 打开或关闭数据库连接
  *
  * @param boolean $value whether to open or close DB connection
  * @throws CException if connection fails
  */
 public function setActive($value)
 {
     if ($value != $this->getActive() && $value) {
         $this->setAttribute(PDO::ATTR_TIMEOUT, $this->timeout);
     }
     parent::setActive($value);
 }

 /**
  * Constructor.
  * @param CDbConnection $conn database connection.
  */
 public function __construct($conn)
 {
     $conn->setActive(true);
     $this->_connection = $conn;
     foreach ($conn->schemaCachingExclude as $name) {
         $this->_cacheExclude[$name] = true;
     }
 }

 public function setupDB()
 {
     $dump_file = dirname(Yii::app()->request->scriptFile) . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . 'install' . DIRECTORY_SEPARATOR . 'db.sql';
     if (!file_exists($dump_file)) {
         return array('error' => 'Dump file was not found');
     }
     $connection = new CDbConnection('mysql:host=' . $this->host . ';port=' . $this->port, $this->user, $this->password);
     $connection->setActive(true);
     $sql = "DROP DATABASE IF EXISTS `{$this->dbname}`; CREATE DATABASE `{$this->dbname}` CHARACTER SET utf8 COLLATE utf8_general_ci;";
     $connection->createCommand($sql)->query();
     $connection->setActive(false);
     $connection = null;
     $connection = new CDbConnection('mysql:host=' . $this->host . ';port=' . $this->port . ';dbname=' . $this->dbname, $this->user, $this->password);
     $sql = file_get_contents($dump_file);
     $connection->createCommand($sql)->query();
     $this->saveDBInstallStatusConfig(1);
     return array('ok' => 1);
 }

 public function install()
 {
     # Does the application need installing? Check if database exists, and can connect
     try {
         # Required fields
         $required = array("db-host", "db-name", "db-username", "db-password", "table-prefix");
         # Did all the required fields get passed in?
         if (count(array_intersect($required, array_keys($_REQUEST))) != count($required)) {
             throw new Exception("Not all required fields were submitted.");
         }
         # Verify the required unempty fields
         foreach ($required as $field) {
             # Skip the fields that can be empty
             if ($field == "table-prefix" or $field == "db-password") {
                 continue;
             }
             # Check if empty, throw error if they are.
             if (empty($_REQUEST[$field])) {
                 throw new Exception("Field <i>" . lookupfieldname($field) . "</i> cannot be empty.");
             }
         }
         # Try connecting to the database with the passed in credentials
         try {
             # Setup connection details
             $dsn = 'mysql:host=' . $_REQUEST["db-host"] . ';dbname=' . $_REQUEST["db-name"];
             $username = $_REQUEST["db-username"];
             $password = $_REQUEST["db-password"];
             $prefix = $_REQUEST["table-prefix"];
             # Make the connection
             $conn = new CDbConnection($dsn, $username, $password);
             $conn->active = true;
             $conn->setActive(true);
         } catch (Exception $e) {
             throw new Exception("Could not connect to database. Make sure you have created the database first. Details: " . $e->getMessage());
         }
         # Setup the database params for saving in the extended configuration
         $db_params = array('components' => array('db' => array('connectionString' => $dsn, 'emulatePrepare' => true, 'username' => $username, 'password' => $password, 'charset' => 'utf8', 'tablePrefix' => $prefix)), 'params' => array('LOCALAPP_SERVER' => $_SERVER["HTTP_HOST"]));
         # Make sure to only overwrite if explicitly asked to
         $config_ext = Yii::app()->basePath . "\\config\\main-ext.php";
         if (is_file($config_ext)) {
             throw new Exception("Database configuration already exists. Delete this configuration in order to install this application.");
         }
         # Open up the file and write the new configuration.
         $handle = fopen($config_ext, "w");
         fwrite($handle, "<?php return ");
         fwrite($handle, var_export($db_params, true));
         fwrite($handle, "; ?>");
         fclose($handle);
         # Make read-only
         chmod($config_ext, 060);
     } catch (Exception $e) {
         $this->set_error($e->getMessage());
         return false;
     }
     # If we made it to here, installation is a success!
     return true;
 }

 /**
  * Validator for connection to MySQL
  * @return bool     Whether or not we could connect to MySQL
  */
 public function validateConnection()
 {
     // Make sure all fields are provided
     if ($this->validate()) {
         // Just turning the connection on and off. A CDbException will be thrown if something goes wrong
         try {
             $connection = new CDbConnection("mysql:host={$this->host};dbname={$this->dbname}", $this->username, $this->password);
             $connection->setActive(true);
             $connection->setActive(false);
             $this->dsn = $connection->connectionString;
             return true;
         } catch (Exception $e) {
             // Add errors to all fields for the visual indicator
             $this->addError('username', '');
             $this->addError('password', '');
             $this->addError('dbname', '');
             $this->addError('host', '');
             $this->addError('dsn', Yii::t('Install.main', 'Unable to connect to database using the provided credentials.'));
             return false;
         }
     }
     $this->addError('dsn', Yii::t('Install.main', 'Unable to connect to database using the provided credentials.'));
     return false;
 }

 public function checkUser()
 {
     if ($this->hasErrors('db_exp_sql_host') || $this->hasErrors('db_exp_sql_dbname') || $this->hasErrors('db_exp_sql_login') || $this->hasErrors('db_exp_sql_password') || $this->hasErrors('db_exp_sql_port')) {
         return false;
     }
     try {
         $connection = new CDbConnection('mysql:host=' . $this->db_exp_sql_host, $this->db_exp_sql_login, $this->db_exp_sql_password);
         $res = $connection->setActive(true);
         $sql = "CREATE DATABASE IF NOT EXISTS `{$this->db_exp_sql_dbname}` CHARACTER SET UTF8";
         $res = $connection->createCommand($sql)->query();
     } catch (CDbException $e) {
         $this->addError('db_exp_sql_login', $e->getMessage());
         return false;
     }
     return true;
 }

 public function setActive($value)
 {
     if ($value && $this->autoReconnect) {
         $lifetime = time() - $this->_lastActive;
         if ($lifetime > intval($this->autoReconnect)) {
             try {
                 if ($this->getActive()) {
                     @$this->getPdoInstance()->query('SELECT 1');
                 }
             } catch (Exception $e) {
                 Yii::trace($e->getMessage() . " Last connection's lifetime: {$lifetime}, trying to close and reconnect... ", 'components.DbConnection.setActive');
                 parent::setActive(false);
             }
         }
     }
     parent::setActive($value);
     $this->_lastActive = time();
 }

 /**
  * This is our overloaded getDbConnection, allowing us to tell yii what our db connection is
  * without it having to go through
  */
 public function getDbConnection()
 {
     $connection = new CDbConnection("mysql:host={$this->dsn['host']};dbname={$this->dsn['dbname']}", $this->dsn['username'], $this->dsn['password']);
     $connection->setActive(true);
     return $connection;
 }

 public function checkUser()
 {
     if ($this->hasErrors('host') || $this->hasErrors('user') || $this->hasErrors('password') || $this->hasErrors('port')) {
         return false;
     }
     try {
         $connection = new CDbConnection('mysql:host=' . $this->host, $this->user, $this->password);
         $connection->setActive(true);
         $sql = "DROP DATABASE IF EXISTS `{$this->dbname}`;";
         $connection->createCommand($sql)->query();
         $sql = "CREATE DATABASE `{$this->dbname}` CHARACTER SET utf8 COLLATE utf8_general_ci;";
         $connection->createCommand($sql)->query();
     } catch (CDbException $e) {
         $this->addError('user', $e->getMessage());
         return false;
     }
     return true;
 }

    }
    foreach ($fieldmap as $k => $v) {
        $value = addslashes($_POST[$k]);
        fwrite($fh, "define('{$v[0]}', \"{$value}\");\n");
    }
    fwrite($fh, "define('DB_VERSION', " . DB_VERSION . ");\n");
    fclose($fh);
    header('location: setup.php?a=config');
    return;
}
if (field_value('yii', false) && file_exists($yii = field_value('yii', false))) {
    require_once $yii;
    try {
        $db = new CDbConnection(field_value('dsn', false), field_value('user', false), field_value('password', false));
        $db->tablePrefix = field_value('prefix');
        $db->setActive(true);
        $db_ok = true;
        $curr_db_ver = filemtime(dirname(__FILE__) . '/protected/data/CurrentDbScheme.php');
        $db_new = DB_VERSION >= $curr_db_ver;
    } catch (CException $e) {
        $db_ok = false;
        $db_new = false;
        $err_msg = $e->getMessage();
    }
} else {
    $err_msg = 'Path to yii ("' . field_value('yii') . '") not found';
}
if (isset($_GET['a'])) {
    $page_act = $_GET['a'];
} else {
    $page_act = 'config';

 /**
  * This method will save the admin user into the database,
  */
 public function save()
 {
     if (!$this->validateForm()) {
         return false;
     }
     try {
         // Store some data in session temporarily
         Yii::app()->session['encryptionKey'] = $this->encryptionKey;
         Yii::app()->session['siteName'] = $this->siteName;
         Yii::app()->session['primaryEmail'] = $this->email;
         // Try to save the record into the database
         $connection = new CDbConnection(Yii::app()->session['dsn']['dsn'], Yii::app()->session['dsn']['username'], Yii::app()->session['dsn']['password']);
         $connection->setActive(true);
         $connection->createCommand('INSERT INTO users (id, email, password, firstName, lastName, displayName, user_role, status, created, updated) VALUES (1, :email, :password, :firstName, :lastName, :displayName, 9, 1, UTC_TIMESTAMP(), UTC_TIMESTAMP())')->bindParam(':email', $this->email)->bindParam(':password', $this->encryptedPassword)->bindParam(':firstName', $this->firstName)->bindParam(':lastName', $this->lastName)->bindParam(':displayName', $this->displayName)->execute();
         return true;
     } catch (CDbException $e) {
         $this->addError('password', Yii::t('Install.main', 'There was an error saving your details to the database.'));
         return false;
     }
     return false;
 }

 /**
  * Init connection with backup database
  */
 private function initDbConnection()
 {
     It::debug("try to init DB connection (0)", 'backup_database');
     try {
         It::debug("try to init DB connection (1)", 'backup_database');
         // check if (remote) host is reachable
         $fp = @fsockopen($this->settings->db_exp_sql_host, $this->settings->db_exp_sql_port);
         if ($fp === false) {
             throw new Exception("Host " . $this->settings->db_exp_sql_host . ':' . $this->settings->db_exp_sql_port . ' is unreachable');
         }
         // create connection with database
         $dsn = 'mysql:host=' . $this->settings->db_exp_sql_host . ';port=' . $this->settings->db_exp_sql_port . ';dbname=' . $this->settings->db_exp_sql_dbname;
         $connection = new CDbConnection($dsn, $this->settings->db_exp_sql_login, $this->settings->db_exp_sql_password);
         It::debug("try to init DB connection (2)", 'backup_database');
         try {
             It::debug("try to init DB connection (3)", 'backup_database');
             $res = $connection->setActive(true);
             It::debug("try to init DB connection (4)", 'backup_database');
             $this->db_conn = $connection;
             It::debug("try to init DB connection (5)", 'backup_database');
         } catch (PDOException $e) {
             It::debug("try to init DB connection (6)", 'backup_database');
             throw new Exception($e->getMessage());
         }
         It::debug("try to init DB connection (7)", 'backup_database');
     } catch (CDbException $e) {
         It::debug("try to init DB connection (8)", 'backup_database');
         throw new Exception($e->getMessage());
     }
     It::debug("try to init DB connection (DONE)", 'backup_database');
 }