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 $DIC;
 
        $ilDB = $DIC['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 $DIC;
 
        $ilDB = $DIC['ilDB'];
            
        $fields = $this->properties->getPrimary();
        $this->properties->prepareInsert($fields);
                    
        $ilDB->insert($this->properties->getTable(), $fields);
        
        // enables subtables
        $this->properties->afterInsert();
    }
    
    public function update()
    {
        global $DIC;
 
        $ilDB = $DIC['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 $DIC;
 
        $ilDB = $DIC['ilDB'];
            
        $ilDB->manipulate("DELETE FROM " . $this->properties->getTable() .
            " WHERE " . $this->properties->buildPrimaryWhere());
 
        // enables subtables
        $this->properties->afterDelete();
    }
}