Changeset 891 for trunk/Modules/Notify/Notify.php

Timestamp:

Dec 30, 2020, 11:52:07 PM (3 years ago)

Author:

chronos

Message:

• Added: More modules models installation.

File:

• trunk/Modules/Notify/Notify.php (modified) (3 diffs)

trunk/Modules/Notify/Notify.php

@@ -128 +128 @@
   }
 
+  static function GetModels(): array
+  {
+    return array(
+      'NotifyCategory',
+      'NotifyUser',
+    );
+  }
+
   function DoInstall(): void
   {
-    $this->Database->query('CREATE TABLE IF NOT EXISTS `NotifyCategory` (
-      `Id` int(11) NOT NULL AUTO_INCREMENT,
-      `Name` varchar(255) NOT NULL,
-      `SysName` varchar(255) NOT NULL,
-      PRIMARY KEY (`Id`)
-    ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
+    foreach (self::GetModels() as $Model)
+    {
+      $this->InstallModel($Model::GetDesc());
+    }
 
     $this->Database->query("INSERT INTO `NotifyCategory` (`Id`, `Name`, `SysName`) VALUES
@@ -144 +150 @@
     (5, 'Minimální odezva', 'NetworkLatency'),
     (6, 'Minimální propustnost', 'NetworkBandwidth');");
-
-    $this->Database->query('
-  CREATE TABLE IF NOT EXISTS `NotifyUser` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `User` int(11) NOT NULL,
-  `Contact` int(11) NOT NULL,
-  `Period` int(11) NOT NULL,
-  PRIMARY KEY (`Id`),
-  KEY `User` (`User`),
-  KEY `Contact` (`Contact`)
-    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;');
-    $this->Database->query('ALTER TABLE `NotifyUser`
-ADD CONSTRAINT `NotifyUser_ibfk_1` FOREIGN KEY (`User`) REFERENCES `User` (`Id`),
-ADD CONSTRAINT `NotifyUser_ibfk_2` FOREIGN KEY (`Contact`) REFERENCES `Contact` (`Id`);');
   }
 
   function DoUninstall(): void
   {
-    $this->Database->query('DROP TABLE `NotifyUser`');
-    $this->Database->query('DROP TABLE `NotifyCategory`');
+    foreach (array_reverse(self::GetModels()) as $Model)
+    {
+      $this->UninstallModel($Model::GetDesc());
+    }
   }
 
@@ -207 +201 @@
   }
 }
+
+class NotifyCategory extends Model
+{
+  static function GetDesc(): ModelDesc
+  {
+    $Desc = new ModelDesc('NotifyCategory');
+    $Desc->AddString('Name');
+    $Desc->AddString('SysName');
+    return $Desc;
+  }
+}
+
+class NotifyUser extends Model
+{
+  static function GetDesc(): ModelDesc
+  {
+    $Desc = new ModelDesc('NotifyUser');
+    $Desc->AddReference('User', 'User');
+    $Desc->AddReference('Contact', 'Contact');
+    $Desc->AddInteger('Period');
+    return $Desc;
+  }
+}