Inheritance diagram for ilDBPdoReversePostgres:

Collaboration diagram for ilDBPdoReversePostgres:

Public Member Functions
	getTableConstraintDefinition ($table, $constraint_name)
	Get the structure of a constraint into an array. More...

	getTriggerDefinition ($trigger)
	Get the structure of a trigger into an array. More...

	tableInfo ($result, $mode=null)
	Returns information about a table or a result set. More...

Public Member Functions inherited from ilDBPdoReverse
	__construct (\PDO $pdo, ilDBPdo $db_instance)
	ilDBPdoReverse constructor. More...

	getQueryUtils ()

	getTableFieldDefinition ($table_name, $field_name)

	getTableIndexDefinition ($table, $index_name)

	getTableConstraintDefinition ($table, $constraint_name)

	getTriggerDefinition ($trigger)

	tableInfo ($result, $mode=null)

Additional Inherited Members
Protected Attributes inherited from ilDBPdoReverse
	$pdo

	$db_instance

	$query_utils

Detailed Description

Class ilDBPdoReverse.

Author: Fabian Schmid fs@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Definition at line 9 of file class.ilDBPdoReversePostgres.php.

Member Function Documentation

◆ getTableConstraintDefinition()

ilDBPdoReversePostgres::getTableConstraintDefinition	(	$table,
		$constraint_name
	)

Get the structure of a constraint into an array.

Parameters

string	$table	name of table that should be used in method
string	$constraint_name	name of constraint that should be used in method

Returns: mixed data array on success, a MDB2 error on failure public

Implements ilDBReverse.

Definition at line 186 of file class.ilDBPdoReversePostgres.php.

References $columns, ilDBPdoReverse\$db_instance, $query, $row, array, ilDBConstants\FETCHMODE_ASSOC, and ilDBConstants\MODULE_MANAGER.

                                                                         {
                 $db = $this->db_instance;
 
                 $query = 'SELECT relname, indisunique, indisprimary, indkey FROM pg_index, pg_class';
                 $query .= ' WHERE pg_class.oid = pg_index.indexrelid';
                 $query .= " AND (indisunique = 't' OR indisprimary = 't')";
                 $query .= ' AND pg_class.relname = %s';
                 $constraint_name_mdb2 = $db->getIndexName($constraint_name);
                 try {
                         $row = $db->queryRow(sprintf($query, $db->quote($constraint_name_mdb2, 'text')), null, ilDBConstants::FETCHMODE_ASSOC);
                 } catch (Exception $e) {
                 }
 
                 if ($e instanceof PDOException || empty($row)) {
                         // fallback to the given $index_name, without transformation
                         $row = $db->queryRow(sprintf($query, $db->quote($constraint_name, 'text')), null, ilDBConstants::FETCHMODE_ASSOC);
                 }
 
                 if (empty($row)) {
                         throw new ilDatabaseException($constraint_name . ' is not an existing table constraint');
                 }
 
                 $row = array_change_key_case($row, CASE_LOWER);
                 $columns = $db->loadModule(ilDBConstants::MODULE_MANAGER)->listTableFields($table);
 
                 $definition = array();
                 if ($row['indisprimary'] == 't') {
                         $definition['primary'] = true;
                 } elseif ($row['indisunique'] == 't') {
                         $definition['unique'] = true;
                 }
 
                 $index_column_numbers = explode(' ', $row['indkey']);
 
                 $colpos = 1;
                 foreach ($index_column_numbers as $number) {
                         $definition['fields'][$columns[($number - 1)]] = array(
                                 'position' => $colpos ++,
                                 'sorting'  => 'ascending',
                         );
                 }
 
                 return $definition;
         }

◆ getTriggerDefinition()

ilDBPdoReversePostgres::getTriggerDefinition ( $trigger )

Get the structure of a trigger into an array.

EXPERIMENTAL

WARNING: this function is experimental and may change the returned value at any time until labelled as non-experimental

Parameters

string $trigger name of trigger that should be used in method

Returns: mixed data array on success, a MDB2 error on failure public

: add support for plsql functions and functions with args

Implements ilDBReverse.

Definition at line 248 of file class.ilDBPdoReversePostgres.php.

