ilDBPdoManagerPostgres Class Reference

Class ilDBPdoManager. More...

Inheritance diagram for ilDBPdoManagerPostgres:

Collaboration diagram for ilDBPdoManagerPostgres:

Public Member Functions
	getQueryUtils ()
	getTableCreationQuery ($name, $fields, $options=array())
	createTable ($name, $fields, $options=array())
	listTables ($database=null)
	createDatabase ($name)
	dropDatabase ($name)
	listTableFields ($table)
	listTableIndexes ($table)
	listTableConstraints ($table)
	createSequence ($seq_name, $start=1, $options=array())
	dropSequence ($seq_name)
	dropIndex ($table, $name)
	listSequences ($database=null)
	dropConstraint ($table, $name, $primary=false)
Public Member Functions inherited from ilDBPdoManager
	__construct (\PDO $pdo, ilDBPdo $db_instance)
	ilDBPdoManager constructor. More...
	getQueryUtils ()
	getDBInstance ()
	listTables ($database=null)
	listSequences ($database=null)
	createConstraint ($table, $name, $definition)
	createSequence ($seq_name, $start=1, $options=array())
	alterTable ($name, $changes, $check)
	createTable ($name, $fields, $options=array())
	getIndexName ($idx)
	getSequenceName ($sqn)
	listTableFields ($table)
	listTableConstraints ($table)
	listTableIndexes ($table)
	createIndex ($table, $name, $definition)
	dropIndex ($table, $name)
	dropSequence ($table_name)
	getTableCreationQuery ($name, $fields, $options=array())
	dropConstraint ($table, $name, $primary=false)
	dropTable ($name)
	Parameters $name Table-name Returns mixed More...

Protected Member Functions
	fixIndexName ($idx)
Protected Member Functions inherited from ilDBPdoManager
	fixSequenceName ($sqn, $check=false)
	fixIndexName ($idx)

Additional Inherited Members
Protected Attributes inherited from ilDBPdoManager
	$pdo
	$db_instance
	$query_utils

Detailed Description

Class ilDBPdoManager.

Author

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

Definition at line 8 of file class.ilDBPdoManagerPostgres.php.

Member Function Documentation

createDatabase()

ilDBPdoManagerPostgres::createDatabase

(

$name

)

Parameters

$name

Returns

mixed

Definition at line 77 of file class.ilDBPdoManagerPostgres.php.

References ilDBPdoManager\$db_instance, and $name.

    {
        $db = $this->db_instance;
        $name = $db->quoteIdentifier($name, true);

        return $db->manipulate("CREATE DATABASE $name");
    }

createSequence()

ilDBPdoManagerPostgres::createSequence	(		$seq_name,
			$start = 1,
			$options = array()
	)

Parameters

	$seq_name
int	$start
array	$options

Returns

mixed

Implements ilDBManager.

Definition at line 276 of file class.ilDBPdoManagerPostgres.php.

References ilDBPdoManager\$db_instance.

    {
        $db = $this->db_instance;

        $sequence_name = $db->quoteIdentifier($db->getSequenceName($seq_name), true);

        return $db->manipulate("CREATE SEQUENCE $sequence_name INCREMENT 1" . ($start < 1 ? " MINVALUE $start" : '') . " START $start");
    }

createTable()

ilDBPdoManagerPostgres::createTable	(		$name,
			$fields,
			$options = array()
	)

Parameters

	$name
	$fields
array	$options

Returns

int

Definition at line 43 of file class.ilDBPdoManagerPostgres.php.

References $name, and getQueryUtils().

    {
        return $this->pdo->exec($this->getQueryUtils()->createTable($name, $fields, $options));
    }

Here is the call graph for this function:

dropConstraint()

ilDBPdoManagerPostgres::dropConstraint	(		$table,
			$name,
			$primary = false
	)

Parameters

	$table
	$name
bool	$primary

Returns

int

Implements ilDBManager.

Definition at line 363 of file class.ilDBPdoManagerPostgres.php.

References $name, ilDBPdoManager\getDBInstance(), and ilDBPdoManager\getIndexName().

    {
        $table_quoted = $this->getDBInstance()->quoteIdentifier($table, true);
        $name = $this->getDBInstance()->quoteIdentifier($table . '_' . $this->getDBInstance()->getIndexName($name), true);

        return $this->pdo->exec("ALTER TABLE $table_quoted DROP CONSTRAINT $name");
    }

Here is the call graph for this function:

dropDatabase()

ilDBPdoManagerPostgres::dropDatabase

(

$name

)

Parameters

$name

