<?php

/*
 *  $Id: SQLiteTypes.php,v 1.3 2004/03/20 04:16:50 hlellelid 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>.
 */
 
require_once 'creole/CreoleTypes.php';

/**
 * MySQL types / type map.
 *
 * @author    Hans Lellelid <hide@address.com>
 * @version   $Revision: 1.3 $
 * @package   creole.drivers.sqlite
 */
class SQLiteTypes extends CreoleTypes {

    /** 
     * Map some fake SQLite types CreoleTypes. 
     * SQLite is typeless so this is really only for "hint" / readability
     * purposes.    
     * @var array
     */
    private static $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,
                                );
    
    /** Reverse mapping, created on demand. */
    private static $reverseMap = null;
    
    /**
     * This method returns the generic Creole (JDBC-like) type
     * when given the native db type.  If no match is found then we just
     * return CreoleTypes::TEXT because SQLite is typeless.
     * @param string $nativeType DB native type (e.g. 'TEXT', 'byetea', etc.).
     * @return int Creole native type (e.g. CreoleTypes::LONGVARCHAR, CreoleTypes::BINARY, etc.).
     */
    public static function getType($nativeType)
    {
        $t = strtolower($nativeType);
        if (isset(self::$typeMap[$t])) {
            return self::$typeMap[$t];
        } else {
            return CreoleTypes::TEXT; // because SQLite is typeless
        }
    }
            
    /**
     * This method will return a native type that corresponds to the specified
     * Creole (JDBC-like) type.  Remember that this is really only for "hint" purposes
     * as SQLite is typeless.
     * 
     * If there is more than one matching native type, then the LAST defined 
     * native type will be returned.
     * 
     * @param int $creoleType
     * @return string Native type string.
     */
    public static function getNativeType($creoleType)
    {
        if (self::$reverseMap === null) {
            self::$reverseMap = array_flip(self::$typeMap);
        }
        return @self::$reverseMap[$creoleType];
    }
                                
}