o
    ҷh>                     @   s  d Z ddlZ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
Z
ddlmZmZ ddlmZ ddlmZmZmZmZ ddlZddlmZ ddlmZ dd	lmZmZmZm Z m!Z! zddl"Z"d
Z#W n e$ym   dZ#Y nw zddl%Z%d
Z&W n e$y   dZ&Y nw e
j'(dZ)e
j*e
j+de
j'j,e& peddkddde
j+de
j'j,e# dddgddd Z-e
j*dd Z.e
j*dd Z/e
j*dd Z0e
j*dd Z1e
j*d d! Z2e
j*ej3ej4j5ej3ej4j6ej3ej4j7ej8d"d#ej8d$d#ej8d%d#ej8d&d#gdd'd( Z9						
		
	)dFd*d+Z:d,d- Z;d.d/ Z<d0d1 Z=d2d3 Z>d4d5 Z?d6d7 Z@d8d9 ZAd:d; ZBd<d= ZCG d>d? d?ZDG d@dA dAeDZEG dBdC dCeDZFG dDdE dEeDZGdS )Gz test parquet compat     N)Decimal)BytesIO)
get_optionusing_copy_on_write)is_platform_windows)pa_version_under7p0pa_version_under8p0pa_version_under11p0pa_version_under13p0)Version)FastParquetImplPyArrowImpl
get_engineread_parquet
to_parquetTFz2ignore:DataFrame._data is deprecated:FutureWarningfastparquetmode.data_managerarrayz4fastparquet is not installed or ArrayManager is usedreason)markspyarrowpyarrow is not installed)paramsc                 C      | j S Nparamrequest r    O/var/www/html/venv/lib/python3.10/site-packages/pandas/tests/io/test_parquet.pyengine;   s   r"   c                   C   s   t std dS )Nr   r   )_HAVE_PYARROWpytestskipr    r    r    r!   paP   s   
r&   c                   C   s,   t s	td dS tddkrtd dS )Nzfastparquet is not installedr   r   z.ArrayManager is not supported with fastparquetr   )_HAVE_FASTPARQUETr$   r%   r   r    r    r    r!   fpW   s   

