DBParser.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) NAVER <http://www.navercorp.com> */

class DBParser
{

    var $escape_char_left;

    var $escape_char_right;

    var $table_prefix;

    function __construct($escape_char_left, $escape_char_right = "", $table_prefix = "xe_")
    {
        $this->escape_char_left = $escape_char_left;
        if($escape_char_right !== "")
        {
            $this->escape_char_right = $escape_char_right;
        }
        else
        {
            $this->escape_char_right = $escape_char_left;
        }
        $this->table_prefix = $table_prefix;
    }

    function getEscapeChar($leftOrRight)
    {
        if($leftOrRight === 'left')
        {
            return $this->escape_char_left;
        }
        else
        {
            return $this->escape_char_right;
        }
    }

    function escape($name)
    {
        return $this->escape_char_left . $name . $this->escape_char_right;
    }

    function escapeString($name)
    {
        return "'" . $this->escapeStringValue($name) . "'";
    }

    function escapeStringValue($value)
    {
        if($value == "*")
        {
            return $value;
        }
        if(is_string($value))
        {
            return $value = str_replace("'", "''", $value);
        }
        return $value;
    }

    function parseTableName($name)
    {
        return $this->table_prefix . $name;
    }

    function parseColumnName($name)
    {
        return $this->escapeColumn($name);
    }

    function escapeColumn($column_name)
    {
        if($this->isUnqualifiedColumnName($column_name))
        {
            return $this->escape($column_name);
        }
        if($this->isQualifiedColumnName($column_name))
        {
            list($table, $column) = explode('.', $column_name);
            // $table can also be an alias, so the prefix should not be added
            return $this->escape($table) . '.' . $this->escape($column);
            //return $this->escape($this->parseTableName($table)).'.'.$this->escape($column);
        }
    }

    function isUnqualifiedColumnName($column_name)
    {
        if(strpos($column_name, '.') === FALSE && strpos($column_name, '(') === FALSE)
        {
            return TRUE;
        }
        return FALSE;
    }

    function isQualifiedColumnName($column_name)
    {
        if(strpos($column_name, '.') !== FALSE && strpos($column_name, '(') === FALSE)
        {
            return TRUE;
        }
        return FALSE;
    }

    function parseExpression($column_name)
    {
        $functions = preg_split('/([\+\-\*\/\ ])/', $column_name, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY);
        foreach($functions as $k => $v)
        {
            $function = &$functions[$k];
            if(strlen($function) == 1)
            {
                continue; // skip delimiters
            }
            $pos = strrpos("(", $function);
            $matches = preg_split('/([a-zA-Z0-9_*]+)/', $function, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY);
            $total_brackets = substr_count($function, "(");
            $brackets = 0;
            foreach($matches as $i => $j)
            {
                $match = &$matches[$i];
                if($match == '(')
                {
                    $brackets++;
                    continue;
                }
                if(strpos($match, ')') !== FALSE)
                {
                    continue;
                }
                if(in_array($match, array(',', '.')))
                {
                    continue;
                }
                if($brackets == $total_brackets)
                {
                    if(!is_numeric($match) && !in_array(strtoupper($match), array('UNSIGNED', 'INTEGER', 'AS')))
                    {
                        $match = $this->escapeColumnExpression($match);
                    }
                }
            }
            $function = implode('', $matches);
        }
        return implode('', $functions);
    }

    function isStar($column_name)
    {
        if(substr($column_name, -1) == '*')
        {
            return TRUE;
        }
        return FALSE;
    }

    function isStarFunction($column_name)
    {
        if(strpos($column_name, "(*)") !== FALSE)
        {
            return TRUE;
        }
        return FALSE;
    }

    function escapeColumnExpression($column_name)
    {
        if($this->isStar($column_name))
        {
            return $column_name;
        }
        if($this->isStarFunction($column_name))
        {
            return $column_name;
        }
        if(stripos($column_name, 'distinct') !== FALSE)
        {
            return $column_name;
        }
        return $this->escapeColumn($column_name);
    }

}
/* End of file DBParser.class.php */
/* Location: ./classes/xml/xmlquery/DBParser.class.php */