libraries/export/yaml.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Set of functions used to build YAML dumps of tables
   5  *
   6  * @package phpMyAdmin-Export-YAML
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  *
  14  */
  15 if (isset($plugin_list)) {
  16     $plugin_list['yaml'] = array(
  17         'text'          => 'YAML',
  18         'extension'     => 'yml',
  19         'mime_type'     => 'text/yaml',
  20         'force_file'    => true,
  21         'options'       => array(
  22             array('type' => 'begin_group', 'name' => 'general_opts'),
  23             array(
  24                 'type' => 'hidden',
  25                 'name' => 'structure_or_data',
  26             ),
  27             array('type' => 'end_group')
  28         ),
  29         'options_text'  => __('Options'),
  30     );
  31 } else {
  32
  33 /**
  34  * Set of functions used to build exports of tables
  35  */
  36
  37 /**
  38  * Outputs comment
  39  *
  40  * @param   string      Text of comment
  41  *
  42  * @return  bool        Whether it suceeded
  43  */
  44 function PMA_exportComment($text)
  45 {
  46     PMA_exportOutputHandler('# ' . $text . $GLOBALS['crlf']);
  47     return true;
  48 }
  49
  50 /**
  51  * Outputs export footer
  52  *
  53  * @return  bool        Whether it suceeded
  54  *
  55  * @access  public
  56  */
  57 function PMA_exportFooter()
  58 {
  59     PMA_exportOutputHandler('...' . $GLOBALS['crlf']);
  60     return true;
  61 }
  62
  63 /**
  64  * Outputs export header
  65  *
  66  * @return  bool        Whether it suceeded
  67  *
  68  * @access  public
  69  */
  70 function PMA_exportHeader()
  71 {
  72     PMA_exportOutputHandler('%YAML 1.1' . $GLOBALS['crlf'] . '---' . $GLOBALS['crlf']);
  73     return true;
  74 }
  75
  76 /**
  77  * Outputs database header
  78  *
  79  * @param   string      Database name
  80  *
  81  * @return  bool        Whether it suceeded
  82  *
  83  * @access  public
  84  */
  85 function PMA_exportDBHeader($db)
  86 {
  87     return true;
  88 }
  89
  90 /**
  91  * Outputs database footer
  92  *
  93  * @param   string      Database name
  94  *
  95  * @return  bool        Whether it suceeded
  96  *
  97  * @access  public
  98  */
  99 function PMA_exportDBFooter($db)
 100 {
 101     return true;
 102 }
 103
 104 /**
 105  * Outputs create database database
 106  *
 107  * @param   string      Database name
 108  *
 109  * @return  bool        Whether it suceeded
 110  *
 111  * @access  public
 112  */
 113 function PMA_exportDBCreate($db)
 114 {
 115     return true;
 116 }
 117
 118 /**
 119  * Outputs the content of a table in YAML format
 120  *
 121  * @param   string      the database name
 122  * @param   string      the table name
 123  * @param   string      the end of line sequence
 124  * @param   string      the url to go back in case of error
 125  * @param   string      SQL query for obtaining data
 126  *
 127  * @return  bool        Whether it suceeded
 128  *
 129  * @access  public
 130  */
 131 function PMA_exportData($db, $table, $crlf, $error_url, $sql_query)
 132 {
 133     $result      = PMA_DBI_query($sql_query, null, PMA_DBI_QUERY_UNBUFFERED);
 134
 135     $columns_cnt = PMA_DBI_num_fields($result);
 136     for ($i = 0; $i < $columns_cnt; $i++) {
 137         $columns[$i] = stripslashes(PMA_DBI_field_name($result, $i));
 138     }
 139     unset($i);
 140
 141     $buffer = '';
 142     $record_cnt = 0;
 143     while ($record = PMA_DBI_fetch_row($result)) {
 144         $record_cnt++;
 145
 146         // Output table name as comment if this is the first record of the table
 147         if ($record_cnt == 1) {
 148             $buffer = '# ' . $db . '.' . $table . $crlf;
 149             $buffer .= '-' . $crlf;
 150         } else {
 151             $buffer = '-' . $crlf;
 152         }
 153
 154         for ($i = 0; $i < $columns_cnt; $i++) {
 155             if (! isset($record[$i])) {
 156                 continue;
 157             }
 158
 159             $column = $columns[$i];
 160
 161             if (is_null($record[$i])) {
 162                 $buffer .= '  ' . $column . ': null' . $crlf;
 163                 continue;
 164             }
 165
 166             if (is_numeric($record[$i])) {
 167                 $buffer .= '  ' . $column . ': '  . $record[$i] . $crlf;
 168                 continue;
 169             }
 170
 171             $record[$i] = preg_replace('/\r\n|\r|\n/', $crlf.'    ', $record[$i]);
 172             if (strstr($record[$i], $crlf))
 173               $record[$i] = '|-' . $crlf . '    '.$record[$i];
 174
 175             $buffer .= '  ' . $column . ': ' . $record[$i] . $crlf;
 176         }
 177
 178         if (! PMA_exportOutputHandler($buffer)) {
 179             return FALSE;
 180         }
 181     }
 182     PMA_DBI_free_result($result);
 183
 184     return true;
 185 }
 186
 187 }
 188 ?>