o
    E6d                     @   sf  d dl Z d dlZddlmZ ddlmZ ddlmZ ddlm	Z	 ddlm
Z
 ddlmZ dd	lmZ dd
lmZ ddlmZ ddlmZ ddlmZ ddlmZ h dZdd Zeddd Ze
ddd Zeddd Zeddd Ze	ddd Zdd Zeddd  Zedd!d" Zedd#d$ Zeddd%d&d'd(ZdS ))    N   )exc)url)	create_db)drop_db)follower_url_from_main)generate_driver_url)log)post_configure_engine)run_reap_dbs) stop_test_class_outside_fixtures)temp_table_keyword_args)upsert>   Zpysqlite_numericZpysqliteZpysqlite_dollarZ	aiosqlitepysqlcipherc           	      C   s  t | } |du r|  }| j}|dk}d}|rs|dkrsd|vs"J td|}| }|D ]}|tv r:|du r9|}q-|dv r?q-|du rH|d}q-|sSJ d| j | d| }|rc|d| 7 }|d	7 }|rm|d
7 }| j|d} |r{| jdd} | jd|f d} | S )zUgiven a sqlite url + desired driver + ident, make a canonical
    URL out of it

    Nr   :memory:Ztest_schemaz[_\.])dbenc_z#sqlite filename has no name token: .dbz.enc)databasetest)passwordz	sqlite+%s)
drivername)	sa_urlmake_urlZget_driver_namer   resplit_drivernamesstripset)	r   driveridentfilenameZ	needs_encZ
name_tokentokensZnew_filenametoken r%   {C:\Users\jesus\OneDrive\Desktop\erpjis_fastapi\backend\jisbackend\Lib\site-packages\sqlalchemy/dialects/sqlite/provision.py_format_url   s@   

r'   Zsqlitec                 C   s2   t | |d } z|   W | S  tjy   Y d S w N)r'   get_dialectr   ZNoSuchModuleError)r   r    Z	query_strr%   r%   r&   r   O   s   
r   c                 C   s   t | d |S r(   )r'   )r   r!   r%   r%   r&   _sqlite_follower_url_from_main[      r*   c                    sd   ddl m} |r| d|j d n|j d ||d fdd}||d fd	d
}d S )Nr   )eventr   z_test_schema.dbconnectc                    s   |  d  d d S )NzATTACH DATABASE "z" AS test_schema)execute)Zdbapi_connectionZconnection_recordZattach_pathr%   r&   r-   i   s   

z._sqlite_post_configure_engine.<locals>.connectZengine_disposedc                    sP   t j rt   | jj}|r"|dkr$t j|r&t | dS dS dS dS )zmost databases should be dropped using
        stop_test_class_outside_fixtures

        however a few tests like AttachedDBTest might not get triggered on
        that main hook

        r   N)ospathexistsremover   r   )enginer"   r/   r%   r&   disposew   s   

z._sqlite_post_configure_engine.<locals>.dispose)Z
sqlalchemyr,   r    Zlistens_for)r   r4   Zfollower_identr,   r-   r5   r%   r/   r&   _sqlite_post_configure_engine`   s   

r6   c                 C   s   d S r(   r%   cfgengr!   r%   r%   r&   _sqlite_create_db   s   r:   c                 C   s   t |jj|j| d S r(   )_drop_dbs_w_identr   r   r    r7   r%   r%   r&   _sqlite_drop_db   s   r<   c                 C   sJ   t dD ]}t j|\}}||v r"|dv r"td| t | qd S )N.)r   z.db.encz!deleting SQLite database file: %s)r0   listdirr1   r   r	   infor3   )Zdatabasenamer    r!   r1   fnameextr%   r%   r&   r;      s   
r;   c                 C   s   |   d S r(   )r5   )configr   clsr%   r%   r&   r      r+   r   c                 C   s
   ddgiS )Nprefixes	TEMPORARYr%   )r8   r9   r%   r%   r&   _sqlite_temp_table_keyword_args   s   
rF   c                 C   sN   t d|  t dd| t| } |D ]}tD ]	}t| j|| qqd S )Nzdb reaper connecting to %rzidentifiers in file: %sz, )r	   r?   joinr   r   r   r;   r   )r   Zidentsr!   r   r%   r%   r&   _reap_sqlite_dbs   s   
rH   F)
set_lambdasort_by_parameter_orderc                C   sH   ddl m} ||}|r|j||jd}n| }|j|d|i}|S )Nr   )insert)set_rJ   )Zsqlalchemy.dialects.sqliterK   Zon_conflict_do_updateexcludedZon_conflict_do_nothing	returning)r8   tablerN   rI   rJ   rK   stmtr%   r%   r&   _upsert   s   rQ   )r0   r    r   r4   r   r   Ztesting.provisionr   r   r   r   r	   r
   r   r   r   r   r   r'   Zfor_dbr*   r6   r:   r<   r;   rF   rH   rQ   r%   r%   r%   r&   <module>   sH   	1


)




	