
    .i	                         d dl Z d dlZd dlZd dlmZ d dlmZ  ej                  d      Zej                  d        Z
ej                  d        Zd Zd Zej                  j                  d	d
dg      d        Zd Zy)    N)	DataFrame)ExcelWriter
xlsxwriterc                       y)Nz.xlsx r       c/var/www/app/trading-bot/venv/lib/python3.12/site-packages/pandas/tests/io/excel/test_xlsxwriter.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                    t        j                  d      }t        ddgddgd      }t        |       5 }|j	                  |       d}|j
                  }|j                         d   }|j                  d|i      }|j                  dd |       d d d        t        j                  |j                  |             5 }	 |d   }	d d d        	 	d
   }
	 |
j                  }|k(  sJ y # 1 sw Y   WxY w# t        $ r |j                  d	      }	Y Lw xY w# 1 sw Y   QxY w# t        $ r 	j                  d
      }
Y jw xY w# t         $ r# |
j"                  j                  j$                  }Y w xY w)Nopenpyxli@ )ABz#,##0r   
num_formatzB:BSheet1)nameB2)pytestimportorskipr   r   to_excelbook
worksheets
add_format
set_column
contextlibclosingload_workbook	TypeErrorget_sheet_by_namecellnumber_formatAttributeErrorstyle_format_code)r   r   framewriterr   write_workbookwrite_worksheet
col_formatread_workbookread_worksheetr'   read_num_formats               r	   test_column_formatr4      s    "":.HVV,FF3CDEE	Y	 <6v 
(335a8#..j/IJ
""5$
;< 
		H229=	> L-	L*84NL)d#
@,, j(((;< <  	L*<<(<KN	LL L  )""4()  @**22??@sZ   AC"8D:C.D D; "C+.D	DDDDD87D8;)E'&E'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 xlsxwriter!)matchr   a)enginemode)r   raises
ValueErrorr   )r   msgs     r	   test_write_append_mode_raisesr=   @   s6    
9C	z	- >Il=> > >s   6?nan_inf_to_errorsTFc                     dd|ii}t        | d|      5 }|j                  j                  |k(  sJ 	 d d d        y # 1 sw Y   y xY w)Noptionsr>   r   )r8   engine_kwargs)r   r   r>   )r   r>   rA   r-   s       r	   test_engine_kwargsrB   G   sY     !46G HIM	,m
 B	{{,,0AAAAB B Bs	   ;Ac                     t        | d      5 }|j                  i k(  sJ |j                  j                  d      }|j                  d|ik(  sJ 	 d d d        y # 1 sw Y   y xY w)Nr   )r8   	test_name)r   sheetsr   add_worksheet)r   r-   sheets      r	   test_book_and_sheets_consistentrH   Q   s`    	Y|	4 5}}"""))+6}}e 44445 5 5s   A AA!)r"   r   r   pandasr   pandas.io.excelr   r   r   fixturer
   r   r4   r=   markparametrizerB   rH   r   r   r	   <module>rN      s        ' V  .
    $)N> ,tUm<B =B5r   