Returns

mixed

Definition at line 90 of file class.ilDBPdoManagerPostgres.php.

References ilDBPdoManager\$db_instance, $name, $query, $result, ilDBPdoManager\alterTable(), ilDBPdoManager\getIndexName(), listTableConstraints(), listTableIndexes(), and ilDBConstants\MODULE_REVERSE.

    {
        $db = $this->db_instance;

        $name = $db->quoteIdentifier($name, true);

        return $db->manipulate("DROP DATABASE $name");
    }

Here is the call graph for this function:

dropIndex()

ilDBPdoManagerPostgres::dropIndex	(		$table,
			$name
	)

Parameters

$table
$name

Returns

mixed

Implements ilDBManager.

Definition at line 305 of file class.ilDBPdoManagerPostgres.php.

References ilDBPdoManager\$db_instance, $name, ilDBPdoManager\getDBInstance(), and ilDBPdoManager\getIndexName().

    {
        $db = $this->db_instance;

        $name = $this->getIndexName($name);
        $name = $db->quoteIdentifier($this->getDBInstance()->constraintName($table, $name), true);

        return $db->manipulate("DROP INDEX $name");
    }

Here is the call graph for this function:

dropSequence()

ilDBPdoManagerPostgres::dropSequence

(

$seq_name

)

Parameters

$seq_name

Returns

mixed

Implements ilDBManager.

Definition at line 290 of file class.ilDBPdoManagerPostgres.php.

References ilDBPdoManager\$db_instance.

    {
        $db = $this->db_instance;

        $sequence_name = $db->quoteIdentifier($db->getSequenceName($seq_name), true);

        return $db->manipulate("DROP SEQUENCE $sequence_name");
    }

fixIndexName()

ilDBPdoManagerPostgres::fixIndexName (   $idx )

protected

Parameters

$idx

Returns

mixed

Definition at line 320 of file class.ilDBPdoManagerPostgres.php.

References ilDBPdoFieldDefinition\INDEX_FORMAT.

Referenced by listTableConstraints(), and listTableIndexes().

    {
        $idx_pattern = '/^' . preg_replace('/%s/', '([a-z0-9_]+)', ilDBPdoFieldDefinition::INDEX_FORMAT) . '$/i';
        $idx_name = preg_replace($idx_pattern, '\\1', $idx);
        if ($idx_name && !strcasecmp($idx, $this->db_instance->getIndexName($idx_name))) {
            return $idx_name;
        }

        return $idx;
    }

Here is the caller graph for this function:

getQueryUtils()

ilDBPdoManagerPostgres::getQueryUtils

(

)

Returns

Definition at line 14 of file class.ilDBPdoManagerPostgres.php.

References ilDBPdoManager\$query_utils.

Referenced by createTable(), and getTableCreationQuery().

    {
        if (!$this->query_utils) {
            $this->query_utils = new ilPostgresQueryUtils($this->db_instance);
        }

        return $this->query_utils;
    }

Here is the caller graph for this function:

getTableCreationQuery()

ilDBPdoManagerPostgres::getTableCreationQuery	(		$name,
			$fields,
			$options = array()
	)

Parameters

	$name
	$fields
array	$options

Returns

string

Exceptions

Definition at line 31 of file class.ilDBPdoManagerPostgres.php.

References $name, and getQueryUtils().

    {
        return $this->getQueryUtils()->createTable($name, $fields, $options);
    }

Here is the call graph for this function:

listSequences()

ilDBPdoManagerPostgres::listSequences

(

$database = null

)

Parameters

null

$database

Returns

array

Implements ilDBManager.

Definition at line 336 of file class.ilDBPdoManagerPostgres.php.

References ilDBPdoManager\$db_instance, $query, $result, and ilDBPdoManager\fixSequenceName().

    {
        $db = $this->db_instance;

        $query = "SELECT relname FROM pg_class WHERE relkind = 'S' AND relnamespace IN";
        $query .= "(SELECT oid FROM pg_namespace WHERE nspname NOT LIKE 'pg_%' AND nspname != 'information_schema')";
        $table_names = $db->queryCol($query);

        $result = array();
        foreach ($table_names as $table_name) {
            $result[] = $this->fixSequenceName($table_name);
        }
        if ($db->options['portability']) {
            $result = array_map(($db->options['field_case'] == CASE_LOWER ? 'strtolower' : 'strtoupper'), $result);
        }
        sort($result); // FSX patch

        return $result;
    }

Here is the call graph for this function:

listTableConstraints()

ilDBPdoManagerPostgres::listTableConstraints

