libraries/export/texytext.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Export to Texy! text.
   5  *
   6  * @package phpMyAdmin-Export
   7  * @subpackage Texy
   8  */
   9 if (! defined('PHPMYADMIN')) {
  10     exit;
  11 }
  12
  13 /**
  14  *
  15  */
  16 if (isset($plugin_list)) {
  17     $plugin_list['texytext'] = array(
  18         'text' => __('Texy! text'),
  19         'extension' => 'txt',
  20         'mime_type' => 'text/plain',
  21         'options' => array(
  22         /* what to dump (structure/data/both) */
  23         array('type' => 'begin_group', 'text' => __('Dump table'), 'name' => 'general_opts'),
  24         array('type' => 'radio', 'name' => 'structure_or_data', 'values' => array('structure' => __('structure'), 'data' => __('data'), 'structure_and_data' => __('structure and data'))),
  25         array('type' => 'end_group'),
  26         array('type' => 'begin_group', 'name' => 'data', 'text' => __('Data dump options'), 'force' => 'structure'),
  27         array('type' => 'text', 'name' => 'null', 'text' => __('Replace NULL by')),
  28         array('type' => 'bool', 'name' => 'columns', 'text' => __('Put columns names in the first row')),
  29         array('type' => 'end_group'),
  30         ),
  31         'options_text' => __('Options'),
  32         );
  33 } else {
  34
  35     /**
  36      * Outputs export footer
  37      *
  38      * @return  bool        Whether it suceeded
  39      *
  40      * @access  public
  41      */
  42     function PMA_exportFooter() {
  43         return true;
  44     }
  45
  46     /**
  47      * Outputs export header
  48      *
  49      * @return  bool        Whether it suceeded
  50      *
  51      * @access  public
  52      */
  53     function PMA_exportHeader() {
  54         return true;
  55     }
  56
  57     /**
  58      * Outputs database header
  59      *
  60      * @param string  $db Database name
  61      * @return  bool        Whether it suceeded
  62      *
  63      * @access  public
  64      */
  65     function PMA_exportDBHeader($db) {
  66         return PMA_exportOutputHandler('===' . __('Database') . ' ' . $db . "\n\n");
  67     }
  68
  69     /**
  70      * Outputs database footer
  71      *
  72      * @param string  $db Database name
  73      * @return  bool        Whether it suceeded
  74      *
  75      * @access  public
  76      */
  77     function PMA_exportDBFooter($db) {
  78         return true;
  79     }
  80
  81     /**
  82      * Outputs CREATE DATABASE statement
  83      *
  84      * @param string  $db Database name
  85      * @return  bool        Whether it suceeded
  86      *
  87      * @access  public
  88      */
  89     function PMA_exportDBCreate($db) {
  90         return true;
  91     }
  92
  93     /**
  94      * Outputs the content of a table in Texy format
  95      *
  96      * @param string  $db         database name
  97      * @param string  $table      table name
  98      * @param string  $crlf       the end of line sequence
  99      * @param string  $error_url  the url to go back in case of error
 100      * @param string  $sql_query  SQL query for obtaining data
 101      * @return  bool        Whether it suceeded
 102      *
 103      * @access  public
 104      */
 105     function PMA_exportData($db, $table, $crlf, $error_url, $sql_query)
 106     {
 107         global $what;
 108
 109         if (! PMA_exportOutputHandler('== ' . __('Dumping data for table') . ' ' . $table . "\n\n")) {
 110             return false;
 111         }
 112
 113         // Gets the data from the database
 114         $result      = PMA_DBI_query($sql_query, null, PMA_DBI_QUERY_UNBUFFERED);
 115         $fields_cnt  = PMA_DBI_num_fields($result);
 116
 117         // If required, get fields name at the first line
 118         if (isset($GLOBALS[$what . '_columns'])) {
 119             $text_output = "|------\n";
 120             for ($i = 0; $i < $fields_cnt; $i++) {
 121                 $text_output .= '|' . htmlspecialchars(stripslashes(PMA_DBI_field_name($result, $i)));
 122             } // end for
 123             $text_output .= "\n|------\n";
 124             if (! PMA_exportOutputHandler($text_output)) {
 125                 return false;
 126             }
 127         } // end if
 128
 129         // Format the data
 130         while ($row = PMA_DBI_fetch_row($result)) {
 131             $text_output = '';
 132             for ($j = 0; $j < $fields_cnt; $j++) {
 133                 if (! isset($row[$j]) || is_null($row[$j])) {
 134                     $value = $GLOBALS[$what . '_null'];
 135                 } elseif ($row[$j] == '0' || $row[$j] != '') {
 136                     $value = $row[$j];
 137                 } else {
 138                     $value = ' ';
 139                 }
 140                 $text_output .= '|' . htmlspecialchars($value);
 141             } // end for
 142             $text_output .= "\n";
 143             if (! PMA_exportOutputHandler($text_output)) {
 144                 return false;
 145             }
 146         } // end while
 147         PMA_DBI_free_result($result);
 148
 149         return true;
 150     }
 151
 152     /**
 153      * Outputs table's structure
 154      *
 155      * @param string  $db           database name
 156      * @param string  $table        table name
 157      * @param string  $crlf         the end of line sequence
 158      * @param string  $error_url    the url to go back in case of error
 159      * @param bool    $do_relation  whether to include relation comments
 160      * @param bool    $do_comments  whether to include the pmadb-style column comments
 161      *                                as comments in the structure; this is deprecated
 162      *                                but the parameter is left here because export.php
 163      *                                calls PMA_exportStructure() also for other export
 164      *                                types which use this parameter
 165      * @param bool    $do_mime      whether to include mime comments
 166      * @param bool    $dates        whether to include creation/update/check dates
 167      * @param string  $export_mode  'create_table', 'triggers', 'create_view', 'stand_in'
 168      * @param string  $export_type  'server', 'database', 'table'
 169      * @return  bool      Whether it suceeded
 170      *
 171      * @access  public
 172      */
 173     function PMA_exportStructure($db, $table, $crlf, $error_url, $do_relation = false, $do_comments = false, $do_mime = false, $dates = false, $export_mode, $export_type)
 174     {
 175         global $cfgRelation;
 176
 177         if (! PMA_exportOutputHandler('== ' . __('Table structure for table') . ' ' .$table . "\n\n")) {
 178             return false;
 179         }
 180
 181         /**
 182          * Get the unique keys in the table
 183          */
 184         $unique_keys = array();
 185         $keys        = PMA_DBI_get_table_indexes($db, $table);
 186         foreach ($keys as $key) {
 187             if ($key['Non_unique'] == 0) {
 188                 $unique_keys[] = $key['Column_name'];
 189             }
 190         }
 191
 192         /**
 193          * Gets fields properties
 194          */
 195         PMA_DBI_select_db($db);
 196
 197         // Check if we can use Relations
 198         if ($do_relation && ! empty($cfgRelation['relation'])) {
 199             // Find which tables are related with the current one and write it in
 200             // an array
 201             $res_rel = PMA_getForeigners($db, $table);
 202
 203             if ($res_rel && count($res_rel) > 0) {
 204                 $have_rel = true;
 205             } else {
 206                 $have_rel = false;
 207             }
 208         } else {
 209                $have_rel = false;
 210         } // end if
 211
 212         /**
 213          * Displays the table structure
 214          */
 215
 216         $columns_cnt = 4;
 217         if ($do_relation && $have_rel) {
 218             $columns_cnt++;
 219         }
 220         if ($do_comments && $cfgRelation['commwork']) {
 221             $columns_cnt++;
 222         }
 223         if ($do_mime && $cfgRelation['mimework']) {
 224             $columns_cnt++;
 225         }
 226
 227         $text_output = "|------\n";
 228         $text_output .= '|' . __('Column');
 229         $text_output .= '|' . __('Type');
 230         $text_output .= '|' . __('Null');
 231         $text_output .= '|' . __('Default');
 232         if ($do_relation && $have_rel) {
 233             $text_output .= '|' . __('Links to');
 234         }
 235         if ($do_comments) {
 236             $text_output .= '|' . __('Comments');
 237             $comments = PMA_getComments($db, $table);
 238         }
 239         if ($do_mime && $cfgRelation['mimework']) {
 240             $text_output .= '|' . htmlspecialchars('MIME');
 241             $mime_map = PMA_getMIME($db, $table, true);
 242         }
 243         $text_output .= "\n|------\n";
 244
 245         if (! PMA_exportOutputHandler($text_output)) {
 246             return false;
 247         }
 248
 249         $columns = PMA_DBI_get_columns($db, $table);
 250         foreach ($columns as $column) {
 251
 252             $text_output = '';
 253
 254             $extracted_fieldspec = PMA_extractFieldSpec($column['Type']);
 255             $type = $extracted_fieldspec['print_type'];
 256             if (empty($type)) {
 257                 $type     = '&nbsp;';
 258             }
 259
 260             if (! isset($column['Default'])) {
 261                 if ($column['Null'] != 'NO') {
 262                     $column['Default'] = 'NULL';
 263                 }
 264             }
 265
 266             $fmt_pre = '';
 267             $fmt_post = '';
 268             if (in_array($column['Field'], $unique_keys)) {
 269                 $fmt_pre = '**' . $fmt_pre;
 270                 $fmt_post = $fmt_post . '**';
 271             }
 272             if ($column['Key']=='PRI') {
 273                 $fmt_pre = '//' . $fmt_pre;
 274                 $fmt_post = $fmt_post . '//';
 275             }
 276             $text_output .= '|' . $fmt_pre . htmlspecialchars($column['Field']) . $fmt_post;
 277             $text_output .= '|' . htmlspecialchars($type);
 278             $text_output .= '|' . (($column['Null'] == '' || $column['Null'] == 'NO') ? __('No') : __('Yes'));
 279             $text_output .= '|' . htmlspecialchars(isset($column['Default']) ? $column['Default'] : '');
 280
 281             $field_name = $column['Field'];
 282
 283             if ($do_relation && $have_rel) {
 284                 $text_output .= '|' . (isset($res_rel[$field_name]) ? htmlspecialchars($res_rel[$field_name]['foreign_table'] . ' (' . $res_rel[$field_name]['foreign_field'] . ')') : '');
 285             }
 286             if ($do_comments && $cfgRelation['commwork']) {
 287                 $text_output .= '|' . (isset($comments[$field_name]) ? htmlspecialchars($comments[$field_name]) : '');
 288             }
 289             if ($do_mime && $cfgRelation['mimework']) {
 290                 $text_output .= '|' . (isset($mime_map[$field_name]) ? htmlspecialchars(str_replace('_', '/', $mime_map[$field_name]['mimetype'])) : '');
 291             }
 292
 293             $text_output .= "\n";
 294
 295             if (! PMA_exportOutputHandler($text_output)) {
 296                 return false;
 297             }
 298         } // end while
 299
 300         return true;
 301     }
 302
 303 }
 304 ?>