ilADTMultiDBBridge Class Reference

Inheritance diagram for ilADTMultiDBBridge:

Collaboration diagram for ilADTMultiDBBridge:

Public Member Functions
	readRecord (array $a_row)
	prepareInsert (array &$a_fields)
	afterInsert ()
	afterUpdate ()
	afterDelete ()
Public Member Functions inherited from ilADTDBBridge
	__construct (ilADT $a_adt)
	Constructor. More...
	getADT ()
	Get ADT. More...
	setTable ($a_table)
	Set table name. More...
	getTable ()
	Get table name. More...
	setElementId ($a_value)
	Set element id (aka DB column[s] [prefix]) More...
	getElementId ()
	Get element id. More...
	setPrimary (array $a_value)
	Set primary fields (in MDB2 format) More...
	getPrimary ()
	Get primary fields. More...
	buildPrimaryWhere ()
	Convert primary keys array to sql string. More...
	readRecord (array $a_row)
	Import DB values to ADT. More...
	prepareInsert (array &$a_fields)
	Prepare ADT values for insert. More...
	afterInsert ()
	After insert hook to enable sub-tables. More...
	prepareUpdate (array &$a_fields)
	Prepare ADT values for update. More...
	afterUpdate ()
	After update hook to enable sub-tables. More...
	afterDelete ()
	After delete hook to enable sub-tables. More...

Protected Member Functions
	getSubTableName ()
	Build sub-table name. More...
	readMultiRecord ($a_set)
	Import record-rows from sub-table. More...
	prepareMultiInsert ()
	Build insert-fields for each "value". More...
Protected Member Functions inherited from ilADTDBBridge
	isValidADT (ilADT $a_adt)
	Check if given ADT is valid. More...
	setADT (ilADT $a_adt)
	Set ADT. More...

Additional Inherited Members
Protected Attributes inherited from ilADTDBBridge
	$adt
	$table
	$id
	$primary = []

Detailed Description

Definition at line 5 of file class.ilADTMultiDBBridge.php.

Member Function Documentation

afterDelete()

ilADTMultiDBBridge::afterDelete

(

)

Definition at line 75 of file class.ilADTMultiDBBridge.php.

References $DIC, $ilDB, ilADTDBBridge\buildPrimaryWhere(), and getSubTableName().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $ilDB->manipulate("DELETE FROM " . $this->getSubTableName() .
            " WHERE " . $this->buildPrimaryWhere());
    }

Here is the call graph for this function:

afterInsert()

ilADTMultiDBBridge::afterInsert

(

)

Definition at line 45 of file class.ilADTMultiDBBridge.php.

References afterUpdate().

    {
        $this->afterUpdate();
    }

Here is the call graph for this function:

afterUpdate()

ilADTMultiDBBridge::afterUpdate

(

)

Definition at line 50 of file class.ilADTMultiDBBridge.php.

References $DIC, $ilDB, ilADTDBBridge\buildPrimaryWhere(), ilADTDBBridge\getPrimary(), getSubTableName(), and prepareMultiInsert().

Referenced by afterInsert().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        // :TODO: build diff, save difference
        
        $ilDB->manipulate("DELETE FROM " . $this->getSubTableName() .
            " WHERE " . $this->buildPrimaryWhere());
        
        foreach ($this->prepareMultiInsert() as $sub_items) {
            $fields = array_merge($this->getPrimary(), $sub_items);
            
            $ilDB->insert($this->getSubTableName(), $fields);
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getSubTableName()

ilADTMultiDBBridge::getSubTableName ( )

protected

Build sub-table name.

Returns

string

Definition at line 14 of file class.ilADTMultiDBBridge.php.

References ilADTDBBridge\getElementId(), and ilADTDBBridge\getTable().

Referenced by afterDelete(), afterUpdate(), readRecord(), and ilADTMultiEnumDBBridge\readRecord().

    {
        return $this->getTable() . "_" . $this->getElementId();
    }

Here is the call graph for this function:

Here is the caller graph for this function:

prepareInsert()

ilADTMultiDBBridge::prepareInsert

(

array &

$a_fields

)

Definition at line 40 of file class.ilADTMultiDBBridge.php.

    {
        // see afterUpdate()
    }

prepareMultiInsert()

ilADTMultiDBBridge::prepareMultiInsert ( )

abstractprotected

Build insert-fields for each "value".

Returns

array

Referenced by afterUpdate().

Here is the caller graph for this function:

readMultiRecord()

ilADTMultiDBBridge::readMultiRecord (   $a_set )

abstractprotected

Import record-rows from sub-table.

Parameters

object

$a_set

Referenced by readRecord().

Here is the caller graph for this function:

readRecord()

ilADTMultiDBBridge::readRecord

(

array

$a_row

)

Definition at line 19 of file class.ilADTMultiDBBridge.php.

References $DIC, $ilDB, ilADTDBBridge\buildPrimaryWhere(), ilADTDBBridge\getElementId(), getSubTableName(), and readMultiRecord().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
                
        $sql = "SELECT " . $this->getElementId() .
            " FROM " . $this->getSubTableName() .
            " WHERE " . $this->buildPrimaryWhere();
        $set = $ilDB->query($sql);
        
        $this->readMultiRecord($set);
    }

Here is the call graph for this function:

---

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

• Services/ADT/classes/Bridges/class.ilADTMultiDBBridge.php