Also add auto-updatable output-based tests to examplefiles (#1689)

Co-authored-by: Georg Brandl <georg@python.org>

1 files changed, 99 insertions, 0 deletions

diff --git a/tests/examplefiles/sqlite3/sqlite3.sqlite3-console.output b/tests/examplefiles/sqlite3/sqlite3.sqlite3-console.output
new file mode 100644
index 00000000..62f56e26
--- /dev/null
+++ b/tests/examplefiles/sqlite3/sqlite3.sqlite3-console.output
@@ -0,0 +1,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