o
    vh                     @   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 ddlmZ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'yu   dZ&Y nw zddl(Z(dZ)W n e'y   dZ)Y nw e
j*+de
j*+dgZ,e
j-e
j.de
j*j/e) peddddkdde
j*j0e dddgde
j.de
j*j/e& dddgddd Z1e
j-dd Z2e
j-dd  Z3e
j-d!d" Z4e
j-d#d$ Z5e
j-d%d& Z6e
j-ej7ej8j9ej7ej8j:ej7ej8j;ej<d'd(ej<d)d(ej<d*d(ej<d+d(gdd,d- Z=									.dMd/d0Z>d1d2 Z?d3d4 Z@d5d6 ZAd7d8 ZBd9d: ZCd;d< ZDd=d> ZEd?d@ ZFdAdB ZGdCdD ZHG dEdF dFZIG dGdH dHeIZJG dIdJ dJeIZKG dKdL dLeIZLdS )Nz test parquet compat     N)Decimal)BytesIO)using_copy_on_writeusing_string_dtype)_get_option)is_platform_windows)pa_version_under11p0pa_version_under13p0pa_version_under15p0pa_version_under19p0pa_version_under20p0)Version)FastParquetImplPyArrowImpl
get_engineread_parquet
to_parquetTFz2ignore:DataFrame._data is deprecated:FutureWarningz=ignore:Passing a BlockManager to DataFrame:DeprecationWarningfastparquetmode.data_managersilentarrayz4fastparquet is not installed or ArrayManager is usedreasonTODO(infer_string) fastparquetr   strictmarkspyarrowpyarrow is not installed)paramsc                 C      | j S Nparamrequest r(   Z/var/www/html/hyperkenya/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)   pa]   s   
r.   c                 C   sJ   t std ntddddkrtd t r#| tjjddd	 d
S )Nzfastparquet is not installedr   Tr   r   z.ArrayManager is not supported with fastparquetr   Fr   r   )_HAVE_FASTPARQUETr,   r-   r   r   applymarkermarkxfailr&   r(   r(   r)   fpd   s   
r3   c                   C   s"   t jg dddt ddgdS )N         fooABr:   r;   columns)pd	DataFrameIndexr(   r(   r(   r)   	df_compatq   s   "rA   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abcr5            @      @float64dtypeTFT20130101r7   periods)abdef)r>   r?   listrangenparange
date_range)dfr(   r(   r)   df_cross_compatv   s   rX   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 )NrB   rM   crM   NrY   )   foo   bars   bazr8   barbazr5   rC   r7      u1rD   rE   rF   rG          @      @rI   rJ   rK   20130103)stringstring_with_nanstring_with_nonebytesunicodeintuintfloatfloat_with_nanbooldatetimedatetime_with_nat)r>   r?   rR   rT   nanrS   rU   astyperV   	TimestampNaTr(   r(   r(   r)   df_full   s$   

ru   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   rv   r6   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 )Nrf   r5   rf   )check_names
check_likecheck_dtype)rS   r   r   loctmassert_frame_equal)repeat_actualr{   rz   ry   rW   expectedpathread_kwargswrite_kwargsr(   r)   compare   s   
z!check_round_trip.<locals>.compare)r}   ensure_clean)rW   r*   r   r   r   r   ry   rz   r{   r   r   r(   r   r)   check_round_trip   s   "

"r   c                 C   s0   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   Nhive)partitioning)pyarrow.datasetdatasetr   schemanames)r   r   dsr   r(   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'matchr8   r^   )r,   raises
ValueErrorr   )rA   msgr(   r(   r)   test_invalid_engine  s   "r   c                 C   sP   |rt s| jd| _tdd t|  W d    d S 1 s!w   Y  d S )Nstrio.parquet.enginer   )r   r=   rr   r>   option_contextr   )rA   r.   using_infer_stringr(   r(   r)   test_options_py  s
   
"r   c                 C   :   t dd t|  W d    d S 1 sw   Y  d S )Nr   r   r>   r   r   )rA   r3   r(   r(   r)   test_options_fp     
"r   c                 C   r   )Nr   autor   )rA   r3   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   r>   r   )r3   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_message2  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*   rw   r*   rM   rO   )r*   r=   r}   r   r   r   r~   rX   r.   r3   rW   r   resultr(   r(   r)   test_cross_engine_pa_fp]  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_pak  s   
"r   c              	   C   s   t dg di}d}t 0}tjt|ddd |||  W d    n1 s*w   Y  W d    d S W d    d S 1 sBw   Y  d S )NrM   r4   zqStarting with pandas version 3.0 all arguments of to_parquet except for the argument 'path' will be keyword-only.F)r   check_stacklevelraise_on_extra_warnings)r>   r?   r}   r   assert_produces_warningFutureWarningr   )r*   rW   r   r   r(   r(   r)   !test_parquet_pos_args_deprecationx  s   
"r   c                   @   s   e Zd Zdd Z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   rw   )r}   r   r,   r   r   )selfrW   r*   excerr_msgr   r(   r(   r)   check_error_on_write  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   )r}   r   external_error_raisedr   )r   rW   r*   r   r   r(   r(   r)   check_external_error_on_write  s   
"z"Base.check_external_error_on_writeN)__name__
__module____qualname__r   r   r(   r(   r(   r)   r     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dd  Zejd!g d"d#d$ Zejjejj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 )Nr4   r5   r8   rJ   z+to_parquet only supports IO with DataFrames)r>   Seriesrs   rT   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 )NrB   r5   rC   re   rj   r8   r^   r>   r?   rR   rS   r=   r   )r   r*   rW   r(   r(   r)   test_columns_dtypes  s   
zTestBasic.test_columns_dtypesrw   )Ngzipsnappybrotlic                 C   s(   t dg di}t||d|id d S )Nr:   r4   rw   r   r>   r?   r   )r   r*   rw   rW   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 )NrB   r5   rC   r   re   r=   r   r   r>   r?   rR   rS   r   )r   r*   rW   r   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 )NrC   aabb)rj   partrj   r   r5   partition_colsr   )r   ==rM   )filtersr=   )r   r   r   r   r   r   )r   r*   tmp_pathrW   r   r(   r(   r)   test_read_filters  s   

zTestBasic.test_read_filtersc                 C   s   |dk}t dg di}t|| g dt jdddtdg d	g}|D ]}||_t|t jr7|jd |_t|||d
 q%g d|_d|j_	t|| d S )Nr   r:   r4   )r6   r7   rC   rJ   r7   rK   rB   )r5   r7   rC   )ry   )r   r5   r6   r8   )
