c\dZddlmZddlmZmZmZmZmZm Z m Z ddl m Z ddl Z dZGddeZGd d Ze j$d ZGd d ZGddZGddeZGddZGddeZy)zTable management module.)CodeType)AnyListOptionalTupleUnionDictIterator)StringIONzrestructuredtext enc eZdZdZ d@dedeeedeeddfdZ defdZ de fd Z d e defd Ze j Zd Zdefd ZdeeddfdZdeeddfdZdAdeddfdZdeddfdZdBdededdfdZdBdededdfdZdededeeeeedffeedfffdZdededdfdZdZdeded eddfd!Zd"eded eeefddfd#Zded$eee eeeefddfd%Z!d"ed$eeddfd&Z" dAd$eeee efeefdeedefd'Z#dAd(ed$eededdfd)Z$d(edeefd*Z%d"eddfd+Z&ded,eeee'fddfd-Z(ded,eeee'fddfd.Z)d,e'deddfd/Z*d(ed,e'deddfd0Z+d(edeefd1Z,deddfd2Z-de.eeffd3Z/e0e/Z1d4ee.eee2efeeeffee2fdefd5Z3d6Z4d7Z5dCd8Z6deeefd9Z7dCd:Z8dDd;Z9dEd<Z:defd=Z;defd>Z.is_iterable<s' X  s  F)rboollist)rr%r*s r__eq__z Table.__eq__;s? # $  =  :e, ,rc||k( Sr)rr%s r__ne__z Table.__ne__Os5=  rc,t|jSrrrs r__len__z Table.__len__Rs4>>""rc|jj||D]>}|jj|jgt |j z@y)z.Appends row_names to the list of existing rowsN)rextendrappendrrr)rrrow_names rrzTable.create_rowsVsN i(! IH II  d001C4GG H Irc4|D]}|j|y)z1Appends col_names to the list of existing columnsN) create_column)rrcol_names rrzTable.create_columns\s! )H   x ( )rr6c|xs|j}|jj||jj|jgt |j zy)z'Creates a rowname to the row_names listN)r rr5rrrr)rr6s r create_rowzTable.create_rowasP4t224 h' $,,-DNN0CCDrr9c|jj||jD]}|j|jy)z'Creates a colname to the col_names listN)rr5rr)rr9rows rr8zTable.create_columngs9 h'99 +C JJt)) * +rcol_idmethodc |jj|}|j||y#t$rt d|zwxYw)z=Sorts the table (in-place) according to data stored in col_idzCol (%s) not found in tableN)rindexsort_by_column_index ValueErrorKeyError)rr>r? col_indexs rsort_by_column_idzTable.sort_by_column_idnsN E,,V4I  % %i 8 E8FCD D E -0ArEc xtt|j|jDcgc] \}}||||fc}}}|j dk(r|j g|_g|_|D]<\}}}|jj ||jj |>ycc}}w)zvSorts the table 'in-place' according to data stored in col_index method should be in ('asc', 'desc') descN)sortedziprrlowerreverser5)rrEr?r=r6 sort_listvals rrBzTable.sort_by_column_indexvs BEdiiQUQ_Q_B` ahc)nc8 , a <<>V #     "+ , Ch II  S ! NN ! !( + , bsB6 colnameotherscvi}|f|z}|Dcgc]}|jj|}}|jD]t}|}|ddD]} |j|| i}|j||dt |j |j} | j t|v|Scc}w)z]builds indexes of data :returns: nested dictionaries pointing to actual rows N)rr)rrAr setdefaultr r append_rowtuple) rrPrQgroupscolnamesr> col_indexesr=ptrrEtables rgroupbyz Table.groupbys :&BJKt~~++F3K K99 )CC("- 9 nnS^R8 9NNKO$D$6$6$..QE   U3Z ( ) Ls"B6valuecb|j|} ||S#t$r tcYSwxYwr)r\rDr )rrPr]groupeds rselectz Table.selects7,,w' 5> ! 7N s ..c|jj|}|jddD]&}|||k(s |jj|(yr)rrArremove)rrPr]rEr=s rrbz Table.removesKNN((1 99Q< &C9~&   % &r row_indexrc(||j||<y)z3sets value of cell 'row_indew', 'col_index' to dataNr)rrcrErs rset_cellzTable.set_cells*. )Y'rrow_idc |jj|} |jj|}||j||<y#t$rt d|zwxYw#t$rt d|zwxYw)zsets value of cell mapped by row_id and col_id to data Raises a KeyError if row_id or col_id are not found in the table Column (%s) not found in tableRow (%s) not found in tableN)rrArrrCrD)rrgr>rrcrEs rset_cell_by_idszTable.set_cell_by_idss L,,V4I L NN008 26 )$Y/ L?6JKK L  E8FCD D EsA'-A A$'A?row_datac"||j|<y)zsets the 'row_index' row pre:: type(row_data) == types.ListType len(row_data) == len(self.col_names) Nre)rrcrls rset_rowz Table.set_rows ( )rc |jj|}|j||y#t$rt d|zwxYw)zsets the 'row_id' column pre:: type(row_data) == types.ListType len(row_data) == len(self.row_names) Raises a KeyError if row_id is not found rjN)rrArnrCrD)rrgrlrcs r set_row_by_idzTable.set_row_by_idsL E,,V4I LLH - E8FCD D ErGc|xs|j}|jj||jj|t |jdz S)zAppends a row to the table pre:: type(row_data) == types.ListType len(row_data) == len(self.col_names) r)r rr5rr)rrlr6s rrUzTable.append_rowsN4t224 h' "499~!!rrAc|xs|j}|jj|||jj||y)a.Appends row_data before 'index' in the table. To make 'insert' behave like 'list.insert', inserting in an out of range index will insert row_data to the end of the list pre:: type(row_data) == types.ListType len(row_data) == len(self.col_names) N)r rinsertr)rrArlr6s r insert_rowzTable.insert_rows?4t224 eX. )rcn|jj||jj|S)ztDeletes the 'index' row in the table, and returns it. Raises an IndexError if index is out of range )rpoprrrAs r delete_rowzTable.delete_rows) 5!yy}}U##rc |jj|}|j|y#t$rt d|zwxYw)zbDeletes the 'row_id' row in the table. Raises a KeyError if row_id was not found. rjN)rrArxrCrDrrgrcs rdelete_row_by_idzTable.delete_row_by_idsJ E,,V4I OOI & E8FCD D E ,/Acol_datacNt|D]\}}||j||<y)zsets the 'col_index' column pre:: type(col_data) == types.ListType len(col_data) == len(self.row_names) N) enumerater)rrEr}rc cell_datas r set_columnzTable.set_columns0%.h$7 8 Iy.7DIIi  + 8rc |jj|}|j||y#t$rt d|zwxYw)zsets the 'col_id' column pre:: type(col_data) == types.ListType len(col_data) == len(self.col_names) Raises a KeyError if col_id is not found riN)rrArrCrD)rr>r}rEs rset_column_by_idzTable.set_column_by_idsL H,,V4I OOIx 0 H;vFG G HrGc|jj|t|D]#\}}|j|j|%y)zAppends the 'col_index' column pre:: type(col_data) == types.ListType len(col_data) == len(self.row_names) N)rr5rr)rr}r9rcrs r append_columnzTable.append_column sF h'$-h$7 3 Iy IIi ' ' 2 3rc|jj||t|D]$\}}|j|j||&y)a.Appends col_data before 'index' in the table. To make 'insert' behave like 'list.insert', inserting in an out of range index will insert col_data to the end of the list pre:: type(col_data) == types.ListType len(col_data) == len(self.row_names) N)rrsrr)rrAr}r9rcrs r insert_columnzTable.insert_column+sJ eX.$-h$7 : Iy IIi ' 'y 9 :rc|jj||jDcgc]}|j|c}Scc}w)zwDeletes the 'index' column in the table, and returns it. Raises an IndexError if index is out of range )rrvr)rrAr=s r delete_columnzTable.delete_column8s6 5!*.))43444sAc |jj|}|j|y#t$rt d|zwxYw)zbDeletes the 'col_id' col in the table. Raises a KeyError if col_id was not found. riN)rrArrCrD)rr>rEs rdelete_column_by_idzTable.delete_column_by_id?sL H,,V4I   y ) H;vFG G Hr|cVt|jt|jfS)z2Returns a tuple which represents the table's shape)rrrrs r get_shapezTable.get_shapeKs4>>"C$777rindicescd}d}d}t|tr|d}t|dkDr|d}n|}t|tr |jj |}t|trt||dz}d}n td}d}t|tr |jj |}t|trt||dz}d}n td}d}t}|j|_ |j|j||j|j|t|j |D]\} } |j#| | ||r!|r|S|j D cgc]} | d c} S|r|j dS|j ddS#t $rtd|zwxYw#t $rtd|zwxYwcc} w)zprovided for convenienceFNrrrjTri) isinstancerVrstrrrArCrDintslicerr rrrrrrn) rr multirows multicols cols_indice rows_indicerowscolstabidxr=items r __getitem__zTable.__getitem__Qs  .2 gu %!!*K7|a%aj !K k3 ' N"nn22;?  k3 'kAo6DI;DI k3 ' Q"nn22;?  k3 'kAo6DI;DIg .. t,- 4>>$/0!$))D/2 (HC KKSY ' (  ,/HH5DQ55xx{"xx{1~%W N< LMM N Q?;OPP Q06sF:G G0:GG-c |jj|} |jj|}|j ||S#t$rt d|zwxYw#t$rt d|zwxYw)z'Returns the element at [row_id][col_id]rirj)rrArrCrDr)rrgr>rcrEs rget_cell_by_idszTable.get_cell_by_idss L,,V4I L NN008 yy#I.. L?6JKK L  E8FCD D EsA&A A#&A>c |jj|}|j|S#t$rtd|zwxYw)zReturns the 'row_id' rowrj)rrArCrDrrzs r get_row_by_idzTable.get_row_by_idsQ E,,V4Iyy## E8FCD D Es ,Ac |jj|}|j ||S#t$rtd|zwxYw)zReturns the 'col_id' colri)rrArCrD get_column)rr>distinctrEs rget_column_by_idzTable.get_column_by_idsS H,,V4Iy(33 H;vFG G Hs /Acrtt|jDcgc] }|dd|f c}Scc}w)z$Returns all the columns in the tableN)rangerrrws r get_columnszTable.get_columnss,,1#dnn2E,FG5QXGGGs4ct|jDcgc]}|| }}|rtt|}|Scc}w)zget a column by index)rr,set)rrErr=cols rrzTable.get_columns7)-3#s9~33 s3x.C 4s 5c<|jD] }t|y)z$Applies the stylesheet to this tableN) instructionseval)r stylesheet instructions rapply_stylesheetzTable.apply_stylesheets%22 K   rct}|j|j|j|jt |j D]\}}|j|||S)zZKeeps the self object intact, and returns the transposed (rotated) table. )r rrrrrrrn)r transposedrEcolumns r transposezTable.transposesgW t~~.!!$..1!*4+;+;+=!> 2 Iv   y& 1 2rc d}|jD]}t||kDst|}|dz}g}d|zg}|jD]}|j|dz|jddj |zdzt|d}t |j D]\}} g} |j|}| j|d|t|z zzt | D]N\} } t|j| dz} t| }| j|d| t|z zzP|jddj | zdzt|d|kDst|d}|jdd|z|jd|zdj |S) z[returns a string representing the table in a pretty printed 'text' format. r z |rS- ) rrrr5joinrrrrs)r max_row_namer6 col_startlinescol_names_liner9max_line_lengthrcr=linerEcellcol_name_lengthrs rpprintz Table.pprints   -H8}|+"8}  -!1$  /* 6H  ! !(W"4 5 6 S388N33c9:eAh-( 2 1NIsD~~i0H KK3)c(m*C#DD E$-S> H 4"%dnnY&?"@1"D4y D3/CI*E#FFG H LLsxx~-3 459~/"%eBi. 1  Qo-. S?*+yyrc,t|jSr)reprrrs r__repr__zTable.__repr__r$rc g}|jD]*}|j|Dcgc] }t|c},|Dcgc]}dj|}}dj|Scc}wcc}w)N r)rr5rr)rrr=rrs ras_textz Table.as_textsg99 5C KKs3tT3 4 5+/0C300yy40s A+ A0)rNNr)asc)F)rTableStyleSheetrN)rr )>__name__ __module__ __qualname____doc__rrrrrrr r r#objectr+r-__hash__r0r2rrr;r8rFrBrr r\r`rbrfrkfloatrnrprUrtrxr{rrrrrrrrrpropertyshaperrrrrrrrrrrrr/rrr r s5)-#' ( (DI& (C= (  (33(Ft$H!##IT#YI4I )S )d) E3E$E +c+d+EESETE,c,3,4,(%( tCc7l++,d3<.@@ A(c#'&/#/#/S/T/ Lc L3 LeCHo LRV L((d5k49dSVi6W0X(]a( EC E49 E E ^b "d5#45tCy@A "MUVY] "  " * *tCy *C *SW *$$S $EsEtE 8C 85cE9I3J 8t 8 Hs HeDIuJK ') #$LT Ks B4 B9 B>r]r>c"||j|<y)z.sets the size of the specified col_id to valueNrrr]r>s rset_sizezTableStyle.set_sizes! &rrEcj|dk(rd}n|jj|dz }||j|<y)zAllows to set the size according to the column index rather than using the column's id. BE CAREFUL : the '0' column is the '__row_column__' one ! rrrNrrrrr]rEr>s rset_size_by_indexzTableStyle.set_size_by_indexs6 >%F[[**9q=9F! &rc"||j|<y)z3sets the alignment of the specified col_id to valueNrrs r set_alignmentzTableStyle.set_alignment%s!&vrcj|dk(rd}n|jj|dz }||j|<y)zAllows to set the alignment according to the column index rather than using the column's id. BE CAREFUL : the '0' column is the '__row_column__' one ! rrrNrrrrs rset_alignment_by_indexz!TableStyle.set_alignment_by_index)s6 >%F[[**9q=9F!&vrc"||j|<y)z.sets the unit of the specified col_id to valueNrrs rset_unitzTableStyle.set_unit5s" 6rcj|dk(rd}n|jj|dz }||j|<y)a)Allows to set the unit according to the column index rather than using the column's id. BE CAREFUL : the '0' column is the '__row_column__' one ! (Note that in the 'unit' case, you shouldn't have to set a unit for the 1st column (the __row__column__ one)) rrrNrrrrs rset_unit_by_indexzTableStyle.set_unit_by_index9s6 >%F[[**9q=9F" 6rc |j|S)z(Returns the size of the specified col_idrrr>s rget_sizezTableStyle.get_sizeGsyy  rch|dk(rd}n|jj|dz }|j|S)zAllows to get the size according to the column index rather than using the column's id. BE CAREFUL : the '0' column is the '__row_column__' one ! rrrrrrEr>s rget_size_by_indexzTableStyle.get_size_by_indexKs7 >%F[[**9q=9Fyy  rc |j|S)z-Returns the alignment of the specified col_idrrs r get_alignmentzTableStyle.get_alignmentWs~~f%%rch|dk(rd}n|jj|dz }|j|S)zAllors to get the alignment according to the column index rather than using the column's id. BE CAREFUL : the '0' column is the '__row_column__' one ! rrrrrs rget_alignment_by_indexz!TableStyle.get_alignment_by_index[s7 >%F[[**9q=9F~~f%%rc |j|S)z(Returns the unit of the specified col_idrrs rget_unitzTableStyle.get_unitgszz&!!rch|dk(rd}n|jj|dz }|j|S)zAllors to get the unit according to the column index rather than using the column's id. BE CAREFUL : the '0' column is the '__row_column__' one ! rrrrrs rget_unit_by_indexzTableStyle.get_unit_by_indexks7 >%F[[**9q=9Fzz&!!r)rrrrr rrrrrrrrrrrrrrrr/rrrrs&! *e * *"c"3"4" "s "s "t "'3''' 'C 'C 'D '#c#3#4# #s #s #t #!s!s! !3 !3 !&C&C& & & &"s"s" "3 "3 "rrz([0-9]+)_([0-9]+)c eZdZdZddeeeddfdZdeddfdZde e e fd e d e d e ddf d Z de e e fd e d e d e ddf d Z de e e fde de de ddf dZ de e e fde de de ddf dZy)raA simple Table stylesheet Rules are expressions where cells are defined by the row_index and col_index separated by an underscore ('_'). For example, suppose you want to say that the (2,5) cell must be the sum of its two preceding cells in the row, you would create the following rule :: 2_5 = 2_3 + 2_4 You can also use all the math.* operations you want. For example:: 2_5 = sqrt(2_3**2 + 2_4**2) Nrulesrc\|xsg}g|_g|_|D]}|j|yr)rradd_rule)rrrules rrzTableStyleSheet.__init__s5  " ,. D MM$  rrc0 dg}|jtjd||jjt dj |dd|j j|y#t$rtd|zYywxYw)z#Adds a rule to the stylesheet ruleszfrom math import *zself.data[\1][\2]rztable.pyexecz"Bad Stylesheet Rule : %s [skipped]N) r5 CELL_PROGsubrcompilerr SyntaxErrorprint)rr source_codes rrzTableStyleSheet.add_rules ?/0K   y}}-A4H I    $ $WTYY{-CZQW%X Y JJ  d # ? 6= > ?sA8A;;BB dest_cellrc start_colend_colct||dzDcgc] }d||fz }}d|zdj|z}|j|ycc}w)a&Creates and adds a rule to sum over the row at row_index from start_col to end_col. dest_cell is a tuple of two elements (x,y) of the destination cell No check is done for indexes ranges. pre:: start_col >= 0 end_col > start_col r%d_%d%d_%d=+Nrrr)rrrcrrrA cell_listrs radd_rowsum_rulezTableStyleSheet.add_rowsum_rules[@EYPWZ[P[?\]eW 511] ])#chhy&99 d^A ct||dzDcgc] }d||fz }}||z dz}d|zdzdj|zd|zz}|j|ycc}w)aCreates and adds a rule to make the row average (from start_col to end_col) dest_cell is a tuple of two elements (x,y) of the destination cell No check is done for indexes ranges. pre:: start_col >= 0 end_col > start_col rrr(r)/%fNr) rrrcrrrArnumrs radd_rowavg_rulezTableStyleSheet.add_rowavg_rulesx@EYPWZ[P[?\]eW 511] ] !A%)#c)CHHY,??&3,N d^ArE start_rowend_rowct||dzDcgc] }d||fz }}d|zdj|z}|j|ycc}w)a&Creates and adds a rule to sum over the col at col_index from start_row to end_row. dest_cell is a tuple of two elements (x,y) of the destination cell No check is done for indexes ranges. pre:: start_row >= 0 end_row > start_row rrrrNr)rrrEr"r#rArrs radd_colsum_rulezTableStyleSheet.add_colsum_rules[@EYPWZ[P[?\]eWy11] ])#chhy&99 d^rct||dzDcgc] }d||fz }}||z dz}d|zdzdj|zd|zz}|j|ycc}w)aCreates and adds a rule to make the col average (from start_row to end_row) dest_cell is a tuple of two elements (x,y) of the destination cell No check is done for indexes ranges. pre:: start_row >= 0 end_row > start_row rrrrrrNr) rrrEr"r#rArrrs radd_colavg_rulezTableStyleSheet.add_colavg_rulesx@EYPWZ[P[?\]eWy11] ] !A%)#c)CHHY,??&3,N d^r!r)rrrrrrrrrrrrr r%r'r/rrrr{s   htCy1 T ?S?T?sCx58EHSV  sCx58EHSV "sCx58EHSV  sCx58EHSV rrc eZdZdZdeddfdZdeeefdede de e effd Z d e dede de e effd Z d e dede de e effd Zde e efde dede e effdZdede dede ee ffdZdede dede fdZy)TableCellRendererzDefines a simple text renderer propertiesrNc ||_y)a/keywords should be properties with an associated boolean as value. For example : renderer = TableCellRenderer(units = True, alignment = False) An unspecified property will have a 'False' value by default. Possible properties are : alignment, unit N)r*rr*s rrzTableCellRenderer.__init__s %r cell_coordr[ table_stylec|\}}|j||}|j|||dz}|j|||dzS)z@Renders the cell at 'cell_coord' in the table, using table_styler)r_make_cell_content_render_cell_content)rr-r[r.rcrE cell_value final_contents r render_cellzTableCellRenderer.render_cellsT * 9ZZ *95 // KUVW (( YQR]SSrr6c,|}|j||dS)z!Renders the cell for 'row_id' rowr)r1)rr6r[r.r2s rrender_row_cellz!TableCellRenderer.render_row_cells (([!DDrr9ch|}|jj|}|j|||dzS)z!Renders the cell for 'col_id' rowr)rrAr1)rr9r[r.r2rEs rrender_col_cellz!TableCellRenderer.render_col_cells6 OO))(3 (([)a-PPrcontentrEc|S)aMakes the appropriate rendering for this cell content. Rendering properties will be searched using the *table_style.get_xxx_by_index(col_index)' methods **This method should be overridden in the derived renderer classes.** r/)rr9r.rEs rr1z&TableCellRenderer._render_cell_contents r cell_contentc|}d|jvr|jd}nd}|r|dk(r|S |jd}|r|j|||}|S#t$rY|SwxYw)zVMakes the cell content (adds decoration data, like units for example) skip_zerorr)r* _add_unitrD)rr;r.rEr3replacement_charunits_ons rr0z$TableCellRenderer._make_cell_contents *6 $// )#{;     2# # w/H $|[) T    s$A A A cF|j|}t|dz|zS)z'Adds unit to the cell_content if neededr)rr)rr;r.rEunits rr>zTableCellRenderer._add_unit(s',,Y7< 3&--r)rrrrrrrrr rrrr4r6r8r1r0r>r/rrr)r)s:(%S%T%TS/T27TFPT sCxTEE$)E8BE sCxEQQ$)Q8BQ sCxQ S#X 5? LO  sCx .8EH sCx0.c. .s.WZ.rr)cFeZdZdZdededefdZdeeefdededefdZ y) DocbookRendererz1Defines how to render a cell for a docboook tablerEr.rc2|j|}d||fzS)z3Computes the colspec element according to the stylez' )r)rrEr.rs rdefine_col_headerz!DocbookRenderer.define_col_header1s",,Y79Yz z%s r)r*rrD)rr;r.rEalign_onrs rr1z$DocbookRenderer._render_cell_content6sY 8{3H#::9EI;DlSS  8(<7 7 8s*/AAN) rrrrrrrrFrr1r/rrrDrD.sP;N3NZNCN !#s(O:DQT rrDc `eZdZdZdededeededdf dZd Z d e ddfd Z d Z dd e ddfdZy) TableWriterzA class to write tablesstreamr[styler*rNc d||_|xs t||_||_||_d|_yr)_streamrrLrr*renderer)rrKr[rLr*s rrzTableWriter.__init__Ms1 /j/  $37 rc||_y)z!sets the table's associated styleN)rL)rrLs r set_stylezTableWriter.set_styleVs  rrOc||_y)zsets the way to render cellN)rO)rrOs r set_rendererzTableWriter.set_rendererZs   rc :|jj|y)z0Updates writer's properties (for cell rendering)N)r*updater,s rupdate_propertieszTableWriter.update_properties^s z*rtitlectd)Writes the tablez!write_table must be implemented !)NotImplementedErrorrrWs r write_tablezTableWriter.write_tablebs!"EFFrr)rrrrr r rrrrQrDrSrVrr\r/rrrJrJJsi!88',85=c]8RU8 8!_!!+GGdGrrJc2eZdZdZddZddZd deddfdZy) DocbookTableWriterzDDefines an implementation of TableWriter to write a table in DocbookrNcj|jJtt|jjdzD]A}|j j |jj||jC|j j d|j j d|jjD]L}|j j |jj||j|jN|j j dy)zWrites col headersNrz z z ) rOrrrrrNwriterFrLr8)rrEr9s r_write_headersz!DocbookTableWriter._write_headersjs}}(((s4;;#8#89A=> WI LL  t}}>>y$**U V W -. ./ -- aH LL  t}}< z z z ) rOrNrarrrrr6rLr4)rrcr=r6rErs r _write_bodyzDocbookTableWriter._write_bodyzs}}((( ;'' (8(89 +NIs LL  y ){{,,Y7H LL  t}}<  4 ""MM--y).DdkkSWS]S]^  LL  z * + <(rrWc2|jjd|z|jjdt|jjdzz|j |j |jjdy)rYz%s> z6 rz
N)rNrarrrrbrdr[s rr\zDocbookTableWriter.write_tablesx :eDE  E4;;(()A- /    23r)rNr])rrrrrbrdrr\r/rrr_r_gs"N1 )* 4 4d 4rr_)rtypesrtypingrrrrrr r _ior re __docformat__rr rr r rr)rDrJr_r/rrrks$DDD % c Fc Lr"r"j BJJ* + bbJK.K.\'8GG:2424r