diff options
| author | Paul McGuire <ptmcg@austin.rr.com> | 2012-11-23 08:54:10 +0000 |
|---|---|---|
| committer | Paul McGuire <ptmcg@austin.rr.com> | 2012-11-23 08:54:10 +0000 |
| commit | 774e46526945ea91265734a2dc82d15eed515577 (patch) | |
| tree | 734ae210c20a98f01fe029f7e6eeb7a93b4617fb /src/examples/simpleSQL.py | |
| parent | 6b12041d4656f4cda910f24acda8d71013166fbd (diff) | |
| download | pyparsing-git-774e46526945ea91265734a2dc82d15eed515577.tar.gz | |
Clean up examples to be Python 3 compatible
Diffstat (limited to 'src/examples/simpleSQL.py')
| -rw-r--r-- | src/examples/simpleSQL.py | 120 |
1 files changed, 60 insertions, 60 deletions
diff --git a/src/examples/simpleSQL.py b/src/examples/simpleSQL.py index fc9e408..62f9928 100644 --- a/src/examples/simpleSQL.py +++ b/src/examples/simpleSQL.py @@ -10,17 +10,17 @@ from pyparsing import Literal, CaselessLiteral, Word, Upcase, delimitedList, Opt ZeroOrMore, restOfLine, Keyword
def test( str ):
- print str,"->"
+ print(str,"->")
try:
tokens = simpleSQL.parseString( str )
- print "tokens = ", tokens
- print "tokens.columns =", tokens.columns
- print "tokens.tables =", tokens.tables
- print "tokens.where =", tokens.where
- except ParseException, err:
- print " "*err.loc + "^\n" + err.msg
- print err
- print
+ print("tokens = ", tokens)
+ print("tokens.columns =", tokens.columns)
+ print("tokens.tables =", tokens.tables)
+ print("tokens.where =", tokens.where)
+ except ParseException as err:
+ print(" "*err.loc + "^\n" + err.msg)
+ print(err)
+ print()
# define SQL tokens
@@ -87,56 +87,56 @@ test( "Select A,b from table1,table2 where table1.id eq table2.id -- test out co """
Test output:
->pythonw -u simpleSQL.py -SELECT * from XYZZY, ABC -> -tokens = ['select', '*', 'from', ['XYZZY', 'ABC']] -tokens.columns = * -tokens.tables = ['XYZZY', 'ABC'] - -select * from SYS.XYZZY -> -tokens = ['select', '*', 'from', ['SYS.XYZZY']] -tokens.columns = * -tokens.tables = ['SYS.XYZZY'] - -Select A from Sys.dual -> -tokens = ['select', ['A'], 'from', ['SYS.DUAL']] -tokens.columns = ['A'] -tokens.tables = ['SYS.DUAL'] - -Select A,B,C from Sys.dual -> -tokens = ['select', ['A', 'B', 'C'], 'from', ['SYS.DUAL']] -tokens.columns = ['A', 'B', 'C'] -tokens.tables = ['SYS.DUAL'] - -Select A, B, C from Sys.dual -> -tokens = ['select', ['A', 'B', 'C'], 'from', ['SYS.DUAL']] -tokens.columns = ['A', 'B', 'C'] -tokens.tables = ['SYS.DUAL'] - -Select A, B, C from Sys.dual, Table2 -> -tokens = ['select', ['A', 'B', 'C'], 'from', ['SYS.DUAL', 'TABLE2']] -tokens.columns = ['A', 'B', 'C'] -tokens.tables = ['SYS.DUAL', 'TABLE2'] - -Xelect A, B, C from Sys.dual -> -^ -Expected 'select' -Expected 'select' (0), (1,1) - -Select A, B, C frox Sys.dual -> - ^ -Expected 'from' -Expected 'from' (15), (1,16) - -Select -> - ^ -Expected '*' -Expected '*' (6), (1,7) - -Select &&& frox Sys.dual -> - ^ -Expected '*' -Expected '*' (7), (1,8) - +>pythonw -u simpleSQL.py
+SELECT * from XYZZY, ABC ->
+tokens = ['select', '*', 'from', ['XYZZY', 'ABC']]
+tokens.columns = *
+tokens.tables = ['XYZZY', 'ABC']
+
+select * from SYS.XYZZY ->
+tokens = ['select', '*', 'from', ['SYS.XYZZY']]
+tokens.columns = *
+tokens.tables = ['SYS.XYZZY']
+
+Select A from Sys.dual ->
+tokens = ['select', ['A'], 'from', ['SYS.DUAL']]
+tokens.columns = ['A']
+tokens.tables = ['SYS.DUAL']
+
+Select A,B,C from Sys.dual ->
+tokens = ['select', ['A', 'B', 'C'], 'from', ['SYS.DUAL']]
+tokens.columns = ['A', 'B', 'C']
+tokens.tables = ['SYS.DUAL']
+
+Select A, B, C from Sys.dual ->
+tokens = ['select', ['A', 'B', 'C'], 'from', ['SYS.DUAL']]
+tokens.columns = ['A', 'B', 'C']
+tokens.tables = ['SYS.DUAL']
+
+Select A, B, C from Sys.dual, Table2 ->
+tokens = ['select', ['A', 'B', 'C'], 'from', ['SYS.DUAL', 'TABLE2']]
+tokens.columns = ['A', 'B', 'C']
+tokens.tables = ['SYS.DUAL', 'TABLE2']
+
+Xelect A, B, C from Sys.dual ->
+^
+Expected 'select'
+Expected 'select' (0), (1,1)
+
+Select A, B, C frox Sys.dual ->
+ ^
+Expected 'from'
+Expected 'from' (15), (1,16)
+
+Select ->
+ ^
+Expected '*'
+Expected '*' (6), (1,7)
+
+Select &&& frox Sys.dual ->
+ ^
+Expected '*'
+Expected '*' (7), (1,8)
+
>Exit code: 0
"""
\ No newline at end of file |