ILIAS  release_8 Revision v8.23
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 ()
 
 setTable (string $a_table)
 
 getTable ()
 
 setElementId (string $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...
 
 getAdditionalPrimaryFields ()
 
 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)
 
 afterUpdate ()
 After update hook to enable sub-tables. More...
 
 afterDelete ()
 After delete hook to enable sub-tables. More...
 
 supportsDefaultValueColumn ()
 true if table storage relies on the default 'value' column More...
 

Protected Member Functions

 getSubTableName ()
 Build sub-table name. More...
 
 readMultiRecord (ilDBStatement $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)
 
 setADT (ilADT $a_adt)
 

Additional Inherited Members

- Protected Attributes inherited from ilADTDBBridge
ilADT $adt
 
string $table
 
string $id
 
array $primary = []
 
ilDBInterface $db
 

Detailed Description

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

Member Function Documentation

◆ afterDelete()

ilADTMultiDBBridge::afterDelete ( )

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

62  : void
63  {
64  // is this in use? Cannot
65  /*
66  $ilDB->manipulate("DELETE FROM " . $this->getSubTableName() .
67  " WHERE " . $this->buildPrimaryWhere());
68  */
69  }

◆ afterInsert()

ilADTMultiDBBridge::afterInsert ( )

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

References afterUpdate().

36  : void
37  {
38  $this->afterUpdate();
39  }
+ Here is the call graph for this function:

◆ afterUpdate()

ilADTMultiDBBridge::afterUpdate ( )

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

References prepareMultiInsert().

Referenced by afterInsert().

41  : void
42  {
43  // :TODO: build diff, save difference
44  // is this in use? Cannot
45  /*
46  $ilDB->manipulate("DELETE FROM " . $this->getSubTableName() .
47  " WHERE " . $this->buildPrimaryWhere());
48 
49  foreach ($this->prepareMultiInsert() as $sub_items) {
50  $fields = array_merge($this->getPrimary(), $sub_items);
51 
52  $ilDB->insert($this->getSubTableName(), $fields);
53  }
54  */
55  }
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ getSubTableName()

ilADTMultiDBBridge::getSubTableName ( )
protected

Build sub-table name.

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

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

Referenced by readRecord().

10  : string
11  {
12  // getElementId? => adv_md_values_enum_123
13  return $this->getTable() . "_" . $this->getElementId();
14  }
getElementId()
Get element id.
+ 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 31 of file class.ilADTMultiDBBridge.php.

31  : void
32  {
33  // see afterUpdate()
34  }

◆ prepareMultiInsert()

ilADTMultiDBBridge::prepareMultiInsert ( )
abstractprotected

Build insert-fields for each "value".

Referenced by afterUpdate().

+ Here is the caller graph for this function:

◆ readMultiRecord()

ilADTMultiDBBridge::readMultiRecord ( ilDBStatement  $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 16 of file class.ilADTMultiDBBridge.php.

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

16  : void
17  {
18  $sql = "SELECT " . $this->getElementId() .
19  " FROM " . $this->getSubTableName() .
20  " WHERE " . $this->buildPrimaryWhere();
21  $set = $this->db->query($sql);
22  $this->readMultiRecord($set);
23  }
buildPrimaryWhere()
Convert primary keys array to sql string.
getSubTableName()
Build sub-table name.
getElementId()
Get element id.
readMultiRecord(ilDBStatement $a_set)
Import record-rows from sub-table.
+ Here is the call graph for this function:

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