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...
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)
	getTableFieldDefinition ($table_name, $field_name)
	getTableIndexDefinition ($table, $constraint_name)
	getTableConstraintDefinition ($table, $index_name)
	getTriggerDefinition ($trigger)

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 189 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, $table, ilDBConstants\FETCHMODE_ASSOC, and ilDBConstants\MODULE_MANAGER.

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 252 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, ilDBConstants::FETCHMODE_ASSOC);
    }

References ilDBPdoReverse\$db_instance, $query, and ilDBConstants\FETCHMODE_ASSOC.

---

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

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