sql_compiler::parse_query() - Code Metrics - Inspection of "Merge pull request #101 from mjrider/save-custom-f..." - Ariadne-CMS/ariadne - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( c95774...6765cb )

by Auke

created 2016-03-11 15:14 UTC

sql_compiler::parse_query() C

↳ Parent: sql_compiler

Complexity

Conditions	8
Paths	40

Size

Total Lines	80
Code Lines	28

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	26
CRAP Score	8.1515

Metric	Value
dl	0
loc	80
ccs	26
cts	30
cp	0.8667
rs	6.0132
cc	8
eloc	28
nc	40
nop	1
crap	8.1515

How to fix Long Method

<?php

abstract class sql_compiler {
	protected $skipDefaultOrderBy;
	protected $store;
	public  $error;
	protected $join_target_properties;
	protected $offset;
	protected $limit;
	protected $cache;
	protected $path;
	protected $_SCAN_WS        = array(" " => true, "\t" => true, "\n" => true ,"\r" => true);
	protected $_SCAN_AZ        = array("a" => true, "A" => true, "b" => true, "B" => true, "c" => true, "C" => true, "d" => true, "D" => true, "e" => true, "E" => true, "f" => true, "F" => true, "g" => true, "G" => true, "h" => true, "H" => true, "i" => true, "I" => true, "j" => true, "J" => true, "k" => true, "K" => true, "l" => true, "L" => true, "m" => true, "M" => true, "n" => true, "N" => true, "o" => true, "O" => true, "p" => true, "P" => true, "q" => true, "Q" => true, "r" => true, "R" => true, "s" => true, "S" => true, "t" => true, "T" => true, "u" => true, "U" => true, "v" => true, "V" => true, "w" => true, "W" => true, "x" => true, "X" => true, "y" => true, "Y" => true, "z" => true, "Z" => true);
	protected $_SCAN_AZ_09     = array("a" => true, "A" => true, "b" => true, "B" => true, "c" => true, "C" => true, "d" => true, "D" => true, "e" => true, "E" => true, "f" => true, "F" => true, "g" => true, "G" => true, "h" => true, "H" => true, "i" => true, "I" => true, "j" => true, "J" => true, "k" => true, "K" => true, "l" => true, "L" => true, "m" => true, "M" => true, "n" => true, "N" => true, "o" => true, "O" => true, "p" => true, "P" => true, "q" => true, "Q" => true, "r" => true, "R" => true, "s" => true, "S" => true, "t" => true, "T" => true, "u" => true, "U" => true, "v" => true, "V" => true, "w" => true, "W" => true, "x" => true, "X" => true, "y" => true, "Y" => true, "z" => true, "Z" => true, "_" => true, "0" => true, "1" => true, "2" => true, "3" => true, "4" => true, "5" => true, "6" => true, "7" => true, "8" => true, "9" => true);
	protected $_SCAN_NUM       = array("0" => true, "1" => true, "2" => true, "3" => true, "4" => true, "5" => true, "6" => true, "7" => true, "8" => true, "9" => true);
	protected $_SCAN_NUM_START = array("0" => true, "1" => true, "2" => true, "3" => true, "4" => true, "5" => true, "6" => true, "7" => true, "8" => true, "9" => true, "-" => true);
	protected $_SCAN_CMP       = array("~" => array("=" => array("FIN" => true)), "=" => array("=" => array("FIN" => true), "FIN" => true, "~" => array("FIN" => true, "~" => array("FIN" => true)), "*" => array("FIN" => true, "*" => array("FIN" => true)), "/" => array("FIN" => true)), "!" => array("=" => array("FIN" => true), "~" => array("FIN" => true, "~" => array("FIN" => true)), "*" => array("FIN" => true, "*" => array("FIN" => true)), "/" => array("FIN" => true, "/" => array("FIN" => true))), "<" => array("=" => array("FIN" => true), "FIN" => true), ">" => array("=" => array("FIN" => true), "FIN" => true), "/" => array("=" => array("=" => array("FIN" => true))));


