diff options
author | Paul McGuire <ptmcg@austin.rr.com> | 2016-02-07 05:47:23 +0000 |
---|---|---|
committer | Paul McGuire <ptmcg@austin.rr.com> | 2016-02-07 05:47:23 +0000 |
commit | 3963d5fdbd16f25d4e94968b823e811df836142d (patch) | |
tree | 0329cd5c5951e851e445b6e07b3fd8420424e34b /src/examples/simpleSQL.py | |
parent | 4b24fe8cfb54086ecaec689a7cd229a0430b75c9 (diff) | |
download | pyparsing-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.py | 14 |
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()
|