ILIAS  release_8 Revision v8.24
ilADTMultiDBBridge Class Reference
+ Inheritance diagram for ilADTMultiDBBridge:
+ Collaboration diagram for ilADTMultiDBBridge:

Public Member Functions

 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...
 
 afterUpdate ()
 After update hook to enable sub-tables. More...
 
 afterDelete ()
 After delete hook to enable sub-tables. More...
 
- 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 ( )

After delete hook to enable sub-tables.

Reimplemented from ilADTDBBridge.

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 ( )

After insert hook to enable sub-tables.

Reimplemented from ilADTDBBridge.

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

36 : void
37 {
38 $this->afterUpdate();
39 }
afterUpdate()
After update hook to enable sub-tables.

References afterUpdate().

+ Here is the call graph for this function:

◆ afterUpdate()

ilADTMultiDBBridge::afterUpdate ( )

After update hook to enable sub-tables.

Reimplemented from ilADTDBBridge.

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

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 }

Referenced by afterInsert().

+ 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.

10 : string
11 {
12 // getElementId? => adv_md_values_enum_123
13 return $this->getTable() . "_" . $this->getElementId();
14 }
getElementId()
Get element id.

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

Referenced by readRecord().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ prepareInsert()

ilADTMultiDBBridge::prepareInsert ( array &  $a_fields)

Prepare ADT values for insert.

Parameters
array&$a_fields

Reimplemented from ilADTDBBridge.

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".

Reimplemented in ilADTMultiTextDBBridge.

◆ readMultiRecord()

ilADTMultiDBBridge::readMultiRecord ( ilDBStatement  $a_set)
abstractprotected

Import record-rows from sub-table.

Parameters
object$a_set

Reimplemented in ilADTMultiTextDBBridge.

Referenced by readRecord().

+ Here is the caller graph for this function:

◆ readRecord()

ilADTMultiDBBridge::readRecord ( array  $a_row)

Import DB values to ADT.

Parameters
array$a_row

Reimplemented from ilADTDBBridge.

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

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.
readMultiRecord(ilDBStatement $a_set)
Import record-rows from sub-table.
getSubTableName()
Build sub-table name.

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

+ Here is the call graph for this function:

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