o
    _~#g<                     @   sX  d dl 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	  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 ejjZedZej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 Z(dd Z)ej*dg dd d! Z+d"d# Z,ej-d$d% Z.d&d' Z/d(d) Z0d*d+ Z1d,d- Z2d.d/ Z3dS )0    N	timedelta)	Timestamp)	DataFrameIndexSeries_testingconcat
date_rangeread_hdf)_maybe_removeensure_clean_storetablesz!ignore::tables.NaturalNameWarningc              
   C   s  t | F}ttjddttdtdt	ddddd	}t
|d
 |d
|d d  |d
|dd   t|d
 | t
|d |jd|d d dd |d|dd   t|d | t
|d |d|d d  |d|dd   t|d | t
|d |d|d d  |d|dd   t|d | tddgddgddgddggd}d|d< tj|jd< t
|d |d| t|d | tttjdjddddtjdttjdjddddtjdttjdjddddtjdtg dtjdd tdd!}t
|d" |d"| tj|d" |d#d$ t
|d" |jd"|g d%d& tj|d" |d#d$ W d    d S 1 sOw   Y  d S )'N   )      ABCDdtype
2000-01-01r   Bperiodsfreqcolumnsindexdf1
   df2table)formatdf3z/df3z/df3 foozdf3 foo   r   )datatestingmixed_column)r   r&   df      )highsizei  i   @)l           l          @l            l            l            )u08u16u32u64r   uintsTcheck_index_type)r,   r-   r.   data_columns)r   r   nprandomdefault_rngstandard_normalr   listobjectr
   r   appendtmassert_frame_equalputnanlocr   integersuint8uint16uint32uint64arange)
setup_pathstorer'   	uint_data rK   /var/www/static.ux5.de/https/Moving-Object-Detection-with-OpenCV/env/lib/python3.10/site-packages/pandas/tests/io/pytables/test_append.pytest_append   sn   



"


$rM   c           	      C   s  t | }ttdtjdd tdD d}ttjdtjdtdddd	}ttd
}|d| |d }t	|| |j
d u sDJ |d| |d }t	|| |j
d u s[J d|_
|d| |d }t	|| |j
|j
ksvJ ||dk }|dd}t	|| ||dk|jdk @  }|dd}tj	||dd ttjdddgd}tt||d< d|d< d|jdddf< |jddgdd |jdd }|jd|_|d!| tj	|d! |dd W d    d S 1 sw   Y  d S )"Nr   c                 S      g | ]}d | qS )i_rK   .0irK   rK   rL   
<listcomp>k       z&test_append_series.<locals>.<listcomp>)r   r   r   r   z
2020-01-01r   r0   d   sstsfoons<   zfoo>60F   Z   zfoo>70 and index<90Tr2   r   )r)   r#   Ar   r   Cbar   r)   inplace)future_stackmi)r   r   ranger6   float64rG   r
   r<   r=   assert_series_equalnameselectr   r   r7   r8   r9   lenrA   	set_indexstack	droplevel)	rH   rI   rW   rX   rZ   resultexpectedrf   srK   rK   rL   test_append_seriesh   sF   
