ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 3 F³`Q¼Óã@s`dZddlZddlZddlZddlZddlZddlZddlZddlZej ddkZ e rxeZeZ eZeZeZddlmZnejZejZeZddlmZe r´ej ddkr´ddlmZnddlmZdZdZdZdZdZ d Z!d Z"dZ#ej$dƒZ%d d„Z&Gdd„de'ƒZ(dd„Z)dd„Z*d"dd„Z+dd„Z,Gdd„deƒZ-dd„Z.dd„Z/dd „Z0e1d!kr\e0ƒdS)#z0.7.2éNé)Ú HTMLParseréé)Úescapeé éééz\[[0-9;]*mcCs,|jdƒ}t|ƒ}tdd„|Dƒƒ}||fS)NÚ cSsg|]}t|ƒ‘qS©)Ú_str_block_width)Ú.0Úlinerrú!/usr/lib/python3.6/prettytable.pyú Osz_get_size..)ÚsplitÚlenÚmax)ÚtextÚlinesZheightÚwidthrrrÚ _get_sizeLs rc@sBeZdZdÍdd„Zdd„Zdd„Zdd „Zd d„Zer@dd „Z ndd „Z dd„Z dd„Zdd„Zdd„Z dd„Zdd„Zdd„Zdd„Zdd „Zd!d"„Zd#d$„Zd%d&„Zd'd(„Zd)d*„Zd+d,„Zd-d.„Zd/d0„Zd1d2„Zd3d4„ZeeeƒZd5d6„Zd7d8„Z eee ƒZ!d9d:„Z"d;d<„Z#ee"e#ƒZ$d=d>„Z%d?d@„Z&ee%e&ƒZ'dAdB„Z(dCdD„Z)ee(e)ƒZ*dEdF„Z+dGdH„Z,ee+e,ƒZ-dIdJ„Z.dKdL„Z/ee.e/ƒZ0dMdN„Z1dOdP„Z2ee1e2ƒZ3dQdR„Z4dSdT„Z5ee4e5ƒZ6dUdV„Z7dWdX„Z8ee7e8ƒZ9dYdZ„Z:d[d\„Z;ee:e;ƒZee=e>ƒZ?dadb„Z@dcdd„ZAee@eAƒZBdedf„ZCdgdh„ZDeeCeDƒZEdidj„ZFdkdl„ZGeeFeGƒZHdmdn„ZIdodp„ZJeeIeJƒZKdqdr„ZLdsdt„ZMeeLeMƒZNdudv„ZOdwdx„ZPeeOePƒZQdydz„ZRd{d|„ZSeeReSƒZTd}d~„ZUdd€„ZVeeUeVƒZWdd‚„ZXdƒd„„ZYeeXeYƒZZd…d†„Z[d‡dˆ„Z\ee[e\ƒZ]d‰dŠ„Z^d‹dŒ„Z_ee^e_ƒZ`ddŽ„Zadd„ZbeeaebƒZcd‘d’„Zdd“d”„ZeeedeeƒZfd•d–„Zgd—d˜„ZheegehƒZid™dš„Zjd›dœ„Zkddž„ZldŸd „Zmd¡d¢„Znd£d¤„Zod¥d¦„Zpd§d¨„ZqdÎd«d¬„Zrdd®„Zsd¯d°„Ztd±d²„Zud³d´„Zvdµd¶„Zwd·d¸„Zxd¹dº„Zyd»d¼„Zzd½d¾„Z{d¿dÀ„Z|dÁdÂ„Z}dÃdÄ„Z~dÅdÆ„ZdÇdÈ„Z€dÉdÊ„ZdËdÌ„Z‚dS)ÏÚPrettyTableNcKsZ|jddƒ|_g|_i|_i|_i|_g|_|r8||_ng|_dj ƒ|_ |j jdj ƒƒ|j jdj ƒƒx0|j D]&}||krŽ|j|||ƒqpd||<qpW|dp¤d|_ |d p²d|_|d pÀd|_|dd'krÜ|d|_nd|_|dpìd|_|dd(kr |d|_nd|_|dpt|_|dp,t|_|dpsz&PrettyTable.__init__..Ú int_formatÚfloat_formatÚ padding_widthrÚleft_padding_widthÚright_padding_widthÚ vertical_charú|Úhorizontal_charú-Ú junction_charú+Úprint_emptyÚformatÚxhtmlÚ attributes)TF)TF)TF)TF)'ÚgetrÚ_field_namesÚ_alignÚ_valignÚ _max_widthÚ_rowsÚfield_namesÚ_widthsrÚ_optionsÚextendÚ_validate_optionÚ_startÚ_endÚ_fieldsÚ_headerÚ _header_styleÚ_borderÚFRAMEÚ_hrulesÚALLÚ_vrulesÚ_sortbyÚ_reversesortÚ _sort_keyÚ_int_formatÚ _float_formatÚ_padding_widthÚ_left_padding_widthÚ_right_padding_widthÚ_unicodeÚ_vertical_charÚ_horizontal_charÚ_junction_charÚ_print_emptyÚ_formatZ_xhtmlÚ_attributes)Úselfr=ÚkwargsÚoptionrrrÚ__init__Ts^ zPrettyTable.__init__cCs.t|tƒst|ƒ}t|tƒs*t||jdƒ}|S)NÚstrict)Ú isinstanceÚ basestringÚstrÚunicoder)r[ÚvaluerrrrT±s zPrettyTable._unicodecCsª|t|ƒ}|dkr ||dS|dkr4|d|S|drŠt|ƒdrh|dd||dddS|ddd||ddSn|dd||ddSdS)NÚlú Úrrr)r )r[rrÚalignZexcessrrrÚ_justify¸s "zPrettyTable._justifycCsP|dkrt|jƒS|dkrD|jr*t|jƒS|jr>t|jdƒSdSnt|ƒ‚dS)NÚrowcountZcolcountr)rr<r8ÚAttributeError)r[ÚnamerrrÚ__getattr__Ís zPrettyTable.__getattr__cCs¤tƒ}|j|_x(|jD]}t|d|t|d|ƒƒqWt|dt|dƒƒt|tƒrtxJ|j|D]}|j|ƒq`Wn,t|t ƒr|j|j|ƒnt dt|ƒƒ‚|S)NÚ_r9z0Index %s is invalid, must be an integer or slice)rr=r?ÚsetattrÚgetattrr`Úslicer<Úadd_rowÚintÚ Exceptionrb)r[ÚindexÚnewÚattrÚrowrrrÚ__getitem__Ûs zPrettyTable.__getitem__cCs|jƒS)N)Ú__unicode__)r[rrrÚ__str__ìszPrettyTable.__str__cCs|jƒj|jƒS)N)rzÚencoder)r[rrrr{ïscCs|jƒS)N)Ú get_string)r[rrrrzòszPrettyTable.__unicode__cCs4|dkr|j|ƒn|dkr.|j||ƒn|d krD|j||ƒnì|d krZ|j||ƒnÖ|dkrp|j||ƒnÀ|dkr†|j||ƒnª|d krœ|j||ƒn”|dkr²|j||ƒn~|dkrÆ|j|ƒnj|dkrÜ|j ||ƒnT|dkrô|j ||ƒn<|dkr|j||ƒn$|dkr$|j||ƒnt d|ƒ‚dS)Nr=rrÚ max_widthr*r+r,r4r#r%r!r"rrr r$r5r3rr(r)r-r/r1r6zUnrecognised option: %s!)rrr~r*r+r,r4)rr r$r5r3)r-r/r1)Ú_validate_field_namesÚ_validate_nonnegative_intÚ_validate_field_nameÚ_validate_functionÚ_validate_hrulesÚ_validate_vrulesÚ_validate_all_field_namesÚ_validate_true_or_falseÚ_validate_header_styleÚ_validate_int_formatÚ_validate_float_formatÚ_validate_single_charÚ_validate_attributesrt)r[r]ÚvalrrrrAs6 zPrettyTable._validate_optioncCsæ|jrPyt|ƒt|jƒkst‚Wn.tk rNtdt|ƒt|jƒfƒ‚YnX|jr¨yt|ƒt|jdƒksrt‚Wn2tk r¦tdt|ƒt|jdƒfƒ‚YnXyt|ƒtt|ƒƒksÂt‚Wntk ràtdƒ‚YnXdS)NzJField name list has incorrect number of values, (actual) %d!=%d (expected)rzField names must be unique!)r8rÚAssertionErrorrtr<Úset)r[rŒrrrrs $z!PrettyTable._validate_field_namescCs2y|dkst‚Wntk r,tdƒ‚YnXdS)NÚcapÚtitleÚupperÚlowerz;Invalid header style, use cap, title, upper, lower or None!)rrr‘r’N)rrt)r[rŒrrrr‡0sz"PrettyTable._validate_header_stylecCs6y|dkst‚Wn tk r0td|ƒ‚YnXdS)NreÚcrgz'Alignment %s is invalid, use l, c or r!)rer“rg)rrt)r[rŒrrrÚ_validate_align6szPrettyTable._validate_aligncCs6y|dkst‚Wn tk r0td|ƒ‚YnXdS)NÚtÚmÚbz-Alignment %s is invalid, use t, m, b or None!)r•r–r—N)rrt)r[rŒrrrÚ_validate_valign<szPrettyTable._validate_valigncCsDyt|ƒdkst‚Wn*tk r>td||j|ƒfƒ‚YnXdS)NrzInvalid value for %s: %s!)rsrrtrT)r[rlrŒrrrr€Bsz%PrettyTable._validate_nonnegative_intcCs6y|dkst‚Wn tk r0td|ƒ‚YnXdS)NTFz-Invalid value for %s! Must be True or False.)TF)rrt)r[rlrŒrrrr†Hsz#PrettyTable._validate_true_or_falsecCsV|dkrdSy$t|ƒttfks"t‚|jƒs.t‚Wn tk rPtd|ƒ‚YnXdS)NÚz8Invalid value for %s! Must be an integer format string.)ÚtyperbrcrÚisdigitrt)r[rlrŒrrrrˆNsz PrettyTable._validate_int_formatcCs¨|dkrdSyvt|ƒttfks"t‚d|ks.t‚|jdƒ}t|ƒdksHt‚|ddksd|djƒsdt‚|ddks€|djƒs€t‚Wn tk r¢td|ƒ‚YnXdS)Nr™Ú.rrrz5Invalid value for %s! Must be a float format string.)ršrbrcrrrr›rt)r[rlrŒÚbitsrrrr‰Ws z"PrettyTable._validate_float_formatcCs8yt|dƒst‚Wn tk r2td|ƒ‚YnXdS)NÚ__call__z*Invalid value for %s! Must be a function.)Úhasattrrrt)r[rlrŒrrrr‚dszPrettyTable._validate_functioncCs>y|ttttfkst‚Wn tk r8td|ƒ‚YnXdS)Nz:Invalid value for %s! Must be ALL, FRAME, HEADER or NONE.)rJrHÚHEADERÚNONErrt)r[rlrŒrrrrƒjszPrettyTable._validate_hrulescCs<y|tttfkst‚Wn tk r6td|ƒ‚YnXdS)Nz3Invalid value for %s! Must be ALL, FRAME, or NONE.)rJrHr¡rrt)r[rlrŒrrrr„pszPrettyTable._validate_vrulescCs@y||jks|dkst‚Wn tk r:td|ƒ‚YnXdS)NzInvalid field name: %s!)r8rrt)r[rlrŒrrrrvsz PrettyTable._validate_field_namecCs@yx|D]}|j||ƒqWWntk r:tdƒ‚YnXdS)Nz)fields must be a sequence of field names!)rrrt)r[rlrŒr&rrrr…|s z%PrettyTable._validate_all_field_namescCs:yt|ƒdkst‚Wn tk r4td|ƒ‚YnXdS)Nrz4Invalid value for %s! Must be a string of length 1.)r rrt)r[rlrŒrrrrŠƒsz!PrettyTable._validate_single_charcCs4yt|tƒst‚Wntk r.tdƒ‚YnXdS)Nz4attributes must be a dictionary of name/value pairs!)r`Údictrrt)r[rlrŒrrrr‹‰sz PrettyTable._validate_attributescCs|jS)N)r8)r[rrrÚ_get_field_names“szPrettyTable._get_field_namescs$‡fdd„|Dƒ}ˆjd|ƒˆjr2ˆjdd…}|ˆ_ˆjr|rx&t||ƒD]\}}ˆj|ˆj|<qNWx>|D]}|ˆjkrpˆjj|ƒqpWnxˆjD]}dˆj|<q˜Wˆjo²|rx&t||ƒD]\}}ˆj|ˆj|<qÂWx@|D]}|ˆjkräˆjj|ƒqäWnxˆjD]}dˆj|<qWdS)Ncsg|]}ˆj|ƒ‘qSr)rT)rr&)r[rrr›sz0PrettyTable._set_field_names..r=r“r•)rAr8r9ÚzipÚpopr:)r[rŒZ old_namesZold_nameÚnew_nameÚfieldr)r[rÚ_set_field_namesšs* zPrettyTable._set_field_namescCs|jS)N)r9)r[rrrÚ _get_align´szPrettyTable._get_aligncCs(|j|ƒx|jD]}||j|<qWdS)N)r”r8r9)r[rŒr§rrrÚ _set_align¶s zPrettyTable._set_aligncCs|jS)N)r:)r[rrrÚ_get_valign¼szPrettyTable._get_valigncCs(|j|ƒx|jD]}||j|<qWdS)N)r˜r8r:)r[rŒr§rrrÚ_set_valign¾s zPrettyTable._set_valigncCs|jS)N)r;)r[rrrÚ_get_max_widthÄszPrettyTable._get_max_widthcCs*|jd|ƒx|jD]}||j|<qWdS)Nr~)rAr8r;)r[rŒr§rrrÚ_set_max_widthÆszPrettyTable._set_max_widthcCs|jS)zList or tuple of field names to include in displays Arguments: fields - list or tuple of field names to include in displays)rD)r[rrrÚ_get_fieldsÌszPrettyTable._get_fieldscCs|jd|ƒ||_dS)Nr)rArD)r[rŒrrrÚ_set_fieldsÓszPrettyTable._set_fieldscCs|jS)z{Start index of the range of rows to print Arguments: start - index of first data row to include in output)rB)r[rrrÚ _get_startØszPrettyTable._get_startcCs|jd|ƒ||_dS)Nr)rArB)r[rŒrrrÚ _set_startàszPrettyTable._set_startcCs|jS)z’End index of the range of rows to print Arguments: end - index of last data row to include in output PLUS ONE (list slice style))rC)r[rrrÚ_get_endåszPrettyTable._get_endcCs|jd|ƒ||_dS)Nr)rArC)r[rŒrrrÚ_set_endìszPrettyTable._set_endcCs|jS)z_Name of field by which to sort rows Arguments: sortby - field name to sort by)rL)r[rrrÚ_get_sortbyñszPrettyTable._get_sortbycCs|jd|ƒ||_dS)Nr#)rArL)r[rŒrrrÚ_set_sortbyøszPrettyTable._set_sortbycCs|jS)z®Controls direction of sorting (ascending vs descending) Arguments: reveresort - set to True to sort by descending order, or False to sort by ascending order)rM)r[rrrÚ_get_reversesortýszPrettyTable._get_reversesortcCs|jd|ƒ||_dS)Nr$)rArM)r[rŒrrrÚ_set_reversesortszPrettyTable._set_reversesortcCs|jS)zªSorting key function, applied to data points before sorting Arguments: sort_key - a function which takes one argument and returns something to be sorted)rN)r[rrrÚ _get_sort_key szPrettyTable._get_sort_keycCs|jd|ƒ||_dS)Nr%)rArN)r[rŒrrrÚ _set_sort_keyszPrettyTable._set_sort_keycCs|jS)z‹Controls printing of table header with field names Arguments: header - print a header showing field names (True or False))rE)r[rrrÚ_get_headerszPrettyTable._get_headercCs|jd|ƒ||_dS)Nr)rArE)r[rŒrrrÚ_set_headerszPrettyTable._set_headercCs|jS)zºControls stylisation applied to field names in header Arguments: header_style - stylisation to apply to field names in header ("cap", "title", "upper", "lower" or None))rF)r[rrrÚ_get_header_style!szPrettyTable._get_header_stylecCs|j|ƒ||_dS)N)r‡rF)r[rŒrrrÚ_set_header_style(s zPrettyTable._set_header_stylecCs|jS)z~Controls printing of border around table Arguments: border - print a border around the table (True or False))rG)r[rrrÚ_get_border-szPrettyTable._get_bordercCs|jd|ƒ||_dS)Nr )rArG)r[rŒrrrÚ_set_border4szPrettyTable._set_bordercCs|jS)z˜Controls printing of horizontal rules after rows Arguments: hrules - horizontal rules style. Allowed values: FRAME, ALL, HEADER, NONE)rI)r[rrrÚ_get_hrules9szPrettyTable._get_hrulescCs|jd|ƒ||_dS)Nr!)rArI)r[rŒrrrÚ_set_hrules@szPrettyTable._set_hrulescCs|jS)z‘Controls printing of vertical rules between columns Arguments: vrules - vertical rules style. Allowed values: FRAME, ALL, NONE)rK)r[rrrÚ_get_vrulesEszPrettyTable._get_vrulescCs|jd|ƒ||_dS)Nr")rArK)r[rŒrrrÚ_set_vrulesLszPrettyTable._set_vrulescCs|jS)zbControls formatting of integer data Arguments: int_format - integer format string)rO)r[rrrÚ_get_int_formatQszPrettyTable._get_int_formatcCsx|jD]}||j|<qWdS)N)r8rO)r[rŒr§rrrÚ_set_int_formatWszPrettyTable._set_int_formatcCs|jS)zrControls formatting of floating point data Arguments: float_format - floating point format string)rP)r[rrrÚ_get_float_format]szPrettyTable._get_float_formatcCsx|jD]}||j|<qWdS)N)r8rP)r[rŒr§rrrÚ_set_float_formatcszPrettyTable._set_float_formatcCs|jS)zœThe number of empty spaces between a column's edge and its content Arguments: padding_width - number of spaces, must be a positive integer)rQ)r[rrrÚ_get_padding_widthiszPrettyTable._get_padding_widthcCs|jd|ƒ||_dS)Nr*)rArQ)r[rŒrrrÚ_set_padding_widthpszPrettyTable._set_padding_widthcCs|jS)z The number of empty spaces between a column's left edge and its content Arguments: left_padding - number of spaces, must be a positive integer)rR)r[rrrÚ_get_left_padding_widthusz#PrettyTable._get_left_padding_widthcCs|jd|ƒ||_dS)Nr+)rArR)r[rŒrrrÚ_set_left_padding_width|sz#PrettyTable._set_left_padding_widthcCs|jS)z¢The number of empty spaces between a column's right edge and its content Arguments: right_padding - number of spaces, must be a positive integer)rS)r[rrrÚ_get_right_padding_widthsz$PrettyTable._get_right_padding_widthcCs|jd|ƒ||_dS)Nr,)rArS)r[rŒrrrÚ_set_right_padding_widthˆsz$PrettyTable._set_right_padding_widthcCs|jS)z¥The charcter used when printing table borders to draw vertical lines Arguments: vertical_char - single character string used to draw vertical lines)rU)r[rrrÚ_get_vertical_charszPrettyTable._get_vertical_charcCs |j|ƒ}|jd|ƒ||_dS)Nr-)rTrArU)r[rŒrrrÚ_set_vertical_char”s zPrettyTable._set_vertical_charcCs|jS)z«The charcter used when printing table borders to draw horizontal lines Arguments: horizontal_char - single character string used to draw horizontal lines)rV)r[rrrÚ_get_horizontal_charšsz PrettyTable._get_horizontal_charcCs |j|ƒ}|jd|ƒ||_dS)Nr/)rTrArV)r[rŒrrrÚ_set_horizontal_char¡s z PrettyTable._set_horizontal_charcCs|jS)z¥The charcter used when printing table borders to draw line junctions Arguments: junction_char - single character string used to draw line junctions)rW)r[rrrÚ_get_junction_char§szPrettyTable._get_junction_charcCs |j|ƒ}|jd|ƒ||_dS)Nr-)rTrArW)r[rŒrrrÚ_set_junction_char®s zPrettyTable._set_junction_charcCs|jS)z~Controls whether or not HTML tables are formatted to match styling options Arguments: format - True or False)rY)r[rrrÚ_get_format´szPrettyTable._get_formatcCs|jd|ƒ||_dS)Nr4)rArY)r[rŒrrrÚ_set_format»szPrettyTable._set_formatcCs|jS)zControls whether or not empty tables produce a header and frame or just an empty string Arguments: print_empty - True or False)rX)r[rrrÚ_get_print_emptyÀszPrettyTable._get_print_emptycCs|jd|ƒ||_dS)Nr3)rArX)r[rŒrrrÚ_set_print_emptyÇszPrettyTable._set_print_emptycCs|jS)z§A dictionary of HTML attribute name/value pairs to be included in the tag when printing HTML Arguments: attributes - dictionary of attributes)rZ)r[rrrÚ_get_attributesÌszPrettyTable._get_attributescCs|jd|ƒ||_dS)Nr6)rArZ)r[rŒrrrÚ_set_attributesÓszPrettyTable._set_attributescCsPi}xF|jD]<}||kr6|j|||ƒ||||<qt|d|ƒ||<qW|S)Nrn)r?rArp)r[r\Úoptionsr]rrrÚ_get_optionsÜszPrettyTable._get_optionscCsT|tkr|jƒn>|tkr$|jƒn,|tkr6|jƒn|tkrH|jƒntdƒ‚dS)NzInvalid pre-set style!) ÚDEFAULTÚ_set_default_styleÚMSWORD_FRIENDLYÚ_set_msword_styleÚ PLAIN_COLUMNSÚ_set_columns_styleÚRANDOMÚ_set_random_stylert)r[ZstylerrrÚ set_styleës zPrettyTable.set_stylecCs@d|_d|_t|_t|_d|_d|_d|_d|_ d|_ d|_dS)NTrr.r0r2)rr rHrIrJrKr*r+r,r-r/r1)r[rrrrÞøszPrettyTable._set_default_stylecCs.d|_d|_t|_d|_d|_d|_d|_dS)NTrr.)rr r¡rIr*r+r,r-)r[rrrràszPrettyTable._set_msword_stylecCs"d|_d|_d|_d|_d|_dS)NTFrré)rr r*r+r,)r[rrrrâs zPrettyTable._set_columns_stylecCs‚tjdƒ|_tjdƒ|_tjttttfƒ|_tjtttfƒ|_ tj ddƒ|_tj ddƒ|_tjdƒ|_ tjdƒ|_tjdƒ|_dS)NTFréz ~!@#$%^&*()_+|-=\{}[];':",./;<>?)TF)TF)ÚrandomZchoicerr rJrHr r¡rIrKZrandintr+r,r-r/r1)r[rrrräszPrettyTable._set_random_stylecCsf|jr2t|ƒt|jƒkr2tdt|ƒt|jƒfƒ‚|jsRdd„tdt|ƒƒDƒ|_|jjt|ƒƒdS)zAdd a row to the table Arguments: row - row of data, should be a list with as many elements as the table has fieldsz>Row has incorrect number of values, (actual) %d!=%d (expected)cSsg|]}d|d‘qS)zField %drr)rÚnrrrr4sz'PrettyTable.add_row..rN)r8rrtÚranger=r<ÚappendÚlist)r[rxrrrrr(s zPrettyTable.add_rowcCs4|t|jƒdkr(td|t|jƒfƒ‚|j|=dS)z‚Delete a row to the table Arguments: row_index - The index of the row you want to delete. Indexing starts at 0.rz4Cant delete row at index %d, table only has %d rows!N)rr<rt)r[Z row_indexrrrÚdel_row7szPrettyTable.del_rowr“r•cCs´t|jƒdt|ƒfkr–|j|ƒ|j|ƒ|jj|ƒ||j|<||j|<xdtdt|ƒƒD]6}t|jƒ|dkr||jjgƒ|j|j||ƒqZWnt dt|ƒt|jƒfƒ‚dS)aAdd a column to the table. Arguments: fieldname - name of the field to contain the new column of data column - column of data, should be a list with as many elements as the table has rows align - desired alignment for this column - "l" for left, "c" for centre and "r" for right valign - desired vertical alignment for new columns - "t" for top, "m" for middle and "b" for bottomrrz2Column length %d does not match number of rows %d!N) rr<r”r˜r8rër9r:rêrt)r[Ú fieldnameÚcolumnrhÚvalignÚirrrÚ add_columnCs zPrettyTable.add_columncCs g|_dS)z?Delete all rows from the table but keep the current field namesN)r<)r[rrrÚ clear_rows\szPrettyTable.clear_rowscCsg|_g|_g|_dS)zWDelete all rows and field names from the table, maintaining nothing but styling optionsN)r<r8r>)r[rrrÚclearbszPrettyTable.clearcCs tj|ƒS)N)ÚcopyÚdeepcopy)r[rrrrõnszPrettyTable.copycCsdt|tƒr.||jkr.|jd|j||ƒ}n,t|tƒrZ||jkrZ|jd|j||ƒ}|j|ƒS)Nz%%%sdz%%%sf)r`rsrOrTÚfloatrP)r[r§rdrrrÚ _format_valueus zPrettyTable._format_valuecCs®|drdd„|jDƒ}nt|jƒdg}xx|D]p}xjt|ƒD]^\}}|j|}||jkr‚t||tt|ƒd|j|ƒƒ||<q>t||t|ƒdƒ||<q>Wq0W||_dS)NrcSsg|]}t|ƒd‘qS)r)r)rr§rrrr~sz/PrettyTable._compute_widths..r) r8rr=Ú enumerater~rÚminrr>)r[ÚrowsrÛZwidthsrxrurdrîrrrÚ_compute_widths|s ("zPrettyTable._compute_widthscCsD|ddk r|d}n|d}|ddk r4|d}n|d}||fS)Nr+r*r,r)r[rÛÚlpadÚrpadrrrÚ_get_padding_widthsŠs zPrettyTable._get_padding_widthscsntj|j|d|d…ƒ}|drj|jj|dƒ‰‡fdd„|Dƒ}|j|d|ddd d„|Dƒ}|S) z—Return only those data rows that should be printed, based on slicing and sorting. Arguments: options - dictionary of option settings.rrr#csg|]}|ˆg|‘qSrr)rrx)Ú sortindexrrr£sz)PrettyTable._get_rows..r$r%)ÚreverseÚkeycSsg|]}|dd…‘qS)rNr)rrxrrrr§s)rõrör<r8ruÚsort)r[rÛrûr)rrÚ _get_rows–szPrettyTable._get_rowscs‡fdd„tˆj|ƒDƒS)Ncsg|]\}}ˆj||ƒ‘qSr)rø)rr§rd)r[rrr«sz+PrettyTable._format_row..)r¤r8)r[rxrÛr)r[rÚ_format_rowªszPrettyTable._format_rowcs‡‡fdd„|DƒS)Ncsg|]}ˆj|ˆƒ‘qSr)r)rrx)rÛr[rrr®sz,PrettyTable._format_rows..r)r[rûrÛr)rÛr[rÚ_format_rowsszPrettyTable._format_rowscKsì|j|ƒ}g}|jdkr0|ds,|dr0dS|j|ƒ}|j||ƒ}|j||ƒ|j|ƒ|_|drx|j|j|ƒƒn$|drœ|dt t fkrœ|j|jƒx|D]}|j|j||ƒƒq¢W|drÜ|dt krÜ|j|jƒ|jdƒj |ƒS)a"Return string representation of table in current state. Arguments: start - index of first data row to include in output end - index of last data row to include in output PLUS ONE (list slice style) fields - names of fields (columns) to include header - print a header showing field names (True or False) border - print a border around the table (True or False) hrules - controls printing of horizontal rules after rows. Allowed values: ALL, FRAME, HEADER, NONE vrules - controls printing of vertical rules between columns. Allowed values: FRAME, ALL, NONE int_format - controls formatting of integer data float_format - controls formatting of floating point data padding_width - number of spaces on either side of column data (only used if left and right paddings are None) left_padding_width - number of spaces on left hand side of column data right_padding_width - number of spaces on right hand side of column data vertical_char - single character string used to draw vertical lines horizontal_char - single character string used to draw horizontal lines junction_char - single character string used to draw line junctions sortby - name of field to sort rows by sort_key - sorting key function, applied to data points before sorting reversesort - True or False to sort in descending or ascending order print empty - if True, stringify just the header for an empty table, if False return an empty string rr3r r™rr!r)rÜrjrrrüÚ_stringify_hruleÚ_hrulerëÚ_stringify_headerrJrHÚ_stringify_rowrTÚjoin)r[r\rÛrrûÚformatted_rowsrxrrrr}´s" zPrettyTable.get_stringcCs|dsdS|j|ƒ\}}|dttfkr6|dg}n |dg}|js^|j|dƒdj|ƒSxtt|j|jƒD]b\}}|drŒ||dkrŒqn|j||||dƒ|dtkrÂ|j|dƒqn|j|dƒqnW|dtkrö|jƒ|j|dƒdj|ƒS)Nr r™r"r1r/r) rÿrJrHr8rërr¤r>r¥)r[rÛrýrþrr§rrrrrñs( zPrettyTable._stringify_hrulecCsäg}|j|ƒ\}}|drj|dttfkr@|j|jƒ|jdƒ|dttfkr`|j|dƒn |jdƒ|jsš|dttfkr|j|dƒn |jdƒxât|j|jƒD]Ð\}}|drÈ||dkrÈqª|jdkrÜ|j ƒ}nD|jd krð|j ƒ}n0|jd kr|jƒ}n|jdkr|jƒ}n|}|jd||j |||j|ƒd|ƒ|drª|dtkrp|j|dƒqª|jdƒqªW|dr¬|dtkr¬|jƒ|j|dƒ|drÚ|dtkrÚ|jdƒ|j|jƒdj|ƒS) Nr r!rr"r-rfrrrr‘r’r™)rÿrJrHrërr8r¤r>rFÚ capitalizerr‘r’rir9r¥r¡r)r[rÛrrýrþr§rrîrrrr sJ * zPrettyTable._stringify_headerc Csx€ttdt|ƒƒ|j||jƒD]`\}}}}|jdƒ}g}x.|D]&} t| ƒ|krZtj| |ƒ} |j | ƒq>W|}dj |ƒ}|||<qWd} x$|D]}t|ƒd}|| krŒ|} qŒWg} |j|ƒ\}}xVtd| ƒD]H}| j gƒ|drÊ|dt tfkr| |j |jƒqÊ| |j dƒqÊWxFt|j||jƒD]0\}}}|j|}|jdƒ}| t|ƒ}|r¼|dkr”dgt|d ƒ|dg|t|d ƒ}n(|d kr®dg||}n|dg|}d}x˜|D]}|dræ||dkræqÆ| |j d||j|||j|ƒd|ƒ|drL|dt kr>| |j |jƒn| |j dƒ|d7}qÆWq*WxJtd| ƒD]<}|drl|dtkrl| |jƒ| |j |dƒqlW|drê|d t krê| | dj dƒ| | dj |jƒx&td| ƒD]}dj | |ƒ| |<qöWdj | ƒS)Nrrrr r"rfr–r™rr—rr-r!)r¤rêrr8r>rr ÚtextwrapZfillrërrrÿrJrHr-r:rsrir9r¥r)r[rxrÛrur§rdrrZ new_linesrZ row_heightr“ÚhrrýrþÚyrðZdHeightrerrrr :sj* . . zPrettyTable._stringify_rowcKs,|j|ƒ}|dr|j|ƒ}n |j|ƒ}|S)a;Return string representation of HTML formatted version of table in current state. Arguments: start - index of first data row to include in output end - index of last data row to include in output PLUS ONE (list slice style) fields - names of fields (columns) to include header - print a header showing field names (True or False) border - print a border around the table (True or False) hrules - controls printing of horizontal rules after rows. Allowed values: ALL, FRAME, HEADER, NONE vrules - controls printing of vertical rules between columns. Allowed values: FRAME, ALL, NONE int_format - controls formatting of integer data float_format - controls formatting of floating point data padding_width - number of spaces on either side of column data (only used if left and right paddings are None) left_padding_width - number of spaces on left hand side of column data right_padding_width - number of spaces on right hand side of column data sortby - name of field to sort rows by sort_key - sorting key function, applied to data points before sorting attributes - dictionary of name/value pairs to include as HTML attributes in the

