Subversion-Projekte lars-tiefland.laravel_shop

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
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
}