""rs   c                 C   s  t | }tttjdddtjddtjddddtd	dtd	dd	t
dd
}t|d tj|jddg df< |d|d d  |d|dd   tj|d |dd | }tj|d< t|d |d|d d  |d|dd   tj|d |dd | }tj|d< t|d |d|d d  |d|dd   tj|d |dd | }tj|d< t|d |d|d d  |d|dd   tj|d |dd W d    d S 1 sw   Y  d S )Nr   r   int32rY   ra   
2001-01-01rZ   
2001-01-02)r^   A1A2r   r`   DEr0   r   r      )rw   r   ry   rz   r   Tr2   rw   rx   r   rz   r"   )r   r   r   r6   r7   r8   r9   astyper   as_unitrG   r   r@   rA   r<   r=   r>   copy)rH   rI   r'   r   r   r"   rK   rK   rL   test_append_some_nans   sL   







"r   c                 C   s
  t | }ttjddtjdddtdd}tj|jddd d f< t	|d |j
d|d d d	d
 |j
d|dd  d	d
 tj|d |dd  d	d t	|d |j
d|d d dd
 |j
d|dd  dd
 tj|d |d	d tdd) t	|d |
d|d d  |
d|dd   t|d | W d    n1 sw   Y  tdd	% t	|d |
d|d d  |
d|dd   t|d |dd   ttjddtjdddddtdd}tj|jddd d f< t	|d |j
d|d d d	d
 |j
d|dd  d	d
 tj|d |d	d t	|d |j
d|d d dd
 |j
d|dd  dd
 tj|d |d	d ttjddtjddddtddtdddtdd}tj|jddd d f< t	|d |j
d|d d d	d
 |j
d|dd  d	d
 tj|d |d	d t	|d |j
d|d d dd
 |j
d|dd  dd
 tj|d |d	d W d    n1 sw   Y  W d    d S W d    d S 1 sw   Y  d S )Nr   r   )rw   rx   r0   r   r{   r'   r   T)dropnar2   r   Fio.hdf.dropna_tabler"   df4rY   ra   )rw   rx   r   r`   ru   rZ   rv   )rw   rx   r   r`   ry   rz   )r   r   r6   r7   r8   r9   rG   r@   rA   r   r<   r=   r>   pdoption_contextr   r}   rH   rI   r'   rK   rK   rL   test_append_all_nans   s   








 $r   c              	   C   sv  t | }ttjddttdtdt	ddddd	}|j
d |_
t|d
 |jd
|jd d d df dgd |d
|jd d dd f  t|d
 | |d
d}|jdgd}t|| |d
d}|jdg|j
dd d	}t|| td}tjt|d |d
d W d    n1 sw   Y  W d    d S W d    d S 1 sw   Y  d S )Nr   r   r   r   r   r   r   r   r   r   r   r   )axes	columns=Ar^   r_   )r   zindex=df.index[0:4]r   r   zOpassing a filterable condition to a non-table indexer [Filter: Not Initialized]matchzcolumns=A and index>df.index[4])r   r   r6   r7   r8   r9   r   r:   r;   r
   r   
_with_freqr   r<   ilocr=   r>   rk   reindexreescapepytestraises	TypeError)rH   rI   r'   rp   rq   msgrK   rK   rL   !test_append_frame_column_oriented  s4   

$"r   c              	   C   sj  t | z}tdD ]m}ttjddtdd}td|d< |d  |d 7  < tdgt	| dd	|d< tdgt	| d
d	|d
< |d dkrZ|d= tdgt	| dd	|d< |d dkri|
d}||d< |jddd |d| q	W d    n1 sw   Y  t | }ttjddtddd}tdgt	| dd	|d< tdgt	| d
d	|d
< |d| tdgt	| d
d	|d< td}tjt|d |d| W d    n1 sw   Y  tdgt	| dd	|d< td}tjt|d |d| W d    n1 sw   Y  W d    d S W d    d S 1 s.w   Y  d S )Nr   r   )r   r   ABr_   r   r#   int64r   int16r   rb   r^   Trc   r'   rh   )r   r   int16_2zCcannot match existing table structure for [int16] on appending datar         ?float_3zAcannot match existing table structure for [A,B] on appending data)r   rg   r   r6   r7   r8   r9   r:   r   rl   poprm   r<   r   r   r   r   
ValueError)rH   rI   rR   r'   ar   rK   rK   rL   )test_append_with_different_block_ordering>  sZ   


 $r   c              	      sD  t |   fdd}tddgddgg} d| t d| |ddd	 td
dgddgg} d| t||g}t d| |ddd	 tddgddgg} jd|ddid t d| |ddd  d| td
dgddgg}d}tjt	|d  d| W d    n1 sw   Y  tg dg dt
g dtdtddddd} jd |d! d"d#id t d |d!   jd$|d! d%d"d#id& t d$|d!   jd'|d(d"d)id* |  jd+d,d} d'| t d't||g  jd-|d! d(d"d)id*  d-|d!  t d-t|d! |d! g t d. ttjd/d0t
td1tdtd2d3d!d4d5}d6|d7< tj|j|jd8d# d7f< d9|d:< tj|j|jd#d; d:f< d<|d=< tj|j|jd8d  d=f<  d.|  d.}t|| W d    n	1 sw   Y  t |  td6d9d>td3d?}t d.  jd.|d@dAid |d.d@dA  d.jd@gksJ t d.  jd.|d!gd@dAid& |d.d@dA  d.jd!d@gksJ t d.  jd.|d!gddAid& |d.d!dA |d.dBdA  d.jd!gks,J t d.  jd.|d d dAd  jd.|dd  dAd t d. | tg dCd@gdD}t d. t dE}tjt	|d  jd.|dFdFdGd W d    n1 sw   Y  W d    d S W d    d S 1 sw   Y  d S )HNc                    "   t  | jj|j|ksJ d S Ngetattr
get_storerr    descriptionitemsizekeyrj   r+   rI   rK   rL   	check_colu     "z+test_append_with_strings.<locals>.check_col{   	asdqwertyiY  dggnhebbsdfbdfbdf_bigvalues_block_1r{   |   asdqyiZ  dggnhefbdfbdf_big2values2   min_itemsizedf_new
abcdefqhijabcdefghijklmnopqrtsuvwxyzzTrying to store a string with len \[26\] in \[values_block_1\] column but\nthis column has a limit of \[15\]!\nConsider using min_itemsize to preset the sizes on these columnsr   )        r   g       @g      @g      @)r   r   r   r   r   )foo1foo2foo3foo4foo5r   20130101r)   rU   )r^   r   r`   ry   r`   rW   r   r   r   ss2Tr5   r   ss3r       )r!   r   longer)r`   ss4r'   r   r   r   r   r   r   r   rY   stringr#   ra   string2   bahstring3r^   r   r0   r^      values_block_0)rY   rY   rY   barhr   r   r_   zBmin_itemsize has the key [foo] which is not an axis or data_columnr   )rY   foobar)!r   r   r<   r=   r>   rk   r	   r   r   r   r   r;   r
   rm   ri   r?   r~   reset_indexassignr   r6   r7   r8   r9   r:   r@   rA   r   rg   r   r5   r   r   )rH   r   r'   r   rq   r   r   rp   rK   r   rL   test_append_with_stringsr  s   