r(   c                   C   s   t g dddS )N         fooAB)pd	DataFramer    r    r    r!   	df_compat`   s   r3   c               
   C   sB   t tdttddtjddddg dt jd	d
dd} | S )Nabcr*            @      @float64dtypeTFT20130101r,   periods)abdef)r1   r2   listrangenparange
date_range)dfr    r    r!   df_cross_compate   s   rJ   c                   C   s   t tddtjdgg dg dg dttddtd	d
dtjdddddtjdgg dt jdd	dt 	dt j
t 	dgdS )Nr4   r?   cr?   NrK   )   foo   bars   bazr-   barbazr*   r5   r,      u1r6   r7   r8   r9          @      @r;   r<   r=   20130103)stringstring_with_nanstring_with_nonebytesunicodeintuintfloatfloat_with_nanbooldatetimedatetime_with_nat)r1   r2   rD   rF   nanrE   rG   astyperH   	TimestampNaTr    r    r    r!   df_fullw   s$   

rg   z2019-01-04T16:41:24+0200z%Y-%m-%dT%H:%M:%S%zz2019-01-04T16:41:24+0215z2019-01-04T16:41:24-0200z2019-01-04T16:41:24-0215c                 C   r   r   r   r   r    r    r!   timezone_aware_date_list   s   rh   r+   c
                    s   pddip	i du r|r|d< |d<  fdd}
du rFt  |
|	 W d   dS 1 s?w   Y  dS |
|	 dS )a  Verify parquet serializer and deserializer produce the same results.

    Performs a pandas to disk and disk to pandas round trip,
    then compares the 2 resulting DataFrames to verify equality.

    Parameters
    ----------
    df: Dataframe
    engine: str, optional
        'pyarrow' or 'fastparquet'
    path: str, optional
    write_kwargs: dict of str:str, optional
    read_kwargs: dict of str:str, optional
    expected: DataFrame, optional
        Expected deserialization result, otherwise will be equal to `df`
    check_names: list of str, optional
        Closed set of column names to be compared
    check_like: bool, optional
        If True, ignore the order of index & columns.
    repeat: int, optional
        How many times to repeat the test
    compressionNr"   c                    sZ   t | D ]&}jfi  tfi }dv r d jd< tj| d qd S )NrX   r*   rX   )check_names
check_likecheck_dtype)rE   r   r   loctmassert_frame_equal)repeat_actualrm   rl   rk   rI   expectedpathread_kwargswrite_kwargsr    r!   compare   s   
z!check_round_trip.<locals>.compare)ro   ensure_clean)rI   r"   rv   rx   rw   ru   rk   rl   rm   rq   ry   r    rt   r!   check_round_trip   s   "

"r{   c                 C   s~   t r'ddlm} |j| dd}t|jjt|ksJ |jjt|ks%J dS ddlm	} |j	| dd}|j
jj|ks=J dS )zCheck partitions of a parquet file are as expected.

    Parameters
    ----------
    path: str
        Path of the dataset.
    expected: iterable of str
        Expected partition names.
    r   NF)validate_schemahive)partitioning)r   pyarrow.parquetparquetParquetDatasetlen
partitionspartition_namessetpyarrow.datasetdatasetr~   schemanames)rv   ru   pqr   dsr    r    r!   check_partition_names   s   
r   c                 C   sD   d}t jt|d t| dd W d    d S 1 sw   Y  d S )Nz.engine must be one of 'pyarrow', 'fastparquet'matchr-   rP   )r$   raises
ValueErrorr{   )r3   msgr    r    r!   test_invalid_engine   s   "r   c                 C   :   t dd t|  W d    d S 1 sw   Y  d S )Nio.parquet.enginer   r1   option_contextr{   )r3   r&   r    r    r!   test_options_py      
"r   c                 C   r   )Nr   r   r   )r3   r(   r    r    r!   test_options_fp  r   r   c                 C   r   )Nr   autor   )r3   r(   r&   r    r    r!   test_options_auto  r   r   c                 C   sP  t tdts	J t tdtsJ tdd# t tdts"J t tdts+J t tdts4J W d    n1 s>w   Y  tdd# t tdtsSJ t tdts\J t tdtseJ W d    n1 sow   Y  tdd$ t tdtsJ t tdtsJ t tdtsJ W d    d S 1 sw   Y  d S )Nr   r   r   r   )
isinstancer   r   r   r1   r   )r(   r&   r    r    r!   test_options_get_engine  s"   "r   c                  C   s  ddl m}  | d}| d}tsdnttjt|k }ts!dnttjt|k }to.| }to3| }|s|s|r\d| d}t	j
t|d td	 W d    n1 sVw   Y  nd
}t	j
t|d td	 W d    n1 stw   Y  |rd| d}t	j
t|d td	 W d    d S 1 sw   Y  d S d}t	j
t|d td	 W d    d S 1 sw   Y  d S d S d S )Nr   )VERSIONSr   r   FzPandas requires version .z. or newer of .pyarrow.r   r   z%Missing optional dependency .pyarrow.z. or newer of .fastparquet.z)Missing optional dependency .fastparquet.)pandas.compat._optionalr   getr#   r   r   __version__r'   r   r$   r   ImportErrorr   )r   
pa_min_ver
fp_min_verhave_pa_bad_versionhave_fp_bad_versionhave_usable_pahave_usable_fpr   r    r    r!   "test_get_engine_auto_error_message&  sD   






"
"r   c                 C   s   | }t  0}|j||d d t||d}t || t||ddgd}t ||ddg  W d    d S 1 s9w   Y  d S N)r"   ri   r"   r?   rA   )r"   columnsro   rz   r   r   rp   rJ   r&   r(   rI   rv   resultr    r    r!   test_cross_engine_pa_fpQ  s   
"r   c                 C   s   | }t  0}|j||d d t||d}t || t||ddgd}t ||ddg  W d    d S 1 s9w   Y  d S r   r   r   r    r    r!   test_cross_engine_fp_pa_  s   
"r   c                   @   s4   e Zd Zdd Zdd Zejjejjdd Z	dS )Basec              	   C   s|   t  0}tj||d t|||d d W d    n1 sw   Y  W d    d S W d    d S 1 s7w   Y  d S )Nr   ri   )ro   rz   r$   r   r   )selfrI   r"   excerr_msgrv   r    r    r!   check_error_on_writem  s   
"zBase.check_error_on_writec              	   C   sx   t  .}t | t|||d d W d    n1 sw   Y  W d    d S W d    d S 1 s5w   Y  d S )Nr   )ro   rz   external_error_raisedr   )r   rI   r"   r   rv   r    r    r!   check_external_error_on_writes  s   
"z"Base.check_external_error_on_writec                 C   sr   |dkr	t | t|dddddd}|j| d t|j}W d    n1 s,w   Y  t|| d S )	Nr   iodatar   zsimple.parquetrb)mode)content)	r$   importorskipopenserve_contentreadr   urlro   rp   )r   
httpserverdatapathr3   r"   rC   rI   r    r    r!   test_parquet_read_from_urly  s   
zBase.test_parquet_read_from_urlN)
__name__
__module____qualname__r   r   r$   marknetwork
single_cpur   r    r    r    r!   r   l  s    r   c                   @   s   e Zd Zdd Zdd Zejdg 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dd Zejjedd d!d" Zejd#g d$d%d& Zd'S )(	TestBasicc                 C   sF   t g dddt dtg dfD ]}d}| ||t| qd S )Nr)   r*   r-   r<   z+to_parquet only supports IO with DataFrames)r1   Seriesre   rF   r   r   r   )r   r"   objr   r    r    r!   
test_error  s   zTestBasic.test_errorc                 C   s6   t tdttddd}ddg|_t|| d S )Nr4   r*   r5   rW   r\   r-   rP   )r1   r2   rD   rE   r   r{   )r   r"   rI   r    r    r!   test_columns_dtypes  s   
zTestBasic.test_columns_dtypesri   )Ngzipsnappybrotlic                 C   s(   t dg di}t||d|id d S )Nr/   r)   ri   rx   r1   r2   r{   )r   r"   ri   rI   r    r    r!   test_compression  s   zTestBasic.test_compressionc                 C   sJ   t tdttddd}t dtdi}t|||ddgid d S )Nr4   r*   r5   r   rW   r   ru   rw   r1   r2   rD   rE   r{   )r   r"   rI   ru   r    r    r!   test_read_columns  s
   
zTestBasic.test_read_columnsc              	   C   sX   t ttdtdd}t dddgi}t||||ddgid	gdgd
dd d S )Nr5   aabb)r\   partr\   r   r*   partition_colsr   )r   ==r?   )filtersr   )rv   ru   rx   rw   rq   r   )r   r"   tmp_pathrI   ru   r    r    r!   test_read_filters  s   

zTestBasic.test_read_filtersc                 C   s   |dk}|r|dkr|j tjjdd tdg di}t|| g dtjddd	t	d
g dg}|D ]}||_
t|tjrH|j
d |_
t|||d q6g d|_
d|j
_t|| d S )Nr   zfastparquet write into indexr   r/   r)   )r+   r,   r5   r<   r,   r=   r4   )r*   r,   r5   )rk   )r   r*   r+   r-   )node
add_markerr$   r   xfailr1   r2   r{   rH   rD   indexr   DatetimeIndex
_with_freqname)r   r"   r   r   rk   rI   indexesr   r    r    r!   test_write_index  s(   

zTestBasic.test_write_indexc                 C   s:   |}t dg di}t jg d}||_t|| d S )Nr/   r)   )r?   r*   )r?   r+   )r@   r*   )r1   r2   
MultiIndexfrom_tuplesr   r{   )r   r&   r"   rI   r   r    r    r!   test_write_multiindex  s
   zTestBasic.test_write_multiindexc                 C   s   |}t jdddd}t jtjddt| dftdd}t j	j
d	d
g|gddgd}|jd d}||fD ]}||_t|| t||dddgi|ddg d q8d S )Nz01-Jan-2018z01-Dec-2018MS)freqr+   r,   ABCr   Level1Level2leveldate)r   r   r/   r0   rw   ru   )r1   rH   r2   rF   randomdefault_rngstandard_normalr   rD   r   from_productcopyr   r{   )r   r&   r"   datesrI   index1index2r   r    r    r!   test_multiindex_with_columns  s"   
z&TestBasic.test_multiindex_with_columnsc                 C   s   t g dg dd}d dd}|jdd}t||||d t jg dg ddg d	d
}t||||d g dg dg}t jttddd tdD d|d
}|jdd}t||||d d S )Nr)   )qrs)r?   r@   F)ri   r   T)droprx   ru   )zyxwvutsrr   rP   rP   rQ   rQ   r-   r-   quxr  onetwor  r  r  r  r  r     c                 S   s   g | ]}| qS r    r    ).0ir    r    r!   
<listcomp>
  s    z7TestBasic.test_write_ignoring_index.<locals>.<listcomp>)r  r  )r1   r2   reset_indexr{   rD   rE   )r   r"   rI   rx   ru   arraysr    r    r!   test_write_ignoring_index  s    
 z#TestBasic.test_write_ignoring_indexc                 C   sb   t jg d}t jtjdd|d}|dkr$| ||t	d d S |dkr/t
|| d S d S )Nr   r+   )r5   r,   r   r   Column name must be a stringr   )r1   r   r   r2   rF   r   r   r   r   	TypeErrorr{   )r   r"   
mi_columnsrI   r    r    r!   test_write_column_multiindex  s   z&TestBasic.test_write_column_multiindexc                 C   sn   g dg dg}t jtjdd|d}ddg|j_|dkr*| ||t	d	 d S |d
kr5t
|| d S d S )Nr  )r*   r+   r*   r+   r*   r+   r*   r+   r+   r  r  r   r   r   r   zColumn namer   )r1   r2   rF   r   r   r   r   r   r   r   r{   r   r"   r  rI   r    r    r!   &test_write_column_multiindex_nonstring  s   z0TestBasic.test_write_column_multiindex_nonstringc                 C   sJ   |}g dg dg}t jtjdd|d}ddg|j_t|| d S )Nr  r  r+   r  r   	ColLevel1	ColLevel2)	r1   r2   rF   r   r   r   r   r   r{   r   r&   r"   r  rI   r    r    r!   #test_write_column_multiindex_string/  s   z-TestBasic.test_write_column_multiindex_stringc                 C   s>   |}g d}t jtjdd|d}d|j_t|| d S )N)rP   rQ   r-   r  r+   r  r5   r   	StringCol)	r1   r2   rF   r   r   r   r   r   r{   r   r    r    r!   test_write_column_index_string@  s   z(TestBasic.test_write_column_index_stringc                 C   sV   g d}t jtjdd|d}d|j_|dkr$| ||t	d d S t
|| d S )Nr*   r+   r,   r5   r+   r"  r   NonStringColr   r  )r1   r2   rF   r   r   r   r   r   r   r  r{   r  r    r    r!   !test_write_column_index_nonstringN  s   z+TestBasic.test_write_column_index_nonstringzminimum pyarrow not installedr   c           
      C   s  dd l m} |dkrtjjdd}|j| tt	g ddt	g ddt	g dt	g d	t	g d
dt	g ddt	g ddd}t
 }||| t||d}t||dd}W d    n1 snw   Y  |d jtdksJ ttj	g dddtj	g dddtj	g dddtj	g d	ddtj	g d
ddtj	g dddtj	g dddd}	|dkr|jddd}|	jddd}	t
||	 d S )Nr   r   z.Fastparquet nullable dtype support is disabledr   r*   r+   r,   Nint64uint8)r?   r@   rK   N)TFTNr%  )      ?rT   rU   Nfloat32r8   )r?   r@   rK   rA   rB   rC   gr   numpy_nullabler"   dtype_backendr?   Int64r9   UInt8rW   booleanFloat32Float64rK   r*   )axis)r   r   r$   r   r   r   r   r   tabler   ro   rz   write_tabler   r:   rF   r1   r2   r  rp   )
r   r"   r   r   r   r7  rv   result1result2ru   r    r    r!   test_dtype_backend^  sH   
zTestBasic.test_dtype_backendr:   )	r1  r2  r3  objectzdatetime64[ns, UTC]r^   z	period[D]r5  rW   c                 C   sT   t dt jg |di}d }|dkrt dt jg ddi}t||ddi|d d S )Nvaluer9   r^   r5  r0  r.  r   )r1   r2   r   r{   )r   r&   r:   rI   ru   r    r    r!   test_read_empty_array  s   
zTestBasic.test_read_empty_arrayN)r   r   r   r   r   r$   r   parametrizer   r   r   r   r   r  r  r  r  r!  r$  r'  skipifr   r;  r>  r    r    r    r!   r     s.    
		 
1r   c                   @   s  e Z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je dde
jdeejgdd Zdd Ze
jjdd Ze
jjdd Ze
jje
jddgg gdd Zdd Zd d! Zd"d# Zd$d% Ze
jjded&d' gd(d)gd*d+d, Zd-d. Zd/d0 Zd1d2 Zd3d4 Z d5d6 Z!d7d8 Z"d9d: Z#d;d< Z$d=d> Z%d?d@ Z&dAdB Z'dCdD Z(dEdF Z)dGdH Z*dIdJ Z+e
jj,e-dKddLdM Z.dNdO Z/dPS )QTestParquetPyArrowc                 C   s@   |}t jdddd}|d }||d< g d|d< t|| d S )Nr<   r,   Europe/Brusselsr>   tzdatetime_tzTNTbool_with_none)r1   rH   r   r{   )r   r&   rg   rI   dtir    r    r!   
test_basic  s   
zTestParquetPyArrow.test_basicc                 C   s<   |}t jdddd|d< t|||ddg dddgid	 d S )
Nr<   r,   rB  rC  rE  rW   r\   r   r   )r1   rH   r{   )r   r&   rg   rI   r    r    r!   test_basic_subset_columns  s   


z,TestParquetPyArrow.test_basic_subset_columnsc           	      C   s   d}d }t  r	t}|j|d}t|tsJ t|}t|}|jdd}d |jd< t	j
||d t	|| W d    d S 1 sBw   Y  d S )Nz.Mismatched null-like values nan and None foundr   F)deeprj   r   )r   FutureWarningr   r   rZ   r   r   r   rn   ro   assert_produces_warningrp   )	r   r&   rg   r   warn	buf_bytes
buf_streamresru   r    r    r!   *test_to_bytes_without_path_or_buf_provided  s   
"z=TestParquetPyArrow.test_to_bytes_without_path_or_buf_providedc                 C   s8   t jtdddtdd }| ||td d S )N   r5   r,   aaar   zDuplicate column names found	r1   r2   rF   rG   reshaperD   r   r   r   r   r&   rI   r    r    r!   test_duplicate_columns  s   $z)TestParquetPyArrow.test_duplicate_columnsc                 C   s<   t dt jdddi}tr| ||t d S t|| d S )Nr?   1 dayr,   r=   )r1   r2   timedelta_ranger   r   NotImplementedErrorr{   rW  r    r    r!   test_timedelta  s   z!TestParquetPyArrow.test_timedeltac                 C   s&   t dg di}| ||tj d S )Nr?   r?   r*   rT   )r1   r2   r   r   ArrowExceptionrW  r    r    r!   test_unsupported  s   z#TestParquetPyArrow.test_unsupportedc                 C   s6   t jddt jd}tj|dgd}| ||tj d S )Nr+   
   r9   fp16r   r   )rF   rG   float16r1   r2   r   r   r^  )r   r&   r   rI   r    r    r!   test_unsupported_float16  s   z+TestParquetPyArrow.test_unsupported_float16zqPyArrow does not cleanup of partial files dumps when unsupported dtypes are passed to_parquet function in windowsr   	path_typec              	   C   s   t jddt jd}tj|dgd}t 2}||}ttj	 |j
||d W d    n1 s2w   Y  tj|r?J W d    d S 1 sJw   Y  d S )Nr+   r`  r9   ra  rb  )rv   r"   )rF   rG   rc  r1   r2   ro   rz   r   r   r^  r   osrv   isfile)r   r&   re  r   rI   path_strrv   r    r    r!    test_unsupported_float16_cleanup  s   
"z3TestParquetPyArrow.test_unsupported_float16_cleanupc                 C   sd   t  }t td|d< t jg dt g dd|d< t jg dg dd	d
|d< t|| d S )Nabcdefr?   )rP   r-   r-   rP   NrP   rO   r9   r@   )r?   r@   rK   r?   rK   r@   )r@   rK   rA   T)
categoriesorderedrK   )r1   r2   CategoricalrD   CategoricalDtyper{   rW  r    r    r!   test_categorical  s   

z#TestParquetPyArrow.test_categoricalc                 C   s@   t d}|jdi |}d|i}t|||j d||d d S )Ns3fs
filesystem/pyarrow.parquetrv   rw   rx   r    )r$   r   S3FileSystemr{   r   )r   r3   s3_public_bucketr&   s3sorp  s3kwr    r    r!   test_s3_roundtrip_explicit_fs  s   


