File Coverage

blib/lib/Text/Highlight/SQL.pm

Criterion	Covered	Total	%
statement	4	4	100.0
branch			n/a
condition			n/a
subroutine	2	2	100.0
pod	0	1	0.0
total	6	7	85.7

line	stmt	sub	pod	time	code
1					package Text::Highlight::SQL;
2	1	1		6	use strict;
	1			1
	1			1685
3
4					sub syntax
5					{
6					return {
7	1	1	0	380	'key5' => {
8					'int' => 1,
9					'bit' => 1,
10					'varchar' => 1,
11					'nvarchar' => 1,
12					'money' => 1,
13					'datetime' => 1,
14					'double' => 1,
15					'float' => 1,
16					'text' => 1,
17					'smallmoney' => 1,
18					'smallint' => 1,
19					'nchar' => 1,
20					'real' => 1,
21					'varbinary' => 1,
22					'tinyint' => 1,
23					'binary' => 1,
24					'smalldatetime' => 1,
25					'image' => 1,
26					'bigint' => 1,
27					'char' => 1,
28					'numeric' => 1,
29					'decimal' => 1
30					},
31					'key6' => {
32					'system' => 1,
33					'sysindexes' => 1,
34					'sysusers' => 1,
35					'systypes' => 1,
36					'sysdepends' => 1,
37					'syssegments' => 1,
38					'syscomments' => 1,
39					'syscolumns' => 1,
40					'sysconstraints' => 1,
41					'sysreferences' => 1,
42					'sysprotects' => 1,
43					'sysalternates' => 1,
44					'sysobjects' => 1
45					},
46					'name' => 'ANSI_SQL',
47					'case' => 0,
48					'blockCommentOn' => [
49					'/*'
50					],
51					'key3' => {
52					'sp_dropdevice' => 1,
53					'sp_helplog' => 1,
54					'sp_special_columns' => 1,
55					'sp_remoteoption' => 1,
56					'sp_validlang' => 1,
57					'sp_processmail' => 1,
58					'sp_revokelogin' => 1,
59					'sp_droplogin' => 1,
60					'sp_unbindefault' => 1,
61					'sp_recompile' => 1,
62					'sp_addmessage' => 1,
63					'sp_server_info' => 1,
64					'xp_enumgroups' => 1,
65					'sp_defaultdb' => 1,
66					'sp_table_privileges' => 1,
67					'sp_stored_procedures' => 1,
68					'sp_datatype_info' => 1,
69					'sp_rename' => 1,
70					'sp_monitor' => 1,
71					'xp_logevent' => 1,
72					'sp_sproc_columns' => 1,
73					'sp_fixindex' => 1,
74					'sp_diskdefault' => 1,
75					'sp_helptext' => 1,
76					'sp_dropserver' => 1,
77					'sp_helpsort' => 1,
78					'sp_grantlogin' => 1,
79					'sp_helpuser' => 1,
80					'xp_sendmail' => 1,
81					'sp_addgroup' => 1,
82					'xp_readmail' => 1,
83					'sp_changedbowner' => 1,
84					'sp_password' => 1,
85					'sp_serveroption' => 1,
86					'sp_helpremotelogin' => 1,
87					'sp_statistics' => 1,
88					'sp_addalias' => 1,
89					'sp_dropalias' => 1,
90					'sp_defaultlanguage' => 1,
91					'sp_helpconstraint' => 1,
92					'sp_altermessage' => 1,
93					'sp_droptype' => 1,
94					'sp_addserver' => 1,
95					'sp_pkeys' => 1,
96					'sp_unbindrule' => 1,
97					'sp_checknames' => 1,
98					'xp_startmail' => 1,
99					'sp_who' => 1,
100					'xp_stopmail' => 1,
101					'sp_helprotect' => 1,
102					'sp_addremotelogin' => 1,
103					'xp_deletemail' => 1,
104					'sp_bindrule' => 1,
105					'sp_addextendedproc' => 1,
106					'sp_addlogin' => 1,
107					'sp_dropextendedproc' => 1,
108					'sp_helpdb' => 1,
109					'sp_helpdevice' => 1,
110					'sp_spaceused' => 1,
111					'sp_helplanguage' => 1,
112					'sp_addtype' => 1,
113					'sp_logdevice' => 1,
114					'sp_helpextendedproc' => 1,
115					'sp_configure' => 1,
116					'sp_fkeys' => 1,
117					'sp_helpindex' => 1,
118					'sp_adduser' => 1,
119					'sp_helpserver' => 1,
120					'sp_renamedb' => 1,
121					'sp_changegroup' => 1,
122					'sp_dropuser' => 1,
123					'sp_depends' => 1,
124					'sp_dropgroup' => 1,
125					'sp_dboption' => 1,
126					'sp_column_privileges' => 1,
127					'sp_lock' => 1,
128					'sp_who2' => 1,
129					'xp_cmdshell' => 1,
130					'sp_addumpdevice' => 1,
131					'sp_dropremotelogin' => 1,
132					'sp_tables' => 1,
133					'sp_bindefault' => 1,
134					'sp_databases' => 1,
135					'sp_columns' => 1,
136					'sp_helpgroup' => 1,
137					'xp_findnextmsg' => 1,
138					'sp_dropmessage' => 1,
139					'sp_help' => 1
140					},
141					'key2' => {
142					'outer' => 1,
143					'/' => 1,
144					'=' => 1,
145					'*' => 1,
146					'not' => 1,
147					'all' => 1,
148					'-' => 1,
149					'like' => 1,
150					'or' => 1,
151					'in' => 1,
152					'.' => 1,
153					'<' => 1,
154					'!' => 1,
155					'between' => 1,
156					'\|\|' => 1,
157					'%' => 1,
158					'>' => 1,
159					'any' => 1,
160					'+' => 1,
161					'join' => 1,
162					'null' => 1,
163					')' => 1,
164					'some' => 1,
165					'exists' => 1,
166					'and' => 1,
167					'(' => 1
168					},
169					'lineComment' => [
170					'--'
171					],
172					'delimiters' => ',()-+*/="\'!<>:.',
173					'key4' => {
174					'sqrt' => 1,
175					'patindex' => 1,
176					'floor' => 1,
177					'coalesce' => 1,
178					'@@total_write' => 1,
179					'degrees' => 1,
180					'power' => 1,
181					'day' => 1,
182					'sum' => 1,
183					'atan' => 1,
184					'sign' => 1,
185					'ltrim' => 1,
186					'index_col' => 1,
187					'datalength' => 1,
188					'count' => 1,
189					'str' => 1,
190					'indexproperty' => 1,
191					'abs' => 1,
192					'dateadd' => 1,
193					'@@trancount' => 1,
194					'lower' => 1,
195					'textptr' => 1,
196					'host_name' => 1,
197					'@@cursor_rows' => 1,
198					'user_id' => 1,
199					'month' => 1,
200					'datepart' => 1,
201					'round' => 1,
202					'@@dbts' => 1,
203					'@@max_connections' => 1,
204					'case' => 1,
205					'nullif' => 1,
206					'col_length' => 1,
207					'@@cpu_busy' => 1,
208					'@@max_precision' => 1,
209					'asin' => 1,
210					'charindex' => 1,
211					'rtrim' => 1,
212					'@@nestlevel' => 1,
213					'suser_id' => 1,
214					'@@pack_sent' => 1,
215					'@@remserver' => 1,
216					'avg' => 1,
217					'host_id' => 1,
218					'@@datefirst' => 1,
219					'right' => 1,
220					'ascii' => 1,
221					'datediff' => 1,
222					'db_id' => 1,
223					'getutcdate' => 1,
224					'year' => 1,
225					'left' => 1,
226					'@@pack_received' => 1,
227					'@@idle' => 1,
228					'@@textsize' => 1,
229					'soundex' => 1,
230					'@@timeticks' => 1,
231					'textvalid' => 1,
232					'replicate' => 1,
233					'@@servicename' => 1,
234					'user' => 1,
235					'getdate' => 1,
236					'@@version' => 1,
237					'exp' => 1,
238					'@@langid' => 1,
239					'ceiling' => 1,
240					'@@procid' => 1,
241					'user_name' => 1,
242					'datename' => 1,
243					'reverse' => 1,
244					'sin' => 1,
245					'replace' => 1,
246					'stuff' => 1,
247					'@@error' => 1,
248					'tan' => 1,
249					'@@spid' => 1,
250					'@@rowcount' => 1,
251					'cast' => 1,
252					'objectproperty' => 1,
253					'@@lock_timeout' => 1,
254					'@@io_busy' => 1,
255					'@@fetch_status' => 1,
256					'cos' => 1,
257					'log10' => 1,
258					'@@language' => 1,
259					'log' => 1,
260					'object_id' => 1,
261					'pi' => 1,
262					'substring' => 1,
263					'cot' => 1,
264					'atn2' => 1,
265					'isnull' => 1,
266					'@@total_errors' => 1,
267					'suser_name' => 1,
268					'convert' => 1,
269					'@@connections' => 1,
270					'radians' => 1,
271					'upper' => 1,
272					'rand' => 1,
273					'col_name' => 1,
274					'acos' => 1,
275					'space' => 1,
276					'@@options' => 1,
277					'@@identity' => 1,
278					'object_name' => 1,
279					'@@total_read' => 1,
280					'@@servername' => 1,
281					'@@packet_errors' => 1
282					},
283					'key1' => {
284					'insert' => 1,
285					'absolute' => 1,
286					'statistics' => 1,
287					'file' => 1,
288					'tsequal' => 1,
289					'print' => 1,
290					'loop' => 1,
291					'key' => 1,
292					'init' => 1,
293					'if' => 1,
294					'save' => 1,
295					'view' => 1,
296					'constraint' => 1,
297					'load' => 1,
298					'unique' => 1,
299					'relative' => 1,
300					'isolation' => 1,
301					'unload' => 1,
302					'name' => 1,
303					'clustered' => 1,
304					'open' => 1,
305					'hash' => 1,
306					'commit' => 1,
307					'prior' => 1,
308					'delete' => 1,
309					'override' => 1,
310					'privileges' => 1,
311					'cursor' => 1,
312					'time' => 1,
313					'of' => 1,
314					'mirror' => 1,
315					'rule' => 1,
316					'is' => 1,
317					'asc' => 1,
318					'procedure' => 1,
319					'when' => 1,
320					'noinit' => 1,
321					'vdevno' => 1,
322					'cascade' => 1,
323					'truncate' => 1,
324					'last' => 1,
325					'concat' => 1,
326					'dbcc' => 1,
327					'where' => 1,
328					'execute' => 1,
329					'index' => 1,
330					'char' => 1,
331					'update' => 1,
332					'checktable' => 1,
333					'remove' => 1,
334					'next' => 1,
335					'checkalloc' => 1,
336					'off' => 1,
337					'dbrepair' => 1,
338					'kill' => 1,
339					'proc' => 1,
340					'order' => 1,
341					'transaction' => 1,
342					'fetch' => 1,
343					'unmirror' => 1,
344					'noexec' => 1,
345					'escape' => 1,
346					'reconfigure' => 1,
347					'only' => 1,
348					'traceoff' => 1,
349					'returns' => 1,
350					'values' => 1,
351					'readtext' => 1,
352					'full' => 1,
353					'by' => 1,
354					'declare' => 1,
355					'nowait' => 1,
356					'columns' => 1,
357					'ignore_dup_key' => 1,
358					'checkcatalog' => 1,
359					'trigger' => 1,
360					'fillfactor' => 1,
361					'add' => 1,
362					'checkdb' => 1,
363					'drop_existing' => 1,
364					'tran' => 1,
365					'close' => 1,
366					'check' => 1,
367					'public' => 1,
368					'option' => 1,
369					'goto' => 1,
370					'select' => 1,
371					'checkpoint' => 1,
372					'while' => 1,
373					'as' => 1,
374					'fast' => 1,
375					'blocksize' => 1,
376					'serializable' => 1,
377					'percent' => 1,
378					'table' => 1,
379					'schema' => 1,
380					'writetext' => 1,
381					'on' => 1,
382					'desc' => 1,
383					'inner' => 1,
384					'traceon' => 1,
385					'distinct' => 1,
386					'truncate_only' => 1,
387					'break' => 1,
388					'waitfor' => 1,
389					'output' => 1,
390					'quoted_identifier' => 1,
391					'level' => 1,
392					'mirrorexit' => 1,
393					'top' => 1,
394					'physname' => 1,
395					'with' => 1,
396					'union' => 1,
397					'no_log' => 1,
398					'function' => 1,
399					'delay' => 1,
400					'drop' => 1,
401					'into' => 1,
402					'size' => 1,
403					'to' => 1,
404					'group' => 1,
405					'holdlock' => 1,
406					'sorted_data' => 1,
407					'references' => 1,
408					'from' => 1,
409					'set' => 1,
410					'prepare' => 1,
411					'create' => 1,
412					'stripe' => 1,
413					'vstart' => 1,
414					'work' => 1,
415					'database' => 1,
416					'identity_insert' => 1,
417					'then' => 1,
418					'parseonly' => 1,
419					'compute' => 1,
420					'nonclustered' => 1,
421					'headeronly' => 1,
422					'max' => 1,
423					'nocount' => 1,
424					'authorization' => 1,
425					'processexit' => 1,
426					'showplan' => 1,
427					'shutdown' => 1,
428					'alter' => 1,
429					'read' => 1,
430					'setuser' => 1,
431					'io' => 1,
432					'nounload' => 1,
433					'exec' => 1,
434					'offsets' => 1,
435					'dateformat' => 1,
436					'for' => 1,
437					'else' => 1,
438					'default' => 1,
439					'arithignore' => 1,
440					'end' => 1,
441					'foreign' => 1,
442					'continue' => 1,
443					'remirror' => 1,
444					'grant' => 1,
445					'browse' => 1,
446					'dump' => 1,
447					'disk' => 1,
448					'primary' => 1,
449					'rows' => 1,
450					'having' => 1,
451					'arithabort' => 1,
452					'rollback' => 1,
453					'use' => 1,
454					'merge' => 1,
455					'retaindays' => 1,
456					'at' => 1,
457					'current' => 1,
458					'revoke' => 1,
459					'begin' => 1,
460					'connect' => 1,
461					'first' => 1,
462					'recompile' => 1,
463					'min' => 1,
464					'return' => 1,
465					'deallocate' => 1
466					},
467					'quot' => [
468					'\''
469					],
470					'blockCommentOff' => [
471					'*/'
472					],
473					'continueQuote' => 1,
474					'escape' => '\\'
475					};
476					;
477					}
478
479					1;