ilADTActiveRecord Class Reference

ADT Active Record helper class. More...

Collaboration diagram for ilADTActiveRecord:

Public Member Functions
	__construct (ilADTGroupDBBridge $a_properties)
	Constructor. More...
	read ()
	Read record. More...
	create ()
	Create/insert record. More...
	update ()
	Update record. More...
	delete ()
	Delete record. More...

Protected Attributes
	$properties

Detailed Description

ADT Active Record helper class.

This class expects a valid primary for all actions!

Author

Jörg Lützenkirchen luetz.nosp@m.enki.nosp@m.rchen.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Version

$Id$

Definition at line 13 of file class.ilADTActiveRecord.php.

Constructor & Destructor Documentation

__construct()

ilADTActiveRecord::__construct

(

ilADTGroupDBBridge

$a_properties

)

Constructor.

Parameters

ilADTGroupDBBridge

$a_properties

Returns

self

Definition at line 23 of file class.ilADTActiveRecord.php.

        {
                $this->properties = $a_properties;
        }

Member Function Documentation

create()

ilADTActiveRecord::create

(

)

Create/insert record.

Definition at line 55 of file class.ilADTActiveRecord.php.

        {
                global $ilDB;
                        
                $fields = $this->properties->getPrimary();
                $this->properties->prepareInsert($fields);      
                                        
                $ilDB->insert($this->properties->getTable(), $fields);
                
                // enables subtables
                $this->properties->afterInsert();               
        }

References $ilDB.

delete()

ilADTActiveRecord::delete

(

)

Delete record.

Definition at line 88 of file class.ilADTActiveRecord.php.

        {
                global $ilDB;
                        
                $ilDB->manipulate("DELETE FROM ".$this->properties->getTable().
                        " WHERE ".$this->properties->buildPrimaryWhere());
 
                // enables subtables
                $this->properties->afterDelete();                       
        }       

References $ilDB.

read()

ilADTActiveRecord::read

(

)

Read record.

Returns

boolean

Definition at line 33 of file class.ilADTActiveRecord.php.

        {               
                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;
        }

References $ilDB, and $row.

update()

ilADTActiveRecord::update

(

)

Update record.

Definition at line 71 of file class.ilADTActiveRecord.php.

        {
                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();               
        }

References $ilDB.

Field Documentation

$properties

ilADTActiveRecord::$properties

protected

Definition at line 15 of file class.ilADTActiveRecord.php.

---

The documentation for this class was generated from the following file:

• Services/ADT/classes/ActiveRecord/class.ilADTActiveRecord.php