z0TestParquetPyArrow.test_s3_roundtrip_explicit_fsc                 C   s(   d|i}t ||d|j d||d d S )Nstorage_optionss3://rr  rs  r{   r   )r   r3   ru  r&   rv  r    r    r!   test_s3_roundtrip,  s   
z$TestParquetPyArrow.test_s3_roundtrippartition_colr/   c              
   C   sr   t d | }|r |t|tj}d}|| |||< t|||d|j	 dd|i|d |dddd	 d S )
Nrp  categoryr{  z/parquet_dirrz  )r   ri   rz  Tr*   )ru   rv   rw   rx   rl   rq   )
r$   r   r   rd   dictfromkeysrF   int32r{   r   )r   r3   ru  r&   r~  rv  expected_dfpartition_col_typer    r    r!   test_s3_roundtrip_for_dir8  s*   

z,TestParquetPyArrow.test_s3_roundtrip_for_dirc                 C   s2   t d t }|| t|}t|| d S )Nr   )r$   r   r   r   r   ro   rp   )r   r3   bufferdf_from_bufr    r    r!   test_read_file_like_obj_support_  s
   

z2TestParquetPyArrow.test_read_file_like_obj_supportc                 C   s   t d |dd |dd t jtdd td W d    n1 s'w   Y  t jtdd |d W d    d S 1 sDw   Y  d S )Nr   HOMETestingUserUSERPROFILEz.*TestingUser.*r   z~/file.parquet)r$   r   setenvr   OSErrorr   r   )r   r3   monkeypatchr    r    r!   test_expand_userf  s   

