Changeset 342 for trunk/Model.php

Timestamp:

Jan 17, 2012, 10:37:59 AM (13 years ago)

Author:

chronos

Message:

• Upraveno: Databáze nyní hlásí chyby dotazů přes výjimky.
• Opraveno: Inicializace modulů.

File:

• trunk/Model.php (modified) (2 diffs)

trunk/Model.php

@@ -16 +16 @@
   var $Properties;
   
-  function __construct()
+  function __construct($Database)
   {
+    $this->Database = &$Database;
     $this->AddPropertyDateTime('TimeCreate');
     $this->AddPropertyOneToMany('UserCreate', 'User');
@@ -67 +68 @@
       'Column' => $Column); 
   }
+  
+  function Install()
+  {
+    $Query = 'CREATE TABLE IF NOT EXISTS `'.$this->Name.'` ('.
+      '`Id` int(11) NOT NULL AUTO_INCREMENT,';
+    foreach($this->Properties as $Property)
+    {
+      if($Property['Type'] == PropertyDateTime) 
+        $Query .= '`'.$Property['Name'].'` DATETIME NOT NULL,';
+      else if($Property['Type'] == PropertyString) 
+        $Query .= '`'.$Property['Name'].'` VARCHAR(255) COLLATE utf8_general_ci NOT NULL,';
+      else if($Property['Type'] == PropertyText) 
+        $Query .= '`'.$Property['Name'].'` TEXT COLLATE utf8_general_ci NOT NULL,';
+      else if($Property['Type'] == PropertyInteger) 
+        $Query .= '`'.$Property['Name'].'` INT(11) NOT NULL,';
+      else if($Property['Type'] == PropertyFloat) 
+        $Query .= '`'.$Property['Name'].'` FLOAT NOT NULL,';
+      else if($Property['Type'] == PropertyOneToMany) 
+        $Query .= '`'.$Property['Name'].'` INT(255) NOT NULL,'.
+          'KEY `'.$Property['Name'].'` (`'.$Property['Name'].'`),';
+      else if($Property['Type'] == PropertyManyToOne) 
+        $Query .= '';
+      else if($Property['Type'] == PropertyManyToMany) ;
+        // Create many-to-many table
+        //$Query .= '`'.$Property['Name'].'` INT(255) NOT NULL,'.
+        //  'KEY `'.$Property['Name'].'` (`'.$Property['Name'].'`),';
+    }
+    $Query .= 'PRIMARY KEY (`Id`)'.
+      ') ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ;';          
+    $this->Database->query($Query);
+    foreach($this->Properties as $Property)
+    {
+      if($Property['Type'] == PropertyOneToMany) 
+        $this->Database->query('ALTER TABLE `'.$this->Name.'` ADD CONSTRAINT '.
+          '`'.$this->Name.'_ibfk_'.$Property['Name'].'` FOREIGN KEY (`'.$Property['TargetModel'].'`) REFERENCES `'.$Property['TargetModel'].'` (`Id`);');
+    }
+  }
+    
+  function UnInstall()
+  {
+    foreach($Model->Properties as $Property)
+    {
+      if($Property['Type'] == PropertyManyToMany)
+        ; // Delete many-to-many table
+    }
+    $this->Database->query('DROP TABLE IF EXISTS `'.$this->Name.'`');
+  }
 }