ilDBPdoReversePostgres Class Reference

Class ilDBPdoReverse. More...

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)
	getTableFieldDefinition ($table_name, $field_name)
	getTableIndexDefinition ($table, $constraint_name)
	getTableConstraintDefinition ($table, $index_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 @access public

Reimplemented from ilDBPdoReverse.

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

                                                                        {
                $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;
        }

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

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 @access public

@TODO : add support for plsql functions and functions with args

Reimplemented from ilDBPdoReverse.

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

                                                {
                $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);
        }

References ilDBPdoReverse\$db_instance, $query, and 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()

Reimplemented from ilDBPdoReverse.

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

                                                  {
                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;
        }

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

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