"z#TestParquetPyArrow.test_expand_userc                 C   s>   ddg}|}|j ||d d t|| t|j|jksJ d S )Nr`   r\   r   ri   r   r   r   shape)r   r   r&   rg   r   rI   r    r    r!   test_partition_cols_supportedo  s
   
z0TestParquetPyArrow.test_partition_cols_supportedc                 C   s@   d}|g}|}|j ||d d t|| t|j|jksJ d S )Nr`   r  r  )r   r   r&   rg   r   partition_cols_listrI   r    r    r!   test_partition_cols_stringw  s   
z-TestParquetPyArrow.test_partition_cols_stringc                 C   s   | S r   r    )xr    r    r!   <lambda>  s    zTestParquetPyArrow.<lambda>rW   zpathlib.Path)idsc           	      C   s<   d}|g}|}||}|j ||d t|j|jksJ d S )Nr0   )r   )r   r   r  )	r   r   r&   r3   re  r   r  rI   rv   r    r    r!   test_partition_cols_pathlib  s   z.TestParquetPyArrow.test_partition_cols_pathlibc                 C   s   t jg g d}t|| d S )N)r   r   r   rW  r    r    r!   test_empty_dataframe  s   z'TestParquetPyArrow.test_empty_dataframec                 C   sV   dd l }tdddgi}||jd| dg}|t}t||d|i|d d S )Nr   r  r*   )typer   r  )	r   r1   r2   r   fieldbool_rd   r`   r{   )r   r&   r   rI   r   out_dfr    r    r!   test_write_with_schema  s
   
