U
    f/eQI                     @   s  d Z ddlZddlZddlmZ ddl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 Z/ej)0dddgej)0dddgdd Z1dd Z2ej)0deddfedd fgd!d" Z3ej)0d#dd$d%gej)0dddgd&d' Z4d(d) Z5d*d+ Z6dS ),z0
Tests for the pandas.io.common functionalities
    N)partial)BytesIOStringIO)Path)is_platform_windowsc                   @   s    e Zd ZdZdd Zdd ZdS )CustomFSPathz%For testing fspath on unknown objectsc                 C   s
   || _ d S Npath)selfr
    r   ?/tmp/pip-unpacked-wheel-tiezk1ph/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__N)__name__
__module____qualname____doc__r   r   r   r   r   r   r      s   r   )localz*ignore:can't resolve package:ImportWarningc                   @   s  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dddddddddg	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"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	d0d1 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ej#d#ed/fg
d2d3 Z&ejd4ejd#d5fej%d#d5fejd#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g
ej'd>ej'd?d@dA Z(ejdBdCi d#fdDdEdFidFfdGi d(fdHi d#fdIi d#fdJi d#fdKi d#fdLdMe)dNid#fgdOdP Z*ej'd?ej+dQdR Z,dSS )T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_pathF   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_pathlibM   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_localpathS   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_fspathZ   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   r/   r
   Z
fsspec_objr   r   r   !test_stringify_file_and_path_like_   s    

z:TestCommonIOCapabilities.test_stringify_file_and_path_likezextension,expected) N)z.gzgzip)z.bz2bz2)z.zipzip)z.xzxz)z.GZr:   )z.BZ2r;   )z.ZIPr<   )z.XZr=   	path_typec                 C   s*   |d| }t j|dd}||ks&td S )Nr+   Zinfer)compression)r   Zinfer_compressionr   )r   	extensionexpectedr>   r
   r?   r   r   r    test_infer_compression_from_pathf   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_pathz   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   rI   rJ   r   closedclose)r   Zinput_bufferrM   r   r   r   test_get_handle_with_buffer   s
    
z4TestCommonIOCapabilities.test_get_handle_with_bufferc              	   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   )	chunksizeT)Zignore_indexr   )	pdread_csvr   data1concatr5   assert_frame_equalnextZiloc)r   readerr-   rA   itfirstr   r   r   test_iterator   s    z&TestCommonIOCapabilities.test_iteratorz#reader, module, error_class, fn_extr   csvtxtZxlrdZxlsxZpyarrow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 )Ndata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)r3   r4   r   r
   r$   HEREraises)r   r[   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_existentc                 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~rg   r   c                 S   s   t jd| S )Nr!   )r   r
   r$   )xr   r   r   <lambda>       zJTestCommonIOCapabilities.test_read_expands_user_home_dir.<locals>.<lambda>rh   ri   rj   rk   z0Unexpected character found when decoding 'false'rl   rm   rn   ro   rp   rq   rr   rs   rt   ru   )r3   r4   r   r
   r$   setattrr   rx   )r   r[   ry   rz   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)iorf   r_   ziris.csv)r   rf   Zfixed_widthzfixed_width_format.txt)r   rf   excelz
test1.xlsx)r   rf   ra   zfeather-0_3_1.feather)r   rf   Z
legacy_hdfzdatetimetz_object.h5)r   rf   Zstatazstata10_115.dta)r   Zsasrf   ztest1.sas7bdat)r   rd   rf   ztsframe_v012.json)r   rf   re   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)r3   r4   r   endswithr5   Zassert_categorical_equalrY   )r   r[   ry   r
   datapathmypathr-   rA   r   r   r   test_read_fspath_all   s    &

z-TestCommonIOCapabilities.test_read_fspath_allz"writer_name, writer_kwargs, moduleto_csvZto_excelengineZxlwtZ
to_featherZto_htmlZto_jsonZto_latexZ	to_pickleZ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ArS      rb)r5   r6   rU   	DataFramer3   r4   r   getattrr7   readr   )r   Zwriter_nameZwriter_kwargsry   p1p2dfr   r   r   writerfrA   r-   r   r   r   test_write_fspath_all  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 )	Nrb   r   rS   r   r   r   r"   )key)
r3   r4   rU   r   r5   r6   r   Zto_hdfread_hdfrY   )	r   r   r   r   r   r   r   r-   rA   r   r   r   test_write_fspath_hdf5;  s    


"z/TestCommonIOCapabilities.test_write_fspath_hdf5N)-r   r   r   rW   r   r   r&   tdZ
skip_if_nor*   r.   r8   r3   markparametrize
path_typesrB   strr   r   rN   rR   r^   rU   rV   FileNotFoundErrorZread_fwfZ
read_excelZread_featherIOErrorr   Z
read_stataZread_sas	read_json
ValueErrorZread_pickler   Z
read_tabler   filterwarningsr   Zto_datetimer   Z&skip_array_manager_not_yet_implementedr   r   r   r   r   r   3   s   	










