summaryrefslogtreecommitdiffstats
path: root/tests/mocks/database
diff options
context:
space:
mode:
authorAndrey Andreev <narf@devilix.net>2019-01-16 16:49:35 +0100
committerAndrey Andreev <narf@devilix.net>2019-01-16 16:49:35 +0100
commitc576995304fc3609cca0b7b92d1b2cd611ec82f5 (patch)
treec8b9121cb295b56bbabe3aeaad0a3eb1f2d390bb /tests/mocks/database
parent4eaf80a6ec0b58a0adc95638153363e00ebf5378 (diff)
[ci skip] 3.1.10 release
Diffstat (limited to 'tests/mocks/database')
-rwxr-xr-xtests/mocks/database/ci_test.sqlitebin19456 -> 0 bytes
-rw-r--r--tests/mocks/database/config/mysql.php34
-rw-r--r--tests/mocks/database/config/mysqli.php34
-rw-r--r--tests/mocks/database/config/pdo/mysql.php37
-rw-r--r--tests/mocks/database/config/pdo/pgsql.php37
-rw-r--r--tests/mocks/database/config/pdo/sqlite.php37
-rw-r--r--tests/mocks/database/config/pgsql.php34
-rw-r--r--tests/mocks/database/config/sqlite.php34
-rw-r--r--tests/mocks/database/db.php142
-rw-r--r--tests/mocks/database/db/driver.php40
-rw-r--r--tests/mocks/database/drivers/mysql.php16
-rw-r--r--tests/mocks/database/drivers/mysqli.php16
-rw-r--r--tests/mocks/database/drivers/pdo.php15
-rw-r--r--tests/mocks/database/drivers/postgre.php16
-rw-r--r--tests/mocks/database/drivers/sqlite.php16
-rw-r--r--tests/mocks/database/schema/skeleton.php155
16 files changed, 0 insertions, 663 deletions
diff --git a/tests/mocks/database/ci_test.sqlite b/tests/mocks/database/ci_test.sqlite
deleted file mode 100755
index 574d3ae53..000000000
--- a/tests/mocks/database/ci_test.sqlite
+++ /dev/null
Binary files differ
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);
- }
- }
- }
-
-}