z)TestParquetPyArrow.test_write_with_schemac                 C   sz   t d ttjg dddtjg dddtjg dddd}t|| td	tjg d
ddi}t|| d S )Nr   r)   r1  r9   UInt32rL   rW   r?   r@   rK   r?   r(  )r$   r   r1   r2   r   r{   rW  r    r    r!    test_additional_extension_arrays  s   

z3TestParquetPyArrow.test_additional_extension_arraysc              	   C   st   t d tdtjg dddi}td| t|||d| dd	 W d    d S 1 s3w   Y  d S )
Nr   r?   rL   string[pyarrow]r9   string_storagezstring[]ru   )r$   r   r1   r2   r   r   r{   rd   )r   r&   r  rI   r    r    r!    test_pyarrow_backed_string_array  s
   
"z3TestParquetPyArrow.test_pyarrow_backed_string_arrayc                 C   sV   t d ttjg dtjddddtjtjddddd}t	|| d S )	Nr   ))r   r*   )r*   r+   )r,   r5   z
2012-01-01r,   D)r>   r   r5   )rK   rA   rB   )
r$   r   r1   r2   IntervalIndexr   period_rangefrom_breaksrH   r{   rW  r    r    r!   test_additional_extension_types  s   

z2TestParquetPyArrow.test_additional_extension_typesc                 C   s>   t sd}nd}tdtjddddi}t||d|id	 d S )
Nz2.6z2.0r?   z
2017-01-011nr`  r   r>   versionr   )r   r1   r2   rH   r{   )r   r&   verrI   r    r    r!   test_timestamp_nanoseconds  s
   z-TestParquetPyArrow.test_timestamp_nanosecondsc                 C   sV   t s|jtjjkr|jtjj	dd d|g }t
j|d|id}t||dd d S )Nzitemporary skip this test until it is properly resolved: https://github.com/pandas-dev/pandas/issues/37286r      index_as_colr   r   F)rm   )r   tzinfora   timezoneutcr   r   r$   r   r   r1   r2   r{   )r   r   r&   rh   idxrI   r    r    r!   test_timezone_aware_index  s   
z,TestParquetPyArrow.test_timezone_aware_indexc                 C   s|   t d tdttddi}t }||| t	||dgdd}W d    n1 s/w   Y  t
|dks<J d S )	Nr   r?   r   r,   r?   r   r   F)r   use_legacy_datasetr*   )r$   r   r1   r2   rD   rE   ro   rz   r   r   r   )r   r&   rI   rv   r   r    r    r!   test_filter_row_groups  s   


z)TestParquetPyArrow.test_filter_row_groupsc                 C   s   t jtjddg dd}t }||| t	||}W d    n1 s*w   Y  |r>t
|jt jjjs<J d S t
|jt jjjsIJ d S )Nr+   )r`  r,   )r/   r0   Cr   )r1   r2   rF   r   r   r   ro   rz   r   r   r   _mgrcore	internalsArrayManagerBlockManager)r   r&   using_array_managerrI   rv   r   r    r    r!   test_read_parquet_manager  s   
z,TestParquetPyArrow.test_read_parquet_managerc                 C   s   dd l }|}tjdddd}|d }||d< g d|d< |j|}|jtjd	}trO|d
 	d|d
