diff options
Diffstat (limited to 'tests/mocks/database/schema/skeleton.php')
| -rw-r--r-- | tests/mocks/database/schema/skeleton.php | 155 |
1 files changed, 0 insertions, 155 deletions
diff --git a/tests/mocks/database/schema/skeleton.php b/tests/mocks/database/schema/skeleton.php deleted file mode 100644 index e2b6e7d0e..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) OR show_error('Unable to create the `user` table'); - - // 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) OR show_error('Unable to create the `job` table'); - - // 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) OR show_error('Unable to create the `misc` table'); - } - - /** - * 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) OR show_error("Unable to truncate `{$table}` table"); - - foreach ($dummy_data as $single_dummy_data) - { - self::$db->insert($table, $single_dummy_data) OR show_error("Unable to insert data into `{$table}` table"); - } - } - } - -} |