diff options
author | Dan Ungureanu <udan1107@gmail.com> | 2015-06-15 20:05:20 +0300 |
---|---|---|
committer | Dan Ungureanu <udan1107@gmail.com> | 2015-07-10 23:18:12 +0300 |
commit | bf6e14393d32cd5fc4937a210d8c82597f612947 (patch) | |
tree | 146f650aefe035c6cd882ceb167fa7b703f7aef3 | |
parent | 02f6c7f4c06111677baa6e873d82df0d6d16c133 (diff) |
Removed PMA_RTN_parseOneParameter().
Signed-off-by: Dan Ungureanu <udan1107@gmail.com>
-rw-r--r-- | libraries/rte/rte_routines.lib.php | 76 | ||||
-rw-r--r-- | test/libraries/rte/PMA_RTN_ParameterParser_test.php | 52 |
2 files changed, 0 insertions, 128 deletions
diff --git a/libraries/rte/rte_routines.lib.php b/libraries/rte/rte_routines.lib.php index c36326f718..b16926001f 100644 --- a/libraries/rte/rte_routines.lib.php +++ b/libraries/rte/rte_routines.lib.php @@ -80,82 +80,6 @@ function PMA_RTN_main($type) } // end PMA_RTN_main() /** - * This function parses a string containing one parameter of a routine - * and returns an array containing the information about this parameter. - * - * @param string $value A string containing one parameter of a routine - * - * @return array Parsed information about the input parameter - */ -function PMA_RTN_parseOneParameter($value) -{ - global $param_directions; - - $retval = array(0 => '', - 1 => '', - 2 => '', - 3 => '', - 4 => ''); - $parsed_param = PMA_SQP_parse($value); - $pos = 0; - if (in_array( - /*overload*/mb_strtoupper($parsed_param[$pos]['data']), - $param_directions - )) { - $retval[0] = /*overload*/mb_strtoupper($parsed_param[0]['data']); - $pos++; - } - if ($parsed_param[$pos]['type'] == 'alpha_identifier' - || $parsed_param[$pos]['type'] == 'quote_backtick' - ) { - $retval[1] = PMA_Util::unQuote( - $parsed_param[$pos]['data'] - ); - $pos++; - } - $depth = 0; - $param_length = ''; - $param_opts = array(); - for ($i = $pos; $i < $parsed_param['len']; $i++) { - if (($parsed_param[$i]['type'] == 'alpha_columnType' - || $parsed_param[$i]['type'] == 'alpha_functionName') && $depth == 0 - ) { - $retval[2] = /*overload*/mb_strtoupper($parsed_param[$i]['data']); - } else if ($parsed_param[$i]['type'] == 'punct_bracket_open_round' - && $depth == 0 - ) { - $depth = 1; - } else if ($parsed_param[$i]['type'] == 'punct_bracket_close_round' - && $depth == 1 - ) { - $depth = 0; - } else if ($depth == 1) { - $param_length .= $parsed_param[$i]['data']; - } else if ($parsed_param[$i]['type'] == 'alpha_reservedWord' - && /*overload*/mb_strtoupper($parsed_param[$i]['data']) == 'CHARSET' - && $depth == 0 - ) { - if ($parsed_param[$i+1]['type'] == 'alpha_charset' - || $parsed_param[$i+1]['type'] == 'alpha_identifier' - ) { - $param_opts[] = /*overload*/mb_strtolower( - $parsed_param[$i+1]['data'] - ); - } - } else if ($parsed_param[$i]['type'] == 'alpha_columnAttrib' - && $depth == 0 - ) { - $param_opts[] = /*overload*/mb_strtoupper($parsed_param[$i]['data']); - } - } - $retval[3] = $param_length; - sort($param_opts); - $retval[4] = implode(' ', $param_opts); - - return $retval; -} // end PMA_RTN_parseOneParameter() - -/** * This function looks through the contents of a parsed * SHOW CREATE [PROCEDURE | FUNCTION] query and extracts * information about the routine's definer. diff --git a/test/libraries/rte/PMA_RTN_ParameterParser_test.php b/test/libraries/rte/PMA_RTN_ParameterParser_test.php index cfced81a20..d94e6c0b96 100644 --- a/test/libraries/rte/PMA_RTN_ParameterParser_test.php +++ b/test/libraries/rte/PMA_RTN_ParameterParser_test.php @@ -62,57 +62,5 @@ class PMA_RTN_ParameterParser_Test extends PHPUnit_Framework_TestCase ), ); } - - /** - * Test for PMA_RTN_parseOneParameter - * - * @param string $source Source - * @param array $target Expected output - * - * @return void - * - * @dataProvider paramProvider - */ - public function testParseOneParameter($source, $target) - { - PMA_RTN_setGlobals(); - $this->assertEquals($target, PMA_RTN_parseOneParameter($source)); - } - - /** - * Data provider for testParseOneParameter - * - * @return array - */ - public function paramProvider() - { - return array( - array('`foo` TEXT', array('', 'foo', 'TEXT', '', '')), - array('`foo` INT(20)', array('', 'foo', 'INT', '20', '')), - array('DECIMAL(5,5)', array('', '', 'DECIMAL', '5,5', '')), - array( - 'IN `fo``fo` INT UNSIGNED', - array('IN', 'fo`fo', 'INT', '', 'UNSIGNED') - ), - array( - 'OUT bar VARCHAR(1) CHARSET utf8', - array('OUT', 'bar', 'VARCHAR', '1', 'utf8') - ), - array( - '`"baz\'\'` ENUM(\'a\', \'b\') CHARSET latin1', - array('', '"baz\'\'', 'ENUM', '\'a\',\'b\'', 'latin1') - ), - array( - 'INOUT `foo` DECIMAL(5,2) UNSIGNED ZEROFILL', - array('INOUT', 'foo', 'DECIMAL', '5,2', 'UNSIGNED ZEROFILL') - ), - array( - '`foo``s func` SET(\'test\'\'esc"\', \'more\\\'esc\')', - array( - '', 'foo`s func', 'SET', '\'test\'\'esc"\',\'more\\\'esc\'', '' - ) - ) - ); - } } ?> |