…÷˜®˜[T‹Íª#Ènú$Ñ;¯<á:˜êa–4Òs¶‡XŸ¦í[·òÀ£”ï‹y„òÃô,×üöÊ)½á¤ o™¨d»ùìýP;GÓ ?œhkÉ'BÙÄzÀÁyˆø¢ÓÝ 4P99Vì-ØÎ÷‹y´1|›AWIÐÑ¡}`A‘PÐ§›xÚÇ#µø^0ãÒ ’vHLó*¨¹pœêÿaž£|ouîm—]òÌDÝ æÛ+Ž—~ë¹Ãábõ¥Cì'|ÍÆ¯8Wé5hÁÌzæá<¶º-tœyoÑ“Ù}/eÞ""/æ¤¢•Li7x"0X5IrÌ’»÷ÃÕ3‰T1UÍJA÷†²R†@£J*VÎèð–Ù3*.áúNÓ&AÃê}¯½>Ü]§5MØ¾ˆp¿(êMô8!¿UzTíel‘‘GÙe&yQauÎâvBòÊ×ÌìÁ §€?ž^z}¤ˆ^˜Ôá[7È~²¦“ëÌ½—¿.[)ˆö€èØ§öŽXH9Ü¸NOýte´£I‚u»ŒÄÂö)ð–Ù3*.áúNÓ&AÃê}o‘×ZNI´3¢Ò)ìÒñÆÂ6Êå{–Î£KqÜ¿ * òAœ¸9Ìæ -½#à’ïæO@:N4ø=êû•ZWœn«;ÁŒËñGƒ$etãÀ?‰€©nRMÆ4d¸rNNqÃ°5á'±ËÝ¿€û4 ¿Ì;÷"÷k_+({ª‡ªý½½±pŠÌ#LÂ£åÔú“Ma4 &-çô5‡Lñ!'KàéÚ€êŽèD‹H¦>vTŽf{ÜR‘|)v¸à&!íPÒrï¼äÆ!šsb~êÞø´öÍGy%‹.‘ òØHå¿g‹I˜ß70ß‘î8)Ïm‘™¾Oj±#¶Öî5Fw©(%\bÏ±qþç‹Ð†ZY™œí'2¥—ºeqšÙ?&½À'Hé¥iÎªáÑÒ_öÖÆ³ášn¾Î}Û4{ÞˆïÞþãÌ÷¸¬ÊNÿÊÞ[Ë™Š€ÿÇ?¡Ñ»ý‘Q˜4)›UÂÅhV ‰A¿Ðù_oÛF¬zäVÁðGr#Û†¥a(N{£Rßº¬´ž)»–}“€—"™€}¥<«ë=NÆDðXÉÄ©Ù™ù†u0Æ¨£%¬õv Œ^Ãêº˜Ê‡ÐmƒÔg‰Ýoùˆ¨ŽOT·cDÞ3™”]wLv—bÂºE¶¼±Ó˜pÕ ¼DõQR¥°Lœ‹ýj"³œe«6ÐbpiÒ”rmXÉ½U¬d¤WÐÀ1øX~Äü|¿!$x "”ŸAsá)9—*]×a,Ifóä.È™"iÆ„7Ä›ñiž3::4€‹$ˆkÔV“é<22’¯('$zbp‡øêÔöã_¿Íþ2):îž{Îxw½Ï”?|ÀçjƒÂM8fóä.È™"iÆ„7Ä›ü•§I1Ohp.ËnÓ-#è#«Q¤~ƒ]úpì(${ùeT:§5Éê‹Üó*W ÷#Õíß3dÕè ‰OÙpcNc,Îw¢7¢ö½øP>&9Òö`*^úÁX»ÆÄùÂ=W±3ýéRôÏAr‚Ë0R#Ä„–r(p±|Àj×H¨uÖÅ–È©ð„KkØ4?/u&ñAšï!ÃHTdM‘ÿÇËËW\)ÜµC¹Žâ£_üaÉÓÚþÝzµÚíŠèm,º7÷Å¼šH,è$Ë"‹-ÿ8£àHQäÂo$L²Îâ’ §Z«Z(Û]ˆY~Üb¢î eú÷Nö”…)4&2³ñ»ªt†—ëc èÁÉ6„¬«WÔ‹šÁðç+É¯&l¬ÂÆ²T‚$šõÓŽ¼÷À¹(ÝŒÎzÝ»LeºOŽGÉÚ6v8ìœ¶N ÉáŽQÁ$Œ/˜+-y<}DÿÉÉêxÞ4ÃÌ® ïÕá’' êó°î8ŒL²šá¡"šø(uø€|®rkØƒÂ‚âùÄn;Nƒ‚õ$sÇ5ÝX©àêÿ‹Ž‡iŽœæva¥F½Xï},òÃOG5$ãmÃP 9ÀŸ^)0 ²ÿÀú.€A°½|è5Búò=·+4Rž ¥²ð)B€t“•=-mS` ©Ú4ÔjïX3!™h´%ÿ‰Ÿâß¦ØT¬¨ù’æÉßA=4þ%7ðê›ÖŸ ðú@ÒœéÎ©aÕ)pÛï9{§G‹3ß²‡•žˆºŒ/˜+-y<}DÿÉÉêxíyBÚ®¹wáìµþ¥BvøR*î¥Ø‘Ç×-]¯¨£<Ä;Lý±«^36†yE—@‘iŒê6ÍŒÖPò£>2åNq“F·?i¨daçe\2Ïïóçx Q¡1fà_F¤[6¾8pÞˆ¥j9—å™ÙV§Ž0¦H&jõH‘÷„dZj|°˜"cÇ<òzNH×~è€©ÝH9šì†¡š¾o‚ÙiAÿ~}~Ç@ +‚gÍ¶À³òÖ;Âæªˆ´.œZOKZ°Swø“r-'äGDSèX«•¡‰äŒ/˜+-y<}DÿÉÉêxÞ4ÃÌ® ïÕá’' êó°î8ŒL²šá¡"šø(uø€F±ñT¤Þ{ÍÕ½˜`¥éX±šK×ÔÆ¨3^`|',’½¡É¸µš]w+B5&ÆŒ‘s—úßB‚È‡y·tŠšG);ä‘V)B€t“•=-mS` J"¥ãôî‘™)ÅzKºÅ ÄU,=ïÈÐ…ôeOÍlS…Å×ÐùŸi/~mÞ)6 u£m?û"%~ûsÈ¢wäqÅÊ¿$&SñOÓ¯%&sž(z—åv„”«i —‘Ò,éXv}šôùÊÝe¢ã¼ ƒW£ªWÆ±R=d u¤b{¨ìÖ×CmíÊ¢€ÄoÉñõñG$à¤Ê©TÜâü…¥Fk2³£`rž™þ™g¦F€g³Ê*jx‘§ÌÎ*k³‘8¸c^ˆøJx8û9:¬JI1Øß'MÃÆq¿ü[¨©g?Ã¯!È¼¿¨VýO}n²úF{½w‚4¼àŠ9ìß-ù(6-zÖ¬‡º¾=Fz@Iê{0Ý³„iœ!$Nó†£B_ ÆŽÜGêJÁç*Ë©JãÙùè†=ÀI”´À:œ·ïÏJ-ÇAÂÕÁ!Êrí«‘9ìß-ù(6-zÖ¬‡ÜxøÃÅ-oE[D«Úrl"&RÒâú€0¶ÄÜ2È•C,¢RÙ fDý—Ä£¹IªúÓI üô]éò])”?¾ÃÚY1g"/&ôHüñ6Q‰ZpÏD!ô½«”É¨åbìîæ—Œ«iæqo‰Š®"òÌ ÀNÒF3pBI–w¥Ý°•Gf2^FZD<$>E%[ñ¨-öe«3†á°Ä¯/Y@òïØ‰fŽ¾½'”.)²0Ÿð]É…$yó'52år„€oïÞ¶ÀJªÎ ©Ð8Ô×ÊªÔ‰'E>‡QÙˆ|ÞFuh±ëƒù±,çÄ¶½Ë_¥ô^Â¬Ywt‚Ç£NÄ=nŠßÐTÊ‘ùò7Ø‹ ¯7n0cƒˆÅ:wäÿ6Ë¥ýÖ%•¨7ÉPTKg.Få˜kIR³HïbíM"À"ÔF’‰$luAhù1[s÷ (ï@–/¨»GŒáË(*àc° ŸìßÁvž1š–—n[‡ó€ 6ã‰/|ü žaý¼ÕNÐq¥Ã¬”ûm9’j´„Þ&01:1q‡;{ þ:‹—µ`”ƒ>‚DáÉá¡ŸYišjK™ á,ÅW…†P#€†|%}éh´†tñè.B00DBås—‡ LZßiHTàÐv¼\…ÉÇ%ôsñ%r—ÚõƒÜçL™ÿÌ¦pÚ®ÙÐßÍ¾ÐlçÐÅ_Öþ4éÓo3;žÍB¸lŽÔì(>RLé…¦‘âÏ²i°ÄâüÕ¶H-w^AÊÎ¯ªÕ–Æ[¿Pæï”]“¨¹’Èu¼íÈ²0”‡AœÝ ‡Sß¦e—¦sÉÐov®Ä9]š‰Lj^®ïJÅ½|Ñ½HÞ¶²Æ£Hú?ìð‡yÝc]b¡ÏËMºf(¢ÛT´ýFVÏÓ&é¬Aþ±åB{aÿ¸0ª`'ü !½š9¿ãÑå^æ™‚‘¿)cùAÄz‘‡{q’üç–ÛÇ‹¼ª§ÄW-K=¸–ìº¡€æ¸—ØuÑÖB‰®VØJ?Þi€ŽwòGJ£‚™X¶óaž>åBô£Š'ÀÿhÈ½bÇ—è~Ø`µFËPR¸LëE"-óßÀfÀdq9]m2ññ85{™ÖÚôpø˜O~eg øç– ¾·Á4AÌÂã6£Þ ±™ñ´D¶ü«r‚ùGìà²ÎïO¿¸Êõý?æâ‹wÂ°®qáFÞ"[AÝ“Y6Þîo^_±À¦•Ñ û>ŠdÓDœš¦Äf&Rc>Œ Ì—Ø5é5è¡Ž4ãG…ÞÇ‚w“ŽSº oŠ¡@úx%Îí©vqÿ²wñ‘œ†àÈrÓÏR’'ªð|nÙ¸Ÿ£Ü6jí`ƒÒo “CdH!øM»£ ·ïfØÕïý!%»U² ˜uS×òÈ!šUYéžL|Íƒ½vý@¤¡?#\À@[Låžs`ƒFAŸjœó%¿³þS’‰ˆåO1º6¤G‡¶ð!Ÿ¾]oôÍBúNðn^ÕJšÛÞe½õKË½â\~Uv{`–4r Ý£~ay[á¼Ó~9d=Å”3ªˆ÷Ná¾£š1#ÉŽÂzÇÁì3]]¯–®ùmethod('getColumnNames') ->will($this->returnValue(array("id", "col1", "col2"))); $dbi->expects($this->any()) ->method('tryQuery') ->will($this->returnValue(true)); $dbi->expects($this->any()) ->method('getTables') ->will( $this->returnValue(array("PMA_table", "PMA_table1", "PMA_table2")) ); $dbi->expects($this->any())->method('escapeString') ->will($this->returnArgument(0)); } /** * Test for PMA_centralColumnsGetParams * * @return void */ public function testPMACentralColumnsGetParams() { $this->assertSame( array( 'user' => 'pma_user', 'db' => 'phpmyadmin', 'table' => 'pma_central_columns' ), PMA_centralColumnsGetParams() ); } /** * Test for PMA_getColumnsList * * @return void */ public function testPMAGetColumnsList() { $GLOBALS['dbi']->expects($this->exactly(2)) ->method('fetchResult') ->willReturnOnConsecutiveCalls( $this->_columnData, array_slice($this->_columnData, 1, 2) ); $this->assertEquals( $this->_modifiedColumnData, PMA_getColumnsList('phpmyadmin') ); $this->assertEquals( array_slice($this->_modifiedColumnData, 1, 2), PMA_getColumnsList('phpmyadmin', 1, 2) ); } /** * Test for PMA_getCentralColumnsCount * * @return void */ function testPMAGetCentralColumnsCount() { $GLOBALS['dbi']->expects($this->once()) ->method('fetchResult') ->with( "SELECT count(db_name) FROM `pma_central_columns` " . "WHERE db_name = 'phpmyadmin';", null, null, $GLOBALS['controllink'] ) ->will( $this->returnValue(array(3)) ); $this->assertEquals( 3, PMA_getCentralColumnsCount('phpmyadmin') ); } /** * Test for PMA_syncUniqueColumns * * @return void */ public function testPMASyncUniqueColumns() { $_REQUEST['db'] = 'PMA_db'; $_REQUEST['table'] = 'PMA_table'; $this->assertTrue( PMA_syncUniqueColumns(array('PMA_table')) ); } /** * Test for PMA_deleteColumnsFromList * * @return void */ public function testPMADeleteColumnsFromList() { $_REQUEST['db'] = 'PMA_db'; $_REQUEST['table'] = 'PMA_table'; // when column exists in the central column list $GLOBALS['dbi']->expects($this->at(4)) ->method('fetchResult') ->with( "SELECT col_name FROM `pma_central_columns` " . "WHERE db_name = 'PMA_db' AND col_name IN ('col1');", null, null, $GLOBALS['controllink'] ) ->will( $this->returnValue(array('col1')) ); $GLOBALS['dbi']->expects($this->at(7)) ->method('tryQuery') ->with( "DELETE FROM `pma_central_columns` " . "WHERE db_name = 'PMA_db' AND col_name IN ('col1');", $GLOBALS['controllink'] ) ->will( $this->returnValue(array('col1')) ); $this->assertTrue( PMA_deleteColumnsFromList(array("col1"), false) ); // when column does not exist in the central column list $this->assertInstanceOf( 'PMA\libraries\Message', PMA_deleteColumnsFromList(array('column1'), false) ); $this->assertInstanceOf( 'PMA\libraries\Message', PMA_deleteColumnsFromList(array('PMA_table')) ); } /** * Test for PMA_makeConsistentWithList * * @return void */ public function testPMAMakeConsistentWithList() { $GLOBALS['dbi']->expects($this->any()) ->method('fetchResult') ->will( $this->returnValue($this->_columnData) ); $GLOBALS['dbi']->expects($this->any()) ->method('fetchValue') ->will( $this->returnValue('PMA_table=CREATE table `PMA_table` (id integer)') ); $this->assertTrue( PMA_makeConsistentWithList("phpmyadmin", array('PMA_table')) ); } /** * Test for PMA_getCentralColumnsFromTable * * @return void */ public function testPMAGetCentralColumnsFromTable() { $db = 'PMA_db'; $table = 'PMA_table'; $GLOBALS['dbi']->expects($this->once()) ->method('fetchResult') ->with( "SELECT col_name FROM `pma_central_columns` " . "WHERE db_name = 'PMA_db' AND col_name IN ('id','col1','col2');", null, null, $GLOBALS['controllink'] ) ->will( $this->returnValue(array('id','col1')) ); $this->assertEquals( array("id", "col1"), PMA_getCentralColumnsFromTable($db, $table) ); } /** * Test for PMA_getCentralColumnsFromTable with $allFields = true * * @return void */ public function testPMAGetCentralColumnsFromTableWithAllFields() { $db = 'PMA_db'; $table = 'PMA_table'; $GLOBALS['dbi']->expects($this->once()) ->method('fetchResult') ->with( "SELECT * FROM `pma_central_columns` " . "WHERE db_name = 'PMA_db' AND col_name IN ('id','col1','col2');", null, null, $GLOBALS['controllink'] ) ->will( $this->returnValue(array_slice($this->_columnData, 0, 2)) ); $this->assertEquals( array_slice($this->_modifiedColumnData, 0, 2), PMA_getCentralColumnsFromTable($db, $table, true) ); } /** * Test for PMA_updateOneColumn * * @return void */ public function testPMAUpdateOneColumn() { $this->assertTrue( PMA_updateOneColumn( "phpmyadmin", "", "", "", "", "", "", "", "", "" ) ); $this->assertTrue( PMA_updateOneColumn( "phpmyadmin", "col1", "", "", "", "", "", "", "", "" ) ); } /** * Test for PMA_updateMultipleColumn * * @return void */ public function testPMAUpdateMultipleColumn() { $_POST['db'] = 'phpmyadmin'; $_POST['orig_col_name'] = array("col1","col2"); $_POST['field_name'] = array("col1","col2"); $_POST['field_default_type'] = array("",""); $_POST['col_extra'] = array("",""); $_POST['field_length'] = array("",""); $_POST['field_attribute'] = array("",""); $_POST['field_type'] = array("",""); $_POST['field_collation'] = array("",""); $this->assertTrue( PMA_updateMultipleColumn() ); } /** * Test for PMA_getHTMLforEditingPage * * @return void */ public function testPMAGetHTMLforEditingPage() { $GLOBALS['dbi']->expects($this->any()) ->method('fetchResult') ->with( "SELECT * FROM `pma_central_columns` " . "WHERE db_name = 'phpmyadmin' AND col_name IN ('col1','col2');", null, null, $GLOBALS['controllink'] ) ->will( $this->returnValue($this->_columnData) ); $result = PMA_getHTMLforEditingPage( array("col1", "col2"), 'phpmyadmin' ); $this->assertContains( 'assertContains( PMA_getCentralColumnsEditTableHeader($header_cells), $result ); $list_detail_cols = PMA_findExistingColNames( 'phpmyadmin', "'col1','col2'", true ); $this->assertContains( PMA_getHTMLforCentralColumnsEditTableRow( $list_detail_cols[0], false, 0 ), $result ); $this->assertContains( PMA_getCentralColumnsEditTableFooter(), $result ); } /** * Test for PMA_getHTMLforTableNavigation * * @return void */ public function testPMAGetHTMLforTableNavigation() { $result = PMA_getHTMLforTableNavigation(0, 0, 'phpmyadmin'); $this->assertContains( 'assertContains( __('Search this table'), $result ); $result_1 = PMA_getHTMLforTableNavigation(25, 10, 'phpmyadmin'); $this->assertContains( '

' . PMA_URL_getHiddenInputs( 'phpmyadmin' ), $result_1 ); $this->assertContains( '', $result_1 ); $this->assertContains( PMA\libraries\Util::pageselector( 'pos', 10, 2, 3 ), $result_1 ); $this->assertContains( '', $result_1 ); } /** * Test for PMA_getCentralColumnsTableHeader * * @return void */ public function testPMAGetCentralColumnsTableHeader() { $this->assertContains( 'expects($this->once()) ->method('fetchResult') ->with( "SELECT * FROM `pma_central_columns` " . "WHERE db_name = 'phpmyadmin';", null, null, $GLOBALS['controllink'] ) ->will( $this->returnValue($this->_columnData) ); $this->assertEquals( json_encode($this->_modifiedColumnData), PMA_getCentralColumnsListRaw('phpmyadmin', '') ); } /** * Test for PMA_getCentralColumnsListRaw with a table name * * @return void */ public function testPMAGetCentralColumnsListRawWithTable() { $GLOBALS['dbi']->expects($this->once()) ->method('fetchResult') ->with( "SELECT * FROM `pma_central_columns` " . "WHERE db_name = 'phpmyadmin' AND col_name " . "NOT IN ('id','col1','col2');", null, null, $GLOBALS['controllink'] ) ->will( $this->returnValue($this->_columnData) ); $this->assertEquals( json_encode($this->_modifiedColumnData), PMA_getCentralColumnsListRaw('phpmyadmin', 'table1') ); } /** * Test for PMA_getHTMLforAddNewColumn * * @return void */ public function testPMAGetHTMLforAddNewColumn() { $result = PMA_getHTMLforAddNewColumn('phpmyadmin'); $this->assertContains( 'assertContains( 'assertContains( __('Add new column'), $result ); $this->assertContains( PMA_URL_getHiddenInputs('phpmyadmin'), $result ); } /** * Test for PMA_configErrorMessage * * @return void */ public function testPMAConfigErrorMessage() { $this->assertInstanceOf( 'PMA\libraries\Message', PMA_configErrorMessage() ); } /** * Test for PMA_findExistingColNames * * @return void */ public function testPMAFindExistingColNames() { $GLOBALS['dbi']->expects($this->once()) ->method('fetchResult') ->with( "SELECT * FROM `pma_central_columns` WHERE db_name = 'phpmyadmin'" . " AND col_name IN ('col1');", null, null, $GLOBALS['controllink'] ) ->will( $this->returnValue(array_slice($this->_columnData, 1, 1)) ); $this->assertEquals( array_slice($this->_modifiedColumnData, 1, 1), PMA_findExistingColNames('phpmyadmin', "'col1'", true) ); } /** * Test for PMA_getHTMLforTableDropdown * * @return void */ public function testPMAGetHTMLforTableDropdown() { $db = 'PMA_db'; $result = PMA_getHTMLforTableDropdown($db); $this->assertContains( '' . '' . '', $result ); } /** * Test for PMA_getCentralColumnsTableFooter * * @return void */ public function testPMAGetCentralColumnsTableFooter() { $pmaThemeImage = "pmaThemeImage"; $text_dir = "text_dir"; if (!defined("PMA_USR_BROWSER_AGENT")) { define("PMA_USR_BROWSER_AGENT", "other"); } $result = PMA_getCentralColumnsTableFooter($pmaThemeImage, $text_dir); $this->assertContains( 'assertContains("With selected:", $result); $this->assertContains( '