FilesExpand file tree

master

/

sqlFormatter.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

53 lines (46 loc) · 1.05 KB

master

/

sqlFormatter.php

Copy path

Top

File metadata and controls

• Code
• Blame

53 lines (46 loc) · 1.05 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

<?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]));

}

}