a
    Pf3                     @   s  d dl mZ d dlmZ d dlZd dlZd dlZd dlm	Z	 d dl
mZ d dlZd dlmZmZmZmZmZmZmZ d dlmZmZ d dlmZ d d	lmZ ejjZ d
d Z!dd Z"dd Z#dd Z$dd Z%ejj&e dd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&d' Z/d(d) Z0d*d+ Z1e2d,d-d. Z3ej4d/d0d1gd2d3 Z5ej6d4ej6d5d6d7 Z7d8d9 Z8dS ):    )closing)PathN)	Timestamp)is_platform_windows)	DataFrameHDFStoreIndexSeries_testing
date_rangeread_hdf)_maybe_removeensure_clean_store)_test_decorators)TableIteratorc                 C   sv   | | }t tdtdd}|j|dd tjtdd t|d W d    n1 sZ0    Y  |j|dd d S )N   abk1key 'No object named k2 in the file'matchk2)r   rangeto_hdfpytestraisesKeyErrorr   tmp_path
setup_pathpathdf r&   [/var/www/ai-form-bot/venv/lib/python3.9/site-packages/pandas/tests/io/pytables/test_read.py!test_read_missing_key_close_store    s    (r(   c                 C   sv   | | }t g g dg d}|j|dd tjtdd t|ddd W d    n1 sZ0    Y  |j|dd d S )	NABindexr   r   zlist index out of ranger   r   stop)r   r   r   r   
IndexErrorr   r!   r&   r&   r'   !test_read_index_error_close_store.   s    ,r1   c              	   C   s   | | }t tdtdd}|j|dd t|dR}tjtdd t|d W d    n1 sf0    Y  t|d W d    n1 s0    Y  d S )	Nr   r   r   r   rr   r   r   )r   r   r   r   r   r   r    r   )r"   r#   r$   r%   storer&   r&   r'   "test_read_missing_key_opened_store<   s    (r4   c           	   	   C   s  t tjddttdtdtddddd	}t	| Z}t
|d
 tjtdd |d
d W d    n1 sx0    Y  |d
| tjttdd |d
d W d    n1 s0    Y  td}tjt|d" |jd
ddgd W d    n1 s0    Y  |d
d}t|jt|jj t|tsLJ td}tjt|d |d
d W d    n1 s0    Y  | }d|d< |jd|dgd |dd}t|j|d j | }d|d< tj|j|jdd df< |jd|dgd |dd}t|j|d j |jdddd}t|j|d jdd   |jdddd}t|j|d jdd   |jdddd}t|j|d jd d  |jdddd}t|j|d jd d  |jddddd}t|j|d jdd  |jddddd}t|j|d jdd  t tjdddd}|jd |d!d |d }|d d}t|| W d    n1 s0    Y  d S )"Nr   )
      ZABCDdtypez