< |d 	d|d< |d 	t|j
ddd|d< t||ddi|d d S )Nr   r<   r,   rB  rC  rE  rF  rG  )types_mapperra   ztimestamp[us][pyarrow]rb   us)unitrD  r0  r   r"   rw   ru   )r   r1   rH   r   Tablefrom_pandas	to_pandas
ArrowDtyper
   rd   	timestampr{   )r   r&   rg   r   rI   rH  pa_tableru   r    r    r!   &test_read_dtype_backend_pyarrow_config  s,   

z9TestParquetPyArrow.test_read_dtype_backend_pyarrow_configc                 C   sn   t jdddgit jddgdddd	}| }d
d l}t|jtdkr+|jd|_t	||ddi|d d S )Nr?   r*   r+   r,   r5   testr   zint64[pyarrow])r   r:   r   z11.0.0r0  r   r  )
r1   r2   Indexr   r   r   r   r   rd   r{   )r   r&   rI   ru   r   r    r    r!   ,test_read_dtype_backend_pyarrow_config_index  s   
z?TestParquetPyArrow.test_read_dtype_backend_pyarrow_config_indexc                 C   s   t tdttddd}ddg|_t|| ddg|_tjtdd	 t|| W d    n1 s5w   Y  t		d
ddddt		d
ddddg|_t|| d S )Nr4   r*   r5   r   r   rM   rN   z|S3r     )
r1   r2   rD   rE   r   r{   r$   r   r[  ra   rW  r    r    r!   test_columns_dtypes_not_invalid-  s   


z2TestParquetPyArrow.test_columns_dtypes_not_invalidc                 C   s(   t jt jg dddd}t|| d S )Nr  custom namer  r
  r1   r2   r  r{   rW  r    r    r!   test_empty_columnsA  s   z%TestParquetPyArrow.test_empty_columnsc                 C   sR   |d }t jddgid}ddi|_|j||d t||d}|j|jks'J d S )Nztest_df_metadata.pr*   r   test_attributer   )r1   r2   attrsr   r   )r   r   r&   rv   rI   new_dfr    r    r!   test_df_attrs_persistenceF  s   
z,TestParquetPyArrow.test_df_attrs_persistencec                 C   s   |d }t jdddgiddgd}|j|dd t d	d
 t|dd}W d    n1 s/w   Y  t jdddgidt jddgddd}t|| d S )Nztest_string_inference.pr?   r  yr@   )r   r   r   r   future.infer_stringTstring[pyarrow_numpy]r9   )r   r:   r   )r1   r2   r   r   r   r  ro   rp   r   r   r&   rv   rI   r   ru   r    r    r!   test_string_inferenceN  s   
