Server : ApacheSystem : Linux host.digitalbabaji.in 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64 User : addictionfreeind ( 1003) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system Directory : /home/addictionfreeind/public_html/admin1/vendor/phpmyadmin/sql-parser/tests/Utils/ |
Upload File : |
<?php
declare(strict_types=1);
namespace PhpMyAdmin\SqlParser\Tests\Utils;
use PhpMyAdmin\SqlParser\Tests\TestCase;
use PhpMyAdmin\SqlParser\Utils\CLI;
use function dirname;
use function exec;
use const PHP_BINARY;
class CLITest extends TestCase
{
/**
* @param array<string, bool|string>|false $getopt
*/
private function getCLI($getopt): CLI
{
$cli = $this->createPartialMock(CLI::class, ['getopt']);
$cli->method('getopt')->willReturn($getopt);
return $cli;
}
/**
* @param array<string, bool|string>|false $getopt
*/
private function getCLIStdIn(string $input, $getopt): CLI
{
$cli = $this->createPartialMock(CLI::class, ['getopt', 'readStdin']);
$cli->method('getopt')->willReturn($getopt);
$cli->method('readStdin')->willReturn($input);
return $cli;
}
/**
* Test that getopt call works.
*
* We do mock it for other tests to return values we want.
*/
public function testGetopt(): void
{
$cli = new CLI();
$this->assertEquals(
$cli->getopt('', []),
[]
);
}
/**
* @param array<string, bool|string>|false $getopt
*
* @dataProvider highlightParamsProvider
*/
public function testRunHighlight($getopt, string $output, int $result): void
{
$cli = $this->getCLI($getopt);
$this->expectOutputString($output);
$this->assertEquals($result, $cli->runHighlight());
}
/**
* @return array<int, array<int, int|string|array<string, bool|string>|false>>
* @psalm-return list<array{(array<string, bool|string>|false), string, int}>
*/
public function highlightParamsProvider(): array
{
return [
[
['q' => 'SELECT 1'],
"\x1b[35mSELECT\n \x1b[92m1\x1b[0m\n",
0,
],
[
['query' => 'SELECT 1'],
"\x1b[35mSELECT\n \x1b[92m1\x1b[0m\n",
0,
],
[
[
'q' => 'SELECT /* comment */ 1 /* other */',
'f' => 'text',
],
"SELECT\n /* comment */ 1 /* other */\n",
0,
],
[
[
'q' => 'SELECT 1',
'f' => 'foo',
],
"ERROR: Invalid value for format!\n",
1,
],
[
[
'q' => 'SELECT 1',
'f' => 'html',
],
'<span class="sql-reserved">SELECT</span><br/>' .
' <span class="sql-number">1</span>' . "\n",
0,
],
[
['h' => true],
'Usage: highlight-query --query SQL [--format html|cli|text] [--ansi]' . "\n" .
' cat file.sql | highlight-query' . "\n",
0,
],
[
[],
'ERROR: Missing parameters!' . "\n" .
'Usage: highlight-query --query SQL [--format html|cli|text] [--ansi]' . "\n" .
' cat file.sql | highlight-query' . "\n",
1,
],
[
false,
'',
1,
],
];
}
/**
* @param array<string, bool|string>|false $getopt
*
* @dataProvider highlightParamsStdInProvider
*/
public function testRunHighlightStdIn(string $input, $getopt, string $output, int $result): void
{
$cli = $this->getCLIStdIn($input, $getopt);
$this->expectOutputString($output);
$this->assertEquals($result, $cli->runHighlight());
}
/**
* @return array<int, array<int, int|string|array<string, bool|string>|false>>
* @psalm-return list<array{string, (array<string, bool|string>|false), string, int}>
*/
public function highlightParamsStdInProvider(): array
{
return [
[
'SELECT 1',
[],
"\x1b[35mSELECT\n \x1b[92m1\x1b[0m\n",
0,
],
[
'SELECT /* comment */ 1 /* other */',
['f' => 'text'],
"SELECT\n /* comment */ 1 /* other */\n",
0,
],
[
'SELECT 1',
['f' => 'foo'],
"ERROR: Invalid value for format!\n",
1,
],
[
'SELECT 1',
['f' => 'html'],
'<span class="sql-reserved">SELECT</span><br/>' .
' <span class="sql-number">1</span>' . "\n",
0,
],
[
'',
['h' => true],
'Usage: highlight-query --query SQL [--format html|cli|text] [--ansi]' . "\n" .
' cat file.sql | highlight-query' . "\n",
0,
],
[
'',
[],
'ERROR: Missing parameters!' . "\n" .
'Usage: highlight-query --query SQL [--format html|cli|text] [--ansi]' . "\n" .
' cat file.sql | highlight-query' . "\n",
1,
],
[
'',
false,
'',
1,
],
];
}
/**
* @param array<string, bool|string>|false $getopt
*
* @dataProvider lintParamsStdInProvider
*/
public function testRunLintFromStdIn(string $input, $getopt, string $output, int $result): void
{
$cli = $this->getCLIStdIn($input, $getopt);
$this->expectOutputString($output);
$this->assertEquals($result, $cli->runLint());
}
/**
* @return array<int, array<int, int|string|array<string, bool|string>|false>>
* @psalm-return list<array{string, (array<string, bool|string>|false), string, int}>
*/
public function lintParamsStdInProvider(): array
{
return [
[
'SELECT 1',
[],
'',
0,
],
[
'SELECT SELECT',
[],
'#1: An expression was expected. (near "SELECT" at position 7)' . "\n" .
'#2: This type of clause was previously parsed. (near "SELECT" at position 7)' . "\n" .
'#3: An expression was expected. (near "" at position 0)' . "\n",
10,
],
[
'SELECT SELECT',
['c' => 'MySql80000'],
'#1: An expression was expected. (near "SELECT" at position 7)' . "\n" .
'#2: This type of clause was previously parsed. (near "SELECT" at position 7)' . "\n" .
'#3: An expression was expected. (near "" at position 0)' . "\n",
10,
],
[
'',
[],
'ERROR: Missing parameters!' . "\n" .
'Usage: lint-query --query SQL [--ansi]' . "\n" .
' cat file.sql | lint-query' . "\n",
1,
],
[
'',
['h' => true],
'Usage: lint-query --query SQL [--ansi]' . "\n" .
' cat file.sql | lint-query' . "\n",
0,
],
[
'',
false,
'',
1,
],
];
}
/**
* @param array<string, bool|string>|false $getopt
*
* @dataProvider lintParamsProvider
*/
public function testRunLint($getopt, string $output, int $result): void
{
$cli = $this->getCLI($getopt);
$this->expectOutputString($output);
$this->assertEquals($result, $cli->runLint());
}
/**
* @return array<int, array<int, int|string|array<string, bool|string>|false>>
* @psalm-return list<array{(array<string, bool|string>|false), string, int}>
*/
public function lintParamsProvider(): array
{
return [
[
['q' => 'SELECT 1'],
'',
0,
],
[
['query' => 'SELECT 1'],
'',
0,
],
[
['q' => 'SELECT SELECT'],
'#1: An expression was expected. (near "SELECT" at position 7)' . "\n" .
'#2: This type of clause was previously parsed. (near "SELECT" at position 7)' . "\n" .
'#3: An expression was expected. (near "" at position 0)' . "\n",
10,
],
[
[
'q' => 'SELECT SELECT',
'c' => 'MySql80000',
],
'#1: An expression was expected. (near "SELECT" at position 7)' . "\n" .
'#2: This type of clause was previously parsed. (near "SELECT" at position 7)' . "\n" .
'#3: An expression was expected. (near "" at position 0)' . "\n",
10,
],
[
['h' => true],
'Usage: lint-query --query SQL [--ansi]' . "\n" .
' cat file.sql | lint-query' . "\n",
0,
],
[
[],
'ERROR: Missing parameters!' . "\n" .
'Usage: lint-query --query SQL [--ansi]' . "\n" .
' cat file.sql | lint-query' . "\n",
1,
],
[
false,
'',
1,
],
];
}
/**
* @param array<string, bool|string>|false $getopt
*
* @dataProvider tokenizeParamsProvider
*/
public function testRunTokenize($getopt, string $output, int $result): void
{
$cli = $this->getCLI($getopt);
$this->expectOutputString($output);
$this->assertEquals($result, $cli->runTokenize());
}
/**
* @return array<int, array<int, int|string|array<string, bool|string>|false>>
* @psalm-return list<array{(array<string, bool|string>|false), string, int}>
*/
public function tokenizeParamsProvider(): array
{
$result = "[TOKEN 0]\nType = 1\nFlags = 3\nValue = 'SELECT'\nToken = 'SELECT'\n\n"
. "[TOKEN 1]\nType = 3\nFlags = 0\nValue = ' '\nToken = ' '\n\n"
. "[TOKEN 2]\nType = 6\nFlags = 0\nValue = 1\nToken = '1'\n\n"
. "[TOKEN 3]\nType = 9\nFlags = 0\nValue = NULL\nToken = NULL\n\n";
return [
[
['q' => 'SELECT 1'],
$result,
0,
],
[
['query' => 'SELECT 1'],
$result,
0,
],
[
['h' => true],
'Usage: tokenize-query --query SQL [--ansi]' . "\n" .
' cat file.sql | tokenize-query' . "\n",
0,
],
[
[],
'ERROR: Missing parameters!' . "\n" .
'Usage: tokenize-query --query SQL [--ansi]' . "\n" .
' cat file.sql | tokenize-query' . "\n",
1,
],
[
false,
'',
1,
],
];
}
/**
* @param array<string, bool|string>|false $getopt
*
* @dataProvider tokenizeParamsStdInProvider
*/
public function testRunTokenizeStdIn(string $input, $getopt, string $output, int $result): void
{
$cli = $this->getCLIStdIn($input, $getopt);
$this->expectOutputString($output);
$this->assertEquals($result, $cli->runTokenize());
}
/**
* @return array<int, array<int, int|string|array<string, bool|string>|false>>
* @psalm-return list<array{string, (array<string, bool|string>|false), string, int}>
*/
public function tokenizeParamsStdInProvider(): array
{
$result = "[TOKEN 0]\nType = 1\nFlags = 3\nValue = 'SELECT'\nToken = 'SELECT'\n\n"
. "[TOKEN 1]\nType = 3\nFlags = 0\nValue = ' '\nToken = ' '\n\n"
. "[TOKEN 2]\nType = 6\nFlags = 0\nValue = 1\nToken = '1'\n\n"
. "[TOKEN 3]\nType = 9\nFlags = 0\nValue = NULL\nToken = NULL\n\n";
return [
[
'SELECT 1',
[],
$result,
0,
],
[
'',
['h' => true],
'Usage: tokenize-query --query SQL [--ansi]' . "\n" .
' cat file.sql | tokenize-query' . "\n",
0,
],
[
'',
[],
'ERROR: Missing parameters!' . "\n" .
'Usage: tokenize-query --query SQL [--ansi]' . "\n" .
' cat file.sql | tokenize-query' . "\n",
1,
],
[
'',
false,
'',
1,
],
];
}
/**
* @dataProvider stdinParamsProvider
*/
public function testStdinPipe(string $cmd, int $result): void
{
exec($cmd, $out, $ret);
$this->assertSame($result, $ret);
}
/**
* @return array<int, array<int, int|string>>
* @psalm-return list<array{string, int}>
*/
public function stdinParamsProvider(): array
{
$binPath = PHP_BINARY . ' ' . dirname(__DIR__, 2) . '/bin/';
return [
[
'echo "SELECT 1" | ' . $binPath . 'highlight-query',
0,
],
[
'echo "invalid query" | ' . $binPath . 'highlight-query',
0,
],
[
'echo "SELECT 1" | ' . $binPath . 'lint-query',
0,
],
[
'echo "invalid query" | ' . $binPath . 'lint-query',
10,
],
[
'echo "SELECT 1" | ' . $binPath . 'tokenize-query',
0,
],
[
'echo "invalid query" | ' . $binPath . 'tokenize-query',
0,
],
];
}
}