o
    _~#g3                     @   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 s-w   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/static.ux5.de/https/Moving-Object-Detection-with-OpenCV/env/lib/python3.10/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 s-w   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*}tjtdd t|d W d    n1 s3w   Y  t|d W d    d S 1 sHw   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	| }t
|d
 tjtdd |d
d W d    n1 s<w   Y  |d
| tjttdd |d
d W d    n1 sbw   Y  td}tjt|d |jd
ddgd W d    n1 sw   Y  |d
d}t|jt|jj t|tsJ td}tjt|d |d
d W d    n1 sw   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    d S 1 sw   Y  d S )"Nr   )
      ABCDdtypez
2000-01-01r5   r+   )periodsfreqcolumnsr-   r%   zNo object named df in the filer   r-   z%'column [foo] not found in the table'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 indexablevalues_block_0stringdf2)data_columnsr6      df3)startr.   )rF   r/   r)   df4T)r   nprandomdefault_rngstandard_normalr   listobjectr   r   r   r   r   r    select_columnappendreescape	TypeErrortmassert_almost_equalvaluesr	   r-   
isinstance
ValueErrorcopynanlocassert_series_equal)	r#   r%   r3   msgresultrB   rE   rH   expectedr&   r&   r'   test_read_columnK   st   


$r`   c                 C   sN   t | ddddd}|d }W d    n1 sw   Y  t|ts%J d S )Niodatazlegacy_hdf/pytables_native.h5r2   modezdetector/readout)r   rW   r   )datapathr3   d2r&   r&   r'   test_pytables_native_read   s   
rg   z#native2 read fails oddly on windows)reasonc                 C   sX   t | dddddd}t| |d }W d    n1 sw   Y  t|ts*J d S )Nra   rb   
legacy_hdfzpytables_native2.h5r2   rc   detector)r   strrW   r   )re   r3   d1r&   r&   r'   test_pytables_native2_read   s   
rm   c                 C   sr   t | dddddd}|d}W d    n1 sw   Y  tg dgg d	td
gddd}t|| d S )Nra   rb   ri   zlegacy_table_fixed_py2.h5r2   rc   r%   )   r      D)r*   r+   Crp   ABC
INDEX_NAME)namer<   )r   selectr   r   rT   assert_frame_equalre   r3   r^   r_   r&   r&   r'   'test_legacy_table_fixed_format_read_py2   s   rx   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 s+w   Y  t|| d S )Nz2020-02-06T18:00r*   datezM8[ns])r=   r-   r9   ra   rb   ri   z"legacy_table_fixed_datetime_py2.h5r2   rc   r%   )r   r   r   r   ru   rT   rv   re   r_   r3   r^   r&   r&   r'   0test_legacy_table_fixed_format_read_datetime_py2   s   
r{   c                 C   sf   t | dddddd}|d}W d    n1 sw   Y  tdd	gd
dgd}t|| d S )Nra   rb   ri   zlegacy_table_py2.h5r2   rc   tabler   r   r   ro   r   )r   ru   r   rT   rv   rw   r&   r&   r'   test_legacy_table_read_py2   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 t	|d
}t
|dd}t	|d
}t|| |jsEJ W d    d S 1 sPw   Y  d S )Nr   r6      abcdABCDEr-   r=   lettersETkeysrP   r%   wr   rd   r2   rc   )r   rI   rJ   rK   rM   r-   rt   	set_indexr   r   r   rT   rv   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 s-J t
|| d S )
Nr   r~   )r   rn   r   ro   r   r   r%   r   r|   r   rd   format)r   rI   rJ   rK   rM   r   r   r-   _databaserT   rv   )r"   r#   r%   r$   rB   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sCJ t| }W d    n1 sSw   Y  t|| d S )Nr   r~   r   r   r   r   r   Tr   r%   r   tr   )iterator)r   rI   rJ   rK   rM   r-   rt   r   r   r   r   r3   rW   r   next__iter__rT   rv   )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    d S 1 sIw   Y  d S )Nr   r~   r   r   r   r%   r   r   rB   ?key must be provided when HDF5 file contains multiple datasets.r   )r   rI   rJ   rK   rM   r   r   rT   rv   r   r   rX   r"   r#   r%   r$   rereadr]   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    d S 1 sHw   Y  d S )Nr   abacdcategoryr8   )icr%   r   r|   r   rB   r   r   )r   r   r	   rM   r   r   rT   rv   r   r   rX   r   r&   r&   r'   test_read_nokey_table)  s   
"r   c                 C   s^   | | }t |}|  td}tjt|d t| W d    d S 1 s(w   Y  d S )Nz]Dataset(s) incompatible with Pandas data types, not table, or no datasets found in HDF5 file.r   )r   closerQ   rR   r   r   rX   r   )r"   r#   r$   r3   r]   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   r~   r   r   r   r%   r   r   r   )
r   rI   rJ   rK   rM   r   r   r   rT   rv   )r"   r#   r_   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   r~   r   r   r   r%   r   r   r   )py.pathr   r   rI   rJ   rK   rM   r   r   rT   rv   )r"   r#   	LocalPathr_   r   r   r   r&   r&   r'   test_read_from_py_localpathT  s   r   r   fixedr|   c                 C   sH   t tdtjd}| | }|j|d|d t|ddd}t|| d S )Nr5   r8   rb   r   r   r2   r   )r	   r   rI   float64r   r   rT   r\   )r"   r   r#   seriesr$   r^   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 s)w   Y  t|| d S )N)g      ?r   ro   )z
2015-01-01z
2015-01-02z
2015-01-05r+   )r;   r,   ra   rb   ri   z*periodindex_0.20.1_x86_64_darwin_2.7.13.h5r2   rc   p)r   pdPeriodIndexr   rT   rv   rz   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 s1w   Y  tdg didtdgddd}t	|| d S )Npyarrowr   )r   r   Nrb   r|   r   zfuture.infer_stringTr2   r   zstring[pyarrow_numpy]r8   )r9   r=   )
r   importorskipr   r   r   option_contextr   r   rT   rv   )r"   r#   r%   r$   r^   r_   r&   r&   r'   test_read_infer_string  s   

r   )9
contextlibr   pathlibr   rQ   numpyrI   r   pandas._libs.tslibsr   pandas.compatr   pandasr   r   r   r   r	   r
   rT   r   r   pandas.tests.io.pytables.commonr   r   pandas.utilr   tdpandas.io.pytablesr   mark
single_cpu
pytestmarkr(   r1   r4   r`   rg   skipifrm   rx   r{   r}   r   r   r   r   r   r   r   
skip_if_nor   parametrizer   filterwarningsr   r   r&   r&   r&   r'   <module>   sL    $	R
	



