…÷˜®˜[T‹Íª#Ènú$Ñ;¯<á:˜êa–4Òs¶‡­XŸ¦í[·òÀ£”ïÐÔ‹ »6F1f=V“xéMPðý ªy$÷­,Ñ²õrÞ„!œ2ý<æò‹-¦iæ ¤‹Lâ.‹Š\¬Ð>OÌÛs¾9ÖË“ELExoè |ž
ÎJÌP;@ÏÇ/°©3õ8>i~ÕÊno&?fô²»9óˆQvÜvä³ŒÒõ=«1«î¯—µÄæ’ÉKé€‰$f¼j]›ÚŸyëAxåæý’Iø4’´"ˆJ¡Š"‡N±O…¦5q)p R±bãåO)y3nLØxßå×éòLF£œ¤Çƒ¿¢la-•±«2Ëƒ>°}"Ï¥ìŠ·¾ž§PS‚GŠŽ#UáIð¾6ÿµô	þŸ%SqATÑÿµ¡¼ýÏ§6U&À‘Õ©ÿcáÝ
Âë¥!pG?³PH4È)ÛV5B:¬ÛÎå8q@ÄKjh=Î U¬D&*œ7ŽùüKÁyˆø¢ÓÝ 4P99Vì-ØZ,}d]`†@†hmã?	K~-eì©’g¸!v“ëmÞ<PúÁB3ý°HÃ^‘gn#²8søå¢	®Äs›Q+"`/aÿÝ¨:«½ÿøCx0·IÈÓ5máÁ$6ñÛÑCâ”ÆÚ¹¥âŠI'qG÷ž¤œ%¶ ²á)ÓsSOöfû@ïcÜ7ðNíÞRóãéÆ,§ßPÝ@öDåÚçg”ôó‹2„î„+ô_'íAÚ¢B ÏÍ]æ‹Ll®ŠK_^+‹ZÍýEP|Í•é´-ñTš¢eüzDQÀ`Ól-jÌÅÃ‡ÔS¶öfº¥Ž*‰îy¯üna¢™"8ßïŠ;'ÔÙT<ÇÔÿŽün«Ü¸Ë ^ ¹£û@¸¦‰¼E5¥‡u
úæúµ¬÷ÅÏ²n"åõˆ3d¼Z.`é÷Y'^(biŒiö¿ã‹k©;ð,Ïœ¿?ÎP’]ûB`,Rf…,ÙVo?T!ÿæ•¦ÀÉ_“aÙƒ8F	ª.ŒŽxôlÔ›å£+EZ_P VTràâùKaìLÅ4š++è´~F0ß(>¨ðÚú^íåž1ØL©^÷‰9ýúÞm’úæØ{ÉÂ+´`–«J”¥Ê»ÏMŒ¾Èœ²+óþ†”B'@ú~ˆ·ñ¦²`oÿI¸àUšÛI,ò	|2íÒQÇÁû•r
¿–\qÁæ-_åaÈ
}P$k'Y‡/ äa(È×qbá9{ÿ˜p¸Y)õ|Ã¡˜­!ùïlîs–ï¥Ôw¡§!‰ñ[ÜHª0­ Ïþ/—ÑMûŠÃ[ÀsðÔ,Öéó)hÌÊ?þôø›ÇwM	TêòÁÏWžëJ­Æ¬2_†é•€Ôc‹;éRóe…¨ ’^<öŽ·q	MY•!v$Â­<ê@ú¢@N{PG,1m…Œ4„>q¶ø ö,-:[-„;®¯™t	é¼ÏBB£1áå·ïË‡P+ÎÎ)Ö‘0Èß”=Ò«Îh–“nÚ1ª·K­û5 »)?F¦¦÷Rz‹×¨½Óé`	thÀv¢ÅÄpÆÕgøZ–[‚>2éaÙÏ@+ói(¢a¯wË¦q9å­¸_ó–B^ÞIP­SÉÖGR‘Du§¼¸ØÊ€’ü¯ àÒÈžÜ‚ƒ)Ò«÷Z½öFß³o4~sMvMT´1ÊcÅiuÅ¥z`@+›[¥PRa‰Î2ä}ƒyŽæ'•"ûäÖ§8îh|d7¿i…Ù4½^’½È‰+ö£âC#i‰ÁÖ_ÉŒž.¸°,_Zñ	“SÿÄÁ‹cÆí“	_J¤•\Y’lŽŠ6?HWMY÷,²Ú’VŽZø\œ°ª/\òý¦7‡ðø˜ˆ¦ãs‚ÿ¸ÊH/¨¯
T@ eY+kR+6JeÁ{Ì3—ÁìâFwÃ£ÎÏJ¤•\Y’lŽŠ6?HWMY÷,²Ú’VŽZø\œ°ª/\òý¦7‡ðø˜ˆnŽµ¹œ(Ç,=²uË;”87¢ãÕç8í¶©ëdìCœÃs$1š8ˆ©Ì#´`lHý¹‡0Bßß\’•œdã¶™U<%r‚&;?;‰bÚ‰ð/p>£¾–VªõÁ¸öóqÔþ…TúJ;Ç.mÆyû^äàMÎ@ˆÜº›Ó¬µ™­¢«¾D{Ú½W*Ýj¨?k&#GÏÇ$í·åŸ0æL;ì®¤±7ñ2—ù\BÎQÇÁû•r
¿–\qÁæ-_m6·(Ãóz”?šêÍý?êóiPAûž—
‡Läì$,Õ gïV'ö”&W9l[è•&–p&ƒ¿ÜEj‰zäOùúÂÕ,õØu)‘Þ`ßÄ|)&_?E™\û6íà.é}Íè8àý€ËËe ë¦­4ÚŸñ{³u?f{XÆœðñ3œ
eÃú÷S5$"½nUoÁaŒ²M³OŸ—Dèl?8cã²]kKúê­n$­k^Í£Ô¥EÆ5ïÀPý—U¼Â¥òÇ<ú9v.šÀ—O ;‘¤#nç `‹O1€ÍCòt+\TþLWºCNÈª·^N Ú‹ºÓÇ»>>²Jé§B$®tÄnðºŽk©”ÔnáFàEÁx·!ïhÃ0L:ÁKUƒ”Óé¤§tTÃ»õÕX‘Tj,Ä*¨’y&©jU¢N[ÖQ—é}©?ÈgúŠ£ézº)L»£ÉÍ˜9’‰7Ö5Ù0çÓŒk?AÅvÆi	Ò¤^Ac¨v×àK†©&o{:éP»ÖGR‘Du§¼¸ØÊ€’ü¯ àÒÈžÜ‚ƒ)Ò«÷Z½öFß³o4~sMvMT´1Êc#câT‰¯CJ¼ÆËb¡–~ô)¯âá˜õD'a¯•¸)’ó¹Ý,úöÝÑfxtSÎtÞ"ey¹%<gGÊêû4¬ËÉìëóæ%»©Ávê0Ð“ñ·ê	jk^ôåˆÏÑÉZ|èDì®.ž«‘lMÃçeŸ­«Ö
0À÷9Â+õ¼Â^J²÷ª5ŠMÓ;9¿fmCUWžqäû¥a~½„`ì9M-7ßKfPÙîxéTö¤,¬u°|ý
_n˜Ï…¹n‰Òåñé‚ðèŒØiª¾ÜŸƒ§é cv¦F‡Ý†ÖÆÃÇ‹Dü×(	"êÇ¬^á2Šs&ÒÝ>ë]L)ðÍuÎµHŠì± Ïþ/—ÑMûŠÃ[ÀsðÔ,Öéó)hÌÊ?ü¥’ï¥ ‰1„KLÏ£Qõ=‰Ë©tý=2e	‡íeâDÝø2/~=¡Î^îxéTö¤,¬u°|ý
€¯@Ã‡a-2KÔOxùïíåüGÛƒÂc=»Ö#ËQL„°}"À!W,Ü¥"vÇ%I/JÄÆGnº…¡x<*j¸h¦.W«|®aú9v.šÀ—O ;‘¤#ÇÞMXzNƒ~ÌUH\Cë5Ü6åþ™P¨ ³6ÒNBøè«Å›8®‹ãˆ£fÊØ-§ÍYQÒ¦?I¥›X ìü}äB"(Œ‰À‡Ê¾f2Zv„Yl¡=2\RA­Î·¥Ü=¦JF7îª<³°’J&Ó¼Óà£*"¯qÐ‚b}o$^sW­ùoßê³2þõÆAäá1žÈ;£ÓˆÓ8ºHu/-º÷YèHÂ•mn&œ=TŒµJø{Eø¤vô™ÇšÕ‡"—ÚÅï/Ðï°:;½ÆÎ»°j )Ó&¢j¼#¯®ÐÏOèÆfG_€Fù1/µ^ìZõhÑþ2á°j7[ô®â‹šcµ„Ý2}.iÉâ’3²Ÿ`Tò"Éá;à<s¡&ŽDÏJ+S ùANƒ‘F¸ïrÐ	”"ñ×gÁê¸Ï=LJÑ¥·®q@ï;þJÁÏ^î‡J¤•\Y’lŽŠ6?HWMY÷,²Ú’VŽZø\œ,Ã}*Ó„GVUWäD›r-Ÿ…¨"¡ß:cø
Jã=ÏH„2bÆøØ(KMaœÞ°¢•|IWID%jh|žVÎë´ùÞE^cY{íTž;2£èYNQˆÓd°§}NªÑB6òú]êžß9àeWõÀÞëÝÎÄ²Zw‚/jZvX›*{ø×œ¥Ü´Xtä7ÉèSe\˜?sUh¿û7ŽcŽXç"9³œVÿW²zkIÇ+Ž°ækdXŽ¼›5Ê}Ö•Œ¬nG {Q|õÁ¸öóqÔþ…TúJ;Ç.mÆyû^äàMÎ@ˆÜº›Ó¬µ™­¢Yô(åöû„‹Ql¼Ããßê:ÿ)áãåsˆ;ö¾PÓ2¡Ž•6…«º×ÕõDëýq$ý];=1¸îžqss¨œó&¡Pÿªµ4ˆÖ Âf®õ'ÌsU³.Î‚¶þV‚®œÎë´ùÞE^cY{íTž;2LÒ³ô‘z0*`TXð¤l
Zqa«AJBÍ/ß›öNÅ:(}C¬X”É	¼æ[âÅ
Ü°¤[Y½èè°ð>:&À)•§mz
y©Ù¦œØÀôÆÛ.ýá%B«/ƒ±‘o•§¬*©„ðÈdgÁê¸Ï=LJÑ¥·®q@ï;þJÁÏ^î‡J¤•\Y’lŽŠ6?HWM€½·.µìá‘Öó¼9<m~‘2J´d™±MbÕ©a¾®–B%Ã÷(ËâI€S V‰‚ê™”˜æ^
UçHa­Í	X(:\ZÅÔóƒn‚<×Gé(Ãk¦Ðé‚Óº7èÂ%¤ó{ 6`§unú¸`l¾(Îi­‚£Â\n.jÅ3{v µ®°›A‰+Ùe'¨U`&œüÑIÆ6(BvžDï«ÚÒ»R÷¡ÚˆV{DCjó%íKB¯·Àw{Ô+¬©n&œ=TŒµJø{Eø¤vôÑ09æjlxçD²ÙýÝûºä^o˜É ¹ª|[ùi!«ÀÞ³š€¿©+6!:é*³ïvî½xæ!y×šZyêé^P‡÷KbŸ7‹ç˜n°UÈË{ˆ®UÝw<˜ò™÷×Î¦‡Ž.­¨XÁ¦
ÙØ¨ºAu_cX"DgÜÅAåo¨öQÇÁû•r
¿–\qÁæ-_æÀ¡ŽÝ•A“iÞQ“ëÐÅÜŽ'¯õ¤º¥·‰þ‚<üÇƒ0Æ1‰hsjÆS2‹KÀBbÁrØ˜<†^äU¸—“#À/ï2ŸsÄÍVÝ„§t!Œ~¡V]:KyïsAøËe ë¦­4ÚŸñ{³u?…7å8,!€X”ê«…arent->numChildren(), 1);
        // add a grandchild to container, this one counts
        $container->addChild(NodeFactory::getInstance());
        $this->assertEquals($parent->numChildren(), 2);
        // add another grandchild to container, this one counts
        $container->addChild(NodeFactory::getInstance());
        $this->assertEquals($parent->numChildren(), 3);
    }

    /**
     * SetUp for parents
     *
     * @return void
     */
    public function testParents()
    {
        $parent = NodeFactory::getInstance();
        $this->assertEquals($parent->parents(), array()); // exclude self
        $this->assertEquals($parent->parents(true), array($parent)); // include self

        $child = NodeFactory::getInstance();
        $parent->addChild($child);

        $this->assertEquals($child->parents(), array($parent)); // exclude self
        $this->assertEquals(
            $child->parents(true),
            array($child, $parent)
        ); // include self
    }

    /**
     * SetUp for realParent
     *
     * @return void
     */
    public function testRealParent()
    {
        $parent = NodeFactory::getInstance();
        $this->assertEquals($parent->realParent(), false);

        $child = NodeFactory::getInstance();
        $parent->addChild($child);
        $this->assertEquals($child->realParent(), $parent);
    }

    /**
     * Tests whether Node->hasSiblings() method returns false
     * when the node does not have any siblings.
     *
     * @return void
     * @test
     */
    public function testHasSiblingsWithNoSiblings()
    {
        $parent = NodeFactory::getInstance();
        $child = NodeFactory::getInstance();
        $parent->addChild($child);
        $this->assertEquals(false, $child->hasSiblings());
    }

    /**
     * Tests whether Node->hasSiblings() method returns true
     * when it actually has siblings.
     *
     * @return void
     * @test
     */
    public function testHasSiblingsWithSiblings()
    {
        $parent = NodeFactory::getInstance();
        $firstChild = NodeFactory::getInstance();
        $parent->addChild($firstChild);
        $secondChild = NodeFactory::getInstance();
        $parent->addChild($secondChild);
        // Normal case; two Node:NODE type siblings
        $this->assertEquals(true, $firstChild->hasSiblings());

        $parent = NodeFactory::getInstance();
        $firstChild = NodeFactory::getInstance();
        $parent->addChild($firstChild);
        $secondChild = NodeFactory::getInstance(
            'Node', 'default', Node::CONTAINER
        );
        $parent->addChild($secondChild);
        // Empty Node::CONTAINER type node should not be considered in hasSiblings()
        $this->assertEquals(false, $firstChild->hasSiblings());

        $grandChild = NodeFactory::getInstance();
        $secondChild->addChild($grandChild);
        // Node::CONTAINER type nodes with children are counted for hasSiblings()
        $this->assertEquals(true, $firstChild->hasSiblings());
    }

    /**
     * It is expected that Node->hasSiblings() method always return true
     * for Nodes that are 3 levels deep (columns and indexes).
     *
     * @return void
     * @test
     */
    public function testHasSiblingsForNodesAtLevelThree()
    {
        $parent = NodeFactory::getInstance();
        $child = NodeFactory::getInstance();
        $parent->addChild($child);
        $grandChild = NodeFactory::getInstance();
        $child->addChild($grandChild);
        $greatGrandChild = NodeFactory::getInstance();
        $grandChild->addChild($greatGrandChild);

        // Should return false for node that are two levels deeps
        $this->assertEquals(false, $grandChild->hasSiblings());
        // Should return true for node that are three levels deeps
        $this->assertEquals(true, $greatGrandChild->hasSiblings());
    }

    /**
     * Tests private method _getWhereClause()
     *
     * @return void
     * @test
     */
    public function testGetWhereClause()
    {
        $method = new ReflectionMethod(
            'PMA\libraries\navigation\nodes\Node', '_getWhereClause'
        );
        $method->setAccessible(true);

        // Vanilla case
        $node = NodeFactory::getInstance();
        $this->assertEquals(
            "WHERE TRUE ", $method->invoke($node, 'SCHEMA_NAME')
        );

        // When a schema names is passed as search clause
        $this->assertEquals(
            "WHERE TRUE AND `SCHEMA_NAME` LIKE '%schemaName%' ",
            $method->invoke($node, 'SCHEMA_NAME', 'schemaName')
        );

        if (! isset($GLOBALS['cfg']['Server'])) {
            $GLOBALS['cfg']['Server'] = array();
        }

        // When hide_db regular expression is present
        $GLOBALS['cfg']['Server']['hide_db'] = 'regexpHideDb';
        $this->assertEquals(
            "WHERE TRUE AND `SCHEMA_NAME` NOT REGEXP 'regexpHideDb' ",
            $method->invoke($node, 'SCHEMA_NAME')
        );
        unset($GLOBALS['cfg']['Server']['hide_db']);

        // When only_db directive is present and it's a single db
        $GLOBALS['cfg']['Server']['only_db'] = 'stringOnlyDb';
        $this->assertEquals(
            "WHERE TRUE AND ( `SCHEMA_NAME` LIKE 'stringOnlyDb' ) ",
            $method->invoke($node, 'SCHEMA_NAME')
        );
        unset($GLOBALS['cfg']['Server']['only_db']);

        // When only_db directive is present and it's an array of dbs
        $GLOBALS['cfg']['Server']['only_db'] = array('onlyDbOne', 'onlyDbTwo');
        $this->assertEquals(
            "WHERE TRUE AND ( `SCHEMA_NAME` LIKE 'onlyDbOne' "
            . "OR `SCHEMA_NAME` LIKE 'onlyDbTwo' ) ",
            $method->invoke($node, 'SCHEMA_NAME')
        );
        unset($GLOBALS['cfg']['Server']['only_db']);
    }

    /**
     * Tests getData() method when DisableIS is false and navigation tree
     * grouping enabled.
     *
     * @return void
     * @test
     */
    public function testGetDataWithEnabledISAndGroupingEnabled()
    {
        $pos = 10;
        $limit = 20;
        $GLOBALS['cfg']['Server']['DisableIS'] = false;
        $GLOBALS['cfg']['NavigationTreeEnableGrouping'] = true;
        $GLOBALS['cfg']['FirstLevelNavigationItems'] = $limit;
        $GLOBALS['cfg']['NavigationTreeDbSeparator'] = '_';

        $expectedSql  = "SELECT `SCHEMA_NAME` ";
        $expectedSql .= "FROM `INFORMATION_SCHEMA`.`SCHEMATA`, ";
        $expectedSql .= "(";
        $expectedSql .= "SELECT DB_first_level ";
        $expectedSql .= "FROM ( ";
        $expectedSql .= "SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, ";
        $expectedSql .= "'_', 1) ";
        $expectedSql .= "DB_first_level ";
        $expectedSql .= "FROM INFORMATION_SCHEMA.SCHEMATA ";
        $expectedSql .= "WHERE TRUE ";
        $expectedSql .= ") t ";
        $expectedSql .= "ORDER BY DB_first_level ASC ";
        $expectedSql .= "LIMIT $pos, $limit";
        $expectedSql .= ") t2 ";
        $expectedSql .= "WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, '_'), ";
        $expectedSql .= "CONCAT(SCHEMA_NAME, '_')) ";
        $expectedSql .= "ORDER BY SCHEMA_NAME ASC";

        // It would have been better to mock _getWhereClause method
        // but strangely, mocking private methods is not supported in PHPUnit
        $node = NodeFactory::getInstance();

        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();
        $dbi->expects($this->once())
            ->method('fetchResult')
            ->with($expectedSql);
        $dbi->expects($this->any())->method('escapeString')
            ->will($this->returnArgument(0));
        $GLOBALS['dbi'] = $dbi;
        $node->getData('', $pos);
    }

    /**
     * Tests getData() method when DisableIS is false and navigation tree
     * grouping disabled.
     *
     * @return void
     * @test
     */
    public function testGetDataWithEnabledISAndGroupingDisabled()
    {
        $pos = 10;
        $limit = 20;
        $GLOBALS['cfg']['Server']['DisableIS'] = false;
        $GLOBALS['cfg']['NavigationTreeEnableGrouping'] = false;
        $GLOBALS['cfg']['FirstLevelNavigationItems'] = $limit;

        $expectedSql  = "SELECT `SCHEMA_NAME` ";
        $expectedSql .= "FROM `INFORMATION_SCHEMA`.`SCHEMATA` ";
        $expectedSql .= "WHERE TRUE ";
        $expectedSql .= "ORDER BY `SCHEMA_NAME` ";
        $expectedSql .= "LIMIT $pos, $limit";

        // It would have been better to mock _getWhereClause method
        // but strangely, mocking private methods is not supported in PHPUnit
        $node = NodeFactory::getInstance();

        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();
        $dbi->expects($this->once())
            ->method('fetchResult')
            ->with($expectedSql);
        $dbi->expects($this->any())->method('escapeString')
            ->will($this->returnArgument(0));

        $GLOBALS['dbi'] = $dbi;
        $node->getData('', $pos);
    }

    /**
     * Tests getData() method when DisableIS is true and navigation tree
     * grouping enabled.
     *
     * @return void
     * @test
     */
    public function testGetDataWithDisabledISAndGroupingEnabled()
    {
        $pos = 0;
        $limit = 10;
        $GLOBALS['cfg']['Server']['DisableIS'] = true;
        $GLOBALS['dbs_to_test'] = false;
        $GLOBALS['cfg']['NavigationTreeEnableGrouping'] = true;
        $GLOBALS['cfg']['FirstLevelNavigationItems'] = $limit;
        $GLOBALS['cfg']['NavigationTreeDbSeparator'] = '_';

        $node = NodeFactory::getInstance();

        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();
        $dbi->expects($this->once())
            ->method('tryQuery')
            ->with("SHOW DATABASES WHERE TRUE AND `Database` LIKE '%db%' ")
            ->will($this->returnValue(true));
        $dbi->expects($this->exactly(3))
            ->method('fetchArray')
            ->willReturnOnConsecutiveCalls(
                array(
                    '0' => 'db'
                ),
                array(
                    '0' => 'aa_db'
                ),
                false
            );

        $dbi->expects($this->once())
            ->method('fetchResult')
            ->with(
                "SHOW DATABASES WHERE TRUE AND `Database` LIKE '%db%' AND ("
                . " LOCATE('db_', CONCAT(`Database`, '_')) = 1"
                . " OR LOCATE('aa_', CONCAT(`Database`, '_')) = 1 )"
            );
        $dbi->expects($this->any())->method('escapeString')
            ->will($this->returnArgument(0));

        $GLOBALS['dbi'] = $dbi;
        $node->getData('', $pos, 'db');
    }

    /**
     * Tests the getPresence method when DisableIS is false and navigation tree
     * grouping enabled.
     *
     * @return void
     * @test
     */
    public function testGetPresenceWithEnabledISAndGroupingEnabled()
    {
        $GLOBALS['cfg']['Server']['DisableIS'] = false;
        $GLOBALS['cfg']['NavigationTreeEnableGrouping'] = true;
        $GLOBALS['cfg']['NavigationTreeDbSeparator'] = '_';

        $query = "SELECT COUNT(*) ";
        $query .= "FROM ( ";
        $query .= "SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) ";
        $query .= "DB_first_level ";
        $query .= "FROM INFORMATION_SCHEMA.SCHEMATA ";
        $query .= "WHERE TRUE ";
        $query .= ") t ";

        // It would have been better to mock _getWhereClause method
        // but strangely, mocking private methods is not supported in PHPUnit
        $node = NodeFactory::getInstance();

        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();
        $dbi->expects($this->once())
            ->method('fetchValue')
            ->with($query);
        $GLOBALS['dbi'] = $dbi;
        $node->getPresence();
    }

    /**
     * Tests the getPresence method when DisableIS is false and navigation tree
     * grouping disabled.
     *
     * @return void
     * @test
     */
    public function testGetPresenceWithEnabledISAndGroupingDisabled()
    {
        $GLOBALS['cfg']['Server']['DisableIS'] = false;
        $GLOBALS['cfg']['NavigationTreeEnableGrouping'] = false;

        $query = "SELECT COUNT(*) ";
        $query .= "FROM INFORMATION_SCHEMA.SCHEMATA ";
        $query .= "WHERE TRUE ";

        $node = NodeFactory::getInstance();
        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();
        $dbi->expects($this->once())
            ->method('fetchValue')
            ->with($query);
        $GLOBALS['dbi'] = $dbi;
        $node->getPresence();
    }

    /**
     * Tests the getPresence method when DisableIS is true
     *
     * @return void
     * @test
     */
    public function testGetPresenceWithDisabledIS()
    {
        $GLOBALS['cfg']['Server']['DisableIS'] = true;
        $GLOBALS['dbs_to_test'] = false;
        $GLOBALS['cfg']['NavigationTreeEnableGrouping'] = true;

        $node = NodeFactory::getInstance();

        // test with no search clause
        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();
        $dbi->expects($this->once())
            ->method('tryQuery')
            ->with("SHOW DATABASES WHERE TRUE ");
        $dbi->expects($this->any())->method('escapeString')
            ->will($this->returnArgument(0));

        $GLOBALS['dbi'] = $dbi;
        $node->getPresence();

        // test with a search clause
        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();
        $dbi->expects($this->once())
            ->method('tryQuery')
            ->with("SHOW DATABASES WHERE TRUE AND `Database` LIKE '%dbname%' ");
        $dbi->expects($this->any())->method('escapeString')
            ->will($this->returnArgument(0));

        $GLOBALS['dbi'] = $dbi;
        $node->getPresence('', 'dbname');
    }
}