[Summary view] [Print] [Text view]

   1  <?php
   2  /* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */
   3  
   4  // +----------------------------------------------------------------------+
   5  // | Akelos Framework - http://www.akelos.org                             |
   6  // +----------------------------------------------------------------------+
   7  // | Copyright (c) 2002-2006, Akelos Media, S.L.  & Bermi Ferrer Martinez |
   8  // | Released under the GNU Lesser General Public License, see LICENSE.txt|
   9  // +----------------------------------------------------------------------+
  10  
  11  /**
  12   * @package ActiveRecord
  13   * @subpackage Base
  14   * @component DbAdapter SQLite
  15   * @author Bermi Ferrer <bermi a.t akelos c.om> 2004 - 2007
  16   * @author Kaste 2007
  17   * @copyright Copyright (c) 2002-2006, Akelos Media, S.L. http://www.akelos.org
  18   * @license GNU Lesser General Public License <http://www.gnu.org/copyleft/lesser.html>
  19   */
  20  
  21  class AkSqliteDbAdapter extends AkDbAdapter
  22  {
  23      
  24      /**
  25       * @param array $database_settings
  26       * @return string
  27       */
  28      function _constructDsn($database_settings)
  29      {
  30          $dsn  = $database_settings['type'].'://';
  31          $dsn .= urlencode($database_settings['database_file']).'/?persist';
  32          $dsn .= !empty($database_settings['options']) ? $database_settings['options'] : '';
  33          return $dsn;
  34      }
  35      
  36      function type()
  37      {
  38          return 'sqlite';
  39      }
  40  
  41      /* DATABASE STATEMENTS - CRUD */
  42      
  43      function incrementsPrimaryKeyAutomatically(){
  44          return false;
  45      }
  46      
  47      function getNextSequenceValueFor($table){
  48          $sequence_table = 'seq_'.$table;
  49          return $this->connection->GenID($sequence_table);
  50      }
  51      
  52      /* QUOTING */ 
  53      
  54      function quote_string($value)
  55      {
  56          return "'".sqlite_escape_string($value)."'";
  57      }
  58      
  59      
  60  }
  61  ?>