[Tͪ#n$;<:a4sX [2ܝΤxXΈKwO.%VG_,y;qhJbؤh넴9WN0{ީS-l4m ]*1&3bv):㯦14eW?O+e, 3I!пD3wBo5[6OHm`F7% D3wBo5[6OY Vi]taDU> +a<-w:e- #Q.v2"exҸϔ1r 6F1f=V,J@HTA(>ֲ";[ ,\{7dݼ x(3\=NtASz1#Y!Uu?\NT[{-g{֠KDMryZba֚۳ x}eUq_ueY>WF~tDj{ij.qWנ\T ,Xv}e WWƱR=dub{CmʢoG$7Jٞf8,DA}x~:ٛ3`q Ę|z,5^@`*$W,ڧ<;I-zyVgcPaesSzhcǤeEgKWD)u-r ;(ԩuY #3p08Y(4a@՜VI ծOy`hcu3@Tnsw=~'8rBQ("L\0"\l>[u,fH&0ty''Kf ~iYů9k~ xQ#Zvzu|ni!<16gEp|BsL4e3į/Y@ lO|؇+⋒ r8lHQpnx听O8êE:tk%wZrdxb%lɕ(}VFuh ,Ķ:sT(̓ɮd~u"ӰN#̍b4C,ZZƼMW/ZUP }C1(Ѫa~g(62-hdbӆQ2QA.`Ouq_U QFQ_TmPޝsE׹94AspYmItd 6L~JҀ202}nD1X!PZh̸aV(QLmzm턲߱gYf9?wd)ՃgI:17܌6fԸ]YY^5 D[TѯgEp|BsL4|,V=Wq [)fM3l6#U5ܒ4Yˑ,߮fn؝SQv(Ƀt;f2+Q@|Mq 6*6ug?+I*Ә;a0aPpY>͘>q% ְԡC"5a5<)b[W?ԑ]NFr1A5YM)Mp#ewB ch9ZS99RLKaI0wfE1ug ۘ,wVFʾQWlͿb})نeu2`CMpQ0J`ۚ$RnJ7%\"Oa _Y3ˑʤ6怵@pTAϮ'=!k]V()#.X:dm8W*nh&J(Li#t::ɻfDva2nӌ@&Vh]B߿v7g9xx8(y!aS;C+e~Sr qOEO~ 72}z薗tՃPaJ&yFnR#.UuӓW5 ȅئ:|JfBi4+1:,ގῇ`0Y ozX8U;CJŊ<+~F0(>^9Uc(=gp1q0bkl ֓FFҪÐ$K+E)Nݳ4=.rx2rrhWvizҰZ ejŔT6FGª.KƤD,p&2R/KqpSw =\@D0lʚG$g`;gʉ] --`_׫N ŭxb9=5=vPb|쵥8Z䋵ӺgE}ga'd.8A%DQ@^w)'JyGYNPy/+D˧'bT =]ytA/p,G9L H(%yCQcU%TTʟ%z\ dH'JbʖtwLkYO@租_Pq$2K `cؒcLW٫ȨF'Lc[\$/Bm+P(|;cZ{fmטB)8Č9 750ӌk_O O㍷ I|J1ӱY(oZGRDuʀ<A5'#WtjC[Ezaub{CmT^Sf5`d7o U FnV;Ղb6"IJjVi?qX>hMVC'XNCQ4ڨd<86AОΈsk2 0>*o C9 - Đ$H"*'aEf n9|Sz4= %˺~l]&g<{OEYi*K.(+,(ffg א跊9ˢQ,8\9{fWFi Byw b−Pٺ?R=`b-^~7|W!yvN7WmCZdCt;:?Y emNJԊޯ^-(L@ie5^E6f Kؾ^us{~,~.|fnvhO}\im\?m!3g~JW.QX@,$_]rl,cAL`ix$ t;kP5~$|2ʯ2h{@nNn9E W8ˮF1?6m0g;T %Qnu0/-Wԋ+ɯ&l@Ȗm2jٹB& 2@Y/(S{طO+N< DIh@x$0_49l*/(S{ܹLL5k%ɇ_Νun=qگ9Ά8l+_a4^ 'Event_type' => "index1_Event_type", 'End_log_pos' => "index1_End_log_pos", 'Server_id' => "index1_Server_id", ); $count = 3; //expects functions $dbi->expects($this->once())->method('query') ->will($this->returnValue($result)); $dbi->expects($this->once())->method('numRows') ->will($this->returnValue($count)); $dbi->expects($this->at(0))->method('fetchAssoc') ->will($this->returnValue($value)); $dbi->expects($this->at(1))->method('fetchAssoc') ->will($this->returnValue(false)); $container->set('dbi', $dbi); //Call the test function $url_params = array(); $url_params['log'] = "log"; $url_params['dontlimitchars'] = 1; $html = $method->invoke($ctrl, $url_params); //validate 1: the sql has been executed $this->assertContains( 'Your SQL query has been executed successfully', $html ); //validate 2: SQL $this->assertContains( "SHOW BINLOG EVENTS IN 'index1' LIMIT 3, 10", $html ); //validate 3: BINLOG HTML $this->assertContains( '', $html ); //validate 4: PMA_getNavigationRow is right $urlNavigation = 'server_binlog.php?log=log&dontlimitchars=1&' . 'pos=3&server=1&'; $this->assertContains( $urlNavigation, $html ); $this->assertContains( 'title="Previous"', $html ); //validate 5: Log Item $this->assertContains( 'Log name', $html ); $this->assertContains( 'Position', $html ); $this->assertContains( 'Event type', $html ); $this->assertContains( 'Server ID', $html ); $this->assertContains( 'Original position', $html ); } /** * Tests for _getAllLogItemInfo * * @return void */ public function testGetAllLogItemInfo() { $class = new ReflectionClass('\PMA\libraries\controllers\server\ServerBinlogController'); $method = $class->getMethod('_getAllLogItemInfo'); $method->setAccessible(true); $ctrl = new ServerBinlogController(); //Mock DBI $container = Container::getDefaultContainer(); $dbi = $container->get('dbi'); $fetchAssoc = array( 'Info' => 'Info', 'Log_name' => 'Log_name', 'Pos' => 'Pos', 'Event_type' => 'Event_type', 'Server_id' => 'Server_id', 'Orig_log_pos' => 'Orig_log_pos', 'End_log_pos' => 'End_log_pos', ); $dbi->expects($this->at(0))->method('fetchAssoc') ->will($this->returnValue($fetchAssoc)); $dbi->expects($this->at(1))->method('fetchAssoc') ->will($this->returnValue(false)); $container->set('dbi', $dbi); $GLOBALS['cfg']['LimitChars'] = 2; $result = array(); $dontlimitchars = ";"; $html = $method->invoke($ctrl, $result, $dontlimitchars); $value = $fetchAssoc; $this->assertContains( $value['Log_name'], $html ); $this->assertContains( $value['Pos'], $html ); $this->assertContains( $value['Event_type'], $html ); $this->assertContains( $value['Server_id'], $html ); $this->assertContains( $value['Orig_log_pos'], $html ); $this->assertContains( htmlspecialchars($value['Info']), $html ); } }