PHPSQLParser\PHPSQLCreator::create PHP Method

create() public method

public create ( $parsed )
    public function create($parsed)
    {
        $k = key($parsed);
        switch ($k) {
            case 'UNION':
                $builder = new UnionStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            case 'UNION ALL':
                $builder = new UnionAllStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            case 'SELECT':
                $builder = new SelectStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            case 'INSERT':
                $builder = new InsertStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            case 'REPLACE':
                $builder = new ReplaceStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            case 'DELETE':
                $builder = new DeleteStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            case 'TRUNCATE':
                $builder = new TruncateStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            case 'UPDATE':
                $builder = new UpdateStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            case 'RENAME':
                $builder = new RenameStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            case 'SHOW':
                $builder = new ShowStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            case 'CREATE':
                $builder = new CreateStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            case 'BRACKET':
                $builder = new BracketStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            case 'DROP':
                $builder = new DropStatementBuilder();
                $this->created = $builder->build($parsed);
                break;
            default:
                throw new UnsupportedFeatureException($k);
                break;
        }
        return $this->created;
    }

Usage Example

Example #1
0
 public function testIssue101()
 {
     $sql = "SELECT tab.col AS `tab.col`, tab2.col AS `tab2.col` FROM tab, tab2";
     $parser = new PHPSQLParser($sql);
     $p = $parser->parsed;
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue101.sql', false);
     $this->assertSame($expected, $created, 'alias with quotes');
 }
All Usage Examples Of PHPSQLParser\PHPSQLCreator::create