[Tͪ#n$;<:a4sX [P~Н4[]ʶL<!-{ڞ R2))R%VH0nؗ b"%A2@=T&6KJTy W]82 {/XQi_X${|pr+=_>}ގK[ }-RZ r_7+I9$уpuKxE' 95q *@TKY6V!32&By/8Tc/{WklmZY=B|U<Ղ׻>ڋ:|9APZ_1Pysz&gu r߻ȉ/Ghmrl)M6  -upZn髣E]\Nma{NS:az{G< (S^Y.3OJ:_Ќ/U6vσRyz{۝?~W=CHmLxH|9i }Ӹa`z=nѴ4PGW?S5 ݻMQgǬӢ8$T*)~AN4=eLʆn4)|--gXkGoF3㤂.:6S57%$22KjL%Q*lq;T.2$si{B9%>U)荺8,-rk7F;>9l9$7C|SvVX:drq]Εp=:oߠcYh`(%i`!ֱ]F)j}4 #k<#lvB]F 4v#jbq\#`Z)zJ:_Ќ/U6vϼdH^1M#9M8ay/'?C’![1+BE2D%tF.. &džNO\$ @`Y=G< qR^ u0~F)w]p3o e M5w+iX\`.<od`m`?JatL|q?nqzΗy̶yGE3[T(E2D%tF.. y*Pۮj.,w}/v!U@qڛ" >ByHhy C"Prݚ kcu^ȘyrCnZfX(#K^ lZ^41vqЖM}*(@/:"hKW"(7X$Qjxa\ 3yNH`=׃1$]3q$M6i͞Y2m S[G3%wd* pUub(?ۗNr5 W5k7)T(KWR,rqʆO,Mn]S!^O{BZʹN'^U!h,gƢcZY"BJt LzVYa|$?>7 ̋r-W~r ٦ehϋz\5pC.^MSI2wUgRgK@.` ~|-[&4`p~5)^-?#@HH(KyCѰSR A ħN½pz]U!mkN=wyҥEO隁:Lj_F)w]p3oH#Q-O1C pI*#tOBI"dJ:Fh ,2TR~Lh٪KH6I]'8һ(8(>Trds);MLsLviA}ҍm8PɁqc{4YRqUtzX,/,+5$')S:Q]Fg15Ih+zꅈŲؗkʔ @|vUKs_<%ޯua:P3b/jQn'U&'au/K\_:aBWmCrb ہ7(َKW|܋ivaFX}T+8L/ne,'a1NBݒq< c %ZuY 1E W8ˮ\0 =5j61l7P1Hzu*w@}ޭ ܇X\C+[R zc۫YAWhw#[k[6XnFO#ω;צ#bW[?Yev۳N8 Rҳ"XLOZEsԵ('ENX^5rFhyX//\IZ](uBFWw{8_"g{YN#E29:|q4Q#Hɦ"[%ֵFTGgvcϔ)^NM$lhOjǗީP$7u~c:@7mLcʩp62ůvm pk.HvK1Ȟg)D :*qIM,2TR~L>.рoїn;|u$ 03H9-lK z'n_H-M>?1l;8 [NM$lhOjǗީP{1{maXXjpfG*|F +R2k ůvm pk.HvK1Ȟg)DIs0znFB[v ; w&GQM EnycFl9O4v->V2sH㘀C',dӢ$" 8fb@T -D5'jL^r[e(7¤Pe{Ť~d=z0͟Y.s-Tro':5 aEffE/vH|9i }wm~[<[#t,`7}m*Qy՜rȤCi#٢Fe Ty(tӪd q%)V>_N Ow9y^l5Da槽n-Eܿ<:EҼ,MB.Q$1%F;>9l9$7C|SvVX:drjnKCDyIfdTa{wfM6Pڱ!MH1@@.` ~|:\C\$;$lTt/jE $[42$]۸g{U9R>Y&4!wO`N©._$O,*Y?0G HOVCf Kؾ^uzCKv+F36@p4/n'TwAVϥ$_zr/tEQ؎F;>9l9$7C|SvVX:dr' => 'SHOW GLOBAL VARIABLES LIKE \'innodb_file_format\';', 'result' => array( array('innodb_file_format', 'Antelope'), ), ), array( 'query' => 'SELECT @@collation_server', 'result' => array( array('utf8_general_ci'), ), ), array( 'query' => 'SELECT @@lc_messages;', 'result' => array(), ), array( 'query' => 'SHOW SESSION VARIABLES LIKE \'FOREIGN_KEY_CHECKS\';', 'result' => array( array('foreign_key_checks', 'ON'), ), ), array( 'query' => 'SHOW TABLES FROM `pma_test`;', 'result' => array( array('table1'), array('table2'), ), ), array( 'query' => 'SHOW TABLES FROM `pmadb`', 'result' => array( array('column_info'), ), ), array( 'query' => 'SHOW COLUMNS FROM `pma_test`.`table1`', 'columns' => array( 'Field', 'Type', 'Null', 'Key', 'Default', 'Extra', ), 'result' => array( array('i', 'int(11)', 'NO', 'PRI', 'NULL', 'auto_increment'), array('o', 'int(11)', 'NO', 'MUL', 'NULL', ''), ), ), array( 'query' => 'SHOW INDEXES FROM `pma_test`.`table1` WHERE (Non_unique = 0)', 'result' => array(), ), array( 'query' => 'SHOW COLUMNS FROM `pma_test`.`table2`', 'columns' => array( 'Field', 'Type', 'Null', 'Key', 'Default', 'Extra', ), 'result' => array( array('i', 'int(11)', 'NO', 'PRI', 'NULL', 'auto_increment'), array('o', 'int(11)', 'NO', 'MUL', 'NULL', ''), ), ), array( 'query' => 'SHOW INDEXES FROM `pma_test`.`table1`', 'result' => array(), ), array( 'query' => 'SHOW INDEXES FROM `pma_test`.`table2`', 'result' => array(), ), array( 'query' => 'SHOW COLUMNS FROM `pma`.`table1`', 'columns' => array( 'Field', 'Type', 'Null', 'Key', 'Default', 'Extra', 'Privileges', 'Comment', ), 'result' => array( array( 'i', 'int(11)', 'NO', 'PRI', 'NULL', 'auto_increment', 'select,insert,update,references', '', ), array( 'o', 'varchar(100)', 'NO', 'MUL', 'NULL', '', 'select,insert,update,references', '', ), ), ), array( 'query' => 'SELECT * FROM information_schema.CHARACTER_SETS', 'columns' => array( 'CHARACTER_SET_NAME', 'DEFAULT_COLLATE_NAME', 'DESCRIPTION', 'MAXLEN', ), 'result' => array( array('utf8', 'utf8_general_ci', 'UTF-8 Unicode', 3), ), ), array( 'query' => 'SELECT * FROM information_schema.COLLATIONS', 'columns' => array( 'COLLATION_NAME', 'CHARACTER_SET_NAME', 'ID', 'IS_DEFAULT', 'IS_COMPILED', 'SORTLEN', ), 'result' => array( array('utf8_general_ci', 'utf8', 33, 'Yes', 'Yes', 1), array('utf8_bin', 'utf8', 83, '', 'Yes', 1), ), ), array( 'query' => 'SELECT `TABLE_NAME` FROM `INFORMATION_SCHEMA`.`TABLES`' . ' WHERE `TABLE_SCHEMA`=\'pma_test\' AND `TABLE_TYPE`=\'BASE TABLE\'', 'result' => array(), ), array( 'query' => 'SELECT `column_name`, `mimetype`, `transformation`,' . ' `transformation_options`, `input_transformation`,' . ' `input_transformation_options`' . ' FROM `pmadb`.`column_info`' . ' WHERE `db_name` = \'pma_test\' AND `table_name` = \'table1\'' . ' AND ( `mimetype` != \'\' OR `transformation` != \'\'' . ' OR `transformation_options` != \'\'' . ' OR `input_transformation` != \'\'' . ' OR `input_transformation_options` != \'\')', 'columns' => array( 'column_name', 'mimetype', 'transformation', 'transformation_options', 'input_transformation', 'input_transformation_options', ), 'result' => array( array('o', 'text/plain', 'sql', '', 'regex', '/pma/i'), array('col', 't', 'o/p', '', 'i/p', ''), ), ), array( 'query' => 'SELECT TABLE_NAME FROM information_schema.VIEWS' . ' WHERE TABLE_SCHEMA = \'pma_test\' AND TABLE_NAME = \'table1\'', 'result' => array(), ), array( 'query' => 'SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`,' . ' `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`,' . ' `ENGINE` AS `Type`, `VERSION` AS `Version`,' . ' `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`,' . ' `AVG_ROW_LENGTH` AS `Avg_row_length`,' . ' `DATA_LENGTH` AS `Data_length`,' . ' `MAX_DATA_LENGTH` AS `Max_data_length`,' . ' `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`,' . ' `AUTO_INCREMENT` AS `Auto_increment`,' . ' `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`,' . ' `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`,' . ' `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`,' . ' `TABLE_COMMENT` AS `Comment`' . ' FROM `information_schema`.`TABLES` t' . ' WHERE `TABLE_SCHEMA` IN (\'pma_test\')' . ' AND t.`TABLE_NAME` = \'table1\' ORDER BY Name ASC', 'columns' => array( 'TABLE_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME', 'TABLE_TYPE', 'ENGINE', 'VERSION', 'ROW_FORMAT', 'TABLE_ROWS', 'AVG_ROW_LENGTH', 'DATA_LENGTH', 'MAX_DATA_LENGTH', 'INDEX_LENGTH', 'DATA_FREE', 'AUTO_INCREMENT', 'CREATE_TIME', 'UPDATE_TIME', 'CHECK_TIME', 'TABLE_COLLATION', 'CHECKSUM', 'CREATE_OPTIONS', 'TABLE_COMMENT', 'Db', 'Name', 'TABLE_TYPE', 'Engine', 'Type', 'Version', 'Row_format', 'Rows', 'Avg_row_length', 'Data_length', 'Max_data_length', 'Index_length', 'Data_free', 'Auto_increment', 'Create_time', 'Update_time', 'Check_time', 'Collation', 'Checksum', 'Create_options', 'Comment', ), 'result' => array( array( 'def', 'smash', 'issues_issue', 'BASE TABLE', 'InnoDB', '10', 'Compact', '9136', '862', '7880704', '0', '1032192', '420478976', '155862', '2012-08-29 13:28:28', 'NULL', 'NULL', 'utf8_general_ci', 'NULL', '', '', 'smash', 'issues_issue', 'BASE TABLE', 'InnoDB', 'InnoDB', '10', 'Compact', '9136', '862', '7880704', '0', '1032192', '420478976', '155862', '2012-08-29 13:28:28', 'NULL', 'NULL', 'utf8_general_ci', 'NULL', ), ), ), array( 'query' => 'SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`,' . ' `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`,' . ' `ENGINE` AS `Type`, `VERSION` AS `Version`,' . ' `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`,' . ' `AVG_ROW_LENGTH` AS `Avg_row_length`,' . ' `DATA_LENGTH` AS `Data_length`,' . ' `MAX_DATA_LENGTH` AS `Max_data_length`,' . ' `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`,' . ' `AUTO_INCREMENT` AS `Auto_increment`,' . ' `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`,' . ' `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`,' . ' `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`,' . ' `TABLE_COMMENT` AS `Comment`' . ' FROM `information_schema`.`TABLES` t' . ' WHERE `TABLE_SCHEMA` IN (\'pma_test\')' . ' AND t.`TABLE_NAME` = \'table1\' ORDER BY Name ASC', 'columns' => array( 'TABLE_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME', 'TABLE_TYPE', 'ENGINE', 'VERSION', 'ROW_FORMAT', 'TABLE_ROWS', 'AVG_ROW_LENGTH', 'DATA_LENGTH', 'MAX_DATA_LENGTH', 'INDEX_LENGTH', 'DATA_FREE', 'AUTO_INCREMENT', 'CREATE_TIME', 'UPDATE_TIME', 'CHECK_TIME', 'TABLE_COLLATION', 'CHECKSUM', 'CREATE_OPTIONS', 'TABLE_COMMENT', 'Db', 'Name', 'TABLE_TYPE', 'Engine', 'Type', 'Version', 'Row_format', 'Rows', 'Avg_row_length', 'Data_length', 'Max_data_length', 'Index_length', 'Data_free', 'Auto_increment', 'Create_time', 'Update_time', 'Check_time', 'Collation', 'Checksum', 'Create_options', 'Comment', ), 'result' => array( array( 'def', 'smash', 'issues_issue', 'BASE TABLE', 'InnoDB', '10', 'Compact', '9136', '862', '7880704', '0', '1032192', '420478976', '155862', '2012-08-29 13:28:28', 'NULL', 'NULL', 'utf8_general_ci', 'NULL', '', '', 'smash', 'issues_issue', 'BASE TABLE', 'InnoDB', 'InnoDB', '10', 'Compact', '9136', '862', '7880704', '0', '1032192', '420478976', '155862', '2012-08-29 13:28:28', 'NULL', 'NULL', 'utf8_general_ci', 'NULL', ), ), ), array( 'query' => 'SELECT COUNT(*) FROM `pma_test`.`table1`', 'result' => array(array(0)), ), array( 'query' => 'SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.' . '`USER_PRIVILEGES`' . ' WHERE GRANTEE=\'\'\'pma_test\'\'@\'\'localhost\'\'\'' . ' AND PRIVILEGE_TYPE=\'TRIGGER\'', 'result' => array(), ), array( 'query' => 'SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.' . '`SCHEMA_PRIVILEGES`' . ' WHERE GRANTEE=\'\'\'pma_test\'\'@\'\'localhost\'\'\'' . ' AND PRIVILEGE_TYPE=\'TRIGGER\' AND \'pma_test\'' . ' LIKE `TABLE_SCHEMA`', 'result' => array(), ), array( 'query' => 'SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.' . '`TABLE_PRIVILEGES`' . ' WHERE GRANTEE=\'\'\'pma_test\'\'@\'\'localhost\'\'\'' . ' AND PRIVILEGE_TYPE=\'TRIGGER\' AND \'pma_test\'' . ' LIKE `TABLE_SCHEMA` AND TABLE_NAME=\'table1\'', 'result' => array(), ), array( 'query' => 'SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.' . '`USER_PRIVILEGES`' . ' WHERE GRANTEE=\'\'\'pma_test\'\'@\'\'localhost\'\'\'' . ' AND PRIVILEGE_TYPE=\'EVENT\'', 'result' => array(), ), array( 'query' => 'SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.' . '`SCHEMA_PRIVILEGES`' . ' WHERE GRANTEE=\'\'\'pma_test\'\'@\'\'localhost\'\'\'' . ' AND PRIVILEGE_TYPE=\'EVENT\' AND \'pma_test\'' . ' LIKE `TABLE_SCHEMA`', 'result' => array(), ), array( 'query' => 'SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.' . '`TABLE_PRIVILEGES`' . ' WHERE GRANTEE=\'\'\'pma_test\'\'@\'\'localhost\'\'\'' . ' AND PRIVILEGE_TYPE=\'EVENT\'' . ' AND TABLE_SCHEMA=\'pma\\\\_test\' AND TABLE_NAME=\'table1\'', 'result' => array(), ), array( 'query' => 'RENAME TABLE `pma_test`.`table1` TO `pma_test`.`table3`;', 'result' => array(), ), array( 'query' => 'SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION,' . ' EVENT_OBJECT_TABLE, ACTION_TIMING, ACTION_STATEMENT, ' . 'EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, DEFINER' . ' FROM information_schema.TRIGGERS' . ' WHERE EVENT_OBJECT_SCHEMA= \'pma_test\'' . ' AND EVENT_OBJECT_TABLE = \'table1\';', 'result' => array(), ), array( 'query' => 'SHOW TABLES FROM `pma`;', 'result' => array(), ), array( 'query' => "SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`." . "`SCHEMA_PRIVILEGES` WHERE GRANTEE='''pma_test''@''localhost'''" . " AND PRIVILEGE_TYPE='EVENT' AND TABLE_SCHEMA='pma'", 'result' => array(), ), array( 'query' => "SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`." . "`SCHEMA_PRIVILEGES` WHERE GRANTEE='''pma_test''@''localhost'''" . " AND PRIVILEGE_TYPE='TRIGGER' AND TABLE_SCHEMA='pma'", 'result' => array(), ), array( 'query' => 'SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA' . ' WHERE SCHEMA_NAME = \'pma_test\' LIMIT 1', 'columns' => array('DEFAULT_COLLATION_NAME'), 'result' => array( array('utf8_general_ci'), ), ), array( 'query' => 'SELECT @@collation_database', 'columns' => array('@@collation_database'), 'result' => array( array('bar'), ), ), array( 'query' => "SHOW TABLES FROM `phpmyadmin`", 'result' => array(), ), array( 'query' => "SELECT tracking_active FROM `pmadb`.`tracking`" . " WHERE db_name = 'pma_test_db'" . " AND table_name = 'pma_test_table'" . " ORDER BY version DESC", 'columns' => array('tracking_active'), 'result' => array( array(1), ), ), array( 'query' => "SELECT tracking_active FROM `pmadb`.`tracking`" . " WHERE db_name = 'pma_test_db'" . " AND table_name = 'pma_test_table2'" . " ORDER BY version DESC", 'result' => array(), ), array( 'query' => "SHOW SLAVE STATUS", 'result' => array( array( 'Slave_IO_State' => 'running', 'Master_Host' => 'locahost', 'Master_User' => 'Master_User', 'Master_Port' => '1002', 'Connect_Retry' => 'Connect_Retry', 'Master_Log_File' => 'Master_Log_File', 'Read_Master_Log_Pos' => 'Read_Master_Log_Pos', 'Relay_Log_File' => 'Relay_Log_File', 'Relay_Log_Pos' => 'Relay_Log_Pos', 'Relay_Master_Log_File' => 'Relay_Master_Log_File', 'Slave_IO_Running' => 'NO', 'Slave_SQL_Running' => 'NO', 'Replicate_Do_DB' => 'Replicate_Do_DB', 'Replicate_Ignore_DB' => 'Replicate_Ignore_DB', 'Replicate_Do_Table' => 'Replicate_Do_Table', 'Replicate_Ignore_Table' => 'Replicate_Ignore_Table', 'Replicate_Wild_Do_Table' => 'Replicate_Wild_Do_Table', 'Replicate_Wild_Ignore_Table' => 'Replicate_Wild_Ignore_Table', 'Last_Errno' => 'Last_Errno', 'Last_Error' => 'Last_Error', 'Skip_Counter' => 'Skip_Counter', 'Exec_Master_Log_Pos' => 'Exec_Master_Log_Pos', 'Relay_Log_Space' => 'Relay_Log_Space', 'Until_Condition' => 'Until_Condition', 'Until_Log_File' => 'Until_Log_File', 'Until_Log_Pos' => 'Until_Log_Pos', 'Master_SSL_Allowed' => 'Master_SSL_Allowed', 'Master_SSL_CA_File' => 'Master_SSL_CA_File', 'Master_SSL_CA_Path' => 'Master_SSL_CA_Path', 'Master_SSL_Cert' => 'Master_SSL_Cert', 'Master_SSL_Cipher' => 'Master_SSL_Cipher', 'Master_SSL_Key' => 'Master_SSL_Key', 'Seconds_Behind_Master' => 'Seconds_Behind_Master', ), ), ), array( 'query' => "SHOW MASTER STATUS", 'result' => array( array( "File" => "master-bin.000030", "Position" => "107", "Binlog_Do_DB" => "Binlog_Do_DB", "Binlog_Ignore_DB" => "Binlog_Ignore_DB", ), ), ), array( 'query' => "SHOW GRANTS", 'result' => array(), ), array( 'query' => "SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, " . "(SELECT DB_first_level FROM ( SELECT DISTINCT " . "SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level " . "FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY " . "DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(" . "CONCAT(DB_first_level, '_'), CONCAT(SCHEMA_NAME, '_')) " . "ORDER BY SCHEMA_NAME ASC", 'result' => array( "test", ), ), array( 'query' => "SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(" . "SCHEMA_NAME, '_', 1) DB_first_level " . "FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t", 'result' => array( array(1), ), ), array( 'query' => "SELECT `PARTITION_METHOD` " . "FROM `information_schema`.`PARTITIONS` " . "WHERE `TABLE_SCHEMA` = 'db' AND `TABLE_NAME` = 'table' LIMIT 1", 'result' => array(), ), array( 'query' => "SHOW PLUGINS", 'result' => array( array('Name' => 'partition'), ), ), array( 'query' => "SHOW FULL TABLES FROM `default` WHERE `Table_type`='BASE TABLE'", 'result' => array( array("test1", "BASE TABLE"), array("test2", "BASE TABLE"), ), ), array( 'query' => "SHOW FULL TABLES FROM `default` " . "WHERE `Table_type`!='BASE TABLE'", 'result' => array(), ), array( 'query' => "SHOW FUNCTION STATUS WHERE `Db`='default'", 'result' => array(array("Name" => "testFunction")), ), array( 'query' => "SHOW PROCEDURE STATUS WHERE `Db`='default'", 'result' => array(), ), array( 'query' => "SHOW EVENTS FROM `default`", 'result' => array(), ), array( 'query' => "FLUSH PRIVILEGES", 'result' => array(), ), array( 'query' => "SELECT * FROM `mysql`.`db` LIMIT 1", 'result' => array(), ), array( 'query' => "SELECT * FROM `mysql`.`columns_priv` LIMIT 1", 'result' => array(), ), array( 'query' => "SELECT * FROM `mysql`.`tables_priv` LIMIT 1", 'result' => array(), ), array( 'query' => "SELECT * FROM `mysql`.`procs_priv` LIMIT 1", 'result' => array(), ), array( 'query' => 'DELETE FROM `mysql`.`db` WHERE `host` = "" ' . 'AND `Db` = "" AND `User` = ""', 'result' => true ), array( 'query' => 'DELETE FROM `mysql`.`columns_priv` WHERE ' . '`host` = "" AND `Db` = "" AND `User` = ""', 'result' => true ), array( 'query' => 'DELETE FROM `mysql`.`tables_priv` WHERE ' . '`host` = "" AND `Db` = "" AND `User` = "" AND Table_name = ""', 'result' => true ), array( 'query' => 'DELETE FROM `mysql`.`procs_priv` WHERE ' . '`host` = "" AND `Db` = "" AND `User` = "" AND `Routine_name` = "" ' . 'AND `Routine_type` = ""', 'result' => true ), array( 'query' => 'SELECT `plugin` FROM `mysql`.`user` WHERE ' . '`User` = "pma_username" AND `Host` = "pma_hostname" LIMIT 1', 'result' => array() ), array( 'query' => 'SELECT @@default_authentication_plugin', 'result' => array( array('@@default_authentication_plugin' => 'mysql_native_password'), ), ), array( 'query' => "SELECT TABLE_NAME FROM information_schema.VIEWS WHERE " . "TABLE_SCHEMA = 'db' AND TABLE_NAME = 'table'", 'result' => array(), ), array( 'query' => "SELECT *, `TABLE_SCHEMA` AS `Db`, " . "`TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, " . "`ENGINE` AS `Engine`, `ENGINE` AS `Type`, " . "`VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, " . "`TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, " . "`DATA_LENGTH` AS `Data_length`, " . "`MAX_DATA_LENGTH` AS `Max_data_length`, " . "`INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, " . "`AUTO_INCREMENT` AS `Auto_increment`, " . "`CREATE_TIME` AS `Create_time`, " . "`UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, " . "`TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, " . "`CREATE_OPTIONS` AS `Create_options`, " . "`TABLE_COMMENT` AS `Comment` " . "FROM `information_schema`.`TABLES` t " . "WHERE `TABLE_SCHEMA` IN ('db') " . "AND t.`TABLE_NAME` = 'table' ORDER BY Name ASC", 'result' => array(), ), array( 'query' => "SHOW TABLE STATUS FROM `db` WHERE `Name` LIKE 'table%'", 'result' => array(), ), array( 'query' => "SELECT @@have_partitioning;", 'result' => array(), ), array( 'query' => "SELECT @@lower_case_table_names", 'result' => array(), ), array( 'query' => "SELECT `PLUGIN_NAME`, `PLUGIN_DESCRIPTION` " . "FROM `information_schema`.`PLUGINS` " . "WHERE `PLUGIN_TYPE` = 'AUTHENTICATION';", 'result' => array(), ), array( 'query' => "SHOW TABLES FROM `db`;", 'result' => array(), ), array( 'query' => "SELECT `PRIVILEGE_TYPE` FROM " . "`INFORMATION_SCHEMA`.`SCHEMA_PRIVILEGES` " . "WHERE GRANTEE='''pma_test''@''localhost''' " . "AND PRIVILEGE_TYPE='EVENT' AND 'db' LIKE `TABLE_SCHEMA`", 'result' => array(), ), array( 'query' => "SELECT `PRIVILEGE_TYPE` FROM " . "`INFORMATION_SCHEMA`.`SCHEMA_PRIVILEGES` " . "WHERE GRANTEE='''pma_test''@''localhost''' " . "AND PRIVILEGE_TYPE='TRIGGER' AND 'db' LIKE `TABLE_SCHEMA`", 'result' => array(), ), array( 'query' => "SELECT (COUNT(DB_first_level) DIV 100) * 100 from " . "( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) " . "DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA " . "WHERE `SCHEMA_NAME` < 'db' ) t", 'result' => array(), ), array( 'query' => "SELECT `SCHEMA_NAME` FROM " . "`INFORMATION_SCHEMA`.`SCHEMATA`, " . "(SELECT DB_first_level FROM ( SELECT DISTINCT " . "SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM " . "INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t " . "ORDER BY DB_first_level ASC LIMIT , 100) t2 WHERE TRUE AND " . "1 = LOCATE(CONCAT(DB_first_level, '_'), " . "CONCAT(SCHEMA_NAME, '_')) ORDER BY SCHEMA_NAME ASC", 'result' => array(), ), array( 'query' => 'SELECT @@ndb_version_string', 'result' => array(array('ndb-7.4.10')), ), ); /** * Current database. */ $GLOBALS['dummy_db'] = ''; /* Some basic setup for dummy driver */ $GLOBALS['userlink'] = 1; $GLOBALS['controllink'] = 2; $GLOBALS['cfg']['DBG']['sql'] = false; if (!defined('PMA_MARIADB')) { define('PMA_MARIADB', 0); } /** * Fake database driver for testing purposes * * It has hardcoded results for given queries what makes easy to use it * in testsuite. Feel free to include other queries which your test will * need. * * @package PhpMyAdmin-DBI * @subpackage Dummy */ class DBIDummy implements DBIExtension { /** * connects to the database server * * @param string $user mysql user name * @param string $password mysql user password * @param bool $is_controluser whether this is a control user connection * @param array $server host/port/socket/persistent * @param bool $auxiliary_connection (when true, don't go back to login if * connection fails) * * @return mixed false on error or a mysqli object on success */ public function connect( $user, $password, $is_controluser = false, $server = null, $auxiliary_connection = false ) { return true; } /** * selects given database * * @param string $dbname name of db to select * @param resource $link mysql link resource * * @return bool */ public function selectDb($dbname, $link) { $GLOBALS['dummy_db'] = $dbname; return true; } /** * runs a query and returns the result * * @param string $query query to run * @param resource $link mysql link resource * @param int $options query options * * @return mixed */ public function realQuery($query, $link = null, $options = 0) { $query = trim(preg_replace('/ */', ' ', str_replace("\n", ' ', $query))); for ($i = 0, $nb = count($GLOBALS['dummy_queries']); $i < $nb; $i++) { if ($GLOBALS['dummy_queries'][$i]['query'] != $query) { continue; } $GLOBALS['dummy_queries'][$i]['pos'] = 0; if (!is_array($GLOBALS['dummy_queries'][$i]['result'])) { return false; } return $i; } echo "Not supported query: $query\n"; return false; } /** * Run the multi query and output the results * * @param resource $link connection object * @param string $query multi query statement to execute * * @return array|bool */ public function realMultiQuery($link, $query) { return false; } /** * returns result data from $result * * @param object $result MySQL result * * @return array */ public function fetchAny($result) { $query_data = $GLOBALS['dummy_queries'][$result]; if ($query_data['pos'] >= count($query_data['result'])) { return false; } $ret = $query_data['result'][$query_data['pos']]; $GLOBALS['dummy_queries'][$result]['pos'] += 1; return $ret; } /** * returns array of rows with associative and numeric keys from $result * * @param object $result result MySQL result * * @return array */ public function fetchArray($result) { $data = $this->fetchAny($result); if (!is_array($data) || !isset($GLOBALS['dummy_queries'][$result]['columns']) ) { return $data; } foreach ($data as $key => $val) { $data[$GLOBALS['dummy_queries'][$result]['columns'][$key]] = $val; } return $data; } /** * returns array of rows with associative keys from $result * * @param object $result MySQL result * * @return array */ public function fetchAssoc($result) { $data = $this->fetchAny($result); if (!is_array($data) || !isset($GLOBALS['dummy_queries'][$result]['columns']) ) { return $data; } $ret = array(); foreach ($data as $key => $val) { $ret[$GLOBALS['dummy_queries'][$result]['columns'][$key]] = $val; } return $ret; } /** * returns array of rows with numeric keys from $result * * @param object $result MySQL result * * @return array */ public function fetchRow($result) { $data = $this->fetchAny($result); return $data; } /** * Adjusts the result pointer to an arbitrary row in the result * * @param object $result database result * @param integer $offset offset to seek * * @return bool true on success, false on failure */ public function dataSeek($result, $offset) { if ($offset > count($GLOBALS['dummy_queries'][$result]['result'])) { return false; } $GLOBALS['dummy_queries'][$result]['pos'] = $offset; return true; } /** * Frees memory associated with the result * * @param object $result database result * * @return void */ public function freeResult($result) { return; } /** * Check if there are any more query results from a multi query * * @param resource $link the connection object * * @return bool false */ public function moreResults($link) { return false; } /** * Prepare next result from multi_query * * @param resource $link the connection object * * @return boolean false */ public function nextResult($link) { return false; } /** * Store the result returned from multi query * * @param resource $link the connection object * * @return mixed false when empty results / result set when not empty */ public function storeResult($link) { return false; } /** * Returns a string representing the type of connection used * * @param resource $link mysql link * * @return string type of connection used */ public function getHostInfo($link) { return ''; } /** * Returns the version of the MySQL protocol used * * @param resource $link mysql link * * @return integer version of the MySQL protocol used */ public function getProtoInfo($link) { return -1; } /** * returns a string that represents the client library version * * @return string MySQL client library version */ public function getClientInfo() { return ''; } /** * returns last error message or false if no errors occurred * * @param resource $link connection link * * @return string|bool $error or false */ public function getError($link) { return false; } /** * returns the number of rows returned by last query * * @param object $result MySQL result * * @return string|int */ public function numRows($result) { if (is_bool($result)) { return 0; } return count($GLOBALS['dummy_queries'][$result]['result']); } /** * returns the number of rows affected by last query * * @param resource $link the mysql object * @param bool $get_from_cache whether to retrieve from cache * * @return string|int */ public function affectedRows($link = null, $get_from_cache = true) { return 0; } /** * returns metainfo for fields in $result * * @param object $result result set identifier * * @return array meta info for fields in $result */ public function getFieldsMeta($result) { return array(); } /** * return number of fields in given $result * * @param object $result MySQL result * * @return int field count */ public function numFields($result) { if (!isset($GLOBALS['dummy_queries'][$result]['columns'])) { return 0; } return count($GLOBALS['dummy_queries'][$result]['columns']); } /** * returns the length of the given field $i in $result * * @param object $result result set identifier * @param int $i field * * @return int length of field */ public function fieldLen($result, $i) { return -1; } /** * returns name of $i. field in $result * * @param object $result result set identifier * @param int $i field * * @return string name of $i. field in $result */ public function fieldName($result, $i) { return ''; } /** * returns concatenated string of human readable field flags * * @param object $result result set identifier * @param int $i field * * @return string field flags */ public function fieldFlags($result, $i) { return ''; } /** * returns properly escaped string for use in MySQL queries * * @param mixed $link database link * @param string $str string to be escaped * * @return string a MySQL escaped string */ public function escapeString($link, $str) { return $str; } }