sql_compiler::parse_orderby() - Code Metrics - Inspection of "Merge pull request #78 from mjrider/release-prep-9..." - Ariadne-CMS/ariadne - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( b6dbee...323036 )

by Robbert

created 2015-12-04 14:16 UTC

sql_compiler::parse_orderby() C

↳ Parent: sql_compiler

Complexity

Conditions	14
Paths	138

Size

Total Lines	68
Code Lines	54

Duplication

Lines	32
Ratio	47.06 %

Code Coverage

Tests	45
CRAP Score	17.5371

Metric	Value
dl	32
loc	68
ccs	45
cts	61
cp	0.7377
rs	5.2791
cc	14
eloc	54
nc	138
nop	1
crap	17.5371

How to fix Long Method Complexity

<?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 ( b6dbee...323036 )

sql_compiler::parse_orderby() C

Complexity

Size

Duplication

Code Coverage

How to fix Long Method Complexity

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	193	protected function parse_const(&$YYBUFFER) {
21	193	$YYCURSOR = 0;
22	193	while (isset($this->_SCAN_WS[$YYBUFFER[$YYCURSOR]])) {
23	193	$YYCURSOR++;
24	193	}
25	193	$value = '';
26	193	$yych = $YYBUFFER[$YYCURSOR];
27		switch (true) {
28	193	case '"' === $yych:
29	193	case "'" === $yych:
30	190	$quote = $yych;
31	190	$yych = $YYBUFFER[++$YYCURSOR];
32	190	while ($yych !== "\0" && $yych !== $quote) {
33	190	if ($yych === "\\") {
34	49	$yych = $YYBUFFER[++$YYCURSOR];
35	3	if ($yych !== $quote && $yych != "\\") {
36		$value .= "\\";
37		}
38	49	}
39	190	$value .= $yych;
40	190	$yych = $YYBUFFER[++$YYCURSOR];

Ariadne-CMS / ariadne

Push — master ( b6dbee...323036 )

sql_compiler::parse_orderby() C

Complexity

Size

Duplication

Code Coverage

How to fix Long Method Complexity

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