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

Timestamp:

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

Author:

chronos

Message:

• Added: More modules models installation.

File:

• trunk/Modules/Subject/Subject.php (modified) (2 diffs)

trunk/Modules/Subject/Subject.php

@@ -133 +133 @@
   function DoInstall(): void
   {
-    $this->Database->query("CREATE TABLE IF NOT EXISTS `Subject` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Name` varchar(64) NOT NULL DEFAULT '',
-  `AddressStreet` varchar(64) NOT NULL DEFAULT '',
-  `AddressTown` varchar(64) NOT NULL DEFAULT '',
-  `AddressPSC` int(11) NOT NULL DEFAULT '0',
-  `AddressCountry` int(11) NOT NULL,
-  `IC` varchar(32) NOT NULL,
-  `DIC` varchar(32) NOT NULL DEFAULT '',
-  `PayVAT` int(11) NOT NULL,
-  `MapPosition` int(11) DEFAULT NULL,
-  `WWW` varchar(255) NOT NULL,
-  `Note` varchar(255) NOT NULL,
-  PRIMARY KEY (`Id`)
-) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
-    $this->Database->query("CREATE TABLE IF NOT EXISTS `Contact` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Category` int(11) NOT NULL,
-  `Value` varchar(255) NOT NULL,
-  `Subject` int(11) DEFAULT NULL,
-  `User` int(11) DEFAULT NULL,
-  `Description` varchar(255) NOT NULL,
-  `Receive` tinyint(1) NOT NULL,
-  PRIMARY KEY (`Id`)
-) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
-    $this->System->Database->query("CREATE TABLE IF NOT EXISTS `ContactCategory` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Name` varchar(255) NOT NULL,
-  PRIMARY KEY (`Id`)
-) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
-
-    $this->Database->query("ALTER TABLE `Subject`
-ADD CONSTRAINT `Subject_ibfk_1` FOREIGN KEY (`AddressCountry`) REFERENCES `Country` (`Id`),
-ADD CONSTRAINT `Subject_ibfk_2` FOREIGN KEY (`MapPosition`) REFERENCES `MapPosition` (`Id`);");
-    $this->Database->query("ALTER TABLE `Contact`
-    ADD CONSTRAINT `Contact_ibfk_1` FOREIGN KEY (`Category`) REFERENCES `ContactCategory` (`Id`),
-    ADD CONSTRAINT `Contact_ibfk_2` FOREIGN KEY (`Subject`) REFERENCES `Subject` (`Id`),
-    ADD CONSTRAINT `Contact_ibfk_3` FOREIGN KEY (`User`) REFERENCES `User` (`Id`);");
+    $this->InstallModel(Country::GetDesc());
+    $this->InstallModel(Subject::GetDesc());
+    $this->InstallModel(ContactCategory::GetDesc());
+    $this->InstallModel(Contact::GetDesc());
   }
 
   function DoUninstall(): void
   {
-    $this->Database->query('DROP TABLE `Contact`');
-    $this->Database->query('DROP TABLE `ContactCategory`');
-    $this->Database->query('DROP TABLE `Subject`');
+    $this->UninstallModel(Contact::GetDesc());
+    $this->UninstallModel(ContactCategory::GetDesc());
+    $this->UninstallModel(Subject::GetDesc());
+    $this->UninstallModel(Country::GetDesc());
   }
 
@@ -188 +155 @@
   }
 }
+
+class Subject extends Model
+{
+  static function GetDesc(): ModelDesc
+  {
+    $Desc = new ModelDesc('Subject');
+    $Desc->AddString('Name');
+    $Desc->AddString('AddressStreet');
+    $Desc->AddString('AddressTown');
+    $Desc->AddString('AddressPSC');
+    $Desc->AddReference('AddressCountry', 'Country', true);
+    $Desc->AddString('IC');
+    $Desc->AddString('DIC');
+    $Desc->AddBoolean('PayVAT');
+    $Desc->AddReference('MapPosition', 'MapPosition', true);
+    $Desc->AddString('WWW');
+    $Desc->AddString('Note');
+    return $Desc;
+  }
+}
+
+class Country extends Model
+{
+  static function GetDesc(): ModelDesc
+  {
+    $Desc = new ModelDesc('Country');
+    $Desc->AddString('Name');
+    return $Desc;
+  }
+}
+
+class Contact extends Model
+{
+  static function GetDesc(): ModelDesc
+  {
+    $Desc = new ModelDesc('Contact');
+    $Desc->AddReference('Category', 'ContactCategory', true);
+    $Desc->AddString('Value');
+    $Desc->AddReference('Subject', 'Subject', true);
+    $Desc->AddReference('User', 'User', true);
+    $Desc->AddString('Description');
+    $Desc->AddBoolean('Receive');
+    return $Desc;
+  }
+}
+
+class ContactCategory extends Model
+{
+  static function GetDesc(): ModelDesc
+  {
+    $Desc = new ModelDesc('ContactCategory');
+    $Desc->AddString('Name');
+    return $Desc;
+  }
+}