"


T




 "$r   c                 C   s   t | 6}tdg di}|jd|d d ddid |jd|dd  ddid t|d| W d    d S 1 s=w   Y  d S )Nx)r   bcdef r'   r#   r   )r   r   r<   r=   r>   rk   r   rK   rK   rL   test_append_with_empty_string  s   
"r   c           	   	      s  t |  ttjddttdtdt	ddddd	}d
|j
d|jdf< t d  jd|d d dgd  d|dd   t d |  jjjjjjjdu sZJ  jjjjjjjdu sgJ  dd}||jdk }t||  dd}|j|jdd  d}||jdk }t|| | }d|d< tj|j|jdd df< d|j|jdd df< t d  jd|dgd  dd}||jdk }t||  fdd}W d    n1 sw   Y  t | K t d  jd|dgddid |ddd t d  jd|dgdd |ddd t d  jd|dgddid |ddd W d    n	1 sBw   Y  t | : d|d < d!|d"< d#|d$< t d  jd|dd gdd%d&d'd |ddd |dd d% |dd(d& W d    n	1 sw   Y  t |  | }d
|j
d|jd)f< d*|j
d|jdf< d|d< |jd}tj|j
dd|f< d|j
dd|f< d|d < |jd }tj|j
dd|f< d|j
d+d,|f< t d  jd|g d-d  dd.}||jdk|jdk@ |j dk@ |jdk @  }tj||d/d0  dd1}||jdk|jd2k@  }t|| W d    n	1 s=w   Y  t |  | }d|d< tj|j|jdd df< d|j|jd+d3 df< d2|d < t!d4"d5|d6< tj|j|jd7d g d8f< t d9  jd9|g d:d  d9d}||jdk }t||  d9g d;}||jdk|j#dk@ |jdk@  }tj||d/d0 W d    n	1 sw   Y  t |  t	d<d,d=}ttjdd>|g d?d@}d|d< tj|j|jdd df< d|j|jd+d3 df< |ddAg $ |ddAg< d2|d <  jd9|g dBd  d9d}||jdk }t||  d9g dC}||jdk|j#dk@ |jdk@  }t|| W d    d S 1 sgw   Y  d S )DNr   r   r   r   r   r   r   r   r   r   r   r'   r4   TB>0zB>0 and index>df.index[3]r   r0   rY   r   r#   ra   r)   r   zstring='foo'c                    r   r   r   r   r   rK   rL   r     r   z0test_append_with_data_columns.<locals>.check_col   r   r   	foobarbahr   
foobarbah1string_block1
foobarbah2string_block2(   r   )r   r   r   r   r^   g         r   )r^   r   r   r   z.string='foo' and string2='foo' and A>0 and B<0F)
check_freqzstring='foo' and string2='cool'cool	   20010102rZ   datetimerb   )r^   r   r   df_dc)r   r`   r   r   r   )B > 0C > 0zstring == fooz1/1/2000rU   )r   rb   )r^   r   r`   )r   r   r`   )r   r`   r   r   )r   r   zstring == "foo")%r   r   r6   r7   r8   r9   r   r:   r;   r
   r   r   get_locr   r<   r=   r>   _handlerootr'   r    colsr   
