BigShark\SQLToBuilder\BuilderClass

Complexity

Total Complexity

7

Size/Duplication

Total Lines	70
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

100%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	7	1
B	convert()	0	31	6

<?php

namespace BigShark\SQLToBuilder;

use BigShark\SQLToBuilder\Converter\Factory;
use PHPSQLParser\PHPSQLParser;

class BuilderClass
{
    /**
     * @var string
     */
    protected $sql;

    /**
     * @var PHPSQLParser
     */
    protected $sqlParser;

    /**
     * @var Factory
     */
    protected $converterFactory;

    /**
     * @var Generator
     */
    protected $generator;

    /**
     * @param string $sql
     */
    public function __construct($sql)
    {
        $this->sql = $sql;
        $this->sqlParser = new PHPSQLParser();
        $this->converterFactory = new Factory();
        $this->generator = new Generator('DB');
    }

    /**
     * @throws \Exception
     *
     * @return string
     */
    public function convert()
    {
        $parsed = $this->sqlParser->parse($this->sql);

        if (false === $parsed) {
            throw new \Exception('SQL query is not valid');
        }

        $results = [];
        foreach ($parsed as $section => $data) {
            if ($this->converterFactory->canCreate($section)) {
                $converter = $this->converterFactory->create($section);
                $results = array_merge($results, $converter->convert($data));
            }
        }

        $table = current(array_filter($results, function ($item) {
            return 'table' === $item['name'];
        }));
        unset($results[array_search($table, $results)]);
        array_unshift($results, $table);

        foreach ($results as $function) {
            $args = isset($function['args']) ? $function['args'] : [];
            $this->generator->addFunction($function['name'], $args);
        }

        $this->generator->addFunction('get');

        return $this->generator->generate();
    }
}