Home | Classes | Modules | Annotated | Functions | Files

MySQLTypes.php

Go to the documentation of this file.

<?php

/*
 *  $Id: MySQLTypes.php,v 1.1 2004/03/25 22:59:40 micha Exp $
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the LGPL. For more information please see
 * <http://creole.phpdb.org>.
 */

//
// STATUS:
// - ported:   y
// - compiled: y
// - tested:   n
//

require_once 'creole/CreoleTypes.php';

class MySQLTypes extends CreoleTypes
{
  var $typeMap = null;
  var $reverseMap = null;

  function getType($nativeType)
  {
    $self =& MySQLTypes::getInstance();

    $t = strtolower($nativeType);
    if (isset($self->typeMap[$t])) {
      return $self->typeMap[$t];
    }
    else {
      return CreoleTypes::OTHER();
    }
  }

  function getNativeType($creoleType)
  {
    $self =& MySQLTypes::getInstance();

    if ($self->reverseMap === null) {
      $self->reverseMap = array_flip($self->typeMap);
    }

    return @$self->reverseMap[$creoleType];
  }

  /*
  * @private
  */
  function & getInstance()
  {
    static $instance;

    if ($instance === null)
    {
      $instance = new MySQLTypes();
      $instance->typeMap = array
      (
        'tinyint' => CreoleTypes::TINYINT(),
        'smallint' => CreoleTypes::SMALLINT(),
        'mediumint' => CreoleTypes::SMALLINT(),
        'int' => CreoleTypes::INTEGER(),
        'integer' => CreoleTypes::INTEGER(),
        'bigint' => CreoleTypes::BIGINT(),
        'int24' => CreoleTypes::BIGINT(),
        'real' => CreoleTypes::REAL(),
        'float' => CreoleTypes::FLOAT(),
        'decimal' => CreoleTypes::DECIMAL(),
        'numeric' => CreoleTypes::NUMERIC(),
        'double' => CreoleTypes::DOUBLE(),
        'char' => CreoleTypes::CHAR(),
        'varchar' => CreoleTypes::VARCHAR(),
        'date' => CreoleTypes::DATE(),
        'time' => CreoleTypes::TIME(),
        'year' => CreoleTypes::YEAR(),
        'datetime' => CreoleTypes::TIMESTAMP(),
        'timestamp' => CreoleTypes::TIMESTAMP(),
        'tinyblob' => CreoleTypes::BINARY(),
        'blob' => CreoleTypes::VARBINARY(),
        'mediumblob' => CreoleTypes::VARBINARY(),
        'longblob' => CreoleTypes::VARBINARY(),
        'tinytext' => CreoleTypes::VARCHAR(),
        'mediumtext' => CreoleTypes::LONGVARCHAR(),
        'text' => CreoleTypes::LONGVARCHAR(),
        'enum' => CreoleTypes::CHAR(),
        'set' => CreoleTypes::CHAR()
      );
    }

    return $instance;
  }

}

---

This file is part of the Creole[php4] library.