Changeset 889 for trunk/Packages/Common/AppModule.php

Timestamp:

Dec 22, 2020, 11:34:19 PM (3 years ago)

Author:

chronos

Message:

• Added: Install and uninstall modules models persistence using abstract classes.

File:

• trunk/Packages/Common/AppModule.php (modified) (1 diff)

trunk/Packages/Common/AppModule.php

@@ -184 +184 @@
     $this->Models[get_class($Model)] = $Model;
   }
+
+  function InstallModel(ModelDesc $ModelDesc)
+  {
+    $Query = 'CREATE TABLE IF NOT EXISTS `'.$ModelDesc->Name.'` ('."\n";
+    $Query = '  `'.$ModelDesc->PrimaryKey.'` int(11) NOT NULL AUTO_INCREMENT,'."\n";
+    foreach ($ModelDesc->Columns as $Column)
+    {
+      $Query .= "  `".$Column->Name."` ";
+      if ($Column->Type == ModelColumnType::Integer) $Query .= 'int(11)';
+      else if ($Column->Type == ModelColumnType::String) $Query .= 'varchar(255)';
+      else if ($Column->Type == ModelColumnType::Float) $Query .= 'varchar(255)';
+      else if ($Column->Type == ModelColumnType::Text) $Query .= 'text';
+      else if ($Column->Type == ModelColumnType::DateTime) $Query .= 'datetime';
+      else if ($Column->Type == ModelColumnType::Reference) $Query .= 'int(11)';
+
+      if ($Column->Nullable) $Query .= '';
+        else $Query .= ' NOT NULL';
+
+      $Query .= ' COLLATE utf8_general_ci';
+
+      if ($Column->HasDefault)
+      {
+        if ($Column->Default == null)
+          $Query .= ' DEFAULT NULL';
+        $Query .= ' DEFAULT '.$Column->GetDefault();
+      }
+      $Query .= ",\n";
+    }
+    $Query .= '  PRIMARY KEY (`'.$ModelDesc->PrimaryKey.'`),';
+    foreach ($ModelDesc->Columns as $Column)
+    {
+      if ($Column->Type == ModelColumnType::Reference)
+        $Query .= '  KEY `'.$Column->Name.'` (`'.$Column->Name.'`)'."\n";
+      else if ($Column->Unique)
+        $Query .= '  UNIQUE KEY `'.$Column->Name.'` (`'.$Column->Name.'`)'."\n";
+    }
+
+    $Query .= ") ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;";
+    $I = 1;
+    foreach ($ModelDesc->Columns as $Column)
+    {
+      if ($Column->Type == ModelColumnType::Reference)
+        $Query .= "ALTER TABLE `".$ModelDesc->Name."` ".
+        "ADD CONSTRAINT `".$ModelDesc->Name."_ibfk_".$I."` FOREIGN KEY (`".$Column->Name."`) REFERENCES `".$Column->RefTable."` (`Id`);";
+    }
+    $this->Database->query($Query);
+  }
+
+  function UninstallModel(ModelDesc $ModelDesc)
+  {
+    $this->Database->query('DROP TABLE `'.$ModelDesc->Name.'`');
+  }
 }