1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
|
<?php
/**
* PHPPgAdmin 6.0.0
*/
namespace PHPPgAdmin\Database;
/**
* @file
* PostgreSQL 9.6 support
*/
class Postgres96 extends Postgres
{
public $typIndexes = ['BTREE', 'BRIN', 'RTREE', 'GIST', 'GIN', 'HASH', 'SP-GIST'];
/**
* @var float
*/
public $major_version = 9.6;
/**
* @var class-string
*/
public $help_classname = \PHPPgAdmin\Help\PostgresDoc96::class;
// Administration functions
/**
* Returns all available process information.
*
* @param null|string $database (optional) Find only connections to specified database
*
* @return int|\PHPPgAdmin\ADORecordSet A recordset
*/
public function getProcesses($database = null)
{
if (null === $database) {
$sql = "SELECT datid, datname, pid, usename, application_name, client_addr, state, wait_event_type, wait_event, state_change as query_start,
CASE
WHEN state='active' THEN query
ELSE state
END AS query
FROM pg_catalog.pg_stat_activity
ORDER BY datname, usename, pid";
} else {
$this->clean($database);
$sql = "SELECT datid, datname, pid, usename, application_name, client_addr, state, wait_event_type, wait_event, state_change as query_start,
CASE
WHEN state='active' THEN query
ELSE state
END AS query
FROM pg_catalog.pg_stat_activity
WHERE datname='{$database}'
ORDER BY usename, pid";
}
return $this->selectSet($sql);
}
public function hasUserSignals()
{
return true;
}
/**
* Creates a new user. As of PG 9.6, CREATEUSER privilege has been deprecated.
*
* @see {@link https://www.postgresql.org/docs/9.6/static/sql-createrole.html}
*
* @param string $username The username of the user to create
* @param string $password A password for the user
* @param bool $createdb boolean Whether or not the user can create databases
* @param bool $createrole boolean Whether or not the user can create other users
* @param string $expiry string Format 'YYYY-MM-DD HH:MM:SS'. '' means never expire
* @param array $groups The groups to create the user in
*
* @return int|\PHPPgAdmin\ADORecordSet 0 if operation was successful
*
* @internal param $group (array) The groups to create the user in
*/
public function createUser($username, $password, $createdb, $createrole, $expiry, $groups)
{
$enc = $this->_encryptPassword($username, $password);
$this->fieldClean($username);
$this->clean($enc);
$this->clean($expiry);
$this->fieldArrayClean($groups);
$sql = "CREATE USER \"{$username}\"";
if ('' !== $password) {
$sql .= " WITH ENCRYPTED PASSWORD '{$enc}'";
}
$sql .= $createdb ? ' CREATEDB' : ' NOCREATEDB';
$sql .= $createrole ? ' CREATEROLE' : ' NOCREATEROLE';
if (\is_array($groups) && 0 < \count($groups)) {
$sql .= ' IN GROUP "' . \implode('", "', $groups) . '"';
}
if ('' !== $expiry) {
$sql .= " VALID UNTIL '{$expiry}'";
} else {
$sql .= " VALID UNTIL 'infinity'";
}
return $this->execute($sql);
}
}
|
