libraries/db_routines.inc.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @todo Support seeing the "results" of the called procedure or
   6  *       function. This needs further reseach because a procedure
   7  *       does not necessarily contain a SELECT statement that
   8  *       produces something to see. But it seems we could at least
   9  *       get the number of rows affected. We would have to
  10  *       use the CLIENT_MULTI_RESULTS flag to get the result set
  11  *       and also the call status. All this does not fit well with
  12  *       our current sql.php.
  13  *       Of course the interface would need a way to pass calling parameters.
  14  *       Also, support DEFINER (like we do in export).
  15  * @package phpMyAdmin
  16  */
  17 if (! defined('PHPMYADMIN')) {
  18     exit;
  19 }
  20
  21 $routines = PMA_DBI_fetch_result('SELECT SPECIFIC_NAME,ROUTINE_NAME,ROUTINE_TYPE,DTD_IDENTIFIER FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA= \'' . PMA_sqlAddslashes($db,true) . '\';');
  22
  23 if ($routines) {
  24     PMA_generate_slider_effect('routines', __('Routines'));
  25     echo '<fieldset>' . "\n";
  26     echo ' <legend>' . __('Routines') . '</legend>' . "\n";
  27     echo '<table border="0">';
  28     echo sprintf('<tr>
  29                       <th>%s</th>
  30                       <th>&nbsp;</th>
  31                       <th>&nbsp;</th>
  32                       <th>%s</th>
  33                       <th>%s</th>
  34                 </tr>',
  35           __('Name'),
  36           __('Type'),
  37           __('Return type'));
  38     $ct=0;
  39     $delimiter = '//';
  40     if ($GLOBALS['cfg']['AjaxEnable']) {
  41         $conditional_class = 'class="drop_procedure_anchor"';
  42     } else {
  43         $conditional_class = '';
  44     }
  45
  46     foreach ($routines as $routine) {
  47
  48         // information_schema (at least in MySQL 5.0.45)
  49         // does not return the routine parameters
  50         // so we rely on PMA_DBI_get_definition() which
  51         // uses SHOW CREATE
  52
  53         $definition = 'DROP ' . $routine['ROUTINE_TYPE'] . ' ' . PMA_backquote($routine['SPECIFIC_NAME']) . $delimiter . "\n"
  54             .  PMA_DBI_get_definition($db, $routine['ROUTINE_TYPE'], $routine['SPECIFIC_NAME'])
  55             . "\n";
  56
  57         //if ($routine['ROUTINE_TYPE'] == 'PROCEDURE') {
  58         //    $sqlUseProc  = 'CALL ' . $routine['SPECIFIC_NAME'] . '()';
  59         //} else {
  60         //    $sqlUseProc = 'SELECT ' . $routine['SPECIFIC_NAME'] . '()';
  61             /* this won't get us far: to really use the function
  62                i'd need to know how many parameters the function needs and then create
  63                something to ask for them. As i don't see this directly in
  64                the table i am afraid that requires parsing the ROUTINE_DEFINITION
  65                and i don't really need that now so i simply don't offer
  66                a method for running the function*/
  67         //}
  68         if ($routine['ROUTINE_TYPE'] == 'PROCEDURE') {
  69             $sqlDropProc = 'DROP PROCEDURE ' . PMA_backquote($routine['SPECIFIC_NAME']);
  70         } else {
  71             $sqlDropProc = 'DROP FUNCTION ' . PMA_backquote($routine['SPECIFIC_NAME']);
  72         }
  73
  74         echo sprintf('<tr class="%s">
  75                           <td><input type="hidden" class="drop_procedure_sql" value="%s" /><strong>%s</strong></td>
  76                           <td>%s</td>
  77                           <td>%s</td>
  78                           <td>%s</td>
  79                           <td>%s</td>
  80                      </tr>',
  81                      ($ct%2 == 0) ? 'even' : 'odd',
  82                      $sqlDropProc,
  83                      $routine['ROUTINE_NAME'],
  84                      ! empty($definition) ? PMA_linkOrButton('db_sql.php?' . $url_query . '&amp;sql_query=' . urlencode($definition) . '&amp;show_query=1&amp;db_query_force=1&amp;delimiter=' . urlencode($delimiter), $titles['Structure']) : '&nbsp;',
  85                      '<a ' . $conditional_class . ' href="sql.php?' . $url_query . '&amp;sql_query=' . urlencode($sqlDropProc) . '" >' . $titles['Drop'] . '</a>',
  86                      $routine['ROUTINE_TYPE'],
  87                      $routine['DTD_IDENTIFIER']);
  88         $ct++;
  89     }
  90     echo '</table>';
  91     echo '</fieldset>' . "\n";
  92     echo '</div>' . "\n";
  93 }
  94 ?>