GeezerVison is showing github.com — sqlFormatter/sqlFormatter.php at master · nicoder/sqlFormatter

Expand file tree

sqlFormatter.php

Copy path

More file actions

Latest commit

History

53 lines (46 loc) · 1.05 KB

sqlFormatter.php

Copy path

File metadata and controls

53 lines (46 loc) · 1.05 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

<?php

class SqlFormatter

{

private $_select;

private $_from;

private $_where;

public function format($sql)

{

$this->_separateSelectAndFrom($sql);

$this->_separateFromAndWhere();

$this->_formatFrom();

return $this->_assemble();

}

private function _formatFrom()

{

$this->_from = str_ireplace(' left join', "\nLEFT JOIN", $this->_from);

}

private function _assemble()

{

$result = $this->_select . "\n" . $this->_from;

if ($this->_where) {

$result .= "\n" . $this->_where;

}

return $result;

}

private function _separateSelectAndFrom($sql)

{

$a = $this->_separate($sql, 'FROM');

$this->_select = str_ireplace('select', 'SELECT', $a[0]);

$this->_from = $a[1];

}

private function _separateFromAndWhere()

{

$a = $this->_separate($this->_from, 'WHERE');

$this->_from = $a[0];

$this->_where = $a[1];

}

private function _separate($sql, $keyWord)

{

$a = preg_split('/' . $keyWord . '/i', $sql);

if (!isset($a[1])) {

return array($sql, '');

}

return array(trim($a[0]), strtoupper($keyWord) . ' ' . trim($a[1]));

}