
    A[g                        d dl mZm Z  d dlZd dlZd dlmZ d dlZd dlm	Z
 d dlmZ  ej                  d      Z e       rej                  j                   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)is_platform_windows)ExcelWriterodfc                       y)Nz.ods r	       _/var/www/html/bid-api/venv/lib/python3.12/site-packages/pandas/tests/io/excel/test_odswriter.pyextr      s    r
   c                     d}t        j                  |       5 }t        j                  t        |      5  t        |dd       d d d        d d d        y # 1 sw Y   xY w# 1 sw Y   y xY w)Nz&Append mode is not supported with odf!matchr   a)enginemode)tmensure_cleanpytestraises
ValueErrorr   )r   msgfs      r   test_write_append_mode_raisesr      sL    
2C		]]:S1%c2 2 
	11 
	s"   A AA A	A  A)engine_kwargskwarg   c                 L   t        j                  |       5 }|Ht        j                  d      }t	        j
                  t        |      5  t        |d|       d d d        nt        |d|      5 }	 d d d        d d d        y # 1 sw Y   xY w# 1 sw Y   xY w# 1 sw Y   y xY w)NzDOpenDocumentSpreadsheet() got an unexpected keyword argument 'kwarg'r   r   )r   r   )r   r   reescaper   r   	TypeErrorr   )r   r   r   error_s        r   test_engine_kwargsr$   #   s    
 
	$IIVE  Ae=I	  QuMJa K 
	
  KJ 
	s;   3B	BB/B1BB	BB	BB#c                 l   t        j                  |       5 }t        |      5 }|j                  i k(  sJ t        j
                  j                  d      }|j                  j                  j                  |       |j                  d|ik(  sJ 	 d d d        d d d        y # 1 sw Y   xY w# 1 sw Y   y xY w)N	test_name)name)
r   r   r   sheetsr   tableTablebookspreadsheet
addElement)r   r   writerr)   s       r   test_book_and_sheets_consistentr/   7   s    		^v==B&&&IIOOO5EKK##..u5==[%$8888	  
	^ 
	s#   B*A*BB*B'	#B**B3)valuecell_value_typecell_value_attribute
cell_value)Tbooleanzboolean-valuetrue)test stringstringzstring-valuer6   )r   floatr0   1)g      ?r8   r0   z1.5i  
   r   z
date-valuez2010-10-10T10:10:10z
2010-10-10)	argvaluesc           	         ddl m} ddlm}m}  |       j
                  }t        j                  |       5 }	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        d d d        y c c}w # 1 sw Y   xY w# 1 sw Y   y xY w)Nr   )OFFICENS)	TableCellTableRowF)headerindexqnamez
value-type)odf.namespacesr=   	odf.tabler>   r?   rB   r   r   pd	DataFrameto_excel	ExcelFile_readerget_sheet_by_indexgetElementsByType
childNodeshasattr
attributesget)r   r0   r1   r2   r3   r=   r>   r?   table_cell_namer   wbsheet
sheet_rowsxsheet_cellscells                   r   test_cell_value_typerW   A   s0   & (
  k''O		
ugY((5(F\\!_JJ11!4E00:J $A111A1g&177o+E 1   q>D??&&,'?@OSSS??&&2F'GHJVVV  
	 _ 
	s6   ?E4>D82$D3AD8"E3D88E	=EE)r   r   r   r   pandas.compatr   pandasrE   pandas._testing_testingr   pandas.io.excelr   importorskipr   mark
single_cpu
pytestmarkfixturer   r   parametrizer$   r/   rW   r	   r
   r   <module>rc      s   
  -   'f% ''J  3 4'1*>? @&9 F2@"&T2r2r2.!		
 
dB	V\<@   W! Wr
   