o
    QD©i(  ã                	   @   s¾   d dl mZ ddg d¢g d¢g d¢g d¢gdd	d
œddd
œddd
œdd	d
œgddddœdœgdœdœdddgddgddgddggdœgiZdd„ Zdd„ Zd d!„ Zd"d#„ Zd$d%„ Zd&d'„ Zd(S ))é    )ÚPackageÚ	resourcesÚmain©ÚidÚnameÚsurnameÚ	parent_id)Ú1ÚAlexÚMartinÚ )Ú2ÚJohnÚDockinsr
   )Ú3ÚWalterÚWhiter   r   Úinteger)r   Útyper   Ústringr   r	   ÚpeopleÚ	firstname©ÚresourceÚfields©r   Ú	reference)r   ÚforeignKeys)r   ÚdataÚschemar   r   r   r   r   r   )r   r   c                  C   s¢   t tƒ} |  d¡}| ¡ }|d jsJ ‚|d jsJ ‚|d js"J ‚|d  ¡ dddd dœks1J ‚|d  ¡ ddd	ddœks@J ‚|d  ¡ d
ddddœksOJ ‚d S )Nr   r   é   é   r   r   r   r   r   é   r   r   )r   ÚDESCRIPTOR_FKÚget_table_resourceÚ	read_rowsÚvalidÚto_dict©Úpackager   Úrows© r,   úb/var/www/Datamplify/venv/lib/python3.10/site-packages/frictionless/package/__spec__/test_schema.pyÚtest_package_schema_foreign_key,   s0   

ü
ü
ür.   c                  C   sÀ   t tƒ} d| jd jd d< |  d¡}| ¡ }|d jsJ ‚|d js%J ‚|d jd jdks1J ‚|d  	¡ ddd	d d
œks@J ‚|d  	¡ ddddd
œksOJ ‚|d  	¡ ddddd
œks^J ‚d S )NÚbadr!   r#   r   r   r"   úforeign-keyr   r   r   r   r   r   r   )
r   r$   r   r   r%   r&   r'   Úerrorsr   r(   r)   r,   r,   r-   Ú'test_package_schema_foreign_key_invalidG   s2   

ü
ü
ür2   c                  C   sh   t tƒ} dgddgdœdœg| jd j_|  d¡}| ¡ }|d js$J ‚|d js+J ‚|d	 js2J ‚d S )
Nr	   r   r   r   r   r   r   r!   r"   ©r   r$   r   r    Úforeign_keysr%   r&   r'   r)   r,   r,   r-   Ú.test_package_schema_foreign_key_self_referencec   s   ÿ
r5   c                  C   s†   t tƒ} d| jd jd d< dgddgdœdœg| jd j_|  d	¡}| ¡ }|d js.J ‚|d
 js5J ‚|d j	d j
dksAJ ‚d S )NÚ0r   r"   r	   r   r   r   r   r   r!   r0   )r   r$   r   r   r    r4   r%   r&   r'   r1   r   r)   r,   r,   r-   Ú6test_package_schema_foreign_key_self_reference_invalido   s   ÿ
r7   c                  C   sl   t tƒ} ddgdddgdœdœg| jd j_|  d¡}| ¡ }|d js&J ‚|d	 js-J ‚|d
 js4J ‚d S )Nr   r   r   r   r   r   r   r   r!   r"   r3   r)   r,   r,   r-   Ú*test_package_schema_foreign_key_multifield|   s   þÿ
r8   c                  C   sŠ   t tƒ} ddgdddgdœdœg| jd j_d| jd	 jd
 d< |  d¡}| ¡ }|d js0J ‚|d	 js7J ‚|d j	d j
dksCJ ‚d S )Nr   r   r   r   r   r   r   r/   r!   r#   r   r"   r0   )r   r$   r   r    r4   r   r%   r&   r'   r1   r   r)   r,   r,   r-   Ú2test_package_schema_foreign_key_multifield_invalid‹   s   þÿ
r9   N)	Úfrictionlessr   r$   r.   r2   r5   r7   r8   r9   r,   r,   r,   r-   Ú<module>   sD    üüþÿùøüþèÿ&