PHP CActiveRecord::db方法代码示例

 public function setUp()
 {
     if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) {
         $this->markTestSkipped('PDO and PostgreSQL extensions are required.');
     }
     $this->db = new CDbConnection('pgsql:host=127.0.0.1;dbname=yii', 'test', 'test');
     try {
         $this->db->active = true;
     } catch (Exception $e) {
         $schemaFile = realpath(dirname(__FILE__) . '/../data/postgres.sql');
         $this->markTestSkipped("Please read {$schemaFile} for details on setting up the test environment for PostgreSQL test case.");
     }
     try {
         $this->db->createCommand('DROP SCHEMA test CASCADE')->execute();
     } catch (Exception $e) {
     }
     try {
         $this->db->createCommand('DROP TABLE yii_types CASCADE')->execute();
     } catch (Exception $e) {
     }
     $sqls = file_get_contents(dirname(__FILE__) . '/../data/postgres.sql');
     foreach (explode(';', $sqls) as $sql) {
         if (trim($sql) !== '') {
             $this->db->createCommand($sql)->execute();
         }
     }
     $this->db->active = false;
     $config = array('basePath' => dirname(__FILE__), 'components' => array('db' => array('class' => 'system.db.CDbConnection', 'connectionString' => 'pgsql:host=127.0.0.1;dbname=yii', 'username' => 'test', 'password' => 'test')));
     $app = new TestApplication($config);
     $app->db->active = true;
     CActiveRecord::$db = $this->db = $app->db;
 }

 public function setUp()
 {
     $this->getFixtureManager()->resetTable('order');
     $this->getFixtureManager()->loadFixture('order');
     CActiveRecord::$db = $this->db = Yii::app()->db;
     parent::setUp();
 }

 /**
  * set up environment with yii application and migrate up db
  */
 public function setUp()
 {
     $basePath = dirname(__FILE__) . '/tmp';
     if (!file_exists($basePath)) {
         mkdir($basePath, 0777, true);
     }
     if (!file_exists($basePath . '/runtime')) {
         mkdir($basePath . '/runtime', 0777, true);
     }
     // create webapp
     if (\Yii::app() === null) {
         \Yii::createWebApplication(array('basePath' => $basePath));
     }
     \CActiveRecord::$db = null;
     if (!isset($_ENV['DB']) || $_ENV['DB'] == 'sqlite') {
         if (!$this->dbFile) {
             $this->dbFile = $basePath . '/test.' . uniqid(time()) . '.db';
         }
         \Yii::app()->setComponent('db', new \CDbConnection('sqlite:' . $this->dbFile));
     } elseif ($_ENV['DB'] == 'mysql') {
         \Yii::app()->setComponent('db', new \CDbConnection('mysql:dbname=test;host=localhost', 'root'));
     } elseif ($_ENV['DB'] == 'pgsql') {
         \Yii::app()->setComponent('db', new \CDbConnection('pqsql:dbname=test;host=localhost', 'postgres'));
     } else {
         throw new \Exception('Unknown db. Only sqlite, mysql and pgsql are valid.');
     }
     // create db
     $this->migration = new EActiveRecordRelationBehaviorTestMigration();
     $this->migration->dbConnection = \Yii::app()->db;
     $this->migration->up();
 }

 protected function setUp()
 {
     if (!extension_loaded('pdo') || !extension_loaded('pdo_sqlite')) {
         $this->markTestSkipped('PDO and SQLite extensions are required.');
     }
     $this->_connection = new CDbConnection('sqlite::memory:');
     $this->_connection->active = true;
     $this->_connection->pdoInstance->exec(file_get_contents(dirname(__FILE__) . '/../fixtures/data/sqlite.sql'));
     CActiveRecord::$db = $this->_connection;
 }

 public function setUp()
 {
     if (!extension_loaded('pdo') || !extension_loaded('pdo_sqlite')) {
         $this->markTestSkipped('PDO and SQLite extensions are required.');
     }
     $this->db = new CDbConnection('sqlite::memory:');
     $this->db->active = true;
     $this->db->pdoInstance->exec(file_get_contents(dirname(__FILE__) . '/CSortTest.sql'));
     CActiveRecord::$db = $this->db;
 }

 public function setUp()
 {
     if (!extension_loaded('pdo') || !extension_loaded('pdo_sqlite')) {
         $this->markTestSkipped('PDO and SQLite extensions are required.');
     }
     copy(SRC_DB_FILE, TEST_DB_FILE);
     $config = array('basePath' => dirname(__FILE__), 'components' => array('db' => array('class' => 'system.db.CDbConnection', 'connectionString' => 'sqlite:' . TEST_DB_FILE)));
     $app = new TestApplication($config);
     $app->db->active = true;
     CActiveRecord::$db = $this->db = $app->db;
 }

 protected function setUp()
 {
     if (!extension_loaded('pdo') || !extension_loaded('pdo_sqlite')) {
         $this->markTestSkipped('PDO and SQLite extensions are required.');
     }
     $this->_connection = new CDbConnection('sqlite::memory:');
     $this->_connection->active = true;
     $columns = array('id' => 'pk', 'name' => 'string');
     $this->_connection->createCommand()->createTable($this->_tableName, $columns);
     CActiveRecord::$db = $this->_connection;
     $this->declareArModelClass();
 }

 public function setup()
 {
     define('YII_DEBUG', false);
     $basePath = dirname(dirname(dirname(dirname(__DIR__))));
     // go 4 up
     require $basePath . '/vendor/yiisoft/yii/framework/yii.php';
     require_once "{$basePath}/app/classes/model/yii1/Comment.php";
     require_once "{$basePath}/app/classes/model/yii1/Post.php";
     $dbConfig = DbConfig::get_params();
     $db = new CDbConnection("mysql:host={$dbConfig['host']};dbname={$dbConfig['dbname']};charset=utf8", $dbConfig['username'], $dbConfig['password']);
     CActiveRecord::$db = $db;
 }

 public function setUp()
 {
     if (!extension_loaded('pdo') || !extension_loaded('pdo_sqlite')) {
         $this->markTestSkipped('PDO and SQLite extensions are required.');
     }
     $this->_connection = new CDbConnection('sqlite::memory:');
     $this->_connection->active = true;
     $this->_connection->pdoInstance->exec(file_get_contents(dirname(__FILE__) . '/../data/sqlite.sql'));
     CActiveRecord::$db = $this->_connection;
     UserWithWrappers::clearCounters();
     PostWithWrappers::clearCounters();
     CommentWithWrappers::clearCounters();
 }

    public function setUp()
    {
        if (self::DB_DSN_PREFIX == 'sqlsrv' && (!extension_loaded('pdo') || !extension_loaded('sqlsrv') || !extension_loaded('pdo_sqlsrv'))) {
            $this->markTestSkipped('PDO and SQLSRV extensions are required.');
        } else {
            if (self::DB_DSN_PREFIX != 'sqlsrv' && (!extension_loaded('pdo') || !extension_loaded('pdo_dblib'))) {
                $this->markTestSkipped('PDO and MSSQL extensions are required.');
            }
        }
        if (self::DB_DSN_PREFIX == 'sqlsrv') {
            $dsn = self::DB_DSN_PREFIX . ':Server=' . self::DB_HOST . ';Database=' . self::DB_NAME;
        } else {
            $dsn = self::DB_DSN_PREFIX . ':host=' . self::DB_HOST . ';dbname=' . self::DB_NAME;
        }
        $this->db = new CDbConnection($dsn, self::DB_USER, self::DB_PASS);
        if (self::DB_DSN_PREFIX == 'sqlsrv') {
            $this->db->setAttribute(PDO::SQLSRV_ATTR_ENCODING, PDO::SQLSRV_ENCODING_SYSTEM);
        }
        try {
            $this->db->active = true;
        } catch (Exception $e) {
            $schemaFile = realpath(dirname(__FILE__) . '/../data/mssql.sql');
            $this->markTestSkipped("Please read {$schemaFile} for details on setting up the test environment for MSSQL test case.");
        }
        $tables = array('comments', 'post_category', 'posts', 'categories', 'profiles', 'users', 'items', 'orders', 'types');
        foreach ($tables as $table) {
            $sql = <<<EOD
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[{$table}]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[{$table}]
EOD;
            $this->db->createCommand($sql)->execute();
        }
        $rawSqls = file_get_contents(dirname(__FILE__) . '/../data/mssql.sql');
        // remove comments from SQL
        $sqls = '';
        foreach (array_filter(explode("\n", $rawSqls)) as $line) {
            if (substr($line, 0, 2) == '--') {
                continue;
            }
            $sqls .= $line . "\n";
        }
        // run SQL
        foreach (explode('GO', $sqls) as $sql) {
            if (trim($sql) !== '') {
                $this->db->createCommand($sql)->execute();
            }
        }
        CActiveRecord::$db = $this->db;
    }

 /**
  * set up environment with yii application and migrate up db
  */
 public function setUp()
 {
     $basePath = dirname(__FILE__) . '/tmp';
     if (!file_exists($basePath)) {
         mkdir($basePath, 0777, true);
     }
     if (!file_exists($basePath . '/runtime')) {
         mkdir($basePath . '/runtime', 0777, true);
     }
     if (!$this->db) {
         $this->db = $basePath . '/test.' . uniqid(time()) . '.db';
     }
     // create webapp
     if (\Yii::app() === null) {
         \Yii::createWebApplication(array('basePath' => $basePath));
     }
     \CActiveRecord::$db = null;
     \Yii::app()->setComponent('db', new \CDbConnection('sqlite:' . $this->db));
     // create db
     $this->migration = new EActiveRecordRelationBehaviorTestMigration();
     $this->migration->dbConnection = \Yii::app()->db;
     $this->migration->up();
 }

 public function getDbConnection()
 {
     if (self::$db !== null) {
         return self::$db;
     } else {
         self::$db = Yii::app()->getDb();
         if (self::$db instanceof CDbConnection) {
             return self::$db;
         } else {
             throw new CDbException(Yii::t('yii', 'Active Record requires a "db" CDbConnection application component.'));
         }
     }
 }