z(TestParquetPyArrow.test_string_inferenceznot supported before 11.0c                 C   st   dd l }|d }tjdtdgidd}|j||d|dfgd t|}tjdd	gid
d}t	|| d S )Nr   z	decimal.pr?   z123.00r  r9   r  )r   123zstring[python])
r   r1   r2   r   r   r   
decimal128r   ro   rp   r  r    r    r!   test_roundtrip_decimal\  s    z)TestParquetPyArrow.test_roundtrip_decimalc                 C   s   dd l }dd lm} |d }|d|g d| i}||| tdd t	|}W d    n1 s8w   Y  tj
dg didtjdgddd	}t|| d S )
Nr   zlarge_string.pr?   )Nr@   rK   r  Tr  r9   )r   r:   r   )r   r   r   r7  r   large_stringr8  r1   r   r   r2   r  ro   rp   )r   r   r&   r   rv   r7  r   ru   r    r    r!   #test_infer_string_large_string_typeh  s   

z6TestParquetPyArrow.test_infer_string_large_string_typeN)0r   r   r   rI  rJ  rR  rX  r\  r_  rd  r$   r   r   r   r?  strpathlibPathri  ro  r   ry  r}  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r@  r	   r  r  r    r    r    r!   rA    sj    

		

rA  c                   @   s   e Z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jdd Zdd Zdd Zdd Zdd Ze
jje dd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e
jje ddd-d. Zd/S )0TestParquetFastParquetc                 C   sF   |}t jdddd}|d }||d< t jddd|d< t|| d S )	Nr<   r,   z
US/EasternrC  rE  rY  r=   	timedelta)r1   rH   r   rZ  r{   )r   r(   rg   rI   rH  r    r    r!   rI    s   
z!TestParquetFastParquet.test_basicc                 C   s   t tdttddd}t}d}ddg|_| |||| ddg|_| |||| td	ddddtd	ddddg|_| |||| d S )
Nr4   r*   r5   r   r  r   rM   rN   r  )r1   r2   rD   rE   r  r   r   ra   )r   r(   rI   errr   r    r    r!   test_columns_dtypes_invalid  s   

z2TestParquetFastParquet.test_columns_dtypes_invalidc                 C   s<   t jtdddtdd }d}| ||t| d S )NrS  r5   r,   rT  r   z9Cannot create parquet dataset with duplicate column namesrU  r   r(   rI   r   r    r    r!   rX    s   $z-TestParquetFastParquet.test_duplicate_columnsc                 C   s@   t dg di}t jddtjdgidd}t|||dd d S )	Nr?   )TNFr+  g        rc  r9   F)ru   rm   )r1   r2   rF   rc   r{   r   r(   rI   ru   r    r    r!   test_bool_with_none  s   z*TestParquetFastParquet.test_bool_with_nonec                 C   sT   t dt jddddi}| ||td  t dg di}d}| ||t| d S )Nr?   2013Mr,   r  r]  z"Can't infer object conversion type)r1   r2   r  r   r   r  r    r    r!   r_    s
   z'TestParquetFastParquet.test_unsupportedc                 C   s&   t dt tdi}t|| d S )Nr?   r4   )r1   r2   rm  rD   r{   )r   r(   rI   r    r    r!   ro    s   z'TestParquetFastParquet.test_categoricalc                 C   sz   dt tddi}t|}t }|j||d dd t||dgd}W d    n1 s.w   Y  t|dks;J d S )Nr?   r   r,   r*   )ri   row_group_offsetsr  )r   )	rD   rE   r1   r2   ro   rz   r   r   r   )r   r(   rA   rI   rv   r   r    r    r!   r    s   

z-TestParquetFastParquet.test_filter_row_groupsc                 C   s*   t ||d|j dd|id |dd d S )Nr{  z/fastparquet.parquetrz  )ri   rz  rs  r|  )r   r3   ru  r(   rv  r    r    r!   r}    s   
z(TestParquetFastParquet.test_s3_roundtripc                 C   s\   ddg}|}|j |d|d d tj|sJ dd l}|t|dj}t|dks,J d S )Nr`   r\   r   r"   r   ri   r   Fr+   	r   rf  rv   existsr   ParquetFiler  catsr   r   r   r(   rg   r   rI   r   actual_partition_colsr    r    r!   r       z4TestParquetFastParquet.test_partition_cols_supportedc                 C   sX   d}|}|j |d|d d tj|sJ dd l}|t|dj}t|dks*J d S )Nr`   r   r  r   Fr*   r  r  r    r    r!   r    s   z1TestParquetFastParquet.test_partition_cols_stringc                 C   s\   ddg}|}|j |dd |d tj|sJ dd l}|t|dj}t|dks,J d S )Nr`   r\   r   )r"   ri   partition_onr   Fr+   r  r  r    r    r!   test_partition_on_supported  r  z2TestParquetFastParquet.test_partition_on_supportedc                 C   sX   ddg}|}d}t jt|d |j|dd ||d W d    d S 1 s%w   Y  d S )Nr`   r\   zYCannot use both partition_on and partition_cols. Use partition_cols for partitioning datar   r   )r"   ri   r  r   )r$   r   r   r   )r   r   r(   rg   r   rI   r   r    r    r!   3test_error_on_using_partition_cols_and_partition_on  s   "zJTestParquetFastParquet.test_error_on_using_partition_cols_and_partition_onzfastparquet writes into Indexr   c                 C   s"   t  }| }t|||d d S )Nr  )r1   r2   r   r{   r  r    r    r!   r    s   z+TestParquetFastParquet.test_empty_dataframec                 C   s>   d|g }t j|d|id}| }d|j_t|||d d S )Nr  r  r  r   r  )r1   r2   r   r   r   r{   )r   r(   rh   r  rI   ru   r    r    r!   r     s
   
