PHP CDbConnection::getDriverName方法代码示例

 /**
  * Creates the token DB table.
  * @param CDbConnection $db the database connection
  * @param string $tableName the name of the table to be created
  */
 protected function createTokenTable($db, $tableName)
 {
     $driver = $db->getDriverName();
     $file = dirname(__DIR__) . '/migrations/' . $this->tokenTableName . '.' . $db->getDriverName();
     $pdo = $this->getDbConnection()->pdoInstance;
     $sql = file_get_contents($file);
     $sql = rtrim($sql);
     $sqls = preg_replace_callback("/\\((.*)\\)/", create_function('$matches', 'return str_replace(";"," $$$ ",$matches[0]);'), $sql);
     $sqls = explode(";", $sqls);
     foreach ($sqls as $sql) {
         if (!empty($sql)) {
             $sql = str_replace(" \$\$\$ ", ";", $sql) . ";";
             $pdo->exec($sql);
         }
     }
 }

 /**
  * Creates the session DB table.
  * @param CDbConnection $db the database connection
  * @param string $tableName the name of the table to be created
  */
 protected function createSessionTable($db, $tableName)
 {
     $driver = $db->getDriverName();
     if ($driver === 'mysql') {
         $blob = 'LONGBLOB';
     } elseif ($driver === 'pgsql') {
         $blob = 'BYTEA';
     } else {
         $blob = 'BLOB';
     }
     $db->createCommand()->createTable($tableName, array('id' => 'CHAR(255) PRIMARY KEY', 'expire' => 'integer', 'user_id' => 'integer', 'data' => $blob));
 }

 /**
  * Creates the DB table for storing log messages.
  * @param CDbConnection $db the database connection
  * @param string $tableName the name of the table to be created
  */
 protected function createLogTable($db, $tableName)
 {
     $driver = $db->getDriverName();
     if ($driver === 'mysql') {
         $logID = 'id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY';
     } else {
         if ($driver === 'pgsql') {
             $logID = 'id SERIAL PRIMARY KEY';
         } else {
             $logID = 'id INTEGER NOT NULL PRIMARY KEY';
         }
     }
     $sql = "\r\nCREATE TABLE {$tableName}\r\n(\r\n\t{$logID},\r\n\tlevel VARCHAR(128),\r\n\tcategory VARCHAR(128),\r\n\tlogtime INTEGER,\r\n\tmessage TEXT\r\n)";
     $db->createCommand($sql)->execute();
 }

 /**
  * Creates the session DB table.
  * @param CDbConnection $db the database connection
  * @param string $tableName the name of the table to be created
  */
 public function createSessionTable($db, $tableName)
 {
     switch ($db->getDriverName()) {
         case 'mysql':
             $blob = 'LONGBLOB';
             break;
         case 'pgsql':
             $blob = 'BYTEA';
             break;
         case 'sqlsrv':
         case 'mssql':
         case 'dblib':
             $blob = 'VARBINARY(MAX)';
             break;
         default:
             $blob = 'BLOB';
             break;
     }
     $db->createCommand()->createTable($tableName, array('id' => 'CHAR(32) PRIMARY KEY', 'expire' => 'integer', 'data' => $blob, 'user_id' => 'integer', 'start_expire' => 'integer', 'user_agent' => 'text', 'user_type' => 'integer', 'user_avatar' => 'string', 'ip_address' => 'string', 'current_url' => 'text'));
 }

 /**
  * Sets up list of migrations.
  *
  * @return void
  * @since 0.1.0
  */
 public function setMigrations()
 {
     $path = Yii::getPathOfAlias('application.migrations');
     Yii::import('application.migrations.*');
     $files = scandir($path);
     // this was very weird, but late static binding didn't help all
     // migrations being put in the very same array
     $driverName = static::$db->getDriverName();
     static::$migrations[$driverName] = array();
     foreach ($files as $file) {
         if (preg_match('#^m\\d{6}_\\d{6}[\\w_]*\\.php$#', $file)) {
             $migrationName = substr($file, 0, strlen($file) - 4);
             /**
              * @var $migration CDbMigration
              */
             $migration = new $migrationName();
             $migration->setDbConnection(static::$db);
             $tthis = get_called_class();
             static::$migrations[$driverName][] = $migration;
         }
     }
 }

 /**
  * Creates the session DB table.
  * @param CDbConnection $db the database connection
  * @param string $tableName the name of the table to be created
  */
 protected function createSessionTable($db, $tableName)
 {
     switch ($db->getDriverName()) {
         case 'mysql':
             $blob = 'LONGBLOB';
             break;
         case 'pgsql':
             $blob = 'BYTEA';
             break;
         case 'sqlsrv':
         case 'mssql':
         case 'dblib':
             $blob = 'VARBINARY(MAX)';
             break;
         default:
             $blob = 'BLOB';
             break;
     }
     $db->createCommand()->createTable($tableName, array('id' => 'CHAR(32) PRIMARY KEY', 'expire' => 'integer', 'data' => $blob));
 }

    /**
     * Creates the cache DB table.
     * @param CDbConnection $db the database connection
     * @param string $tableName the name of the table to be created
     */
    protected function createCacheTable($db, $tableName)
    {
        $driver = $db->getDriverName();
        if ($driver === 'mysql') {
            $blob = 'LONGBLOB';
        } else {
            if ($driver === 'pgsql') {
                $blob = 'BYTEA';
            } else {
                $blob = 'BLOB';
            }
        }
        $sql = <<<EOD
CREATE TABLE {$tableName}
(
\tid CHAR(128) PRIMARY KEY,
\texpire INTEGER,
\tvalue {$blob}
)
EOD;
        $db->createCommand($sql)->execute();
    }

 /**
  * Optional settings screen
  */
 private function stepOptionalConfiguration()
 {
     $aData['clang'] = $clang = $this->lang;
     $aData['confirmation'] = Yii::app()->session['optconfig_message'];
     $aData['title'] = $clang->gT("Optional settings");
     $aData['descp'] = $clang->gT("Optional settings to give you a head start");
     $aData['classesForStep'] = array('off', 'off', 'off', 'off', 'off', 'on');
     $aData['progressValue'] = 80;
     $this->loadHelper('surveytranslator');
     $aData['model'] = $model = new InstallerConfigForm('optional');
     if (isset($_POST['InstallerConfigForm'])) {
         $model->attributes = $_POST['InstallerConfigForm'];
         //run validation, if it fails, load the view again else proceed to next step.
         if ($model->validate()) {
             $sDefaultAdminUserName = $model->adminLoginName;
             $sDefaultAdminPassword = $model->adminLoginPwd;
             $sDefaultAdminRealName = $model->adminName;
             $sDefaultSiteName = $model->siteName;
             $sDefaultSiteLanguage = $model->surveylang;
             $sDefaultAdminEmail = $model->adminEmail;
             $aData['title'] = $clang->gT("Database configuration");
             $aData['descp'] = $clang->gT("Please enter the database settings you want to use for LimeSurvey:");
             $aData['classesForStep'] = array('off', 'off', 'off', 'on', 'off', 'off');
             $aData['progressValue'] = 40;
             //config file is written, and we've a db in place
             $this->connection = Yii::app()->db;
             //checking DB Connection
             if ($this->connection->getActive() == true) {
                 $sPasswordHash = hash('sha256', $sDefaultAdminPassword);
                 try {
                     if (User::model()->count() > 0) {
                         die;
                     }
                     // Save user
                     $user = new User();
                     // Fix UserID to 1 for MySQL even if installed in master-master configuration scenario
                     if (in_array($this->connection->getDriverName(), array('mysql', 'mysqli'))) {
                         $user->uid = 1;
                     }
                     $user->users_name = $sDefaultAdminUserName;
                     $user->password = $sPasswordHash;
                     $user->full_name = $sDefaultAdminRealName;
                     $user->parent_id = 0;
                     $user->lang = $sDefaultSiteLanguage;
                     $user->email = $sDefaultAdminEmail;
                     $user->save();
                     // Save permissions
                     $permission = new Permission();
                     $permission->entity_id = 0;
                     $permission->entity = 'global';
                     $permission->uid = $user->uid;
                     $permission->permission = 'superadmin';
                     $permission->read_p = 1;
                     $permission->save();
                     // Save  global settings
                     $this->connection->createCommand()->insert("{{settings_global}}", array('stg_name' => 'SessionName', 'stg_value' => self::_getRandomString()));
                     $this->connection->createCommand()->insert("{{settings_global}}", array('stg_name' => 'sitename', 'stg_value' => $sDefaultSiteName));
                     $this->connection->createCommand()->insert("{{settings_global}}", array('stg_name' => 'siteadminname', 'stg_value' => $sDefaultAdminRealName));
                     $this->connection->createCommand()->insert("{{settings_global}}", array('stg_name' => 'siteadminemail', 'stg_value' => $sDefaultAdminEmail));
                     $this->connection->createCommand()->insert("{{settings_global}}", array('stg_name' => 'siteadminbounce', 'stg_value' => $sDefaultAdminEmail));
                     $this->connection->createCommand()->insert("{{settings_global}}", array('stg_name' => 'defaultlang', 'stg_value' => $sDefaultSiteLanguage));
                     // only continue if we're error free otherwise setup is broken.
                 } catch (Exception $e) {
                     throw new Exception(sprintf('Could not add optional settings: %s.', $e));
                 }
                 Yii::app()->session['deletedirectories'] = true;
                 $aData['title'] = $clang->gT("Success!");
                 $aData['descp'] = $clang->gT("LimeSurvey has been installed successfully.");
                 $aData['classesForStep'] = array('off', 'off', 'off', 'off', 'off', 'off');
                 $aData['progressValue'] = 100;
                 $aData['user'] = $sDefaultAdminUserName;
                 $aData['pwd'] = $sDefaultAdminPassword;
                 $this->render('/installer/success_view', $aData);
                 return;
             }
         } else {
             // if passwords don't match, redirect to proper link.
             Yii::app()->session['optconfig_message'] = sprintf('<b>%s</b>', $clang->gT("Passwords don't match."));
             $this->redirect(array('installer/optional'));
         }
     } elseif (empty(Yii::app()->session['configFileWritten'])) {
         $this->_writeConfigFile();
     }
     $this->render('/installer/optconfig_view', $aData);
 }

 public function testOdbc()
 {
     if (!extension_loaded('pdo_odbc')) {
         $this->markTestSkipped('pdo_odbc extension is required.');
     }
     $db = new CDbConnection();
     $db->connectionString = 'odbc:Driver=SQLite3;Database=:memory:';
     $db->driverName = 'sqlite';
     try {
         $this->assertEquals('odbc', $db->getAttribute(PDO::ATTR_DRIVER_NAME));
         $this->assertEquals('sqlite', $db->getDriverName());
     } catch (Exception $e) {
         $this->markTestSkipped('SQLite3 ODBC driver package must be installed in your operating system.');
     }
     $db->active = true;
     $db->pdoInstance->exec(file_get_contents(dirname(__FILE__) . '/data/sqlite.sql'));
     $command = $db->createCommand('SELECT * FROM posts');
     $this->assertTrue($command instanceof CDbCommand);
 }

 /**
  * Creates the session DB table.
  * @param CDbConnection $db the database connection
  * @param string $tableName the name of the table to be created
  */
 protected function createSessionTable($db, $tableName)
 {
     $driver = $db->getDriverName();
     if ($driver === 'mysql') {
         $blob = 'LONGBLOB';
     } else {
         if ($driver === 'pgsql') {
             $blob = 'BYTEA';
         } else {
             $blob = 'BLOB';
         }
     }
     $sql = "\nCREATE TABLE {$tableName}\n(\n\tid CHAR(32) PRIMARY KEY,\n\texpire INTEGER,\n\tdata {$blob}\n)";
     $db->createCommand($sql)->execute();
 }