class.ilADTActiveRecord.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilADTActiveRecord
{
        protected $properties; // [ilADTGroupDBBridge]
        
        public function __construct(ilADTGroupDBBridge $a_properties)
        {
                $this->properties = $a_properties;
        }
 
        public function read()
        {               
                global $ilDB;
                
                // reset all group elements
                $this->properties->getADT()->reset();
                
                $sql = "SELECT * FROM ".$this->properties->getTable().
                        " WHERE ".$this->properties->buildPrimaryWhere();
                $set = $ilDB->query($sql);
                if($ilDB->numRows($set))
                {
                        $row = $ilDB->fetchAssoc($set);                 
                        $this->properties->readRecord($row);                    
                        return true;
                }               
                return false;
        }
        
        public function create()
        {
                global $ilDB;
                        
                $fields = $this->properties->getPrimary();
                $this->properties->prepareInsert($fields);      
                                        
                $ilDB->insert($this->properties->getTable(), $fields);
                
                // enables subtables
                $this->properties->afterInsert();               
        }
        
        public function update()
        {
                global $ilDB;
                                
                $fields = array();
                $this->properties->prepareUpdate($fields);      
                
                // does return affected rows, but will also return 0 for unchanged records
                $ilDB->update($this->properties->getTable(), $fields, $this->properties->getPrimary());
                
                // enables subtables
                $this->properties->afterUpdate();               
        }
        
        public function delete()
        {
                global $ilDB;
                        
                $ilDB->manipulate("DELETE FROM ".$this->properties->getTable().
                        " WHERE ".$this->properties->buildPrimaryWhere());
 
                // enables subtables
                $this->properties->afterDelete();                       
        }       
}
 
?>