From e173f36bcb50451c49e5708de29fcb41267b41f4 Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Sun, 2 Nov 2008 23:55:09 +0000 Subject: Create some basic infrastructure: * item model (contains basic item info, similar to the gx version) * module model (has info about each module and which version of it is installed) * added a very basic unit test to verify that we can create an instance of item * Updated our test controller to require a unit_test db config and call core::install if it hasn't been done already. New pattern: * core/helpers/core_installer.php creates core_installer helper. When we install a new module you call xxx_installer::install(), and when you want it to go away, you do xxx_installer::uninstall() Create --- core/controllers/welcome.php | 4 +-- core/helpers/core_installer.php | 67 +++++++++++++++++++++++++++++++++++++++++ core/models/item.php | 21 +++++++++++++ core/models/module.php | 21 +++++++++++++ core/tests/Item_Test.php | 24 +++++++++++++++ 5 files changed, 135 insertions(+), 2 deletions(-) create mode 100644 core/helpers/core_installer.php create mode 100644 core/models/item.php create mode 100644 core/models/module.php create mode 100644 core/tests/Item_Test.php (limited to 'core') diff --git a/core/controllers/welcome.php b/core/controllers/welcome.php index 672252eb..061a4176 100644 --- a/core/controllers/welcome.php +++ b/core/controllers/welcome.php @@ -20,7 +20,7 @@ class Welcome_Controller extends Template_Controller { public $template = 'welcome.html'; - function Index() { + function index() { $this->template->syscheck = new View('welcome_syscheck.html'); $this->template->syscheck->errors = $this->_get_config_errors(); $this->_create_directories(); @@ -77,7 +77,7 @@ class Welcome_Controller extends Template_Controller { return $errors; } - function _error_handler() { + function _error_handler($x) { } function _create_directories() { diff --git a/core/helpers/core_installer.php b/core/helpers/core_installer.php new file mode 100644 index 00000000..ef4dddd9 --- /dev/null +++ b/core/helpers/core_installer.php @@ -0,0 +1,67 @@ +where('name', 'core')->find()->version; + } catch (Exception $e) { + if ($e->getMessage() == "Table modules does not exist in your database.") { + $base_version = 0; + } else { + throw $e; + } + } + + if ($base_version == 0) { + $db->query("CREATE TABLE `modules` ( + `id` int(9) NOT NULL auto_increment, + `name` char(255) default NULL, + `version` int(9) default NULL, + PRIMARY KEY (`id`), + UNIQUE KEY(`name`)) + ENGINE=InnoDB DEFAULT CHARSET=utf8;"); + + $db->query("CREATE TABLE `items` ( + `id` int(9) NOT NULL auto_increment, + `type` char(32) default NULL, + `title` char(255) default NULL, + `path` char(255) default NULL, + `parent_id` int(9) default NULL, + `level` int(9) default NULL, + `left` int(9) default NULL, + `right` int(9) default NULL, + PRIMARY KEY (`id`), + KEY `parent_id` (`parent_id`), + KEY `type` (`type`)) + ENGINE=InnoDB DEFAULT CHARSET=utf8;"); + $core = ORM::factory('module')->where('name', 'core')->find(); + $core->name = "core"; + $core->version = 1; + $core->save(); + } + } + + public function uninstall() { + $db = Database::instance(); + $db->query("DROP TABLE IF EXISTS `items`;"); + $db->query("DROP TABLE IF EXISTS `modules`;"); + } +} diff --git a/core/models/item.php b/core/models/item.php new file mode 100644 index 00000000..f402a567 --- /dev/null +++ b/core/models/item.php @@ -0,0 +1,21 @@ +