Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/phpmyadmin/phpmyadmin.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
path: root/test/libraries/PMA_SQL_parser_test.php
diff options
context:
space:
mode:
Diffstat (limited to 'test/libraries/PMA_SQL_parser_test.php')
-rw-r--r--test/libraries/PMA_SQL_parser_test.php435
1 files changed, 0 insertions, 435 deletions
diff --git a/test/libraries/PMA_SQL_parser_test.php b/test/libraries/PMA_SQL_parser_test.php
deleted file mode 100644
index 3cda3964c4..0000000000
--- a/test/libraries/PMA_SQL_parser_test.php
+++ /dev/null
@@ -1,435 +0,0 @@
-<?php
-/* vim: set expandtab sw=4 ts=4 sts=4: */
-/**
- * Tests for correctness of SQL parser
- *
- * @package PhpMyAdmin-test
- */
-
-/*
- * Include to test.
- */
-require_once 'libraries/sqlparser.lib.php';
-require_once 'libraries/sqlparser.data.php';
-require_once 'libraries/php-gettext/gettext.inc';
-require_once 'libraries/Message.class.php';
-require_once 'libraries/Util.class.php';
-require_once 'libraries/Theme.class.php';
-require_once 'libraries/sanitizing.lib.php';
-
-/**
- * PMA_SQLParser_Test class
- *
- * this class is for testing sqlparser.lib.php
- *
- * @package PhpMyAdmin-test
- */
-class PMA_SQLParser_Test extends PHPUnit_Framework_TestCase
-{
- /**
- * Prepares environment for the test.
- *
- * @return void
- */
- public function setUp()
- {
- if (function_exists('mb_internal_encoding')) {
- mb_internal_encoding('utf-8');
- }
- $_SESSION['PMA_Theme'] = new PMA_Theme();
- $GLOBALS['pmaThemeImage'] = 'theme/';
- }
-
- /**
- * Testing of SQL parser.
- *
- * @param string $sql SQL query to parse
- * @param array $expected Expected parse result
- * @param string $error Expected error message
- *
- * @return void
- *
- * @dataProvider parserData
- * @group medium
- */
- public function testParser($sql, $expected, $error = '')
- {
- PMA_SQP_resetError();
- $this->expectOutputString($error);
- $parsed_sql = PMA_SQP_parse($sql);
- $this->assertEquals('', PMA_SQP_getErrorString());
- $this->assertEquals($expected, $parsed_sql);
- }
-
- /**
- * Test for PMA_SQP_isKeyWord
- *
- * @return void
- */
- public function testPmaSqpIsKeyWord()
- {
- PMA_SQP_resetError();
- $this->assertTrue(PMA_SQP_isKeyWord("ACCESSIBLE"));
- $this->assertTrue(PMA_SQP_isKeyWord("accessible"));
- $this->assertTrue(PMA_SQP_isKeyWord("ASC"));
- $this->assertFalse(PMA_SQP_isKeyWord("hello"));
- }
-
- /**
- * Test PMA_SQP_typeCheck
- *
- * @return void
- */
- public function testPmaSqpTypeCheck()
- {
- $this->assertTrue(
- PMA_SQP_typeCheck("VARCHAR", "VARCHAR")
- );
-
- $this->assertFalse(
- PMA_SQP_typeCheck("VARCHAR", "VARCHAR_INT")
- );
-
- $this->assertTrue(
- PMA_SQP_typeCheck("VARCHAR_INT", "VARCHAR")
- );
-
- $this->assertFalse(
- PMA_SQP_typeCheck("TIME_INT", "VARCHAR")
- );
- }
-
- /**
- * Test PMA_SQP_throwError
- *
- * @return void
- */
- public function testPmaSqpThrowError()
- {
- global $SQP_errorString;
- $message = "error from testPMA_SQP_throwError";
- $sql = "select * from PMA.PMABookmark";
- PMA_SQP_throwError($message, $sql);
-
- $this->assertContains(
- "There seems to be an error in your SQL query.",
- $SQP_errorString
- );
-
- $this->assertContains(
- 'ERROR: ' . $message,
- $SQP_errorString
- );
-
- $this->assertContains(
- 'SQL: ' . htmlspecialchars($sql),
- $SQP_errorString
- );
- }
-
- /**
- * Data provider for parser testing
- *
- * @return array with test data
- */
- public function parserData()
- {
- return array(
- array(
- 'SELECT 1;',
- array(
- 'raw' => 'SELECT 1;',
- 0 => array(
- 'type' => 'alpha_reservedWord',
- 'data' => 'SELECT',
- 'pos' => 6,
- 'forbidden' => true,
- ),
- 1 => array(
- 'type' => 'digit_integer',
- 'data' => '1',
- 'pos' => 8,
- ),
- 2 => array(
- 'type' => 'punct_queryend',
- 'data' => ';',
- 'pos' => 9,
- ),
- 'len' => 3,
- )
- ),
- array(
- 'SELECT * from aaa;',
- array(
- 'raw' => 'SELECT * from aaa;',
- 0 => array(
- 'type' => 'alpha_reservedWord',
- 'data' => 'SELECT',
- 'pos' => 6,
- 'forbidden' => true,
- ),
- 1 => array(
- 'type' => 'punct',
- 'data' => '*',
- 'pos' => 8,
- ),
- 2 => array(
- 'type' => 'alpha_reservedWord',
- 'data' => 'from',
- 'pos' => 13,
- 'forbidden' => true,
- ),
- 3 => array(
- 'type' => 'alpha_identifier',
- 'data' => 'aaa',
- 'pos' => 17,
- 'forbidden' => false,
- ),
- 4 => array(
- 'type' => 'punct_queryend',
- 'data' => ';',
- 'pos' => 18,
- ),
- 'len' => 5,
- )
- ),
- array(
- 'SELECT * from `aaa`;',
- array(
- 'raw' => 'SELECT * from `aaa`;',
- 0 => array(
- 'type' => 'alpha_reservedWord',
- 'data' => 'SELECT',
- 'pos' => 6,
- 'forbidden' => true,
- ),
- 1 => array(
- 'type' => 'punct',
- 'data' => '*',
- 'pos' => 8,
- ),
- 2 => array(
- 'type' => 'alpha_reservedWord',
- 'data' => 'from',
- 'pos' => 13,
- 'forbidden' => true,
- ),
- 3 => array(
- 'type' => 'quote_backtick',
- 'data' => '`aaa`',
- 'pos' => 19,
- ),
- 4 => array(
- 'type' => 'punct_queryend',
- 'data' => ';',
- 'pos' => 20,
- ),
- 'len' => 5,
- )
- ),
- array(
- 'SELECT * from `aaa;',
- array(
- 'raw' => 'SELECT * from `aaa`;',
- 0 => array (
- 'type' => 'alpha_reservedWord',
- 'data' => 'SELECT',
- 'pos' => 6,
- 'forbidden' => true,
- ),
- 1 => array(
- 'type' => 'punct',
- 'data' => '*',
- 'pos' => 8,
- ),
- 2 => array(
- 'type' => 'alpha_reservedWord',
- 'data' => 'from',
- 'pos' => 13,
- 'forbidden' => true,
- ),
- 3 => array(
- 'type' => 'quote_backtick',
- 'data' => '`aaa`',
- 'pos' => 19,
- ),
- 4 => array(
- 'type' => 'punct_queryend',
- 'data' => ';',
- 'pos' => 20,
- ),
- 'len' => 5,
- ),
- '<div class="notice"><img src="theme/s_notice.png" '
- . 'title="" alt="" /> Automatically appended '
- . 'backtick to the end of query!</div>'
- ),
- array(
- 'SELECT * FROM `a_table` tbla INNER JOIN b_table` tblb ON '
- . 'tblb.id = tbla.id WHERE tblb.field1 != tbla.field1`;',
- array(
- 'raw' => 'SELECT * FROM `a_table` tbla INNER JOIN '
- . 'b_table` tblb ON tblb.id = tbla.id WHERE '
- . 'tblb.field1 != tbla.field1`;',
- 0 => array(
- 'type' => 'alpha_reservedWord',
- 'data' => 'SELECT',
- 'pos' => 6,
- 'forbidden' => true,
- ),
- 1 => array(
- 'type' => 'punct',
- 'data' => '*',
- 'pos' => 8,
- ),
- 2 => array(
- 'type' => 'alpha_reservedWord',
- 'data' => 'FROM',
- 'pos' => 13,
- 'forbidden' => true,
- ),
- 3 => array(
- 'type' => 'quote_backtick',
- 'data' => '`a_table`',
- 'pos' => 23,
- ),
- 4 => array(
- 'type' => 'alpha_identifier',
- 'data' => 'tbla',
- 'pos' => 28,
- 'forbidden' => false,
- ),
- 5 => array(
- 'type' => 'alpha_reservedWord',
- 'data' => 'INNER',
- 'pos' => 34,
- 'forbidden' => true,
- ),
- 6 => array(
- 'type' => 'alpha_reservedWord',
- 'data' => 'JOIN',
- 'pos' => 39,
- 'forbidden' => true,
- ),
- 7 => array(
- 'type' => 'alpha_identifier',
- 'data' => 'b_table',
- 'pos' => 47,
- 'forbidden' => false,
- ),
- 8 => array(
- 'type' => 'quote_backtick',
- 'data' => '` tblb ON tblb.id = tbla.id WHERE '
- . 'tblb.field1 != tbla.field1`',
- 'pos' => 108,
- ),
- 9 => array(
- 'type' => 'punct_queryend',
- 'data' => ';',
- 'pos' => 109,
- ),
- 'len' => 10,
- )
- ),
- );
- }
-
- /**
- * Data provider for testPmaSqpGetAliasesFromQuery
- *
- * @return array with test data
- */
- public function aliasDataProvider()
- {
- return array(
- array(
- 'select i.name as `n`,abcdef gh from qwerty i',
- 'mydb',
- array(
- 'mydb' => array(
- 'alias' => null,
- 'tables' => array(
- 'qwerty' => array(
- 'alias' => 'i',
- 'columns' => array(
- 'name' => 'n',
- 'abcdef' => 'gh'
- )
- )
- )
- )
- )
- ),
- array(
- 'select film_id id,title from film',
- 'sakila',
- array(
- 'sakila' => array(
- 'alias' => null,
- 'tables' => array(
- 'film' => array(
- 'alias' => null,
- 'columns' => array(
- 'film_id' => 'id'
- )
- )
- )
- )
- )
- ),
- array(
- 'select `sakila`.`A`.`actor_id` as aid,`F`.`film_id` `fid`,'
- . 'last_update updated from `sakila`.actor A join `film_actor` as '
- . '`F` on F.actor_id = A.`actor_id`',
- 'sakila',
- array(
- 'sakila' => array(
- 'alias' => null,
- 'tables' => array(
- 'film_actor' => array(
- 'alias' => 'F',
- 'columns' => array(
- 'film_id' => 'fid',
- 'last_update' => 'updated'
- )
- ),
- 'actor' => array(
- 'alias'=> 'A',
- 'columns' => array(
- 'actor_id' => 'aid',
- 'last_update' => 'updated'
- )
- )
- )
- )
- )
- ),
- array(
- '',
- '',
- array()
- )
- );
- }
-
- /**
- * Testing of PMA_SQP_getAliasesFromQuery.
- *
- * @param string $select_query The Select SQL Query
- * @param string $db Current DB
- * @param array $expected Expected parse result
- *
- * @return void
- *
- * @dataProvider aliasDataProvider
- * @group medium
- */
- public function testPmaSqpGetAliasesFromQuery($select_query, $db, $expected)
- {
- $this->assertEquals(
- $expected,
- PMA_SQP_getAliasesFromQuery($select_query, $db)
- );
- }
-}
-?>
generated by cgit v1.2.3 (git 2.25.1) at 2024-07-27 12:53:02 +0300