r   c                 C   s   | ddddS )Nr   rf   r_   ztest_mmap.csvr   )r   r   r   r   	mmap_fileT  s    r   c                   @   s`   e Zd Zd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	| W 5 Q R X t
|}|  d}tjt|d t	| W 5 Q R X d S )NzI am not a filec                   S   s   dS )Nr   r   r   r   r   r   \  r   z;TestMMapWrapper.test_constructor_bad_file.<locals>.<lambda>zThe parameter is incorrectz
[Errno 22]ru   zI/O operation on closed file)r   filenor   OSErrormmaperrorr3   rx   r   _MMapWrapperr7   rQ   r   )r   r   Znon_filemsgerrtargetr   r   r   test_constructor_bad_fileZ  s    
z)TestMMapWrapper.test_constructor_bad_filec              	   C   sj   t |}t|}W 5 Q R X t|j}dd |D }|d |D ]}t||sDtqDt|drftd S )Nc                 S   s   g | ]}| d s|qS )__)
startswith).0attrr   r   r   
<listcomp>u  s     
 z1TestMMapWrapper.test_get_attr.<locals>.<listcomp>__next__r!   )r7   r   r   rC   r   appendhasattrr   )r   r   r   wrapperattrsr   r   r   r   test_get_attrp  s    


zTestMMapWrapper.test_get_attrc              	   C   sr   t |}t|}| }W 5 Q R X |D ] }t|}| | ks*tq*tjt	dd t| W 5 Q R X d S )Nz^$ru   )
r7   r   r   	readlinesrZ   stripr   r3   rx   StopIteration)r   r   r   r   lines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 engineru   Zpyt)r   )	r5   r6   makeDataFramer   r3   rx   r   rU   rV   r   r
   r   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+br1   r   Z	index_colN)r5   r6   r   r   rY   rU   rV   r   r   r   r   test_binary_mode  s    
z TestMMapWrapper.test_binary_modeencodingzutf-16zutf-32compression_r;   r=   c              
   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 BOMru   N)r5   r   r6   Zassert_produces_warningUnicodeWarningr   r3   rx   UnicodeErrorrU   rV   )r   r   r   r   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   r   r3   r   r   r   r   r   r   r   r   Y  s   r   c                   C   sX   t dstt dstt dr*tt dr8tt drFtt drTtd S )Nzgcs://pandas/somethingelse.comzgs://pandas/somethingelse.comzhttp://pandas/somethingelse.comzrandom:pandas/somethingelse.comz/local/pathzrelative/local/path)r   Zis_fsspec_urlr   r   r   r   r   test_is_fsspec_url  s    r   r   utf-8formatr_   rd   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 )NrD   )r2   r   to_rO   r_   r   r   )
r5   r   r6   codecsr7   r   rU   rV   r   rY   )r   r   rA   r
   rJ   r   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 )Nr0   r   r   r   r   )r5   r   r6   r7   r   	getwriterr   	getreaderrU   rV   rY   )rA   r
   rJ   encodedr   r   r   r   test_codecs_get_writer_reader  s    
,r   zio_class,mode,msgtz*a bytes-like object is required, not 'str'bz%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 )Nru   rD   r1   )r5   r   r3   rx   	TypeErrorr   )Zio_classr2   r   rA   bufferr   r   r   test_explicit_encoding  s    r   encoding_errorsstrictreplacec              
   C   s   d}d}|dkrd S 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   r_      
s   {"r   s   ": {"s   ":"s   "}}index)Zorientr   ru   )r   errors)r   )rU   rV   r   r   r5   r6   r   write_bytesr3   rx   UnicodeDecodeErrordecoder   rY   )r   r   r   Zbad_encodingcontentr[   r
   filer   decodedrA   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#Invalid value for `encoding_errors`ru   rD   badr   )r5   r6   r3   rx   r   r   rI   r	   r   r   r   test_bad_encdoing_errors  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\]ru   Zdoesnt_exist)r3   rx   r   rU   rV   errnoENOENTr   )r   r   r   r   test_errno_attribute  s    
r   )7r   r   r   	functoolsr   r   r   r   r   r   pathlibr   rE   r3   Zpandas.compatr   Zpandas.util._test_decoratorsutilZ_test_decoratorsr   ZpandasrU   Zpandas._testingZ_testingr5   Zpandas.io.commoncommonr   r   r   r   Zpy.pathr   r(   r   ImportErrorr
   r'   dirname__file__rw   r   r   r   Zfixturer   r   r   r   r   r   r   r   r   r   r   r   r   r   <module>   s\   

  "
W


"