[Sommaire] [Imprimer]

   1  <?php
   2  /*

   3   *  $Id: SQLiteDatabaseInfo.php,v 1.3 2004/03/20 04:16:50 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   * SQLite implementation of DatabaseInfo.

  26   * 

  27   * @author    Hans Lellelid <hans@xmpl.org>

  28   * @version   $Revision: 1.3 $

  29   * @package   creole.drivers.sqlite.metadata

  30   */ 
  31  class SQLiteDatabaseInfo extends DatabaseInfo {
  32      
  33      /**

  34       * @throws SQLException

  35       * @return void

  36       */
  37      protected function initTables()
  38      {
  39          include_once 'creole/drivers/sqlite/metadata/SQLiteTableInfo.php';        
  40          
  41          $sql = "SELECT name FROM sqlite_master WHERE type='table' UNION ALL SELECT name FROM sqlite_temp_master WHERE type='table' ORDER BY name;";
  42          $result = sqlite_query($this->dblink, $sql);
  43              
  44          if (!$result) {
  45              throw new SQLException("Could not list tables", sqlite_last_error($this->dblink));
  46          }
  47          
  48          while ($row = sqlite_fetch_array($result)) {
  49              $this->tables[strtoupper($row[0])] = new SQLiteTableInfo($this, $row[0]);
  50          }
  51      }
  52      
  53      /**

  54       * SQLite does not support sequences.

  55       *

  56       * @return void 

  57       * @throws SQLException

  58       */
  59      protected function initSequences()
  60      {
  61          // throw new SQLException("MySQL does not support sequences natively.");

  62      }
  63          
  64  }