r>   r?   r   rV   rR   indexr   DatetimeIndex
_with_freqname)r   r*   ry   rW   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:   r4   )rM   r5   )rM   r6   )rN   r5   )r>   r?   
MultiIndexfrom_tuplesr   r   )r   r.   r*   rW   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)freqr6   r7   ABCr<   Level1Level2leveldate)r   r=   r:   r;   r   r   )r>   rV   r?   rT   randomdefault_rngstandard_normallenrR   r   from_productcopyr   r   )r   r.   r*   datesrW   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 )Nr4   )qrs)rM   rN   F)rw   r   T)dropr   r   )zyxwvutsrr   r^   r^   r_   r_   r8   r8   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  )r>   r?   reset_indexr   rR   rS   )r   r*   rW   r   r   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   r6   )rC   r7   r<   r   Column name must be a stringr   )r>   r   r   r?   rT   r   r   r   r   	TypeErrorr   )r   r*   
mi_columnsrW   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  )r5   r6   r5   r6   r5   r6   r5   r6   r6   r	  r	  r<   r   r   r   zColumn namer   )r>   r?   rT   r   r   r   r=   r   r   r   r   r   r*   r  rW   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  r6   r  r<   	ColLevel1	ColLevel2)	r>   r?   rT   r   r   r   r=   r   r   r   r.   r*   r  rW   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)r^   r_   r8   r  r6   r	  rC   r<   	StringCol)	r>   r?   rT   r   r   r   r=   r   r   r  r(   r(   r)   test_write_column_index_stringO  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r5   r6   r7   rC   r6   r  r<   NonStringColr   r  )r>   r?   rT   r   r   r   r=   r   r   r  r   r  r(   r(   r)   !test_write_column_index_nonstring]  s   z+TestBasic.test_write_column_index_nonstringc           
      C   s  t d}|dkrt jjdd}|| 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 slw   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 )Nzpyarrow.parquetr   z.Fastparquet nullable dtype support is disabledr   r5   r6   r7   Nint64uint8)rM   rN   rY   N)TFTNr  )      ?rb   rc   Nfloat32rF   )rM   rN   rY   rO   rP   rQ   gr   numpy_nullabler*   dtype_backendrM   Int64rG   UInt8re   booleanFloat32Float64rY   r5   )axis)r,   importorskipr1   r2   r0   r   tabler   r}   r   write_tabler   rH   rT   r>   r?   r   r~   )
