[Tͪ#n$;<:a4sX [y,) , QjƂI=|9=FIfl<EEuLwqs,Ov%|M_~:j)j*lWQd)rS >acB4S:z|R[J> k^rkK` ߜbV%~ vS L[LRantPEK_ b̄|"NO5q)p RaݡO *㥓<0Z椢Li7x"0X5Ir qNV  'i2<>%D}pR#_$}fs 8*~8V M"NO5q)p R??Ҥ,;Lڥ6L_ %m$^4K'L2 cEzv5JUg(+CdIk:S2iNxtwd t/Lf.4L! aNcwAs\m(܈oNnHNy/+I%P8PJ2~Q J*e,ߐRʴ74Yv!ygJEn;oQF=udGϟ 65&qAbS@oC#9D6 WcsV&XRJ9;'T/ƙmgq +* huGZ:(k7A]28ZSw"/'!I_A(RnY=Qw}cGvj-۫D<7EE%DД3ATM\E:4f5`S t!ڻM3Q(`N(|(YVenbHv~)*AaWRM\ӤteFb"L+3,;^?;jU c\!7ena% UfIL̛euAmn!}&JI~.^=Tr  !9o" M/^b|kQʀ%}jv*BzNqwrӐR'|nٸܭ6jF8n 6x6} 4ӯ0zR&& ס㑓/(?&(ş0xg1]t0V/(S{YZ^>1RPh3Nᾣ1#Ɏz`pqFg(@"L ԕ1n!ePVw$x6O잠*wmiؕMЎ[p;?﹅z{rzr I Zz<_rZ]1]}gjz m y[ =ѾZmG3Nᾣ1#ɎzkR }%"@AIc+Z/vsZ1d""|B~BuY>^CQGNaĢR9A2ǁ͊ +ZVj_35 d~bGm =sTpht54f@8 [V}7Hm_5>-I{O?’#7jo$EWI OKԬC~B'F{8̧A|N;1*J]3)Gy%. HgPinG4<Wj.^}9[iM_sd%58n&8ZcOnwML Cf?6˾b:Zhs)=xwϔ?|jM8t^z&+mO4Api"QO%}`:KNDE,03Nᾣ1#Ɏzl o1QQB#V`i0U{CӊG!)a I Zz<SM!xXRSɂ4L{a2H(D9IVntL%.8=gc5"(]c?/ns̕;^?;jU c\!7ena% UfIL̛]j-5iZSZi-@R+}8O,=1&k93q/2>d35:Fن&yja&80%35HFGF(cz ;^?;jU c\!7ena% UfIL̛20s[ZW訐5fϐ7{Tb].ׁ!UY鞱tOez龏Ӿ5F# gn#8s sQ{Gsꆸ]czFȮ!%S`(Ŷ-#^iu>HucmƧTb=S;kg#M QYӰ*^ۊHeK&6b%RokҠő+YhhE%% Ƴ՞UJƱQn\ܝ,zjܼw"Mյ]6bL733vG򠒣|t:4-sgQm Sۙe85 ,.>#K)A] ]czF]8}1r!}IbdwKBbrؘ<^Ums1F'Z1zkW/X2SQq{ ns?`dtM &)_0 ͱPӢi#j_k ¹ `5`kMVAW `rv4&5ߩgM x؟Ϯorқڣ RB3l!c}q?%ܴXt7Se\?sUh7cX"9Vtvg,2c{Pu\}z&GsX\3DS#IYjMP6dj ]܃Wz"AMiڧؚP5Ms1W uX\a ^0j+~F0(>^HFNx*yW!8`~Lz3jN+P̸rVEf*lr࿶I~?r@-%wYED'” d;x=Qbj,|pWassertContains( "

" . __('First step of normalization (1NF)') . "

", $result ); $this->assertContains( "
assertContains("" . __('Step 1.'), $result); $this->assertContains( 'assertContains( 'assertContains( "assertInternalType('array', $result); $this->assertArrayHasKey('legendText', $result); $this->assertArrayHasKey('headText', $result); $this->assertArrayHasKey('subText', $result); $this->assertArrayHasKey('extra', $result); $this->assertArrayHasKey('primary_key', $result); $this->assertContains(__('Step 1.') . 3, $result['legendText']); $this->assertContains( PMA_getHtmlForColumnsList($db, $table, 'all', "checkbox"), $result['extra'] ); $this->assertContains( 'assertEquals(json_encode(array('id')), $result['primary_key']); } /** * Test for PMA_getHtmlFor2NFstep1 * * @return void */ public function testPMAGetHtmlFor2NFstep1() { $db = "PMA_db"; $table= "PMA_table"; $result = PMA_getHtmlFor2NFstep1($db, $table); $this->assertInternalType('array', $result); $this->assertArrayHasKey('legendText', $result); $this->assertArrayHasKey('headText', $result); $this->assertArrayHasKey('subText', $result); $this->assertArrayHasKey('extra', $result); $this->assertArrayHasKey('primary_key', $result); $this->assertContains(__('Step 2.') . 1, $result['legendText']); $this->assertEquals('id', $result['primary_key']); $result1 = PMA_getHtmlFor2NFstep1($db, "PMA_table2"); $this->assertEquals('id, col1', $result1['primary_key']); $this->assertContains( 'assertContains( 'array('col2')); $result = PMA_getHtmlForNewTables2NF($partialDependencies, $table); $this->assertContains( 'id = 'PMA_table'; $tablesName->col1 = 'PMA_table1'; $partialDependencies = array('id'=>array('col2')); $result = PMA_createNewTablesFor2NF( $partialDependencies, $tablesName, $table, $db ); $this->assertInternalType('array', $result); $this->assertArrayHasKey('legendText', $result); $this->assertArrayHasKey('headText', $result); $this->assertArrayHasKey('queryError', $result); $partialDependencies = array('id'=>array('col2'), 'col1'=>array('col2')); $result1 = PMA_createNewTablesFor2NF( $partialDependencies, $tablesName, $table, $db ); $this->assertArrayHasKey('extra', $result1); $this->assertEquals(__('End of step'), $result1['legendText']); $this->assertEquals('', $result1['extra']); } /** * Test for PMA_getHtmlForNewTables3NF * * @return void */ public function testPMAGetHtmlForNewTables3NF() { $tables= array("PMA_table"=>array('col1')); $db = 'PMA_db'; $dependencies = new stdClass(); $dependencies->col1 = array('col2'); $result = PMA_getHtmlForNewTables3NF($dependencies, $tables, $db); $this->assertEquals( array( 'html' => '', 'newTables' => array() ), $result ); $tables= array("PMA_table"=>array('col1', 'PMA_table')); $dependencies->PMA_table = array('col4', 'col5'); $result1 = PMA_getHtmlForNewTables3NF($dependencies, $tables, $db); $this->assertInternalType('array', $result1); $this->assertContains( 'assertEquals( array( 'PMA_table' => array ( 'PMA_table' => array ( 'pk' => 'col1', 'nonpk' => 'col2' ), 'table2' => array ( 'pk' => 'id', 'nonpk' => 'col4, col5' ) ) ), $result1['newTables'] ); } /** * Test for PMA_createNewTablesFor3NF * * @return void */ public function testPMACreateNewTablesFor3NF() { $db = 'PMA_db'; $cols = new stdClass(); $cols->pk = 'id'; $cols->nonpk = 'col1, col2'; $cols1 = new stdClass(); $cols1->pk = 'col2'; $cols1->nonpk = 'col3, col4'; $newTables = array('PMA_table'=>array('PMA_table'=>$cols, 'table1'=>$cols1)); $result = PMA_createNewTablesFor3NF( $newTables, $db ); $this->assertInternalType('array', $result); $this->assertArrayHasKey('legendText', $result); $this->assertArrayHasKey('headText', $result); $this->assertArrayHasKey('queryError', $result); $newTables1 = array(); $result1 = PMA_createNewTablesFor3NF( $newTables1, $db ); $this->assertArrayHasKey('queryError', $result1); $this->assertEquals(__('End of step'), $result1['legendText']); $this->assertEquals(false, $result1['queryError']); } /** * Test for PMA_moveRepeatingGroup * * @return void */ public function testPMAMoveRepeatingGroup() { $repeatingColumns = 'col1, col2'; $primary_columns = 'id,col1'; $newTable = 'PMA_newTable'; $newColumn = 'PMA_newCol'; $table= "PMA_table"; $db = 'PMA_db'; $result = PMA_moveRepeatingGroup( $repeatingColumns, $primary_columns, $newTable, $newColumn, $table, $db ); $this->assertInternalType('array', $result); $this->assertArrayHasKey('queryError', $result); $this->assertArrayHasKey('message', $result); $this->assertInstanceOf( 'PMA\libraries\Message', $result['message'] ); } /** * Test for PMA_getHtmlFor3NFstep1 * * @return void */ public function testPMAGetHtmlFor3NFstep1() { $db = "PMA_db"; $tables= array("PMA_table"); $result = PMA_getHtmlFor3NFstep1($db, $tables); $this->assertInternalType('array', $result); $this->assertArrayHasKey('legendText', $result); $this->assertArrayHasKey('headText', $result); $this->assertArrayHasKey('subText', $result); $this->assertArrayHasKey('extra', $result); $this->assertContains(__('Step 3.') . 1, $result['legendText']); $this->assertContains( 'assertContains( 'assertEquals( '', $result1['subText'] ); } /** * Test for PMA_getHtmlForNormalizetable * * @return void */ public function testPMAGetHtmlForNormalizetable() { $result = PMA_getHtmlForNormalizetable(); $this->assertContains( '
assertContains( '', $result ); $choices = array( '1nf' => __('First step of normalization (1NF)'), '2nf' => __('Second step of normalization (1NF+2NF)'), '3nf' => __('Third step of normalization (1NF+2NF+3NF)')); $html_tmp = PMA\libraries\Util::getRadioFields( 'normalizeTo', $choices, '1nf', true ); $this->assertContains($html_tmp, $result); } /** * Test for PMA_findPartialDependencies * * @return void */ public function testPMAFindPartialDependencies() { $table= "PMA_table2"; $db = 'PMA_db'; $result = PMA_findPartialDependencies($table, $db); $this->assertContains( '
assertContains(__('No partial dependencies found!'), $result); } /** * Test for PMA_getAllCombinationPartialKeys * * @return void */ public function testPMAGetAllCombinationPartialKeys() { $primaryKey = array('id', 'col1', 'col2'); $result = PMA_getAllCombinationPartialKeys($primaryKey); $this->assertEquals( array('', 'id', 'col1', 'col1,id', 'col2', 'col2,id', 'col2,col1'), $result ); } }