References ilDBPdoReverse\$db_instance, $query, array, and MDB2_FETCHMODE_ASSOC.

                                                 {
                 $db = $this->db_instance;
 
                 $query = "SELECT trg.tgname AS trigger_name,
                          tbl.relname AS table_name,
                          CASE
                             WHEN p.proname IS NOT NULL THEN 'EXECUTE PROCEDURE ' || p.proname || '();'
                             ELSE ''
                          END AS trigger_body,
                          CASE trg.tgtype & cast(2 as int2)
                             WHEN 0 THEN 'AFTER'
                             ELSE 'BEFORE'
                          END AS trigger_type,
                          CASE trg.tgtype & cast(28 as int2)
                             WHEN 16 THEN 'UPDATE'
                             WHEN 8 THEN 'DELETE'
                             WHEN 4 THEN 'INSERT'
                             WHEN 20 THEN 'INSERT, UPDATE'
                             WHEN 28 THEN 'INSERT, UPDATE, DELETE'
                             WHEN 24 THEN 'UPDATE, DELETE'
                             WHEN 12 THEN 'INSERT, DELETE'
                          END AS trigger_event,
                          trg.tgenabled AS trigger_enabled,
                          obj_description(trg.oid, 'pg_trigger') AS trigger_comment
                     FROM pg_trigger trg,
                          pg_class tbl,
                          pg_proc p
                    WHERE trg.tgrelid = tbl.oid
                      AND trg.tgfoid = p.oid
                      AND trg.tgname = " . $db->quote($trigger, 'text');
                 $types = array(
                         'trigger_name'    => 'text',
                         'table_name'      => 'text',
                         'trigger_body'    => 'text',
                         'trigger_type'    => 'text',
                         'trigger_event'   => 'text',
                         'trigger_comment' => 'text',
                         'trigger_enabled' => 'boolean',
                 );
 
                 return $db->queryRow($query, $types, MDB2_FETCHMODE_ASSOC);
         }

◆ tableInfo()

ilDBPdoReversePostgres::tableInfo	(	$result,
		$mode = `null`
	)

Returns information about a table or a result set.

NOTE: only supports 'table' and 'flags' if $result is a table name.

Parameters

object \| string	$result	MDB2_result object from a query or a string containing the name of a table. While this also accepts a query result resource identifier, this behavior is deprecated.
int	$mode	a valid tableInfo mode

Returns: array an associative array with the information requested. A MDB2_Error object on failure.

See also: MDB2_Driver_Common::tableInfo()

Implements ilDBReverse.

Definition at line 312 of file class.ilDBPdoReversePostgres.php.

References ilDBPdoReverse\$db_instance, $res, $result, array, PEAR\isError(), MDB2\isResultCommon(), MDB2_ERROR_NEED_MORE_DATA, MDB2_TABLEINFO_ORDER, and MDB2_TABLEINFO_ORDERTABLE.

                                                   {
                 if (is_string($result)) {
                         return parent::tableInfo($result, $mode);
                 }
 
                 $db = $this->db_instance;
 
                 $resource = MDB2::isResultCommon($result) ? $result->getResource() : $result;
                 if (!is_resource($resource)) {
                         return $db->raiseError(MDB2_ERROR_NEED_MORE_DATA, null, null, 'Could not generate result resource', __FUNCTION__);
                 }
 
                 if ($db->options['portability']) {
                         if ($db->options['field_case'] == CASE_LOWER) {
                                 $case_func = 'strtolower';
                         } else {
                                 $case_func = 'strtoupper';
                         }
                 } else {
                         $case_func = 'strval';
                 }
 
                 $count = @pg_num_fields($resource);
                 $res = array();
 
                 if ($mode) {
                         $res['num_fields'] = $count;
                 }
 
                 $db->loadModule('Datatype', null, true);
                 for ($i = 0; $i < $count; $i ++) {
                         $res[$i] = array(
                                 'table'  => function_exists('pg_field_table') ? @pg_field_table($resource, $i) : '',
                                 'name'   => $case_func(@pg_field_name($resource, $i)),
                                 'type'   => @pg_field_type($resource, $i),
                                 'length' => @pg_field_size($resource, $i),
                                 'flags'  => '',
                         );
                         $mdb2type_info = $db->datatype->mapNativeDatatype($res[$i]);
                         if (PEAR::isError($mdb2type_info)) {
                                 return $mdb2type_info;
                         }
                         $res[$i]['mdb2type'] = $mdb2type_info[0][0];
                         if ($mode & MDB2_TABLEINFO_ORDER) {
                                 $res['order'][$res[$i]['name']] = $i;
                         }
                         if ($mode & MDB2_TABLEINFO_ORDERTABLE) {
                                 $res['ordertable'][$res[$i]['table']][$res[$i]['name']] = $i;
                         }
                 }
 
                 return $res;
         }

Here is the call graph for this function:

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

Services/Database/classes/PDO/Reverse/class.ilDBPdoReversePostgres.php

Public Member Functions

Additional Inherited Members

Detailed Description

Member Function Documentation

◆ getTableConstraintDefinition()

◆ getTriggerDefinition()

◆ tableInfo()