summaryrefslogtreecommitdiffstats
path: root/tests/mocks/database/schema/skeleton.php
diff options
context:
space:
mode:
Diffstat (limited to 'tests/mocks/database/schema/skeleton.php')
-rw-r--r--tests/mocks/database/schema/skeleton.php155
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");
- }
- }
- }
-
-}