ADT Active Record helper class This class expects a valid primary for all actions! More...

Collaboration diagram for ilADTActiveRecord:

Public Member Functions
	__construct (ilADTGroupDBBridge $a_properties)
	Constructor. More...

	read ()
	Read record. More...

	create ()

	update ()

	delete ()

Protected Attributes
ilADTGroupDBBridge	$properties

ilDBInterface	$db

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

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

Constructor & Destructor Documentation

◆ __construct()

ilADTActiveRecord::__construct ( ilADTGroupDBBridge $a_properties )

Constructor.

Parameters

ilADTGroupDBBridge $a_properties

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

References $DIC.

     {
         global $DIC;
 
         $this->db = $DIC->database();
         $this->properties = $a_properties;
     }

Member Function Documentation

◆ create()

ilADTActiveRecord::create ( )

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

                             : void
     {
         $fields = $this->properties->getPrimary();
         $this->properties->prepareInsert($fields);
         $this->db->insert($this->properties->getTable(), $fields);
         $this->properties->afterInsert();
     }

◆ delete()

ilADTActiveRecord::delete ( )

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

                             : void
     {
         $this->db->manipulate("DELETE FROM " . $this->properties->getTable() .
             " WHERE " . $this->properties->buildPrimaryWhere());
         $this->properties->afterDelete();
     }

◆ read()

ilADTActiveRecord::read ( )

Read record.

Returns: bool

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

                           : bool
     {
         // reset all group elements
         $this->properties->getADT()->reset();
 
         $sql = "SELECT * FROM " . $this->properties->getTable() .
             " WHERE " . $this->properties->buildPrimaryWhere();
         $set = $this->db->query($sql);
         if ($this->db->numRows($set)) {
             $row = $this->db->fetchAssoc($set);
             $this->properties->readRecord($row);
             return true;
         }
         return false;
     }

◆ update()

ilADTActiveRecord::update ( )

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

                             : void
     {
         $fields = array();
         $this->properties->prepareUpdate($fields);
         $this->db->update($this->properties->getTable(), $fields, $this->properties->getPrimary());
         $this->properties->afterUpdate();
     }

Field Documentation

◆ $db

ilDBInterface ilADTActiveRecord::$db

protected

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

◆ $properties

ilADTGroupDBBridge ilADTActiveRecord::$properties