U
    sVcV                     @   s  d Z ddlZddlZddlmZ ddlmZmZmZ ddl	Z	ddl
Z
ddlm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 ddlm  mZ G dd dZeeegZzdd	l m!Z" e#e" W n e$k
r   Y nX e
j%&e
j%'e(Z)ej*+d
G dd dZ,ej-dd Z.G dd dZ/dd Z0ej*1dddgej*1dddgdd Z2dd Z3ej*1deddfedd fgd!d" Z4ej*1d#dd$d%gej*1dddgd&d' Z5d(d) Z6d*d+ Z7d,d- Z8d.d/ Z9dS )0z0
Tests for the pandas.io.common functionalities
    N)partial)BytesIOStringIOUnsupportedOperation)Path)is_platform_windowsc                   @   s&   e Zd ZdZddddZdd ZdS )CustomFSPathz%For testing fspath on unknown objectsN)returnc                 C   s
   || _ d S Npath)selfr    r   ?/tmp/pip-unpacked-wheel-xj8nt62q/pandas/tests/io/test_common.py__init__   s    zCustomFSPath.__init__c                 C   s   | j S r
   r   r   r   r   r   
__fspath__"   s    zCustomFSPath.__fspath__)__name__
__module____qualname____doc__r   r   r   r   r   r   r      s   r   )localz*ignore:can't resolve package:ImportWarningc                   @   sV  e Zd ZdZdd Zdd Zdd Zedd	d
 Z	dd Z
dd Zejdedd Zejdeeegdd Zdd Zdd Zejddddd Zdd Zejdejd ed!fejd ed"fejd#ed$fejded%fej d&ed'fej!d ed(fej"d ed)fej#d ed*fej$d ed+fg	d,d- Z%ejd.ej&j'd ed!fej&j(d ed/fej&j)d#ed$fej&j*ded%fej&j+ded0fej&j,d ed(fej&j-d ed*fej&j.d ed+fgd1d2 Z/ejdejd ed!fej0d ed!fejd ed"fejd#ed$fejded%fej d&ed'fej!d ed(fej"d ed)fej#d ed*fej$d ed+fg
d3d4 Z1ejd5ejd d6fej0d d6fejd d7fejd#d8fejdd9fej d&d:fej!d d;fej"d d<fej#d d=fej$d d>fg
ej2d?ej2d@dAdB Z3ej2dCejdDdEi d fdFdGdHidHfdIi dfdJi d fdKi d fdLi d fdMi d fdNdOe4dPid fgdQdR Z5ej2d@dSdT Z6dUS )VTestCommonIOCapabilitiesziindex,A,B,C,D
foo,2,3,4,5
bar,7,8,9,10
baz,12,13,14,15
qux,12,13,14,15
foo2,12,13,14,15
bar2,12,13,14,15
c                 C   sB   d}t |}||ksttj|s*ttj||ks>td S )Nz
~/sometest)icom_expand_userAssertionErrorosr   isabs
expanduserr   filenameZexpanded_namer   r   r   test_expand_user?   s
    
z)TestCommonIOCapabilities.test_expand_userc                 C   s2   d}t |}||ksttj||ks.td S )Nz/somefolder/sometest)r   r   r   r   r   r   r   r   r   r   test_expand_user_normal_pathG   s    
z5TestCommonIOCapabilities.test_expand_user_normal_pathc                 C   sB   t td}|dkstt td}|tjddks>td S )N.zfoo//barfoobar)r   stringify_pathr   r   r   r   join)r   rel_pathZredundant_pathr   r   r   test_stringify_path_pathlibN   s    z4TestCommonIOCapabilities.test_stringify_path_pathlibzpy.pathc                 C   s8   t jdd}t j|}t|}t||ks4td S )Nr$   r%   )r   r   r'   abspath	LocalPathr   r&   r   )r   r   abs_pathZlpathr   r   r   test_stringify_path_localpathT   s    z6TestCommonIOCapabilities.test_stringify_path_localpathc                 C   s"   t d}t|}|dkstd S )Nfoo/bar.csv)r   r   r&   r   )r   presultr   r   r   test_stringify_path_fspath[   s    
z3TestCommonIOCapabilities.test_stringify_path_fspathc              
   C   sT   t d}t 8}|jd| dd}|t|ks<tW 5 Q R X W 5 Q R X d S )Nfsspeczfile://wbmode)pytestimportorskiptmensure_cleanopenr   r&   r   )r   r2   r   Z
