Changeset 69 for trunk/Application/UpdateTrace.php

Timestamp:

Feb 28, 2016, 10:54:30 AM (9 years ago)

Author:

chronos

Message:

• Modified: Use object oriented approach for page drawing using Application class.
• Added: SQL updated will be automatic using UpdateTrace.php file.
• Added: Use generic setup page at URL /setup for SQL structure update.
• Modified: Update Common package to newer version.

Location:

trunk/Application

Files:

• . (added)
• UpdateTrace.php (moved) (moved from trunk/UpdateTrace.php ) (2 diffs)

trunk/Application/UpdateTrace.php

@@ -1 +1 @@
 <?php
 
-class UpdateTrace
+function FullInstall($Manager)
 {
-  var $Manager;
-
-  function FullInstall($Manager)
-  {
-    $this->Manager->Execute('CREATE TABLE IF NOT EXISTS `SystemVersion` (
+   $Manager->Execute('CREATE TABLE IF NOT EXISTS `SystemVersion` (
   `Id` int(11) NOT NULL AUTO_INCREMENT,
   `Revision` int(11) NOT NULL,
   PRIMARY KEY (`Id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
-    $this->Manager->Execute('INSERT INTO `SystemVersion` (`Id`, `Version`) VALUES (NULL, 65);');
-  }
+  $Manager->Execute('INSERT INTO `SystemVersion` (`Id`, `Revision`) VALUES (NULL, 65);');
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `measure` (
+  `Id` int(11) NOT NULL auto_increment,
+  `Name` varchar(255) collate utf8_general_ci NOT NULL,
+  `Description` varchar(255) collate utf8_general_ci NOT NULL,
+  `Divider` int(11) NOT NULL default 1,
+  `Unit` varchar(16) collate utf8_general_ci NOT NULL,
+  `Continuity` tinyint(1) NOT NULL default 0,
+  `Period` int(11) NOT NULL default 60,
+  `OldName` varchar(32) collate utf8_general_ci NOT NULL,
+  `PermissionView` varchar(255) collate utf8_general_ci NOT NULL default "all",
+  `PermissionAdd` varchar(255) collate utf8_general_ci NOT NULL default "localhost.localdomain",
+  `Info` varchar(255) collate utf8_general_ci NOT NULL,
+  `Enabled` int(11) NOT NULL default 1,
+  `Cumulative` int(11) NOT NULL default 0,
+  `DataTable` varchar(32) collate utf8_general_ci NOT NULL default "data",
+  `DataType` varchar(32) collate utf8_general_ci NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;');
+}
 
-  function UpdateTo67($Manager)
-  {
-    $this->Manager->Execute('RENAME TABLE `measure` TO `Measure`;');
-    $this->Manager->Execute('CREATE TABLE IF NOT EXISTS `Permission` (
+function UpdateTo67($Manager)
+{
+  $Manager->Execute('RENAME TABLE `measure` TO `Measure`;');
+/*
+   $Manager->Execute('CREATE TABLE IF NOT EXISTS `Permission` (
   `Id` int(11) NOT NULL AUTO_INCREMENT,
   `Measure` int(11) NOT NULL,
@@ -26 +41 @@
   KEY `Measure` (`Measure`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
-    $this->Manager->Execute('ALTER TABLE `Permission` ADD FOREIGN KEY (`Measure`) '.
-    'REFERENCES `Measure`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
-    $DbResult = $this->Manager->Execute('SELECT `Id`, `PermissionAdd` FROM `Measure`');
-    while($DbRow = $DbResult->fetch_assoc())
-    {
-          $this->Manager->Execute('INSERT INTO `Permission` (`Measure`, `Operation`) VALUES ('.
+  $Manager->Execute('ALTER TABLE `Permission` ADD FOREIGN KEY (`Measure`) '.
+  'REFERENCES `Measure`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
+  $DbResult = $Manager->Execute('SELECT `Id`, `PermissionAdd` FROM `Measure`');
+  while($DbRow = $DbResult->fetch_assoc())
+  {
+    $Manager->Execute('INSERT INTO `Permission` (`Measure`, `Operation`) VALUES ('.
             $DbRow['Id'].', "add");');
         }
-    $DbResult = $this->Manager->Execute('SELECT `Id`, `PermissionView` FROM `Measure`');
-    while($DbRow = $DbResult->fetch_assoc())
-    {
-          $this->Manager->Execute('INSERT INTO `Permission` (`Measure`, `Operation`) VALUES ('.
+  $DbResult = $Manager->Execute('SELECT `Id`, `PermissionView` FROM `Measure`');
+  while($DbRow = $DbResult->fetch_assoc())
+  {
+          $Manager->Execute('INSERT INTO `Permission` (`Measure`, `Operation`) VALUES ('.
             $DbRow['Id'].', "view");');
-        }
-        //$this->Manager->Execute('');
   }
+  */
+}
 
-  function __construct()
+class Updates
+{
+  function Get()
   {
-    $this->Updates = array(
+    return(array(
       65 => array('Revision' => 67, 'Function' => 'UpdateTo67'),
-    );
+    ));
   }
 }