is_indexedr   rk   r   r~   r@   rA   r   r   r^   r   r}   r`   abs)	rH   r'   rp   rq   r   r   slr   r   rK   r   rL   test_append_with_data_columns  s   



,








 

"
"$r   c                 C   s   |}d |j _t|0}|d| |d}t|| |jdddgd}|jddgd}t|| W d    n1 s=w   Y  | d }|j|ddd t	|dddgd}|jddgd}t|| d S )	Nrf   r^   r   r_   ztest.hdfr'   r    )r   r!   )
r   rj   r   r<   rk   r=   r>   r   to_hdfr   )tmp_pathrH    multiindex_dataframe_random_datar'   rI   rp   rq   pathrK   rK   rL   test_append_hierarchical  s   


r   c                 C   s   t | O}tdtdd ttdtdtdd tdD tdd	}|j	d
|dd |
d
}t|| |j	d|dd |
d}t|| W d    d S 1 sVw   Y  d S )N皙?x   r   r   r   r   c                 S   rN   zi-rK   rP   rK   rK   rL   rS     rT   z$test_append_misc.<locals>.<listcomp>r   r   r'   r#   	chunksizer   r   )expectedrows)r   r   r6   rG   reshaper   r:   r;   rg   r<   rk   r=   r>   )rH   rI   r'   rp   rK   rK   rL   test_append_misc  s   


"r  r  )r   r   i  c                 C   s   t dtdd ttdtdtdd tdD tdd	}d
|d< d|d< |d d|d< |d dk|d< t	d
d|d< t	d
d|d< t| dd}|jd||d |d}t|| W d    d S 1 spw   Y  d S )Nr   r   r   r   r   c                 S   rN   r  rK   rP   rK   rK   rL   rS     rT   z.test_append_misc_chunksize.<locals>.<listcomp>r   r   rY   r   r   float322float32r   boolr   rZ   time120130102time2w)modeobjr  )r   r6   rG   r  r   r:   r;   rg   r|   r   r}   r   r<   rk   r=   r>   )rH   r  r'   rI   rp   rK   rK   rL   test_append_misc_chunksize  s    
"r  c              	   C   s  t | u}ttdd}|d| tjtdd |d W d    n1 s)w   Y  ttj	
d	dtdd}|d| t|d| |d| t|d| ttdd}|d| t|d| W d    d S 1 s|w   Y  d S )	NABCr_   r'   z 'No object named df in the file'r   r   )r   rb   r   )r   r   r:   r<   r   r   KeyErrorrk   r6   r7   r8   r=   r>   r?   )rH   rI   df_emptyr'   rK   rK   rL   test_append_misc_empty_frame  s   
"r  c              	   C   s  t | }tdtdd ttdtdtdd tdD tdd	}d
ggt	| |d< |j
d tjks:J td}tjt|d |d| W d    n1 sWw   Y  d
ggt	| |d< d
ggt	| |d< tjt|d |d| W d    n1 sw   Y  tdtdd ttdtdtdd tdD tdd	}ttddd|jd}|t}tj|dd< ||d< |j
d tjksJ d}tjt|d |d| W d    n1 sw   Y  d}tjt|d |dtd W d    n	1 sw   Y  td}tjt|d |dttd W d    n	1 s8w   Y  tdtdd ttdtdtdd tdD tdd	}|d| d|d< td}tjt|d |d| W d    n	1 sw   Y  t|d td|d< |d| d |d< td!}tjt|d |d| W d    n1 sw   Y  W d    d S W d    d S 1 sw   Y  d S )"Nr   r   r   r   r   c                 S   rN   r  rK   rP   rK   rK   rL   rS     rT   z%test_append_raise.<locals>.<listcomp>r   r   r   invalidziCannot serialize the column [invalid]
because its data contents are not [string] but [mixed] object dtyper   r'   invalid2invalid3c                 S   rN   r  rK   rP   rK   rK   rL   rS     rT   i  r#   r   r0   r   r)   z>too many timezones in this block, create separate data columnsz(value must be None, Series, or DataFramer   z]cannot properly create the storer for: [group->df,value-><class 'pandas.core.series.Series'>]c                 S   rN   r  rK   rP   rK   rK   rL   rS     rT   rY   zinvalid combination of [non_index_axes] on appending data [(1, ['A', 'B', 'C', 'D', 'foo'])] vs current table [(1, ['A', 'B', 'C', 'D'])]r   ra   a  invalid combination of [values_axes] on appending data [name->values_block_1,cname->values_block_1,dtype->bytes24,kind->string,shape->(1, 30)] vs current table [name->values_block_1,cname->values_block_1,dtype->datetime64[s],kind->datetime64[s],shape->None])r   r   r6   rG   r  r   r:   r;   rg   rl   dtypesobject_r   r   r   r   r   r<   r   r   r   r|   r@   r   r   r   )rH   rI   r'   r   rr   rK   rK   rL   test_append_raise  s   

 R$r  c                    s  t dd t  fddtdD d}|d |d  |d	< tj|jd
dd	f< t| }t|d |j	d|dd |
d}t|| |j
ddd}t|| |j
ddd}t||jd
d   |
dd}t||jd
d   |
dd}|jd	gd}t||jdd   |
dd}|jdd  }t||jdd   t|d |d| |
d}t|| W d    d S 1 sw   Y  d S )Nr   rZ   c                    s   g | ]
} t |d d qS )r   )dayssecondsr   rP   rX   rK   rL   rS   C  s    z.test_append_with_timedelta.<locals>.<listcomp>r   r   r^   r   r`   rb   r)   r'   Tr4   zC<100000)wherezC<pd.Timedelta('-3D')zC<'-3D'zC<'-500000s')subsetr   z	C<'-3.5D'r#   r   r   )r   r}   r   rg   r6   r@   rA   r   r   r<   rk   r=   r>   r   r   r?   )rH   r'   rI   rp   rK   r  rL   test_append_with_timedelta;  s<   




