| 148 |
lars |
1 |
<?php
|
|
|
2 |
|
|
|
3 |
/*
|
|
|
4 |
* This file is part of the Symfony package.
|
|
|
5 |
*
|
|
|
6 |
* (c) Fabien Potencier <fabien@symfony.com>
|
|
|
7 |
*
|
|
|
8 |
* For the full copyright and license information, please view the LICENSE
|
|
|
9 |
* file that was distributed with this source code.
|
|
|
10 |
*/
|
|
|
11 |
|
|
|
12 |
namespace Symfony\Component\VarDumper\Caster;
|
|
|
13 |
|
|
|
14 |
use Symfony\Component\VarDumper\Cloner\Stub;
|
|
|
15 |
|
|
|
16 |
/**
|
|
|
17 |
* Casts pqsql resources to array representation.
|
|
|
18 |
*
|
|
|
19 |
* @author Nicolas Grekas <p@tchwork.com>
|
|
|
20 |
*
|
|
|
21 |
* @final
|
|
|
22 |
*/
|
|
|
23 |
class PgSqlCaster
|
|
|
24 |
{
|
|
|
25 |
private const PARAM_CODES = [
|
|
|
26 |
'server_encoding',
|
|
|
27 |
'client_encoding',
|
|
|
28 |
'is_superuser',
|
|
|
29 |
'session_authorization',
|
|
|
30 |
'DateStyle',
|
|
|
31 |
'TimeZone',
|
|
|
32 |
'IntervalStyle',
|
|
|
33 |
'integer_datetimes',
|
|
|
34 |
'application_name',
|
|
|
35 |
'standard_conforming_strings',
|
|
|
36 |
];
|
|
|
37 |
|
|
|
38 |
private const TRANSACTION_STATUS = [
|
|
|
39 |
\PGSQL_TRANSACTION_IDLE => 'PGSQL_TRANSACTION_IDLE',
|
|
|
40 |
\PGSQL_TRANSACTION_ACTIVE => 'PGSQL_TRANSACTION_ACTIVE',
|
|
|
41 |
\PGSQL_TRANSACTION_INTRANS => 'PGSQL_TRANSACTION_INTRANS',
|
|
|
42 |
\PGSQL_TRANSACTION_INERROR => 'PGSQL_TRANSACTION_INERROR',
|
|
|
43 |
\PGSQL_TRANSACTION_UNKNOWN => 'PGSQL_TRANSACTION_UNKNOWN',
|
|
|
44 |
];
|
|
|
45 |
|
|
|
46 |
private const RESULT_STATUS = [
|
|
|
47 |
\PGSQL_EMPTY_QUERY => 'PGSQL_EMPTY_QUERY',
|
|
|
48 |
\PGSQL_COMMAND_OK => 'PGSQL_COMMAND_OK',
|
|
|
49 |
\PGSQL_TUPLES_OK => 'PGSQL_TUPLES_OK',
|
|
|
50 |
\PGSQL_COPY_OUT => 'PGSQL_COPY_OUT',
|
|
|
51 |
\PGSQL_COPY_IN => 'PGSQL_COPY_IN',
|
|
|
52 |
\PGSQL_BAD_RESPONSE => 'PGSQL_BAD_RESPONSE',
|
|
|
53 |
\PGSQL_NONFATAL_ERROR => 'PGSQL_NONFATAL_ERROR',
|
|
|
54 |
\PGSQL_FATAL_ERROR => 'PGSQL_FATAL_ERROR',
|
|
|
55 |
];
|
|
|
56 |
|
|
|
57 |
private const DIAG_CODES = [
|
|
|
58 |
'severity' => \PGSQL_DIAG_SEVERITY,
|
|
|
59 |
'sqlstate' => \PGSQL_DIAG_SQLSTATE,
|
|
|
60 |
'message' => \PGSQL_DIAG_MESSAGE_PRIMARY,
|
|
|
61 |
'detail' => \PGSQL_DIAG_MESSAGE_DETAIL,
|
|
|
62 |
'hint' => \PGSQL_DIAG_MESSAGE_HINT,
|
|
|
63 |
'statement position' => \PGSQL_DIAG_STATEMENT_POSITION,
|
|
|
64 |
'internal position' => \PGSQL_DIAG_INTERNAL_POSITION,
|
|
|
65 |
'internal query' => \PGSQL_DIAG_INTERNAL_QUERY,
|
|
|
66 |
'context' => \PGSQL_DIAG_CONTEXT,
|
|
|
67 |
'file' => \PGSQL_DIAG_SOURCE_FILE,
|
|
|
68 |
'line' => \PGSQL_DIAG_SOURCE_LINE,
|
|
|
69 |
'function' => \PGSQL_DIAG_SOURCE_FUNCTION,
|
|
|
70 |
];
|
|
|
71 |
|
|
|
72 |
public static function castLargeObject($lo, array $a, Stub $stub, bool $isNested)
|
|
|
73 |
{
|
|
|
74 |
$a['seek position'] = pg_lo_tell($lo);
|
|
|
75 |
|
|
|
76 |
return $a;
|
|
|
77 |
}
|
|
|
78 |
|
|
|
79 |
public static function castLink($link, array $a, Stub $stub, bool $isNested)
|
|
|
80 |
{
|
|
|
81 |
$a['status'] = pg_connection_status($link);
|
|
|
82 |
$a['status'] = new ConstStub(\PGSQL_CONNECTION_OK === $a['status'] ? 'PGSQL_CONNECTION_OK' : 'PGSQL_CONNECTION_BAD', $a['status']);
|
|
|
83 |
$a['busy'] = pg_connection_busy($link);
|
|
|
84 |
|
|
|
85 |
$a['transaction'] = pg_transaction_status($link);
|
|
|
86 |
if (isset(self::TRANSACTION_STATUS[$a['transaction']])) {
|
|
|
87 |
$a['transaction'] = new ConstStub(self::TRANSACTION_STATUS[$a['transaction']], $a['transaction']);
|
|
|
88 |
}
|
|
|
89 |
|
|
|
90 |
$a['pid'] = pg_get_pid($link);
|
|
|
91 |
$a['last error'] = pg_last_error($link);
|
|
|
92 |
$a['last notice'] = pg_last_notice($link);
|
|
|
93 |
$a['host'] = pg_host($link);
|
|
|
94 |
$a['port'] = pg_port($link);
|
|
|
95 |
$a['dbname'] = pg_dbname($link);
|
|
|
96 |
$a['options'] = pg_options($link);
|
|
|
97 |
$a['version'] = pg_version($link);
|
|
|
98 |
|
|
|
99 |
foreach (self::PARAM_CODES as $v) {
|
|
|
100 |
if (false !== $s = pg_parameter_status($link, $v)) {
|
|
|
101 |
$a['param'][$v] = $s;
|
|
|
102 |
}
|
|
|
103 |
}
|
|
|
104 |
|
|
|
105 |
$a['param']['client_encoding'] = pg_client_encoding($link);
|
|
|
106 |
$a['param'] = new EnumStub($a['param']);
|
|
|
107 |
|
|
|
108 |
return $a;
|
|
|
109 |
}
|
|
|
110 |
|
|
|
111 |
public static function castResult($result, array $a, Stub $stub, bool $isNested)
|
|
|
112 |
{
|
|
|
113 |
$a['num rows'] = pg_num_rows($result);
|
|
|
114 |
$a['status'] = pg_result_status($result);
|
|
|
115 |
if (isset(self::RESULT_STATUS[$a['status']])) {
|
|
|
116 |
$a['status'] = new ConstStub(self::RESULT_STATUS[$a['status']], $a['status']);
|
|
|
117 |
}
|
|
|
118 |
$a['command-completion tag'] = pg_result_status($result, \PGSQL_STATUS_STRING);
|
|
|
119 |
|
|
|
120 |
if (-1 === $a['num rows']) {
|
|
|
121 |
foreach (self::DIAG_CODES as $k => $v) {
|
|
|
122 |
$a['error'][$k] = pg_result_error_field($result, $v);
|
|
|
123 |
}
|
|
|
124 |
}
|
|
|
125 |
|
|
|
126 |
$a['affected rows'] = pg_affected_rows($result);
|
|
|
127 |
$a['last OID'] = pg_last_oid($result);
|
|
|
128 |
|
|
|
129 |
$fields = pg_num_fields($result);
|
|
|
130 |
|
|
|
131 |
for ($i = 0; $i < $fields; ++$i) {
|
|
|
132 |
$field = [
|
|
|
133 |
'name' => pg_field_name($result, $i),
|
|
|
134 |
'table' => sprintf('%s (OID: %s)', pg_field_table($result, $i), pg_field_table($result, $i, true)),
|
|
|
135 |
'type' => sprintf('%s (OID: %s)', pg_field_type($result, $i), pg_field_type_oid($result, $i)),
|
|
|
136 |
'nullable' => (bool) pg_field_is_null($result, $i),
|
|
|
137 |
'storage' => pg_field_size($result, $i).' bytes',
|
|
|
138 |
'display' => pg_field_prtlen($result, $i).' chars',
|
|
|
139 |
];
|
|
|
140 |
if (' (OID: )' === $field['table']) {
|
|
|
141 |
$field['table'] = null;
|
|
|
142 |
}
|
|
|
143 |
if ('-1 bytes' === $field['storage']) {
|
|
|
144 |
$field['storage'] = 'variable size';
|
|
|
145 |
} elseif ('1 bytes' === $field['storage']) {
|
|
|
146 |
$field['storage'] = '1 byte';
|
|
|
147 |
}
|
|
|
148 |
if ('1 chars' === $field['display']) {
|
|
|
149 |
$field['display'] = '1 char';
|
|
|
150 |
}
|
|
|
151 |
$a['fields'][] = new EnumStub($field);
|
|
|
152 |
}
|
|
|
153 |
|
|
|
154 |
return $a;
|
|
|
155 |
}
|
|
|
156 |
}
|