source: trunk/Common/Model.php@ 373

<?php

define('PropertyInteger8', 'Integer8');
define('PropertyInteger16', 'Integer16');
define('PropertyInteger24', 'Integer24');
define('PropertyInteger32', 'Integer32');
define('PropertyInteger64', 'Integer64');

define('PropertyText8', 'Text8');
define('PropertyText16', 'Text16');
define('PropertyText24', 'Text24');
define('PropertyText32', 'Text32');

define('PropertyDate', 'Date');
define('PropertyTime', 'Time');
define('PropertyDateTime', 'DateTime');
define('PropertyText', 'Text16');
define('PropertyString', 'String');
define('PropertyBoolean', 'Boolean');
define('PropertyInteger', 'Integer32');
define('PropertyFloat', 'Float');
define('PropertyDouble', 'Double');
define('PropertyOneToMany', 'OneToMany');
define('PropertyManyToMany', 'ManyToMany');


class Model 
{
  var $Database;    
  var $Name;
  var $Properties;
  var $System;
  
  function __construct($Database, $System)
  {
    $this->Database = &$Database;
    $this->System = &$System;
    $this->AddPropertyDateTime('TimeCreate');
    $this->AddPropertyOneToMany('UserCreate', 'User');
    $this->AddPropertyDateTime('TimeModify');
    $this->AddPropertyOneToMany('UserModify', 'User');
    $this->AddPropertyOneToMany('Module', 'Module');
  }
  
  function AddPropertyDateTime($Name)
  {
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyDateTime); 
  }
  
  function AddPropertyDate($Name)
  {
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyDate); 
  }
  
  function AddPropertyTime($Name)
  {
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyTime); 
  }
  
  function AddPropertyOneToMany($Name, $TargetModel)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyOneToMany, 'TargetModel' => $TargetModel); 
  }
  
  function AddPropertyText($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyText); 
  }

  function AddPropertyText8($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyText8); 
  }

  function AddPropertyText16($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyText16); 
  }

  function AddPropertyText24($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyText24); 
  }

  function AddPropertyText32($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyText32); 
  }

  function AddPropertyString($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyString); 
  }

  function AddPropertyInteger($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyInteger); 
  }

  function AddPropertyInteger8($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyInteger8); 
  }

  function AddPropertyInteger16($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyInteger16); 
  }

  function AddPropertyInteger24($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyInteger24); 
  }

  function AddPropertyInteger32($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyInteger32); 
  }

  function AddPropertyInteger64($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyInteger64); 
  }

  function AddPropertyFloat($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyFloat); 
  }

  function AddPropertyDouble($Name)
  {      
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyDouble); 
  }

  function AddPropertyBoolean($Name)
  {
    $this->Properties[] = array('Name' => $Name, 'Type' => PropertyBoolean); 
  }
 
  function AddPropertyManyToMany($TargetModel, $Relation, $ColumOwn, $ColumnTarget)
  {      
    $this->Properties[] = array('Type' => PropertyManyToMany, 
      'TargetModel' => $TargetModel, 'Relation' => $Relation, 'ColumnOwn' => $ColumnOwn,
      'ColumnTarget' => $ColumnTarget); 
  }
  
  function Install()
  {
    $this->Database->insert('SystemModel', array('Name' => $this->Name, 'Module' => $this->Module->Id));
    $this->Id = $this->Database->insert_id;
    
    $Query = 'CREATE TABLE IF NOT EXISTS `'.$this->Name.'` ('.
      '`Id` int(11) NOT NULL AUTO_INCREMENT,';
    foreach($this->Properties as $Property)
    {
      $this->Database->insert('SystemModelProperty', array('Name' => $Property['Name'], 
        'Model' => $this->Id, 'Type' => $Property['Type']));
      if($Property['Type'] == PropertyDateTime) 
        $Query .= '`'.$Property['Name'].'` DATETIME NOT NULL,';
      else if($Property['Type'] == PropertyDate) 
        $Query .= '`'.$Property['Name'].'` DATE NOT NULL,';
      else if($Property['Type'] == PropertyTime) 
        $Query .= '`'.$Property['Name'].'` TIME NOT NULL,';
      else if($Property['Type'] == PropertyString) 
        $Query .= '`'.$Property['Name'].'` VARCHAR(255) COLLATE utf8_general_ci NOT NULL,';
      else if($Property['Type'] == PropertyText8) 
        $Query .= '`'.$Property['Name'].'` TINYTEXT COLLATE utf8_general_ci NOT NULL,';
      else if($Property['Type'] == PropertyText16) 
        $Query .= '`'.$Property['Name'].'` TEXT COLLATE utf8_general_ci NOT NULL,';
      else if($Property['Type'] == PropertyText24) 
        $Query .= '`'.$Property['Name'].'` MEDIUMTEXT COLLATE utf8_general_ci NOT NULL,';
      else if($Property['Type'] == PropertyText32) 
        $Query .= '`'.$Property['Name'].'` LONGTEXT COLLATE utf8_general_ci NOT NULL,';
      else if($Property['Type'] == PropertyInteger8) 
        $Query .= '`'.$Property['Name'].'` TINYINT(4) NOT NULL,';
      else if($Property['Type'] == PropertyInteger16) 
        $Query .= '`'.$Property['Name'].'` SMALLINT(6) NOT NULL,';
      else if($Property['Type'] == PropertyInteger24) 
        $Query .= '`'.$Property['Name'].'` MEDIUMINT(9) NOT NULL,';
      else if($Property['Type'] == PropertyInteger32) 
        $Query .= '`'.$Property['Name'].'` INT(11) NOT NULL,';
      else if($Property['Type'] == PropertyInteger64) 
        $Query .= '`'.$Property['Name'].'` BIGINT(20) NOT NULL,';
      else if($Property['Type'] == PropertyBoolean) 
        $Query .= '`'.$Property['Name'].'` BOOLEAN NOT NULL,';
      else if($Property['Type'] == PropertyFloat) 
        $Query .= '`'.$Property['Name'].'` FLOAT NOT NULL,';
      else if($Property['Type'] == PropertyDouble) 
        $Query .= '`'.$Property['Name'].'` DOUBLE NOT NULL,';
      else if($Property['Type'] == PropertyOneToMany) 
        $Query .= '`'.$Property['Name'].'` INT(255) NOT NULL,'.
          'KEY `'.$Property['Name'].'` (`'.$Property['Name'].'`),';
      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.'`');
  }
}

?>