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.

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

References $DIC.

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