Taufan Aditya | 655a89f | 2012-03-29 03:00:56 +0700 | [diff] [blame] | 1 | <?php |
| 2 | |
| 3 | class Mock_Database_DB { |
| 4 | |
Taufan Aditya | ee2f5d0 | 2012-03-30 06:29:11 +0700 | [diff] [blame] | 5 | /** |
| 6 | * @var array DB configuration |
| 7 | */ |
Taufan Aditya | 655a89f | 2012-03-29 03:00:56 +0700 | [diff] [blame] | 8 | private $config = array(); |
| 9 | |
| 10 | /** |
| 11 | * Prepare database configuration skeleton |
| 12 | * |
| 13 | * @param array DB configuration to set |
| 14 | * @return void |
| 15 | */ |
| 16 | public function __construct($config = array()) |
| 17 | { |
Taufan Aditya | 655a89f | 2012-03-29 03:00:56 +0700 | [diff] [blame] | 18 | $this->config = $config; |
| 19 | } |
| 20 | |
Taufan Aditya | ee2f5d0 | 2012-03-30 06:29:11 +0700 | [diff] [blame] | 21 | /** |
| 22 | * Build DSN connection string for DB driver instantiate process |
| 23 | * |
| 24 | * @param string Group name |
| 25 | * @return string DSN Connection string |
| 26 | */ |
Taufan Aditya | a8a2e33 | 2012-03-29 03:56:46 +0700 | [diff] [blame] | 27 | public function set_dsn($group = 'default') |
Taufan Aditya | 655a89f | 2012-03-29 03:00:56 +0700 | [diff] [blame] | 28 | { |
| 29 | if ( ! isset($this->config[$group])) |
| 30 | { |
| 31 | throw new InvalidArgumentException('Group '.$group.' not exists'); |
| 32 | } |
| 33 | |
Taufan Aditya | a8a2e33 | 2012-03-29 03:56:46 +0700 | [diff] [blame] | 34 | $params = array( |
| 35 | 'dbprefix' => '', |
| 36 | 'pconnect' => FALSE, |
Taufan Aditya | ee2f5d0 | 2012-03-30 06:29:11 +0700 | [diff] [blame] | 37 | 'db_debug' => FALSE, |
Taufan Aditya | a8a2e33 | 2012-03-29 03:56:46 +0700 | [diff] [blame] | 38 | 'cache_on' => FALSE, |
| 39 | 'cachedir' => '', |
| 40 | 'char_set' => 'utf8', |
| 41 | 'dbcollat' => 'utf8_general_ci', |
| 42 | 'swap_pre' => '', |
| 43 | 'autoinit' => TRUE, |
| 44 | 'stricton' => FALSE, |
Taufan Aditya | a8a2e33 | 2012-03-29 03:56:46 +0700 | [diff] [blame] | 45 | ); |
| 46 | |
| 47 | $config = array_merge($this->config[$group], $params); |
Taufan Aditya | 1972514 | 2012-04-04 23:46:23 +0700 | [diff] [blame] | 48 | $dsnstring = ( ! empty($config['dsn'])) ? $config['dsn'] : FALSE; |
Taufan Aditya | f4c6c9b | 2012-04-04 23:24:09 +0700 | [diff] [blame] | 49 | $pdodriver = ( ! empty($config['pdodriver'])) ? $config['pdodriver'] : FALSE; |
| 50 | $failover = ( ! empty($config['failover'])) ? $config['failover'] : FALSE; |
Taufan Aditya | a8a2e33 | 2012-03-29 03:56:46 +0700 | [diff] [blame] | 51 | |
Taufan Aditya | 1972514 | 2012-04-04 23:46:23 +0700 | [diff] [blame] | 52 | $dsn = $config['dbdriver'].'://'.$config['username'].':'.$config['password'] |
Taufan Aditya | 655a89f | 2012-03-29 03:00:56 +0700 | [diff] [blame] | 53 | .'@'.$config['hostname'].'/'.$config['database']; |
| 54 | |
Taufan Aditya | f4c6c9b | 2012-04-04 23:24:09 +0700 | [diff] [blame] | 55 | // Build the parameter |
Taufan Aditya | a8a2e33 | 2012-03-29 03:56:46 +0700 | [diff] [blame] | 56 | $other_params = array_slice($config, 6); |
Taufan Aditya | 1972514 | 2012-04-04 23:46:23 +0700 | [diff] [blame] | 57 | if ($dsnstring) $other_params['dsn'] = $dsnstring; |
Taufan Aditya | f4c6c9b | 2012-04-04 23:24:09 +0700 | [diff] [blame] | 58 | if ($pdodriver) $other_params['pdodriver'] = $pdodriver; |
| 59 | if ($failover) $other_params['failover'] = $failover; |
Taufan Aditya | 655a89f | 2012-03-29 03:00:56 +0700 | [diff] [blame] | 60 | |
Taufan Aditya | ee2f5d0 | 2012-03-30 06:29:11 +0700 | [diff] [blame] | 61 | return $dsn.'?'.http_build_query($other_params); |
Taufan Aditya | a8a2e33 | 2012-03-29 03:56:46 +0700 | [diff] [blame] | 62 | } |
| 63 | |
Taufan Aditya | ee2f5d0 | 2012-03-30 06:29:11 +0700 | [diff] [blame] | 64 | /** |
| 65 | * Return a database config array |
| 66 | * |
| 67 | * @see ./config |
| 68 | * @param string Driver based configuration |
| 69 | * @return array |
| 70 | */ |
| 71 | public static function config($driver) |
| 72 | { |
| 73 | $dir = realpath(dirname(__FILE__)).DIRECTORY_SEPARATOR; |
| 74 | |
| 75 | return include($dir.'config'.DIRECTORY_SEPARATOR.$driver.'.php'); |
| 76 | } |
| 77 | |
| 78 | /** |
| 79 | * Main DB method wrapper |
| 80 | * |
| 81 | * @param string Group or DSN string |
| 82 | * @param bool |
| 83 | * @return object |
| 84 | */ |
Taufan Aditya | a8a2e33 | 2012-03-29 03:56:46 +0700 | [diff] [blame] | 85 | public static function DB($group, $query_builder = FALSE) |
| 86 | { |
| 87 | include_once(BASEPATH.'database/DB.php'); |
| 88 | |
| 89 | try |
| 90 | { |
| 91 | $db = DB($group, $query_builder); |
| 92 | } |
| 93 | catch (Exception $e) |
| 94 | { |
| 95 | throw new InvalidArgumentException($e->getMessage()); |
| 96 | } |
| 97 | |
| 98 | return $db; |
Taufan Aditya | 655a89f | 2012-03-29 03:00:56 +0700 | [diff] [blame] | 99 | } |
| 100 | } |