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 | d�S )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 | d�S )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 | ]\}}||f�qS 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 || i�S )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.stripHTMLTagsra )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 ZconvertToInteger�floatZconvertToFloatr/ rR ri r� r� rD r� r' Zsigned_integerr� rx r r� Z
mixed_integerrH �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_datetime�uuidr7 r6 r� r� r r r rV r. �
_commasepitemr@ rY r� Zcomma_separated_listrd rB rw rw rw rx rn � sN ""
2 8 �__main__Zselect�fromz_$r] )rb �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 )ra 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� �chrru r� rH r� r �reversedr� r� r r6 r r rI ZmaxintZxranger� Z __builtin__r� Zfnamer� rJ r� r� r� r� r� r� Zascii_uppercaseZascii_lowercaser4 rR rD r3 rk r� Z printablerV rK r r r! r# r& r� r" �MutableMapping�registerr9 rJ rG r/ r2 r4 rQ rM r$ r, r
r r r� rQ r r r rl r/ r' r% r r. r0 r r r r* r) r1 r0 r r r r r r r r rJ r r2 rM rN r r( r rV 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_escapedOctChar�UNICODEZ _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
" |