/** * It parses the given SQL statement and generates a detailled * output array for every part of the statement. The method can * also generate [position] fields within the output, which hold * the character position for every statement part. The calculation * of the positions needs some time, if you don't need positions in * your application, set the parameter to false. * * @param String $sql The SQL statement. * @param boolean $calcPositions True, if the output should contain [position], false otherwise. * * @return array An associative array with all meta information about the SQL statement. */ public function parse($sql, $calcPositions = false) { $processor = new DefaultProcessor(); $queries = $processor->process($sql); // calc the positions of some important tokens if ($calcPositions) { $calculator = new PositionCalculator(); $queries = $calculator->setPositionsWithinSQL($sql, $queries); } // store the parsed queries $this->parsed = $queries; return $this->parsed; }
public function parse($sql, $calcPositions = false) { #lex the SQL statement $inputArray = $this->split_sql($sql); #This is the highest level lexical analysis. This is the part of the #code which finds UNION and UNION ALL query parts $queries = $this->processUnion($inputArray); # If there was no UNION or UNION ALL in the query, then the query is # stored at $queries[0]. if (!$this->isUnion($queries)) { $queries = $this->processSQL($queries[0]); } # calc the positions of some important tokens if ($calcPositions) { $calculator = new PositionCalculator(); $queries = $calculator->setPositionsWithinSQL($sql, $queries); } # store the parsed queries $this->parsed = $queries; return $this->parsed; }