PHP Pix_Table::setDefaultDb Exemples

setDefaultDb() public static méthode

setDefaultDb 指定 Pix_Table 預設的 db

public static setDefaultDb ( Pix_Table_Db $db ) : void
$db	Pix_Table_Db	用哪個 db
Résultat	void

Exemple #1

Fichier : Db.php Projet : ronnywang/pixframework

 public static function addDbFromURI($uri)
 {
     if (strpos($uri, 'mysql://') === 0) {
         if (!preg_match('#mysql://([^:]*):([^@]*)@([^/]*)/(.*)#', strval($uri), $matches)) {
             throw new Exception("wrong mysql URI format, must be mysql://{user}:{password}@{host}/{db}");
         }
         $db = new StdClass();
         $db->host = $matches[3];
         $db->username = $matches[1];
         $db->password = $matches[2];
         $db->dbname = $matches[4];
         $config = new StdClass();
         $config->master = $config->slave = $db;
         Pix_Table::setDefaultDb(new Pix_Table_Db_Adapter_MysqlConf(array($config)));
     } elseif (strpos($uri, 'pgsql://') === 0) {
         if (!preg_match('#pgsql://([^:]*):([^@]*)@([^/:]*):?([0-9]*)?/(.*)#', strval($uri), $matches)) {
             throw new Exception("wrong pgsql URI format, must be pgsql://{user}:{password}@{host}/{db}");
         }
         $options = array('host' => $matches[3], 'user' => $matches[1], 'password' => $matches[2], 'dbname' => $matches[5]);
         if ($matches[4]) {
             $options['port'] = $matches[4];
         }
         Pix_Table::setDefaultDb(new Pix_Table_Db_Adapter_PgSQL($options));
     } elseif (strpos($uri, 'sqlite://') === 0) {
         $file = substr($uri, strlen('sqlite://'));
         Pix_Table::setDefaultDb(new Pix_Table_Db_Adapter_Sqlite($file));
     } else {
         throw new Exception("add DB failed, unknown uri {$uri}");
     }
 }

Exemple #2

Fichier : TableTest.php Projet : ronnywang/itunes-taiwan-update

 /**
  * 測試 getDb , 如果 Table 有指定應該要傳回 Table 指定的，沒有就是 default
  */
 public function testGetDb()
 {
     $db = $this->getMock('Pix_Table_Db_Adapter_Abstract');
     Pix_Table::setDefaultDb($db);
     $this->assertEquals(Pix_Table::getTable('Pix_Table_TableTest_Table2')->getDb(), $db);
 }

Exemple #3

Fichier : init.inc.php Projet : yslbc/twcompany

<?php

error_reporting(E_ALL ^ E_STRICT ^ E_NOTICE);
include __DIR__ . '/stdlibs/pixframework/Pix/Loader.php';
set_include_path(__DIR__ . '/stdlibs/pixframework/' . PATH_SEPARATOR . __DIR__ . '/models' . PATH_SEPARATOR . __DIR__ . '/Dropbox-master');
Pix_Loader::registerAutoLoad();
if (file_exists(__DIR__ . '/config.php')) {
    include __DIR__ . '/config.php';
}
// TODO: 之後要搭配 geoip
date_default_timezone_set('Asia/Taipei');
if (!getenv('MYSQL_DATABASE_URL')) {
    die('need MYSQL_DATABASE_URL');
}
if (!preg_match('#mysql://([^:]*):([^@]*)@([^/]*)/(.*)#', strval(getenv('MYSQL_DATABASE_URL')), $matches)) {
    die('mysql only');
}
$db = new StdClass();
$db->host = $matches[3];
$db->username = $matches[1];
$db->password = $matches[2];
$db->dbname = $matches[4];
$config = new StdClass();
$config->master = $config->slave = $db;
Pix_Table::setDefaultDb(new Pix_Table_Db_Adapter_MysqlConf(array($config)));

Exemple #4

Fichier : init.inc.php Projet : ronnywang/itunes-taiwan-update

<?php

include __DIR__ . '/libs/pixframework/Pix/Loader.php';
set_include_path(__DIR__ . '/libs/pixframework' . PATH_SEPARATOR . __DIR__ . '/models');
Pix_Loader::registerAutoload();
if (file_exists(__DIR__ . '/config.php')) {
    include __DIR__ . '/config.php';
} else {
    if (getenv('DATABASE_URL')) {
        if (preg_match('#postgres://([^:]*):([^@]*)@([^/]*)/(.*)#', strval(getenv('DATABASE_URL')), $matches)) {
            $user = $matches[1];
            $pass = $matches[2];
            $host = $matches[3];
            $dbname = $matches[4];
            Pix_Table::setDefaultDb(new Pix_Table_Db_Adapter_PgSQL(array('user' => $user, 'password' => $pass, 'host' => $host, 'dbname' => $dbname)));
        }
    }
}
date_default_timezone_set('Asia/Taipei');

Exemple #5

Fichier : example1.php Projet : yslbc/twcompany

<?php

// init: 要自動載入 Pix Framework
include __DIR__ . '/../../Pix/Loader.php';
set_include_path(__DIR__ . '/../../' . PATH_SEPARATOR . __DIR__ . '/models');
Pix_Loader::registerAutoload();
// 預設所有 Db 都是 sqlite
Pix_Table::setDefaultDb(new Pix_Table_Db_Adapter_Sqlite(':memory:'));
// 顯示 SQL query
Pix_Table::enableLog(Pix_Table::LOG_QUERY);
echo 'create table' . PHP_EOL;
User::createTable();
Article::createTable();
echo '增加 user alice' . PHP_EOL;
$user_alice = User::insert(array('name' => 'alice', 'password' => crc32('foo')));
echo '新增一篇文章' . PHP_EOL;
$article = $user_alice->create_articles(array('post_at' => time(), 'title' => '我是標題', 'body' => '我是內容'));