o
    ;D©iÄ  ã                   @   s|   d dl mZmZmZ d dlmZ d dlZd dlmZ d dl	m
Z
mZmZ dd„ Zdd	„ Zd
d„ Zdd„ Zdd„ Zdd„ ZdS )é    )Úabsolute_importÚprint_functionÚdivision)ÚNamedTemporaryFileN)Úieq)ÚfromdbÚtodbÚappenddbc                  C   s’   t dd} |  ¡  d}t | j¡}| ¡ }| d¡ |D ]}| d|¡ q| ¡  | ¡  | ¡  t| jdƒ}d}t	||t
d t	||t
d d S )	NF©Údelete©©Úaé   ©Úbé   ©Úcg       @úCREATE TABLE foobar (foo, bar)ú INSERT INTO foobar VALUES (?, ?)úSELECT * FROM foobar©©ÚfooÚbarr   r   r   ©Úcast)r   ÚcloseÚsqlite3ÚconnectÚnameÚcursorÚexecuteÚcommitr   r   Útuple)ÚfÚdataÚ
connectionr   ÚrowÚactualÚexpect© r,   úR/var/www/Datamplify/venv/lib/python3.10/site-packages/petl/test/io/test_sqlite3.pyÚtest_fromsqlite3   s   

r.   c                  C   st   d} t  d¡}| ¡ }| d¡ | D ]}| d|¡ q| ¡  | ¡  t|dƒ}d}t||td t||td d S )Nr   ú:memory:r   r   r   r   r   )	r   r    r"   r#   r$   r   r   r   r%   ©r'   r(   r   r)   r*   r+   r,   r,   r-   Útest_fromsqlite3_connection)   s   


r1   c                  C   sn   d} t  d¡}| ¡ }| d¡ | D ]}| d|¡ q| ¡  | ¡  t|ddƒ}d}t||ƒ t||ƒ d S )Nr   r/   r   r   z.SELECT * FROM foobar WHERE bar > ? AND bar < ?)r   é   )r   r   r   )r   r    r"   r#   r$   r   r   r   r0   r,   r,   r-   Útest_fromsqlite3_withargsB   s    

ý
r3   c                  C   s    d} t dd}| ¡  t |j¡}| d¡ | ¡  t| |jdƒ t |j¡}| d¡}d}t||ƒ d}t||jdƒ t |j¡}| d¡}d	}t||ƒ d S )
N©r   r   r   ©r   r   Fr
   ú'CREATE TABLE foobar (foo TEXT, bar INT)Úfoobarr   ©r   r   r5   ©r   ©Údé   ©Úeé	   ©r&   r   ©r   r   r5   r:   r=   r@   )	r   r   r   r    r!   r#   r   r   r	   )Útabler&   Úconnr*   r+   Útable2r,   r,   r-   Útest_tosqlite3_appendsqlite3]   s"   




rE   c                  C   sh   t  d¡} |  d¡ d}t|| dƒ |  d¡}d}t||ƒ d}t|| dƒ |  d¡}d}t||ƒ d S )	Nr/   r6   r4   r7   r   r8   r9   rA   )r   r    r#   r   r   r	   )rC   rB   r*   r+   rD   r,   r,   r-   Ú'test_tosqlite3_appendsqlite3_connection†   s   




rF   c                  C   sj   d} t dd}| ¡  t |j¡}| d¡ | ¡  t| |jdƒ t |j¡}| d¡}d}t||ƒ d S )N))zfoo foozbar.baz.spong`r   r   r5   Fr
   zACREATE TABLE "foo "" bar`" ("foo foo" TEXT, "bar.baz.spong`" INT)z
foo " bar`zSELECT * FROM `foo " bar```r8   )r   r   r   r    r!   r#   r   r   )rB   r&   rC   r*   r+   r,   r,   r-   Útest_tosqlite3_identifiers«   s   


rG   )Ú
__future__r   r   r   Útempfiler   r   Úpetl.test.helpersr   Ú
petl.io.dbr   r   r	   r.   r1   r3   rE   rF   rG   r,   r,   r,   r-   Ú<module>   s   )%