tag xhtml - print
tags if True,
tags if falser4)rÜÚ_get_formatted_html_stringÚ_get_simple_html_string)r[r\rÛÚstringrrrÚget_html_string†s zPrettyTable.get_html_stringcCsrg}|drd}nd}g}|jdƒ|drXx*|dD]}|jd||d|fƒq6W|jdƒ|jdj|ƒƒ|d rÎ|jd ƒx>|jD]4}|dr¦||dkr¦qŒ|jdt|ƒjd |ƒƒqŒW|jdƒ|j|ƒ}|j||ƒ}xr|D]j} |jd ƒxPt|j| ƒD]@\}} |dr*||dkr*q|jdt| ƒjd |ƒƒqW|jdƒqêW|jdƒ|jd ƒj|ƒS)Nr5z
z
zr™rz rz rz z z

%s
%s

) rërr8rÚreplacerrr¤rT)r[rÛrÚ linebreakÚopen_tagÚ attr_namer§rûrrxÚdatumrrrr¦s: z#PrettyTable._get_simple_html_stringcCsÐg}|j|ƒ\}}|dr d}nd}g}|jdƒ|dr|dtkr`|dtkr`|jdƒn¨|dtkr„|dtkr„|jd ƒn„|dtkr¨|dtkr¨|jd ƒn`|dtkrÀ|jdƒnH|dtkrØ|jdƒn0|dtkrð|jd ƒn|dtkr|jdƒ|dr@x,|dD] }|jd||d|fƒqW|jdƒ|jdj|ƒƒ|drÆ|jdƒxL|jD]B}|dr–||dkr–qv|jd||t|ƒjd|ƒfƒqvW|jdƒ|j|ƒ} |j | |ƒ} g}g}xH|jD]>}|jddddœ|j |ƒ|jdddd œ|j|ƒqìWx†| D]~} |jdƒxbt|j| ||ƒD]N\}}}}|dr|||dkr|qT|jd!||||t|ƒjd|ƒfƒqTW|jdƒq4W|jd"ƒ|j dƒj|ƒS)#Nr5z
z
zrzW %srz ÚleftÚrightÚcenter)rergr“ÚtopZmiddleZbottom)r•r–r—zg %sz)rÿrërJrHrr8rrrrr9r:r¤rT)r[rÛrrýrþrrrr§rûrZalignsZvalignsrxrrhrðrrrrÎsd & " * z&PrettyTable._get_formatted_html_string)N)r“r•)ƒÚ__name__Ú __module__Ú__qualname__r^rTrirmryÚpy3kr{rzrArr‡r”r˜r€r†rˆr‰r‚rƒr„rr…rŠr‹r£r¨Úpropertyr=r©rªrhr«r¬rðrr®r~r¯r°rr±r²rr³r´rrµr¶r#r·r¸r$r¹rºr%r»r¼rr½r¾rr¿rÀr rÁrÂr!rÃrÄr"rÅrÆr(rÇrÈr)rÉrÊr*rËrÌr+rÍrÎr,rÏrÐr-rÑrÒr/rÓrÔr1rÕrÖr4r×rØr3rÙrÚr6rÜrårÞràrârärrríròrórôrõrørürÿrrrr}rr r rrrrrrrrRs ] =/L (rcCsîd|kodknrdSd|ko.dknr8dSd|koJdknrTdStjt|ƒƒrfd Sd |koxdkns–d|kod knršdSd|ko¬dknr¶dSd|koÈdknrÒdS|dkrÞdS|dkrêd SdS)Né!é~riNiÿŸri¬i¯×ri@0iŸ0i 0iÿ0iÿi`ÿi0i>0ræéé)rær&éÿÿÿÿ)rr')ÚunicodedataZ combiningÚuni_chr)ÚcharrrrÚ_char_block_widths&0r,cCsttttttjd|ƒƒƒƒS)Nr™)ÚsumÚitermapr,ÚordÚ_reÚsub)rŒrrrr /sr cKs”tjƒj|jdƒƒ}|jdƒtj||ƒ}tf|Ž}|r@||_n.trZdd„t |ƒDƒ|_ndd„|j ƒDƒ|_x |D]}|j dd„|DƒƒqtW|S)NircSsg|]}|jƒ‘qSr)Ústrip)rr&rrrrBszfrom_csv..cSsg|]}|jƒ‘qSr)r2)rr&rrrrDscSsg|]}|jƒ‘qSr)r2)rr&rrrrGs)ÚcsvZSnifferZsniffÚreadÚseekÚreaderrr=r"Únextrr)Úfpr=r\Zdialectr6ÚtablerxrrrÚfrom_csv7s r:cKsF|jrBtf|Ž}dd„|jDƒ|_x|jƒD]}|j|ƒq,W|SdS)NcSsg|]}|d‘qS)rr)rÚcolrrrrOsz"from_db_cursor..)Údescriptionrr=Zfetchallrr)Zcursorr\r9rxrrrÚfrom_db_cursorKs r=c@s<eZdZdd„Zdd„Zdd„Zdd„Zd d „Zdd„Zd S)ÚTableHandlercKs>tj|ƒ||_g|_g|_g|_d|_d|_d|_d|_ dS)Nrr™F) rr^r\ÚtablesÚlast_rowrûÚ max_row_widthÚactiveÚlast_contentÚis_last_row_header)r[r\rrrr^Vs zTableHandler.__init__cCs||_|dkrd|_dS)NÚthT)rBrD)r[ÚtagÚattrsrrrÚhandle_starttagaszTableHandler.handle_starttagcCs|dkr|jjƒ}|jj|ƒ|dkrZ|jj|j|jfƒt|jt|jƒƒ|_g|_d|_|dkr€|j |jƒ}|j j|ƒg|_d|_d|_dS)NrEÚtdZtrFr9rf)rErI)rCr2r@rërûrDrrArÚgenerate_tabler?rB)r[rFZstripped_contentr9rrrÚ handle_endtagfs zTableHandler.handle_endtagcCs|j|7_dS)N)rC)r[ÚdatarrrÚhandle_dataxszTableHandler.handle_datacCsštf|jŽ}xˆ|jD]~}t|dƒ|jkr^|jt|dƒ}x td|ƒD]}|djdƒqHW|ddkr„|j|dƒ|d|_q|j |dƒqW|S)zE Generates from a list of rows a PrettyTable object. rrr0T) rr\rûrrArêrëÚmake_fields_uniquer=rr)r[rûr9rxZappendsrñrrrrJ{szTableHandler.generate_tablecCsXxRtdt|ƒƒD]@}x:t|dt|ƒƒD]$}||||kr(||d7<q(WqWdS)zB iterates over the row and make each field unique rrú'N)rêr)r[rrñÚjrrrrNszTableHandler.make_fields_uniqueN) rr r!r^rHrKrMrJrNrrrrr>Tsr>cKstf|Ž}|j|ƒ|jS)zƒ Generates a list of PrettyTables from a string of HTML code. Each in the HTML becomes one PrettyTable object. )r>Zfeedr?)Ú html_coder\ÚparserrrrÚ from_html–s rScKsFt|f|Ž}yt|ƒdkst‚Wntk r<tdƒ‚YnX|dS)zf Generates a PrettyTables from a string of HTML code which contains only a single

rzDMore than one

in provided HTML code! Use from_html instead.r)rSrrrt)rQr\r?rrrÚ from_html_one srTcCsÀtddddgƒ}d|_d|_d|jd<d|_d|jd<|jd d ddgƒ|jd dddgƒ|jddddgƒ|jddddgƒ|jddddgƒ|jdddd gƒ|jd!d"d#d$gƒt|ƒdS)%Nz City nameZAreaZ PopulationzAnnual RainfallTZ04dz6.1freZAdelaideiis¬gÄ‚@ZBrisbaneii:Xgš™™™™é‘@ZDarwinépiDØgÍÌÌÌÌÊš@ZHobartiMiô"g\ƒ@ZSydneyi iö*Bg33333û’@Z MelbourneiiŒ:g333337„@ZPerthi iQ¹g33333+‹@)rr#r$r(r)rhrrÚprint)r&rrrÚmain±s rWÚ__main__)N)2Ú__version__rõr3rèÚreÚsysrÚ itertoolsr)Úversion_infor"rbrcraÚmapr.r¤ZiterzipÚchrr*Zhtml.parserrZimapZizipZunichrZhtmlrZcgirHrJr¡r rÝrßrárãÚcompiler0rÚobjectrr,r r:r=r>rSrTrWrrrrrÚ sj E! B