* * For the full copyright and license information, please view the LICENSE * file that was distributed with this source code. */ namespace Symfony\Component\VarDumper\Caster; use Symfony\Component\VarDumper\Cloner\Stub; /** * Casts pqsql resources to array representation. * * @author Nicolas Grekas */ class PgSqlCaster { private static $paramCodes = array( 'server_encoding', 'client_encoding', 'is_superuser', 'session_authorization', 'DateStyle', 'TimeZone', 'IntervalStyle', 'integer_datetimes', 'application_name', 'standard_conforming_strings', ); private static $transactionStatus = array( PGSQL_TRANSACTION_IDLE => 'PGSQL_TRANSACTION_IDLE', PGSQL_TRANSACTION_ACTIVE => 'PGSQL_TRANSACTION_ACTIVE', PGSQL_TRANSACTION_INTRANS => 'PGSQL_TRANSACTION_INTRANS', PGSQL_TRANSACTION_INERROR => 'PGSQL_TRANSACTION_INERROR', PGSQL_TRANSACTION_UNKNOWN => 'PGSQL_TRANSACTION_UNKNOWN', ); private static $resultStatus = array( PGSQL_EMPTY_QUERY => 'PGSQL_EMPTY_QUERY', PGSQL_COMMAND_OK => 'PGSQL_COMMAND_OK', PGSQL_TUPLES_OK => 'PGSQL_TUPLES_OK', PGSQL_COPY_OUT => 'PGSQL_COPY_OUT', PGSQL_COPY_IN => 'PGSQL_COPY_IN', PGSQL_BAD_RESPONSE => 'PGSQL_BAD_RESPONSE', PGSQL_NONFATAL_ERROR => 'PGSQL_NONFATAL_ERROR', PGSQL_FATAL_ERROR => 'PGSQL_FATAL_ERROR', ); private static $diagCodes = array( 'severity' => PGSQL_DIAG_SEVERITY, 'sqlstate' => PGSQL_DIAG_SQLSTATE, 'message' => PGSQL_DIAG_MESSAGE_PRIMARY, 'detail' => PGSQL_DIAG_MESSAGE_DETAIL, 'hint' => PGSQL_DIAG_MESSAGE_HINT, 'statement position' => PGSQL_DIAG_STATEMENT_POSITION, 'internal position' => PGSQL_DIAG_INTERNAL_POSITION, 'internal query' => PGSQL_DIAG_INTERNAL_QUERY, 'context' => PGSQL_DIAG_CONTEXT, 'file' => PGSQL_DIAG_SOURCE_FILE, 'line' => PGSQL_DIAG_SOURCE_LINE, 'function' => PGSQL_DIAG_SOURCE_FUNCTION, ); public static function castLargeObject($lo, array $a, Stub $stub, $isNested) { $a['seek position'] = pg_lo_tell($lo); return $a; } public static function castLink($link, array $a, Stub $stub, $isNested) { $a['status'] = pg_connection_status($link); $a['status'] = new ConstStub(PGSQL_CONNECTION_OK === $a['status'] ? 'PGSQL_CONNECTION_OK' : 'PGSQL_CONNECTION_BAD', $a['status']); $a['busy'] = pg_connection_busy($link); $a['transaction'] = pg_transaction_status($link); if (isset(self::$transactionStatus[$a['transaction']])) { $a['transaction'] = new ConstStub(self::$transactionStatus[$a['transaction']], $a['transaction']); } $a['pid'] = pg_get_pid($link); $a['last error'] = pg_last_error($link); $a['last notice'] = pg_last_notice($link); $a['host'] = pg_host($link); $a['port'] = pg_port($link); $a['dbname'] = pg_dbname($link); $a['options'] = pg_options($link); $a['version'] = pg_version($link); foreach (self::$paramCodes as $v) { if (false !== $s = pg_parameter_status($link, $v)) { $a['param'][$v] = $s; } } $a['param']['client_encoding'] = pg_client_encoding($link); $a['param'] = new EnumStub($a['param']); return $a; } public static function castResult($result, array $a, Stub $stub, $isNested) { $a['num rows'] = pg_num_rows($result); $a['status'] = pg_result_status($result); if (isset(self::$resultStatus[$a['status']])) { $a['status'] = new ConstStub(self::$resultStatus[$a['status']], $a['status']); } $a['command-completion tag'] = pg_result_status($result, PGSQL_STATUS_STRING); if (-1 === $a['num rows']) { foreach (self::$diagCodes as $k => $v) { $a['error'][$k] = pg_result_error_field($result, $v); } } $a['affected rows'] = pg_affected_rows($result); $a['last OID'] = pg_last_oid($result); $fields = pg_num_fields($result); for ($i = 0; $i < $fields; ++$i) { $field = array( 'name' => pg_field_name($result, $i), 'table' => sprintf('%s (OID: %s)', pg_field_table($result, $i), pg_field_table($result, $i, true)), 'type' => sprintf('%s (OID: %s)', pg_field_type($result, $i), pg_field_type_oid($result, $i)), 'nullable' => (bool) pg_field_is_null($result, $i), 'storage' => pg_field_size($result, $i).' bytes', 'display' => pg_field_prtlen($result, $i).' chars', ); if (' (OID: )' === $field['table']) { $field['table'] = null; } if ('-1 bytes' === $field['storage']) { $field['storage'] = 'variable size'; } elseif ('1 bytes' === $field['storage']) { $field['storage'] = '1 byte'; } if ('1 chars' === $field['display']) { $field['display'] = '1 char'; } $a['fields'][] = new EnumStub($field); } return $a; } } __halt_compiler();----SIGNATURE:----VsKD/NkuEZLTl7/+QqP1yfdTQ1bKLS+01RAZvUEnAoEm/QV60A3/t/HDJ2cxfC+qhVVrvj9LdePd+65YB1ZhCH0A9yiw/m9rDHqtGj01Bw1iAbM6kz2WDDKnTZUxYMMmRf8qpp8KETrM43BaMwUtDkrXgfqdwVdot+3Ogspqp1N1+ztOzoNnmNyRL6Z8ZeUBOTkRwqT2E/XGAodhMfYsnsijkmU37JHprSB3lZBCt0hOrYdZTwdgm9bWV/WAtCX/+Bsurulu6kWg6MkDe4oXu4W+uxkZe5czl9PJ0Tr6RumZ5PBpKSPvkIOMz30CifnEbcYrUHcWWkbrDJdkajqh7aWA5H/KNDKoM0PISZgRADYmCy1VYvHQD34uj3NSevBRkeCBkyUqYP+kKXIIe3DhP2tlmy9zSCEvygHb5CdzKqzU3wOgAafoqwGAGvr84fO6jZBXhw2C2DT1tg5zVvue9f8AeDmYASd9ikR2Egtlt5irRMHU/dlouK1rWex3s6hhgvyOZeEvQbSMa6vgL43VvC56PbJHhXnqw1rLyTm73i5k8nqJcLj8Uo4uf3xSGV67iCJJFeL4SkwdfeYTDDWPKsh6RRh5QZux0qq9tUrW9HZy8lUmMoK1FwO7N7NfgbKg6+61ooK53UltLSJbvrxl/lSWviKyjGlmMiXxvsqKHCU=----ATTACHMENT:----MjY1MDcyNTg2OTA3NzUyMCA1NjQ4MzgzNDkyMzA4Nzc5IDcwMzQ4NjcwNzU5NTU4MTU=