|
1
|
|
|
<?php |
|
2
|
|
|
/** |
|
3
|
|
|
* Highlighter |
|
4
|
|
|
* |
|
5
|
|
|
* Copyright (C) 2016, Some right reserved. |
|
6
|
|
|
* |
|
7
|
|
|
* @author Kacper "Kadet" Donat <[email protected]> |
|
8
|
|
|
* |
|
9
|
|
|
* Contact with author: |
|
10
|
|
|
* Xmpp: [email protected] |
|
11
|
|
|
* E-mail: [email protected] |
|
12
|
|
|
* |
|
13
|
|
|
* From Kadet with love. |
|
14
|
|
|
*/ |
|
15
|
|
|
|
|
16
|
|
|
namespace Kadet\Highlighter\Language; |
|
17
|
|
|
|
|
18
|
|
|
use Kadet\Highlighter\Matcher\CommentMatcher; |
|
19
|
|
|
use Kadet\Highlighter\Matcher\RegexMatcher; |
|
20
|
|
|
use Kadet\Highlighter\Matcher\WordMatcher; |
|
21
|
|
|
use Kadet\Highlighter\Parser\Rule; |
|
22
|
|
|
|
|
23
|
|
|
class Sql extends GreedyLanguage |
|
24
|
|
|
{ |
|
25
|
|
|
|
|
26
|
|
|
protected $_keywords = [ |
|
27
|
|
|
'ADD', 'ALL', 'ALLOCATE', 'ALTER', 'AND', 'ANY', 'ARE', 'AS', 'ASENSITIVE', 'ASYMMETRIC', 'AT', |
|
28
|
|
|
'ATOMIC', 'AUTHORIZATION', 'BEGIN', 'BETWEEN', 'BOTH', 'BY', 'COMMENT', |
|
29
|
|
|
'CALL', 'CALLED', 'CASCADED', 'CASE', 'CAST', 'CHECK', 'CLOB', 'CLOSE', 'COLLATE', |
|
30
|
|
|
'COLUMN', 'COMMIT', 'CONDITION', 'CONNECT', 'CONSTRAINT', 'CONTINUE', 'CORRESPONDING', 'CREATE', |
|
31
|
|
|
'CROSS', 'CUBE', 'CURRENT', 'CURSOR', 'CYCLE', 'DEALLOCATE', 'DECLARE', 'DEFAULT', 'DELETE', |
|
32
|
|
|
'DEREF', 'DESCRIBE', 'DETERMINISTIC', 'DISCONNECT', 'DISTINCT', 'DO', 'DROP', 'DYNAMIC', |
|
33
|
|
|
'EACH', 'ELEMENT', 'ELSE', 'ELSEIF', 'END', 'ESCAPE', 'EXCEPT', 'EXEC', 'EXECUTE', 'EXISTS', 'EXIT', |
|
34
|
|
|
'EXTERNAL', 'FETCH', 'FILTER', 'FOR', 'FOREIGN', 'FREE', 'FROM', 'FULL', 'FUNCTION', |
|
35
|
|
|
'GET', 'GLOBAL', 'GRANT', 'GROUP', 'GROUPING', 'HANDLER', 'HAVING', 'HOLD', 'IDENTITY', 'IF', |
|
36
|
|
|
'IMMEDIATE', 'IN', 'INDICATOR', 'INNER', 'INOUT', 'INPUT', 'INSENSITIVE', 'INSERT', |
|
37
|
|
|
'INTERSECT', 'INTERVAL', 'INTO', 'IS', 'ITERATE', 'LANGUAGE', 'LARGE', 'LATERAL', 'LEADING', |
|
38
|
|
|
'LEAVE', 'LEFT', 'LIKE', 'LOCAL', 'LOOP', 'MATCH', 'MEMBER', 'MERGE', 'METHOD', 'MODIFIES', |
|
39
|
|
|
'MODULE', 'MONTH', 'MULTISET', 'NATIONAL', 'NATURAL', 'NCHAR', 'NCLOB', 'NEW', 'NO', 'NONE', 'NOT', |
|
40
|
|
|
'OF', 'OLD', 'ON', 'ONLY', 'OPEN', 'OR', 'ORDER', 'OUT','OUTER', 'OUTPUT', 'OVER', |
|
41
|
|
|
'OVERLAPS', 'PARAMETER', 'PARTITION', 'PRECISION', 'PREPARE', 'PRIMARY', 'PROCEDURE', 'RANGE', 'READS', |
|
42
|
|
|
'RECURSIVE', 'REF', 'REFERENCES', 'REFERENCING', 'RELEASE', |
|
43
|
|
|
'REPEAT', 'RESIGNAL', 'RESULT', 'RETURN', 'RETURNS', 'REVOKE', 'RIGHT', 'ROLLBACK', 'ROLLUP', 'ROW', |
|
44
|
|
|
'ROWS', 'SAVEPOINT', 'SCOPE', 'SCROLL', 'SEARCH', 'SECOND', 'SELECT', 'SENSITIVE', 'SESSION_USER', |
|
45
|
|
|
'SET', 'SIGNAL', 'SIMILAR', 'SOME', 'SPECIFIC', 'SPECIFICTYPE', 'SQL', 'SQLEXCEPTION', |
|
46
|
|
|
'SQLSTATE', 'SQLWARNING', 'START', 'STATIC', 'SUBMULTISET', 'SYMMETRIC', 'SYSTEM', 'SYSTEM_USER', |
|
47
|
|
|
'TABLE', 'TABLESAMPLE', 'THEN', 'TO', 'TRAILING', 'TRANSLATION', 'TREAT', 'TRIGGER', 'UNDO', 'UNION', |
|
48
|
|
|
'UNIQUE', 'UNKNOWN', 'UNNEST', 'UNTIL', 'UPDATE', 'USER', 'USING', 'VALUE', 'VALUES', 'VARYING', 'WHEN', |
|
49
|
|
|
'WHENEVER', 'WHERE', 'WHILE', 'WINDOW', 'WITH', 'WITHIN', 'WITHOUT', 'KEY', 'ACTION' |
|
50
|
|
|
]; |
|
51
|
|
|
|
|
52
|
|
|
protected $_types = [ |
|
53
|
|
|
'ARRAY', 'BIGINT', 'BINARY', 'BIT', 'BLOB', 'BOOLEAN', 'CHAR', 'CHARACTER', 'DATE', |
|
54
|
|
|
'DEC', 'DECIMAL', 'FLOAT', 'INT', 'INTEGER', 'INTERVAL', 'NUMBER', 'NUMERIC', 'REAL', |
|
55
|
|
|
'SERIAL', 'SMALLINT', 'VARCHAR', 'VARYING', 'INT8', 'SERIAL8', 'TEXT' |
|
56
|
|
|
]; |
|
57
|
|
|
|
|
58
|
|
|
/** |
|
59
|
|
|
* Tokenization rules |
|
60
|
|
|
*/ |
|
61
|
|
|
public function setupRules() |
|
62
|
|
|
{ |
|
63
|
|
|
$this->rules->addMany([ |
|
64
|
|
|
'keyword' => new Rule(new WordMatcher($this->_keywords, ['escape' => false])), |
|
65
|
|
|
'symbol.type' => new Rule(new WordMatcher($this->_types, ['escape' => false])), |
|
66
|
|
|
|
|
67
|
|
|
'constant' => new Rule(new WordMatcher(['FALSE', 'TRUE', 'NULL'])), |
|
68
|
|
|
'comment' => new Rule(new CommentMatcher(['#', '--'], [['/*', '*/']])), |
|
69
|
|
|
|
|
70
|
|
|
'string' => CommonFeatures::strings(['single' => '\'', 'double' => '"']), |
|
71
|
|
|
|
|
72
|
|
|
'number' => new Rule(new RegexMatcher('/\b(-?\d+)\b/i')), |
|
73
|
|
|
'call' => new Rule(new RegexMatcher('/([a-z_]\w*)\s*\(/i'), ['priority' => -1]), |
|
74
|
|
|
'operator.escape' => new Rule(new RegexMatcher('/(\\[\\0\'|bnrtZ%_])/'), ['context' => ['string']]) |
|
75
|
|
|
]); |
|
76
|
|
|
} |
|
77
|
|
|
|
|
78
|
|
|
/** {@inheritdoc} */ |
|
79
|
|
|
public function getIdentifier() |
|
80
|
|
|
{ |
|
81
|
|
|
return 'sql'; |
|
82
|
|
|
} |
|
83
|
|
|
|
|
84
|
|
View Code Duplication |
public static function getMetadata() |
|
85
|
|
|
{ |
|
86
|
|
|
return [ |
|
87
|
|
|
'name' => ['sql'], |
|
88
|
|
|
'mime' => ['text/x-sql'], |
|
89
|
|
|
'extension' => ['*.sql'] |
|
90
|
|
|
]; |
|
91
|
|
|
} |
|
92
|
|
|
} |
|
93
|
|
|
|
kadet1090 /
KeyLighter
