test/libraries/PMA_sql_test.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Tests for libraries/sql.lib.php
   5  *
   6  * @package PhpMyAdmin-test
   7  */
   8
   9 /*
  10  * Include to test.
  11  */
  12 require_once 'libraries/sql.lib.php';
  13
  14 /**
  15  * Tests for libraries/sql.lib.php
  16  *
  17  * @package PhpMyAdmin-test
  18  */
  19 class PMA_SqlTest extends PHPUnit_Framework_TestCase
  20 {
  21     /**
  22      * Test PMA_getSqlWithLimitClause
  23      *
  24      * @return void
  25      */
  26     public function testGetSqlWithLimitClause()
  27     {
  28         // Test environment.
  29         $GLOBALS['_SESSION']['tmpval']['pos'] = 1;
  30         $GLOBALS['_SESSION']['tmpval']['max_rows'] = 2;
  31         $GLOBALS['db'] = 'db';
  32
  33         $analyzed_sql_results = PMA_parseAndAnalyze(
  34             'SELECT * FROM test LIMIT 0, 10'
  35         );
  36         $this->assertEquals(
  37             'SELECT * FROM test LIMIT 1, 2 ',
  38             PMA_getSqlWithLimitClause($analyzed_sql_results)
  39         );
  40     }
  41
  42     /**
  43      * Test PMA_isRememberSortingOrder
  44      *
  45      * @return void
  46      */
  47     public function testIsRememberSortingOrder()
  48     {
  49         // Test environment.
  50         $GLOBALS['cfg']['RememberSorting'] = true;
  51         $GLOBALS['db'] = 'db';
  52
  53         $this->assertTrue(
  54             PMA_isRememberSortingOrder(
  55                 PMA_parseAndAnalyze('SELECT * FROM tbl')
  56             )
  57         );
  58
  59         $this->assertFalse(
  60             PMA_isRememberSortingOrder(
  61                 PMA_parseAndAnalyze('SELECT col FROM tbl')
  62             )
  63         );
  64
  65         $this->assertFalse(
  66             PMA_isRememberSortingOrder(
  67                 PMA_parseAndAnalyze('SELECT 1')
  68             )
  69         );
  70
  71         $this->assertFalse(
  72             PMA_isRememberSortingOrder(
  73                 PMA_parseAndAnalyze('SELECT col1, col2 FROM tbl')
  74             )
  75         );
  76
  77         $this->assertFalse(
  78             PMA_isRememberSortingOrder(
  79                 PMA_parseAndAnalyze('SELECT COUNT(*) from tbl')
  80             )
  81         );
  82     }
  83
  84     /**
  85      * Test PMA_isAppendLimitClause
  86      *
  87      * @return void
  88      */
  89     public function testIsAppendLimitClause()
  90     {
  91         // Test environment.
  92         $GLOBALS['_SESSION']['tmpval']['max_rows'] = 10;
  93         $GLOBALS['db'] = 'db';
  94
  95         $this->assertTrue(
  96             PMA_isAppendLimitClause(
  97                 PMA_parseAndAnalyze('SELECT * FROM tbl')
  98             )
  99         );
 100
 101         $this->assertFalse(
 102             PMA_isAppendLimitClause(
 103                 PMA_parseAndAnalyze('SELECT * from tbl LIMIT 0, 10')
 104             )
 105         );
 106     }
 107
 108     /**
 109      * Test PMA_isJustBrowsing
 110      *
 111      * @return void
 112      */
 113     public function testIsJustBrowsing()
 114     {
 115         // Test environment.
 116         $GLOBALS['_SESSION']['tmpval']['max_rows'] = 10;
 117         $GLOBALS['db'] = 'db';
 118
 119         $this->assertTrue(
 120             PMA_isJustBrowsing(
 121                 PMA_parseAndAnalyze('SELECT * FROM db.tbl'),
 122                 null
 123             )
 124         );
 125
 126         $this->assertTrue(
 127             PMA_isJustBrowsing(
 128                 PMA_parseAndAnalyze('SELECT * FROM tbl WHERE 1'),
 129                 null
 130             )
 131         );
 132
 133         $this->assertFalse(
 134             PMA_isJustBrowsing(
 135                 PMA_parseAndAnalyze('SELECT * from tbl1, tbl2 LIMIT 0, 10'),
 136                 null
 137             )
 138         );
 139     }
 140
 141     /**
 142      * Test PMA_isDeleteTransformationInfo
 143      *
 144      * @return void
 145      */
 146     public function testIsDeleteTransformationInfo()
 147     {
 148         $this->assertTrue(
 149             PMA_isDeleteTransformationInfo(
 150                 PMA_parseAndAnalyze('ALTER TABLE tbl DROP COLUMN col')
 151             )
 152         );
 153
 154         $this->assertTrue(
 155             PMA_isDeleteTransformationInfo(
 156                 PMA_parseAndAnalyze('DROP TABLE tbl')
 157             )
 158         );
 159
 160         $this->assertFalse(
 161             PMA_isDeleteTransformationInfo(
 162                 PMA_parseAndAnalyze('SELECT * from tbl')
 163             )
 164         );
 165     }
 166
 167     /**
 168      * Test PMA_hasNoRightsToDropDatabase
 169      *
 170      * @return void
 171      */
 172     public function testHasNoRightsToDropDatabase()
 173     {
 174         $this->assertEquals(
 175             true,
 176             PMA_hasNoRightsToDropDatabase(
 177                 PMA_parseAndAnalyze('DROP DATABASE db'),
 178                 false,
 179                 false
 180             )
 181         );
 182
 183         $this->assertEquals(
 184             false,
 185             PMA_hasNoRightsToDropDatabase(
 186                 PMA_parseAndAnalyze('DROP TABLE tbl'),
 187                 false,
 188                 false
 189             )
 190         );
 191
 192         $this->assertEquals(
 193             false,
 194             PMA_hasNoRightsToDropDatabase(
 195                 PMA_parseAndAnalyze('SELECT * from tbl'),
 196                 false,
 197                 false
 198             )
 199         );
 200     }
 201
 202 }