The branch, master has been updated via 7e7be00f8466bb380e0c1d4370aa43ece0b1780f (commit) from 8cb1f3a1cc1a089e53a89c1a4f59cd63a1ddecf8 (commit)
- Log ----------------------------------------------------------------- commit 7e7be00f8466bb380e0c1d4370aa43ece0b1780f Author: Michal Čihař mcihar@suse.cz Date: Tue Aug 2 15:50:44 2011 +0200
Forgot to reindent this one
-----------------------------------------------------------------------
Summary of changes: libraries/export/sql.php | 1632 +++++++++++++++++++++++----------------------- 1 files changed, 816 insertions(+), 816 deletions(-)
diff --git a/libraries/export/sql.php b/libraries/export/sql.php index 0781db4..f0f6f15 100644 --- a/libraries/export/sql.php +++ b/libraries/export/sql.php @@ -294,956 +294,956 @@ if (isset($plugin_list)) { } } else {
-/** - * Avoids undefined variables, use NULL so isset() returns false - */ -if (! isset($sql_backquotes)) { - $sql_backquotes = null; -} + /** + * Avoids undefined variables, use NULL so isset() returns false + */ + if (! isset($sql_backquotes)) { + $sql_backquotes = null; + }
-/** - * Exports routines (procedures and functions) - * - * @param string $db - * @return bool Whether it suceeded - * - * @access public - */ -function PMA_exportRoutines($db) { - global $crlf; + /** + * Exports routines (procedures and functions) + * + * @param string $db + * @return bool Whether it suceeded + * + * @access public + */ + function PMA_exportRoutines($db) { + global $crlf; + + $text = ''; + $delimiter = '$$';
- $text = ''; - $delimiter = '$$'; + $procedure_names = PMA_DBI_get_procedures_or_functions($db, 'PROCEDURE'); + $function_names = PMA_DBI_get_procedures_or_functions($db, 'FUNCTION');
- $procedure_names = PMA_DBI_get_procedures_or_functions($db, 'PROCEDURE'); - $function_names = PMA_DBI_get_procedures_or_functions($db, 'FUNCTION'); + if ($procedure_names || $function_names) { + $text .= $crlf + . 'DELIMITER ' . $delimiter . $crlf; + }
- if ($procedure_names || $function_names) { - $text .= $crlf - . 'DELIMITER ' . $delimiter . $crlf; - } + if ($procedure_names) { + $text .= + PMA_exportComment() + . PMA_exportComment(__('Procedures')) + . PMA_exportComment();
- if ($procedure_names) { - $text .= - PMA_exportComment() - . PMA_exportComment(__('Procedures')) - . PMA_exportComment(); - - foreach ($procedure_names as $procedure_name) { - if (! empty($GLOBALS['sql_drop_table'])) { - $text .= 'DROP PROCEDURE IF EXISTS ' - . PMA_backquote($procedure_name) - . $delimiter . $crlf; + foreach ($procedure_names as $procedure_name) { + if (! empty($GLOBALS['sql_drop_table'])) { + $text .= 'DROP PROCEDURE IF EXISTS ' + . PMA_backquote($procedure_name) + . $delimiter . $crlf; + } + $text .= PMA_DBI_get_definition($db, 'PROCEDURE', $procedure_name) + . $delimiter . $crlf . $crlf; } - $text .= PMA_DBI_get_definition($db, 'PROCEDURE', $procedure_name) - . $delimiter . $crlf . $crlf; } - }
- if ($function_names) { - $text .= - PMA_exportComment() - . PMA_exportComment(__('Functions')) - . PMA_exportComment(); - - foreach ($function_names as $function_name) { - if (! empty($GLOBALS['sql_drop_table'])) { - $text .= 'DROP FUNCTION IF EXISTS ' - . PMA_backquote($function_name) - . $delimiter . $crlf; + if ($function_names) { + $text .= + PMA_exportComment() + . PMA_exportComment(__('Functions')) + . PMA_exportComment(); + + foreach ($function_names as $function_name) { + if (! empty($GLOBALS['sql_drop_table'])) { + $text .= 'DROP FUNCTION IF EXISTS ' + . PMA_backquote($function_name) + . $delimiter . $crlf; + } + $text .= PMA_DBI_get_definition($db, 'FUNCTION', $function_name) + . $delimiter . $crlf . $crlf; } - $text .= PMA_DBI_get_definition($db, 'FUNCTION', $function_name) - . $delimiter . $crlf . $crlf; } - }
- if ($procedure_names || $function_names) { - $text .= 'DELIMITER ;' . $crlf; - } + if ($procedure_names || $function_names) { + $text .= 'DELIMITER ;' . $crlf; + }
- if (! empty($text)) { - return PMA_exportOutputHandler($text); - } else { - return false; + if (! empty($text)) { + return PMA_exportOutputHandler($text); + } else { + return false; + } } -}
-/** - * Possibly outputs comment - * - * @param string $text Text of comment - * @return string The formatted comment - * - * @access private - */ -function PMA_exportComment($text = '') -{ - if (isset($GLOBALS['sql_include_comments']) && $GLOBALS['sql_include_comments']) { - // see http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-comments.html - return '--' . (empty($text) ? '' : ' ') . $text . $GLOBALS['crlf']; - } else { - return ''; + /** + * Possibly outputs comment + * + * @param string $text Text of comment + * @return string The formatted comment + * + * @access private + */ + function PMA_exportComment($text = '') + { + if (isset($GLOBALS['sql_include_comments']) && $GLOBALS['sql_include_comments']) { + // see http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-comments.html + return '--' . (empty($text) ? '' : ' ') . $text . $GLOBALS['crlf']; + } else { + return ''; + } } -}
-/** - * Possibly outputs CRLF - * - * @return string $crlf or nothing - * - * @access private - */ -function PMA_possibleCRLF() -{ - if (isset($GLOBALS['sql_include_comments']) && $GLOBALS['sql_include_comments']) { - return $GLOBALS['crlf']; - } else { - return ''; + /** + * Possibly outputs CRLF + * + * @return string $crlf or nothing + * + * @access private + */ + function PMA_possibleCRLF() + { + if (isset($GLOBALS['sql_include_comments']) && $GLOBALS['sql_include_comments']) { + return $GLOBALS['crlf']; + } else { + return ''; + } } -}
-/** - * Outputs export footer - * - * @return bool Whether it suceeded - * - * @access public - */ -function PMA_exportFooter() -{ - global $crlf; - global $mysql_charset_map; + /** + * Outputs export footer + * + * @return bool Whether it suceeded + * + * @access public + */ + function PMA_exportFooter() + { + global $crlf; + global $mysql_charset_map; + + $foot = ''; + + if (isset($GLOBALS['sql_disable_fk'])) { + $foot .= 'SET FOREIGN_KEY_CHECKS=1;' . $crlf; + }
- $foot = ''; + if (isset($GLOBALS['sql_use_transaction'])) { + $foot .= 'COMMIT;' . $crlf; + }
- if (isset($GLOBALS['sql_disable_fk'])) { - $foot .= 'SET FOREIGN_KEY_CHECKS=1;' . $crlf; - } + // restore connection settings + $charset_of_file = isset($GLOBALS['charset_of_file']) ? $GLOBALS['charset_of_file'] : ''; + if (!empty($GLOBALS['asfile']) && isset($mysql_charset_map[$charset_of_file])) { + $foot .= $crlf + . '/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;' . $crlf + . '/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;' . $crlf + . '/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;' . $crlf; + }
- if (isset($GLOBALS['sql_use_transaction'])) { - $foot .= 'COMMIT;' . $crlf; - } + /* Restore timezone */ + if ($GLOBALS['sql_utc_time']) { + PMA_DBI_query('SET time_zone = "' . $GLOBALS['old_tz'] . '"'); + }
- // restore connection settings - $charset_of_file = isset($GLOBALS['charset_of_file']) ? $GLOBALS['charset_of_file'] : ''; - if (!empty($GLOBALS['asfile']) && isset($mysql_charset_map[$charset_of_file])) { - $foot .= $crlf - . '/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;' . $crlf - . '/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;' . $crlf - . '/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;' . $crlf; + return PMA_exportOutputHandler($foot); }
- /* Restore timezone */ - if ($GLOBALS['sql_utc_time']) { - PMA_DBI_query('SET time_zone = "' . $GLOBALS['old_tz'] . '"'); - } + /** + * Outputs export header + * + * @return bool Whether it suceeded + * + * @access public + */ + function PMA_exportHeader() + { + global $crlf; + global $cfg; + global $mysql_charset_map; + + if (isset($GLOBALS['sql_compatibility'])) { + $tmp_compat = $GLOBALS['sql_compatibility']; + if ($tmp_compat == 'NONE') { + $tmp_compat = ''; + } + PMA_DBI_try_query('SET SQL_MODE="' . $tmp_compat . '"'); + unset($tmp_compat); + } + $head = PMA_exportComment('phpMyAdmin SQL Dump') + . PMA_exportComment('version ' . PMA_VERSION) + . PMA_exportComment('http://www.phpmyadmin.net') + . PMA_exportComment(); + $host_string = __('Host') . ': ' . $cfg['Server']['host']; + if (!empty($cfg['Server']['port'])) { + $host_string .= ':' . $cfg['Server']['port']; + } + $head .= PMA_exportComment($host_string); + $head .= PMA_exportComment(__('Generation Time') + . ': ' . PMA_localisedDate()) + . PMA_exportComment(__('Server version') . ': ' . PMA_MYSQL_STR_VERSION) + . PMA_exportComment(__('PHP Version') . ': ' . phpversion()) + . PMA_possibleCRLF(); + + if (isset($GLOBALS['sql_header_comment']) && !empty($GLOBALS['sql_header_comment'])) { + // '\n' is not a newline (like "\n" would be), it's the characters + // backslash and n, as explained on the export interface + $lines = explode('\n', $GLOBALS['sql_header_comment']); + $head .= PMA_exportComment(); + foreach ($lines as $one_line) { + $head .= PMA_exportComment($one_line); + } + $head .= PMA_exportComment(); + }
- return PMA_exportOutputHandler($foot); -} + if (isset($GLOBALS['sql_disable_fk'])) { + $head .= 'SET FOREIGN_KEY_CHECKS=0;' . $crlf; + }
-/** - * Outputs export header - * - * @return bool Whether it suceeded - * - * @access public - */ -function PMA_exportHeader() -{ - global $crlf; - global $cfg; - global $mysql_charset_map; - - if (isset($GLOBALS['sql_compatibility'])) { - $tmp_compat = $GLOBALS['sql_compatibility']; - if ($tmp_compat == 'NONE') { - $tmp_compat = ''; + /* We want exported AUTO_INCREMENT fields to have still same value, do this only for recent MySQL exports */ + if (!isset($GLOBALS['sql_compatibility']) || $GLOBALS['sql_compatibility'] == 'NONE') { + $head .= 'SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";' . $crlf; } - PMA_DBI_try_query('SET SQL_MODE="' . $tmp_compat . '"'); - unset($tmp_compat); - } - $head = PMA_exportComment('phpMyAdmin SQL Dump') - . PMA_exportComment('version ' . PMA_VERSION) - . PMA_exportComment('http://www.phpmyadmin.net') - . PMA_exportComment(); - $host_string = __('Host') . ': ' . $cfg['Server']['host']; - if (!empty($cfg['Server']['port'])) { - $host_string .= ':' . $cfg['Server']['port']; - } - $head .= PMA_exportComment($host_string); - $head .= PMA_exportComment(__('Generation Time') - . ': ' . PMA_localisedDate()) - . PMA_exportComment(__('Server version') . ': ' . PMA_MYSQL_STR_VERSION) - . PMA_exportComment(__('PHP Version') . ': ' . phpversion()) - . PMA_possibleCRLF(); - - if (isset($GLOBALS['sql_header_comment']) && !empty($GLOBALS['sql_header_comment'])) { - // '\n' is not a newline (like "\n" would be), it's the characters - // backslash and n, as explained on the export interface - $lines = explode('\n', $GLOBALS['sql_header_comment']); - $head .= PMA_exportComment(); - foreach ($lines as $one_line) { - $head .= PMA_exportComment($one_line); + + if (isset($GLOBALS['sql_use_transaction'])) { + $head .= 'SET AUTOCOMMIT=0;' . $crlf + . 'START TRANSACTION;' . $crlf; } - $head .= PMA_exportComment(); - }
- if (isset($GLOBALS['sql_disable_fk'])) { - $head .= 'SET FOREIGN_KEY_CHECKS=0;' . $crlf; - }
- /* We want exported AUTO_INCREMENT fields to have still same value, do this only for recent MySQL exports */ - if (!isset($GLOBALS['sql_compatibility']) || $GLOBALS['sql_compatibility'] == 'NONE') { - $head .= 'SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";' . $crlf; - } + /* Change timezone if we should export timestamps in UTC */ + if ($GLOBALS['sql_utc_time']) { + $head .= 'SET time_zone = "+00:00";' . $crlf; + $GLOBALS['old_tz'] = PMA_DBI_fetch_value('SELECT @@session.time_zone'); + PMA_DBI_query('SET time_zone = "+00:00"'); + }
- if (isset($GLOBALS['sql_use_transaction'])) { - $head .= 'SET AUTOCOMMIT=0;' . $crlf - . 'START TRANSACTION;' . $crlf; - } + $head .= PMA_possibleCRLF();
+ if (! empty($GLOBALS['asfile'])) { + // we are saving as file, therefore we provide charset information + // so that a utility like the mysql client can interpret + // the file correctly + if (isset($GLOBALS['charset_of_file']) && isset($mysql_charset_map[$GLOBALS['charset_of_file']])) { + // we got a charset from the export dialog + $set_names = $mysql_charset_map[$GLOBALS['charset_of_file']]; + } else { + // by default we use the connection charset + $set_names = $mysql_charset_map['utf-8']; + } + $head .= $crlf + . '/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;' . $crlf + . '/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;' . $crlf + . '/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;' . $crlf + . '/*!40101 SET NAMES ' . $set_names . ' */;' . $crlf . $crlf; + }
- /* Change timezone if we should export timestamps in UTC */ - if ($GLOBALS['sql_utc_time']) { - $head .= 'SET time_zone = "+00:00";' . $crlf; - $GLOBALS['old_tz'] = PMA_DBI_fetch_value('SELECT @@session.time_zone'); - PMA_DBI_query('SET time_zone = "+00:00"'); + return PMA_exportOutputHandler($head); }
- $head .= PMA_possibleCRLF(); - - if (! empty($GLOBALS['asfile'])) { - // we are saving as file, therefore we provide charset information - // so that a utility like the mysql client can interpret - // the file correctly - if (isset($GLOBALS['charset_of_file']) && isset($mysql_charset_map[$GLOBALS['charset_of_file']])) { - // we got a charset from the export dialog - $set_names = $mysql_charset_map[$GLOBALS['charset_of_file']]; + /** + * Outputs CREATE DATABASE statement + * + * @param string $db Database name + * @return bool Whether it suceeded + * + * @access public + */ + function PMA_exportDBCreate($db) + { + global $crlf; + if (isset($GLOBALS['sql_drop_database'])) { + if (!PMA_exportOutputHandler('DROP DATABASE ' . (isset($GLOBALS['sql_backquotes']) ? PMA_backquote($db) : $db) . ';' . $crlf)) { + return false; + } + } + $create_query = 'CREATE DATABASE ' . (isset($GLOBALS['sql_backquotes']) ? PMA_backquote($db) : $db); + $collation = PMA_getDbCollation($db); + if (strpos($collation, '_')) { + $create_query .= ' DEFAULT CHARACTER SET ' . substr($collation, 0, strpos($collation, '_')) . ' COLLATE ' . $collation; } else { - // by default we use the connection charset - $set_names = $mysql_charset_map['utf-8']; + $create_query .= ' DEFAULT CHARACTER SET ' . $collation; } - $head .= $crlf - . '/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;' . $crlf - . '/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;' . $crlf - . '/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;' . $crlf - . '/*!40101 SET NAMES ' . $set_names . ' */;' . $crlf . $crlf; - } - - return PMA_exportOutputHandler($head); -} - -/** - * Outputs CREATE DATABASE statement - * - * @param string $db Database name - * @return bool Whether it suceeded - * - * @access public - */ -function PMA_exportDBCreate($db) -{ - global $crlf; - if (isset($GLOBALS['sql_drop_database'])) { - if (!PMA_exportOutputHandler('DROP DATABASE ' . (isset($GLOBALS['sql_backquotes']) ? PMA_backquote($db) : $db) . ';' . $crlf)) { + $create_query .= ';' . $crlf; + if (!PMA_exportOutputHandler($create_query)) { return false; } - } - $create_query = 'CREATE DATABASE ' . (isset($GLOBALS['sql_backquotes']) ? PMA_backquote($db) : $db); - $collation = PMA_getDbCollation($db); - if (strpos($collation, '_')) { - $create_query .= ' DEFAULT CHARACTER SET ' . substr($collation, 0, strpos($collation, '_')) . ' COLLATE ' . $collation; - } else { - $create_query .= ' DEFAULT CHARACTER SET ' . $collation; - } - $create_query .= ';' . $crlf; - if (!PMA_exportOutputHandler($create_query)) { - return false; - } - if (isset($GLOBALS['sql_backquotes']) && isset($GLOBALS['sql_compatibility']) && $GLOBALS['sql_compatibility'] == 'NONE') { - $result = PMA_exportOutputHandler('USE ' . PMA_backquote($db) . ';' . $crlf); - } else { - $result = PMA_exportOutputHandler('USE ' . $db . ';' . $crlf); - } - - return $result; -} - -/** - * Outputs database header - * - * @param string $db Database name - * @return bool Whether it suceeded - * - * @access public - */ -function PMA_exportDBHeader($db) -{ - $head = PMA_exportComment() - . PMA_exportComment(__('Database') . ': ' . (isset($GLOBALS['sql_backquotes']) ? PMA_backquote($db) : ''' . $db . ''')) - . PMA_exportComment(); - return PMA_exportOutputHandler($head); -} + if (isset($GLOBALS['sql_backquotes']) && isset($GLOBALS['sql_compatibility']) && $GLOBALS['sql_compatibility'] == 'NONE') { + $result = PMA_exportOutputHandler('USE ' . PMA_backquote($db) . ';' . $crlf); + } else { + $result = PMA_exportOutputHandler('USE ' . $db . ';' . $crlf); + }
-/** - * Outputs database footer - * - * @param string $db Database name - * @return bool Whether it suceeded - * - * @access public - */ -function PMA_exportDBFooter($db) -{ - global $crlf; - - $result = true; - if (isset($GLOBALS['sql_constraints'])) { - $result = PMA_exportOutputHandler($GLOBALS['sql_constraints']); - unset($GLOBALS['sql_constraints']); + return $result; }
- if (($GLOBALS['sql_structure_or_data'] == 'structure' || $GLOBALS['sql_structure_or_data'] == 'structure_and_data') && isset($GLOBALS['sql_procedure_function'])) { - $text = ''; - $delimiter = '$$'; + /** + * Outputs database header + * + * @param string $db Database name + * @return bool Whether it suceeded + * + * @access public + */ + function PMA_exportDBHeader($db) + { + $head = PMA_exportComment() + . PMA_exportComment(__('Database') . ': ' . (isset($GLOBALS['sql_backquotes']) ? PMA_backquote($db) : ''' . $db . ''')) + . PMA_exportComment(); + return PMA_exportOutputHandler($head); + }
- if (PMA_MYSQL_INT_VERSION > 50100) { - $event_names = PMA_DBI_fetch_result('SELECT EVENT_NAME FROM information_schema.EVENTS WHERE EVENT_SCHEMA= '' . PMA_sqlAddSlashes($db,true) . '';'); - } else { - $event_names = array(); + /** + * Outputs database footer + * + * @param string $db Database name + * @return bool Whether it suceeded + * + * @access public + */ + function PMA_exportDBFooter($db) + { + global $crlf; + + $result = true; + if (isset($GLOBALS['sql_constraints'])) { + $result = PMA_exportOutputHandler($GLOBALS['sql_constraints']); + unset($GLOBALS['sql_constraints']); }
- if ($event_names) { - $text .= $crlf - . 'DELIMITER ' . $delimiter . $crlf; + if (($GLOBALS['sql_structure_or_data'] == 'structure' || $GLOBALS['sql_structure_or_data'] == 'structure_and_data') && isset($GLOBALS['sql_procedure_function'])) { + $text = ''; + $delimiter = '$$';
- $text .= - PMA_exportComment() - . PMA_exportComment(__('Events')) - . PMA_exportComment(); + if (PMA_MYSQL_INT_VERSION > 50100) { + $event_names = PMA_DBI_fetch_result('SELECT EVENT_NAME FROM information_schema.EVENTS WHERE EVENT_SCHEMA= '' . PMA_sqlAddSlashes($db,true) . '';'); + } else { + $event_names = array(); + }
- foreach ($event_names as $event_name) { - if (! empty($GLOBALS['sql_drop_table'])) { - $text .= 'DROP EVENT ' . PMA_backquote($event_name) . $delimiter . $crlf; + if ($event_names) { + $text .= $crlf + . 'DELIMITER ' . $delimiter . $crlf; + + $text .= + PMA_exportComment() + . PMA_exportComment(__('Events')) + . PMA_exportComment(); + + foreach ($event_names as $event_name) { + if (! empty($GLOBALS['sql_drop_table'])) { + $text .= 'DROP EVENT ' . PMA_backquote($event_name) . $delimiter . $crlf; + } + $text .= PMA_DBI_get_definition($db, 'EVENT', $event_name) . $delimiter . $crlf . $crlf; } - $text .= PMA_DBI_get_definition($db, 'EVENT', $event_name) . $delimiter . $crlf . $crlf; - }
- $text .= 'DELIMITER ;' . $crlf; - } + $text .= 'DELIMITER ;' . $crlf; + }
- if (! empty($text)) { - $result = PMA_exportOutputHandler($text); + if (! empty($text)) { + $result = PMA_exportOutputHandler($text); + } } + return $result; } - return $result; -}
-/** - * Returns a stand-in CREATE definition to resolve view dependencies - * - * @param string $db the database name - * @param string $view the view name - * @param string $crlf the end of line sequence - * @return string resulting definition - * - * @access public - */ -function PMA_getTableDefStandIn($db, $view, $crlf) { - $create_query = ''; - if (! empty($GLOBALS['sql_drop_table'])) { - $create_query .= 'DROP VIEW IF EXISTS ' . PMA_backquote($view) . ';' . $crlf; - } + /** + * Returns a stand-in CREATE definition to resolve view dependencies + * + * @param string $db the database name + * @param string $view the view name + * @param string $crlf the end of line sequence + * @return string resulting definition + * + * @access public + */ + function PMA_getTableDefStandIn($db, $view, $crlf) { + $create_query = ''; + if (! empty($GLOBALS['sql_drop_table'])) { + $create_query .= 'DROP VIEW IF EXISTS ' . PMA_backquote($view) . ';' . $crlf; + }
- $create_query .= 'CREATE TABLE '; + $create_query .= 'CREATE TABLE ';
- if (isset($GLOBALS['sql_if_not_exists']) && $GLOBALS['sql_if_not_exists']) { - $create_query .= 'IF NOT EXISTS '; - } - $create_query .= PMA_backquote($view) . ' (' . $crlf; - $tmp = array(); - $columns = PMA_DBI_get_columns_full($db, $view); - foreach ($columns as $column_name => $definition) { - $tmp[] = PMA_backquote($column_name) . ' ' . $definition['Type'] . $crlf; + if (isset($GLOBALS['sql_if_not_exists']) && $GLOBALS['sql_if_not_exists']) { + $create_query .= 'IF NOT EXISTS '; + } + $create_query .= PMA_backquote($view) . ' (' . $crlf; + $tmp = array(); + $columns = PMA_DBI_get_columns_full($db, $view); + foreach ($columns as $column_name => $definition) { + $tmp[] = PMA_backquote($column_name) . ' ' . $definition['Type'] . $crlf; + } + $create_query .= implode(',', $tmp) . ');'; + return($create_query); } - $create_query .= implode(',', $tmp) . ');'; - return($create_query); -}
-/** - * Returns $table's CREATE definition - * - * @param string $db the database name - * @param string $table the table name - * @param string $crlf the end of line sequence - * @param string $error_url the url to go back in case of error - * @param bool $show_dates whether to include creation/update/check dates - * @param bool $add_semicolon whether to add semicolon and end-of-line at the end - * @param bool $view whether we're handling a view - * @return string resulting schema - * - * @access public - */ -function PMA_getTableDef($db, $table, $crlf, $error_url, $show_dates = false, $add_semicolon = true, $view = false) -{ - global $sql_drop_table; - global $sql_backquotes; - global $sql_constraints_query; // just the text of the query - global $sql_drop_foreign_keys; - - $schema_create = ''; - $auto_increment = ''; - $new_crlf = $crlf; - - // need to use PMA_DBI_QUERY_STORE with PMA_DBI_num_rows() in mysqli - $result = PMA_DBI_query('SHOW TABLE STATUS FROM ' . PMA_backquote($db) . ' LIKE '' . PMA_sqlAddSlashes($table, true) . ''', null, PMA_DBI_QUERY_STORE); - if ($result != false) { - if (PMA_DBI_num_rows($result) > 0) { - $tmpres = PMA_DBI_fetch_assoc($result); - // Here we optionally add the AUTO_INCREMENT next value, - // but starting with MySQL 5.0.24, the clause is already included - // in SHOW CREATE TABLE so we'll remove it below - if (isset($GLOBALS['sql_auto_increment']) && !empty($tmpres['Auto_increment'])) { - $auto_increment .= ' AUTO_INCREMENT=' . $tmpres['Auto_increment'] . ' '; - } + /** + * Returns $table's CREATE definition + * + * @param string $db the database name + * @param string $table the table name + * @param string $crlf the end of line sequence + * @param string $error_url the url to go back in case of error + * @param bool $show_dates whether to include creation/update/check dates + * @param bool $add_semicolon whether to add semicolon and end-of-line at the end + * @param bool $view whether we're handling a view + * @return string resulting schema + * + * @access public + */ + function PMA_getTableDef($db, $table, $crlf, $error_url, $show_dates = false, $add_semicolon = true, $view = false) + { + global $sql_drop_table; + global $sql_backquotes; + global $sql_constraints_query; // just the text of the query + global $sql_drop_foreign_keys; + + $schema_create = ''; + $auto_increment = ''; + $new_crlf = $crlf; + + // need to use PMA_DBI_QUERY_STORE with PMA_DBI_num_rows() in mysqli + $result = PMA_DBI_query('SHOW TABLE STATUS FROM ' . PMA_backquote($db) . ' LIKE '' . PMA_sqlAddSlashes($table, true) . ''', null, PMA_DBI_QUERY_STORE); + if ($result != false) { + if (PMA_DBI_num_rows($result) > 0) { + $tmpres = PMA_DBI_fetch_assoc($result); + // Here we optionally add the AUTO_INCREMENT next value, + // but starting with MySQL 5.0.24, the clause is already included + // in SHOW CREATE TABLE so we'll remove it below + if (isset($GLOBALS['sql_auto_increment']) && !empty($tmpres['Auto_increment'])) { + $auto_increment .= ' AUTO_INCREMENT=' . $tmpres['Auto_increment'] . ' '; + }
- if ($show_dates && isset($tmpres['Create_time']) && !empty($tmpres['Create_time'])) { - $schema_create .= PMA_exportComment(__('Creation') . ': ' . PMA_localisedDate(strtotime($tmpres['Create_time']))); - $new_crlf = PMA_exportComment() . $crlf; - } + if ($show_dates && isset($tmpres['Create_time']) && !empty($tmpres['Create_time'])) { + $schema_create .= PMA_exportComment(__('Creation') . ': ' . PMA_localisedDate(strtotime($tmpres['Create_time']))); + $new_crlf = PMA_exportComment() . $crlf; + }
- if ($show_dates && isset($tmpres['Update_time']) && !empty($tmpres['Update_time'])) { - $schema_create .= PMA_exportComment(__('Last update') . ': ' . PMA_localisedDate(strtotime($tmpres['Update_time']))); - $new_crlf = PMA_exportComment() . $crlf; - } + if ($show_dates && isset($tmpres['Update_time']) && !empty($tmpres['Update_time'])) { + $schema_create .= PMA_exportComment(__('Last update') . ': ' . PMA_localisedDate(strtotime($tmpres['Update_time']))); + $new_crlf = PMA_exportComment() . $crlf; + }
- if ($show_dates && isset($tmpres['Check_time']) && !empty($tmpres['Check_time'])) { - $schema_create .= PMA_exportComment(__('Last check') . ': ' . PMA_localisedDate(strtotime($tmpres['Check_time']))); - $new_crlf = PMA_exportComment() . $crlf; + if ($show_dates && isset($tmpres['Check_time']) && !empty($tmpres['Check_time'])) { + $schema_create .= PMA_exportComment(__('Last check') . ': ' . PMA_localisedDate(strtotime($tmpres['Check_time']))); + $new_crlf = PMA_exportComment() . $crlf; + } } + PMA_DBI_free_result($result); } - PMA_DBI_free_result($result); - } - - $schema_create .= $new_crlf; - - // no need to generate a DROP VIEW here, it was done earlier - if (! empty($sql_drop_table) && ! PMA_Table::isView($db,$table)) { - $schema_create .= 'DROP TABLE IF EXISTS ' . PMA_backquote($table, $sql_backquotes) . ';' . $crlf; - }
- // Complete table dump, - // Whether to quote table and fields names or not - if ($sql_backquotes) { - PMA_DBI_query('SET SQL_QUOTE_SHOW_CREATE = 1'); - } else { - PMA_DBI_query('SET SQL_QUOTE_SHOW_CREATE = 0'); - } + $schema_create .= $new_crlf;
- // I don't see the reason why this unbuffered query could cause problems, - // because SHOW CREATE TABLE returns only one row, and we free the - // results below. Nonetheless, we got 2 user reports about this - // (see bug 1562533) so I remove the unbuffered mode. - //$result = PMA_DBI_query('SHOW CREATE TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table), null, PMA_DBI_QUERY_UNBUFFERED); - // - // Note: SHOW CREATE TABLE, at least in MySQL 5.1.23, does not - // produce a displayable result for the default value of a BIT - // field, nor does the mysqldump command. See MySQL bug 35796 - $result = PMA_DBI_try_query('SHOW CREATE TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table)); - // an error can happen, for example the table is crashed - $tmp_error = PMA_DBI_getError(); - if ($tmp_error) { - return PMA_exportComment(__('in use') . '(' . $tmp_error . ')'); - } - - if ($result != false && ($row = PMA_DBI_fetch_row($result))) { - $create_query = $row[1]; - unset($row); - - // Convert end of line chars to one that we want (note that MySQL doesn't return query it will accept in all cases) - if (strpos($create_query, "(\r\n ")) { - $create_query = str_replace("\r\n", $crlf, $create_query); - } elseif (strpos($create_query, "(\n ")) { - $create_query = str_replace("\n", $crlf, $create_query); - } elseif (strpos($create_query, "(\r ")) { - $create_query = str_replace("\r", $crlf, $create_query); + // no need to generate a DROP VIEW here, it was done earlier + if (! empty($sql_drop_table) && ! PMA_Table::isView($db,$table)) { + $schema_create .= 'DROP TABLE IF EXISTS ' . PMA_backquote($table, $sql_backquotes) . ';' . $crlf; }
- /* - * Drop database name from VIEW creation. - * - * This is a bit tricky, but we need to issue SHOW CREATE TABLE with - * database name, but we don't want name to show up in CREATE VIEW - * statement. - */ - if ($view) { - $create_query = preg_replace('/' . PMA_backquote($db) . './', '', $create_query); + // Complete table dump, + // Whether to quote table and fields names or not + if ($sql_backquotes) { + PMA_DBI_query('SET SQL_QUOTE_SHOW_CREATE = 1'); + } else { + PMA_DBI_query('SET SQL_QUOTE_SHOW_CREATE = 0'); }
- // Should we use IF NOT EXISTS? - if (isset($GLOBALS['sql_if_not_exists'])) { - $create_query = preg_replace('/^CREATE TABLE/', 'CREATE TABLE IF NOT EXISTS', $create_query); + // I don't see the reason why this unbuffered query could cause problems, + // because SHOW CREATE TABLE returns only one row, and we free the + // results below. Nonetheless, we got 2 user reports about this + // (see bug 1562533) so I remove the unbuffered mode. + //$result = PMA_DBI_query('SHOW CREATE TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table), null, PMA_DBI_QUERY_UNBUFFERED); + // + // Note: SHOW CREATE TABLE, at least in MySQL 5.1.23, does not + // produce a displayable result for the default value of a BIT + // field, nor does the mysqldump command. See MySQL bug 35796 + $result = PMA_DBI_try_query('SHOW CREATE TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table)); + // an error can happen, for example the table is crashed + $tmp_error = PMA_DBI_getError(); + if ($tmp_error) { + return PMA_exportComment(__('in use') . '(' . $tmp_error . ')'); }
- // are there any constraints to cut out? - if (preg_match('@CONSTRAINT|FOREIGN[\s]+KEY@', $create_query)) { + if ($result != false && ($row = PMA_DBI_fetch_row($result))) { + $create_query = $row[1]; + unset($row); + + // Convert end of line chars to one that we want (note that MySQL doesn't return query it will accept in all cases) + if (strpos($create_query, "(\r\n ")) { + $create_query = str_replace("\r\n", $crlf, $create_query); + } elseif (strpos($create_query, "(\n ")) { + $create_query = str_replace("\n", $crlf, $create_query); + } elseif (strpos($create_query, "(\r ")) { + $create_query = str_replace("\r", $crlf, $create_query); + }
- // Split the query into lines, so we can easily handle it. We know lines are separated by $crlf (done few lines above). - $sql_lines = explode($crlf, $create_query); - $sql_count = count($sql_lines); + /* + * Drop database name from VIEW creation. + * + * This is a bit tricky, but we need to issue SHOW CREATE TABLE with + * database name, but we don't want name to show up in CREATE VIEW + * statement. + */ + if ($view) { + $create_query = preg_replace('/' . PMA_backquote($db) . './', '', $create_query); + }
- // lets find first line with constraints - for ($i = 0; $i < $sql_count; $i++) { - if (preg_match('@^[\s]*(CONSTRAINT|FOREIGN[\s]+KEY)@', $sql_lines[$i])) { - break; - } + // Should we use IF NOT EXISTS? + if (isset($GLOBALS['sql_if_not_exists'])) { + $create_query = preg_replace('/^CREATE TABLE/', 'CREATE TABLE IF NOT EXISTS', $create_query); }
- // If we really found a constraint - if ($i != $sql_count) { + // are there any constraints to cut out? + if (preg_match('@CONSTRAINT|FOREIGN[\s]+KEY@', $create_query)) {
- // remove , from the end of create statement - $sql_lines[$i - 1] = preg_replace('@,$@', '', $sql_lines[$i - 1]); + // Split the query into lines, so we can easily handle it. We know lines are separated by $crlf (done few lines above). + $sql_lines = explode($crlf, $create_query); + $sql_count = count($sql_lines);
- // prepare variable for constraints - if (!isset($sql_constraints)) { - if (isset($GLOBALS['no_constraints_comments'])) { - $sql_constraints = ''; - } else { - $sql_constraints = $crlf - . PMA_exportComment() - . PMA_exportComment(__('Constraints for dumped tables')) - . PMA_exportComment(); + // lets find first line with constraints + for ($i = 0; $i < $sql_count; $i++) { + if (preg_match('@^[\s]*(CONSTRAINT|FOREIGN[\s]+KEY)@', $sql_lines[$i])) { + break; } }
- // comments for current table - if (!isset($GLOBALS['no_constraints_comments'])) { - $sql_constraints .= $crlf - . PMA_exportComment() - . PMA_exportComment(__('Constraints for table') . ' ' . PMA_backquote($table)) - . PMA_exportComment(); - } + // If we really found a constraint + if ($i != $sql_count) {
- // let's do the work - $sql_constraints_query .= 'ALTER TABLE ' . PMA_backquote($table) . $crlf; - $sql_constraints .= 'ALTER TABLE ' . PMA_backquote($table) . $crlf; - $sql_drop_foreign_keys .= 'ALTER TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table) . $crlf; + // remove , from the end of create statement + $sql_lines[$i - 1] = preg_replace('@,$@', '', $sql_lines[$i - 1]);
- $first = true; - for ($j = $i; $j < $sql_count; $j++) { - if (preg_match('@CONSTRAINT|FOREIGN[\s]+KEY@', $sql_lines[$j])) { - if (!$first) { - $sql_constraints .= $crlf; - } - if (strpos($sql_lines[$j], 'CONSTRAINT') === false) { - $tmp_str = preg_replace('/(FOREIGN[\s]+KEY)/', 'ADD \1', $sql_lines[$j]); - $sql_constraints_query .= $tmp_str; - $sql_constraints .= $tmp_str; + // prepare variable for constraints + if (!isset($sql_constraints)) { + if (isset($GLOBALS['no_constraints_comments'])) { + $sql_constraints = ''; } else { - $tmp_str = preg_replace('/(CONSTRAINT)/', 'ADD \1', $sql_lines[$j]); - $sql_constraints_query .= $tmp_str; - $sql_constraints .= $tmp_str; - preg_match('/(CONSTRAINT)([\s])([\S]*)([\s])/', $sql_lines[$j], $matches); - if (! $first) { - $sql_drop_foreign_keys .= ', '; + $sql_constraints = $crlf + . PMA_exportComment() + . PMA_exportComment(__('Constraints for dumped tables')) + . PMA_exportComment(); + } + } + + // comments for current table + if (!isset($GLOBALS['no_constraints_comments'])) { + $sql_constraints .= $crlf + . PMA_exportComment() + . PMA_exportComment(__('Constraints for table') . ' ' . PMA_backquote($table)) + . PMA_exportComment(); + } + + // let's do the work + $sql_constraints_query .= 'ALTER TABLE ' . PMA_backquote($table) . $crlf; + $sql_constraints .= 'ALTER TABLE ' . PMA_backquote($table) . $crlf; + $sql_drop_foreign_keys .= 'ALTER TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table) . $crlf; + + $first = true; + for ($j = $i; $j < $sql_count; $j++) { + if (preg_match('@CONSTRAINT|FOREIGN[\s]+KEY@', $sql_lines[$j])) { + if (!$first) { + $sql_constraints .= $crlf; } - $sql_drop_foreign_keys .= 'DROP FOREIGN KEY ' . $matches[3]; + if (strpos($sql_lines[$j], 'CONSTRAINT') === false) { + $tmp_str = preg_replace('/(FOREIGN[\s]+KEY)/', 'ADD \1', $sql_lines[$j]); + $sql_constraints_query .= $tmp_str; + $sql_constraints .= $tmp_str; + } else { + $tmp_str = preg_replace('/(CONSTRAINT)/', 'ADD \1', $sql_lines[$j]); + $sql_constraints_query .= $tmp_str; + $sql_constraints .= $tmp_str; + preg_match('/(CONSTRAINT)([\s])([\S]*)([\s])/', $sql_lines[$j], $matches); + if (! $first) { + $sql_drop_foreign_keys .= ', '; + } + $sql_drop_foreign_keys .= 'DROP FOREIGN KEY ' . $matches[3]; + } + $first = false; + } else { + break; } - $first = false; - } else { - break; } - } - $sql_constraints .= ';' . $crlf; - $sql_constraints_query .= ';'; + $sql_constraints .= ';' . $crlf; + $sql_constraints_query .= ';';
- $create_query = implode($crlf, array_slice($sql_lines, 0, $i)) . $crlf . implode($crlf, array_slice($sql_lines, $j, $sql_count - 1)); - unset($sql_lines); + $create_query = implode($crlf, array_slice($sql_lines, 0, $i)) . $crlf . implode($crlf, array_slice($sql_lines, $j, $sql_count - 1)); + unset($sql_lines); + } } + $schema_create .= $create_query; } - $schema_create .= $create_query; - }
- // remove a possible "AUTO_INCREMENT = value" clause - // that could be there starting with MySQL 5.0.24 - $schema_create = preg_replace('/AUTO_INCREMENT\s*=\s*([0-9])+/', '', $schema_create); + // remove a possible "AUTO_INCREMENT = value" clause + // that could be there starting with MySQL 5.0.24 + $schema_create = preg_replace('/AUTO_INCREMENT\s*=\s*([0-9])+/', '', $schema_create);
- $schema_create .= $auto_increment; + $schema_create .= $auto_increment;
- PMA_DBI_free_result($result); - return $schema_create . ($add_semicolon ? ';' . $crlf : ''); -} // end of the 'PMA_getTableDef()' function - -/** - * Returns $table's comments, relations etc. - * - * @param string $db database name - * @param string $table table name - * @param string $crlf end of line sequence - * @param bool $do_relation whether to include relation comments - * @param bool $do_mime whether to include mime comments - * @return string resulting comments - * - * @access private - */ -function PMA_getTableComments($db, $table, $crlf, $do_relation = false, $do_mime = false) -{ - global $cfgRelation; - global $sql_backquotes; - global $sql_constraints; - - $schema_create = ''; - - // Check if we can use Relations - if ($do_relation && !empty($cfgRelation['relation'])) { - // Find which tables are related with the current one and write it in - // an array - $res_rel = PMA_getForeigners($db, $table); - - if ($res_rel && count($res_rel) > 0) { - $have_rel = true; + PMA_DBI_free_result($result); + return $schema_create . ($add_semicolon ? ';' . $crlf : ''); + } // end of the 'PMA_getTableDef()' function + + /** + * Returns $table's comments, relations etc. + * + * @param string $db database name + * @param string $table table name + * @param string $crlf end of line sequence + * @param bool $do_relation whether to include relation comments + * @param bool $do_mime whether to include mime comments + * @return string resulting comments + * + * @access private + */ + function PMA_getTableComments($db, $table, $crlf, $do_relation = false, $do_mime = false) + { + global $cfgRelation; + global $sql_backquotes; + global $sql_constraints; + + $schema_create = ''; + + // Check if we can use Relations + if ($do_relation && !empty($cfgRelation['relation'])) { + // Find which tables are related with the current one and write it in + // an array + $res_rel = PMA_getForeigners($db, $table); + + if ($res_rel && count($res_rel) > 0) { + $have_rel = true; + } else { + $have_rel = false; + } } else { - $have_rel = false; - } - } else { - $have_rel = false; - } // end if + $have_rel = false; + } // end if
- if ($do_mime && $cfgRelation['mimework']) { - if (!($mime_map = PMA_getMIME($db, $table, true))) { - unset($mime_map); + if ($do_mime && $cfgRelation['mimework']) { + if (!($mime_map = PMA_getMIME($db, $table, true))) { + unset($mime_map); + } } - }
- if (isset($mime_map) && count($mime_map) > 0) { - $schema_create .= PMA_possibleCRLF() - . PMA_exportComment() - . PMA_exportComment(__('MIME TYPES FOR TABLE'). ' ' . PMA_backquote($table, $sql_backquotes) . ':'); - @reset($mime_map); - foreach ($mime_map AS $mime_field => $mime) { - $schema_create .= PMA_exportComment(' ' . PMA_backquote($mime_field, $sql_backquotes)) - . PMA_exportComment(' ' . PMA_backquote($mime['mimetype'], $sql_backquotes)); + if (isset($mime_map) && count($mime_map) > 0) { + $schema_create .= PMA_possibleCRLF() + . PMA_exportComment() + . PMA_exportComment(__('MIME TYPES FOR TABLE'). ' ' . PMA_backquote($table, $sql_backquotes) . ':'); + @reset($mime_map); + foreach ($mime_map AS $mime_field => $mime) { + $schema_create .= PMA_exportComment(' ' . PMA_backquote($mime_field, $sql_backquotes)) + . PMA_exportComment(' ' . PMA_backquote($mime['mimetype'], $sql_backquotes)); + } + $schema_create .= PMA_exportComment(); } - $schema_create .= PMA_exportComment(); - }
- if ($have_rel) { - $schema_create .= PMA_possibleCRLF() - . PMA_exportComment() - . PMA_exportComment(__('RELATIONS FOR TABLE'). ' ' . PMA_backquote($table, $sql_backquotes) . ':'); - foreach ($res_rel AS $rel_field => $rel) { - $schema_create .= PMA_exportComment(' ' . PMA_backquote($rel_field, $sql_backquotes)) - . PMA_exportComment(' ' . PMA_backquote($rel['foreign_table'], $sql_backquotes) - . ' -> ' . PMA_backquote($rel['foreign_field'], $sql_backquotes)); + if ($have_rel) { + $schema_create .= PMA_possibleCRLF() + . PMA_exportComment() + . PMA_exportComment(__('RELATIONS FOR TABLE'). ' ' . PMA_backquote($table, $sql_backquotes) . ':'); + foreach ($res_rel AS $rel_field => $rel) { + $schema_create .= PMA_exportComment(' ' . PMA_backquote($rel_field, $sql_backquotes)) + . PMA_exportComment(' ' . PMA_backquote($rel['foreign_table'], $sql_backquotes) + . ' -> ' . PMA_backquote($rel['foreign_field'], $sql_backquotes)); + } + $schema_create .= PMA_exportComment(); } - $schema_create .= PMA_exportComment(); - } - - return $schema_create;
-} // end of the 'PMA_getTableComments()' function + return $schema_create; + + } // end of the 'PMA_getTableComments()' function + + /** + * Outputs table's structure + * + * @param string $db database name + * @param string $table table name + * @param string $crlf the end of line sequence + * @param string $error_url the url to go back in case of error + * @param bool $relation whether to include relation comments + * @param bool $comments whether to include the pmadb-style column comments + * as comments in the structure; this is deprecated + * but the parameter is left here because export.php + * calls PMA_exportStructure() also for other export + * types which use this parameter + * @param bool $mime whether to include mime comments + * @param bool $dates whether to include creation/update/check dates + * @param string $export_mode 'create_table', 'triggers', 'create_view', 'stand_in' + * @param string $export_type 'server', 'database', 'table' + * @return bool Whether it suceeded + * + * @access public + */ + function PMA_exportStructure($db, $table, $crlf, $error_url, $relation = false, $comments = false, $mime = false, $dates = false, $export_mode, $export_type) + { + $formatted_table_name = (isset($GLOBALS['sql_backquotes'])) + ? PMA_backquote($table) + : ''' . $table . '''; + $dump = PMA_possibleCRLF() + . PMA_exportComment(str_repeat('-', 56)) + . PMA_possibleCRLF() + . PMA_exportComment();
-/** - * Outputs table's structure - * - * @param string $db database name - * @param string $table table name - * @param string $crlf the end of line sequence - * @param string $error_url the url to go back in case of error - * @param bool $relation whether to include relation comments - * @param bool $comments whether to include the pmadb-style column comments - * as comments in the structure; this is deprecated - * but the parameter is left here because export.php - * calls PMA_exportStructure() also for other export - * types which use this parameter - * @param bool $mime whether to include mime comments - * @param bool $dates whether to include creation/update/check dates - * @param string $export_mode 'create_table', 'triggers', 'create_view', 'stand_in' - * @param string $export_type 'server', 'database', 'table' - * @return bool Whether it suceeded - * - * @access public - */ -function PMA_exportStructure($db, $table, $crlf, $error_url, $relation = false, $comments = false, $mime = false, $dates = false, $export_mode, $export_type) -{ - $formatted_table_name = (isset($GLOBALS['sql_backquotes'])) - ? PMA_backquote($table) - : ''' . $table . '''; - $dump = PMA_possibleCRLF() - . PMA_exportComment(str_repeat('-', 56)) - . PMA_possibleCRLF() - . PMA_exportComment(); - - switch($export_mode) { - case 'create_table': - $dump .= PMA_exportComment(__('Table structure for table') . ' ' . $formatted_table_name); - $dump .= PMA_exportComment(); - $dump .= PMA_getTableDef($db, $table, $crlf, $error_url, $dates); - $dump .= PMA_getTableComments($db, $table, $crlf, $relation, $mime); - break; - case 'triggers': - $dump = ''; - $triggers = PMA_DBI_get_triggers($db, $table); - if ($triggers) { - $dump .= PMA_possibleCRLF() - . PMA_exportComment() - . PMA_exportComment(__('Triggers') . ' ' . $formatted_table_name) - . PMA_exportComment(); - $delimiter = '//'; - foreach ($triggers as $trigger) { - $dump .= $trigger['drop'] . ';' . $crlf; - $dump .= 'DELIMITER ' . $delimiter . $crlf; - $dump .= $trigger['create']; - $dump .= 'DELIMITER ;' . $crlf; + switch($export_mode) { + case 'create_table': + $dump .= PMA_exportComment(__('Table structure for table') . ' ' . $formatted_table_name); + $dump .= PMA_exportComment(); + $dump .= PMA_getTableDef($db, $table, $crlf, $error_url, $dates); + $dump .= PMA_getTableComments($db, $table, $crlf, $relation, $mime); + break; + case 'triggers': + $dump = ''; + $triggers = PMA_DBI_get_triggers($db, $table); + if ($triggers) { + $dump .= PMA_possibleCRLF() + . PMA_exportComment() + . PMA_exportComment(__('Triggers') . ' ' . $formatted_table_name) + . PMA_exportComment(); + $delimiter = '//'; + foreach ($triggers as $trigger) { + $dump .= $trigger['drop'] . ';' . $crlf; + $dump .= 'DELIMITER ' . $delimiter . $crlf; + $dump .= $trigger['create']; + $dump .= 'DELIMITER ;' . $crlf; + } } - } - break; - case 'create_view': - $dump .= PMA_exportComment(__('Structure for view') . ' ' . $formatted_table_name) - . PMA_exportComment(); - // delete the stand-in table previously created (if any) - if ($export_type != 'table') { - $dump .= 'DROP TABLE IF EXISTS ' . PMA_backquote($table) . ';' . $crlf; - } - $dump .= PMA_getTableDef($db, $table, $crlf, $error_url, $dates, true, true); - break; - case 'stand_in': - $dump .= PMA_exportComment(__('Stand-in structure for view') . ' ' . $formatted_table_name) - . PMA_exportComment(); - // export a stand-in definition to resolve view dependencies - $dump .= PMA_getTableDefStandIn($db, $table, $crlf); - } // end switch - - // this one is built by PMA_getTableDef() to use in table copy/move - // but not in the case of export - unset($GLOBALS['sql_constraints_query']); - - return PMA_exportOutputHandler($dump); -} - -/** - * Outputs the content of a table in SQL format - * - * @param string $db database name - * @param string $table table name - * @param string $crlf the end of line sequence - * @param string $error_url the url to go back in case of error - * @param string $sql_query SQL query for obtaining data - * @return bool Whether it suceeded - * - * @access public - */ -function PMA_exportData($db, $table, $crlf, $error_url, $sql_query) -{ - global $sql_backquotes; - global $current_row; - - $formatted_table_name = (isset($GLOBALS['sql_backquotes'])) - ? PMA_backquote($table) - : ''' . $table . '''; - - // Do not export data for a VIEW - // (For a VIEW, this is called only when exporting a single VIEW) - if (PMA_Table::isView($db, $table)) { - $head = PMA_possibleCRLF() - . PMA_exportComment() - . PMA_exportComment('VIEW ' . ' ' . $formatted_table_name) - . PMA_exportComment(__('Data') . ': ' . __('None')) - . PMA_exportComment() - . PMA_possibleCRLF(); - - if (! PMA_exportOutputHandler($head)) { - return false; - } - return true; - } + break; + case 'create_view': + $dump .= PMA_exportComment(__('Structure for view') . ' ' . $formatted_table_name) + . PMA_exportComment(); + // delete the stand-in table previously created (if any) + if ($export_type != 'table') { + $dump .= 'DROP TABLE IF EXISTS ' . PMA_backquote($table) . ';' . $crlf; + } + $dump .= PMA_getTableDef($db, $table, $crlf, $error_url, $dates, true, true); + break; + case 'stand_in': + $dump .= PMA_exportComment(__('Stand-in structure for view') . ' ' . $formatted_table_name) + . PMA_exportComment(); + // export a stand-in definition to resolve view dependencies + $dump .= PMA_getTableDefStandIn($db, $table, $crlf); + } // end switch
- // analyze the query to get the true column names, not the aliases - // (this fixes an undefined index, also if Complete inserts - // are used, we did not get the true column name in case of aliases) - $analyzed_sql = PMA_SQP_analyze(PMA_SQP_parse($sql_query)); + // this one is built by PMA_getTableDef() to use in table copy/move + // but not in the case of export + unset($GLOBALS['sql_constraints_query']);
- $result = PMA_DBI_try_query($sql_query, null, PMA_DBI_QUERY_UNBUFFERED); - // a possible error: the table has crashed - $tmp_error = PMA_DBI_getError(); - if ($tmp_error) { - return PMA_exportOutputHandler(PMA_exportComment(__('in use') . ' (' . $tmp_error . ')')); + return PMA_exportOutputHandler($dump); }
- if ($result != false) { - $fields_cnt = PMA_DBI_num_fields($result); - - // Get field information - $fields_meta = PMA_DBI_get_fields_meta($result); - $field_flags = array(); - for ($j = 0; $j < $fields_cnt; $j++) { - $field_flags[$j] = PMA_DBI_field_flags($result, $j); + /** + * Outputs the content of a table in SQL format + * + * @param string $db database name + * @param string $table table name + * @param string $crlf the end of line sequence + * @param string $error_url the url to go back in case of error + * @param string $sql_query SQL query for obtaining data + * @return bool Whether it suceeded + * + * @access public + */ + function PMA_exportData($db, $table, $crlf, $error_url, $sql_query) + { + global $sql_backquotes; + global $current_row; + + $formatted_table_name = (isset($GLOBALS['sql_backquotes'])) + ? PMA_backquote($table) + : ''' . $table . '''; + + // Do not export data for a VIEW + // (For a VIEW, this is called only when exporting a single VIEW) + if (PMA_Table::isView($db, $table)) { + $head = PMA_possibleCRLF() + . PMA_exportComment() + . PMA_exportComment('VIEW ' . ' ' . $formatted_table_name) + . PMA_exportComment(__('Data') . ': ' . __('None')) + . PMA_exportComment() + . PMA_possibleCRLF(); + + if (! PMA_exportOutputHandler($head)) { + return false; + } + return true; }
- for ($j = 0; $j < $fields_cnt; $j++) { - if (isset($analyzed_sql[0]['select_expr'][$j]['column'])) { - $field_set[$j] = PMA_backquote($analyzed_sql[0]['select_expr'][$j]['column'], $sql_backquotes); - } else { - $field_set[$j] = PMA_backquote($fields_meta[$j]->name, $sql_backquotes); - } + // analyze the query to get the true column names, not the aliases + // (this fixes an undefined index, also if Complete inserts + // are used, we did not get the true column name in case of aliases) + $analyzed_sql = PMA_SQP_analyze(PMA_SQP_parse($sql_query)); + + $result = PMA_DBI_try_query($sql_query, null, PMA_DBI_QUERY_UNBUFFERED); + // a possible error: the table has crashed + $tmp_error = PMA_DBI_getError(); + if ($tmp_error) { + return PMA_exportOutputHandler(PMA_exportComment(__('in use') . ' (' . $tmp_error . ')')); }
- if (isset($GLOBALS['sql_type']) && $GLOBALS['sql_type'] == 'UPDATE') { - // update - $schema_insert = 'UPDATE '; - if (isset($GLOBALS['sql_ignore'])) { - $schema_insert .= 'IGNORE '; + if ($result != false) { + $fields_cnt = PMA_DBI_num_fields($result); + + // Get field information + $fields_meta = PMA_DBI_get_fields_meta($result); + $field_flags = array(); + for ($j = 0; $j < $fields_cnt; $j++) { + $field_flags[$j] = PMA_DBI_field_flags($result, $j); } - // avoid EOL blank - $schema_insert .= PMA_backquote($table, $sql_backquotes) . ' SET'; - } else { - // insert or replace - if (isset($GLOBALS['sql_type']) && $GLOBALS['sql_type'] == 'REPLACE') { - $sql_command = 'REPLACE'; - } else { - $sql_command = 'INSERT'; + + for ($j = 0; $j < $fields_cnt; $j++) { + if (isset($analyzed_sql[0]['select_expr'][$j]['column'])) { + $field_set[$j] = PMA_backquote($analyzed_sql[0]['select_expr'][$j]['column'], $sql_backquotes); + } else { + $field_set[$j] = PMA_backquote($fields_meta[$j]->name, $sql_backquotes); + } }
- // delayed inserts? - if (isset($GLOBALS['sql_delayed'])) { - $insert_delayed = ' DELAYED'; + if (isset($GLOBALS['sql_type']) && $GLOBALS['sql_type'] == 'UPDATE') { + // update + $schema_insert = 'UPDATE '; + if (isset($GLOBALS['sql_ignore'])) { + $schema_insert .= 'IGNORE '; + } + // avoid EOL blank + $schema_insert .= PMA_backquote($table, $sql_backquotes) . ' SET'; } else { - $insert_delayed = ''; - } + // insert or replace + if (isset($GLOBALS['sql_type']) && $GLOBALS['sql_type'] == 'REPLACE') { + $sql_command = 'REPLACE'; + } else { + $sql_command = 'INSERT'; + } + + // delayed inserts? + if (isset($GLOBALS['sql_delayed'])) { + $insert_delayed = ' DELAYED'; + } else { + $insert_delayed = ''; + }
- // insert ignore? - if (isset($GLOBALS['sql_type']) && $GLOBALS['sql_type'] == 'INSERT' && isset($GLOBALS['sql_ignore'])) { - $insert_delayed .= ' IGNORE'; + // insert ignore? + if (isset($GLOBALS['sql_type']) && $GLOBALS['sql_type'] == 'INSERT' && isset($GLOBALS['sql_ignore'])) { + $insert_delayed .= ' IGNORE'; + } + + // scheme for inserting fields + if ($GLOBALS['sql_insert_syntax'] == 'complete' || $GLOBALS['sql_insert_syntax'] == 'both') { + $fields = implode(', ', $field_set); + $schema_insert = $sql_command . $insert_delayed .' INTO ' . PMA_backquote($table, $sql_backquotes) + // avoid EOL blank + . ' (' . $fields . ') VALUES'; + } else { + $schema_insert = $sql_command . $insert_delayed .' INTO ' . PMA_backquote($table, $sql_backquotes) + . ' VALUES'; + } }
- // scheme for inserting fields - if ($GLOBALS['sql_insert_syntax'] == 'complete' || $GLOBALS['sql_insert_syntax'] == 'both') { - $fields = implode(', ', $field_set); - $schema_insert = $sql_command . $insert_delayed .' INTO ' . PMA_backquote($table, $sql_backquotes) - // avoid EOL blank - . ' (' . $fields . ') VALUES'; + $search = array("\x00", "\x0a", "\x0d", "\x1a"); //\x08\x09, not required + $replace = array('\0', '\n', '\r', '\Z'); + $current_row = 0; + $query_size = 0; + if (($GLOBALS['sql_insert_syntax'] == 'extended' || $GLOBALS['sql_insert_syntax'] == 'both') && (!isset($GLOBALS['sql_type']) || $GLOBALS['sql_type'] != 'UPDATE')) { + $separator = ','; + $schema_insert .= $crlf; } else { - $schema_insert = $sql_command . $insert_delayed .' INTO ' . PMA_backquote($table, $sql_backquotes) - . ' VALUES'; + $separator = ';'; } - }
- $search = array("\x00", "\x0a", "\x0d", "\x1a"); //\x08\x09, not required - $replace = array('\0', '\n', '\r', '\Z'); - $current_row = 0; - $query_size = 0; - if (($GLOBALS['sql_insert_syntax'] == 'extended' || $GLOBALS['sql_insert_syntax'] == 'both') && (!isset($GLOBALS['sql_type']) || $GLOBALS['sql_type'] != 'UPDATE')) { - $separator = ','; - $schema_insert .= $crlf; - } else { - $separator = ';'; - } - - while ($row = PMA_DBI_fetch_row($result)) { - if ($current_row == 0) { - $head = PMA_possibleCRLF() - . PMA_exportComment() - . PMA_exportComment(__('Dumping data for table') . ' ' . $formatted_table_name) - . PMA_exportComment() - . $crlf; - if (! PMA_exportOutputHandler($head)) { - return false; + while ($row = PMA_DBI_fetch_row($result)) { + if ($current_row == 0) { + $head = PMA_possibleCRLF() + . PMA_exportComment() + . PMA_exportComment(__('Dumping data for table') . ' ' . $formatted_table_name) + . PMA_exportComment() + . $crlf; + if (! PMA_exportOutputHandler($head)) { + return false; + } } - } - $current_row++; - for ($j = 0; $j < $fields_cnt; $j++) { - // NULL - if (!isset($row[$j]) || is_null($row[$j])) { - $values[] = 'NULL'; - // a number - // timestamp is numeric on some MySQL 4.1, BLOBs are sometimes numeric - } elseif ($fields_meta[$j]->numeric && $fields_meta[$j]->type != 'timestamp' - && ! $fields_meta[$j]->blob) { - $values[] = $row[$j]; - // a true BLOB - // - mysqldump only generates hex data when the --hex-blob - // option is used, for fields having the binary attribute - // no hex is generated - // - a TEXT field returns type blob but a real blob - // returns also the 'binary' flag - } elseif (stristr($field_flags[$j], 'BINARY') - && $fields_meta[$j]->blob - && isset($GLOBALS['sql_hex_for_blob'])) { - // empty blobs need to be different, but '0' is also empty :-( - if (empty($row[$j]) && $row[$j] != '0') { - $values[] = ''''; + $current_row++; + for ($j = 0; $j < $fields_cnt; $j++) { + // NULL + if (!isset($row[$j]) || is_null($row[$j])) { + $values[] = 'NULL'; + // a number + // timestamp is numeric on some MySQL 4.1, BLOBs are sometimes numeric + } elseif ($fields_meta[$j]->numeric && $fields_meta[$j]->type != 'timestamp' + && ! $fields_meta[$j]->blob) { + $values[] = $row[$j]; + // a true BLOB + // - mysqldump only generates hex data when the --hex-blob + // option is used, for fields having the binary attribute + // no hex is generated + // - a TEXT field returns type blob but a real blob + // returns also the 'binary' flag + } elseif (stristr($field_flags[$j], 'BINARY') + && $fields_meta[$j]->blob + && isset($GLOBALS['sql_hex_for_blob'])) { + // empty blobs need to be different, but '0' is also empty :-( + if (empty($row[$j]) && $row[$j] != '0') { + $values[] = ''''; + } else { + $values[] = '0x' . bin2hex($row[$j]); + } + // detection of 'bit' works only on mysqli extension + } elseif ($fields_meta[$j]->type == 'bit') { + $values[] = "b'" . PMA_sqlAddSlashes(PMA_printable_bit_value($row[$j], $fields_meta[$j]->length)) . "'"; + // something else -> treat as a string } else { - $values[] = '0x' . bin2hex($row[$j]); - } - // detection of 'bit' works only on mysqli extension - } elseif ($fields_meta[$j]->type == 'bit') { - $values[] = "b'" . PMA_sqlAddSlashes(PMA_printable_bit_value($row[$j], $fields_meta[$j]->length)) . "'"; - // something else -> treat as a string - } else { - $values[] = ''' . str_replace($search, $replace, PMA_sqlAddSlashes($row[$j])) . '''; - } // end if - } // end for + $values[] = ''' . str_replace($search, $replace, PMA_sqlAddSlashes($row[$j])) . '''; + } // end if + } // end for
- // should we make update? - if (isset($GLOBALS['sql_type']) && $GLOBALS['sql_type'] == 'UPDATE') { + // should we make update? + if (isset($GLOBALS['sql_type']) && $GLOBALS['sql_type'] == 'UPDATE') {
- $insert_line = $schema_insert; - for ($i = 0; $i < $fields_cnt; $i++) { - if (0 == $i) { - $insert_line .= ' '; - } - if ($i > 0) { - // avoid EOL blank - $insert_line .= ','; + $insert_line = $schema_insert; + for ($i = 0; $i < $fields_cnt; $i++) { + if (0 == $i) { + $insert_line .= ' '; + } + if ($i > 0) { + // avoid EOL blank + $insert_line .= ','; + } + $insert_line .= $field_set[$i] . ' = ' . $values[$i]; } - $insert_line .= $field_set[$i] . ' = ' . $values[$i]; - }
- list($tmp_unique_condition, $tmp_clause_is_unique) = PMA_getUniqueCondition($result, $fields_cnt, $fields_meta, $row); - $insert_line .= ' WHERE ' . $tmp_unique_condition; - unset($tmp_unique_condition, $tmp_clause_is_unique); + list($tmp_unique_condition, $tmp_clause_is_unique) = PMA_getUniqueCondition($result, $fields_cnt, $fields_meta, $row); + $insert_line .= ' WHERE ' . $tmp_unique_condition; + unset($tmp_unique_condition, $tmp_clause_is_unique);
- } else { + } else {
- // Extended inserts case - if ($GLOBALS['sql_insert_syntax'] == 'extended' || $GLOBALS['sql_insert_syntax'] == 'both') { - if ($current_row == 1) { - $insert_line = $schema_insert . '(' . implode(', ', $values) . ')'; - } else { - $insert_line = '(' . implode(', ', $values) . ')'; - if (isset($GLOBALS['sql_max_query_size']) && $GLOBALS['sql_max_query_size'] > 0 && $query_size + strlen($insert_line) > $GLOBALS['sql_max_query_size']) { - if (!PMA_exportOutputHandler(';' . $crlf)) { - return false; + // Extended inserts case + if ($GLOBALS['sql_insert_syntax'] == 'extended' || $GLOBALS['sql_insert_syntax'] == 'both') { + if ($current_row == 1) { + $insert_line = $schema_insert . '(' . implode(', ', $values) . ')'; + } else { + $insert_line = '(' . implode(', ', $values) . ')'; + if (isset($GLOBALS['sql_max_query_size']) && $GLOBALS['sql_max_query_size'] > 0 && $query_size + strlen($insert_line) > $GLOBALS['sql_max_query_size']) { + if (!PMA_exportOutputHandler(';' . $crlf)) { + return false; + } + $query_size = 0; + $current_row = 1; + $insert_line = $schema_insert . $insert_line; } - $query_size = 0; - $current_row = 1; - $insert_line = $schema_insert . $insert_line; } + $query_size += strlen($insert_line); + } + // Other inserts case + else { + $insert_line = $schema_insert . '(' . implode(', ', $values) . ')'; } - $query_size += strlen($insert_line); - } - // Other inserts case - else { - $insert_line = $schema_insert . '(' . implode(', ', $values) . ')'; } - } - unset($values); + unset($values);
- if (!PMA_exportOutputHandler(($current_row == 1 ? '' : $separator . $crlf) . $insert_line)) { - return false; - } + if (!PMA_exportOutputHandler(($current_row == 1 ? '' : $separator . $crlf) . $insert_line)) { + return false; + }
- } // end while - if ($current_row > 0) { - if (!PMA_exportOutputHandler(';' . $crlf)) { - return false; + } // end while + if ($current_row > 0) { + if (!PMA_exportOutputHandler(';' . $crlf)) { + return false; + } } - } - } // end if ($result != false) - PMA_DBI_free_result($result); + } // end if ($result != false) + PMA_DBI_free_result($result);
- return true; -} // end of the 'PMA_exportData()' function + return true; + } // end of the 'PMA_exportData()' function } ?>
hooks/post-receive