[Sommaire] [Imprimer]

   1  <?php
   2  
   3  /*
   4   *  $Id: DBMySQL.php 286 2005-11-25 17:12:29Z hans $
   5   *
   6   * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
   7   * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
   8   * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
   9   * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
  10   * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
  11   * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
  12   * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
  13   * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
  14   * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  15   * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
  16   * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  17   *
  18   * This software consists of voluntary contributions made by many individuals
  19   * and is licensed under the LGPL. For more information please see
  20   * <http://propel.phpdb.org>.
  21   */
  22  
  23  require_once 'propel/adapter/DBAdapter.php';
  24  
  25  /**
  26   * This is used in order to connect to a MySQL database.
  27   *
  28   * @author Hans Lellelid <hans@xmpl.org> (Propel)
  29   * @author Jon S. Stevens <jon@clearink.com> (Torque)
  30   * @author Brett McLaughlin <bmclaugh@algx.net> (Torque)
  31   * @author Daniel Rall <dlr@finemaltcoding.com> (Torque)
  32   * @version $Revision: 286 $
  33   * @package propel.adapter
  34   */
  35  class DBMySQL extends DBAdapter {  
  36  
  37      /**
  38       * This method is used to ignore case.
  39       *
  40       * @param in The string to transform to upper case.
  41       * @return The upper case string.
  42       */
  43      public function toUpperCase($in)
  44      {
  45          return "UPPER(" . $in . ")";
  46      }
  47  
  48      /**
  49       * This method is used to ignore case.
  50       *
  51       * @param in The string whose case to ignore.
  52       * @return The string in a case that can be ignored.
  53       */
  54      public function ignoreCase($in)
  55      {
  56          return "UPPER(" . $in . ")";
  57      }   
  58  
  59      /**
  60       * Returns SQL which concatenates the second string to the first.
  61       *
  62       * @param string String to concatenate.
  63       * @param string String to append.
  64       * @return string 
  65       */
  66      public function concatString($s1, $s2)
  67      {
  68          return "CONCAT($s1, $s2)";
  69      }
  70  
  71      /**
  72       * Returns SQL which extracts a substring.
  73       *
  74       * @param string String to extract from.
  75       * @param int Offset to start from.
  76       * @param int Number of characters to extract.
  77       * @return string 
  78       */
  79      public function subString($s, $pos, $len)
  80      {
  81          return "SUBSTRING($s, $pos, $len)";
  82      }
  83  
  84      /**
  85       * Returns SQL which calculates the length (in chars) of a string.
  86       *
  87       * @param string String to calculate length of.
  88       * @return string 
  89       */
  90      public function strLength($s)
  91      {
  92          return "CHAR_LENGTH($s)";
  93      }
  94   
  95  
  96      /**
  97       * Locks the specified table.
  98       *
  99       * @param Connection $con The Creole connection to use.
 100       * @param string $table The name of the table to lock.
 101       * @throws SQLException No Statement could be created or
 102       * executed.
 103       */
 104      public function lockTable(Connection $con, $table)
 105      {
 106          $statement = $con->createStatement();
 107          $sql = "LOCK TABLE " . $table . " WRITE";
 108          $statement->executeUpdate($sql);
 109      }
 110  
 111      /**
 112       * Unlocks the specified table.
 113       *
 114       * @param Connection $con The Creole connection to use.
 115       * @param string $table The name of the table to unlock.
 116       * @throws SQLException No Statement could be created or
 117       * executed.
 118       */
 119      public function unlockTable(Connection $con, $table)
 120      {
 121          $statement = $con->createStatement();
 122          $statement->executeUpdate("UNLOCK TABLES");
 123      }
 124      
 125      /**
 126       * @see DBAdapter::quoteIdentifier()
 127       */
 128  	public function quoteIdentifier($text)
 129      {
 130          return '`' . $text . '`';
 131      }
 132  
 133  }