Skip to content

Commit 0482290

Browse files
webdevelwebdevel
committed
Merge branch 'feature-add-sql-keyword-data' into develop
2 parents 95d62fe + f53bc94 commit 0482290

File tree

6 files changed

+1861
-3
lines changed

6 files changed

+1861
-3
lines changed

‎STRUCTURE.md

Lines changed: 1 addition & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -19,6 +19,7 @@ Parts in all capitol letters are KEYWORDS, RESERVED WORDS or FUNCTIONS.
1919
- CREATE
2020
- ASSERTION
2121
- CHARACTER SET
22+
- CAST
2223
- COLLATION
2324
- DOMAIN
2425
- ORDERING
@@ -47,13 +48,10 @@ Parts in all capitol letters are KEYWORDS, RESERVED WORDS or FUNCTIONS.
4748
- TYPE
4849
- VIEW
4950
- GRANT
50-
- ROLE
5151
- REVOKE
5252
- Data
5353
- CLOSE
54-
- CURSOR
5554
- DECLARE
56-
- CURSOR
5755
- LOCAL TEMPORARY TABLE
5856
- FETCH
5957
- NEXT

‎data/MANIFEST.md

Lines changed: 19 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,19 @@
1+
# Data File Manifest
2+
This manifest provides at least the following information for each data file.
3+
- Brief description of the file contents
4+
- Filename including path relative to this project root directory
5+
- Source URL reference to where the data originated or is derived from
6+
7+
## Data Files
8+
- SQL keywords derived from `language-sql` Atom package. Keywords are delimited by a new-line `\n`
9+
- data/atom-language-sql-keywords.txt
10+
- https://github.com/atom/language-sql/blob/master/grammars/sql.cson
11+
- SQL keywords selected from other SQL data files for `autocomplete-sql` Atom package. Keywords are delimited by a new-line `\n`
12+
- data/autocomplete-sql-keywords.txt
13+
- https://github.com/webdevel/autocomplete-sql
14+
- SQL keywords derived from SQL 1999 specification document. Keywords are delimited by a new-line `\n`
15+
- data/sql-1999-keywords.txt
16+
- http://web.cecs.pdx.edu/~len/sql1999.pdf
17+
- SQL keywords derived from MySQL 5.7 documentation. Keywords are delimited by a new-line `\n`
18+
- data/mysql-5.7-keywords.txt
19+
- https://dev.mysql.com/doc/refman/5.7/en/keywords.html

‎data/atom-language-sql-keywords.txt

Lines changed: 209 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,209 @@
1+
ABS
2+
ACOS
3+
ADD
4+
AGGREGATE
5+
ALL
6+
ALTER
7+
AND
8+
AS
9+
ASC
10+
ASIN
11+
ATAN
12+
ATAN2
13+
AUTO_INCREMENT
14+
AVG
15+
BEGIN
16+
BETWEEN
17+
BIGINT
18+
BIGSERIAL
19+
BIT
20+
BOOLEAN
21+
BOX
22+
BYTE
23+
CASCADE
24+
CASE
25+
CEIL
26+
CEILING
27+
CHAR
28+
CHARACTER
29+
CHECK
30+
CIDR
31+
CIRCLE
32+
CLASS
33+
COALESCE
34+
COLUMN
35+
COMMENT
36+
COMMIT WORK
37+
CONCATENATE
38+
CONSTRAINT
39+
CONV
40+
CONVERSION
41+
CONVERT
42+
COS
43+
COT
44+
COUNT
45+
CRC32
46+
CREATE
47+
CROSS JOIN
48+
CUME_DIST
49+
CURRENT_DATE
50+
DATABASE
51+
DATE
52+
DATETIME
53+
DECIMAL
54+
DECLARE
55+
DEFAULT
56+
DEGREES
57+
DELETE
58+
DENSE_RANK
59+
DESC
60+
DISTINCT
61+
DOMAIN
62+
DOUBLE
63+
DROP
64+
ELSE
65+
END
66+
ENUM
67+
EXCEPT
68+
EXEC
69+
EXISTS
70+
EXP
71+
EXTRACT
72+
FIRST_VALUE
73+
FLOAT
74+
FLOOR
75+
FOREIGN
76+
FROM
77+
FUNCTION
78+
GO
79+
GRANT
80+
GROUP
81+
GROUP BY
82+
HAVING
83+
IF
84+
IGNORE
85+
IN
86+
INDEX
87+
INET
88+
INNER
89+
INSERT
90+
INT
91+
INTEGER
92+
INTERSECT
93+
INTERVAL
94+
INTO
95+
IS
96+
JOIN
97+
KEY
98+
LAG
99+
LANGUAGE
100+
LAST_VALUE
101+
LEAD
102+
LEFT
103+
LIKE
104+
LIMIT
105+
LINE
106+
LN
107+
LOG
108+
LOG10
109+
LOG2
110+
LOWER
111+
LSEG
112+
MACADDR
113+
MAX
114+
MIN
115+
MOD
116+
MONEY
117+
NATURAL
118+
NOT
119+
NTH_VALUE
120+
NTILE
121+
NULL
122+
NULLIF
123+
NUMBER
124+
NUMERIC
125+
NVL
126+
OFFSET
127+
OID
128+
ON
129+
OPENQUERY
130+
OPERATOR
131+
OPTION
132+
OR
133+
ORDER BY
134+
OUT
135+
OUTER JOIN
136+
OVER
137+
PARTITION BY
138+
PATH
139+
PERCENT_RANK
140+
PI
141+
POINT
142+
POLYGON
143+
POW
144+
POWER
145+
PRECISION
146+
PRIMARY
147+
RADIANS
148+
RAND
149+
RANK
150+
REAL
151+
REFERENCES
152+
REGEXP
153+
REPLACE
154+
REVOKE
155+
RIGHT
156+
RLIKE
157+
ROLLBACK WORK
158+
ROUND
159+
ROW_NUMBER
160+
RULE
161+
SCHEMA
162+
SELECT
163+
SEQUENCE
164+
SERIAL
165+
SESSION
166+
SET
167+
SIGN
168+
SIN
169+
SMALLINT
170+
SQRT
171+
STAMP
172+
START TRANSACTION
173+
STRAIGHT_JOIN
174+
SUBSTRING
175+
SUM
176+
SYSDATE
177+
SYSTEM_USER
178+
TABLE
179+
TABLE
180+
SPACE
181+
TAN
182+
TEXT
183+
THEN
184+
TIME
185+
TIMESTAMP
186+
TINYINT
187+
TRANSLATE
188+
TRIGGER
189+
TRIM
190+
TRUNCATE
191+
TYPE
192+
TZ
193+
UNION
194+
UNIQUE
195+
UPDATE
196+
UPPER
197+
USE
198+
USER
199+
USING
200+
VALUES
201+
VAR
202+
VARCHAR
203+
VARYING
204+
VIEW
205+
WHEN
206+
WHERE
207+
WITH
208+
WORK
209+
ZONE

0 commit comments

Comments
 (0)