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  * @version $Id$
   7  */
   8
   9 /**
  10  *
  11  */
  12 if (isset($plugin_list)) {
  13     $plugin_list['yaml'] = array(
  14         'text' => 'YAML',
  15         'extension' => 'yml',
  16         'mime_type' => 'text/yaml',
  17         'force_file' => true,
  18           'options' => array(
  19             array('type' => 'hidden', 'name' => 'data'),
  20             ),
  21         'options_text' => 'strOptions',
  22         );
  23 } else {
  24
  25 /**
  26  * Set of functions used to build exports of tables
  27  */
  28
  29 /**
  30  * Outputs comment
  31  *
  32  * @param   string      Text of comment
  33  *
  34  * @return  bool        Whether it suceeded
  35  */
  36 function PMA_exportComment($text)
  37 {
  38     return TRUE;
  39 }
  40
  41 /**
  42  * Outputs export footer
  43  *
  44  * @return  bool        Whether it suceeded
  45  *
  46  * @access  public
  47  */
  48 function PMA_exportFooter()
  49 {
  50     return TRUE;
  51 }
  52
  53 /**
  54  * Outputs export header
  55  *
  56  * @return  bool        Whether it suceeded
  57  *
  58  * @access  public
  59  */
  60 function PMA_exportHeader()
  61 {
  62     return TRUE;
  63 }
  64
  65 /**
  66  * Outputs database header
  67  *
  68  * @param   string      Database name
  69  *
  70  * @return  bool        Whether it suceeded
  71  *
  72  * @access  public
  73  */
  74 function PMA_exportDBHeader($db)
  75 {
  76     return TRUE;
  77 }
  78
  79 /**
  80  * Outputs database footer
  81  *
  82  * @param   string      Database name
  83  *
  84  * @return  bool        Whether it suceeded
  85  *
  86  * @access  public
  87  */
  88 function PMA_exportDBFooter($db)
  89 {
  90     return TRUE;
  91 }
  92
  93 /**
  94  * Outputs create database database
  95  *
  96  * @param   string      Database name
  97  *
  98  * @return  bool        Whether it suceeded
  99  *
 100  * @access  public
 101  */
 102 function PMA_exportDBCreate($db)
 103 {
 104     return TRUE;
 105 }
 106
 107 /**
 108  * Outputs the content of a table in YAML format
 109  *
 110  * @param   string      the database name
 111  * @param   string      the table name
 112  * @param   string      the end of line sequence
 113  * @param   string      the url to go back in case of error
 114  * @param   string      SQL query for obtaining data
 115  *
 116  * @return  bool        Whether it suceeded
 117  *
 118  * @access  public
 119  */
 120 function PMA_exportData($db, $table, $crlf, $error_url, $sql_query)
 121 {
 122     $result      = PMA_DBI_query($sql_query, null, PMA_DBI_QUERY_UNBUFFERED);
 123
 124     $columns_cnt = PMA_DBI_num_fields($result);
 125     for ($i = 0; $i < $columns_cnt; $i++) {
 126         $columns[$i] = stripslashes(PMA_DBI_field_name($result, $i));
 127     }
 128     unset($i);
 129
 130     $cnt = 0;
 131     $buffer = '';
 132     while ($record = PMA_DBI_fetch_row($result)) {
 133         $cnt++;
 134         $buffer = $cnt . ":$crlf";
 135         for ($i = 0; $i < $columns_cnt; $i++) {
 136             if (isset($record[$i]) && !is_null($record[$i])) {
 137                 $buffer .= '  ' . $columns[$i] . ': '  . htmlspecialchars($record[$i]) . $crlf;
 138             }
 139         }
 140
 141         if (!PMA_exportOutputHandler($buffer)) {
 142             return FALSE;
 143         }
 144     }
 145     PMA_DBI_free_result($result);
 146
 147     return TRUE;
 148 }
 149
 150 }
 151 ?>