a ¬[ôa¾Äã@s`dZddlZddlZddlZddlZddlZddlZddlZddlZej ddkZ e rxe Z e Z eZeZeZddlmZnejZejZeZddlmZe r´ej ddkr´ddlmZn ddlmZdZdZdZdZdZ d Z!d Z"d Z#e $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,| d¡}t|ƒ}tdd„|Dƒƒ}||fS)NÚ cSsg|] }t|ƒ‘qS©©Ú_str_block_width)Ú.0Úliner r ú,/home/zeyad/Desktop/Ninja/lib/prettytable.pyÚ )óz_get_size..)ÚsplitÚlenÚmax)ÚtextÚlinesÚheightÚwidthr r rÚ _get_size&s rc@sBeZdZdÍdd„Zdd„Zdd„Zdd „Zd d „Zer@d d „Z ndd „Z dd„Z dd„Z dd„Z dd„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¬„Zrd­d®„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)ÏÚ PrettyTableNcKsV| dd¡|_g|_i|_i|_i|_g|_|r8||_ng|_d  ¡|_ |j   d  ¡¡|j   d  ¡¡|j D]&}||vrŒ|  |||¡qnd||<qn|dp d|_ |d p®d|_|d p¼d|_|d d vrØ|d |_nd |_|dpèd|_|dd vr|d|_nd |_|dpt|_|dp(t|_|dp8d|_|dd vrV|d|_nd|_|dpldd„|_|dp|i|_|dpŒi|_|dpœd|_|dp¬d|_|dp¼d|_|dpÒ| d¡|_ |d pè| d!¡|_!|d"pþ| d#¡|_"|d$d vr|d$|_#nd |_#|d%p.d|_$|d&p>d|_%|d'pNi|_&dS)(aáReturn a new PrettyTable instance Arguments: encoding - Unicode encoding scheme used to decode any encoded input field_names - list or tuple of field names fields - list or tuple of field names to include in displays 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) header - print a header showing field names (True or False) header_style - stylisation to apply to field names in header ("cap", "title", "upper", "lower" or None) border - print a border around the table (True or False) hrules - controls printing of horizontal rules after rows. Allowed values: FRAME, HEADER, ALL, 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 valign - default valign for each row (None, "t", "m" or "b") reversesort - True or False to sort in descending or ascending orderÚencodingÚcp1252zZstart end fields header border sortby reversesort sort_key attributes format hrules vruleszLint_format float_format padding_width left_padding_width right_padding_widthzQvertical_char horizontal_char junction_char header_style valign xhtml print_emptyNÚstartrÚendÚfieldsÚheader©TFTÚ header_styleÚborderÚhrulesÚvrulesÚsortbyÚ reversesortFÚsort_keycSs|S©Nr ©Úxr r rÚprz&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)'Ú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Ú_formatÚ_xhtmlÚ _attributes)ÚselfrDÚkwargsÚoptionr r rÚ__init__/s`        zPrettyTable.__init__cCs.t|tƒst|ƒ}t|tƒs*t||jdƒ}|S)NÚstrict)Ú isinstanceÚ basestringÚstrÚunicoder)rcÚvaluer r rr[‚s   zPrettyTable._unicodecCsª|t|ƒ}|dkr ||dS|dkr4|d|S|drŠt|ƒdrh|dd||dddS|ddd||ddSn|dd||ddSdS)NÚlú Úrrrr )rcrrÚalignÚexcessr r rÚ_justify‰s     "zPrettyTable._justifycCsP|dkrt|jƒS|dkrD|jr*t|jƒS|jr>t|jdƒSdSnt|ƒ‚dS)NÚrowcountÚcolcountr)rrCr?ÚAttributeError)rcÚnamer r rÚ __getattr__—s  zPrettyTable.__getattr__cCsœtƒ}|j|_|jD]}t|d|t|d|ƒƒqt|dt|dƒƒt|tƒrl|j|D]}| |¡qZn,t|t ƒrˆ| |j|¡nt dt |ƒƒ‚|S)NÚ_r@z0Index %s is invalid, must be an integer or slice) rrDrFÚsetattrÚgetattrrhÚslicerCÚadd_rowÚintÚ Exceptionrj)rcÚindexÚnewÚattrÚrowr r rÚ __getitem__¤s   zPrettyTable.__getitem__cCs| ¡Sr+)Ú __unicode__©rcr r rÚ__str__·szPrettyTable.__str__cCs| ¡ |j¡Sr+)r„Úencoderr…r r rr†¼scCs| ¡Sr+)Ú get_stringr…r r rr„¿szPrettyTable.__unicode__cCs2|dvr| |¡n|dvr.| ||¡n|dvrD| ||¡nê|dvrZ| ||¡nÔ|dvrp| ||¡n¾|dvr†| ||¡n¨|dvrœ| ||¡n’|dvr²| ||¡n||d vrÆ| |¡nh|d vrÜ|  ||¡nR|d vrò|  ||¡n<|d vr |  ||¡n$|d vr"|  ||¡n t d|ƒ‚dS)NrD)rr Ú max_widthr1r2r3r;r(r*r&r'r!)r"r%r)r<r:r$r/r0)r4r6r8r=zUnrecognised option: %s!)Ú_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_attributesr~)rcreÚvalr r rrHÂs6   zPrettyTable._validate_optionc Csà|jrNzt|ƒt|jƒksJ‚Wn,tyLtdt|ƒt|jƒfƒ‚Yn0|jr¤zt|ƒt|jdƒkspJ‚Wn0ty¢tdt|ƒt|jdƒfƒ‚Yn0zt|ƒtt|ƒƒks¾J‚WntyÚtdƒ‚Yn0dS)NzJField name list has incorrect number of values, (actual) %d!=%d (expected)rzField names must be unique!)r?rÚAssertionErrorr~rCÚset©rcr—r r rrŠàs   $ z!PrettyTable._validate_field_namescCs0z|dvsJ‚Wnty*tdƒ‚Yn0dS)N)ÚcapÚtitleÚupperÚlowerNz;Invalid header style, use cap, title, upper, lower or None!©r˜r~ršr r rr’òs  z"PrettyTable._validate_header_stylecCs4z|dvsJ‚Wnty.td|ƒ‚Yn0dS)N)rmÚcroz'Alignment %s is invalid, use l, c or r!rŸršr r rÚ_validate_alignús zPrettyTable._validate_aligncCs4z|dvsJ‚Wnty.td|ƒ‚Yn0dS)N)ÚtÚmÚbNz-Alignment %s is invalid, use t, m, b or None!rŸršr r rÚ_validate_valigns  zPrettyTable._validate_valignc CsBzt|ƒdksJ‚Wn(ty<td|| |¡fƒ‚Yn0dS)NrzInvalid value for %s: %s!)r}r˜r~r[©rcrvr—r r rr‹s z%PrettyTable._validate_nonnegative_intcCs4z|dvsJ‚Wnty.td|ƒ‚Yn0dS)Nr#z-Invalid value for %s! Must be True or False.rŸr¦r r rr‘s z#PrettyTable._validate_true_or_falsecCsT|dkr dSz$t|ƒttfvs"J‚| ¡s.J‚WntyNtd|ƒ‚Yn0dS)NÚz8Invalid value for %s! Must be an integer format string.)ÚtyperjrkÚisdigitr˜r~r¦r r rr“s z PrettyTable._validate_int_formatcCs¦|dkr dSzvt|ƒttfvs"J‚d|vs.J‚| d¡}t|ƒdksHJ‚|ddksd|d ¡sdJ‚|ddks€|d ¡s€J‚Wnty td|ƒ‚Yn0dS)Nr§Ú.rrrz5Invalid value for %s! Must be a float format string.)r¨rjrkrrr©r˜r~)rcrvr—Úbitsr r rr”s    z"PrettyTable._validate_float_formatcCs6zt|dƒsJ‚Wnty0td|ƒ‚Yn0dS)NÚ__call__z*Invalid value for %s! Must be a function.)Úhasattrr˜r~r¦r r rr*s zPrettyTable._validate_functioncCs<z|ttttfvsJ‚Wnty6td|ƒ‚Yn0dS)Nz:Invalid value for %s! Must be ALL, FRAME, HEADER or NONE.)rQrOÚHEADERÚNONEr˜r~r¦r r rrŽ0sý zPrettyTable._validate_hrulescCs:z|tttfvsJ‚Wnty4td|ƒ‚Yn0dS)Nz3Invalid value for %s! Must be ALL, FRAME, or NONE.)rQrOr¯r˜r~r¦r r rr9s zPrettyTable._validate_vrulescCs>z||jvs|dusJ‚Wnty8td|ƒ‚Yn0dS)NzInvalid field name: %s!)r?r˜r~r¦r r rrŒ?s  z PrettyTable._validate_field_namecCs:z|D]}| ||¡qWnty4tdƒ‚Yn0dS)Nz)fields must be a sequence of field names!)rŒr˜r~)rcrvr—r-r r rrGs  z%PrettyTable._validate_all_field_namescCs8zt|ƒdksJ‚Wnty2td|ƒ‚Yn0dS)Nrz4Invalid value for %s! Must be a string of length 1.)rr˜r~r¦r r rr•Os z!PrettyTable._validate_single_charcCs2zt|tƒsJ‚Wnty,tdƒ‚Yn0dS)Nz4attributes must be a dictionary of name/value pairs!)rhÚdictr˜r~r¦r r rr–Us z PrettyTable._validate_attributescCs|jSr+)r?r…r r rÚ_get_field_names[szPrettyTable._get_field_namescs‡fdd„|Dƒ}ˆ d|¡ˆjr2ˆjdd…}|ˆ_ˆjrˆ|rˆt||ƒD]\}}ˆj|ˆj|<qL|D]}|ˆjvrjˆj |¡qjnˆjD]}dˆj|<qŽˆjrî|rît||ƒD]\}}ˆj|ˆj|<q²|D]}|ˆjvrЈj |¡qÐnˆjD]}dˆj|<qôdS)Ncsg|]}ˆ |¡‘qSr )r[©rr-r…r rr_rz0PrettyTable._set_field_names..rDr r¢)rHr?r@ÚzipÚpoprA)rcr—Ú old_namesÚold_nameÚnew_nameÚfieldr r…rÚ_set_field_names^s*        zPrettyTable._set_field_namescCs|jSr+)r@r…r r rÚ _get_align~szPrettyTable._get_aligncCs$| |¡|jD]}||j|<qdSr+)r¡r?r@©rcr—r¸r r rÚ _set_aligns  zPrettyTable._set_aligncCs|jSr+)rAr…r r rÚ _get_valignˆszPrettyTable._get_valigncCs$| |¡|jD]}||j|<qdSr+)r¥r?rAr»r r rÚ _set_valign‹s  zPrettyTable._set_valigncCs|jSr+)rBr…r r rÚ_get_max_width’szPrettyTable._get_max_widthcCs&| d|¡|jD]}||j|<qdS)Nr‰)rHr?rBr»r r rÚ_set_max_width•s  zPrettyTable._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)rKr…r r rÚ _get_fieldsœszPrettyTable._get_fieldscCs| d|¡||_dS)Nr!)rHrKršr r rÚ _set_fields¤s zPrettyTable._set_fieldscCs|jS)z{Start index of the range of rows to print Arguments: start - index of first data row to include in output)rIr…r r rÚ _get_startªszPrettyTable._get_startcCs| d|¡||_dS)Nr)rHrIršr r rÚ _set_start²s zPrettyTable._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))rJr…r r rÚ_get_end¸szPrettyTable._get_endcCs| d|¡||_dS)Nr )rHrJršr r rÚ_set_endÀs zPrettyTable._set_endcCs|jS)z_Name of field by which to sort rows Arguments: sortby - field name to sort by)rSr…r r rÚ _get_sortbyÆszPrettyTable._get_sortbycCs| d|¡||_dS)Nr()rHrSršr r rÚ _set_sortbyÎs zPrettyTable._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)rTr…r r rÚ_get_reversesortÔszPrettyTable._get_reversesortcCs| d|¡||_dS)Nr))rHrTršr r rÚ_set_reversesortÜs zPrettyTable._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)rUr…r r rÚ _get_sort_keyâszPrettyTable._get_sort_keycCs| d|¡||_dS)Nr*)rHrUršr r rÚ _set_sort_keyês zPrettyTable._set_sort_keycCs|jS)z‹Controls printing of table header with field names Arguments: header - print a header showing field names (True or False))rLr…r r rÚ _get_headerðszPrettyTable._get_headercCs| d|¡||_dS)Nr")rHrLršr r rÚ _set_headerøs zPrettyTable._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))rMr…r r rÚ_get_header_styleþszPrettyTable._get_header_stylecCs| |¡||_dSr+)r’rMršr r rÚ_set_header_styles zPrettyTable._set_header_stylecCs|jS)z~Controls printing of border around table Arguments: border - print a border around the table (True or False))rNr…r r rÚ _get_border szPrettyTable._get_bordercCs| d|¡||_dS)Nr%)rHrNršr r rÚ _set_borders zPrettyTable._set_bordercCs|jS)z˜Controls printing of horizontal rules after rows Arguments: hrules - horizontal rules style. Allowed values: FRAME, ALL, HEADER, NONE)rPr…r r rÚ _get_hrulesszPrettyTable._get_hrulescCs| d|¡||_dS)Nr&)rHrPršr r rÚ _set_hrules"s zPrettyTable._set_hrulescCs|jS)z‘Controls printing of vertical rules between columns Arguments: vrules - vertical rules style. Allowed values: FRAME, ALL, NONE)rRr…r r rÚ _get_vrules(szPrettyTable._get_vrulescCs| d|¡||_dS)Nr')rHrRršr r rÚ _set_vrules0s zPrettyTable._set_vrulescCs|jS)zbControls formatting of integer data Arguments: int_format - integer format string)rVr…r r rÚ_get_int_format6szPrettyTable._get_int_formatcCs|jD]}||j|<qdSr+)r?rVr»r r rÚ_set_int_format=s zPrettyTable._set_int_formatcCs|jS)zrControls formatting of floating point data Arguments: float_format - floating point format string)rWr…r r rÚ_get_float_formatCszPrettyTable._get_float_formatcCs|jD]}||j|<qdSr+)r?rWr»r r rÚ_set_float_formatJs zPrettyTable._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)rXr…r r rÚ_get_padding_widthPszPrettyTable._get_padding_widthcCs| d|¡||_dS)Nr1)rHrXršr r rÚ_set_padding_widthXs zPrettyTable._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)rYr…r r rÚ_get_left_padding_width^sz#PrettyTable._get_left_padding_widthcCs| d|¡||_dS)Nr2)rHrYršr r rÚ_set_left_padding_widthfs z#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)rZr…r r rÚ_get_right_padding_widthlsz$PrettyTable._get_right_padding_widthcCs| d|¡||_dS)Nr3)rHrZršr r rÚ_set_right_padding_widthts z$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)r\r…r r rÚ_get_vertical_charzszPrettyTable._get_vertical_charcCs | |¡}| d|¡||_dS©Nr4)r[rHr\ršr r rÚ_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)r]r…r r rÚ_get_horizontal_char‰sz PrettyTable._get_horizontal_charcCs | |¡}| d|¡||_dS)Nr6)r[rHr]ršr r rÚ_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)r^r…r r rÚ_get_junction_char˜szPrettyTable._get_junction_charcCs | |¡}| d|¡||_dSrâ)r[rHr^ršr r rÚ_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)r`r…r r rÚ _get_format§szPrettyTable._get_formatcCs| d|¡||_dS)Nr;)rHr`ršr r rÚ _set_format¯s zPrettyTable._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)r_r…r r rÚ_get_print_emptyµszPrettyTable._get_print_emptycCs| d|¡||_dS)Nr:)rHr_ršr r rÚ_set_print_empty½s zPrettyTable._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)rbr…r r rÚ_get_attributesÃszPrettyTable._get_attributescCs| d|¡||_dS)Nr=)rHrbršr r rÚ_set_attributesËs zPrettyTable._set_attributescCsLi}|jD]<}||vr4| |||¡||||<q t|d|ƒ||<q |S)Nrx)rFrHrz)rcrdÚoptionsrer r rÚ _get_optionsÑs zPrettyTable._get_optionscCsT|tkr| ¡n>|tkr$| ¡n,|tkr6| ¡n|tkrH| ¡ntdƒ‚dS)NzInvalid pre-set style!) ÚDEFAULTÚ_set_default_styleÚMSWORD_FRIENDLYÚ_set_msword_styleÚ PLAIN_COLUMNSÚ_set_columns_styleÚRANDOMÚ_set_random_styler~)rcÚstyler r rÚ set_styleÜs    zPrettyTable.set_stylecCs@d|_d|_t|_t|_d|_d|_d|_d|_ d|_ d|_ dS)NTrr5r7r9) r"r%rOrPrQrRr1r2r3r4r6r8r…r r rrñèszPrettyTable._set_default_stylecCs.d|_d|_t|_d|_d|_d|_d|_dS)NTrr5)r"r%r¯rPr1r2r3r4r…r r rróôszPrettyTable._set_msword_stylecCs"d|_d|_d|_d|_d|_dS)NTFrré)r"r%r1r2r3r…r r rrõýs zPrettyTable._set_columns_stylecCs‚t d¡|_t d¡|_t ttttf¡|_t tttf¡|_ t  dd¡|_ t  dd¡|_ t d¡|_ t d¡|_t d¡|_dS)Nr#réz ~!@#$%^&*()_+|-=\{}[];':",./;<>?)ÚrandomÚchoicer"r%rQrOr®r¯rPrRÚrandintr2r3r4r6r8r…r r rr÷s  ý  zPrettyTable._set_random_stylecCsf|jr2t|ƒt|jƒkr2tdt|ƒt|jƒfƒ‚|jsRdd„tdt|ƒƒDƒ|_|j t|ƒ¡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Únr r rrrz'PrettyTable.add_row..rN)r?rr~ÚrangerDrCÚappendÚlist)rcr‚r r rr|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)rrCr~)rcÚ row_indexr r rÚdel_rowszPrettyTable.del_rowr r¢cCs°t|jƒdt|ƒfvr’| |¡| |¡|j |¡||j|<||j|<tdt|ƒƒD]6}t|jƒ|dkrz|j g¡|j| ||¡qXnt dt|ƒt|jƒfƒ‚dS)a­Add 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) rrCr¡r¥r?rr@rArr~)rcÚ fieldnameÚcolumnrpÚvalignÚir r rÚ add_column)s       zPrettyTable.add_columncCs g|_dS)z?Delete all rows from the table but keep the current field namesN)rCr…r r rÚ clear_rowsAszPrettyTable.clear_rowscCsg|_g|_g|_dS)zWDelete all rows and field names from the table, maintaining nothing but styling optionsN)rCr?rEr…r r rÚclearEszPrettyTable.clearcCs t |¡Sr+)ÚcopyÚdeepcopyr…r r rr KszPrettyTable.copycCsdt|tƒr.||jvr.| d|j||¡}n,t|tƒrZ||jvrZ| d|j||¡}| |¡S)Nz%%%sdz%%%sf)rhr}rVr[ÚfloatrW)rcr¸rlr r rÚ _format_valueNs zPrettyTable._format_valuecCs¦|drdd„|jDƒ}nt|jƒdg}|D]l}t|ƒD]^\}}|j|}||jvr~t||tt|ƒd|j|ƒƒ||<q:t||t|ƒdƒ||<q:q.||_dS)Nr"cSsg|]}t|ƒd‘qS©r)r)rr¸r r rrWrz/PrettyTable._compute_widths..r) r?rrDÚ enumerater‰rÚminrrE)rcÚrowsrîÚwidthsr‚rrlrr r rÚ_compute_widthsUs  (zPrettyTable._compute_widthscCsD|ddur|d}n|d}|ddur4|d}n|d}||fS)Nr2r1r3r )rcrîÚlpadÚrpadr r rÚ_get_padding_widthsds    zPrettyTable._get_padding_widthscsnt |j|d|d…¡}|drj|j |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.rr r(csg|]}|ˆg|‘qSr r ©rr‚©Ú sortindexr rrxrz)PrettyTable._get_rows..r)r*)ÚreverseÚkeycSsg|]}|dd…‘qS)rNr rr r rrzr)r r rCr?rÚsort)rcrîrr rrÚ _get_rowsoszPrettyTable._get_rowscs‡fdd„tˆj|ƒDƒS)Ncsg|]\}}ˆ ||¡‘qSr )r)rr¸rlr…r rr~rz+PrettyTable._format_row..)r³r?)rcr‚rîr r…rÚ _format_row}szPrettyTable._format_rowcs‡‡fdd„|DƒS)Ncsg|]}ˆ |ˆ¡‘qSr )r r©rîrcr rrrz,PrettyTable._format_rows..r )rcrrîr r!rÚ _format_rows€szPrettyTable._format_rowscKsä| |¡}g}|jdkr,|dr(|ds,dS| |¡}| ||¡}| ||¡| |¡|_|drt| | |¡¡n$|dr˜|dt t fvr˜| |j¡|D]}| |  ||¡¡qœ|drÔ|dt krÔ| |j¡|  d¡  |¡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 rr:r%r§r"r&r )rïrsrr"rÚ_stringify_hruleÚ_hrulerÚ_stringify_headerrQrOÚ_stringify_rowr[Újoin)rcrdrîrrÚformatted_rowsr‚r r rrˆƒs"       zPrettyTable.get_stringcCsü|ds dS| |¡\}}|dttfvr6|dg}n |dg}|js^| |d¡d |¡St|j|jƒD]b\}}|drŠ||dvrŠql| ||||d¡|dtkrÀ| |d¡ql| |d¡ql|dtkrò| ¡| |d¡d |¡S)Nr%r§r'r8r6r!) rrQrOr?rr'r³rEr´)rcrîrrr«r¸rr r rr#®s(     zPrettyTable._stringify_hrulec Csàg}| |¡\}}|drj|dttfvr@| |j¡| d¡|dttfvr`| |d¡n | d¡|jsš|dttfvr| |d¡n | d¡t|j|jƒD]Ð\}}|drÆ||dvrÆq¨|jdkrÚ|  ¡}nD|jd krî|  ¡}n0|jd kr|  ¡}n|jd kr|  ¡}n|}| d||  |||j|¡d|¡|dr¨|dtkrn| |d¡q¨| d¡q¨|dr¨|dtkr¨| ¡| |d¡|drÖ|dtkrÖ| d¡| |j¡d  |¡S) Nr%r&r r'r4rnr!r›rœrržr§)rrQrOrr$r?r³rErMÚ capitalizerœrržrrr@r´r¯r')rcrîr«rrr¸rrr r rr%ÇsJ            *   zPrettyTable._stringify_headerc Csøttdt|ƒƒ|j||jƒD]\\}}}}| d¡}g}|D]&} t| ƒ|krVt | |¡} |  | ¡q:|}d  |¡}|||<qd} |D]} t | ƒd} | | kr‚| } q‚g} |  |¡\}}td| ƒD]F}|   g¡|dr¼|dt tfvrô| |  |j¡q¼| |  d¡q¼t|j||jƒD],\}}}|j|}| d¡}| t|ƒ}|r¦|dkr~dgt|d ƒ|dg|t|d ƒ}n(|d kr˜dg||}n|dg|}d}|D]}|d rÎ||d vrÎq®| |  d|| |||j|¡d|¡|dr4|dt kr&| |  |j¡n| |  d¡|d7}q®qtd| ƒD]<}|drN|dtkrN| | ¡| |  |d ¡qN|drÊ|d t krÊ| | d  d¡| | d  |j¡td| ƒD]}d  | |¡| |<qÔd  | ¡S)Nrr rr%r'rnr£r§rr¤r!r4r&)r³rrr?rErrÚtextwrapÚfillrr'rrrQrOr4rAr}rrr@r´r$)rcr‚rîrr¸rlrrÚ new_linesrÚ row_heightr Úhr«rrÚyrZdHeightrmr r rr&ósj(            . .  zPrettyTable._stringify_rowcKs,| |¡}|dr| |¡}n | |¡}|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 falser;)rïÚ_get_formatted_html_stringÚ_get_simple_html_string)rcrdrîÚstringr r rÚget_html_string4s    zPrettyTable.get_html_stringc Cs^g}|drd}nd}g}| d¡|drT|dD]}| d||d|f¡q4| d¡| d |¡¡|d rÆ| d ¡|jD]4}|d r ||d vr q†| d t|ƒ d |¡¡q†| d¡| |¡}| ||¡}|D]b} | d ¡t|j| ƒD]<\}} |d r||d vrqú| dt| ƒ d |¡¡qú| d¡qà| d¡| d ¡ |¡S)Nr<ú
ú
úr§r"ú r!z r ú z ú
%s
%s
) rr'r?rÚreplacerr"r³r[) rcrîrÚ linebreakÚopen_tagÚ attr_namer¸rr(r‚Údatumr r rr1Ps:           z#PrettyTable._get_simple_html_stringc Cs¼g}| |¡\}}|dr d}nd}g}| d¡|dr|dtkr`|dtkr`| d¡n¨|dtkr„|dtkr„| d ¡n„|dtkr¨|dtkr¨| d ¡n`|dtkrÀ| d ¡nH|dtkrØ| d ¡n0|dtkrð| d ¡n|dtkr| d¡|dr<|dD] }| d||d|f¡q| d¡| d |¡¡|dr¾| d¡|jD]B}|dr||dvrqp| d||t|ƒ d|¡f¡qp| d¡| |¡} |  | |¡} g} g} |jD]>}|  ddddœ|j |¡|  dddd œ|j |¡qâ| D]z} | d¡t |j| | | ƒD]N\}}}}|drl||dvrlqD| d!||||t|ƒ d|¡f¡qD| d¡q&| d"¡|  d¡ |¡S)#Nr<r4r5r6r%r&r'z frame="box" rules="all"z frame="box"z frame="box" rules="cols"z frame="hsides"z frame="hsides" rules="rows"z frame="vsides"z frame="vsides" rules="cols"r=r7r8r§r"r9r!zW %sr r:ÚleftÚrightÚcenter)rmror ÚtopÚmiddleÚbottom)r¢r£r¤zg %sr;)rrrQrOr'r?rr<rr"r@rAr³r[)rcrîrrrr=r>r?r¸rr(ÚalignsÚvalignsr‚r@rprr r rr0ts‚                  $    þþþþ  ü  z&PrettyTable._get_formatted_html_string)N)r r¢)ƒÚ__name__Ú __module__Ú __qualname__rfr[rrrwrƒÚpy3kr†r„rHrŠr’r¡r¥r‹r‘r“r”rrŽrrŒrr•r–r±r¹ÚpropertyrDrºr¼rpr½r¾rr¿rÀr‰rÁrÂr!rÃ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Úr0rÛrÜr1rÝrÞr2rßràr3rárãr4rärår6rærçr8rèrér;rêrër:rìrír=rïrùrñrórõr÷r|rr r r r rrrrr r"rˆr#r%r&r3r1r0r r r rr-s S                                      +,A$rcCsìd|krdkrnndSd|kr0dkr8nndSd|krLdkrTnndSt t|ƒ¡rfd Sd |krzd ks”nd |krd kr˜nndSd|kr¬dkr´nndSd|krÈdkrÐnndS|dvrÜdS|dvrèd SdS)Né!é~riNiÿŸri¬i¯×ri@0iŸ0i 0iÿ0iÿi`ÿi0i>0)rúééÿÿÿÿ)ré)Ú unicodedataÚ combiningÚuni_chr)Úcharr r rÚ_char_block_width·s&.rWc Cstttttt d|¡ƒƒƒS)Nr§)ÚsumÚitermaprWÚordÚ_reÚsub)r—r r rrÍsrcKs”t ¡ | d¡¡}| d¡t ||¡}tfi|¤Ž}|rD||_n.tr^dd„t |ƒDƒ|_ndd„|  ¡Dƒ|_|D]}|  dd„|Dƒ¡qv|S)NircSsg|] }| ¡‘qSr ©Ústripr²r r rrÙrzfrom_csv..cSsg|] }| ¡‘qSr r]r²r r rrÛrcSsg|] }| ¡‘qSr r]r²r r rrÝr) ÚcsvÚSnifferÚsniffÚreadÚseekÚreaderrrDrLÚnextr|)ÚfprDrdÚdialectrdÚtabler‚r r rÚfrom_csvÑs  ricKsF|jrBtfi|¤Ž}dd„|jDƒ|_| ¡D]}| |¡q.|SdS)NcSsg|] }|d‘qSrr )rÚcolr r rrårz"from_db_cursor..)Ú descriptionrrDÚfetchallr|)Úcursorrdrhr‚r r rÚfrom_db_cursorâs   rnc@s<eZdZdd„Zdd„Zdd„Zdd„Zd d „Zd d „Zd S)Ú TableHandlercKs>t |¡||_g|_g|_g|_d|_d|_d|_d|_ dS)Nrr§F) rrfrdÚtablesÚlast_rowrÚ max_row_widthÚactiveÚ last_contentÚis_last_row_header)rcrdr r rrfîs zTableHandler.__init__cCs||_|dkrd|_dS)NÚthT)rsru)rcÚtagÚattrsr r rÚhandle_starttagúszTableHandler.handle_starttagcCs|dvr|j ¡}|j |¡|dkrZ|j |j|jf¡t|jt|jƒƒ|_g|_d|_|dkr€|  |j¡}|j  |¡g|_d|_d|_ dS)N)rvÚtdÚtrFrhrn) rtr^rqrrrurrrrÚgenerate_tablerprs)rcrwÚstripped_contentrhr r rÚ handle_endtagÿs    zTableHandler.handle_endtagcCs|j|7_dSr+)rt)rcÚdatar r rÚ handle_dataszTableHandler.handle_datacCs–tfi|j¤Ž}|jD]z}t|dƒ|jkr\|jt|dƒ}td|ƒD]}|d d¡qH|ddkr‚| |d¡|d|_q|  |d¡q|S)zE Generates from a list of rows a PrettyTable object. rrr7T) rrdrrrrrrÚmake_fields_uniquerDr|)rcrrhr‚Úappendsrr r rr|s   zTableHandler.generate_tablecCsPtdt|ƒƒD]<}t|dt|ƒƒD]$}||||kr$||d7<q$qdS)zB iterates over the row and make each field unique rrú'N)rr)rcr!rÚjr r rr&szTableHandler.make_fields_uniqueN) rIrJrKrfryr~r€r|rr r r rroìs  rocKstfi|¤Ž}| |¡|jS)zƒ Generates a list of PrettyTables from a string of HTML code. Each in the HTML becomes one PrettyTable object. )roÚfeedrp)Ú html_coderdÚparserr r rÚ from_html0s rˆcKsHt|fi|¤Ž}zt|ƒdks"J‚Wnty>tdƒ‚Yn0|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)rˆrr˜r~)r†rdrpr r rÚ from_html_one:s  r‰cCs tgd¢ƒ}d|_d|_d|jd<d|_d|jd<| gd ¢¡| gd ¢¡| gd ¢¡| gd ¢¡| gd ¢¡| gd¢¡| gd¢¡t|ƒdS)N)ú City nameÚAreaÚ PopulationzAnnual RainfallrŒTZ04dr‹z6.1frmrŠ)ZAdelaideiis¬gÄ‚@)ZBrisbaneii:Xgš™™™™é‘@)ÚDarwinépiDØgÍÌÌÌÌÊš@)ZHobartiMiô"g\ƒ@)ZSydneyi iö*Bg33333û’@)Z MelbourneiiŒ:g333337„@)ZPerthi iQ¹g33333+‹@)rr(r)r/r0rpr|Úprintr,r r rÚmainHs   rÚ__main__)N)2Ú __version__r r_rüÚreÚsysr*Ú itertoolsrSÚ version_inforLrjrkriÚmaprYr³ZiterzipÚchrrUÚ html.parserrÚimapÚizipÚunichrÚhtmlrZcgirOrQr¯r®rðròrôröÚcompiler[rÚobjectrrWrrirnrorˆr‰rrIr r r rÚsj     D )