summaryrefslogtreecommitdiff
path: root/tests/examplefiles/sql+jinja/example.sql.output
blob: f055853c5090fb69ca1c768a02b727d0f1ff91d6 (plain)
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
'{%'          Comment.Preproc
'- '          Text
'set'         Keyword
' '           Text
'payment_methods' Name.Variable
' '           Text
'='           Operator
' '           Text
'['           Operator
'"bank_transfer"' Literal.String.Double
','           Operator
' '           Text
'"credit_card"' Literal.String.Double
','           Operator
' '           Text
'"gift_card"' Literal.String.Double
']'           Operator
' '           Text
'-'           Text
'%}'          Comment.Preproc
'\n\n'        Text.Whitespace

'select'      Keyword
'\n  '        Text.Whitespace
'order_id'    Name
','           Punctuation
'\n  '        Text.Whitespace
'{%'          Comment.Preproc
'- '          Text
'for'         Keyword
' '           Text
'payment_method' Name.Variable
' '           Text
'in'          Keyword
' '           Text
'payment_methods' Name.Variable
' '           Text
'%}'          Comment.Preproc
'\n  '        Text.Whitespace
'sum'         Keyword
'('           Punctuation
'case'        Keyword
' '           Text.Whitespace
'when'        Keyword
' '           Text.Whitespace
'payment_method' Name
' '           Text.Whitespace
'='           Operator
' '           Text.Whitespace
"'"           Literal.String.Single
'{{'          Comment.Preproc
'payment_method' Name.Variable
'}}'          Comment.Preproc
"'"           Literal.String.Single
' '           Text.Whitespace
'then'        Keyword
' '           Text.Whitespace
'amount'      Name
' '           Text.Whitespace
'end'         Keyword
')'           Punctuation
' '           Text.Whitespace
'as'          Keyword
' '           Text.Whitespace
'{{'          Comment.Preproc
'payment_method' Name.Variable
'}}'          Comment.Preproc
'_amount'     Name
'\n  '        Text.Whitespace
'{%'          Comment.Preproc
'- '          Text
'if'          Keyword
' '           Text
'not'         Keyword
' '           Text
'loop'        Name.Builtin
'.last'       Name.Variable
' '           Text
'%}'          Comment.Preproc
','           Punctuation
'{%'          Comment.Preproc
' '           Text
'endif'       Keyword
' '           Text
'-'           Text
'%}'          Comment.Preproc
'\n  '        Text.Whitespace
'{%'          Comment.Preproc
' '           Text
'endfor'      Keyword
' '           Text
'%}'          Comment.Preproc
'\n'          Text.Whitespace

'from'        Keyword
' '           Text.Whitespace
'{{'          Comment.Preproc
' '           Text
'ref'         Name.Variable
'('           Operator
"'raw_payments'" Literal.String.Single
')'           Operator
' '           Text
'}}'          Comment.Preproc
'\n'          Text.Whitespace

'group'       Keyword
' '           Text.Whitespace
'by'          Keyword
' '           Text.Whitespace
'1'           Literal.Number.Integer
'\n'          Text.Whitespace