DALDb2Converter.inc

<?php
require_once dirname(__FILE__).'/DALConverter.inc';

class DALDb2Converter extends DALConverter
{

    protected $name = 'DB2';

    protected $dataTypes = array(
                            'char'                => 'CHAR',
                            'varchar'             => 'VARCHAR',
                            'clob'                => 'CLOB',
                            'blob'                => 'BLOB',
                            'integer'             => 'INT',
                            'smallint'            => 'SMALLINT',
                            'numeric'             => 'NUMERIC',
                            'float'               => 'FLOAT',
                            'real'                => 'REAL',
                            'double_precision'    => 'DOUBLE PRECISION',
                            'boolean'             => 'CHAR',
                            'date'                => 'DATE',
                            'time'                => 'TIME',
                            'timestamp'           => 'TIMESTAMP',
                            'time with time zone' => 'TIME',
                           );


    public function __construct()
    {

    }//end __construct()


    protected function handleFunctionSeqNextVal($seqName)
    {
        $sql = 'SELECT next value for '.$seqName[0].' FROM SYSIBM.SYSDUMMY1';
        return $sql;

    }//end handleFunctionSeqNextVal()


    protected function handleFunctionSeqCurrVal($seqName)
    {
        $sql = 'SELECT prevval for '.$seqName[0].' FROM SYSIBM.SYSDUMMY1';
        return $sql;

    }//end handleFunctionSeqCurrVal()


    public function handleFunctionTableExists($tableName)
    {
        if (is_array($tableName) === TRUE) {
            $tableName = $tableName[0];
        }

        $sql = 'SELECT count(*) FROM syscat.tables WHERE tabname = UPPER(CAST('.$tableName.' AS VARCHAR(50)))';
        return $sql;

    }//end handleFunctionTableExists()


    public function handleFunctionSequenceExists($sequenceName)
    {
        if (is_array($sequenceName) === TRUE) {
            $sequenceName = $sequenceName[0];
        }

        $sql = 'SELECT count(*) FROM syscat.sequences WHERE seqname = '.$sequenceName;
        return $sql;

    }//end handleFunctionSequenceExists()


    protected function handleFunctionToDate(array $args)
    {
        $iso8601_date = $this->convertSingleField($args[0]);

        // DB2 appears to allow casting by calling the data type as a function.
        $sql = 'TIMESTAMP('.$iso8601_date.')';
        return $sql;

    }//end handleFunctionToDate()


    protected function getUnionType(array $union)
    {
        $type = '';
        if (isset($union['UNION']) === TRUE) {
            $type = 'UNION';
        } else if (isset($union['UNION-ALL']) === TRUE) {
            $type = 'UNION-ALL';
        }

        return $type;

    }//end getUnionType()


    protected function convertUnionDisplayName($type)
    {
        if ($type === 'UNION-ALL') {
            return 'UNION ALL';
        }

        return $type;

    }//end convertUnionDisplayName()


    protected function handleFunctionConcat(array $args)
    {
        $sql = implode(' || ', $args);
        return $sql;

    }//end handleFunctionConcat()


    protected function convertLikeCondition(array $condition)
    {
        $compare = $this->convertSingleField($condition['compare']);
        $to      = $this->convertSingleField($condition['to']);
        $sql     = 'LOCATE('.str_replace('%', '', $to).', '.str_replace('%', '', $compare).') <> 0';

        return $sql;

    }//end convertLikeCondition()


    protected function handleFunctionBindcast(array $args)
    {
        $sql = $this->handleFunctionCast($args);
        return $sql;

    }//end handleFunctionBindcast()


    protected function handleFunctionSubstring(array $args)
    {
        // SUBSTRING(input FROM start-position [FOR length])
        if (count($args) != 2 && count($args) != 3) {
            $msg = 'The SUBSTR() function only accepts two or three parameters.';
            throw new DALConverterException($msg);
        }

        $input = $this->convertSingleField($args[0]);
        $start = $args[1];
        $length = isset($args[2]) ? ",$args[2]" : '';
        $sql = "SUBSTRING($input, $start $length, OCTETS)";

        return $sql;

    }//end handleFunctionSubstring()


}//end class
?>