summaryrefslogtreecommitdiff
path: root/src/examples/simpleSQL.py
diff options
context:
space:
mode:
authorPaul McGuire <ptmcg@austin.rr.com>2016-02-07 05:47:23 +0000
committerPaul McGuire <ptmcg@austin.rr.com>2016-02-07 05:47:23 +0000
commit3963d5fdbd16f25d4e94968b823e811df836142d (patch)
tree0329cd5c5951e851e445b6e07b3fd8420424e34b /src/examples/simpleSQL.py
parent4b24fe8cfb54086ecaec689a7cd229a0430b75c9 (diff)
downloadpyparsing-git-3963d5fdbd16f25d4e94968b823e811df836142d.tar.gz
Removed deprecated class Upcase and deprecated class keepOriginalText; updated examples to remove those symbols, and to replace operatorPrecedence with infixNotation
Diffstat (limited to 'src/examples/simpleSQL.py')
-rw-r--r--src/examples/simpleSQL.py14
1 files changed, 7 insertions, 7 deletions
diff --git a/src/examples/simpleSQL.py b/src/examples/simpleSQL.py
index 62f9928..e19d5c2 100644
--- a/src/examples/simpleSQL.py
+++ b/src/examples/simpleSQL.py
@@ -5,12 +5,12 @@
#
# Copyright (c) 2003, Paul McGuire
#
-from pyparsing import Literal, CaselessLiteral, Word, Upcase, delimitedList, Optional, \
+from pyparsing import Literal, CaselessLiteral, Word, delimitedList, Optional, \
Combine, Group, alphas, nums, alphanums, ParseException, Forward, oneOf, quotedString, \
- ZeroOrMore, restOfLine, Keyword
+ ZeroOrMore, restOfLine, Keyword, upcaseTokens
def test( str ):
- print(str,"->")
+ print(str + " ->")
try:
tokens = simpleSQL.parseString( str )
print("tokens = ", tokens)
@@ -18,9 +18,9 @@ def test( str ):
print("tokens.tables =", tokens.tables)
print("tokens.where =", tokens.where)
except ParseException as err:
- print(" "*err.loc + "^\n" + err.msg)
+ print(" "*err.loc + "^")
print(err)
- print()
+ print('')
# define SQL tokens
@@ -29,9 +29,9 @@ selectToken = Keyword("select", caseless=True)
fromToken = Keyword("from", caseless=True)
ident = Word( alphas, alphanums + "_$" ).setName("identifier")
-columnName = Upcase( delimitedList( ident, ".", combine=True ) )
+columnName = ( delimitedList( ident, ".", combine=True ) ).addParseAction(upcaseTokens)
columnNameList = Group( delimitedList( columnName ) )
-tableName = Upcase( delimitedList( ident, ".", combine=True ) )
+tableName = ( delimitedList( ident, ".", combine=True ) ).addParseAction(upcaseTokens)
tableNameList = Group( delimitedList( tableName ) )
whereExpression = Forward()