c S s |d dkS )Nr r rw )r r5 rv rw rw rx ry s zr
z) rz r r r r/ r4 r3 r> r r rZ r+ r r2 r r rm r rV rY rB r
_Lr titler ri r )tagStrZxmlZresnameZ tagAttrNameZ tagAttrValueZopenTagZprintablesLessRAbrackZcloseTagrw rw rx _makeTags s"
T\..r c C s
t | dS )a
Helper to construct opening and closing tag expressions for HTML, given a tag name. Matches
tags in either upper or lower case, attributes with namespaces and with quoted or unquoted values.
Example::
text = '| More info at the pyparsing wiki page | '
# makeHTMLTags returns pyparsing expressions for the opening and closing tags as a 2-tuple
a,a_end = makeHTMLTags("A")
link_expr = a + SkipTo(a_end)("link_text") + a_end
for link in link_expr.searchString(text):
# attributes in the tag (like "href" shown here) are also accessible as named results
print(link.link_text, '->', link.href)
prints::
pyparsing -> http://pyparsing.wikispaces.com
F)r )r rw rw rx rK s c C s
t | dS )z
Helper to construct opening and closing tag expressions for XML, given a tag name. Matches
tags only in the given upper/lower case.
Example: similar to L{makeHTMLTags}
T)r )r rw rw rx rL s c s8 | r| dd n|j dd D fdd}|S )a<
Helper to create a validating parse action to be used with start tags created
with C{L{makeXMLTags}} or C{L{makeHTMLTags}}. Use C{withAttribute} to qualify a starting tag
with a required attribute value, to avoid false matches on common tags such as
C{} or C{}.
Call C{withAttribute} with a series of attribute names and values. Specify the list
of filter attributes names and values as:
- keyword arguments, as in C{(align="right")}, or
- as an explicit dict with C{**} operator, when an attribute name is also a Python
reserved word, as in C{**{"class":"Customer", "align":"right"}}
- a list of name-value tuples, as in ( ("ns1:class", "Customer"), ("ns2:align","right") )
For attribute names with a namespace prefix, you must use the second form. Attribute
names are matched insensitive to upper/lower case.
If just testing for C{class} (with or without a namespace), use C{L{withClass}}.
To verify that the attribute exists, but without specifying a value, pass
C{withAttribute.ANY_VALUE} as the value.
Example::
html = '''
Some text
1 4 0 1 0
1,3 2,3 1,1
this has no type
'''
div,div_end = makeHTMLTags("div")
# only match div tag having a type attribute with value "grid"
div_grid = div().setParseAction(withAttribute(type="grid"))
grid_expr = div_grid + SkipTo(div | div_end)("body")
for grid_header in grid_expr.searchString(html):
print(grid_header.body)
# construct a match with any div tag having a type attribute, regardless of the value
div_any_type = div().setParseAction(withAttribute(type=withAttribute.ANY_VALUE))
div_expr = div_any_type + SkipTo(div | div_end)("body")
for div_header in div_expr.searchString(html):
print(div_header.body)
prints::
1 4 0 1 0
1 4 0 1 0
1,3 2,3 1,1
Nc S s g | ]\}}||fqS rw rw )r r r rw rw rx r Q s z!withAttribute. .c s^ xX D ]P\}}||kr&t | |d| |tjkr|| |krt | |d||| |f qW d S )Nzno matching attribute z+attribute '%s' has value '%s', must be '%s')r re ANY_VALUE)r r5 r ZattrNameZ attrValue)attrsrw rx r} R s zwithAttribute..pa)r )r ZattrDictr} rw )r rx re s 2 c C s |r d| nd}t f || iS )a
Simplified version of C{L{withAttribute}} when matching on a div class - made
difficult because C{class} is a reserved word in Python.
Example::
html = '''
Some text
1 4 0 1 0
1,3 2,3 1,1
this <div> has no class
More info at the pyparsing wiki page | '
td,td_end = makeHTMLTags("TD")
table_text = td + SkipTo(td_end).setParseAction(pyparsing_common.stripHTMLTags)("body") + td_end
print(table_text.parseString(text).body) # -> 'More info at the pyparsing wiki page'
r )rn _html_stripperr )r r5 r rw rw rx
stripHTMLTags s
z pyparsing_common.stripHTMLTagsr` )r z r r )r zcomma separated listc C s t | j S )N)r r )rv rw rw rx ry s c C s t | j S )N)r r )rv rw rw rx ry s N)r rB )r rB )r )r )?r r r r rm ru ZconvertToIntegerfloatZconvertToFloatr/ rR ri r r rD r r' Zsigned_integerr rx r r Z
mixed_integerrG realZsci_realr numberr r4 r3 r Z ipv4_addressr Z_full_ipv6_addressZ_short_ipv6_addressr~ Z_mixed_ipv6_addressr
Z ipv6_addressZ mac_addressr r r Z iso8601_dateZiso8601_datetimeuuidr7 r6 r r r r r rV r.
_commasepitemr@ rY r Zcomma_separated_listrd rB rw rw rw rx rn sN ""
2 8 __main__Zselectfromz_$r\ )ra columnsrj ZtablesZcommandaK
# '*' as column list and dotted table name
select * from SYS.XYZZY
# caseless match on "SELECT", and casts back to "select"
SELECT * from XYZZY, ABC
# list of column names, and mixed case SELECT keyword
Select AA,BB,CC from Sys.dual
# multiple tables
Select A, B, C from Sys.dual, Table2
# invalid SELECT keyword - should fail
Xelect A, B, C from Sys.dual
# incomplete command - should fail
Select
# invalid column name - should fail
Select ^^^ frox Sys.dual
z]
100
-100
+100
3.14159
6.02e23
1e-12
z
100
FF
z6
12345678-1234-5678-1234-567812345678
)rq )r` F)N)FT)T)r )T)r __version__Z__versionTime__
__author__r weakrefr r r r~ r rd r r r" r< r r _threadr ImportErrorZ threadingr r Z ordereddict__all__r version_infor; r maxsizer r{ r chrrt r rG r r reversedr r r r5 r
r rI ZmaxintZxranger Z __builtin__r Zfnamer rJ r r r r r r Zascii_uppercaseZascii_lowercaser4 rR rD r3 rj r Z printablerV rK r r r! r# r& r r" MutableMappingregisterr9 rJ rG r/ r2 r4 rQ rM r$ r, r
r r r rQ r r r rl r/ r' r% r r. r/ r r r r* r) r1 r0 r r r r r r r r rI r r2 rL rM r r( r rU r- r
r r r+ r rb r@ r< r rO rN r rS rA rg rh rj ri rC rI rH ra r` r Z _escapedPuncZ_escapedHexCharZ_escapedOctCharUNICODEZ _singleCharZ
_charRangerm r| r_ rM r\ rZ rm rd rB r rK rL re r rk rT r r ri rU r> r^ rY rc rP rf r5 rW r7 r6 r r r r r; r[ r8 rE r r] r? r= rF rX r r r: rn r Z selectTokenZ fromTokenZidentZ
columnNameZcolumnNameListZ
columnSpecZ tableNameZ
tableNameListZ simpleSQLr r r r r r rw rw rw rx = s
8
@ d &A= I
G3 pLOD|M &# @sQ,A, I# % &0
, ? #k Zr
(
0
" |