r   r*   r'   pqr1   r1  r   result1result2r   r(   r(   r)   test_dtype_backendm  sH   


zTestBasic.test_dtype_backendrH   )	r*  r+  r,  objectzdatetime64[ns, UTC]rl   z	period[D]r.  re   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valuerG   rl   r.  r)  r'  r   )r>   r?   r   r   )r   r.   rH   rW   r   r(   r(   r)   test_read_empty_array  s   
zTestBasic.test_read_empty_arrayc                 C   sv   |dkr	t | t|dddddd}|j| d t|j|d	}W d    n1 s.w   Y  t|| d S )
Nr   iodataparquetzsimple.parquetrb)mode)contentr   )	r,   r0  openserve_contentreadr   urlr}   r~   )r   
httpserverdatapathrA   r*   rQ   rW   r(   r(   r)   test_parquet_read_from_url  s   
z$TestBasic.test_parquet_read_from_urlN)r   r   r   r   r   r,   r1   parametrizer   r   r   r   r   r   r  r  r  r  r  r   r6  r9  network
single_cpurF  r(   r(   r(   r)   r     s2    
		 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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d0d1 Z d2d3 Z!d4d5 Z"d6d7 Z#d8d9 Z$d:d; Z%d<d= Z&d>d? Z'd@dA Z(dBdC Z)e
jdDdEdFge
j*dGdHge
jje+e,dIdJdKe--dLdFdFdEdEe--dLdFdFdFdFggdMdN Z.dOdP Z/dQdR Z0dSdT Z1e
jje2dUddVdW Z3dXdY Z4dZS )[TestParquetPyArrowc                 C   s@   |}t jdddd}|d }||d< g d|d< t|| d S )NrJ   r7   Europe/BrusselsrL   tzdatetime_tzTNTbool_with_none)r>   rV   r   r   )r   r.   ru   rW   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 )
NrJ   r7   rK  rL  rN  re   rj   r=   r   )r>   rV   r   )r   r.   ru   rW   r(   r(   r)   test_basic_subset_columns  s   


z,TestParquetPyArrow.test_basic_subset_columnsc                 C   sL   |j |d}t|tsJ t|}t|}| }d |jd< t|| d S )Nr   rx   )	r   r   rh   r   r   r   r|   r}   r~   )r   r.   ru   	buf_bytes
buf_streamresr   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   rC   r7   aaar<   zDuplicate column names found	r>   r?   rT   rU   reshaperR   r   r   r   r   r.   rW   r(   r(   r)   test_duplicate_columns  s   $z)TestParquetPyArrow.test_duplicate_columnsc                 C   s&   t dt jdddi}t|| d S )NrM   1 dayr7   rK   )r>   r?   timedelta_ranger   r\  r(   r(   r)   test_timedelta     z!TestParquetPyArrow.test_timedeltac                 C   s&   t dg di}| ||tj d S )NrM   rM   r5   rb   )r>   r?   r   r   ArrowExceptionr\  r(   r(   r)   test_unsupported  s   z#TestParquetPyArrow.test_unsupportedc                 C   sH   t jddt jd}tj|dgd}tr| ||tj d S t	|| d S )Nr6   
   rG   fp16r;  r=   )
