wazaari\MySQLParser\MySQLParser::parseFile()

Complexity

Conditions	13
Paths	17

Size

Total Lines	100
Code Lines	48

Duplication

Lines	0
Ratio	0 %

Importance

Changes	3
Bugs	0	Features	1

<?php
    public function parseFile($file, $defaultDelimiter = ";", $appendDelimiterCommand = false)
    {
        $currentDelimiter = $defaultDelimiter;

        //Try to open File
        if (!file_exists($file)) {
            throw new \Exception('Unable to open file \'' . $file .'\': File not found');
        }
        try {
            $handle = fopen($file, "r");
        } catch (\Exception $e) {
            throw new \Exception('Unable to open file \'' . $file .'\': File was found but unknown error occured.');
        }

        //Initialize result array
        $_lineArray = array();

        //Initialize multi-line cache
        $multiLineCommand = null;

        //Read file by line and watch out for DELIMITER clauses
        while (($line = fgets($handle)) !== false) {
            //Remove unneccessary whitespaces
            $line = trim($line);

            //if line starts with "--", it is a comment. Ignore
            if ($this->startsWith($line, "--")) {
                continue;
            }

            //Check if line starts with DELIMITER and extract it
            if ($this->startsWith($line, $this->delimiterString)) {
                $currentDelimiter = trim(substr($line, strlen($this->delimiterString)));
                if ($appendDelimiterCommand === true) {
                    $_lineArray[] = array(
                        'command' => $this->delimiterString . ' ' . $currentDelimiter,
                        'delimiter' => null,
                    );
                }
                continue;
            }

            //Otherwise, this is a normal line
            //Extract commands and save them to array
            $instructions = array_map(
                'trim',
                array_filter(preg_split('~\\\\.(*SKIP)(*FAIL)|'.$currentDelimiter.'~s', $line))
            );

            //When there is no instruction (empty line) --> continue with next
            if (count($instructions) == 0) {
                continue;
            }

            /**
             * If the current multi-line cache is not null, all commands up to the next delimiter
             * belong to this command
             */
            if ($multiLineCommand !== null) {
                $firstCommand = array_shift($instructions);
                // If this is the only instruction here and there is no Delimiter
                // append to current file cache and continue. Else write to array and continue with next line
                // Otherwise write to array and proceed with this line
                if (count($instructions) == 0) {
                    if (substr($line, -strlen($currentDelimiter)) == $currentDelimiter) {
                        $_lineArray[] = array(
                            'command' => $multiLineCommand . ' ' . $firstCommand,
                            'delimiter' => $currentDelimiter
                        );
                        $multiLineCommand = null;
                        continue;
                    } else {
                        $multiLineCommand .= ' ' . $firstCommand;
                        continue;
                    }
                } else {
                    $multiLineCommand .= ' ' . $firstCommand;
                }
            }

            /**
             * If line does not end with delimiter, the last element of the array belongs
             * to a multi-line command
             */
            if (substr($line, -strlen($currentDelimiter)) != $currentDelimiter) {
                $multiLineCommand = array_pop($instructions);
            }

            //Proceed with all other instructions as usual
            foreach ($instructions as $i) {
                $_lineArray[] = array(
                    'command' => $i,
                    'delimiter' => $currentDelimiter
                );
            }
        }

        fclose($handle);
        return $_lineArray;
    }