	protected function parse_const(&$YYBUFFER) {
		$YYCURSOR = 0;
		while (isset($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]])) {
			$YYCURSOR++;
		}
		$value = '';
		$yych = $YYBUFFER[$YYCURSOR];
		switch (true) {
			case '"' === $yych:
			case "'" === $yych:
				$quote = $yych;
				$yych = $YYBUFFER[++$YYCURSOR];
				while ($yych !== "\0" && $yych !== $quote) {
					if ($yych === "\\") {
						$yych = $YYBUFFER[++$YYCURSOR];
						if ($yych !== $quote && $yych != "\\") {
							$value .= "\\";
						}
					}
					$value .= $yych;
					$yych = $YYBUFFER[++$YYCURSOR];
				}
				$YYBUFFER = substr($YYBUFFER, $YYCURSOR + 1);
				$node["id"] = "string";
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
				$node["type"] = ($quote === '"') ? "double" : "single";
				$node["value"] = stripslashes($value);
				return $node;
			break;
			case $this->_SCAN_NUM_START[$yych]:
				$value = $yych;
				$yych = $YYBUFFER[++$YYCURSOR];
				while (isset($this->_SCAN_NUM[$yych])) {
					$value .= $yych;
					$yych = $YYBUFFER[++$YYCURSOR];
				}
				if ($yych === '.') {
					$value .= $yych;
					$yych = $YYBUFFER[++$YYCURSOR];
					while (isset($this->_SCAN_NUM[$yych])) {
						$value .= $yych;
						$yych = $YYBUFFER[++$YYCURSOR];
					}
					$node["id"]="float";
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
					$node["value"]=(float)$value;
				} else {
					$node["id"]="int";
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
					$node["value"]=(int)$value;;
				}
				$YYBUFFER = substr($YYBUFFER, $YYCURSOR);
				return $node;
			break;
		}
	}

	protected function parse_ident(&$YYBUFFER) {
		/* parse identifier regs 1,2 and 3


			reg[1]: tablename
			reg[2]: property name
			reg[3]: only used with 'my' properties
		*/
		$reg_id='^[[:space:]]*(([a-z_][a-z0-9_]*)(:[a-z]+)?([.][a-z_][a-z0-9_]*)?([.][a-z_][a-z0-9_]*)?)';
		$reg_id.='[[:space:]]*';

		$YYCURSOR = 0;
		while (isset($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]])) {
			$YYCURSOR++;
		}
		$value = '';
		$yych = $YYBUFFER[$YYCURSOR];

		if ($this->_SCAN_AZ[$yych]) {
			$value .= $yych;
			$yych = $YYBUFFER[++$YYCURSOR];
			while (isset($this->_SCAN_AZ_09[$yych])) {
				$value .= $yych;
				$yych = $YYBUFFER[++$YYCURSOR];
			}
			$match_1 = $value; $value = '';
			if ($yych === ':') {
				$yych = $YYBUFFER[++$YYCURSOR];
				while (isset($this->_SCAN_AZ[$yych])) {
					$value .= $yych;
					$yych = $YYBUFFER[++$YYCURSOR];
				}
				$record_id = $value; $value = '';
			}
			if ($yych === '.') {
				$yych = $YYBUFFER[++$YYCURSOR];
				if ($this->_SCAN_AZ[$yych]) {
					$value .= $yych;
					$yych = $YYBUFFER[++$YYCURSOR];
					while (isset($this->_SCAN_AZ_09[$yych])) {
						$value .= $yych;
						$yych = $YYBUFFER[++$YYCURSOR];
					}
				}
				$match_2 = $value; $value = '';
			}
			if ($yych === '.') {
				$yych = $YYBUFFER[++$YYCURSOR];
				if ($this->_SCAN_AZ[$yych]) {
					$value .= $yych;
					$yych = $YYBUFFER[++$YYCURSOR];
					while (isset($this->_SCAN_AZ_09[$yych])) {
						$value .= $yych;
						$yych = $YYBUFFER[++$YYCURSOR];
					}
				}
				$match_3 = $value; $value = '';
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
			}

		}


		if($match_1) {
			if (!$match_2) {
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
				/* default table is 'object' */
				$match_2 = $match_1;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
				$match_1 = "object";
			}
			$node["id"]="ident";
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}

			$table=$match_1;
			$field=$match_2;
			if ($table=="object") {
				switch ($field) {
					case "implements":
						$node["id"]="implements";
					break;
					case "path":
					case "parent":
					case "priority":
						$node["table"]="nodes";
						$node["field"]=$field;
					break;
					default:
						$node["table"]="objects";
						$node["field"]=$field;
				}
			} else
			if ($table === "my") {
				$node["id"] = "custom";
				if ($match_3) {
					$node["nls"] = $field;
					$field = $match_3;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
				}
				$node["field"] = $field;
				$node["record_id"] = $record_id;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
			} else {
				$node["id"]="property";
				if ($match_3) {
					$node["nls"] = $field;
					$field = $match_3;
				}
				$node["table"]="prop_".$table;
				$node["field"]="AR_".$field;
				$node["record_id"] = $record_id;
			}
		}
		$YYBUFFER = substr($YYBUFFER, $YYCURSOR);
		return $node;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
	}

	protected function parse_cmp_expr(&$YYBUFFER) {
		$result=$this->parse_ident($YYBUFFER);
		if ($result) {

			$YYCURSOR = 0;
			while (isset($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]])) {
				$YYCURSOR++;
			}
			$yych = $YYBUFFER[$YYCURSOR];
			$YYCURSOR_START = $YYCURSOR;
			$RULES = &$this->_SCAN_CMP;
			while (isset($RULES[$yych])) {
				$RULES = &$RULES[$yych];
				if (isset($RULES['FIN'])) {
					$YYMATCH = $YYCURSOR;
				}
				$yych = $YYBUFFER[++$YYCURSOR];
			}
			if (isset($YYMATCH)) {
					$node["id"]="cmp";
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
					$node["operator"]=substr($YYBUFFER, $YYCURSOR_START, ($YYMATCH + 1) - $YYCURSOR_START);
					$node["left"]=$result;
					$YYBUFFER = substr($YYBUFFER, $YYCURSOR);
					$result=$this->parse_const($YYBUFFER);
					if ($result) {
						$node["right"]=$result;
					}
					$result=$node;
			} else {
				$this->error="unknow compare-operator near '$YYBUFFER'";
			}
		}
		return $result;
	}

	protected function parse_group_expr(&$YYBUFFER) {
		$YYCURSOR = 0;
		while (isset($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]])) {
			$YYCURSOR++;
		}
		$yych = $YYBUFFER[$YYCURSOR++];
		if ($yych === '(') {
			$YYBUFFER = substr($YYBUFFER, $YYCURSOR);
			$result = $this->parse_or_expr($YYBUFFER);
			$YYCURSOR = 0;
			while (isset($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]])) {
				$YYCURSOR++;
			}
			$yych = $YYBUFFER[$YYCURSOR++];
			if ($yych === ')') {
				$YYBUFFER = substr($YYBUFFER, $YYCURSOR);
				$node["id"]="group";
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
				$node["left"]=$result;
				$result=$node;
			} else {
				unset($result);
				$this->error = "missing closing group sign near '$YYBUFFER'";
			}
		} else {
			$result = $this->parse_cmp_expr($YYBUFFER);
		}
		return $result;
	}

	protected function parse_and_expr(&$YYBUFFER) {

		$result=$this->parse_group_expr($YYBUFFER);
		while (is_array($result)) {
			$YYCURSOR = 0;
			while (isset($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]])) {
				$YYCURSOR++;
			}
			$ident = strtolower(substr($YYBUFFER, $YYCURSOR, 3));
			if ($ident === 'and' && !isset($this->_SCAN_AZ_09[$YYBUFFER[$YYCURSOR + 3]]) ) {
				$YYBUFFER = substr($YYBUFFER, $YYCURSOR + 3);
				$right = $this->parse_group_expr($YYBUFFER);
				if (is_array($right)) {
					$result = array(
						'id' => $ident,
						'left' => $result,
						'right' => $right
					);
				} else {
					unset($result);
				}
			} else {
				break;
			}
		}
		return $result;
	}

	protected function parse_or_expr(&$YYBUFFER) {

		$result=$this->parse_and_expr($YYBUFFER);
		while (is_array($result)) {
			$YYCURSOR = 0;
			while (isset($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]])) {
				$YYCURSOR++;
			}
			$ident = strtolower(substr($YYBUFFER, $YYCURSOR, 2));
			if ($ident === 'or' && !isset($this->_SCAN_AZ_09[$YYBUFFER[$YYCURSOR + 2]]) ) {
				$YYBUFFER = substr($YYBUFFER, $YYCURSOR + 2);
				$right = $this->parse_and_expr($YYBUFFER);
				if (is_array($right)) {
					$result = array(
						'id' => $ident,
						'left' => $result,
						'right' => $right
					);
				} else {
					unset($result);
				}
			} else {
				break;
			}
		}
		return $result;
	}

	protected function parse_orderby(&$YYBUFFER) {
		$field = $this->parse_ident($YYBUFFER);

		$YYCURSOR = 0;
		while (isset($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]])) {
			$YYCURSOR++;
		}
		$value = '';
		$yych  = $YYBUFFER[$YYCURSOR];
		if ($this->_SCAN_AZ[$yych]) {
			$value .= $yych;
			$yych = $YYBUFFER[++$YYCURSOR];
			while (isset($this->_SCAN_AZ[$yych])) {
				$value .= $yych;
				$yych = $YYBUFFER[++$YYCURSOR];
			}
			$sort_type = strtoupper($value);
			if (!($sort_type == 'ASC' || $sort_type == 'DESC')) { // If sort type is anything else than ASC or DESC, it is not part of the order by.
				$sort_type = 'ASC';
				$YYCURSOR = $YYCURSOR - strlen($value);
				$value = '';
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
			}
		} else {
			$sort_type = 'ASC';
		}
		while (is_array($field)) {
			$result = array(
				'id' => 'orderbyfield',
				'type' => $sort_type,
				'right' => $field,
				'left' => $result
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
			);
			while (isset($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]])) {
				$YYCURSOR++;
			}
			$yych  = $YYBUFFER[$YYCURSOR];
			if ($yych !== ',') {
				$YYBUFFER = substr($YYBUFFER, $YYCURSOR);
				unset($field);
			} else {
				$YYBUFFER = substr($YYBUFFER, $YYCURSOR + 1);
				$field = $this->parse_ident($YYBUFFER);
				$YYCURSOR = 0;
				while (isset($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]])) {
					$YYCURSOR++;
				}
				$value = '';
				$yych  = $YYBUFFER[$YYCURSOR];
				if ($this->_SCAN_AZ[$yych]) {
					$value .= $yych;
					$yych = $YYBUFFER[++$YYCURSOR];
					while (isset($this->_SCAN_AZ[$yych])) {
						$value .= $yych;
						$yych = $YYBUFFER[++$YYCURSOR];
					}
					$sort_type = strtoupper($value);
					if (!($sort_type == 'ASC' || $sort_type == 'DESC')) { // If sort type is anything else than ASC or DESC, it is not part of the order by.
						$sort_type = 'ASC';
						$YYCURSOR = $YYCURSOR - strlen($value);
						$value = '';
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
					}
				} else {
					$sort_type = 'ASC';
				}
			}
		}
		return $result;
	}


	protected function parse_join_target_properties(&$query) {
		do {
			if (!preg_match('/^([a-z_][a-z0-9_]*)(:[a-z]+)?/i', $query, $regs)) {
				$this->error = "expected property name at '$query'";
				return false;
			}
			$this->join_target_properties["prop_".$regs[1]][$regs[2]] = true;
			$query = substr($query, strlen($regs[0]));

			if (!preg_match('/^[[:space:]]*,[[:space:]]*/', $query, $regs)) {
				return true;
			}
			$query = substr($query, strlen($regs[0]));
		} while(1);
	}

	protected function parse_query(&$query) {

		if (!preg_match('|^[[:space:]]*order[[:space:]]*by[[:space:]]+|i', $query, $regs)) {
			$result=$this->parse_or_expr($query);
		} else {
			$no_selection = true;
		}

/*

		$YYCURSOR = 0;
		while ($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]]) {
			$YYCURSOR++;
		}

		$yych  = $YYBUFFER[$YYCURSOR];
		if ($this->_SCAN_AZ[$yych]) {
			$value = $yych;
			$yych  = $YYBUFFER[++$YYCURSOR];
			while ($this->_SCAN_AZ[$yych]) {
				$value .= $yych;
				$yych = $YYBUFFER[++$YYCURSOR];
			}
			$value = strtolower($value);
			if ($value === 'order') {
				while ($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]]) {
					$YYCURSOR++;
				}
				$yych  = $YYBUFFER[$YYCURSOR];
				if ($this->_SCAN_AZ[$yych]) {
					$value = $yych;
					$yych  = $YYBUFFER[++$YYCURSOR];
					while ($this->_SCAN_AZ[$yych]) {
						$value .= $yych;
						$yych = $YYBUFFER[++$YYCURSOR];
					}
					$value = strtolower($value);
					if ($value === 'by') {
						$YYBUFFER = substr($YYBUFFER, $YYCURSOR;
						$result = $this->parse_or_expr($YYBUFFER);
						$YYCURSOR = 0;
						$value = '';
					} else {
						$this->error = "syntax error near: $YYBUFFER";
						return false;
					}
				}
			}
		}

*/

		if (preg_match('|^[[:space:]]*join[[:space:]]*target[[:space:]]*on[[:space:]]*|i', $query, $regs)) {
			$this->join_target_properties = array();
			$query = substr($query, strlen($regs[0]));
			$this->parse_join_target_properties($query);
		}

		$matching = preg_match('|^[[:space:]]*order[[:space:]]*by[[:space:]]+|i', $query, $regs);
		if ( $matching || $no_selection ) {
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
			$query=substr($query, strlen($regs[0]));
			$node["id"]="orderby";
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			$node["right"]=$this->parse_orderby($query);
			$node["left"]=$result;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
			$result=$node;
		}
		if (preg_match('|^[[:space:]]*limit[[:space:]]+([0-9]+)[[:space:]]*([,][[:space:]]*([0-9]+))?|i', $query, $regs)) {
			$query=substr($query, strlen($regs[0]));
			$limit_s["id"]="limit";
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			$limit_s["offset"]=$regs[1];
			$limit_s["limit"]=$regs[3];
		} else {
			$limit_s["id"]="limit";
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
			$limit_s["offset"]=($this->offset) ? $this->offset : 0;
			$limit_s["limit"]=($this->limit) ? $this->limit : 0;
		}
		$limit_s["left"]=$result;
		$result=$limit_s;

		return $result;
	}

	// virtual (&private) method. To be implemented in the sql specific compiler
	protected abstract function priv_sql_compile($node) ;


	public function compile($path, $query, $limit=100, $offset=0, $layers = array()) {
		debug("sql_compiler::compile ($path, $query, $limit, $offset)", "store");
		$this->error="";
		$this->path = $path;

		$this->limit=$limit;
		$this->offset=$offset;
		$this->layers=$layers;
class MyClass { }

$x = new MyClass();
$x->foo = true;

		$tree=$this->parse_query($query);

		if ( $this->error ) {
			return null;
		} else if ( trim($query) ) {
			// no error detected, but there is still a part of the query left
			$this->error="unkown operator near '$query'";
			return null;
		} else if ( $tree ) {

			$compiled_query=$this->priv_sql_compile($tree);
			return $compiled_query;
		} else {
			return null;
		}

	}


  }