rT   rU   float16r>   r?   r
   r   r   rc  r   )r   r.   r;  rW   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   zfloat16 works on 15	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 )Nr6   re  rG   rf  rg  )r   r*   )rT   rU   rh  r>   r?   r}   r   r   r   rc  r   osr   isfile)r   r.   rj  r;  rW   path_strr   r(   r(   r)    test_unsupported_float16_cleanup
  s   
"z3TestParquetPyArrow.test_unsupported_float16_cleanupc              	   C   sV   t t tdt jg dt g ddt jg dg dddd	}t|| d S )
Nabcdef)r^   r8   r8   r^   Nr^   r]   rG   )rM   rN   rY   rM   rY   rN   )rN   rY   rO   T)
categoriesorderedrM   rN   rY   )r>   r?   CategoricalrR   CategoricalDtyper   r\  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r   r   r   r(   )r,   r0  S3FileSystemr   r   )r   rA   s3_public_bucketr.   s3sorv  s3kwr(   r(   r)   test_s3_roundtrip_explicit_fs5  s   


z0TestParquetPyArrow.test_s3_roundtrip_explicit_fsc                 C   s(   d|i}t ||d|j d||d d S )Nstorage_optionss3://rx  ry  r   r   )r   rA   r{  r.   r|  r(   r(   r)   test_s3_roundtripB  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 )
Nrv  categoryr  z/parquet_dirr  )r   rw   r  Tr5   )r   r   r   r   rz   r   )
r,   r0  r   rr   dictfromkeysrT   int32r   r   )r   rA   r{  r.   r  r|  expected_dfpartition_col_typer(   r(   r)   test_s3_roundtrip_for_dirN  s*   

z,TestParquetPyArrow.test_s3_roundtrip_for_dirc                 C   sH   t d t }|| t|}|rts|jd|_t	|| d S )Nr   r   )
r,   r0  r   r   r   r   r=   rr   r}   r~   )r   rA   r   bufferdf_from_bufr(   r(   r)   test_read_file_like_obj_supportu  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,   r0  setenvr   OSErrorr   r   )r   rA   monkeypatchr(   r(   r)   test_expand_user~  s   

"z#TestParquetPyArrow.test_expand_userc                 C   s>   ddg}|}|j ||d d t|| t|j|jksJ d S )Nrn   rj   r   rw   r   r   r   shape)r   r   r.   ru   r   rW   r(   r(   r)   test_partition_cols_supported  s
   
z0TestParquetPyArrow.test_partition_cols_supportedc                 C   s@   d}|g}|}|j ||d d t|| t|j|jksJ d S )Nrn   r  r  )r   r   r.   ru   r   partition_cols_listrW   r(   r(   r)   test_partition_cols_string  s   
z-TestParquetPyArrow.test_partition_cols_stringc                 C   s   | S r#   r(   )xr(   r(   r)   <lambda>  s    zTestParquetPyArrow.<lambda>re   zpathlib.Path)idsc           	      C   s<   d}|g}|}||}|j ||d t|j|jksJ d S )Nr;   )r   )r   r   r  )	r   r   r.   rA   rj  r   r  rW   r   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   r\  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  r5   )typer   r   )	r   r>   r?   r   fieldbool_rr   rn   r   )r   r.   r   rW   r   out_dfr(   r(   r)   test_write_with_schema  s
   
z)TestParquetPyArrow.test_write_with_schemac                 C   s   t d ttjg dddtjg dddtjg dddd}|r4tr4t|||d	d
id nt|| tdtjg dddi}t|| d S )Nr   r4   r*  rG   UInt32rZ   re   rr  rY   r   r   rM   r!  )r,   r0  r>   r?   r   r   r   rr   )r   r.   r   rW   r(   r(   r)    test_additional_extension_arrays  s   

z3TestParquetPyArrow.test_additional_extension_arraysc                 C   s   t d tdtjg dddi}td|4 |r5tr$|d}n	|d| d	}|jd|_n	|d| d	}t	|||d
 W d    d S 1 sPw   Y  d S )Nr   rM   rZ   string[pyarrow]rG   string_storager   zstring[]r  )
