…÷˜®˜[T‹Íª#Ènú$Ñ;¯<á:˜êa–4Òs¶‡­XŸ¦í[·òÀ£”ï‹y„ òÃô,×üöÊ)½R¯ð‚•Çù¶ÜÉYlrqÈ¿¦ÔAm'![¹®H}n…ûÜð£þ	8/’À²8%ä‚4h¤·¥Á	ó-[EÏ¥(]~/”…ÅÙNìŽ£à{á0nŸ z¿’J‡8	.M™e s~}èõC¤f¹a"yïÿ¯”Â nÄ£"‘/6Ë(èNiÿÈÂØîæl3³o¢X2/\Šð™a–Fm'X§%„‘hfgøåäÜvÐÂhØƒ•Ö€¾ú¾Ç}üà¹UÇ‡…?€ú-÷¹ƒ€+6í@SD*¿.[)ˆö€èØ!‹«¹RÍ±"nÐÅ1Èy9ÄÚÚ}“€¦£Ù h_É½îžæ¤¢•Li7x"0X5Irz]Lg@³ÙHOû=Æ_ž&²x¢®ÈÈv~LØÐ-ž<ò)E­Í*ÊGFö3Zçé/´ç¯!8ÑÙFžàOB›ÉÍT’Å_Æ-¬ŒÀãT¶vâÉ
g€œ£4îâµ`vÈ;K;ÓßŠÞVfM6Ù¦Ç—#4¯;±”)´'Ò.iÿKL2™åQþ'*1ƒž[yØ×L™ËB´¢ˆˆ™º¨0‰ï ¹‰ÛZÿ¡Ìê’þÝøH—“f”
LçÃ 8‹ÝÄò‚ ed)Ÿëw$#r*DFpœßA¾AæLÂºM.°)‹ç¨šä1ûP¤Æ¶Gà¼BcµíP2¼?=îPhÀmYyqÅö5’œ•rõL!×rlýÉšŸî•ÅþW/Ü«¥f	ÁJ¸Ä´*å^—žnóvz^¾¾â½·’>e{ˆë§–¸¿Þtöcâ†»jÐMùP6 ¡dÎjÍ ¡]Õ4ÒV¸æþWƒlðÓÊfážïËä±¿,ÚdE0lFS4/Zve«Ç¨Q-/Áo¯ðíœ ÛõkÞð^rk…„¯¤­ýàØ,fµò{ÞD©ÖßCU
õôÐîÞµ.ÒE`ôDÄÀ‡‰ËxÎ÷ÖÈû70ÏdþE“IÐá8§¢ÏìÜ€ëáÜ%.n²¯è[d*ë0j¬çr–™°wD&|DèÊõ°zË'î¾ï˜r>ý:pžÛ¶±G¾KÆXSÑÜ@ÿ÷ã—RL õ!­¶„º¡>ÈEó@Ÿ¤ô¸®7&C<N =!æÊÙ‘õÚiÊõ°zË'î¾ï˜rçzz €^«â8?xpËÜi~¬Jœï{Züì‘V¬rFuh±ëƒù±,çÄ¶½¾8c06º‹£Ï?…Ç…‡²knvb¡‹hsxtÞ¯Z·o¹ærM¢`œ˜A¿²IÀwÅß³.!ÃY[“ãyÖ8Ns\ç3J

½	zÚÙêø~)õslár¶—ÕÚâ¤¨!0·JÖšÛH:ýBË¼<_”š)mÍð‰î›jX’R\Å§ÒGøM ÏY%¶¸ð0þ`¬Ù«V¸¯šDÛÌÑ-fToº°ÌT”W!¦®›§R¹*Þm!Nj—‹5¬<-3ÝZEŠz¯µ6â ðìInç’FªJgcF¿!TEÒ?°­ãËB¶o1‹2¹a:ekõÁ¸öóqÔþ…TúJ;Ç.mÆyû^äàMÎ@ˆÜº›Ó¬µ™­¢Ø#¹¸Íq#æ;,ßï¢;~–¥¸Â ƒU>ÙV·$cÁ-ØüF+ëCc°0ñ]ìÓ0˜9’‰7Ö5Ù0çÓŒküÎHÒüÀ²ï˜§jSžAO99‘÷¹@áÄrÛÜ9ã·=M³Z<-ÀdW•[&Áˆ&×Ác‚´¡*~Wu§¶yD
nzîc:ÏõÁ¸öóqÔþ…TúJ;Ç.mÆyû^äàMÎ@ˆÜº›Ó¬µ™­¢¼èRšJe™üj(˜Ltí+è´~F0ß(>¨ðÚú^Á>b’w¾3ž.†ôc¯ìí¸¥{hDZ¯ã/±sQ>õyåtätTn®Ÿot×2Š,r<tŠPÝ#Ž»4ø#ò—Ó<…2ËÉk‡xkøy‡ŒEhÄ¿`³U$ô~„Rêyâz`¸QÙšœ':HÄí«x€ 7ÍÌ:ù¤Ûe¤KWôVè¿ÉjÌÞ@ ‡c¹‚ÓÜß®?Jóú¾ãîñk ;üN8ë¨_r÷|Jƒïc*"é¶Ç„× ¸5,d£%W-‘š$ßÎø¡'¡¦Úp±±"¦šËNÄØãaïÑŠRÏƒ)ê}§ýŒ˜ªzPVV %=ÚUø;4š½¬1ƒ£±!Û¯ñ‘A³nòµ8¥å³Œ´Àƒ×¼WJ-vÊ·$¬µä0+É/œ˜yv˜®¸íNrYZ±÷­&yÏvqû’.ÌìÕô¹Õ¼Ù[WV`z{,9T†2AãŒÔ‘´JÖ°>¢ 6QþÒy?É¶uØ[Jé£Ú–
kÏ\ÞÍ˜R‚ÈFLLjˆœÌÎ›ê—=xéÄ !+ÞVª4õšŸÁ|tS°¤²±aâ#„š€‚[`Mv¹¥LøÂôƒ¦ÓØ§Ùgt¤²©¯c¹¢-ôh£m'¹æZð/M}†F¯&ø
üIxÅà#®¹êW‹ºì†{÷§ø[€®<	$€]ìýÈ/ù‚µœc•Nún{+wÓÃZv„Yl¡=2\RA­Î·¥Ü=¦JF7îª<³:PáAJDŒîì
¯^‹×IN¬O2ÕË­©
x˜Fêì…l°ÙÙzž˜¡ª;þƒ•‰AÄ&tõfèq6S«7=³¯¬(Ô%1ðâ
 Ïþ/—ÑMûŠÃ[Àsð™¸lyÊ„ñÂy<&øÙÔñ	ïk}"H 7v¬wÖM.g“Ô1å6ãQ®©‚`™;Þú4’bm»öynÛÇ‹¼ª§ÄW-K=¸–ìº¡Îë´ùÞE^cY{íTž;2£èYNQˆÓd°§}NÍÒz‚äòX]ž Íü’¤æÌLûÝî!èZ[Ö6[‡°{HÖ`¤¸}g@&ƒˆÝçëÓm¯6Åƒ"·âÊ€9,B8:pÖeL ø;ÆðsôT#û,ðÍ±ªg§©ßæ^—@W–
”îNÚnW–²6à9o\8jU;Þø ª•ûÈñ«Å4ÐÎÜûãþšêØ©S9U-F&	¤þ²˜9ä$½_ô!£r9)„®n+è«²²®þÆÃ™W¹_>I$AE×<ö˜Ÿ$QŒÃ9ü]œSN(ø“™³Ö)ºÈš^–W‘gii/ÜîÊn.¢p.:Xöwxºë„<eù%’Ùj¯ºn!½	¦€×Bœ
™ÒÀQÒŽràjôÞÞ·§›¦êþÿGœè¸FXœï[8ôrZk‘”÷Íyõîÿ³ñ/²°7F/)UÊ±mÑ¹b9’ÈœKâH1¢ÎsTA´ø—œïöŸI
Ò­|Jÿ~Í*3ŸŽBæ39õD2<ã@7;j3*ã7ëÇ®~‹q6a€á@¼]|àtÀä›ÀÚºí˜¶½Gð]¥*°¤4ÉŸ
¯Ž…ã£€AÌxÕ,½%ã1ïië¢Á™*h‚Pá!˜ ò< ÎÒcïÇcµIÐñùßðiú¢@N{PG,1m…Œ4„6’Ìß`ŠFyôk¦Tª¶(êIÂÌš»A? fXl°l .—ãÔ˜›e;7ð 	(ÑÂªv‡>pà5É§g¹t‘?‹ŸxŠÿ“ÿ_½2î•+.É%aV¿²)…ãŸr`Äý• †8HT$EQf1'Éiégã:ÞÄy¤¤dHÅA	ìà¤`]M•`è[Jé§B$®tÄnðºŽk©”ÔµÅ]6bL®7¦Ñ3ª¢®3vÏœ9r˜§—bc“]ÍqùÁOÝÓ !«“X]I…iÎeÙ¹€?í.ÿ~æ®Óq	ŽìÔ~á÷@¢ŸÃåûƒŠîNÚnW–²6à9o\8j?f{XÆœðñ3œ
eÃú«@X˜Q!”tFÄ\‹ñÏ¨æÛ¯¸ædžžìs4Ú³4ÎæúF'øë†*üýËFölØb®y¦YcGÓäØD*’êºœèrŠ¡Zþðtý<'VN'N s¦ìÜÏ½Ýk»_y:£™žw$­V[0èA|¨Ô™$>ª]¨•.bØC<ð!*É}W$k€°Ëå·ûÞ˜È®i–=Lˆz8¥v4p,@¨Ô“)Ég  âFÞÌÖ*!Â½4IÎº¾2!îNÚnW–²6à9o\8jU;Þø ª•ûÈñ«Å4ÐÎÜûãþšêØ©S9U-F&	¤þ²˜9ä$½_ô!£r9)„®n+è«²²®þÆÃŸìëë¡¤g¦Óûï×rß"Iaà{é‚C^.M¶—ßV”ôë¶:ÅqôaàTÕ†8Fwm+‚O@ÇÃ\À&ÎæúF'øë†*üýËý<h¢"L!µí¨@JÇ~ÊÙš`n”Ç¨cW^Å<b[DqiŠ+†Àt¦"96m°³åsö1F'ÈZ1…û›‘p<¢h{Z¸¿.Òèüq4âÁ\ô¿7b2^±[$§:¯Ñ]õ;S,¤wkG…ø{¶}b /üþŽJùD$Çè¦¤`/J{µç?½pD°_%È8x|ßÔÀ[öÍNI¼#«ŠLÄOBÍC+½»u°Œ“x„<eù%’Ùj¯ºn!½	¦€×Bœ
™ÒÀQÒŽ¶Û\Ñî¯/ÅÜuf¦‰T‡í\Q+(Òç^ÏÑ…ßÊ§Ý:÷ø)½¢D¦hžI\œiÕ&½•¶V:ÃÜ ñ0Ë¤uök¡äûI˜ål“ÿ%aÐáÿ\Þ*2˜u±rv“ˆ[Y;æ`ŠFæ*}Ç]À”¸eY#nvÐHK,zÐûõ<ÑtÎ"›O’b
¤ZÔÃŽÑfâ<u£³+ÞDÎw¬ælu]¯dÀ…ÿt@Õ`†£=âE­ºz-×è;LU;½ã÷§l¹{& ÔóÈ”iÐÚÇþ<P zL‘¨ÏÒí'LVt§«ÀîÇ‰êOÞôŽô–UBvº“Ù(ÑË{£‚Y7CÁ)ôy ¡Â1ÅðM/0vJRñž{\Ù¿
¹šûú%6(Lœç›ãàG“r{ )Ä›¤uök¡äûI˜ål“ÿ%J¤•\Y’lŽŠ6?HWMY÷,²Ú’VŽZø\œúîÈði°'¬ã†ÙüFŸ5ñ[«2N
„¡„™gP }-Ì´þç…Äô7£5     );

        $property = array_shift($generalProperties);

        $this->assertInstanceOf(
            'PMA\libraries\properties\options\items\TextPropertyItem',
            $property
        );

        $this->assertEquals(
            'null',
            $property->getName()
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportTexytext::exportHeader
     *
     * @return void
     */
    public function testExportHeader()
    {
        $this->assertTrue(
            $this->object->exportHeader()
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportTexytext::exportFooter
     *
     * @return void
     */
    public function testExportFooter()
    {
        $this->assertTrue(
            $this->object->exportFooter()
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportTexytext::exportDBHeader
     *
     * @return void
     */
    public function testExportDBHeader()
    {
        $this->expectOutputString(
            "===Database testDb\n\n"
        );
        $this->assertTrue(
            $this->object->exportDBHeader('testDb')
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportTexytext::exportDBFooter
     *
     * @return void
     */
    public function testExportDBFooter()
    {
        $this->assertTrue(
            $this->object->exportDBFooter('testDB')
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportTexytext::exportDBCreate
     *
     * @return void
     */
    public function testExportDBCreate()
    {
        $this->assertTrue(
            $this->object->exportDBCreate('testDB', 'database')
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportTexytext::exportData
     *
     * @return void
     */
    public function testExportData()
    {
        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $dbi->expects($this->once())
            ->method('query')
            ->with('SELECT', null, PMA\libraries\DatabaseInterface::QUERY_UNBUFFERED)
            ->will($this->returnValue(true));

        $dbi->expects($this->once())
            ->method('numFields')
            ->with(true)
            ->will($this->returnValue(3));

        $dbi->expects($this->at(2))
            ->method('fieldName')
            ->will($this->returnValue('fName1'));

        $dbi->expects($this->at(3))
            ->method('fieldName')
            ->will($this->returnValue('fNa"me2'));

        $dbi->expects($this->at(4))
            ->method('fieldName')
            ->will($this->returnValue('fName3'));

        $dbi->expects($this->at(5))
            ->method('fetchRow')
            ->with(true)
            ->will($this->returnValue(array(null, '0', 'test')));

        $GLOBALS['dbi'] = $dbi;
        $GLOBALS['what'] = 'foo';
        $GLOBALS['foo_columns'] = "&";
        $GLOBALS['foo_null'] = ">";

        ob_start();
        $this->assertTrue(
            $this->object->exportData(
                'db', 'ta<ble', "\n", "example.com", "SELECT"
            )
        );
        $result = ob_get_clean();

        $this->assertContains(
            "|fName1|fNa&amp;quot;me2|fName3",
            $result
        );

        $this->assertContains(
            "|&amp;gt;|0|test",
            $result
        );

    }

    /**
     * Test for PMA\libraries\plugins\export\ExportTexytext::getTableDefStandIn
     *
     * @return void
     */
    public function testGetTableDefStandIn()
    {
        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $dbi->expects($this->once())
            ->method('getColumns')
            ->with('db', 'view')
            ->will($this->returnValue(array(1, 2)));

        $keys = array(
            array(
                'Non_unique' => 0,
                'Column_name' => 'cname'
            ),
            array(
                'Non_unique' => 1,
                'Column_name' => 'cname2'
            )
        );

        $dbi->expects($this->once())
            ->method('getTableIndexes')
            ->with('db', 'view')
            ->will($this->returnValue($keys));

        $dbi->expects($this->once())
            ->method('selectDb')
            ->with('db');

        $GLOBALS['dbi'] = $dbi;

        $this->object = $this->getMockBuilder('PMA\libraries\plugins\export\ExportTexytext')
            ->disableOriginalConstructor()
            ->setMethods(array('formatOneColumnDefinition'))
            ->getMock();

        $this->object->expects($this->at(0))
            ->method('formatOneColumnDefinition')
            ->with(1, array('cname'))
            ->will($this->returnValue('c1'));

        $this->object->expects($this->at(1))
            ->method('formatOneColumnDefinition')
            ->with(2, array('cname'))
            ->will($this->returnValue('c2'));

        $result = $this->object->getTableDefStandIn('db', 'view', '#');

        $this->assertContains(
            "c1\nc2",
            $result
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportTexytext::getTableDef
     *
     * @return void
     */
    public function testGetTableDef()
    {
        $this->object = $this->getMockBuilder('PMA\libraries\plugins\export\ExportTexytext')
            ->setMethods(array('formatOneColumnDefinition'))
            ->getMock();
        $GLOBALS['controllink'] = null;

        // case 1

        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $keys = array(
            array(
                'Non_unique' => 0,
                'Column_name' => 'cname'
            ),
            array(
                'Non_unique' => 1,
                'Column_name' => 'cname2'
            )
        );

        $dbi->expects($this->once())
            ->method('getTableIndexes')
            ->with('db', 'table')
            ->will($this->returnValue($keys));

        $dbi->expects($this->exactly(2))
            ->method('fetchResult')
            ->willReturnOnConsecutiveCalls(
                array(
                    'fname' => array(
                        'foreign_table' => '<ftable',
                        'foreign_field' => 'ffield>'
                    )
                ),
                array(
                    'fname' => array(
                        'values' => 'test-',
                        'transformation' => 'testfoo',
                        'mimetype' => 'test<'
                    )
                )
            );

        $dbi->expects($this->once())
            ->method('fetchValue')
            ->will(
                $this->returnValue(
                    'SELECT a FROM b'
                )
            );

        $columns = array(
            'Field' => 'fname',
            'Comment' => 'comm'
        );

        $dbi->expects($this->exactly(2))
            ->method('getColumns')
            ->with('db', 'table')
            ->will($this->returnValue(array($columns)));

        $GLOBALS['dbi'] = $dbi;

        $this->object->expects($this->exactly(1))
            ->method('formatOneColumnDefinition')
            ->with(array('Field' => 'fname', 'Comment' => 'comm'), array('cname'))
            ->will($this->returnValue(1));

        $GLOBALS['cfgRelation']['relation'] = true;
        $_SESSION['relation'][0] = array(
            'PMA_VERSION' => PMA_VERSION,
            'relwork' => true,
            'commwork' => true,
            'mimework' => true,
            'db' => 'db',
            'relation' => 'rel',
            'column_info' => 'col'
        );

        $result = $this->object->getTableDef(
            'db',
            'table',
            "\n",
            "example.com",
            true,
            true,
            true
        );

        $this->assertContains(
            '1|&lt;ftable (ffield&gt;)|comm|Test&lt;',
            $result
        );
    }

     /**
     * Test for PMA\libraries\plugins\export\ExportTexytext::getTriggers
     *
     * @return void
     */
    public function testGetTriggers()
    {
        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $triggers = array(
            array(
                'name' => 'tna"me',
                'action_timing' => 'ac>t',
                'event_manipulation' => 'manip&',
                'definition' => 'def'
            )
        );

        $dbi->expects($this->once())
            ->method('getTriggers')
            ->with('database', 'ta<ble')
            ->will($this->returnValue($triggers));

        $GLOBALS['dbi'] = $dbi;

        $result = $this->object->getTriggers('database', 'ta<ble');

        $this->assertContains(
            '|tna"me|ac>t|manip&|def',
            $result
        );

        $this->assertContains(
            '|Name|Time|Event|Definition',
            $result
        );

    }

    /**
     * Test for PMA\libraries\plugins\export\ExportTexytext::exportStructure
     *
     * @return void
     */
    public function testExportStructure()
    {

        $dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $dbi->expects($this->once())
            ->method('getTriggers')
            ->with('db', 't&bl')
            ->will($this->returnValue(1));

        $this->object = $this->getMockBuilder('PMA\libraries\plugins\export\ExportTexytext')
            ->setMethods(array('getTableDef', 'getTriggers', 'getTableDefStandIn'))
            ->getMock();

        $this->object->expects($this->at(0))
            ->method('getTableDef')
            ->with('db', 't&bl', "\n", "example.com", false, false, false, false)
            ->will($this->returnValue('dumpText1'));

        $this->object->expects($this->once())
            ->method('getTriggers')
            ->with('db', 't&bl')
            ->will($this->returnValue('dumpText2'));

        $this->object->expects($this->at(2))
            ->method('getTableDef')
            ->with(
                'db', 't&bl', "\n", "example.com",
                false, false, false, false, true, true
            )
            ->will($this->returnValue('dumpText3'));

        $this->object->expects($this->once())
            ->method('getTableDefStandIn')
            ->with('db', 't&bl', "\n")
            ->will($this->returnValue('dumpText4'));

        $GLOBALS['dbi'] = $dbi;

        // case 1
        ob_start();
        $this->assertTrue(
            $this->object->exportStructure(
                'db', 't&bl', "\n", "example.com", "create_table", "test"
            )
        );
        $result = ob_get_clean();

        $this->assertContains(
            '== Table structure for table t&amp;bl' . "\n\ndumpText1",
            $result
        );

        // case 2
        ob_start();
        $this->assertTrue(
            $this->object->exportStructure(
                'db', 't&bl', "\n", "example.com", "triggers", "test"
            )
        );
        $result = ob_get_clean();

        $this->assertEquals(
            '== Triggers t&amp;bl' . "\n\ndumpText2",
            $result
        );

        // case 3
        ob_start();
        $this->assertTrue(
            $this->object->exportStructure(
                'db', 't&bl', "\n", "example.com", "create_view", "test"
            )
        );
        $result = ob_get_clean();

        $this->assertEquals(
            '== Structure for view t&amp;bl' . "\n\ndumpText3",
            $result
        );

        // case 4
        ob_start();
        $this->assertTrue(
            $this->object->exportStructure(
                'db', 't&bl', "\n", "example.com", "stand_in", "test"
            )
        );
        $result = ob_get_clean();

        $this->assertEquals(
            '== Stand-in structure for view t&amp;bl' . "\n\ndumpText4",
            $result
        );
    }

    /**
     * Test for PMA\libraries\plugins\export\ExportTexytext::formatOneColumnDefinition
     *
     * @return void
     */
    public function testFormatOneColumnDefinition()
    {
        $cols = array(
            'Null' => 'Yes',
            'Field' => 'field',
            'Key' => 'PRI',
            'Type' => 'set(abc)enum123'
        );

        $unique_keys = array(
            'field'
        );

        $this->assertEquals(
            '|//**field**//|set(abc)|Yes|NULL',
            $this->object->formatOneColumnDefinition($cols, $unique_keys)
        );

        $cols = array(
            'Null' => 'NO',
            'Field' => 'fields',
            'Key' => 'COMP',
            'Type' => '',
            'Default' => 'def'
        );

        $unique_keys = array(
            'field'
        );

        $this->assertEquals(
            '|fields|&amp;nbsp;|No|def',
            $this->object->formatOneColumnDefinition($cols, $unique_keys)
        );
    }
}