diff options
Diffstat (limited to 'tests/mocks/database')
| -rwxr-xr-x | tests/mocks/database/ci_test.sqlite | bin | 19456 -> 0 bytes | |||
| -rw-r--r-- | tests/mocks/database/config/mysql.php | 34 | ||||
| -rw-r--r-- | tests/mocks/database/config/mysqli.php | 34 | ||||
| -rw-r--r-- | tests/mocks/database/config/pdo/mysql.php | 37 | ||||
| -rw-r--r-- | tests/mocks/database/config/pdo/pgsql.php | 37 | ||||
| -rw-r--r-- | tests/mocks/database/config/pdo/sqlite.php | 37 | ||||
| -rw-r--r-- | tests/mocks/database/config/pgsql.php | 34 | ||||
| -rw-r--r-- | tests/mocks/database/config/sqlite.php | 34 | ||||
| -rw-r--r-- | tests/mocks/database/db.php | 142 | ||||
| -rw-r--r-- | tests/mocks/database/db/driver.php | 40 | ||||
| -rw-r--r-- | tests/mocks/database/drivers/mysql.php | 16 | ||||
| -rw-r--r-- | tests/mocks/database/drivers/mysqli.php | 16 | ||||
| -rw-r--r-- | tests/mocks/database/drivers/pdo.php | 15 | ||||
| -rw-r--r-- | tests/mocks/database/drivers/postgre.php | 16 | ||||
| -rw-r--r-- | tests/mocks/database/drivers/sqlite.php | 16 | ||||
| -rw-r--r-- | tests/mocks/database/schema/skeleton.php | 155 |
16 files changed, 0 insertions, 663 deletions
diff --git a/tests/mocks/database/ci_test.sqlite b/tests/mocks/database/ci_test.sqlite Binary files differdeleted file mode 100755 index 574d3ae53..000000000 --- a/tests/mocks/database/ci_test.sqlite +++ /dev/null diff --git a/tests/mocks/database/config/mysql.php b/tests/mocks/database/config/mysql.php deleted file mode 100644 index a590b9f53..000000000 --- a/tests/mocks/database/config/mysql.php +++ /dev/null @@ -1,34 +0,0 @@ -<?php - -return array( - - // Typical Database configuration - 'mysql' => array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'travis', - 'password' => '', - 'database' => 'ci_test', - 'dbdriver' => 'mysql' - ), - - // Database configuration with failover - 'mysql_failover' => array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'not_travis', - 'password' => 'wrong password', - 'database' => 'not_ci_test', - 'dbdriver' => 'mysql', - 'failover' => array( - array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'travis', - 'password' => '', - 'database' => 'ci_test', - 'dbdriver' => 'mysql', - ) - ) - ) -);
\ No newline at end of file diff --git a/tests/mocks/database/config/mysqli.php b/tests/mocks/database/config/mysqli.php deleted file mode 100644 index 5dd08abb2..000000000 --- a/tests/mocks/database/config/mysqli.php +++ /dev/null @@ -1,34 +0,0 @@ -<?php - -return array( - - // Typical Database configuration - 'mysqli' => array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'travis', - 'password' => '', - 'database' => 'ci_test', - 'dbdriver' => 'mysqli' - ), - - // Database configuration with failover - 'mysqli_failover' => array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'not_travis', - 'password' => 'wrong password', - 'database' => 'not_ci_test', - 'dbdriver' => 'mysqli', - 'failover' => array( - array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'travis', - 'password' => '', - 'database' => 'ci_test', - 'dbdriver' => 'mysqli', - ) - ) - ) -);
\ No newline at end of file diff --git a/tests/mocks/database/config/pdo/mysql.php b/tests/mocks/database/config/pdo/mysql.php deleted file mode 100644 index 96608f787..000000000 --- a/tests/mocks/database/config/pdo/mysql.php +++ /dev/null @@ -1,37 +0,0 @@ -<?php - -return array( - - // Typical Database configuration - 'pdo/mysql' => array( - 'dsn' => 'mysql:host=localhost;dbname=ci_test', - 'hostname' => 'localhost', - 'username' => 'travis', - 'password' => '', - 'database' => 'ci_test', - 'dbdriver' => 'pdo', - 'subdriver' => 'mysql' - ), - - // Database configuration with failover - 'pdo/mysql_failover' => array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'not_travis', - 'password' => 'wrong password', - 'database' => 'not_ci_test', - 'dbdriver' => 'pdo', - 'subdriver' => 'mysql', - 'failover' => array( - array( - 'dsn' => 'mysql:host=localhost;dbname=ci_test', - 'hostname' => 'localhost', - 'username' => 'travis', - 'password' => '', - 'database' => 'ci_test', - 'dbdriver' => 'pdo', - 'subdriver' => 'mysql' - ) - ) - ) -);
\ No newline at end of file diff --git a/tests/mocks/database/config/pdo/pgsql.php b/tests/mocks/database/config/pdo/pgsql.php deleted file mode 100644 index e55e3ea77..000000000 --- a/tests/mocks/database/config/pdo/pgsql.php +++ /dev/null @@ -1,37 +0,0 @@ -<?php - -return array( - - // Typical Database configuration - 'pdo/pgsql' => array( - 'dsn' => 'pgsql:host=localhost;port=5432;dbname=ci_test;', - 'hostname' => 'localhost', - 'username' => 'postgres', - 'password' => '', - 'database' => 'ci_test', - 'dbdriver' => 'pdo', - 'subdriver' => 'pgsql' - ), - - // Database configuration with failover - 'pdo/pgsql_failover' => array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'not_travis', - 'password' => 'wrong password', - 'database' => 'not_ci_test', - 'dbdriver' => 'pdo', - 'subdriver' => 'pgsql', - 'failover' => array( - array( - 'dsn' => 'pgsql:host=localhost;port=5432;dbname=ci_test;', - 'hostname' => 'localhost', - 'username' => 'postgres', - 'password' => '', - 'database' => 'ci_test', - 'dbdriver' => 'pdo', - 'subdriver' => 'pgsql' - ) - ) - ) -);
\ No newline at end of file diff --git a/tests/mocks/database/config/pdo/sqlite.php b/tests/mocks/database/config/pdo/sqlite.php deleted file mode 100644 index 1bf56b3ac..000000000 --- a/tests/mocks/database/config/pdo/sqlite.php +++ /dev/null @@ -1,37 +0,0 @@ -<?php - -return array( - - // Typical Database configuration - 'pdo/sqlite' => array( - 'dsn' => 'sqlite:/'.realpath(__DIR__.'/../..').'/ci_test.sqlite', - 'hostname' => 'localhost', - 'username' => 'sqlite', - 'password' => 'sqlite', - 'database' => 'sqlite', - 'dbdriver' => 'pdo', - 'subdriver' => 'sqlite' - ), - - // Database configuration with failover - 'pdo/sqlite_failover' => array( - 'dsn' => 'sqlite:not_exists.sqlite', - 'hostname' => 'localhost', - 'username' => 'sqlite', - 'password' => 'sqlite', - 'database' => 'sqlite', - 'dbdriver' => 'pdo', - 'subdriver' => 'sqlite', - 'failover' => array( - array( - 'dsn' => 'sqlite:/'.realpath(__DIR__.'/../..').'/ci_test.sqlite', - 'hostname' => 'localhost', - 'username' => 'sqlite', - 'password' => 'sqlite', - 'database' => 'sqlite', - 'dbdriver' => 'pdo', - 'subdriver' => 'sqlite' - ) - ) - ) -);
\ No newline at end of file diff --git a/tests/mocks/database/config/pgsql.php b/tests/mocks/database/config/pgsql.php deleted file mode 100644 index 1444b0066..000000000 --- a/tests/mocks/database/config/pgsql.php +++ /dev/null @@ -1,34 +0,0 @@ -<?php - -return array( - - // Typical Database configuration - 'pgsql' => array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'postgres', - 'password' => '', - 'database' => 'ci_test', - 'dbdriver' => 'postgre' - ), - - // Database configuration with failover - 'pgsql_failover' => array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'not_travis', - 'password' => 'wrong password', - 'database' => 'not_ci_test', - 'dbdriver' => 'postgre', - 'failover' => array( - array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'postgres', - 'password' => '', - 'database' => 'ci_test', - 'dbdriver' => 'postgre', - ) - ) - ) -);
\ No newline at end of file diff --git a/tests/mocks/database/config/sqlite.php b/tests/mocks/database/config/sqlite.php deleted file mode 100644 index d37ee4871..000000000 --- a/tests/mocks/database/config/sqlite.php +++ /dev/null @@ -1,34 +0,0 @@ -<?php - -return array( - - // Typical Database configuration - 'sqlite' => array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'sqlite', - 'password' => 'sqlite', - 'database' => realpath(__DIR__.'/..').'/ci_test.sqlite', - 'dbdriver' => 'sqlite3' - ), - - // Database configuration with failover - 'sqlite_failover' => array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'sqlite', - 'password' => 'sqlite', - 'database' => '../not_exists.sqlite', - 'dbdriver' => 'sqlite3', - 'failover' => array( - array( - 'dsn' => '', - 'hostname' => 'localhost', - 'username' => 'sqlite', - 'password' => 'sqlite', - 'database' => realpath(__DIR__.'/..').'/ci_test.sqlite', - 'dbdriver' => 'sqlite3' - ) - ) - ) -);
\ No newline at end of file diff --git a/tests/mocks/database/db.php b/tests/mocks/database/db.php deleted file mode 100644 index 00dd884b0..000000000 --- a/tests/mocks/database/db.php +++ /dev/null @@ -1,142 +0,0 @@ -<?php - -class Mock_Database_DB { - - /** - * @var array DB configuration - */ - private $config = array(); - - /** - * @var string DB driver name - */ - private static $dbdriver = ''; - - /** - * @var string DB sub-driver name - */ - private static $subdriver = ''; - - /** - * Prepare database configuration skeleton - * - * @param array DB configuration to set - * @return void - */ - public function __construct($config = array()) - { - $this->config = $config; - } - - /** - * Build DSN connection string for DB driver instantiate process - * - * @param string Group name - * @return string DSN Connection string - */ - public function set_dsn($group = 'default') - { - if ( ! isset($this->config[$group])) - { - throw new InvalidArgumentException('Group '.$group.' not exists'); - } - - self::$dbdriver = $this->config[$group]['dbdriver']; - if (isset($this->config[$group]['subdriver'])) - { - self::$subdriver = $this->config[$group]['subdriver']; - } - - $params = array( - 'dbprefix' => '', - 'pconnect' => FALSE, - 'db_debug' => FALSE, - 'cache_on' => FALSE, - 'cachedir' => '', - 'char_set' => 'utf8', - 'dbcollat' => 'utf8_general_ci', - 'swap_pre' => '', - 'stricton' => FALSE - ); - - $config = array_merge($this->config[$group], $params); - $dsnstring = empty($config['dsn']) ? FALSE : $config['dsn']; - $subdriver = empty($config['subdriver']) ? FALSE: $config['subdriver']; - $failover = empty($config['failover']) ? FALSE : $config['failover']; - - $dsn = $config['dbdriver'].'://'.$config['username'].':'.$config['password'] - .'@'.$config['hostname'].'/'.$config['database']; - - // Build the parameter - $other_params = array_slice($config, 6); - if ($dsnstring) $other_params['dsn'] = $dsnstring; - if ($subdriver) $other_params['subdriver'] = $subdriver; - if ($failover) $other_params['failover'] = $failover; - - return $dsn.'?'.http_build_query($other_params); - } - - /** - * Return a database config array - * - * @see ./config - * @param string Driver based configuration - * @return array - */ - public static function config($driver) - { - $dir = realpath(dirname(__FILE__)).DIRECTORY_SEPARATOR; - return include($dir.'config'.DIRECTORY_SEPARATOR.$driver.'.php'); - } - - /** - * Main DB method wrapper - * - * @param string Group or DSN string - * @param bool - * @return object - */ - public static function DB($group, $query_builder = FALSE) - { - // Create dummy driver and builder files to "load" - the mocks have - // already triggered autoloading of the real files - $case = CI_TestCase::instance(); - $driver = self::$dbdriver; - $subdriver = self::$subdriver; - $case->ci_vfs_create(array( - 'DB_driver.php' => '', - 'DB_result.php' => '', - 'DB_forge.php' => '', - 'DB_query_builder.php' => '' - ), '', $case->ci_base_root, 'database'); - if (file_exists(SYSTEM_PATH.'database/drivers/'.$driver.'/'.$driver.'_driver.php')) - { - $case->ci_vfs_create(array( - $driver.'_driver.php' => '', - $driver.'_result.php' => '', - $driver.'_forge.php' => '' - ), '', $case->ci_base_root, 'database/drivers/'.$driver); - } - if ($subdriver) - { - $case->ci_vfs_create(array( - $driver.'_'.$subdriver.'_driver.php' => '', - $driver.'_'.$subdriver.'_forge.php' => '' - ), '', $case->ci_base_root, 'database/drivers/'.$driver.'/subdrivers'); - } - - include_once(SYSTEM_PATH.'database/DB.php'); - - try - { - $db = DB($group, $query_builder); - } - catch (Exception $e) - { - throw new RuntimeException($e->getMessage()); - } - - return $db; - } - -}
\ No newline at end of file diff --git a/tests/mocks/database/db/driver.php b/tests/mocks/database/db/driver.php deleted file mode 100644 index 86f7efd54..000000000 --- a/tests/mocks/database/db/driver.php +++ /dev/null @@ -1,40 +0,0 @@ -<?php - -class Mock_Database_DB_Driver extends CI_DB_driver { - - /** - * @var object The actual Driver - */ - protected $ci_db_driver; - - /** - * Instantiate the database driver - * - * @param string DB Driver class name - * @param array DB configuration to set - * @return void - */ - public function __construct($driver_class, $config = array()) - { - if (is_string($driver_class)) - { - $this->ci_db_driver = new $driver_class($config); - } - } - - /** - * Overloading method, emulate the actual driver method (multiple inheritance workaround) - */ - public function __call($method, $arguments) - { - if ( ! is_callable(array($this->ci_db_driver, $method))) - { - throw new BadMethodCallException($method. ' not exists or not implemented'); - } - - return call_user_func_array(array($this->ci_db_driver, $method), $arguments); - } - -} - -class CI_DB extends CI_DB_query_builder {}
\ No newline at end of file diff --git a/tests/mocks/database/drivers/mysql.php b/tests/mocks/database/drivers/mysql.php deleted file mode 100644 index b7718ebaf..000000000 --- a/tests/mocks/database/drivers/mysql.php +++ /dev/null @@ -1,16 +0,0 @@ -<?php - -class Mock_Database_Drivers_Mysql extends Mock_Database_DB_Driver { - - /** - * Instantiate the database driver - * - * @param array DB configuration to set - * @return void - */ - public function __construct($config = array()) - { - parent::__construct('CI_DB_mysql_driver', $config); - } - -}
\ No newline at end of file diff --git a/tests/mocks/database/drivers/mysqli.php b/tests/mocks/database/drivers/mysqli.php deleted file mode 100644 index f747aad46..000000000 --- a/tests/mocks/database/drivers/mysqli.php +++ /dev/null @@ -1,16 +0,0 @@ -<?php - -class Mock_Database_Drivers_Mysqli extends Mock_Database_DB_Driver { - - /** - * Instantiate the database driver - * - * @param array DB configuration to set - * @return void - */ - public function __construct($config = array()) - { - parent::__construct('CI_DB_mysqli_driver', $config); - } - -}
\ No newline at end of file diff --git a/tests/mocks/database/drivers/pdo.php b/tests/mocks/database/drivers/pdo.php deleted file mode 100644 index af1958aea..000000000 --- a/tests/mocks/database/drivers/pdo.php +++ /dev/null @@ -1,15 +0,0 @@ -<?php - -class Mock_Database_Drivers_PDO extends Mock_Database_DB_Driver { - - /** - * Instantiate the database driver - * - * @param array DB configuration to set - * @return void - */ - public function __construct($config = array()) - { - parent::__construct('CI_DB_pdo_driver', $config); - } -}
\ No newline at end of file diff --git a/tests/mocks/database/drivers/postgre.php b/tests/mocks/database/drivers/postgre.php deleted file mode 100644 index 8c91e54a9..000000000 --- a/tests/mocks/database/drivers/postgre.php +++ /dev/null @@ -1,16 +0,0 @@ -<?php - -class Mock_Database_Drivers_Postgre extends Mock_Database_DB_Driver { - - /** - * Instantiate the database driver - * - * @param array DB configuration to set - * @return void - */ - public function __construct($config = array()) - { - parent::__construct('CI_DB_postgre_driver', $config); - } - -}
\ No newline at end of file diff --git a/tests/mocks/database/drivers/sqlite.php b/tests/mocks/database/drivers/sqlite.php deleted file mode 100644 index b2aec28e6..000000000 --- a/tests/mocks/database/drivers/sqlite.php +++ /dev/null @@ -1,16 +0,0 @@ -<?php - -class Mock_Database_Drivers_Sqlite extends Mock_Database_DB_Driver { - - /** - * Instantiate the database driver - * - * @param array DB configuration to set - * @return void - */ - public function __construct($config = array()) - { - parent::__construct('CI_DB_sqlite3_driver', $config); - } - -}
\ No newline at end of file diff --git a/tests/mocks/database/schema/skeleton.php b/tests/mocks/database/schema/skeleton.php deleted file mode 100644 index 888236ff3..000000000 --- a/tests/mocks/database/schema/skeleton.php +++ /dev/null @@ -1,155 +0,0 @@ -<?php - -class Mock_Database_Schema_Skeleton { - - /** - * @var object Database Holder - */ - public static $db; - - /** - * @var object Forge Holder - */ - public static $forge; - - /** - * @var object Driver Holder - */ - public static $driver; - - /** - * Initialize both database and forge components - */ - public static function init($driver) - { - if (empty(self::$db) && empty(self::$forge)) - { - // E_DEPRECATED notices thrown by mysql_connect(), mysql_pconnect() - // on PHP 5.5+ cause the tests to fail - if ($driver === 'mysql' && version_compare(PHP_VERSION, '5.5', '>=')) - { - error_reporting(E_ALL & ~E_DEPRECATED); - } - - $config = Mock_Database_DB::config($driver); - $connection = new Mock_Database_DB($config); - $db = Mock_Database_DB::DB($connection->set_dsn($driver), TRUE); - - CI_TestCase::instance()->ci_instance_var('db', $db); - - $loader = new CI_Loader(); - $loader->dbforge(); - $forge = CI_TestCase::instance()->ci_instance_var('dbforge'); - - self::$db = $db; - self::$forge = $forge; - self::$driver = $driver; - } - - return self::$db; - } - - /** - * Create the dummy tables - * - * @return void - */ - public static function create_tables() - { - // User Table - self::$forge->add_field(array( - 'id' => array( - 'type' => 'INTEGER', - 'constraint' => 3 - ), - 'name' => array( - 'type' => 'VARCHAR', - 'constraint' => 40 - ), - 'email' => array( - 'type' => 'VARCHAR', - 'constraint' => 100 - ), - 'country' => array( - 'type' => 'VARCHAR', - 'constraint' => 40 - ) - )); - self::$forge->add_key('id', TRUE); - self::$forge->create_table('user', TRUE); - - // Job Table - self::$forge->add_field(array( - 'id' => array( - 'type' => 'INTEGER', - 'constraint' => 3 - ), - 'name' => array( - 'type' => 'VARCHAR', - 'constraint' => 40 - ), - 'description' => array( - 'type' => 'TEXT' - ) - )); - self::$forge->add_key('id', TRUE); - self::$forge->create_table('job', TRUE); - - // Misc Table - self::$forge->add_field(array( - 'id' => array( - 'type' => 'INTEGER', - 'constraint' => 3 - ), - 'key' => array( - 'type' => 'VARCHAR', - 'constraint' => 40 - ), - 'value' => array( - 'type' => 'TEXT' - ) - )); - self::$forge->add_key('id', TRUE); - self::$forge->create_table('misc', TRUE); - } - - /** - * Create the dummy datas - * - * @return void - */ - public static function create_data() - { - // Job Data - $data = array( - 'user' => array( - array('id' => 1, 'name' => 'Derek Jones', 'email' => 'derek@world.com', 'country' => 'US'), - array('id' => 2, 'name' => 'Ahmadinejad', 'email' => 'ahmadinejad@world.com', 'country' => 'Iran'), - array('id' => 3, 'name' => 'Richard A Causey', 'email' => 'richard@world.com', 'country' => 'US'), - array('id' => 4, 'name' => 'Chris Martin', 'email' => 'chris@world.com', 'country' => 'UK') - ), - 'job' => array( - array('id' => 1, 'name' => 'Developer', 'description' => 'Awesome job, but sometimes makes you bored'), - array('id' => 2, 'name' => 'Politician', 'description' => 'This is not really a job'), - array('id' => 3, 'name' => 'Accountant', 'description' => 'Boring job, but you will get free snack at lunch'), - array('id' => 4, 'name' => 'Musician', 'description' => 'Only Coldplay can actually called Musician') - ), - 'misc' => array( - array('id' => 1, 'key' => '\\xxxfoo456', 'value' => 'Entry with \\xxx'), - array('id' => 2, 'key' => '\\%foo456', 'value' => 'Entry with \\%'), - array('id' => 3, 'key' => 'spaces and tabs', 'value' => ' One two three tab') - ) - ); - - foreach ($data as $table => $dummy_data) - { - self::$db->truncate($table); - - foreach ($dummy_data as $single_dummy_data) - { - self::$db->insert($table, $single_dummy_data); - } - } - } - -} |