r,   r0  r>   r?   r   r   r   rr   r=   r   )r   r.   r  r   rW   r   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   r5   )r5   r6   )r7   rC   z
2012-01-01r7   D)rL   r   rC   )rY   rO   rP   )
r,   r0  r>   r?   IntervalIndexr   period_rangefrom_breaksrV   r   r\  r(   r(   r)   test_additional_extension_types  s   

z2TestParquetPyArrow.test_additional_extension_typesc                 C   s4   d}t dt jddddi}t||d|id d S )	Nz2.6rM   z
2017-01-011nsre  r   rL   versionr   )r>   r?   rV   r   )r   r.   verrW   r(   r(   r)   test_timestamp_nanoseconds  s   z-TestParquetPyArrow.test_timestamp_nanosecondsc           	      C   s   t dd d|g }tj|d|id}|d d  }tr#|jd|_|jtj	j
kr[zdd l}W n	 ty9   Y n"w |jj|}|| d }|j||_|d j||d< t||d	|d
 d S )Nr   11.0.0   index_as_colr   r;  nsr   <   F)r{   r   )r,   r0  r>   r?   r   r   as_unittzinforo   timezoneutcpytzr   rM  	utcoffsetFixedOffsettotal_seconds
tz_convertdtr   )	r   r.   rv   idxrW   r   r  offsetrM  r(   r(   r)   test_timezone_aware_index  s"   
z,TestParquetPyArrow.test_timezone_aware_indexc                 C   sz   t d tdttdi}t }|j||d t	||dgd}W d    n1 s.w   Y  t
|dks;J d S )Nr   rM   r7   r   rM   r   r   r   r5   )r,   r0  r>   r?   rR   rS   r}   r   r   r   r   )r   r.   rW   r   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 }|j||d 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sJJ d S )Nr6   )re  r7   )r:   r;   Cr<   r   )r>   r?   rT   r   r   r   r}   r   r   r   r   _mgrcore	internalsArrayManagerBlockManager)r   r.   using_array_managerrW   r   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   rJ   r7   rK  rL  rN  rO  rP  )types_mapperro   ztimestamp[us][pyarrow]rp   us)unitrM  r)  r   r*   r   r   )r   r>   rV   r   Tablefrom_pandas	to_pandas
ArrowDtyper	   rr   	timestampr   )r   r.   ru   r   rW   rQ  pa_tabler   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 )NrM   r5   r6   r7   rC   testr   zint64[pyarrow])r   rH   r   r  r)  r   r  )
r>   r?   r@   r   r   r   r   r   rr   r   )r   r.   rW   r   r   r(   r(   r)   ,test_read_dtype_backend_pyarrow_config_indexC  s   
z?TestParquetPyArrow.test_read_dtype_backend_pyarrow_config_indexr=   r   r5   r[   r\   z*https://github.com/apache/arrow/pull/44171)r   r   r     c                 C   s2   t tdttddd}||_t|| d S )NrB   r5   rC   r   r   )r   r.   r=   rW   r(   r(   r)   test_columns_dtypes_not_invalidS  s   z2TestParquetPyArrow.test_columns_dtypes_not_invalidc                 C   s(   t jt jg dddd}t|| d S )Nrr  custom namer  r  r>   r?   r@   r   r\  r(   r(   r)   test_empty_columnsk  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.pr5   r;  test_attributer   )r>   r?   attrsr   r   )r   r   r.   r   rW   new_dfr(   r(   r)   test_df_attrs_persistencep  s   
z,TestParquetPyArrow.test_df_attrs_persistencec           	      C   s   |d }t jdddgiddgd}|j||d t dd	 t||d}W d    n1 s/w   Y  t jtjd
}t jdddgi|t jddg|dt jdgt	rU|sUt
n|dd}t|| d S )Nztest_string_inference.prM   r  yrN   )r;  r   r   future.infer_stringTna_valuerG   )r;  rH   r   r=   )r>   r?   r   r   r   StringDtyperT   rq   r@   r   r7  r}   r~   )	r   r   r.   r   r   rW   r   rH   r   r(   r(   r)   test_string_inferencex  s*   
z(TestParquetPyArrow.test_string_inferenceznot supported before 11.0c                 C   s   dd l }|d }tjdtdgidd}|j||d|dfgd t|}tr5tjdd	gid
d}ntjdtdgidd}t	
|| d S )Nr   z	decimal.prM   z123.00r  rG   r  )r   123zstring[python]r7  )r   r>   r?   r   r   r   
decimal128r   r   r}   r~   )r   r   r.   r   rW   r   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tjtjdtjdgtjtjddd	}t|| d S )
Nr   zlarge_string.prM   )NrN   rY   r  Tr  rG   )r;  rH   r=   )r   pyarrow.parquetr<  r1  r   large_stringr2  r>   r   r   r?   r  rT   rq   r@   r}   r~   )r   r   r.   r3  r   r1  r   r   r(   r(   r)   #test_infer_string_large_string_type  s   

z6TestParquetPyArrow.test_infer_string_large_string_typeN)5r   r   r   rR  rS  rW  r]  r`  rd  ri  r,   r1   r2   r   skipifr
   rG  r   pathlibPathrn  ru  rI  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r%   r   NotImplementedErrorro   r  r  r  r  r   r  r  r(   r(   r(   r)   rJ    s    


			
!		

rJ  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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 )	NrJ   r7   z
US/EasternrL  rN  r^  rK   	timedelta)r>   rV   r   r_  r   )r   r3   ru   rW   rQ  r(   r(   r)   rR    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 )
NrB   r5   rC   r   r  r   r[   r\   r  )r>   r?   rR   rS   r  r=   r   ro   )r   r3   rW   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 )NrX  rC   r7   rY  r<   z9Cannot create parquet dataset with duplicate column namesrZ  r   r3   rW   r   r(   r(   r)   r]    s   $z-TestParquetFastParquet.test_duplicate_columnsc                 C   s   dd l }t|jtdk r ttjtdkr |tjjdd t	dg di}tj	ddtj
d	gid
d}t|||dd d S )Nr   	2024.11.0z2.0.0z$fastparquet uses np.float_ in numpy2r   rM   )TNFr$  g        rh  rG   F)r   r{   )r   r   r   rT   r0   r,   r1   r2   r>   r?   rq   r   )r   r3   r'   r   rW   r   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 )NrM   2013Mr7   r  rb  z"Can't infer object conversion type)r>   r?   r  r   r   r  r(   r(   r)   rd    s
   z'TestParquetFastParquet.test_unsupportedc                 C   s&   t dt tdi}t|| d S )NrM   rB   )r>   r?   rs  rR   r   )r   r3   rW   r(   r(   r)   ru    ra  z'TestParquetFastParquet.test_categoricalc                 C   sx   dt t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 )NrM   r7   r5   )r*   rw   row_group_offsetsr  r  )	rR   rS   r>   r?   r}   r   r   r   r   )r   r3   rO   rW   r   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.parquetr  )rw   r  ry  r  )r   rA   r{  r3   r|  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 )Nrn   rj   r   r*   r   rw   r   Fr6   	r   rk  r   existsr   ParquetFiler   catsr   r   r   r3   ru   r   rW   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 )Nrn   r   r  r   Fr5   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 )Nrn   rj   r   )r*   rw   partition_onr   Fr6   r  r  r(   r(   r)   test_partition_on_supported4  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 )Nrn   rj   zYCannot use both partition_on and partition_cols. Use partition_cols for partitioning datar   r   )r*   rw   r  r   )r,   r   r   r   )r   r   r3   ru   r   rW   r   r(   r(   r)   3test_error_on_using_partition_cols_and_partition_onD  s   "zJTestParquetFastParquet.test_error_on_using_partition_cols_and_partition_onzfastparquet writes into Indexr   c                 C   s"   t  }| }t|||d d S )Nr  )r>   r?   r   r   r   r3   rW   r   r(   r(   r)   r  W  s   z+TestParquetFastParquet.test_empty_dataframec                 C   s~   dd l }t|jtdkr t|jtdk r |tjjdd d|g }tj|d|id}|	 }d	|j
_t|||d
 d S )Nr   z2022.12r  zCfastparquet bug, see https://github.com/dask/fastparquet/issues/929r   r  r  r  r   r  )r   r   r   r0   r,   r1   r2   r>   r?   r   r   r   r   )r   r3   rv   r'   r   r  rW   r   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 )NrM   r5   r6   z!not supported for the fastparquetr   r   T)r*   use_nullable_dtypesr   r(  )r>   r?   r}   r   r   r,   r   r   r   r   r   )r   r3   rW   r   r(   r(   r)   &test_use_nullable_dtypes_not_supportedu  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)
r}   r   r  r  write_bytesr,   r   	Exceptionr   unlink)r   r   r(   r(   r)   $test_close_file_handle_on_read_error  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   r5   r9   r  r  wbr   )	r>   r?   r}   r   r@  encoder   r   r~   )r   r*   rW   r   rQ   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   r5   r9   r  zfilesystem is not implementedr   r8   r*   rw  r[   )r,   r0  r>   r?   r}   r   r   r  r   r  r  r  r   r   rW   r   r(   r(   r)   test_filesystem_notimplemented  (   


"z5TestParquetFastParquet.test_filesystem_notimplementedc              	   C   r  )Nr   r   r5   r9   r  z1filesystem must be a pyarrow or fsspec FileSystemr   r8   r   r[   )r,   r0  r>   r?   r}   r   r   r   r   r  r  r  r   r!  r(   r(   r)   test_invalid_filesystem  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   r5   r9   r  z8storage_options not supported with a pyarrow FileSystem.r   r   r8   r^   )r*   rw  r  r[   )r,   r0  r>   r?   r}   r   r   r  r   LocalFileSystemr  r  r  r   )r   pa_fsrW   r   r(   r(   r)   .test_unsupported_pa_filesystem_storage_options  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.rj   r5   rC   ztmp.parquetr   numpy)r)  )r>   r?   rR   rS   r}   r   r   r,   r   r   r   )r   r*   r   rW   r   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 )Nrr  r  r  r  r  r  r  r(   r(   r)   r    s   z)TestParquetFastParquet.test_empty_columnsN)r   r   r   rR  r   r]  r  rd  ru  r  r,   r1   rI  r  r  r  r  r  r  r   r  r  r  r  r  r"  r$  r'  r)  r  r(   r(   r(   r)   r    s4    	



r  )	NNNNNTFTr6   )M__doc__ro   decimalr   r:  r   rk  r  r(  rT   r,   pandas._configr   r   pandas._config.configr   pandas.compatr   pandas.compat.pyarrowr   r	   r
   r   r   pandasr>   pandas._testing_testingr}   pandas.util.versionr   pandas.io.parquetr   r   r   r   r   r   r+   r   r   r/   r1   filterwarnings
pytestmarkfixturer%   r  r2   r*   r.   r3   rA   rX   ru   nowr  r  minmaxstrptimerv   r   r   r   r   r   r   r   r   r   r   r   r   r   rJ  r  r(   r(   r(   r)   <module>   s    
	







B	+  5   u