"r   c              	   C   s  t tjddttdtdtddddd	}|	 j
d
jd}d|d< t||gdd}t| }d}tjt|d |jddgd d|dd W d    n1 sTw   Y  tjt|d |jd d d|dd W d    n1 svw   Y  d}tjt|d |d|d W d    n1 sw   Y  |jddgd d|dd |jddgddgdd}||jdk|jdk@  }t|| W d    d S 1 sw   Y  d S )Nr   r   r   r   r   r   r   r   r   {}_2r_   ra   rY   r#   axisz=append_to_multiple requires a selector that is in passed dictr   r^   r   r   r"   )selectorzQappend_to_multiple must have a dictionary specified as the way to split the valuer   r   zA>0r   )r  r%  r   )r   r6   r7   r8   r9   r   r:   r;   r
   r~   renamer!   r	   r   r   r   r   append_to_multipleselect_as_multipler^   r   r=   r>   )rH   r   r   r'   rI   r   rp   rq   rK   rK   rL   test_append_to_multiplej  s<   
"r)  c                 C   s&  t tjddttdtdtddddd	}t tjddttdtdtddddd	j	d
j
d}tj|jd|jddgf< t||gdd}t| 8}|jddgd d|ddd |ddg}| }tj||dd t|dj|dj W d    d S 1 sw   Y  d S )Nr   r   r   r   r   r   r   r   r   r!  r_   r#   r^   r"  r$  r   Tr%  r   r   r2   )r   r6   r7   r8   r9   r   r:   r;   r
   r&  r!   r@   r   r   get_indexerr	   r   r'  r(  r   r=   r>   assert_index_equalrk   r   )rH   r   r   r'   rI   rp   rq   rK   rK   rL   test_append_to_multiple_dropna  s.   
