
    .i                        d dl mZm Z  d dlZd dlZd dlZd dlZd dlmZ  ej                  d      Z
ej                  d        Zej                  d        Zd Zej                  j!                  ddd	d
ig      d        Zd Zej                  j!                  g ddddd e dddddd      dddf eddd      dddfg      d        Zy)    )datedatetimeN)ExcelWriterodfc                       y)Nz.ods r       b/var/www/app/trading-bot/venv/lib/python3.12/site-packages/pandas/tests/io/excel/test_odswriter.pyextr      s    r	   c                 n    |t        j                          |  z  }|j                          t        |      S )N)uuiduuid4touchstr)r   tmp_pathtmps      r
   	tmp_excelr      s-    


~cU+
+CIIKs8Or	   c                     d}t        j                  t        |      5  t        | dd       d d d        y # 1 sw Y   y xY w)Nz&Append mode is not supported with odf!matchr   a)enginemode)pytestraises
ValueErrorr   )r   msgs     r
   test_write_append_mode_raisesr      s6    
2C	z	- 7Ie#67 7 7s   6?engine_kwargskwarg   c                     |Ht        j                  d      }t        j                  t        |      5  t        | d|       d d d        y t        | d|      5 }	 d d d        y # 1 sw Y   y xY w# 1 sw Y   y xY w)NzDOpenDocumentSpreadsheet() got an unexpected keyword argument 'kwarg'r   r   )r   r   )reescaper   r   	TypeErrorr   )r   r   error_s       r
   test_engine_kwargsr(   $   s    
  		R
 ]]
 	N 	%}M		N 	N 5N 	RS	 		N 	N	 	s   A$A0$A-0A9c                    t        |       5 }|j                  i k(  sJ t        j                  j	                  d      }|j
                  j                  j                  |       |j                  d|ik(  sJ 	 d d d        y # 1 sw Y   y xY w)N	test_name)name)r   sheetsr   tableTablebookspreadsheet
addElement)r   writerr-   s      r
   test_book_and_sheets_consistentr3   7   sv    	Y	 56}}"""		[1**51}}e 4444	5 5 5s   A*B  B	)valuecell_value_typecell_value_attribute
cell_value)Tbooleanzboolean-valuetrue)test stringstringzstring-valuer:   )r!   floatr4   1)g      ?r<   r4   z1.5i  
   r   z
date-valuez2010-10-10T10:10:10z
2010-10-10)	argvaluesc                 L   ddl m} ddlm}m}  |       j
                  }t        j                  |gg      j                  | dd       t        j                  |       5 }	|	j                  j                  d      }
|
j                  |      }|d   j                  D cg c]  }t        |d      r|j
                  |k(  r|! }}|d   }|j                  j!                  |df      |k(  sJ |j                  j!                  ||f      |k(  sJ 	 d d d        y c c}w # 1 sw Y   y xY w)Nr   )OFFICENS)	TableCellTableRowF)headerindexqnamez
value-type)odf.namespacesrA   	odf.tablerB   rC   rF   pd	DataFrameto_excel	ExcelFile_readerget_sheet_by_indexgetElementsByType
childNodeshasattr
attributesget)r   r4   r5   r6   r7   rA   rB   rC   table_cell_namewbsheet
sheet_rowsxsheet_cellscells                  r
   test_cell_value_typer[   @   s!   * (
  k''OLL5'$$YuE$J	i	  SB

--a0,,X6
  ]--
q'"qww/'A 
 
 1~""Hl#;<OOO""H.B#CD
RRRS S
S Ss   >D$D ADDD#)r   r   r#   r   r   pandasrI   pandas.io.excelr   importorskipr   fixturer   r   r   markparametrizer(   r3   r[   r   r	   r
   <module>rb      s   
    'f%     7 4'1*>? @$5 F2@"&T2r2r2.!		
 
dB	V\<@   S! Sr	   