fsspec_objr   r   r   !test_stringify_file_and_path_like`   s    

z:TestCommonIOCapabilities.test_stringify_file_and_path_like	path_typec                 C   s2   |\}}|d| }t j|dd}||ks.td S )Nr.   Zinfer)compression)r   Zinfer_compressionr   )r   Zcompression_formatr<   	extensionexpectedr   r=   r   r   r    test_infer_compression_from_pathg   s    z9TestCommonIOCapabilities.test_infer_compression_from_pathc              
   C   sz   t jt d`}|dt|j d }t|d2}t|jj sJt	t
j||jjksbt	W 5 Q R X W 5 Q R X d S )N)dirz~/z	/sometestw)tempfileTemporaryDirectoryr   homenamer   
get_handlehandleis_absoluter   r   r   r   )r   r<   tmpr    handlesr   r   r   test_get_handle_with_pathn   s
    z2TestCommonIOCapabilities.test_get_handle_with_pathc              	   C   sB   t  }t|d}|j|ks"tW 5 Q R X |jr6t|  d S )Nr)r   r   rG   rH   r   closedclose)r   Zinput_bufferrK   r   r   r   test_get_handle_with_bufferw   s
    
z4TestCommonIOCapabilities.test_get_handle_with_bufferc              	   C   s   d}t jt|dddr}d}d}|j|}t||ks>tt||k rjt|j dks`t||7 }qt||7 }q"||dkstW 5 Q R X d S )	N&   a,b,c
1,2,3
©,®,®
Look,a snake,🐍rbFis_text       r   utf-8)r   rG   r   rH   readlenr   encode)r   datarK   r0   	chunksizechunkr   r   r   )test_bytesiowrapper_returns_correct_bytes   s    
zBTestCommonIOCapabilities.test_bytesiowrapper_returns_correct_bytespyarrowz0.15.0)min_versionc              	   C   s   ddl m} d}tdddgddd	gd
ddgd}t|}tj|ddd,}||j	 }t
|| |jrttW 5 Q R X d S )Nr   )csvrQ   1   ©ZLook2   ®za snake3u   🐍abcrR   FrS   )r_   ra   pd	DataFramer   r   rG   read_csvrH   Z	to_pandasr8   assert_frame_equalrN   r   )r   ra   r[   r?   srK   dfr   r   r   test_get_handle_pyarrow_compat   s    z7TestCommonIOCapabilities.test_get_handle_pyarrow_compatc              	   C   s   t jt| jdd}t j|dd}W 5 Q R X t t| j}t|| t jt| jdd>}t|}t||jdg  tt ||jdd   W 5 Q R X d S )N   )r\   T)Zignore_indexr   )	rk   rm   r   data1concatr8   rn   nextZiloc)r   readerr0   r?   itfirstr   r   r   test_iterator   s    z&TestCommonIOCapabilities.test_iteratorz#reader, module, error_class, fn_extr   ra   txtZxlrdZxlsxfeathertablesh5ZdtaZsas7bdatjsonpicklec                 C   s   t | tjtdd| }d| d}d| d}d}d}	d	| d
| d}
d| d}d| d}d| }t j|d| d| d| d|	 d|
 d| d| d| dd || W 5 Q R X d S )Nr[   does_not_exist.File (b')?.+does_not_exist\.'? does not exist:\[Errno 2\] No such file or directory: '.+does_not_exist\.'zExpected object or value7path_or_buf needs to be a string file path or file-like#\[Errno 2\] File .+does_not_exist\.$ does not exist: '.+does_not_exist\.<   \[Errno 2\] 没有那个文件或目录: '.+does_not_exist\.?\[Errno 2\] File o directory non esistente: '.+does_not_exist\.+Failed to open local file.+does_not_exist\.(|)match)r6   r7   r   r   r'   HEREraises)r   rv   moduleerror_classfn_extr   msg1msg2msg3msg4msg5msg6msg7msg8r   r   r   test_read_non_existent   s"    


4z/TestCommonIOCapabilities.test_read_non_existentz#method, module, error_class, fn_exthtmlZparquetc              	   C   sl   t | tdddgdddgdddgd}tjtddd	| }t j|d
d ||| W 5 Q R X d S )Nrr            rV   rg   r[   Zmissing_folderr   z@Cannot save file into a non-existent directory: .*missing_folderr   )	r6   r7   rk   rl   r   r   r'   r   r   )r   methodr   r   r   Zdummy_framer   r   r   r   #test_write_missing_parent_directory   s    
$z<TestCommonIOCapabilities.test_write_missing_parent_directoryc                 C   s   t | tjdd| }|tddd  d| d}d| d	}d
}	d}
d| d| d	}d| d	}d| d	}d| }t j|d| d| d|	 d|
 d| d| d| d| dd || W 5 Q R X d S )N~r   r   c                 S   s   t jd| S )Nr$   )r   r   r'   )xr   r   r   <lambda>
  rU   zJTestCommonIOCapabilities.test_read_expands_user_home_dir.<locals>.<lambda>r   r   r   r   z0Unexpected character found when decoding 'false'r   r   r   r   r   r   r   r   r   r   )r6   r7   r   r   r'   setattrr   r   )r   rv   r   r   r   Zmonkeypatchr   r   r   r   r   r   r   r   r   r   r   r   test_read_expands_user_home_dir   s$    


4z8TestCommonIOCapabilities.test_read_expands_user_home_dirzreader, module, path)ior[   ra   ziris.csv)r   r[   Zfixed_widthzfixed_width_format.txt)r   r[   excelz
test1.xlsx)r   r[   r{   zfeather-0_3_1.feather)r   r[   Z
legacy_hdfzdatetimetz_object.h5)r   r[   Zstatazstata10_115.dta)r   Zsasr[   ztest1.sas7bdat)r   r~   r[   ztsframe_v012.json)r   r[   r   zcategorical.0.25.0.picklez8ignore:CategoricalBlock is deprecated:DeprecationWarningz;ignore:`np.object` is a deprecated alias:DeprecationWarningc                 C   sR   t | || }t|}||}||}|drBt|| nt|| d S )Nz.pickle)r6   r7   r   endswithr8   Zassert_categorical_equalrn   )r   rv   r   r   datapathmypathr0   r?   r   r   r   test_read_fspath_all   s    &

z-TestCommonIOCapabilities.test_read_fspath_allz.ignore:In future versions `DataFrame.to_latex`z"writer_name, writer_kwargs, moduleto_csvto_excelengineZxlwt
to_featherto_htmlto_jsonZto_latex	to_pickleto_stataZ
time_stampz2019-01-01 00:00c                 C   s   t d}t d}tdddgi}|}|}t| t|}	t||}
|
|f| t|d}|	 }W 5 Q R X |
|	f| t|d}|	 }W 5 Q R X ||kst
W 5 Q R X W 5 Q R X d S )NstringfspathArr   r   rR   )r8   r9   rk   rl   r6   r7   r   getattrr:   rX   r   )r   Zwriter_nameZwriter_kwargsr   p1p2rp   r   r   r   writerfr?   r0   r   r   r   test_write_fspath_allS  s    



z.TestCommonIOCapabilities.test_write_fspath_allc           	   
   C   s   t d tdddgi}td}td}|V}|F}t|}|j|dd |j|dd tj|dd}tj|dd}W 5 Q R X W 5 Q R X t	|| d S )	Nr|   r   rr   r   r   r   r%   )key)
r6   r7   rk   rl   r8   r9   r   Zto_hdfread_hdfrn   )	r   rp   r   r   r   r   r   r0   r?   r   r   r   test_write_fspath_hdf5u  s    


"z/TestCommonIOCapabilities.test_write_fspath_hdf5N)7r   r   r   rs   r!   r"   r)   tdZ
skip_if_nor-   r1   r;   r6   markparametrize
path_typesr@   strr   r   rL   rP   r^   rq   ry   rk   rm   FileNotFoundErrorZread_fwfZ
read_excelZread_featherOSErrorr   Z
read_stataZread_sas	read_jsonZread_pickler   rl   r   r   r   r   Z
to_parquetr   r   r   r   Z
read_tabler   filterwarningsr   Zto_datetimer   r   r   r   r   r   r   4   s   	













r   c                 C   s   | ddddS )Nr   r[   ra   ztest_mmap.csvr   )r   r   r   r   	mmap_file  s    r   c                   @   sX   e Zd Zdd Zdd Zdd Zdd Zej	d	d
dgej	dddgdd Z
dS )TestMMapWrapperc              	   C   s   t d}dd |_t r"d}t}n
d}tj}tj||d t	|d W 5 Q R X t
|}W 5 Q R X d}tjt|d t	|d W 5 Q R X d S )	NzI am not a filec                   S   s   dS )Nr   r   r   r   r   r     rU   z;TestMMapWrapper.test_constructor_bad_file.<locals>.<lambda>zThe parameter is incorrectz
[Errno 22]r   TzI/O operation on closed file)r   filenor   r   mmaperrorr6   r   r   Z_maybe_memory_mapr:   
ValueError)r   r   Znon_filemsgerrtargetr   r   r   test_constructor_bad_file  s    


z)TestMMapWrapper.test_constructor_bad_filec                 C   s   t |}| }tj|ddddh}|j}t|jjtjs@t|D ] }t	|}|
 |
 ksDtqDtjtdd t	| W 5 Q R X W 5 Q R X W 5 Q R X d S )NrM   T)rT   
memory_mapz^$r   )r:   	readlinesr   rG   rH   
isinstancebufferr   r   ru   stripr6   r   StopIteration)r   r   r   lineswrapperswrapperlineZ	next_liner   r   r   	test_next  s     
   zTestMMapWrapper.test_nextc              
   C   sR   t  @}t  }|| tjtdd tj|dd W 5 Q R X W 5 Q R X d S )NzUnknown enginer   Zpyt)r   )	r8   r9   makeDataFramer   r6   r   r   rk   rm   r   r   rp   r   r   r   test_unknown_engine  s
    

z#TestMMapWrapper.test_unknown_enginec              	   C   sD   t  2}t  }|j|dd t |tj|dd W 5 Q R X dS )z\
        'encoding' shouldn't be passed to 'open' in binary mode.

        GH 35058
        zw+br4   r   Z	index_colN)r8   r9   r   r   rn   rk   rm   r   r   r   r   test_binary_mode  s    
z TestMMapWrapper.test_binary_modeencodingzutf-16zutf-32compression_bz2xzc              
   C   st   t  }t  Z}t t |j|||d W 5 Q R X d}tjt|d t	j
|||d W 5 Q R X W 5 Q R X dS )z
        bz2 and xz do not write the byte order mark (BOM) for utf-16/32.

        https://stackoverflow.com/questions/55171439

        GH 35681
        )r=   r   z&UTF-\d+ stream does not start with BOMr   N)r8   r   r9   Zassert_produces_warningUnicodeWarningr   r6   r   UnicodeErrorrk   rm   )r   r   r   rp   r   r   r   r   r   test_warning_missing_utf_bom  s    

z,TestMMapWrapper.test_warning_missing_utf_bomN)r   r   r   r   r   r   r   r6   r   r   r   r   r   r   r   r     s   r   c                   C   s   t dstt dstt dr*tt dr8tt drFtt drTtt drbtt drptt d	s~td S )
Nzgcs://pandas/somethingelse.comzgs://pandas/somethingelse.comzhttp://pandas/somethingelse.comzrandom:pandas/somethingelse.comz/local/pathzrelative/local/pathzthis is not fsspec://urlz({'url': 'gs://pandas/somethingelse.com'}z#RFC-3986+compliant.spec://something)r   Zis_fsspec_urlr   r   r   r   r   test_is_fsspec_url  s    r   r   rW   formatra   r~   c              
   C   s   t  }t  t}tj|d| d}t|d| | W 5 Q R X tj|d| d(}|dkrltj|dd}n
t|}W 5 Q R X W 5 Q R X t 	|| d S )NrB   )r5   r   to_rM   ra   r   r   )
r8   r   r9   codecsr:   r   rk   rm   r   rn   )r   r   r?   r   rH   rp   r   r   r   test_codecs_encoding  s    
r   c                  C   s   t  } t  ~}t|d*}td|}| | W 5 Q R X W 5 Q R X t|d.}td|}tj	|dd}W 5 Q R X W 5 Q R X W 5 Q R X t 
| | d S )Nr3   rW   rR   r   r   )r8   r   r9   r:   r   	getwriterr   	getreaderrk   rm   rn   )r?   r   rH   encodedrp   r   r   r   test_codecs_get_writer_reader   s    
,r   zio_class,mode,msgtz*a bytes-like object is required, not 'str'ri   z%string argument expected, got 'bytes'c              
   C   sL   t  }|  4}tjt|d |j|d| d W 5 Q R X W 5 Q R X d S )Nr   rB   r4   )r8   r   r6   r   	TypeErrorr   )Zio_classr5   r   r?   r   r   r   r   test_explicit_encoding  s    r   encoding_errorsstrictreplacec              
   C   s  d}d}|dkr<d| d |d  d | }t tjdd}n.d	|d  d
 | d | d }t tjdd}t }t|}|| | dkrtj	t
|d ||| d W 5 Q R X n>||| d}|j| d}	tj|	|	gi|	d gd}
t||
 W 5 Q R X d S )Nz'utf-8' codec can't decode byte   ra      ,   
r   r   r   s   {"s   ": {"s   ":"s   "}}index)Zorientr   r   )r   errors)r   )r   rk   rm   r   r8   r9   r   write_bytesr6   r   UnicodeDecodeErrordecoderl   rn   )r   r   r   Zbad_encodingcontentrv   r   filerp   decodedr?   r   r   r   test_encoding_errors  s<    	

r	  c               
   C   sB   t  0} tjtdd tj| ddd W 5 Q R X W 5 Q R X d S )Nzunknown error handler namer   rB   badr  )r8   r9   r6   r   LookupErrorr   rG   r   r   r   r   test_bad_encdoing_errorsA  s    
r  c               	   C   s8   t jtdd } td | jtjks*tW 5 Q R X d S )Nz\[Errno 2\]r   Zdoesnt_exist)r6   r   r   rk   rm   errnoENOENTr   )r   r   r   r   test_errno_attributeH  s    
r  c               
   C   s@   t jtdd( t } tj| ddd W 5 Q R X W 5 Q R X d S )Nr   r   rR   T)r   )r6   r   r   r   r   rG   )r   r   r   r   test_fail_mmapO  s    r  c                  C   sd   G dd d} t jtdd> t ,}t|d}|j|   W 5 Q R X W 5 Q R X W 5 Q R X d S )Nc                   @   s   e Zd Zdd ZdS )z&test_close_on_error.<locals>.TestErrorc                 S   s   t dd S )Ntest)r   r   r   r   r   rO   X  s    z,test_close_on_error.<locals>.TestError.closeN)r   r   r   rO   r   r   r   r   	TestErrorW  s   r  r  r   rR   )r6   r   r   r   r   rG   Zcreated_handlesappend)r  r   rK   r   r   r   test_close_on_errorU  s
    r  ):r   r   r  	functoolsr   r   r   r   r   r   r   pathlibr   rC   r6   Zpandas.compatr   Zpandas.util._test_decoratorsutilZ_test_decoratorsr   Zpandasrk   Zpandas._testingZ_testingr8   Zpandas.io.commoncommonr   r   r   r   Zpy.pathr   r+   r  ImportErrorr   r*   dirname__file__r   r   r   r   Zfixturer   r   r   r   r   r   r   r	  r  r  r  r  r   r   r   r   <module>   s`   

  Z
O

!