"r-  c              
   C   sT  t tjddttdtdtddddd	}|	 j
d
jd}tj|jd|jddgf< t||gdd}t| d}tddE |jddgd d|ddd d}tjt|d |ddg W d    n1 smw   Y  |dj|djrJ W d    n1 sw   Y  W d    d S W d    d S 1 sw   Y  d S )Nr   r   r   r   r   r   r   r   r   r!  r_   r#   r^   r"  r   T)df1adf2ar.  Fr*  z,all tables must have exactly the same nrows!r   r/  )r   r6   r7   r8   r9   r   r:   r;   r
   r~   r&  r!   r@   r   r   r+  r	   r   r   r   r'  r   r   r   r(  rk   r   equals)rH   r   r   r'   rI   r   rK   rK   rL   $test_append_to_multiple_dropna_false  s(    Pr1  c              	   C   s   t tddtddtddd dd tdD dd tdD d}|jd	g }t| 2}|jd
gddgddgd|jd	g dddddd |g d}tj	||dd W d    d S 1 sew   Y  d S )Nr#      X   c                 S      g | ]}d qS )r   rK   rQ   _rK   rK   rL   rS         z8test_append_to_multiple_min_itemsize.<locals>.<listcomp>r   c                 S   r4  )abcderK   r5  rK   rK   rL   rS     r7  )IXNumBigNumStrLongStrr   r9  r:  r;  r<  r=  )r   numsstrsr   r   rV   r   )r<  r=  r:  r   Tr2   )
r   r6   rG   rg   r   r   r'  r(  r=   r>   )rH   r'   rq   rI   rp   rK   rK   rL   $test_append_to_multiple_min_itemsize  s,   

	



"r@  )4r   r   r   numpyr6   r   pandas._libs.tslibsr   pandas.util._test_decoratorsutil_test_decoratorstdpandasr   r   r   r   r   r=   r	   r
   r   pandas.tests.io.pytables.commonr   r   mark
single_cpu
pytestmarkimportorskipr   filterwarningsrM   rs   r   r   r   r   r   r   r   r   r  parametrizer  r  &skip_array_manager_not_yet_implementedr  r   r)  r-  r1  r@  rK   rK   rK   rL   <module>   sF    $	


H/0V!4{	 

W/%