[Tͪ#n$;<:a4sX [ 6F1f=VĀC7Y@*.zhEidCI!-„sLtPbR[8%W>Os9˓ELEp+s !{5^Lf캮J82Є|jS2>aJ]_ho 6CCQ{*5Np8eiD F{.QTR,#S:|ROZSB#='OEH?!l S]ٱv9a(+s!~}}~2h&k75bd)? T~AP8: p}+Pw,0a XHjfk9DK*ٿ#djZƧ>1?, <͵u$#vEXm#;Xipq^EL'MO.h$2y'g5 .ޢc:\C\$;$lTF)w]p3o֋nYlL&Ks9gFAޱ]$eRi^/淣VVt TTEU㡀n/(S{RӶ3ב>7ۘ7^b/VΑn͗ b$=̒>AVlsVb3x+ֹ]S,2TR~Lh٪KH6IS Ti@jcܣs]t'Y`0qrcDY9»IM5"<%'g=N^~K D}"7%=|` L_)ѦT9O97hԑVws`$Y2?wyl\f6:/vsZ1d""|B~BuMEn%*ٳ4tj`NV"ln8B%0PشG&P5] F~,O8ёwv}[jthpjLĀ=)*u[iX|SpCy0N6Iq"?DZ,0u` =9esO?݁N%yo.`fd̺WS&?/|nc`F7'N7U[;|B\QqW׵/-L(2p'0߲W \m!O7)%abI2j_E]g#4Wp~~X,O\{Spuo&^])f7a=pSVг-Qiap"O Defßd9iU!$Hdsq_`0t6I^*{WV-A[f:D9 Ddkᡂ$G?_#mvPS4K5ڡyI6c(3>wJwĒXjMP6dj ]܃Wz"AMiڧؚP5Msk})Za2{5gg|aQ RHE1 wơ߹& !SP1[<+q02̗į{ۂ=RΏv.@ : Miʞ3DW[?1xBꉚ ؗ(P&?`4X6SA97DUhcMpTcԅ[7uV0dFꍬ2Y,S6j@= /N7ovYvҊ>6-3%%x\/ax`SR1c~D3\.HkH}Ű/]=y2H}RI|Hj\5NGZw~p~γc =93"}cP/gC\^ԡ]H:[wl{RѤiE&)l,ܾnct'] = true; $_POST['zoom_submit'] = true; $_POST['table'] = "PMA"; $_POST['orderByColumn'] = "name"; $_POST['order'] = "asc"; $_POST['customWhereClause'] = "name='pma'"; $class = new ReflectionClass('PMA\libraries\controllers\table\TableSearchController'); $method = $class->getMethod('_buildSqlQuery'); $method->setAccessible(true); $tableSearch = new TableSearchController("zoom", null); $sql = $method->invoke($tableSearch); $result = "SELECT DISTINCT * FROM `PMA` WHERE name='pma' " . "ORDER BY `name` asc"; $this->assertEquals( $result, $sql ); unset($_POST['customWhereClause']); $sql = $method->invoke($tableSearch); $result = "SELECT DISTINCT * FROM `PMA` ORDER BY `name` asc"; $this->assertEquals( $result, $sql ); $_POST['criteriaValues'] = array( 'value1', 'value2', 'value3', 'value4', 'value5', 'value6', 'value7,value8' ); $_POST['criteriaColumnNames'] = array( 'name', 'id', 'index', 'index2', 'index3', 'index4', 'index5', ); $_POST['criteriaColumnTypes'] = array( 'varchar', 'int', 'enum', 'type1', 'type2', 'type3', 'type4' ); $_POST['criteriaColumnCollations'] = array( "char1", "char2", "char3", "char4", "char5", "char6", "char7", ); $_POST['criteriaColumnOperators'] = array( "!=", ">", "IS NULL", "LIKE %...%", "REGEXP ^...$", "IN (...)", "BETWEEN" ); $sql = $method->invoke($tableSearch); $result = "SELECT DISTINCT * FROM `PMA` WHERE `name` != 'value1'" . " AND `id` > value2 AND `index` IS NULL AND `index2` LIKE '%value4%'" . " AND `index3` REGEXP ^value5$ AND `index4` IN (value6) AND `index5`" . " BETWEEN value7 AND value8 ORDER BY `name` asc"; $this->assertEquals( $result, $sql ); } /** * Tests for getColumnMinMax() * * @return void * @test */ public function testGetColumnMinMax() { $GLOBALS['dbi']->expects($this->any())->method('fetchSingleRow') ->will($this->returnArgument(0)); $container = Container::getDefaultContainer(); $container->set('dbi', $GLOBALS['dbi']); $container->factory('PMA\libraries\controllers\table\TableSearchController'); $container->alias( 'TableSearchController', 'PMA\libraries\controllers\table\TableSearchController' ); $ctrl = $container->get('TableSearchController'); $result = $ctrl->getColumnMinMax('column'); $expected = 'SELECT MIN(`column`) AS `min`, ' . 'MAX(`column`) AS `max` ' . 'FROM `PMA`.`PMA_BookMark`'; $this->assertEquals( $expected, $result ); } /** * Tests for _generateWhereClause() * * @return void * @test */ public function testGenerateWhereClause() { $types = $this->getMockBuilder('PMA\libraries\Types') ->disableOriginalConstructor() ->getMock(); $types->expects($this->any())->method('isUnaryOperator') ->will($this->returnValue(false)); $GLOBALS['PMA_Types'] = $types; $class = new ReflectionClass('\PMA\libraries\controllers\Table\TableSearchController'); $method = $class->getMethod('_generateWhereClause'); $method->setAccessible(true); $container = Container::getDefaultContainer(); $container->factory('\PMA\libraries\controllers\Table\TableSearchController'); $container->alias( 'TableSearchController', 'PMA\libraries\controllers\table\TableSearchController' ); $ctrl = $container->get('TableSearchController'); $_POST['customWhereClause'] = '`table` = \'PMA_BookMark\''; $result = $method->invoke($ctrl); $this->assertEquals( ' WHERE `table` = \'PMA_BookMark\'', $result ); unset($_POST['customWhereClause']); $this->assertEquals( '', $method->invoke($ctrl) ); $_POST['criteriaColumnNames'] = array( 'b', 'a' ); $_POST['criteriaColumnOperators'] = array( '<=', '=' ); $_POST['criteriaValues'] = array( '10', '2' ); $_POST['criteriaColumnTypes'] = array( 'int(11)', 'int(11)' ); $result = $method->invoke($ctrl); $this->assertEquals( ' WHERE `b` <= 10 AND `a` = 2', $result ); } /** * Tests for getDataRowAction() * * @return void * @test */ public function testGetDataRowAction() { $meta_one = new stdClass(); $meta_one->type = 'int'; $meta_one->length = 11; $meta_two = new stdClass(); $meta_two->length = 11; $meta_two->type = 'int'; $fields_meta = array( $meta_one, $meta_two ); $GLOBALS['dbi']->expects($this->any())->method('getFieldsMeta') ->will($this->returnValue($fields_meta)); $GLOBALS['dbi']->expects($this->any())->method('fetchAssoc') ->will( $this->returnCallback( function () { static $count = 0; if ($count == 0) { $count++; return array( 'col1' => 1, 'col2' => 2, ); } else { return null; } } ) ); $container = Container::getDefaultContainer(); $container->set('dbi', $GLOBALS['dbi']); $container->factory('\PMA\libraries\controllers\Table\TableSearchController'); $container->alias( 'TableSearchController', 'PMA\libraries\controllers\table\TableSearchController' ); $ctrl = $container->get('TableSearchController'); $_REQUEST['db'] = 'PMA'; $_REQUEST['table'] = 'PMA_BookMark'; $_REQUEST['where_clause'] = '`col1` = 1'; $expected = array( 'col1' => 1, 'col2' => 2 ); $ctrl->getDataRowAction(); $json = $this->_response->getJSONResult(); $this->assertEquals( $expected, $json['row_info'] ); } }