o
    ;Dim                  
   @   s"  d dl mZmZmZ d dlmZ d dlmZ d dlZzd dlm	Z	 W n e
y1   d dlm	Z	 Y nw d dlZd dlmZmZ d dlmZ dd	 Zz
d dlZd dlZW n e
yn Z zejd
e dd W Y dZ[dS dZ[ww dd Zdd Zdd Zdd Zdd Zdd Zdd Zdd ZdS )    )divisionprint_functionabsolute_import)datetime)NamedTemporaryFileN)patch)fromxlstoxls)ieqc                  C   s$   zdd l } | ddW S    Y d S )Nr   petlztest/resources/test.xls)pkg_resourcesresource_filename)r    r   N/var/www/Datamplify/venv/lib/python3.10/site-packages/petl/test/io/test_xls.py_get_test_xls   s
   r   zSKIP xls tests: %sT)allow_module_levelc               	   C   sN   t  } | d u r	d S t| d}dddddtdddff}t|| t|| d S )	NSheet1foobarA   B   Cr      é  r   r   r   r   r
   filenametblexpectr   r   r   test_fromxls#   s   

r%   c               	   C   sL   t  } | d u r	d S t| }dddddtdddff}t|| t|| d S )Nr   r   r   r   r   r   r   r    r!   r   r   r   test_fromxls_nosheet0   s   
r&   c                  C   s<   t  } | d u r	d S t| ddd}d}t|| t|| d S )Nr   F)use_view)r   r   r   r   )r   g    @)r   r   r
   r!   r   r   r   test_fromxls_use_view=   s   
r(   c                  C   sH   d} t dd}|  t| |jd t|jd}t| | t| | d S N)r   r   r   r   Fdeleter   r   closer	   namer   r
   r$   factualr   r   r   
test_toxlsJ   s   

r2   c                  C   sH   g } t dd}|  t| |jd t|jd}t| | t| | d S )NFr*   r   r,   r/   r   r   r   test_toxls_headerlessV   s   

r3   c                  C   sl   ddt dddfdt dddff} td	d
}|  t| |jddtjddid t|jd}t| | d S )Nr   r   r   r   u   ééi  r      Fr*   r   r   z
DD/MM/YYYY)num_format_str)styles)	r   r   r-   r	   r.   xlwteasyxfr   r
   r/   r   r   r   test_toxls_date_   s   

r9   c                  C   sP   d} t dd}|  t| |jd t|jd}t| | t| | d S r)   )r   r-   etlwrapr	   r.   r   r
   r/   r   r   r   test_integrationj   s   

r<   c               
      s   t  } | d u r	d S ddlm} |j  fdd}td|( t| dddd}d	d
dddtdddff}t|| t|| W d    d S 1 sHw   Y  d S )Nr   )Viewc                    s"   d|v sJ  | g|R i |S )Nignore_workbook_corruptionr   )selfargskwargsorg_initr   r   wrapper~   s   z4test_passing_kwargs_to_xlutils_view.<locals>.wrapperz"petl.io.xlutils_view.View.__init__r   T)r'   r>   r   r   r   r   r   r   r   )r   petl.io.xlutils_viewr=   __init__r   r   r   r
   )r"   r=   rD   r#   r$   r   rB   r   #test_passing_kwargs_to_xlutils_viewv   s"   
"rG   ) 
__future__r   r   r   r   tempfiler   pytestunittest.mockr   ImportErrormockr   r:   petl.io.xlsr   r	   petl.test.helpersr
   r   xlrdr7   eskipr%   r&   r(   r2   r3   r9   r<   rG   r   r   r   r   <module>   s8    	