F`Q@sdZddlZddlZddlZddlZddlZddlZddlZddlZej ddkZ e re Z e Z eZeZeZddlmZn(ejZejZeZddlmZe oej ddkrddlmZnddlmZdZdZdZdZdZ d Z!d Z"d Z#ej$d Z%d dZ&Gddde'Z(ddZ)ddZ*dddZ+ddZ,GdddeZ-ddZ.ddZ/dd Z0e1d!kre0dS)"z0.7.2N) HTMLParser)escape z \[[0-9;]*mcCs>|jd}t|}tdd|D}||fS)N cSsg|]}t|qS)_str_block_width).0liner r -/usr/lib/python3/dist-packages/prettytable.py Os z_get_size..)splitlenmax)textlinesZheightwidthr r r _get_sizeLs rc@sdeZdZdddZddZddZdd Zd d Zer`d d Z n dd Z ddZ ddZ ddZ ddZ ddZddZddZddZdd Zd!d"Zd#d$Zd%d&Zd'd(Zd)d*Zd+d,Zd-d.Zd/d0Zd1d2Zd3d4ZeeeZd5d6Zd7d8Z eee Z!d9d:Z"d;d<Z#ee"e#Z$d=d>Z%d?d@Z&ee%e&Z'dAdBZ(dCdDZ)ee(e)Z*dEdFZ+dGdHZ,ee+e,Z-dIdJZ.dKdLZ/ee.e/Z0dMdNZ1dOdPZ2ee1e2Z3dQdRZ4dSdTZ5ee4e5Z6dUdVZ7dWdXZ8ee7e8Z9dYdZZ:d[d\Z;ee:e;Z<d]d^Z=d_d`Z>ee=e>Z?dadbZ@dcddZAee@eAZBdedfZCdgdhZDeeCeDZEdidjZFdkdlZGeeFeGZHdmdnZIdodpZJeeIeJZKdqdrZLdsdtZMeeLeMZNdudvZOdwdxZPeeOePZQdydzZRd{d|ZSeeReSZTd}d~ZUddZVeeUeVZWddZXddZYeeXeYZZddZ[ddZ\ee[e\Z]ddZ^ddZ_ee^e_Z`ddZaddZbeeaebZcddZdddZeeedeeZfddZgddZheegehZiddZjddZkddZlddZmddZnddZoddZpddZqddddZrddZsddZtddZuddZvddZwddZxddZyddZzddZ{ddZ|ddZ}ddZ~ddZddZddZddZdS) PrettyTableNcKs |jdd|_g|_i|_i|_i|_g|_|rT||_n g|_dj |_ |j j dj |j j dj x>|j D]3}||kr|j |||qd||sz&PrettyTable.__init__.. int_format float_format padding_widthrleft_padding_widthright_padding_width vertical_char|horizontal_char- junction_char+ print_emptyformatxhtml attributes)TF)TF)TF)TF)'getr _field_names_align_valign _max_width_rows field_names_widthsr_optionsextend_validate_option_start_end_fields_header _header_style_borderFRAME_hrulesALL_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=kwargsoptionr r r__init__Ts^            zPrettyTable.__init__cCsCt|tst|}t|ts?t||jd}|S)Nstrict) isinstance basestringstrunicoder)r[valuer r rrTs  zPrettyTable._unicodecCs|t|}|dkr(||dS|dkr@|d|S|drt|drz|dd||dddS|ddd||ddSn|dd||ddSdS)Nl rrr)r )r[rralignZexcessr r r_justifys      #zPrettyTable._justifycCsl|dkrt|jS|dkr\|jr;t|jS|jrUt|jdSdSn t|dS)NrowcountZcolcountr)rr<r8AttributeError)r[namer r r __getattr__s      zPrettyTable.__getattr__cCst}|j|_x2|jD]'}t|d|t|d|qWt|dt|dt|trxa|j|D]}|j|qWn<t|t r|j|j|nt dt ||S)N_r9z0Index %s is invalid, must be an integer or slice) rr=r?setattrgetattrr`slicer<add_rowint Exceptionrb)r[indexnewattrrowr r r __getitem__s  %zPrettyTable.__getitem__cCs |jS)N) __unicode__)r[r r r__str__szPrettyTable.__str__cCs|jj|jS)N)rzencoder)r[r r rr{scCs |jS)N) get_string)r[r r rrzszPrettyTable.__unicode__cCs|dkr|j|n|dkr;|j||nb|d krZ|j||nC|d kry|j||n$|d kr|j||n|d kr|j||n|d kr|j||n|dkr|j||n|dkr|j|n|dkr0|j ||nm|dkrO|j ||nN|dkrn|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!)zstartzendz max_widthz padding_widthzleft_padding_widthzright_padding_widthzformat)zheaderzborderz reversesortzxhtmlz print_empty)z vertical_charzhorizontal_charz junction_char)_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]valr r rrAs6             zPrettyTable._validate_optioncCs%|jrhy%t|t|jks-tWn7tk rgtdt|t|jfYnX|jry)t|t|jdkstWn;tk rtdt|t|jdfYnXy(t|tt|kstWntk r tdYnXdS)NzJField name list has incorrect number of values, (actual) %d!=%d (expected)rzField names must be unique!)r8rAssertionErrorrtr<set)r[rr r rrs % * ) .( z!PrettyTable._validate_field_namesc Cs;y|dkstWntk r6tdYnXdS)Ncaptitleupperlowerz;Invalid header style, use cap, title, upper, lower or None!)rztitlezupperzlowerN)rrt)r[rr r rr0s z"PrettyTable._validate_header_stylec Cs?y|dkstWn"tk r:td|YnXdS)Nrecrgz'Alignment %s is invalid, use l, c or r!)rerrg)rrt)r[rr r r_validate_align6s zPrettyTable._validate_alignc Cs?y|dkstWn"tk r:td|YnXdS)Ntmbz-Alignment %s is invalid, use t, m, b or None!)rrrN)rrt)r[rr r r_validate_valign<s zPrettyTable._validate_valignc CsTyt|dkstWn1tk rOtd||j|fYnXdS)NrzInvalid value for %s: %s!)rsrrtrT)r[rlrr r rrBs z%PrettyTable._validate_nonnegative_intc Cs?y|dkstWn"tk r:td|YnXdS)NTFz-Invalid value for %s! Must be True or False.)TF)rrt)r[rlrr r rrHs z#PrettyTable._validate_true_or_falsec Csm|dkrdSy4t|ttfks1t|jsCtWn"tk rhtd|YnXdS)Nz8Invalid value for %s! Must be an integer format string.)typerbrcrisdigitrt)r[rlrr r rrNs  z PrettyTable._validate_int_formatc Cs|dkrdSyt|ttfks1td|ksCt|jd}t|dksjt|ddks|djst|ddks|djstWn"tk rtd|YnXdS)Nr.rrrz5Invalid value for %s! Must be a float format string.)rrbrcrrrrrt)r[rlrbitsr r rrWs &* z"PrettyTable._validate_float_formatc CsByt|dstWn"tk r=td|YnXdS)N__call__z*Invalid value for %s! Must be a function.)hasattrrrt)r[rlrr r rrds zPrettyTable._validate_functionc CsKy"|ttttfks!tWn"tk rFtd|YnXdS)Nz:Invalid value for %s! Must be ALL, FRAME, HEADER or NONE.)rJrHHEADERNONErrt)r[rlrr r rrjs" zPrettyTable._validate_hrulesc CsHy|tttfkstWn"tk rCtd|YnXdS)Nz3Invalid value for %s! Must be ALL, FRAME, or NONE.)rJrHrrrt)r[rlrr r rrps zPrettyTable._validate_vrulesc CsNy%||jks$|dks$tWn"tk rItd|YnXdS)NzInvalid field name: %s!)r8rrt)r[rlrr r rrvs% z PrettyTable._validate_field_namec CsJy%x|D]}|j||q WWntk rEtdYnXdS)Nz)fields must be a sequence of field names!)rrrt)r[rlrr&r r rr|s   z%PrettyTable._validate_all_field_namesc CsEyt|dkstWn"tk r@td|YnXdS)Nrz4Invalid value for %s! Must be a string of length 1.)r rrt)r[rlrr r rrs z!PrettyTable._validate_single_charc Cs>yt|tstWntk r9tdYnXdS)Nz4attributes must be a dictionary of name/value pairs!)r`dictrrt)r[rlrr r rrs z PrettyTable._validate_attributescCs|jS)N)r8)r[r r r_get_field_namesszPrettyTable._get_field_namescsfdd|D}jd|jrEjdd}|_jr|rx1t||D] \}}j|j|.r=rr)rAr8r9zippopr:)r[rZ old_namesZold_namenew_namefieldr )r[r_set_field_namess*    zPrettyTable._set_field_namescCs|jS)N)r9)r[r r r _get_alignszPrettyTable._get_aligncCs2|j|x|jD]}||j| tag when printing HTML Arguments: attributes - dictionary of attributes)rZ)r[r r r_get_attributesszPrettyTable._get_attributescCs|jd|||_dS)Nr6)rArZ)r[rr r r_set_attributesszPrettyTable._set_attributescCsfi}xY|jD]N}||krG|j||||||||tkrK|jn%|tkrd|jn tddS)NzInvalid pre-set style!) DEFAULT_set_default_styleMSWORD_FRIENDLY_set_msword_style PLAIN_COLUMNS_set_columns_styleRANDOM_set_random_stylert)r[Zstyler r r set_styles        zPrettyTable.set_stylecCs^d|_d|_t|_t|_d|_d|_d|_d|_ d|_ d|_ dS)NTrr.r0r2) rr rHrIrJrKr*r+r,r-r/r1)r[r r rrs         zPrettyTable._set_default_stylecCsCd|_d|_t|_d|_d|_d|_d|_dS)NTrr.)rr rrIr*r+r,r-)r[r r rrs      zPrettyTable._set_msword_stylecCs1d|_d|_d|_d|_d|_dS)NTFrr)rr r*r+r,)r[r r rrs     zPrettyTable._set_columns_stylecCstjd|_tjd|_tjttttf|_tjtttf|_ tj dd|_ tj dd|_ tjd|_ tjd|_tjd|_dS)NTFrz ~!@#$%^&*()_+|-=\{}[];':",./;<>?)TF)TF)randomZchoicerr rJrHrrrIrKZrandintr+r,r-r/r1)r[r r rrszPrettyTable._set_random_stylecCs|jrIt|t|jkrItdt|t|jf|jswddtdt|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|dqS)zField %drr )rnr r rr4s z'PrettyTable.add_row..rN)r8rrtranger=r<appendlist)r[rxr r rrr(s $% %zPrettyTable.add_rowcCsF|t|jdkr8td|t|jf|j|=dS)zDelete 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_indexr r rdel_row7szPrettyTable.del_rowrrcCst|jdt|fkr|j||j||jj|||j|<||j|)r[r r rclearbs  zPrettyTable.clearcCs tj|S)N)copydeepcopy)r[r r rrnszPrettyTable.copycCst|tr?||jkr?|jd|j||}n<t|tr{||jkr{|jd|j||}|j|S)Nz%%%sdz%%%sf)r`rsrOrTfloatrP)r[rrdr r r _format_valueus !zPrettyTable._format_valuecCs|dr#dd|jD}nt|jdg}x|D]}xt|D]}\}}|j|}||jkrt||tt|d|j|||.r) r8rr= enumerater~rminrr>)r[rowsrZwidthsrxrurdrr r r_compute_widths|s   4)zPrettyTable._compute_widthscCsX|ddk r|d}n |d}|ddk rD|d}n |d}||fS)Nr+r*r,r )r[rlpadrpadr r r_get_padding_widthss    zPrettyTable._get_padding_widthscstj|j|d|d}|dr|jj|dfdd|D}|jd|dd|d d d|D}|S) zReturn only those data rows that should be printed, based on slicing and sorting. Arguments: options - dictionary of option settings.rrr#cs!g|]}|g|qSr r )rrx) sortindexr rrs z)PrettyTable._get_rows..reverser$keyr%cSs g|]}|ddqS)rNr )rrxr r rrs )rrr<r8rusort)r[rrr )rr _get_rowss$ zPrettyTable._get_rowscs#fddtj|DS)Ncs(g|]\}}j||qSr )r)rrrd)r[r rrs z+PrettyTable._format_row..)rr8)r[rxrr )r[r _format_rowszPrettyTable._format_rowcsfdd|DS)Ncs"g|]}j|qSr )r)rrx)rr[r rrs z,PrettyTable._format_rows..r )r[rrr )rr[r _format_rowsszPrettyTable._format_rowscKs>|j|}g}|jdkr>|d s:|d r>dS|j|}|j||}|j|||j||_|dr|j|j|n0|dr|dt t fkr|j|jx'|D]}|j|j ||qW|dr(|dt kr(|j|j|j dj |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 rrr!r )rrjrrr_stringify_hrule_hruler_stringify_headerrJrH_stringify_rowrTjoin)r[r\rrrformatted_rowsrxr r rr}s"%   zPrettyTable.get_stringcCsJ|dsdS|j|\}}|dttfkrI|dg}n |dg}|js}|j|ddj|Sxt|j|jD]{\}}|dr||dkrq|j||||d|dtkr|j|dq|j|dqW|dtkr=|j|j|ddj|S)Nr rr"r1r/r) rrJrHr8rr rr>r)r[rrrrrrr r rrs(    " zPrettyTable._stringify_hrulecCswg}|j|\}}|dr|dttfkrX|j|j|jd|dttfkr|j|dn |jd|js|dttfkr|j|dn |jdx,t|j|jD]\}}|dr||dkrq|jdkr,|j }n`|jd krJ|j }nB|jd krh|j }n$|jd kr|j }n|}|jd||j |||j|d||dr|dtkr|j|dq|jdqW|dr3|dtkr3|j|j|d|drj|dtkrj|jd|j|jd j|S) Nr r!r r"r-rfrrrrrr)rrJrHrrr8rr>rF capitalizerrrrir9rrr )r[rrrrrrrr r rr  sJ     "3   zPrettyTable._stringify_headerc Csxttdt||j||jD]\}}}}|jd}g}x?|D]7} t| |krtj| |} |j | qYW|}dj |}|||rr textwrapZfillrr rrrJrHr-r:rsrir9rr)r[rxrrurrdrrZ new_linesrZ row_heightrhrrryrZdHeightrer r rr :sj=      (  7  7 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\rstringr r rget_html_strings  zPrettyTable.get_html_stringc Csg}|drd}nd}g}|jd|drpx1|dD]%}|jd||d|fqGW|jd|jdj||d r |jd xQ|jD]F}|d r||d krq|jd t|jd |qW|jd|j|}|j||}x|D]} |jd x`t|j| D]L\}} |d r||d krqY|jdt| jd |qYW|jdq3W|jd|jd j|S)Nr5z
z
zrrz rz r z z z
%s
%s
) rr r8rreplacerrrrT) r[rr linebreakopen_tag attr_namerrr rxdatumr r rrs:    #   '   ' z#PrettyTable._get_simple_html_stringc Csg}|j|\}}|dr.d}nd}g}|jd|dr^|dtkr|dtkr|jdn|dtkr|dtkr|jd n|dtkr|dtkr|jd n}|dtkr|jd n]|dtkr!|jd n=|dtkrA|jd n|dtkr^|jd|drx1|dD]%}|jd||d|fqsW|jd|jdj||dr@|jdxZ|jD]O}|dr||dkrq|jd||t|jd|fqW|jd|j|} |j | |} g} g} xe|jD]Z}| jddddddi|j || jdd d!d"d#d$i|j |qwWx| D]} |jdx{t |j| | | D]a\}}}}|dr7||dkr7q|jd%||||t|jd|fqW|jdqW|jd&|j dj|S)'Nr5z
z
zrzW %sr z releftrgrightrcenterrtoprZmiddlerZbottomzg %sz)rrrJrHr r8rrrrr9r:rrT)r[rrrrrrrrrr ZalignsZvalignsrxrrhrr r rrsd         #   0 *.  +6 z&PrettyTable._get_formatted_html_string)__name__ __module__ __qualname__r^rTrirmrypy3kr{rzrArrrrrrrrrrrrrrrrrpropertyr=rrrhrrrrrr~rrrrrrrrrrrr#rrr$rrr%rrrrrrrrr rrr!rrr"rrr(rrr)rrr*rrr+rrr,rrr-rrr/rrr1rrr4rrr3rrr6rrrrrrrrrrrrrrrrrrrr}rr r rrrr r r rrRs ]                                                                                    =  / L (rcCsd|kodknr dSd|ko7dknr@dSd|koWdknr`dStjt|ryd Sd |kod knsd |kod knrdSd|kodknrdSd|kodknrdS|dkrdS|dkrd SdS)N!~riNiriiri@0i0i0i0ii`i0i>0r)rr&)rr') unicodedataZ combininguni_chr)charr r r_char_block_widths&8  r,cCs(ttttttjd|S)Nr)sumitermapr,ord_resub)rr r rr /sr cKstjj|jd}|jdtj||}t|}|r[||_nAtrddt |D|_ndd|j D|_x(|D] }|j dd|DqW|S)NircSsg|]}|jqSr )strip)rr&r r rrBs zfrom_csv..cSsg|]}|jqSr )r2)rr&r r rrDs cSsg|]}|jqSr )r2)rr&r r rrGs ) csvZSnifferZsniffreadseekreaderrr=r"nextrr)fpr=r\Zdialectr6tablerxr r rfrom_csv7s    r:cKsZ|jrVt|}dd|jD|_x!|jD]}|j|q;W|SdS)NcSsg|]}|dqS)rr )rcolr r rrOs z"from_db_cursor..)Z descriptionrr=Zfetchallrr)Zcursorr\r9rxr r rfrom_db_cursorKs   r<c@sXeZdZddZddZddZddZd d Zd d Zd S) TableHandlercKsYtj|||_g|_g|_g|_d|_d|_d|_d|_ dS)NrrF) rr^r\tableslast_rowr max_row_widthactive last_contentis_last_row_header)r[r\r r rr^Vs        zTableHandler.__init__cCs"||_|dkrd|_dS)NthT)rArC)r[tagZattrsr r rhandle_starttagas  zTableHandler.handle_starttagcCs|dkr+|jj}|jj||dkr|jj|j|jft|jt|j|_g|_d|_|dkr|j |j}|j j|g|_d|_d|_ dS)NrDtdZtrFr9rf)zthrG) rBr2r?rrrCrr@rgenerate_tabler>rA)r[rEZstripped_contentr9r r r handle_endtagfs        zTableHandler.handle_endtagcCs|j|7_dS)N)rB)r[datar r r handle_dataxszTableHandler.handle_datacCst|j}x|jD]}t|d|jkrz|jt|d}x(td|D]}|djdq_W|ddkr|j|d|d|_q|j |dqW|S)zE Generates from a list of rows a PrettyTable object. rrr0T) rr\rrr@rrmake_fields_uniquer=rr)r[rr9rxZappendsrr r rrH{szTableHandler.generate_tablecCsjxctdt|D]L}xCt|dt|D](}||||kr6||d7 in the HTML becomes one PrettyTable object. )r=Zfeedr>) html_coder\parserr r r from_htmls  rQc KsTt||}yt|dks*tWntk rKtdYnX|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)rQrrrt)rOr\r>r r r from_html_ones  rRcCs tddddg}d|_d|_d|jd s`            !  B