Push — master ( c95774...6765cb )

sql_compiler::parse_query() C

Complexity

Size

Duplication

Code Coverage

How to fix Long Method

Long Method

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

1		<?php
2
3		abstract class sql_compiler {
4		protected $skipDefaultOrderBy;
5		protected $store;
6		public $error;
7		protected $join_target_properties;
8		protected $offset;
9		protected $limit;
10		protected $cache;
11		protected $path;
12		protected $_SCAN_WS = array(" " => true, "\t" => true, "\n" => true ,"\r" => true);
13		protected $_SCAN_AZ = array("a" => true, "A" => true, "b" => true, "B" => true, "c" => true, "C" => true, "d" => true, "D" => true, "e" => true, "E" => true, "f" => true, "F" => true, "g" => true, "G" => true, "h" => true, "H" => true, "i" => true, "I" => true, "j" => true, "J" => true, "k" => true, "K" => true, "l" => true, "L" => true, "m" => true, "M" => true, "n" => true, "N" => true, "o" => true, "O" => true, "p" => true, "P" => true, "q" => true, "Q" => true, "r" => true, "R" => true, "s" => true, "S" => true, "t" => true, "T" => true, "u" => true, "U" => true, "v" => true, "V" => true, "w" => true, "W" => true, "x" => true, "X" => true, "y" => true, "Y" => true, "z" => true, "Z" => true);
14		protected $_SCAN_AZ_09 = array("a" => true, "A" => true, "b" => true, "B" => true, "c" => true, "C" => true, "d" => true, "D" => true, "e" => true, "E" => true, "f" => true, "F" => true, "g" => true, "G" => true, "h" => true, "H" => true, "i" => true, "I" => true, "j" => true, "J" => true, "k" => true, "K" => true, "l" => true, "L" => true, "m" => true, "M" => true, "n" => true, "N" => true, "o" => true, "O" => true, "p" => true, "P" => true, "q" => true, "Q" => true, "r" => true, "R" => true, "s" => true, "S" => true, "t" => true, "T" => true, "u" => true, "U" => true, "v" => true, "V" => true, "w" => true, "W" => true, "x" => true, "X" => true, "y" => true, "Y" => true, "z" => true, "Z" => true, "_" => true, "0" => true, "1" => true, "2" => true, "3" => true, "4" => true, "5" => true, "6" => true, "7" => true, "8" => true, "9" => true);
15		protected $_SCAN_NUM = array("0" => true, "1" => true, "2" => true, "3" => true, "4" => true, "5" => true, "6" => true, "7" => true, "8" => true, "9" => true);
16		protected $_SCAN_NUM_START = array("0" => true, "1" => true, "2" => true, "3" => true, "4" => true, "5" => true, "6" => true, "7" => true, "8" => true, "9" => true, "-" => true);
17		protected $_SCAN_CMP = array("~" => array("=" => array("FIN" => true)), "=" => array("=" => array("FIN" => true), "FIN" => true, "~" => array("FIN" => true, "~" => array("FIN" => true)), "" => array("FIN" => true, "" => array("FIN" => true)), "/" => array("FIN" => true)), "!" => array("=" => array("FIN" => true), "~" => array("FIN" => true, "~" => array("FIN" => true)), "" => array("FIN" => true, "" => array("FIN" => true)), "/" => array("FIN" => true, "/" => array("FIN" => true))), "<" => array("=" => array("FIN" => true), "FIN" => true), ">" => array("=" => array("FIN" => true), "FIN" => true), "/" => array("=" => array("=" => array("FIN" => true))));
18
19
20	190	protected function parse_const(&$YYBUFFER) {
21	190	$YYCURSOR = 0;
22	190	while (isset($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]])) {
23	190	$YYCURSOR++;
24	143	}
25	190	$value = '';
26	190	$yych = $YYBUFFER[$YYCURSOR];
27		switch (true) {
28	190	case '"' === $yych:
29	190	case "'" === $yych:
30	186	$quote = $yych;
31	186	$yych = $YYBUFFER[++$YYCURSOR];
32	186	while ($yych !== "\0" && $yych !== $quote) {
33	186	if ($yych === "\\") {
34	93	$yych = $YYBUFFER[++$YYCURSOR];
35	1	if ($yych !== $quote && $yych != "\\") {
36		$value .= "\\";
37		}
38	93	}
39	186	$value .= $yych;
40	186	$yych = $YYBUFFER[++$YYCURSOR];

Ariadne-CMS / ariadne

Push — master ( c95774...6765cb )

sql_compiler::parse_query() C

Complexity

Size

Duplication

Code Coverage

How to fix Long Method

Long Method

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Available Fixes

Duplication Side-by-Side

Filter issues like