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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
|
<?php
// Loads the SQL lexer and parser, which are used to parse this error to detect
// any errors.
require_once 'libraries/sql-parser/autoload.php';
/**
* Gets the starting position of each line.
*
* @param string $str String to be analyzed.
*
* @return array
*/
function getLines($str)
{
$lines = array(0);
for ($i = 0, $len = strlen($str); $i < $len; ++$i) {
if ($str[$i] === "\n") {
$lines[] = $i;
}
}
return $lines;
}
/**
* Computes the number of the line and column given an absolute position.
*
* @param array $lines The starting position of each line.
* @param int $pos The absolute position
*
* @return void
*/
function findLineNumberAndColumn($lines, $pos)
{
$line = 0;
foreach ($lines as $lineNo => $lineStart) {
if ($lineStart >= $pos) {
break;
}
$line = $lineNo;
}
return array($line, $pos - $lines[$line]);
}
/**
* Runs the linting process.
*
* @param string $query The query to be checked.
*
* @return void
*/
function linter($query)
{
// Disabling lint for huge queries to save some resources.
if (strlen($query) > 10000) {
echo json_encode(
array(
array(
'message' => 'The linting is disabled for this query because it exceededs the maxmimum length',
'fromLine' => 0,
'fromColumn' => 0,
'toLine' => 0,
'toColumn' => 0,
'severity' => 'warning',
)
)
);
return;
}
/**
* Lexer used for tokenizing the query.
*
* @var SqlParser\Lexer
*/
$lexer = new SqlParser\Lexer($query);
/**
* Parsed used for analysing the query.
*
* @var SqlParser\Parser
*/
$parser = new SqlParser\Parser($lexer->list);
/**
* Array containing all errors.
*
* @var array
*/
$errors = SqlParser\Utils\Error::get(array($lexer, $parser));
/**
* The response containing of all errors.
*
* @var array
*/
$response = array();
/**
* The starting position for each line.
*
* CodeMirror requires relative position to line, but the parser stores
* only the absolute position of the character in string.
*
* @var array
*/
$lines = getLines($query);
// Building the response.
foreach ($errors as $idx => $error) {
// Starting position of the string that caused the error.
list($fromLine, $fromColumn) = findLineNumberAndColumn(
$lines, $error[3]
);
// Ending position of the string that caused the error.
list($toLine, $toColumn) = findLineNumberAndColumn(
$lines, $error[3] + strlen($error[2])
);
// Building the response.
$response[] = array(
'message' => $error[0] . ' (near ' . $error[2] . ')',
'fromLine' => $fromLine,
'fromColumn' => $fromColumn,
'toLine' => $toLine,
'toColumn' => $toColumn,
'severity' => 'error',
);
}
// Sending back the answer.
echo json_encode($response);
}
linter($_REQUEST['sql_query']);
|
