FilesExpand file tree

develop

/

SQLParser.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

59 lines (52 loc) · 1.97 KB

develop

/

SQLParser.php

Copy path

Top

File metadata and controls

• Code
• Blame

59 lines (52 loc) · 1.97 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

54

55

56

57

58

59

<?php

/*

* The MIT License (MIT)

*

* Copyright (c) 2015-2021 César Rodas

*

* Permission is hereby granted, free of charge, to any person obtaining a copy

* of this software and associated documentation files (the "Software"), to deal

* in the Software without restriction, including without limitation the rights

* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell

* copies of the Software, and to permit persons to whom the Software is

* furnished to do so, subject to the following conditions:

* -

* The above copyright notice and this permission notice shall be included in

* all copies or substantial portions of the Software.

* -

* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR

* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,

* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE

* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER

* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,

* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN

* THE SOFTWARE.

*/

class SQLParser

{

public function parse($text)

{

$lexer = new SQLParser\Lexer($text);

$parser = new SQLParser_Parser();

$comments = [];

$stmt = 0;

while ($lexer->hasNextToken()) {

switch ($lexer->token) {

case 'comment':

$comments[$stmt][] = trim(trim($lexer->value, '-/*'));

continue 2;

case SQLParser_Parser::T_SEMICOLON:

++$stmt;

break;

}

$parser->doParse($lexer->token, $lexer->value);

}

$parser->doParse(0, 0);

foreach ($parser->body as $id => $stmt) {

if (!empty($comments[$id]) && $stmt) {

$stmt->setComments($comments[$id]);

}

}

return $parser->body;

}

}