SM0 She11

Path: / / usr / local / cwpsrv / var / services / pma_31-08-2019.bak / libraries / sql-parser / src / Utils

Full Path (server): /usr/local/cwpsrv/var/services/pma_31-08-2019.bak/libraries/sql-parser/src/Utils

📄 BufferedQuery.php [E] [D]
📄 CLI.php [E] [D]
📄 Error.php [E] [D]
📄 Formatter.php [E] [D]
📄 Misc.php [E] [D]
📄 Query.php [E] [D]
📄 Routine.php [E] [D]
📄 Table.php [E] [D]
📄 Tokens.php [E] [D]

Editing: Routine.php

<?php

/**
 * Routine utilities.
 */

namespace SqlParser\Utils;

use SqlParser\Lexer;
use SqlParser\Parser;
use SqlParser\Components\DataType;
use SqlParser\Components\ParameterDefinition;
use SqlParser\Statements\CreateStatement;

/**
 * Routine utilities.
 *
 * @category   Routines
 *
 * @license    https://www.gnu.org/licenses/gpl-2.0.txt GPL-2.0+
 */
class Routine
{
    /**
     * Parses a parameter of a routine.
     *
     * @param string $param parameter's definition
     *
     * @return array
     */
    public static function getReturnType($param)
    {
        $lexer = new Lexer($param);

// A dummy parser is used for error reporting.
        $type = DataType::parse(new Parser(), $lexer->list);

if ($type === null) {
            return array('', '', '', '', '');
        }

$options = array();
        foreach ($type->options->options as $opt) {
            $options[] = is_string($opt) ? $opt : $opt['value'];
        }

return array(
            '',
            '',
            $type->name,
            implode(',', $type->parameters),
            implode(' ', $options),
        );
    }

/**
     * Parses a parameter of a routine.
     *
     * @param string $param parameter's definition
     *
     * @return array
     */
    public static function getParameter($param)
    {
        $lexer = new Lexer('(' . $param . ')');

// A dummy parser is used for error reporting.
        $param = ParameterDefinition::parse(new Parser(), $lexer->list);

if (empty($param[0])) {
            return array('', '', '', '', '');
        }

$param = $param[0];

$options = array();
        foreach ($param->type->options->options as $opt) {
            $options[] = is_string($opt) ? $opt : $opt['value'];
        }

return array(
            empty($param->inOut) ? '' : $param->inOut,
            $param->name,
            $param->type->name,
            implode(',', $param->type->parameters),
            implode(' ', $options),
        );
    }

/**
     * Gets the parameters of a routine from the parse tree.
     *
     * @param CreateStatement $statement the statement to be processed
     *
     * @return array
     */
    public static function getParameters($statement)
    {
        $retval = array(
            'num' => 0,
            'dir' => array(),
            'name' => array(),
            'type' => array(),
            'length' => array(),
            'length_arr' => array(),
            'opts' => array(),
        );

if (!empty($statement->parameters)) {
            $idx = 0;
            foreach ($statement->parameters as $param) {
                $retval['dir'][$idx] = $param->inOut;
                $retval['name'][$idx] = $param->name;
                $retval['type'][$idx] = $param->type->name;
                $retval['length'][$idx] = implode(',', $param->type->parameters);
                $retval['length_arr'][$idx] = $param->type->parameters;
                $retval['opts'][$idx] = array();
                foreach ($param->type->options->options as $opt) {
                    $retval['opts'][$idx][] = is_string($opt) ?
                        $opt : $opt['value'];
                }
                $retval['opts'][$idx] = implode(' ', $retval['opts'][$idx]);
                ++$idx;
            }

$retval['num'] = $idx;
        }

return $retval;
    }
}