z0TestParquetFastParquet.test_timezone_aware_indexc              
   C   s   t dddgi}t g}|| tjtdd$ tt	 t
|ddd W d    n1 s2w   Y  W d    n1 sAw   Y  tjtdd t
|dd	d
 W d    n1 s_w   Y  W d    d S W d    d S 1 sww   Y  d S )Nr?   r*   r+   z!not supported for the fastparquetr   r   T)r"   use_nullable_dtypesr   r/  )r1   r2   ro   rz   r   r$   r   r   rM  rL  r   )r   r(   rI   rv   r    r    r!   &test_use_nullable_dtypes_not_supported*  s   

"z=TestParquetFastParquet.test_use_nullable_dtypes_not_supportedc              	   C   s   t d7}t|d tjtdd t|dd W d    n1 s&w   Y  t|j	dd W d    d S 1 s?w   Y  d S )	Ntest.parquets   breakit r   r   r   F)
missing_ok)
ro   rz   r  r  write_bytesr$   r   	Exceptionr   unlink)r   rv   r    r    r!   $test_close_file_handle_on_read_error5  s   "z;TestParquetFastParquet.test_close_file_handle_on_read_errorc              	   C   s   t jddgddgdd}td*}t| d}|| W d    n1 s*w   Y  t||d}W d    n1 s?w   Y  t|| d S )Nr   r*   r.   r  r  wbr   )	r1   r2   ro   rz   r   encoder   r   rp   )r   r"   rI   rv   rC   r   r    r    r!   test_bytes_file_name=  s   z+TestParquetFastParquet.test_bytes_file_namec              	   C     t d tjddgddgdd}t '}t jtdd |j|ddd	 W d    n1 s1w   Y  W d    n1 s@w   Y  t 7}t	
|d
 t jtdd t|ddd	 W d    n1 skw   Y  W d    d S W d    d S 1 sw   Y  d S )Nr   r   r*   r.   r  zfilesystem is not implementedr   r-   r"   rq  rM   )r$   r   r1   r2   ro   rz   r   r[  r   r  r  r  r   r   rI   rv   r    r    r!   test_filesystem_notimplementedG  (   


"z5TestParquetFastParquet.test_filesystem_notimplementedc              	   C   r  )Nr   r   r*   r.   r  z1filesystem must be a pyarrow or fsspec FileSystemr   r-   r  rM   )r$   r   r1   r2   ro   rz   r   r   r   r  r  r  r   r  r    r    r!   test_invalid_filesystemW  r  z.TestParquetFastParquet.test_invalid_filesystemc              	   C   s(  t d}tjddgddgdd}t ,}t jtdd |j|d|	 d	d
id W d    n1 s6w   Y  W d    n1 sEw   Y  t <}t
|d t jtdd t|d|	 d	d
id W d    n1 suw   Y  W d    d S W d    d S 1 sw   Y  d S )Nz
pyarrow.fsr   r*   r.   r  z8storage_options not supported with a pyarrow FileSystem.r   r   r-   rP   )r"   rq  rz  rM   )r$   r   r1   r2   ro   rz   r   r[  r   LocalFileSystemr  r  r  r   )r   pa_fsrI   rv   r    r    r!   .test_unsupported_pa_filesystem_storage_optionsg  s@   


"zETestParquetFastParquet.test_unsupported_pa_filesystem_storage_optionsc              	   C   s   d}t dttddi}td3}|| tjt	|d t
|dd W d    n1 s1w   Y  W d    d S W d    d S 1 sIw   Y  d S )	NzPdtype_backend numpy is invalid, only 'numpy_nullable' and 'pyarrow' are allowed.r\   r*   r5   ztmp.parquetr   numpy)r0  )r1   r2   rD   rE   ro   rz   r   r$   r   r   r   )r   r"   r   rI   rv   r    r    r!   test_invalid_dtype_backend  s   
"z1TestParquetFastParquet.test_invalid_dtype_backendc                 C   sF   t jt jg dddd}t jt jg dddd}t|||d d S )Nr  r  r  r
  r  r  r  r    r    r!   r    s   z)TestParquetFastParquet.test_empty_columnsN)r   r   r   rI  r  rX  r  r_  ro  r  r$   r   r   r}  r  r  r  r  r@  r   r  r  r  r  r  r  r  r  r  r  r    r    r    r!   r    s6    	



	
r  )	NNNNNTFTr+   )H__doc__ra   decimalr   r   r   rf  r  r  rF   r$   pandas._configr   r   pandas.compatr   pandas.compat.pyarrowr   r   r	   r
   pandasr1   pandas._testing_testingro   pandas.util.versionr   pandas.io.parquetr   r   r   r   r   r   r#   r   r   r'   r   filterwarnings
pytestmarkfixturer   r@  r"   r&   r(   r3   rJ   rg   nowr  r  minmaxstrptimerh   r{   r   r   r   r   r   r   r   r   r   r   r   rA  r  r    r    r    r!   <module>   s    







B+  0   Y