Viewing file: DBIDummy.class.php (28.1 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * 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 */ if (! defined('PHPMYADMIN')) { exit; }
require_once './libraries/dbi/DBIExtension.int.php';
/** * Array of queries this "driver" supports */ $GLOBALS['dummy_queries'] = array( array('query' => 'SELECT 1', 'result' => array(array('1'))), array( 'query' => 'SELECT CURRENT_USER();', 'result' => array(array('pma_test@localhost')), ), array( 'query' => 'SELECT COUNT(*) FROM mysql.user', 'result' => false, ), array( 'query' => 'SHOW MASTER LOGS', 'result' => false, ), array( 'query' => 'SHOW STORAGE ENGINES', 'result' => array( array( 'Engine' => 'dummy', 'Support' => 'YES', 'Comment' => 'dummy comment' ), array( 'Engine' => 'dummy2', 'Support' => 'NO', 'Comment' => 'dummy2 comment' ), array( 'Engine' => 'FEDERATED', 'Support' => 'NO', 'Comment' => 'Federated MySQL storage engine' ), ) ), array( 'query' => 'SHOW STATUS WHERE Variable_name' . ' LIKE \'Innodb\\_buffer\\_pool\\_%\'' . ' OR Variable_name = \'Innodb_page_size\';', 'result' => array( array('Innodb_buffer_pool_pages_data', 0), array('Innodb_buffer_pool_pages_dirty', 0), array('Innodb_buffer_pool_pages_flushed', 0), array('Innodb_buffer_pool_pages_free', 0), array('Innodb_buffer_pool_pages_misc', 0), array('Innodb_buffer_pool_pages_total', 4096), array('Innodb_buffer_pool_read_ahead_rnd', 0), array('Innodb_buffer_pool_read_ahead', 0), array('Innodb_buffer_pool_read_ahead_evicted', 0), array('Innodb_buffer_pool_read_requests', 64), array('Innodb_buffer_pool_reads', 32), array('Innodb_buffer_pool_wait_free', 0), array('Innodb_buffer_pool_write_requests', 64), array('Innodb_page_size', 16384), ) ), array( 'query' => 'SHOW INNODB STATUS;', 'result' => false, ), array( 'query' => 'SELECT @@innodb_version;', 'result' => array( array('1.1.8'), ) ), array( 'query' => 'SHOW GLOBAL VARIABLES LIKE \'innodb_file_per_table\';', 'result' => array( array('innodb_file_per_table', 'OFF'), ) ), array( 'query' => 'SHOW GLOBAL VARIABLES LIKE \'innodb_file_format\';', 'result' => array( array('innodb_file_format', 'Antelope'), ) ), array( 'query' => 'SHOW VARIABLES LIKE \'collation_server\'', 'result' => array( array('collation_server', 'utf8_general_ci'), ) ), array( 'query' => 'SHOW VARIABLES LIKE \'language\';', 'result' => array(), ), 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 upper(plugin_name) f FROM data_dictionary.plugins' . ' WHERE plugin_name IN (\'MYSQL_PASSWORD\',\'ROT13\')' . ' AND plugin_type = \'Function\' AND is_active', 'columns' => array('f'), 'result' => array(array('ROT13')), ), array( 'query' => 'SELECT `column_name`, `mimetype`, `transformation`,' . ' `transformation_options` FROM `pmadb`.`column_info`' . ' WHERE `db_name` = \'pma_test\' AND `table_name` = \'table1\'' . ' AND ( `mimetype` != \'\' OR `transformation` != \'\'' . ' OR `transformation_options` != \'\')', 'columns' => array( 'column_name', 'mimetype', 'transformation', 'transformation_options' ), 'result' => array( array('o', 'text/plain', 'sql'), ) ), 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 BINARY `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\'' . ' REGEXP REPLACE(REPLACE(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\'' . ' REGEXP REPLACE(REPLACE(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\'' . ' REGEXP REPLACE(REPLACE(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 TRIGGER_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 DEFAULT_COLLATION_NAME FROM data_dictionary.SCHEMAS' . ' WHERE SCHEMA_NAME = \'pma_test\' LIMIT 1', 'columns' => array('DEFAULT_COLLATION_NAME'), 'result' => array( array('utf8_general_ci_pma_drizzle') ) ), array( 'query' => 'SHOW VARIABLES LIKE \'collation_database\'', 'columns' => array('variable_name', 'variable_value'), 'result' => array( array('foo', 'bar'), ) ), array( 'query' => "SHOW TABLES FROM `phpmyadmin`", 'result' => array(), ), array( 'query' => "SELECT tracking_active FROM pma_table_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 pma_table_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() ) ); /** * 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_DRIZZLE')) { define('PMA_DRIZZLE', 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 PMA_DBI_Dummy implements PMA_DBI_Extension { /** * 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 = null) { $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 object $link connection object * @param string $query multi query statement to execute * * @return result collection | boolean(false) */ public function realMultiQuery($link, $query) { return false; }
/** * returns result data from $result * * @param resource $result 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 resource $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 resource $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 resource $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 resource $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 resource $result database result * * @return void */ public function freeResult($result) { return; }
/** * Check if there are any more query results from a multi query * * @param object $link the connection object * * @return bool false */ public function moreResults($link = null) { return false; }
/** * Prepare next result from multi_query * * @param object $link the connection object * * @return boolean false */ public function nextResult($link = null) { return false; }
/** * Store the result returned from multi query * * @return mixed false when empty results / result set when not empty */ public function storeResult() { return false; }
/** * Returns a string representing the type of connection used * * @param object $link mysql link * * @return string type of connection used */ public function getHostInfo($link = null) { return ''; }
/** * Returns the version of the MySQL protocol used * * @param object $link mysql link * * @return integer version of the MySQL protocol used */ public function getProtoInfo($link = null) { 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 object $link connection link * * @return string|bool $error or false */ public function getError($link = null) { return false; }
/** * returns the number of rows returned by last query * * @param resource $result MySQL result * * @return string|int */ public function numRows($result) { if (is_bool($result)) { return 0; }
return count($GLOBALS['dummy_queries'][$result]['result']); }
/** * returns last inserted auto_increment id for given $link * or $GLOBALS['userlink'] * * @param object $link the connection object * * @return string|int */ public function insertId($link = null) { return -1; }
/** * 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 resource $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 ''; } } ?>
|