1[
2 {"type":"CommentSingle","value":"-- basic statements\n// c-style comment\n"},
3 {"type":"CommentMultiline","value":"/* \n\n multiline comment\n\n*/"},
4 {"type":"TextWhitespace","value":"\n"},
5 {"type":"Keyword","value":"CREATE"},
6 {"type":"TextWhitespace","value":" "},
7 {"type":"Keyword","value":"TABLE"},
8 {"type":"TextWhitespace","value":" "},
9 {"type":"Name","value":"cycling"},
10 {"type":"Punctuation","value":"."},
11 {"type":"Name","value":"cyclist_name"},
12 {"type":"TextWhitespace","value":" "},
13 {"type":"Punctuation","value":"("},
14 {"type":"TextWhitespace","value":" "},
15 {"type":"Name","value":"id"},
16 {"type":"TextWhitespace","value":" "},
17 {"type":"NameBuiltin","value":"UUID"},
18 {"type":"TextWhitespace","value":" "},
19 {"type":"Keyword","value":"PRIMARY"},
20 {"type":"TextWhitespace","value":" "},
21 {"type":"Keyword","value":"KEY"},
22 {"type":"Punctuation","value":","},
23 {"type":"TextWhitespace","value":" "},
24 {"type":"Name","value":"lastname"},
25 {"type":"TextWhitespace","value":" "},
26 {"type":"NameBuiltin","value":"text"},
27 {"type":"Punctuation","value":","},
28 {"type":"TextWhitespace","value":" "},
29 {"type":"Name","value":"firstname"},
30 {"type":"TextWhitespace","value":" "},
31 {"type":"NameBuiltin","value":"text"},
32 {"type":"TextWhitespace","value":" "},
33 {"type":"Punctuation","value":");"},
34 {"type":"TextWhitespace","value":"\n"},
35 {"type":"Keyword","value":"INSERT"},
36 {"type":"TextWhitespace","value":" "},
37 {"type":"Keyword","value":"INTO"},
38 {"type":"TextWhitespace","value":" "},
39 {"type":"Name","value":"cycling"},
40 {"type":"Punctuation","value":"."},
41 {"type":"Name","value":"cyclist_name"},
42 {"type":"TextWhitespace","value":" "},
43 {"type":"Punctuation","value":"("},
44 {"type":"Name","value":"id"},
45 {"type":"Punctuation","value":","},
46 {"type":"TextWhitespace","value":" "},
47 {"type":"Name","value":"lastname"},
48 {"type":"Punctuation","value":","},
49 {"type":"TextWhitespace","value":" "},
50 {"type":"Name","value":"firstname"},
51 {"type":"Punctuation","value":")"},
52 {"type":"TextWhitespace","value":" "},
53 {"type":"Keyword","value":"VALUES"},
54 {"type":"TextWhitespace","value":" "},
55 {"type":"Punctuation","value":"("},
56 {"type":"LiteralNumberHex","value":"5b6962dd-3f90-4c93-8f61-eabfa4a803e2"},
57 {"type":"Punctuation","value":","},
58 {"type":"TextWhitespace","value":" "},
59 {"type":"LiteralStringSingle","value":"'VOS'"},
60 {"type":"Punctuation","value":","},
61 {"type":"LiteralStringSingle","value":"'Marianne'"},
62 {"type":"Punctuation","value":");"},
63 {"type":"TextWhitespace","value":"\n"},
64 {"type":"Keyword","value":"SELECT"},
65 {"type":"TextWhitespace","value":" "},
66 {"type":"Operator","value":"*"},
67 {"type":"TextWhitespace","value":" "},
68 {"type":"Keyword","value":"FROM"},
69 {"type":"TextWhitespace","value":" "},
70 {"type":"Name","value":"cycling"},
71 {"type":"Punctuation","value":"."},
72 {"type":"Name","value":"cyclist_name"},
73 {"type":"Punctuation","value":";"},
74 {"type":"TextWhitespace","value":"\n"},
75 {"type":"Keyword","value":"SELECT"},
76 {"type":"TextWhitespace","value":" "},
77 {"type":"Name","value":"lastname"},
78 {"type":"Punctuation","value":","},
79 {"type":"TextWhitespace","value":" "},
80 {"type":"Name","value":"firstname"},
81 {"type":"TextWhitespace","value":" "},
82 {"type":"Keyword","value":"FROM"},
83 {"type":"TextWhitespace","value":" "},
84 {"type":"CommentMultiline","value":"/* a comment */"},
85 {"type":"TextWhitespace","value":" "},
86 {"type":"Name","value":"cycling"},
87 {"type":"Punctuation","value":"."},
88 {"type":"Name","value":"cyclist_name"},
89 {"type":"TextWhitespace","value":" "},
90 {"type":"Keyword","value":"WHERE"},
91 {"type":"TextWhitespace","value":" "},
92 {"type":"Name","value":"id"},
93 {"type":"TextWhitespace","value":" "},
94 {"type":"Operator","value":"="},
95 {"type":"TextWhitespace","value":" "},
96 {"type":"LiteralNumberHex","value":"6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47"},
97 {"type":"TextWhitespace","value":" "},
98 {"type":"CommentMultiline","value":"/* multiline comment \n\n*/"},
99 {"type":"TextWhitespace","value":" "},
100 {"type":"CommentSingle","value":"-- comment;\n"},
101 {"type":"Punctuation","value":";"},
102 {"type":"TextWhitespace","value":"\n\n"},
103 {"type":"Keyword","value":"CREATE"},
104 {"type":"TextWhitespace","value":" "},
105 {"type":"Keyword","value":"TABLE"},
106 {"type":"TextWhitespace","value":" "},
107 {"type":"Name","value":"cycling"},
108 {"type":"Punctuation","value":"."},
109 {"type":"Name","value":"cyclist_category"},
110 {"type":"TextWhitespace","value":" "},
111 {"type":"Punctuation","value":"("},
112 {"type":"TextWhitespace","value":" "},
113 {"type":"Name","value":"category"},
114 {"type":"TextWhitespace","value":" "},
115 {"type":"NameBuiltin","value":"text"},
116 {"type":"Punctuation","value":","},
117 {"type":"TextWhitespace","value":" "},
118 {"type":"Name","value":"points"},
119 {"type":"TextWhitespace","value":" "},
120 {"type":"NameBuiltin","value":"int"},
121 {"type":"Punctuation","value":","},
122 {"type":"TextWhitespace","value":" "},
123 {"type":"Name","value":"id"},
124 {"type":"TextWhitespace","value":" "},
125 {"type":"NameBuiltin","value":"UUID"},
126 {"type":"Punctuation","value":","},
127 {"type":"TextWhitespace","value":" "},
128 {"type":"Name","value":"lastname"},
129 {"type":"TextWhitespace","value":" "},
130 {"type":"NameBuiltin","value":"text"},
131 {"type":"Punctuation","value":","},
132 {"type":"TextWhitespace","value":" "},
133 {"type":"Keyword","value":"PRIMARY"},
134 {"type":"TextWhitespace","value":" "},
135 {"type":"Keyword","value":"KEY"},
136 {"type":"TextWhitespace","value":" "},
137 {"type":"Punctuation","value":"("},
138 {"type":"Name","value":"category"},
139 {"type":"Punctuation","value":","},
140 {"type":"TextWhitespace","value":" "},
141 {"type":"Name","value":"points"},
142 {"type":"Punctuation","value":"))"},
143 {"type":"TextWhitespace","value":" "},
144 {"type":"Keyword","value":"WITH"},
145 {"type":"TextWhitespace","value":" "},
146 {"type":"Keyword","value":"CLUSTERING"},
147 {"type":"TextWhitespace","value":" "},
148 {"type":"Keyword","value":"ORDER"},
149 {"type":"TextWhitespace","value":" "},
150 {"type":"Keyword","value":"BY"},
151 {"type":"TextWhitespace","value":" "},
152 {"type":"Punctuation","value":"("},
153 {"type":"Name","value":"points"},
154 {"type":"TextWhitespace","value":" "},
155 {"type":"Keyword","value":"DESC"},
156 {"type":"Punctuation","value":");"},
157 {"type":"TextWhitespace","value":"\n"},
158 {"type":"Keyword","value":"CREATE"},
159 {"type":"TextWhitespace","value":" "},
160 {"type":"Keyword","value":"TABLE"},
161 {"type":"TextWhitespace","value":" "},
162 {"type":"Name","value":"cycling"},
163 {"type":"Punctuation","value":"."},
164 {"type":"Name","value":"race_winners"},
165 {"type":"TextWhitespace","value":" "},
166 {"type":"Punctuation","value":"("},
167 {"type":"Name","value":"race_name"},
168 {"type":"TextWhitespace","value":" "},
169 {"type":"NameBuiltin","value":"text"},
170 {"type":"Punctuation","value":","},
171 {"type":"TextWhitespace","value":" "},
172 {"type":"Name","value":"race_position"},
173 {"type":"TextWhitespace","value":" "},
174 {"type":"NameBuiltin","value":"int"},
175 {"type":"Punctuation","value":","},
176 {"type":"TextWhitespace","value":" "},
177 {"type":"Name","value":"cyclist_name"},
178 {"type":"TextWhitespace","value":" "},
179 {"type":"NameBuiltin","value":"FROZEN"},
180 {"type":"Operator","value":"\u003c"},
181 {"type":"Name","value":"fullname"},
182 {"type":"Operator","value":"\u003e"},
183 {"type":"Punctuation","value":","},
184 {"type":"TextWhitespace","value":" "},
185 {"type":"Keyword","value":"PRIMARY"},
186 {"type":"TextWhitespace","value":" "},
187 {"type":"Keyword","value":"KEY"},
188 {"type":"TextWhitespace","value":" "},
189 {"type":"Punctuation","value":"("},
190 {"type":"Name","value":"race_name"},
191 {"type":"Punctuation","value":","},
192 {"type":"TextWhitespace","value":" "},
193 {"type":"Name","value":"race_position"},
194 {"type":"Punctuation","value":"));"},
195 {"type":"TextWhitespace","value":"\n"},
196 {"type":"Keyword","value":"CREATE"},
197 {"type":"TextWhitespace","value":" "},
198 {"type":"Keyword","value":"TABLE"},
199 {"type":"TextWhitespace","value":" "},
200 {"type":"Name","value":"cycling"},
201 {"type":"Punctuation","value":"."},
202 {"type":"Name","value":"cyclist_races"},
203 {"type":"TextWhitespace","value":" "},
204 {"type":"Punctuation","value":"("},
205 {"type":"TextWhitespace","value":" "},
206 {"type":"Name","value":"id"},
207 {"type":"TextWhitespace","value":" "},
208 {"type":"NameBuiltin","value":"UUID"},
209 {"type":"TextWhitespace","value":" "},
210 {"type":"Keyword","value":"PRIMARY"},
211 {"type":"TextWhitespace","value":" "},
212 {"type":"Keyword","value":"KEY"},
213 {"type":"Punctuation","value":","},
214 {"type":"TextWhitespace","value":" "},
215 {"type":"Name","value":"lastname"},
216 {"type":"TextWhitespace","value":" "},
217 {"type":"NameBuiltin","value":"text"},
218 {"type":"Punctuation","value":","},
219 {"type":"TextWhitespace","value":" "},
220 {"type":"Name","value":"firstname"},
221 {"type":"TextWhitespace","value":" "},
222 {"type":"NameBuiltin","value":"text"},
223 {"type":"Punctuation","value":","},
224 {"type":"TextWhitespace","value":" "},
225 {"type":"Name","value":"races"},
226 {"type":"TextWhitespace","value":" "},
227 {"type":"NameBuiltin","value":"list"},
228 {"type":"Operator","value":"\u003c"},
229 {"type":"NameBuiltin","value":"FROZEN"},
230 {"type":"TextWhitespace","value":" "},
231 {"type":"Operator","value":"\u003c"},
232 {"type":"Name","value":"race"},
233 {"type":"Operator","value":"\u003e\u003e"},
234 {"type":"TextWhitespace","value":" "},
235 {"type":"Punctuation","value":");"},
236 {"type":"TextWhitespace","value":"\n"},
237 {"type":"Keyword","value":"INSERT"},
238 {"type":"TextWhitespace","value":" "},
239 {"type":"Keyword","value":"INTO"},
240 {"type":"TextWhitespace","value":" "},
241 {"type":"Name","value":"cycling"},
242 {"type":"Punctuation","value":"."},
243 {"type":"Name","value":"cyclist_races"},
244 {"type":"TextWhitespace","value":" "},
245 {"type":"Punctuation","value":"("},
246 {"type":"Name","value":"id"},
247 {"type":"Punctuation","value":","},
248 {"type":"TextWhitespace","value":" "},
249 {"type":"Name","value":"lastname"},
250 {"type":"Punctuation","value":","},
251 {"type":"TextWhitespace","value":" "},
252 {"type":"Name","value":"firstname"},
253 {"type":"Punctuation","value":","},
254 {"type":"TextWhitespace","value":" "},
255 {"type":"Name","value":"races"},
256 {"type":"Punctuation","value":")"},
257 {"type":"TextWhitespace","value":" "},
258 {"type":"Keyword","value":"VALUES"},
259 {"type":"TextWhitespace","value":" "},
260 {"type":"Punctuation","value":"("},
261 {"type":"LiteralNumberHex","value":"5b6962dd-3f90-4c93-8f61-eabfa4a803e2"},
262 {"type":"Punctuation","value":","},
263 {"type":"TextWhitespace","value":" "},
264 {"type":"LiteralStringSingle","value":"'VOS'"},
265 {"type":"Punctuation","value":","},
266 {"type":"TextWhitespace","value":" "},
267 {"type":"LiteralStringSingle","value":"'Marianne'"},
268 {"type":"Punctuation","value":","},
269 {"type":"TextWhitespace","value":" "},
270 {"type":"Punctuation","value":"["},
271 {"type":"TextWhitespace","value":" "},
272 {"type":"Punctuation","value":"{"},
273 {"type":"Name","value":"race_title"},
274 {"type":"Punctuation","value":":"},
275 {"type":"LiteralStringSingle","value":"'Rabobank 7-Dorpenomloop Aalburg'"},
276 {"type":"Punctuation","value":","},
277 {"type":"Name","value":"race_date"},
278 {"type":"Punctuation","value":":"},
279 {"type":"LiteralStringSingle","value":"'2015-05-09'"},
280 {"type":"Punctuation","value":","},
281 {"type":"Name","value":"race_time"},
282 {"type":"Punctuation","value":":"},
283 {"type":"LiteralStringSingle","value":"'02:58:33'"},
284 {"type":"Punctuation","value":"},{"},
285 {"type":"Name","value":"race_title"},
286 {"type":"Punctuation","value":":"},
287 {"type":"LiteralStringSingle","value":"'Ronde van Gelderland'"},
288 {"type":"Punctuation","value":","},
289 {"type":"Name","value":"race_date"},
290 {"type":"Punctuation","value":":"},
291 {"type":"LiteralStringSingle","value":"'2015-04-19'"},
292 {"type":"Punctuation","value":","},
293 {"type":"Name","value":"race_time"},
294 {"type":"Punctuation","value":":"},
295 {"type":"LiteralStringSingle","value":"'03:22:23'"},
296 {"type":"Punctuation","value":"}"},
297 {"type":"TextWhitespace","value":"\n"},
298 {"type":"Punctuation","value":"]);"},
299 {"type":"TextWhitespace","value":"\n\n"},
300 {"type":"Keyword","value":"INSERT"},
301 {"type":"TextWhitespace","value":" "},
302 {"type":"Keyword","value":"INTO"},
303 {"type":"TextWhitespace","value":" "},
304 {"type":"Name","value":"cycling"},
305 {"type":"Punctuation","value":"."},
306 {"type":"Name","value":"cyclist_races"},
307 {"type":"TextWhitespace","value":" "},
308 {"type":"Punctuation","value":"("},
309 {"type":"Name","value":"id"},
310 {"type":"Punctuation","value":","},
311 {"type":"TextWhitespace","value":" "},
312 {"type":"Name","value":"lastname"},
313 {"type":"Punctuation","value":","},
314 {"type":"TextWhitespace","value":" "},
315 {"type":"Name","value":"firstname"},
316 {"type":"Punctuation","value":","},
317 {"type":"TextWhitespace","value":" "},
318 {"type":"Name","value":"races"},
319 {"type":"Punctuation","value":")"},
320 {"type":"TextWhitespace","value":" "},
321 {"type":"Keyword","value":"VALUES"},
322 {"type":"TextWhitespace","value":" "},
323 {"type":"Punctuation","value":"("},
324 {"type":"LiteralNumberHex","value":"e7cd5752-bc0d-4157-a80f-7523add8dbcd"},
325 {"type":"Punctuation","value":","},
326 {"type":"TextWhitespace","value":" "},
327 {"type":"LiteralStringSingle","value":"'VAN DER BREGGEN'"},
328 {"type":"Punctuation","value":","},
329 {"type":"TextWhitespace","value":" "},
330 {"type":"LiteralStringSingle","value":"'Anna'"},
331 {"type":"Punctuation","value":","},
332 {"type":"TextWhitespace","value":" "},
333 {"type":"Punctuation","value":"["},
334 {"type":"TextWhitespace","value":" "},
335 {"type":"Punctuation","value":"{"},
336 {"type":"Name","value":"race_title"},
337 {"type":"Punctuation","value":":"},
338 {"type":"LiteralStringSingle","value":"'Festival Luxembourgeois du cyclisme feminin Elsy Jacobs - Prologue - Garnich \u003e Garnich'"},
339 {"type":"Punctuation","value":","},
340 {"type":"Name","value":"race_date"},
341 {"type":"Punctuation","value":":"},
342 {"type":"LiteralStringSingle","value":"'2015-05-01'"},
343 {"type":"Punctuation","value":","},
344 {"type":"Name","value":"race_time"},
345 {"type":"Punctuation","value":":"},
346 {"type":"LiteralStringSingle","value":"'08:13:00'"},
347 {"type":"Punctuation","value":"},{"},
348 {"type":"Name","value":"race_title"},
349 {"type":"Punctuation","value":":"},
350 {"type":"LiteralStringSingle","value":"'Festival Luxembourgeois du cyclisme feminin Elsy Jacobs - Stage 2 - Garnich \u003e Garnich'"},
351 {"type":"Punctuation","value":","},
352 {"type":"Name","value":"race_date"},
353 {"type":"Punctuation","value":":"},
354 {"type":"LiteralStringSingle","value":"'2015-05-02'"},
355 {"type":"Punctuation","value":","},
356 {"type":"Name","value":"race_time"},
357 {"type":"Punctuation","value":":"},
358 {"type":"LiteralStringSingle","value":"'02:41:52'"},
359 {"type":"Punctuation","value":"},{"},
360 {"type":"Name","value":"race_title"},
361 {"type":"Punctuation","value":":"},
362 {"type":"LiteralStringSingle","value":"'Festival Luxembourgeois du cyclisme feminin Elsy Jacobs - Stage 3 - Mamer \u003e Mamer'"},
363 {"type":"Punctuation","value":","},
364 {"type":"Name","value":"race_date"},
365 {"type":"Punctuation","value":":"},
366 {"type":"LiteralStringSingle","value":"'2015-05-03'"},
367 {"type":"Punctuation","value":","},
368 {"type":"Name","value":"race_time"},
369 {"type":"Punctuation","value":":"},
370 {"type":"LiteralStringSingle","value":"'02:31:24'"},
371 {"type":"Punctuation","value":"}"},
372 {"type":"TextWhitespace","value":" "},
373 {"type":"Punctuation","value":"]);"},
374 {"type":"TextWhitespace","value":"\n\n"},
375 {"type":"Keyword","value":"SELECT"},
376 {"type":"TextWhitespace","value":" "},
377 {"type":"Operator","value":"*"},
378 {"type":"TextWhitespace","value":" "},
379 {"type":"Keyword","value":"FROM"},
380 {"type":"TextWhitespace","value":" "},
381 {"type":"Name","value":"cycling"},
382 {"type":"Punctuation","value":"."},
383 {"type":"Name","value":"cyclist_races"},
384 {"type":"Punctuation","value":";"},
385 {"type":"TextWhitespace","value":"\n\n"},
386 {"type":"Keyword","value":"SELECT"},
387 {"type":"TextWhitespace","value":" "},
388 {"type":"Name","value":"lastname"},
389 {"type":"Punctuation","value":","},
390 {"type":"TextWhitespace","value":" "},
391 {"type":"Name","value":"races"},
392 {"type":"TextWhitespace","value":" "},
393 {"type":"Keyword","value":"FROM"},
394 {"type":"TextWhitespace","value":" "},
395 {"type":"Name","value":"cycling"},
396 {"type":"Punctuation","value":"."},
397 {"type":"Name","value":"cyclist_races"},
398 {"type":"TextWhitespace","value":" "},
399 {"type":"Keyword","value":"WHERE"},
400 {"type":"TextWhitespace","value":" "},
401 {"type":"Name","value":"id"},
402 {"type":"TextWhitespace","value":" "},
403 {"type":"Operator","value":"="},
404 {"type":"TextWhitespace","value":" "},
405 {"type":"LiteralNumberHex","value":"e7cd5752-bc0d-4157-a80f-7523add8dbcd"},
406 {"type":"Punctuation","value":";"},
407 {"type":"TextWhitespace","value":"\n\n"},
408 {"type":"Keyword","value":"INSERT"},
409 {"type":"TextWhitespace","value":" "},
410 {"type":"Keyword","value":"INTO"},
411 {"type":"TextWhitespace","value":" "},
412 {"type":"Name","value":"cycling"},
413 {"type":"Punctuation","value":"."},
414 {"type":"Name","value":"calendar"},
415 {"type":"TextWhitespace","value":" "},
416 {"type":"Punctuation","value":"("},
417 {"type":"Name","value":"race_id"},
418 {"type":"Punctuation","value":","},
419 {"type":"TextWhitespace","value":" "},
420 {"type":"Name","value":"race_start_date"},
421 {"type":"Punctuation","value":","},
422 {"type":"TextWhitespace","value":" "},
423 {"type":"Name","value":"race_end_date"},
424 {"type":"Punctuation","value":","},
425 {"type":"TextWhitespace","value":" "},
426 {"type":"Name","value":"race_name"},
427 {"type":"Punctuation","value":")"},
428 {"type":"TextWhitespace","value":" "},
429 {"type":"Keyword","value":"VALUES"},
430 {"type":"TextWhitespace","value":" "},
431 {"type":"Punctuation","value":"("},
432 {"type":"LiteralNumberFloat","value":"201"},
433 {"type":"Punctuation","value":","},
434 {"type":"TextWhitespace","value":" "},
435 {"type":"LiteralStringSingle","value":"'2015-02-18'"},
436 {"type":"Punctuation","value":","},
437 {"type":"TextWhitespace","value":" "},
438 {"type":"LiteralStringSingle","value":"'2015-02-22'"},
439 {"type":"Punctuation","value":","},
440 {"type":"TextWhitespace","value":" "},
441 {"type":"LiteralStringHeredoc","value":"$$Women's Tour of New Zealand$$"},
442 {"type":"Punctuation","value":");"},
443 {"type":"TextWhitespace","value":"\n\n"},
444 {"type":"Keyword","value":"CREATE"},
445 {"type":"TextWhitespace","value":" "},
446 {"type":"Keyword","value":"USER"},
447 {"type":"TextWhitespace","value":" "},
448 {"type":"Keyword","value":"IF"},
449 {"type":"TextWhitespace","value":" "},
450 {"type":"Keyword","value":"NOT"},
451 {"type":"TextWhitespace","value":" "},
452 {"type":"Keyword","value":"EXISTS"},
453 {"type":"TextWhitespace","value":" "},
454 {"type":"Name","value":"sandy"},
455 {"type":"TextWhitespace","value":" "},
456 {"type":"Keyword","value":"WITH"},
457 {"type":"TextWhitespace","value":" "},
458 {"type":"Keyword","value":"PASSWORD"},
459 {"type":"TextWhitespace","value":" "},
460 {"type":"LiteralStringSingle","value":"'Ride2Win@'"},
461 {"type":"TextWhitespace","value":" "},
462 {"type":"Keyword","value":"NOSUPERUSER"},
463 {"type":"Punctuation","value":";"},
464 {"type":"TextWhitespace","value":"\n"},
465 {"type":"Keyword","value":"CREATE"},
466 {"type":"TextWhitespace","value":" "},
467 {"type":"Keyword","value":"USER"},
468 {"type":"TextWhitespace","value":" "},
469 {"type":"Name","value":"chuck"},
470 {"type":"TextWhitespace","value":" "},
471 {"type":"Keyword","value":"WITH"},
472 {"type":"TextWhitespace","value":" "},
473 {"type":"Keyword","value":"PASSWORD"},
474 {"type":"TextWhitespace","value":" "},
475 {"type":"LiteralStringSingle","value":"'Always1st$'"},
476 {"type":"TextWhitespace","value":" "},
477 {"type":"Keyword","value":"SUPERUSER"},
478 {"type":"Punctuation","value":";"},
479 {"type":"TextWhitespace","value":"\n"},
480 {"type":"Keyword","value":"ALTER"},
481 {"type":"TextWhitespace","value":" "},
482 {"type":"Keyword","value":"USER"},
483 {"type":"TextWhitespace","value":" "},
484 {"type":"Name","value":"sandy"},
485 {"type":"TextWhitespace","value":" "},
486 {"type":"Keyword","value":"SUPERUSER"},
487 {"type":"Punctuation","value":";"},
488 {"type":"TextWhitespace","value":"\n"},
489 {"type":"NameBuiltin","value":"LIST"},
490 {"type":"TextWhitespace","value":" "},
491 {"type":"Keyword","value":"USERS"},
492 {"type":"Punctuation","value":";"},
493 {"type":"TextWhitespace","value":"\n"},
494 {"type":"Keyword","value":"DROP"},
495 {"type":"TextWhitespace","value":" "},
496 {"type":"Keyword","value":"USER"},
497 {"type":"TextWhitespace","value":" "},
498 {"type":"Keyword","value":"IF"},
499 {"type":"TextWhitespace","value":" "},
500 {"type":"Keyword","value":"EXISTS"},
501 {"type":"TextWhitespace","value":" "},
502 {"type":"Name","value":"chuck"},
503 {"type":"Punctuation","value":";"},
504 {"type":"TextWhitespace","value":"\n"},
505 {"type":"Keyword","value":"CREATE"},
506 {"type":"TextWhitespace","value":" "},
507 {"type":"Keyword","value":"ROLE"},
508 {"type":"TextWhitespace","value":" "},
509 {"type":"Keyword","value":"IF"},
510 {"type":"TextWhitespace","value":" "},
511 {"type":"Keyword","value":"NOT"},
512 {"type":"TextWhitespace","value":" "},
513 {"type":"Keyword","value":"EXISTS"},
514 {"type":"TextWhitespace","value":" "},
515 {"type":"Name","value":"team_manager"},
516 {"type":"TextWhitespace","value":" "},
517 {"type":"Keyword","value":"WITH"},
518 {"type":"TextWhitespace","value":" "},
519 {"type":"Keyword","value":"PASSWORD"},
520 {"type":"TextWhitespace","value":" "},
521 {"type":"Operator","value":"="},
522 {"type":"TextWhitespace","value":" "},
523 {"type":"LiteralStringSingle","value":"'RockIt4Us!'"},
524 {"type":"Punctuation","value":";"},
525 {"type":"TextWhitespace","value":"\n"},
526 {"type":"Keyword","value":"CREATE"},
527 {"type":"TextWhitespace","value":" "},
528 {"type":"Keyword","value":"ROLE"},
529 {"type":"TextWhitespace","value":" "},
530 {"type":"Name","value":"sys_admin"},
531 {"type":"TextWhitespace","value":" "},
532 {"type":"Keyword","value":"WITH"},
533 {"type":"TextWhitespace","value":" "},
534 {"type":"Keyword","value":"PASSWORD"},
535 {"type":"TextWhitespace","value":" "},
536 {"type":"Operator","value":"="},
537 {"type":"TextWhitespace","value":" "},
538 {"type":"LiteralStringSingle","value":"'IcanDoIt4ll'"},
539 {"type":"TextWhitespace","value":" "},
540 {"type":"Keyword","value":"AND"},
541 {"type":"TextWhitespace","value":" "},
542 {"type":"Keyword","value":"LOGIN"},
543 {"type":"TextWhitespace","value":" "},
544 {"type":"Operator","value":"="},
545 {"type":"TextWhitespace","value":" "},
546 {"type":"KeywordConstant","value":"true"},
547 {"type":"TextWhitespace","value":" "},
548 {"type":"Keyword","value":"AND"},
549 {"type":"TextWhitespace","value":" "},
550 {"type":"Keyword","value":"SUPERUSER"},
551 {"type":"TextWhitespace","value":" "},
552 {"type":"Operator","value":"="},
553 {"type":"TextWhitespace","value":" "},
554 {"type":"KeywordConstant","value":"true"},
555 {"type":"Punctuation","value":";"},
556 {"type":"TextWhitespace","value":"\n"},
557 {"type":"Keyword","value":"ALTER"},
558 {"type":"TextWhitespace","value":" "},
559 {"type":"Keyword","value":"ROLE"},
560 {"type":"TextWhitespace","value":" "},
561 {"type":"Name","value":"sys_admin"},
562 {"type":"TextWhitespace","value":" "},
563 {"type":"Keyword","value":"WITH"},
564 {"type":"TextWhitespace","value":" "},
565 {"type":"Keyword","value":"PASSWORD"},
566 {"type":"TextWhitespace","value":" "},
567 {"type":"Operator","value":"="},
568 {"type":"TextWhitespace","value":" "},
569 {"type":"LiteralStringSingle","value":"'All4one1forAll'"},
570 {"type":"TextWhitespace","value":" "},
571 {"type":"Keyword","value":"AND"},
572 {"type":"TextWhitespace","value":" "},
573 {"type":"Keyword","value":"SUPERUSER"},
574 {"type":"TextWhitespace","value":" "},
575 {"type":"Operator","value":"="},
576 {"type":"TextWhitespace","value":" "},
577 {"type":"KeywordConstant","value":"false"},
578 {"type":"Punctuation","value":";"},
579 {"type":"TextWhitespace","value":"\n"},
580 {"type":"Keyword","value":"GRANT"},
581 {"type":"TextWhitespace","value":" "},
582 {"type":"Name","value":"sys_admin"},
583 {"type":"TextWhitespace","value":" "},
584 {"type":"Keyword","value":"TO"},
585 {"type":"TextWhitespace","value":" "},
586 {"type":"Name","value":"team_manager"},
587 {"type":"Punctuation","value":";"},
588 {"type":"TextWhitespace","value":"\n"},
589 {"type":"Keyword","value":"GRANT"},
590 {"type":"TextWhitespace","value":" "},
591 {"type":"Name","value":"team_manager"},
592 {"type":"TextWhitespace","value":" "},
593 {"type":"Keyword","value":"TO"},
594 {"type":"TextWhitespace","value":" "},
595 {"type":"Name","value":"sandy"},
596 {"type":"Punctuation","value":";"},
597 {"type":"TextWhitespace","value":"\n"},
598 {"type":"NameBuiltin","value":"LIST"},
599 {"type":"TextWhitespace","value":" "},
600 {"type":"Keyword","value":"ROLES"},
601 {"type":"Punctuation","value":";"},
602 {"type":"TextWhitespace","value":"\n"},
603 {"type":"NameBuiltin","value":"LIST"},
604 {"type":"TextWhitespace","value":" "},
605 {"type":"Keyword","value":"ROLES"},
606 {"type":"TextWhitespace","value":" "},
607 {"type":"Keyword","value":"OF"},
608 {"type":"TextWhitespace","value":" "},
609 {"type":"Name","value":"sandy"},
610 {"type":"Punctuation","value":";"},
611 {"type":"TextWhitespace","value":"\n"},
612 {"type":"Keyword","value":"REVOKE"},
613 {"type":"TextWhitespace","value":" "},
614 {"type":"Name","value":"sys_admin"},
615 {"type":"TextWhitespace","value":" "},
616 {"type":"Keyword","value":"FROM"},
617 {"type":"TextWhitespace","value":" "},
618 {"type":"Name","value":"team_manager"},
619 {"type":"Punctuation","value":";"},
620 {"type":"TextWhitespace","value":"\n"},
621 {"type":"Keyword","value":"REVOKE"},
622 {"type":"TextWhitespace","value":" "},
623 {"type":"Name","value":"team_manager"},
624 {"type":"TextWhitespace","value":" "},
625 {"type":"Keyword","value":"FROM"},
626 {"type":"TextWhitespace","value":" "},
627 {"type":"Name","value":"sandy"},
628 {"type":"Punctuation","value":";"},
629 {"type":"TextWhitespace","value":"\n"},
630 {"type":"Keyword","value":"DROP"},
631 {"type":"TextWhitespace","value":" "},
632 {"type":"Keyword","value":"ROLE"},
633 {"type":"TextWhitespace","value":" "},
634 {"type":"Keyword","value":"IF"},
635 {"type":"TextWhitespace","value":" "},
636 {"type":"Keyword","value":"EXISTS"},
637 {"type":"TextWhitespace","value":" "},
638 {"type":"Name","value":"sys_admin"},
639 {"type":"Punctuation","value":";"},
640 {"type":"TextWhitespace","value":"\n"},
641 {"type":"Keyword","value":"GRANT"},
642 {"type":"TextWhitespace","value":" "},
643 {"type":"Keyword","value":"MODIFY"},
644 {"type":"TextWhitespace","value":" "},
645 {"type":"Keyword","value":"ON"},
646 {"type":"TextWhitespace","value":" "},
647 {"type":"Keyword","value":"KEYSPACE"},
648 {"type":"TextWhitespace","value":" "},
649 {"type":"Name","value":"cycling"},
650 {"type":"TextWhitespace","value":" "},
651 {"type":"Keyword","value":"TO"},
652 {"type":"TextWhitespace","value":" "},
653 {"type":"Name","value":"team_manager"},
654 {"type":"Punctuation","value":";"},
655 {"type":"TextWhitespace","value":"\n"},
656 {"type":"Keyword","value":"GRANT"},
657 {"type":"TextWhitespace","value":" "},
658 {"type":"Name","value":"DESCRIBE"},
659 {"type":"TextWhitespace","value":" "},
660 {"type":"Keyword","value":"ON"},
661 {"type":"TextWhitespace","value":" "},
662 {"type":"Keyword","value":"ALL"},
663 {"type":"TextWhitespace","value":" "},
664 {"type":"Keyword","value":"ROLES"},
665 {"type":"TextWhitespace","value":" "},
666 {"type":"Keyword","value":"TO"},
667 {"type":"TextWhitespace","value":" "},
668 {"type":"Name","value":"sys_admin"},
669 {"type":"Punctuation","value":";"},
670 {"type":"TextWhitespace","value":"\n"},
671 {"type":"Keyword","value":"GRANT"},
672 {"type":"TextWhitespace","value":" "},
673 {"type":"Keyword","value":"AUTHORIZE"},
674 {"type":"TextWhitespace","value":" "},
675 {"type":"Keyword","value":"ALL"},
676 {"type":"TextWhitespace","value":" "},
677 {"type":"Keyword","value":"KEYSPACES"},
678 {"type":"TextWhitespace","value":" "},
679 {"type":"Keyword","value":"TO"},
680 {"type":"TextWhitespace","value":" "},
681 {"type":"Name","value":"sys_admin"},
682 {"type":"Punctuation","value":";"},
683 {"type":"TextWhitespace","value":"\n"},
684 {"type":"Keyword","value":"REVOKE"},
685 {"type":"TextWhitespace","value":" "},
686 {"type":"Keyword","value":"SELECT"},
687 {"type":"TextWhitespace","value":" "},
688 {"type":"Keyword","value":"ON"},
689 {"type":"TextWhitespace","value":" "},
690 {"type":"Keyword","value":"ALL"},
691 {"type":"TextWhitespace","value":" "},
692 {"type":"Keyword","value":"KEYSPACES"},
693 {"type":"TextWhitespace","value":" "},
694 {"type":"Keyword","value":"FROM"},
695 {"type":"TextWhitespace","value":" "},
696 {"type":"Name","value":"team_manager"},
697 {"type":"Punctuation","value":";"},
698 {"type":"TextWhitespace","value":"\n"},
699 {"type":"Keyword","value":"REVOKE"},
700 {"type":"TextWhitespace","value":" "},
701 {"type":"Name","value":"EXECUTE"},
702 {"type":"TextWhitespace","value":" "},
703 {"type":"Keyword","value":"ON"},
704 {"type":"TextWhitespace","value":" "},
705 {"type":"Keyword","value":"FUNCTION"},
706 {"type":"TextWhitespace","value":" "},
707 {"type":"Name","value":"cycling"},
708 {"type":"Punctuation","value":"."},
709 {"type":"Name","value":"fLog"},
710 {"type":"Punctuation","value":"("},
711 {"type":"NameBuiltin","value":"double"},
712 {"type":"Punctuation","value":")"},
713 {"type":"TextWhitespace","value":" "},
714 {"type":"Keyword","value":"FROM"},
715 {"type":"TextWhitespace","value":" "},
716 {"type":"Name","value":"team_manager"},
717 {"type":"Punctuation","value":";"},
718 {"type":"TextWhitespace","value":"\n"},
719 {"type":"NameBuiltin","value":"LIST"},
720 {"type":"TextWhitespace","value":" "},
721 {"type":"Keyword","value":"ALL"},
722 {"type":"TextWhitespace","value":" "},
723 {"type":"Keyword","value":"PERMISSIONS"},
724 {"type":"TextWhitespace","value":" "},
725 {"type":"Keyword","value":"OF"},
726 {"type":"TextWhitespace","value":" "},
727 {"type":"Name","value":"sandy"},
728 {"type":"Punctuation","value":";"},
729 {"type":"TextWhitespace","value":"\n"},
730 {"type":"NameBuiltin","value":"LIST"},
731 {"type":"TextWhitespace","value":" "},
732 {"type":"Keyword","value":"ALL"},
733 {"type":"TextWhitespace","value":" "},
734 {"type":"Keyword","value":"PERMISSIONS"},
735 {"type":"TextWhitespace","value":" "},
736 {"type":"Keyword","value":"ON"},
737 {"type":"TextWhitespace","value":" "},
738 {"type":"Name","value":"cycling"},
739 {"type":"Punctuation","value":"."},
740 {"type":"Name","value":"cyclist_name"},
741 {"type":"TextWhitespace","value":" "},
742 {"type":"Keyword","value":"OF"},
743 {"type":"TextWhitespace","value":" "},
744 {"type":"Name","value":"chuck"},
745 {"type":"Punctuation","value":";"},
746 {"type":"TextWhitespace","value":"\n"},
747 {"type":"Keyword","value":"CREATE"},
748 {"type":"TextWhitespace","value":" "},
749 {"type":"Keyword","value":"MATERIALIZED"},
750 {"type":"TextWhitespace","value":" "},
751 {"type":"Keyword","value":"VIEW"},
752 {"type":"TextWhitespace","value":" "},
753 {"type":"Name","value":"cyclist_by_age"},
754 {"type":"TextWhitespace","value":" "},
755 {"type":"Keyword","value":"AS"},
756 {"type":"TextWhitespace","value":" "},
757 {"type":"Keyword","value":"SELECT"},
758 {"type":"TextWhitespace","value":" "},
759 {"type":"Name","value":"age"},
760 {"type":"Punctuation","value":","},
761 {"type":"TextWhitespace","value":" "},
762 {"type":"Name","value":"birthday"},
763 {"type":"Punctuation","value":","},
764 {"type":"TextWhitespace","value":" "},
765 {"type":"Name","value":"name"},
766 {"type":"Punctuation","value":","},
767 {"type":"TextWhitespace","value":" "},
768 {"type":"Name","value":"country"},
769 {"type":"TextWhitespace","value":" "},
770 {"type":"Keyword","value":"FROM"},
771 {"type":"TextWhitespace","value":" "},
772 {"type":"Name","value":"cyclist_mv"},
773 {"type":"TextWhitespace","value":" "},
774 {"type":"Keyword","value":"WHERE"},
775 {"type":"TextWhitespace","value":" "},
776 {"type":"Name","value":"age"},
777 {"type":"TextWhitespace","value":" "},
778 {"type":"Keyword","value":"is"},
779 {"type":"TextWhitespace","value":" "},
780 {"type":"Keyword","value":"NOT"},
781 {"type":"TextWhitespace","value":" "},
782 {"type":"KeywordConstant","value":"NULL"},
783 {"type":"TextWhitespace","value":" "},
784 {"type":"Keyword","value":"AND"},
785 {"type":"TextWhitespace","value":" "},
786 {"type":"Name","value":"cid"},
787 {"type":"TextWhitespace","value":" "},
788 {"type":"Keyword","value":"IS"},
789 {"type":"TextWhitespace","value":" "},
790 {"type":"Keyword","value":"NOT"},
791 {"type":"TextWhitespace","value":" "},
792 {"type":"KeywordConstant","value":"NULL"},
793 {"type":"TextWhitespace","value":" "},
794 {"type":"Keyword","value":"PRIMARY"},
795 {"type":"TextWhitespace","value":" "},
796 {"type":"Keyword","value":"KEY"},
797 {"type":"TextWhitespace","value":" "},
798 {"type":"Punctuation","value":"("},
799 {"type":"Name","value":"age"},
800 {"type":"Punctuation","value":","},
801 {"type":"TextWhitespace","value":" "},
802 {"type":"Name","value":"cid"},
803 {"type":"Punctuation","value":");"},
804 {"type":"TextWhitespace","value":"\n"},
805 {"type":"Keyword","value":"CREATE"},
806 {"type":"TextWhitespace","value":" "},
807 {"type":"Keyword","value":"MATERIALIZED"},
808 {"type":"TextWhitespace","value":" "},
809 {"type":"Keyword","value":"VIEW"},
810 {"type":"TextWhitespace","value":" "},
811 {"type":"Name","value":"cyclist_by_country"},
812 {"type":"TextWhitespace","value":" "},
813 {"type":"Keyword","value":"AS"},
814 {"type":"TextWhitespace","value":" "},
815 {"type":"Keyword","value":"SELECT"},
816 {"type":"TextWhitespace","value":" "},
817 {"type":"Name","value":"age"},
818 {"type":"Punctuation","value":","},
819 {"type":"TextWhitespace","value":" "},
820 {"type":"Name","value":"birthday"},
821 {"type":"Punctuation","value":","},
822 {"type":"TextWhitespace","value":" "},
823 {"type":"Name","value":"name"},
824 {"type":"Punctuation","value":","},
825 {"type":"TextWhitespace","value":" "},
826 {"type":"Name","value":"country"},
827 {"type":"TextWhitespace","value":" "},
828 {"type":"Keyword","value":"FROM"},
829 {"type":"TextWhitespace","value":" "},
830 {"type":"Name","value":"cyclist_mv"},
831 {"type":"TextWhitespace","value":" "},
832 {"type":"Keyword","value":"WHERE"},
833 {"type":"TextWhitespace","value":" "},
834 {"type":"Name","value":"country"},
835 {"type":"TextWhitespace","value":" "},
836 {"type":"Keyword","value":"is"},
837 {"type":"TextWhitespace","value":" "},
838 {"type":"Keyword","value":"NOT"},
839 {"type":"TextWhitespace","value":" "},
840 {"type":"KeywordConstant","value":"NULL"},
841 {"type":"TextWhitespace","value":" "},
842 {"type":"Keyword","value":"AND"},
843 {"type":"TextWhitespace","value":" "},
844 {"type":"Name","value":"cid"},
845 {"type":"TextWhitespace","value":" "},
846 {"type":"Keyword","value":"IS"},
847 {"type":"TextWhitespace","value":" "},
848 {"type":"Keyword","value":"NOT"},
849 {"type":"TextWhitespace","value":" "},
850 {"type":"KeywordConstant","value":"NULL"},
851 {"type":"TextWhitespace","value":" "},
852 {"type":"Keyword","value":"PRIMARY"},
853 {"type":"TextWhitespace","value":" "},
854 {"type":"Keyword","value":"KEY"},
855 {"type":"TextWhitespace","value":" "},
856 {"type":"Punctuation","value":"("},
857 {"type":"Name","value":"country"},
858 {"type":"Punctuation","value":","},
859 {"type":"TextWhitespace","value":" "},
860 {"type":"Name","value":"cid"},
861 {"type":"Punctuation","value":");"},
862 {"type":"TextWhitespace","value":"\n"},
863 {"type":"Keyword","value":"CREATE"},
864 {"type":"TextWhitespace","value":" "},
865 {"type":"Keyword","value":"MATERIALIZED"},
866 {"type":"TextWhitespace","value":" "},
867 {"type":"Keyword","value":"VIEW"},
868 {"type":"TextWhitespace","value":" "},
869 {"type":"Name","value":"cyclist_by_birthday"},
870 {"type":"TextWhitespace","value":" "},
871 {"type":"Keyword","value":"AS"},
872 {"type":"TextWhitespace","value":" "},
873 {"type":"Keyword","value":"SELECT"},
874 {"type":"TextWhitespace","value":" "},
875 {"type":"Name","value":"age"},
876 {"type":"Punctuation","value":","},
877 {"type":"TextWhitespace","value":" "},
878 {"type":"Name","value":"birthday"},
879 {"type":"Punctuation","value":","},
880 {"type":"TextWhitespace","value":" "},
881 {"type":"Name","value":"name"},
882 {"type":"Punctuation","value":","},
883 {"type":"TextWhitespace","value":" "},
884 {"type":"Name","value":"country"},
885 {"type":"TextWhitespace","value":" "},
886 {"type":"Keyword","value":"FROM"},
887 {"type":"TextWhitespace","value":" "},
888 {"type":"Name","value":"cyclist_mv"},
889 {"type":"TextWhitespace","value":" "},
890 {"type":"Keyword","value":"WHERE"},
891 {"type":"TextWhitespace","value":" "},
892 {"type":"Name","value":"birthday"},
893 {"type":"TextWhitespace","value":" "},
894 {"type":"Keyword","value":"is"},
895 {"type":"TextWhitespace","value":" "},
896 {"type":"Keyword","value":"NOT"},
897 {"type":"TextWhitespace","value":" "},
898 {"type":"KeywordConstant","value":"NULL"},
899 {"type":"TextWhitespace","value":" "},
900 {"type":"Keyword","value":"AND"},
901 {"type":"TextWhitespace","value":" "},
902 {"type":"Name","value":"cid"},
903 {"type":"TextWhitespace","value":" "},
904 {"type":"Keyword","value":"IS"},
905 {"type":"TextWhitespace","value":" "},
906 {"type":"Keyword","value":"NOT"},
907 {"type":"TextWhitespace","value":" "},
908 {"type":"KeywordConstant","value":"NULL"},
909 {"type":"TextWhitespace","value":" "},
910 {"type":"Keyword","value":"PRIMARY"},
911 {"type":"TextWhitespace","value":" "},
912 {"type":"Keyword","value":"KEY"},
913 {"type":"TextWhitespace","value":" "},
914 {"type":"Punctuation","value":"("},
915 {"type":"Name","value":"birthday"},
916 {"type":"Punctuation","value":","},
917 {"type":"TextWhitespace","value":" "},
918 {"type":"Name","value":"cid"},
919 {"type":"Punctuation","value":");"},
920 {"type":"TextWhitespace","value":"\n"},
921 {"type":"Keyword","value":"DROP"},
922 {"type":"TextWhitespace","value":" "},
923 {"type":"Keyword","value":"MATERIALIZED"},
924 {"type":"TextWhitespace","value":" "},
925 {"type":"Keyword","value":"VIEW"},
926 {"type":"TextWhitespace","value":" "},
927 {"type":"Name","value":"cyclist_by_age"},
928 {"type":"Punctuation","value":";"},
929 {"type":"TextWhitespace","value":"\n"},
930 {"type":"Keyword","value":"INSERT"},
931 {"type":"TextWhitespace","value":" "},
932 {"type":"Keyword","value":"INTO"},
933 {"type":"TextWhitespace","value":" "},
934 {"type":"Name","value":"cycling"},
935 {"type":"Punctuation","value":"."},
936 {"type":"Name","value":"calendar"},
937 {"type":"TextWhitespace","value":" "},
938 {"type":"Punctuation","value":"("},
939 {"type":"Name","value":"race_id"},
940 {"type":"Punctuation","value":","},
941 {"type":"TextWhitespace","value":" "},
942 {"type":"Name","value":"race_name"},
943 {"type":"Punctuation","value":","},
944 {"type":"TextWhitespace","value":" "},
945 {"type":"Name","value":"race_start_date"},
946 {"type":"Punctuation","value":","},
947 {"type":"TextWhitespace","value":" "},
948 {"type":"Name","value":"race_end_date"},
949 {"type":"Punctuation","value":")"},
950 {"type":"TextWhitespace","value":" "},
951 {"type":"Keyword","value":"VALUES"},
952 {"type":"TextWhitespace","value":" "},
953 {"type":"Punctuation","value":"("},
954 {"type":"LiteralNumberFloat","value":"200"},
955 {"type":"Punctuation","value":","},
956 {"type":"TextWhitespace","value":" "},
957 {"type":"LiteralStringSingle","value":"'placeholder'"},
958 {"type":"Punctuation","value":","},
959 {"type":"TextWhitespace","value":" "},
960 {"type":"LiteralStringSingle","value":"'2015-05-27'"},
961 {"type":"Punctuation","value":","},
962 {"type":"TextWhitespace","value":" "},
963 {"type":"LiteralStringSingle","value":"'2015-05-27'"},
964 {"type":"Punctuation","value":")"},
965 {"type":"TextWhitespace","value":" "},
966 {"type":"Keyword","value":"USING"},
967 {"type":"TextWhitespace","value":" "},
968 {"type":"NameBuiltin","value":"TIMESTAMP"},
969 {"type":"TextWhitespace","value":" "},
970 {"type":"LiteralNumberFloat","value":"123456789"},
971 {"type":"Punctuation","value":";"},
972 {"type":"TextWhitespace","value":"\n\n"},
973 {"type":"Keyword","value":"CREATE"},
974 {"type":"TextWhitespace","value":" "},
975 {"type":"Keyword","value":"FUNCTION"},
976 {"type":"TextWhitespace","value":" "},
977 {"type":"Keyword","value":"IF"},
978 {"type":"TextWhitespace","value":" "},
979 {"type":"Keyword","value":"NOT"},
980 {"type":"TextWhitespace","value":" "},
981 {"type":"Keyword","value":"EXISTS"},
982 {"type":"TextWhitespace","value":" "},
983 {"type":"Name","value":"cycling"},
984 {"type":"Punctuation","value":"."},
985 {"type":"Name","value":"left"},
986 {"type":"TextWhitespace","value":" "},
987 {"type":"Punctuation","value":"("},
988 {"type":"Name","value":"column"},
989 {"type":"TextWhitespace","value":" "},
990 {"type":"NameBuiltin","value":"TEXT"},
991 {"type":"Punctuation","value":","},
992 {"type":"Name","value":"num"},
993 {"type":"TextWhitespace","value":" "},
994 {"type":"NameBuiltin","value":"int"},
995 {"type":"Punctuation","value":")"},
996 {"type":"TextWhitespace","value":"\n"},
997 {"type":"Keyword","value":"RETURNS"},
998 {"type":"TextWhitespace","value":" "},
999 {"type":"KeywordConstant","value":"NULL"},
1000 {"type":"TextWhitespace","value":" "},
1001 {"type":"Keyword","value":"ON"},
1002 {"type":"TextWhitespace","value":" "},
1003 {"type":"KeywordConstant","value":"NULL"},
1004 {"type":"TextWhitespace","value":" "},
1005 {"type":"Keyword","value":"INPUT"},
1006 {"type":"TextWhitespace","value":"\n"},
1007 {"type":"Keyword","value":"RETURNS"},
1008 {"type":"TextWhitespace","value":" "},
1009 {"type":"NameBuiltin","value":"text"},
1010 {"type":"TextWhitespace","value":"\n"},
1011 {"type":"Keyword","value":"LANGUAGE"},
1012 {"type":"TextWhitespace","value":" "},
1013 {"type":"NameBuiltin","value":"javascript"},
1014 {"type":"TextWhitespace","value":" "},
1015 {"type":"Keyword","value":"AS"},
1016 {"type":"TextWhitespace","value":" "},
1017 {"type":"LiteralStringHeredoc","value":"$$"},
1018 {"type":"Text","value":" \n "},
1019 {"type":"NameOther","value":"column"},
1020 {"type":"Punctuation","value":"."},
1021 {"type":"NameOther","value":"substring"},
1022 {"type":"Punctuation","value":"("},
1023 {"type":"LiteralNumberInteger","value":"0"},
1024 {"type":"Punctuation","value":","},
1025 {"type":"NameOther","value":"num"},
1026 {"type":"Punctuation","value":")"},
1027 {"type":"Text","value":" \n"},
1028 {"type":"LiteralStringHeredoc","value":"$$"},
1029 {"type":"Punctuation","value":";"},
1030 {"type":"TextWhitespace","value":"\n\n"},
1031 {"type":"Keyword","value":"CREATE"},
1032 {"type":"TextWhitespace","value":" "},
1033 {"type":"Keyword","value":"OR"},
1034 {"type":"TextWhitespace","value":" "},
1035 {"type":"Keyword","value":"REPLACE"},
1036 {"type":"TextWhitespace","value":" "},
1037 {"type":"Keyword","value":"FUNCTION"},
1038 {"type":"TextWhitespace","value":" "},
1039 {"type":"Name","value":"cycling"},
1040 {"type":"Punctuation","value":"."},
1041 {"type":"Name","value":"fLog"},
1042 {"type":"TextWhitespace","value":" "},
1043 {"type":"Punctuation","value":"("},
1044 {"type":"Keyword","value":"input"},
1045 {"type":"TextWhitespace","value":" "},
1046 {"type":"NameBuiltin","value":"double"},
1047 {"type":"Punctuation","value":")"},
1048 {"type":"TextWhitespace","value":"\n"},
1049 {"type":"Keyword","value":"CALLED"},
1050 {"type":"TextWhitespace","value":" "},
1051 {"type":"Keyword","value":"ON"},
1052 {"type":"TextWhitespace","value":" "},
1053 {"type":"KeywordConstant","value":"NULL"},
1054 {"type":"TextWhitespace","value":" "},
1055 {"type":"Keyword","value":"INPUT"},
1056 {"type":"TextWhitespace","value":"\n"},
1057 {"type":"Keyword","value":"RETURNS"},
1058 {"type":"TextWhitespace","value":" "},
1059 {"type":"NameBuiltin","value":"double"},
1060 {"type":"TextWhitespace","value":" "},
1061 {"type":"Keyword","value":"LANGUAGE"},
1062 {"type":"TextWhitespace","value":" "},
1063 {"type":"NameBuiltin","value":"java"},
1064 {"type":"TextWhitespace","value":" "},
1065 {"type":"Keyword","value":"AS"},
1066 {"type":"TextWhitespace","value":"\n"},
1067 {"type":"LiteralStringHeredoc","value":"'"},
1068 {"type":"Keyword","value":"return"},
1069 {"type":"Text","value":" "},
1070 {"type":"Name","value":"Double"},
1071 {"type":"Operator","value":"."},
1072 {"type":"NameAttribute","value":"valueOf"},
1073 {"type":"Operator","value":"("},
1074 {"type":"Name","value":"Math"},
1075 {"type":"Operator","value":"."},
1076 {"type":"NameAttribute","value":"log"},
1077 {"type":"Operator","value":"("},
1078 {"type":"Name","value":"input"},
1079 {"type":"Operator","value":"."},
1080 {"type":"NameAttribute","value":"doubleValue"},
1081 {"type":"Operator","value":"()));"},
1082 {"type":"LiteralStringHeredoc","value":"'"},
1083 {"type":"Punctuation","value":";"},
1084 {"type":"TextWhitespace","value":"\n"}
1085]
View as plain text