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)

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 189 of file class.ilDBPdoReversePostgres.php.

References $columns, ilDBPdoReverse\$db_instance, $query, $row, $table, 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 252 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 317 of file class.ilDBPdoReversePostgres.php.

References ilDBPdoReverse\$db_instance, $i, $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