[Sommaire] [Imprimer]

   1  <?php
   2  /*
   3   * $Id: MySQLDatabaseInfo.php,v 1.13 2006/01/17 19:44:39 hlellelid Exp $
   4   *
   5   * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
   6   * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
   7   * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
   8   * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
   9   * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
  10   * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
  11   * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
  12   * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
  13   * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  14   * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
  15   * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  16   *
  17   * This software consists of voluntary contributions made by many individuals
  18   * and is licensed under the LGPL. For more information please see
  19   * <http://creole.phpdb.org>.
  20   */
  21  
  22  require_once 'creole/metadata/DatabaseInfo.php';
  23  
  24  /**
  25   * MySQL implementation of DatabaseInfo.
  26   *
  27   * @author    Hans Lellelid <hans@xmpl.org>
  28   * @version   $Revision: 1.13 $
  29   * @package   creole.drivers.mysql.metadata
  30   */
  31  class MySQLDatabaseInfo extends DatabaseInfo {
  32  
  33      /**
  34       * @throws SQLException
  35       * @return void
  36       */
  37      protected function initTables()
  38      {
  39          include_once 'creole/drivers/mysql/metadata/MySQLTableInfo.php';        
  40                                                                          // using $this->dblink was causing tests to break
  41                                                                          // perhaps dblink is changed by another test ... ?
  42          $result = @mysql_query("SHOW TABLES FROM `" . $this->dbname . "`", $this->conn->getResource());
  43  
  44          if (!$result) {
  45              throw new SQLException("Could not list tables", mysql_error($this->conn->getResource()));
  46          }
  47  
  48          while ($row = mysql_fetch_row($result)) {
  49              $this->tables[strtoupper($row[0])] = new MySQLTableInfo($this, $row[0]);
  50          }
  51          
  52          $this->tablesLoaded = true;
  53          
  54      }
  55  
  56      /**
  57       * MySQL does not support sequences.
  58       *
  59       * @return void
  60       * @throws SQLException
  61       */
  62      protected function initSequences()
  63      {
  64          // throw new SQLException("MySQL does not support sequences natively.");
  65      }
  66  }