(

$table

)

Parameters

$table

Returns

array

Implements ilDBManager.

Definition at line 242 of file class.ilDBPdoManagerPostgres.php.

References ilDBPdoManager\$db_instance, $query, $result, and fixIndexName().

Referenced by dropDatabase().

    {
        $db = $this->db_instance;

        $table = $db->quote($table, 'text');
        $subquery = "SELECT indexrelid FROM pg_index, pg_class";
        $subquery .= " WHERE pg_class.relname=$table AND pg_class.oid=pg_index.indrelid AND (indisunique = 't' OR indisprimary = 't')";
        $query = "SELECT relname FROM pg_class WHERE oid IN ($subquery)";
        $constraints = $db->queryCol($query);

        $result = array();
        foreach ($constraints as $constraint) {
            $constraint = $this->fixIndexName($constraint);
            if (!empty($constraint)) {
                $result[$constraint] = true;
            }
        }

        if ($db->options['portability']
            && $db->options['field_case'] == CASE_LOWER
        ) {
            $result = array_change_key_case($result, $db->options['field_case']);
        }

        return array_keys($result);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

listTableFields()

ilDBPdoManagerPostgres::listTableFields

(

$table

)

Parameters

$table

Returns

array

Implements ilDBManager.

Definition at line 195 of file class.ilDBPdoManagerPostgres.php.

References $data, ilDBPdoManager\$db_instance, $i, and $res.

    {
        $db = $this->db_instance;

        $table = $db->quoteIdentifier($table, true);
        $res = $this->pdo->query("select * from $table");
        for ($i = 0; $i < $res->columnCount(); $i++) {
            $data[] = $res->getColumnMeta($i)["name"];
        }
        return $data;
    }

listTableIndexes()

ilDBPdoManagerPostgres::listTableIndexes

(

$table

)

Parameters

$table

Returns

array

Implements ilDBManager.

Definition at line 212 of file class.ilDBPdoManagerPostgres.php.

References ilDBPdoManager\$db_instance, $index, $query, $result, and fixIndexName().

Referenced by dropDatabase().

    {
        $db = $this->db_instance;

        $table = $db->quote($table, 'text');
        $subquery = "SELECT indexrelid FROM pg_index, pg_class";
        $subquery .= " WHERE pg_class.relname=$table AND pg_class.oid=pg_index.indrelid AND indisunique != 't' AND indisprimary != 't'";
        $query = "SELECT relname FROM pg_class WHERE oid IN ($subquery)";
        $indexes = $db->queryCol($query, 'text');

        $result = array();
        foreach ($indexes as $index) {
            $index = $this->fixIndexName($index);
            if (!empty($index)) {
                $result[$index] = true;
            }
        }

        if ($db->options['portability']) {
            $result = array_change_key_case($result, $db->options['field_case']);
        }

        return array_keys($result);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

listTables()

ilDBPdoManagerPostgres::listTables

(

$database = null

)

Parameters

null

$database

Returns

array

Implements ilDBManager.

Definition at line 53 of file class.ilDBPdoManagerPostgres.php.

References ilDBPdoManager\$db_instance, $query, $result, and ilDBConstants\FETCHMODE_ASSOC.

    {
        $db = $this->db_instance;

        // gratuitously stolen from PEAR DB _getSpecialQuery in pgsql.php
        $query = 'SELECT c.relname AS "Name"' . ' FROM pg_class c, pg_user u' . ' WHERE c.relowner = u.usesysid' . " AND c.relkind = 'r'"
            . ' AND NOT EXISTS' . ' (SELECT 1 FROM pg_views' . '  WHERE viewname = c.relname)' . " AND c.relname !~ '^(pg_|sql_)'" . ' UNION'
            . ' SELECT c.relname AS "Name"' . ' FROM pg_class c' . " WHERE c.relkind = 'r'" . ' AND NOT EXISTS' . ' (SELECT 1 FROM pg_views'
            . '  WHERE viewname = c.relname)' . ' AND NOT EXISTS' . ' (SELECT 1 FROM pg_user' . '  WHERE usesysid = c.relowner)'
            . " AND c.relname !~ '^pg_'";
        $result = $db->queryCol($query, ilDBConstants::FETCHMODE_ASSOC);

        if ($db->options['portability']) {
            $result = array_map(($db->options['field_case'] == CASE_LOWER ? 'strtolower' : 'strtoupper'), $result);
        }
        sort($result); // FSX Patch
        return $result;
    }

---

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

• Services/Database/classes/PDO/Manager/class.ilDBPdoManagerPostgres.php