Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/HuasoFoundries/phpPgAdmin6.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
path: root/src/database/Postgres83.php
diff options
context:
space:
mode:
Diffstat (limited to 'src/database/Postgres83.php')
-rw-r--r--src/database/Postgres83.php442
1 files changed, 0 insertions, 442 deletions
diff --git a/src/database/Postgres83.php b/src/database/Postgres83.php
deleted file mode 100644
index 583744da..00000000
--- a/src/database/Postgres83.php
+++ /dev/null
@@ -1,442 +0,0 @@
-<?php
-
-/**
- * PHPPgAdmin 6.0.0
- */
-
-namespace PHPPgAdmin\Database;
-
-/**
- * @file
- * PostgreSQL 8.3 support
- *
- * Id: Postgres82.php,v 1.10 2007/12/28 16:21:25 ioguix Exp $
- */
-class Postgres83 extends Postgres84
-{
- public $major_version = 8.3;
-
- // List of all legal privileges that can be applied to different types
- // of objects.
- public $privlist = [
- 'table' => ['SELECT', 'INSERT', 'UPDATE', 'DELETE', 'REFERENCES', 'TRIGGER', 'ALL PRIVILEGES'],
- 'view' => ['SELECT', 'INSERT', 'UPDATE', 'DELETE', 'REFERENCES', 'TRIGGER', 'ALL PRIVILEGES'],
- 'sequence' => ['SELECT', 'UPDATE', 'ALL PRIVILEGES'],
- 'database' => ['CREATE', 'TEMPORARY', 'CONNECT', 'ALL PRIVILEGES'],
- 'function' => ['EXECUTE', 'ALL PRIVILEGES'],
- 'language' => ['USAGE', 'ALL PRIVILEGES'],
- 'schema' => ['CREATE', 'USAGE', 'ALL PRIVILEGES'],
- 'tablespace' => ['CREATE', 'ALL PRIVILEGES'],
- ];
-
- // List of characters in acl lists and the privileges they
- // refer to.
- public $privmap = [
- 'r' => 'SELECT',
- 'w' => 'UPDATE',
- 'a' => 'INSERT',
- 'd' => 'DELETE',
- 'R' => 'RULE',
- 'x' => 'REFERENCES',
- 't' => 'TRIGGER',
- 'X' => 'EXECUTE',
- 'U' => 'USAGE',
- 'C' => 'CREATE',
- 'T' => 'TEMPORARY',
- 'c' => 'CONNECT',
- ];
-
- // Databse functions
-
- /**
- * Return all database available on the server.
- *
- * @param string $currentdatabase database name that should be on top of the resultset
- *
- * @return PHPPgAdmin\ArrayRecordSet A recordset or an error number A list of databases, sorted alphabetically
- */
- public function getDatabases($currentdatabase = null)
- {
- $conf = $this->conf;
- $server_info = $this->server_info;
-
- if (isset($conf['owned_only']) && $conf['owned_only'] && !$this->isSuperUser()) {
- $username = $server_info['username'];
- $this->clean($username);
- $clause = " AND pr.rolname='{$username}'";
- } else {
- $clause = '';
- }
-
- if (null !== $currentdatabase) {
- $this->clean($currentdatabase);
- $orderby = "ORDER BY pdb.datname = '{$currentdatabase}' DESC, pdb.datname";
- } else {
- $orderby = 'ORDER BY pdb.datname';
- }
-
- if (!$conf['show_system']) {
- $where = ' AND NOT pdb.datistemplate';
- } else {
- $where = ' AND pdb.datallowconn';
- }
-
- $sql = "
- SELECT pdb.datname AS datname, pr.rolname AS datowner, pg_encoding_to_char(encoding) AS datencoding,
- (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pdb.oid=pd.objoid AND pd.classoid='pg_database'::regclass) AS datcomment,
- (SELECT spcname FROM pg_catalog.pg_tablespace pt WHERE pt.oid=pdb.dattablespace) AS tablespace,
- pg_catalog.pg_database_size(pdb.oid) as dbsize
- FROM pg_catalog.pg_database pdb LEFT JOIN pg_catalog.pg_roles pr ON (pdb.datdba = pr.oid)
- WHERE true
- {$where}
- {$clause}
- {$orderby}";
-
- return $this->selectSet($sql);
- }
-
- // Administration functions
-
- /**
- * Returns all available autovacuum per table information.
- *
- * @param string $table
- *
- * @return PHPPgAdmin\ArrayRecordSet A recordset
- */
- public function getTableAutovacuum($table = '')
- {
- $sql = '';
-
- if ('' !== $table) {
- $this->clean($table);
- $c_schema = $this->_schema;
- $this->clean($c_schema);
-
- $sql = "
- SELECT vacrelid, nspname, relname,
- CASE enabled
- WHEN 't' THEN 'on'
- ELSE 'off'
- END AS autovacuum_enabled, vac_base_thresh AS autovacuum_vacuum_threshold,
- vac_scale_factor AS autovacuum_vacuum_scale_factor, anl_base_thresh AS autovacuum_analyze_threshold,
- anl_scale_factor AS autovacuum_analyze_scale_factor, vac_cost_delay AS autovacuum_vacuum_cost_delay,
- vac_cost_limit AS autovacuum_vacuum_cost_limit
- FROM pg_autovacuum AS a
- join pg_class AS c on (c.oid=a.vacrelid)
- join pg_namespace AS n on (n.oid=c.relnamespace)
- WHERE c.relname = '{$table}' AND n.nspname = '{$c_schema}'
- ORDER BY nspname, relname
- ";
- } else {
- $sql = "
- SELECT vacrelid, nspname, relname,
- CASE enabled
- WHEN 't' THEN 'on'
- ELSE 'off'
- END AS autovacuum_enabled, vac_base_thresh AS autovacuum_vacuum_threshold,
- vac_scale_factor AS autovacuum_vacuum_scale_factor, anl_base_thresh AS autovacuum_analyze_threshold,
- anl_scale_factor AS autovacuum_analyze_scale_factor, vac_cost_delay AS autovacuum_vacuum_cost_delay,
- vac_cost_limit AS autovacuum_vacuum_cost_limit
- FROM pg_autovacuum AS a
- join pg_class AS c on (c.oid=a.vacrelid)
- join pg_namespace AS n on (n.oid=c.relnamespace)
- ORDER BY nspname, relname
- ";
- }
-
- return $this->selectSet($sql);
- }
-
- /**
- * @param mixed $table
- * @param mixed $vacenabled
- * @param mixed $vacthreshold
- * @param mixed $vacscalefactor
- * @param mixed $anathresold
- * @param mixed $anascalefactor
- * @param mixed $vaccostdelay
- * @param mixed $vaccostlimit
- *
- * @return PHPPgAdmin\ArrayRecordSet
- */
- public function saveAutovacuum(
- $table,
- $vacenabled,
- $vacthreshold,
- $vacscalefactor,
- $anathresold,
- $anascalefactor,
- $vaccostdelay,
- $vaccostlimit
- ) {
- $defaults = $this->getAutovacuum();
- $c_schema = $this->_schema;
- $this->clean($c_schema);
- $this->clean($table);
-
- $rs = $this->selectSet("
- SELECT c.oid
- FROM pg_catalog.pg_class AS c
- LEFT JOIN pg_catalog.pg_namespace AS n ON (n.oid=c.relnamespace)
- WHERE
- c.relname = '{$table}' AND n.nspname = '{$c_schema}'
- ");
-
- if ($rs->EOF) {
- return -1;
- }
-
- $toid = $rs->fields('oid');
- unset($rs);
-
- if (empty($_POST['autovacuum_vacuum_threshold'])) {
- $_POST['autovacuum_vacuum_threshold'] = $defaults['autovacuum_vacuum_threshold'];
- }
-
- if (empty($_POST['autovacuum_vacuum_scale_factor'])) {
- $_POST['autovacuum_vacuum_scale_factor'] = $defaults['autovacuum_vacuum_scale_factor'];
- }
-
- if (empty($_POST['autovacuum_analyze_threshold'])) {
- $_POST['autovacuum_analyze_threshold'] = $defaults['autovacuum_analyze_threshold'];
- }
-
- if (empty($_POST['autovacuum_analyze_scale_factor'])) {
- $_POST['autovacuum_analyze_scale_factor'] = $defaults['autovacuum_analyze_scale_factor'];
- }
-
- if (empty($_POST['autovacuum_vacuum_cost_delay'])) {
- $_POST['autovacuum_vacuum_cost_delay'] = $defaults['autovacuum_vacuum_cost_delay'];
- }
-
- if (empty($_POST['autovacuum_vacuum_cost_limit'])) {
- $_POST['autovacuum_vacuum_cost_limit'] = $defaults['autovacuum_vacuum_cost_limit'];
- }
-
- if (empty($_POST['vacuum_freeze_min_age'])) {
- $_POST['vacuum_freeze_min_age'] = $defaults['vacuum_freeze_min_age'];
- }
-
- if (empty($_POST['autovacuum_freeze_max_age'])) {
- $_POST['autovacuum_freeze_max_age'] = $defaults['autovacuum_freeze_max_age'];
- }
-
- $rs = $this->selectSet("SELECT vacrelid
- FROM \"pg_catalog\".\"pg_autovacuum\"
- WHERE vacrelid = {$toid};");
-
- $status = -1; // ini
- if ($rs->recordCount() && ($rs->fields['vacrelid'] === $toid)) {
- // table exists in pg_autovacuum, UPDATE
- $sql = \sprintf(
- "UPDATE \"pg_catalog\".\"pg_autovacuum\" SET
- enabled = '%s',
- vac_base_thresh = %s,
- vac_scale_factor = %s,
- anl_base_thresh = %s,
- anl_scale_factor = %s,
- vac_cost_delay = %s,
- vac_cost_limit = %s,
- freeze_min_age = %s,
- freeze_max_age = %s
- WHERE vacrelid = {$toid};
- ",
- ('on' === $_POST['autovacuum_enabled']) ? 't' : 'f',
- $_POST['autovacuum_vacuum_threshold'],
- $_POST['autovacuum_vacuum_scale_factor'],
- $_POST['autovacuum_analyze_threshold'],
- $_POST['autovacuum_analyze_scale_factor'],
- $_POST['autovacuum_vacuum_cost_delay'],
- $_POST['autovacuum_vacuum_cost_limit'],
- $_POST['vacuum_freeze_min_age'],
- $_POST['autovacuum_freeze_max_age']
- );
- $status = $this->execute($sql);
- } else {
- // table doesn't exists in pg_autovacuum, INSERT
- $sql = \sprintf(
- "INSERT INTO \"pg_catalog\".\"pg_autovacuum\"
- VALUES (%s, '%s', %s, %s, %s, %s, %s, %s, %s, %s )",
- $toid,
- ('on' === $_POST['autovacuum_enabled']) ? 't' : 'f',
- $_POST['autovacuum_vacuum_threshold'],
- $_POST['autovacuum_vacuum_scale_factor'],
- $_POST['autovacuum_analyze_threshold'],
- $_POST['autovacuum_analyze_scale_factor'],
- $_POST['autovacuum_vacuum_cost_delay'],
- $_POST['autovacuum_vacuum_cost_limit'],
- $_POST['vacuum_freeze_min_age'],
- $_POST['autovacuum_freeze_max_age']
- );
- $status = $this->execute($sql);
- }
-
- return $status;
- }
-
- /**
- * @param mixed $table
- *
- * @return bool|int
- */
- public function dropAutovacuum($table)
- {
- $c_schema = $this->_schema;
- $this->clean($c_schema);
- $this->clean($table);
-
- $rs = $this->selectSet("
- SELECT c.oid
- FROM pg_catalog.pg_class AS c
- LEFT JOIN pg_catalog.pg_namespace AS n ON (n.oid=c.relnamespace)
- WHERE
- c.relname = '{$table}' AND n.nspname = '{$c_schema}'
- ");
-
- return $this->deleteRow('pg_autovacuum', ['vacrelid' => $rs->fields['oid']], 'pg_catalog');
- }
-
- // Sequence functions
-
- /**
- * Alter a sequence's properties.
- *
- * @param \ADORecordSet $seqrs The sequence RecordSet returned by getSequence()
- * @param int $increment The sequence incremental value
- * @param int $minvalue The sequence minimum value
- * @param int $maxvalue The sequence maximum value
- * @param int $restartvalue The sequence current value
- * @param int $cachevalue The sequence cache value
- * @param bool $cycledvalue Sequence can cycle ?
- * @param int $startvalue The sequence start value when issueing a restart (ignored)
- *
- * @return PHPPgAdmin\ArrayRecordSet 0 if operation was successful
- */
- public function alterSequenceProps(
- $seqrs,
- $increment,
- $minvalue,
- $maxvalue,
- $restartvalue,
- $cachevalue,
- $cycledvalue,
- $startvalue
- ) {
- $sql = '';
- /* vars are cleaned in _alterSequence */
- if (!empty($increment) && ($increment !== $seqrs->fields['increment_by'])) {
- $sql .= " INCREMENT {$increment}";
- }
-
- if (!empty($minvalue) && ($minvalue !== $seqrs->fields['min_value'])) {
- $sql .= " MINVALUE {$minvalue}";
- }
-
- if (!empty($maxvalue) && ($maxvalue !== $seqrs->fields['max_value'])) {
- $sql .= " MAXVALUE {$maxvalue}";
- }
-
- if (!empty($restartvalue) && ($restartvalue !== $seqrs->fields['last_value'])) {
- $sql .= " RESTART {$restartvalue}";
- }
-
- if (!empty($cachevalue) && ($cachevalue !== $seqrs->fields['cache_value'])) {
- $sql .= " CACHE {$cachevalue}";
- }
-
- // toggle cycle yes/no
- if (null !== $cycledvalue) {
- $sql .= (!$cycledvalue ? ' NO ' : '') . ' CYCLE';
- }
-
- if ('' !== $sql) {
- $f_schema = $this->_schema;
- $this->fieldClean($f_schema);
- $sql = "ALTER SEQUENCE \"{$f_schema}\".\"{$seqrs->fields['seqname']}\" {$sql}";
-
- return $this->execute($sql);
- }
-
- return 0;
- }
-
- /**
- * Alter a sequence's owner.
- *
- * @param \ADORecordSet $seqrs The sequence RecordSet returned by getSequence()
- * @param string $owner sequence owner
- *
- * @return PHPPgAdmin\ArrayRecordSet 0 if operation was successful
- *
- * @internal param string The $name new owner for the sequence
- */
- public function alterSequenceOwner($seqrs, $owner)
- {
- // If owner has been changed, then do the alteration. We are
- // careful to avoid this generally as changing owner is a
- // superuser only function.
- /* vars are cleaned in _alterSequence */
- if (!empty($owner) && ($seqrs->fields['seqowner'] !== $owner)) {
- $f_schema = $this->_schema;
- $this->fieldClean($f_schema);
- $sql = "ALTER TABLE \"{$f_schema}\".\"{$seqrs->fields['seqname']}\" OWNER TO \"{$owner}\"";
-
- return $this->execute($sql);
- }
-
- return 0;
- }
-
- // Function functions
-
- /**
- * Returns all details for a particular function.
- *
- * @param mixed $function_oid
- *
- * @return PHPPgAdmin\ArrayRecordSet Function info
- *
- * @internal param string $func name of the function to retrieve
- */
- public function getFunction($function_oid)
- {
- $this->clean($function_oid);
-
- $sql = "
- SELECT
- pc.oid AS prooid, proname, pg_catalog.pg_get_userbyid(proowner) AS proowner,
- nspname as proschema, lanname as prolanguage, procost, prorows,
- pg_catalog.format_type(prorettype, NULL) as proresult, prosrc,
- probin, proretset, proisstrict, provolatile, prosecdef,
- pg_catalog.oidvectortypes(pc.proargtypes) AS proarguments,
- proargnames AS proargnames,
- pg_catalog.obj_description(pc.oid, 'pg_proc') AS procomment,
- proconfig
- FROM
- pg_catalog.pg_proc pc, pg_catalog.pg_language pl,
- pg_catalog.pg_namespace pn
- WHERE
- pc.oid = '{$function_oid}'::oid AND pc.prolang = pl.oid
- AND pc.pronamespace = pn.oid
- ";
-
- return $this->selectSet($sql);
- }
-
- // Capabilities
- public function hasQueryKill()
- {
- return false;
- }
-
- public function hasDatabaseCollation()
- {
- return false;
- }
-
- public function hasAlterSequenceStart()
- {
- return false;
- }
-}
generated by cgit v1.2.3 (git 2.25.1) at 2024-05-31 08:46:19 +0300