2000-01-01r5   r+   )Zperiodsfreqcolumnsr-   r%   zNo object named df in the filer   r-   z%'column [foo] not found in the table'Zfooz:select_column() got an unexpected keyword argument 'where'zindex>5)wherezScolumn [values_block_0] can not be extracted individually; it is not data indexableZvalues_block_0stringdf2)Zdata_columnsr6      df3)startr.   )rA   r/   r)   df4T)r   nprandomdefault_rngZstandard_normalr   listobjectr   r   r   r   r   r    Zselect_columnappendreescape	TypeErrortmZassert_almost_equalvaluesr	   r-   
isinstance
ValueErrorcopynanlocassert_series_equal)	r#   r%   r3   msgresultr>   r@   rC   expectedr&   r&   r'   test_read_columnK   sj    
*
*
2,rX   c                 C   sN   t | ddddd}|d }W d    n1 s20    Y  t|tsJJ d S )Niodatazlegacy_hdf/pytables_native.h5r2   modezdetector/readout)r   rO   r   )datapathr3   Zd2r&   r&   r'   test_pytables_native_read   s    &r^   z#native2 read fails oddly on windows)reasonc                 C   sX   t | dddddd }t| |d }W d    n1 s<0    Y  t|tsTJ d S )NrY   rZ   
legacy_hdfzpytables_native2.h5r2   r[   Zdetector)r   strrO   r   )r]   r3   Zd1r&   r&   r'   test_pytables_native2_read   s    &rb   c                 C   sr   t | dddddd}|d}W d    n1 s60    Y  tg dgg d	td
gddd}t|| d S )NrY   rZ   r`   zlegacy_table_fixed_py2.h5r2   r[   r%   )   r      D)r*   r+   Cre   ABCZ
INDEX_NAME)namer:   )r   selectr   r   rM   assert_frame_equalr]   r3   rV   rW   r&   r&   r'   'test_legacy_table_fixed_format_read_py2   s    (rl   c                 C   sp   t tdggdgtdgdd}t| dddd	d
d}|d}W d    n1 sV0    Y  t|| d S )Nz2020-02-06T18:00r*   datezM8[ns])r;   r-   r8   rY   rZ   r`   z"legacy_table_fixed_datetime_py2.h5r2   r[   r%   )r   r   r   r   ri   rM   rj   r]   rW   r3   rV   r&   r&   r'   0test_legacy_table_fixed_format_read_datetime_py2   s    
(ro   c                 C   sf   t | dddddd}|d}W d    n1 s60    Y  tdd	gd
dgd}t|| d S )NrY   rZ   r`   zlegacy_table_py2.h5r2   r[   tabler   r   r   rd   r   )r   ri   r   rM   rj   rk   r&   r&   r'   test_legacy_table_read_py2   s    (rq   c                 C   s   t tjddtdtdd}d|j_|jddd	}| | }|j|d
dd t	|d
}t
|dd0}t	|d
}t|| |jsJ W d    n1 s0    Y  d S )Nr   r6      abcdABCDEr-   r;   lettersETkeysrI   r%   wr   r\   r2   r[   )r   rD   rE   rF   rG   r-   rh   	set_indexr   r   r   rM   rj   Zis_open)r"   r#   r%   r$   directr3   indirectr&   r&   r'   test_read_hdf_open_store   s    

r   c                 C   sj   t tjddg dtdd}| | }|j|dddd	 t|d}|jjj	d u sZJ t
|| d S )
Nr   rr   )r   rc   r   rd   ru   rv   r%   r{   rp   r   r\   format)r   rD   rE   rF   rG   r   r   r-   _databaserM   rj   )r"   r#   r%   r$   r>   r&   r&   r'   test_read_hdf_index_not_view   s    
r   c                 C   s   t tjddtdtdd}d|j_|jddd	}| | }|j|d
ddd t	|d
}t	|d
dd}t
|j* t|tsJ t| }W d    n1 s0    Y  t|| d S )Nr   rr   rt   ru   rv   rw   rx   Try   r%   r{   tr   )iterator)r   rD   rE   rF   rG   r-   rh   r}   r   r   r   r3   rO   r   next__iter__rM   rj   )r"   r#   r%   r$   r~   r   r   r&   r&   r'   test_read_hdf_iterator  s    
*r   c                 C   s   t tjddtdtdd}| | }|j|ddd t|}t|| |j|d	dd d
}t	j
t|d t| W d    n1 s0    Y  d S )Nr   rr   rt   ru   rv   r%   r   r|   r>   ?key must be provided when HDF5 file contains multiple datasets.r   )r   rD   rE   rF   rG   r   r   rM   rj   r   r   rP   r"   r#   r%   r$   ZrereadrU   r&   r&   r'   test_read_nokey  s    r   c                 C   s   t tdttdddd}| | }|j|dddd	 t|}t|| |j|d
ddd	 d}tj	t
|d t| W d    n1 s0    Y  d S )Nrs   Zabacdcategoryr7   )icr%   r   rp   r   r>   r   r   )r   r   r	   rG   r   r   rM   rj   r   r   rP   r   r&   r&   r'   test_read_nokey_table)  s    r   c                 C   s\   | | }t |}|  td}tjt|d t| W d    n1 sN0    Y  d S )Nz]Dataset(s) incompatible with Pandas data types, not table, or no datasets found in HDF5 file.r   )r   closerJ   rK   r   r   rP   r   )r"   r#   r$   r3   rU   r&   r&   r'   test_read_nokey_empty8  s    r   c                 C   s`   t tjddtdtdd}| | }t|}|j|ddd t|dd	}t	|| d S )
Nr   rr   rt   ru   rv   r%   r   r|   r   )
r   rD   rE   rF   rG   r   r   r   rM   rj   )r"   r#   rW   filenamepath_objactualr&   r&   r'   test_read_from_pathlib_pathD  s    r   zpy.pathc                 C   sl   ddl m} ttjddtdtdd}| | }||}|j|dd	d
 t|dd}t	
|| d S )Nr   )localr   rr   rt   ru   rv   r%   r   r|   r   )Zpy.pathr   r   rD   rE   rF   rG   r   r   rM   rj   )r"   r#   Z	LocalPathrW   r   r   r   r&   r&   r'   test_read_from_py_localpathT  s    r   r   fixedrp   c                 C   sH   t tdtjd}| | }|j|d|d t|ddd}t|| d S )Nr5   r7   rZ   r   r   r2   r|   )r	   r   rD   Zfloat64r   r   rM   rT   )r"   r   r#   Zseriesr$   rV   r&   r&   r'   test_read_hdf_series_mode_rg  s
    r   z8ignore:Period with BDay freq is deprecated:FutureWarningz3ignore:PeriodDtype\[B\] is deprecated:FutureWarningc                 C   sl   t g dtjg dddd}t| dddd	d
d}|d }W d    n1 sR0    Y  t|| d S )N)g      ?r   rd   )z
2015-01-01z
2015-01-02z
2015-01-05r+   )r9   r,   rY   rZ   r`   z*periodindex_0.20.1_x86_64_darwin_2.7.13.h5r2   r[   p)r   pdZPeriodIndexr   rM   rj   rn   r&   r&   r'   test_read_py2_hdf_file_in_py3s  s    &r   c                 C   s   t d tdg di}| | }|j|ddd tdd t|dd	d
}W d    n1 sb0    Y  tdg didtdgddd}t	|| d S )NZpyarrowr   )r   r   NrZ   rp   r   zfuture.infer_stringTr2   r|   zstring[pyarrow_numpy]r7   )r8   r;   )
r   Zimportorskipr   r   r   Zoption_contextr   r   rM   rj   )r"   r#   r%   r$   rV   rW   r&   r&   r'   test_read_infer_string  s    
,
r   )9
contextlibr   pathlibr   rJ   numpyrD   r   Zpandas._libs.tslibsr   Zpandas.compatr   Zpandasr   r   r   r   r	   r
   rM   r   r   Zpandas.tests.io.pytables.commonr   r   Zpandas.utilr   tdZpandas.io.pytablesr   markZ
single_cpuZ
pytestmarkr(   r1   r4   rX   r^   Zskipifrb   rl   ro   rq   r   r   r   r   r   r   r   Z
skip_if_nor   Zparametrizer   filterwarningsr   r   r&   r&   r&   r'   <module>   sJ   $	R
	



