summaryrefslogtreecommitdiff
path: root/tests/examplefiles/sqlite3/sqlite3.sqlite3-console.output
blob: 62f56e2697bb74812dec9cfcaa91c92339ec0334 (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
'SQLite version 3.4.2\n' Generic.Output

'Enter ".help" for instructions\n' Generic.Output

'sqlite> '    Generic.Prompt
'.'           Punctuation
'schema'      Keyword
'\n'          Text

'CREATE TABLE paste (paste_id integer, code text, parsed_code text, pub_date\n' Generic.Output

'varchar(24), language varchar(64), parent_id integer, url varchar(128));\n' Generic.Output

'CREATE TABLE vars (key varchar(24), value varchar(128));\n' Generic.Output

'sqlite> '    Generic.Prompt
'a'           Name
' '           Text
"'\n"         Literal.String.Single

'   ...> '    Generic.Prompt
"'"           Literal.String.Single
'\n'          Text

'   ...> '    Generic.Prompt
';'           Punctuation
'\n'          Text

'SQL error: near "a": syntax error\n' Generic.Traceback

'sqlite> '    Generic.Prompt
'%'           Operator
';'           Punctuation
'\n'          Text

'SQL error: near "%": syntax error\n' Generic.Traceback

'sqlite> '    Generic.Prompt
'select'      Keyword
' '           Text
'count'       Keyword
'('           Punctuation
'language'    Keyword
')'           Punctuation
','           Punctuation
' '           Text
'language'    Keyword
' '           Text
'from'        Keyword
' '           Text
'paste'       Name
' '           Text
'group'       Keyword
' '           Text
'by'          Keyword
' '           Text
'language'    Keyword
' '           Text
'order'       Keyword
'\n'          Text

'   ...> '    Generic.Prompt
'by'          Keyword
' '           Text
'count'       Keyword
'('           Punctuation
'language'    Keyword
')'           Punctuation
' '           Text
'desc'        Keyword
';'           Punctuation
'\n'          Text

'144|python\n' Generic.Output

'76|text\n'   Generic.Output

'22|pycon\n'  Generic.Output

'9|ruby\n'    Generic.Output

'7|c\n'       Generic.Output

'7|js\n'      Generic.Output

'6|html+django\n' Generic.Output

'4|html\n'    Generic.Output

'4|tex\n'     Generic.Output

'2|html+php\n' Generic.Output

'1|cpp\n'     Generic.Output

'1|scheme\n'  Generic.Output

'sqlite> '    Generic.Prompt
'\n'          Text