o
    ÕèFh6  ã                   @   s¦  d Z ddlZddlZddlZddlmZ ddlmZ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mZ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„ Z)dd„ Z*dd„ Z+e ,ddj-¡ e ,de)eƒ¡ e ,de)eƒ¡ e ,de)eƒ¡ e ,de)eƒ¡ e .ej/e0¡ e .ej1e*¡ e .eje+¡ G d d!„ d!eƒZ2ed"ƒZ3G d#d$„ d$ej4ƒZ5dS )%z@
SQLite backend for the sqlite3 module in the standard library.
é    N)ÚMapping)ÚchainÚtee)Údbapi2)ÚImproperlyConfigured)ÚIntegrityError)ÚBaseDatabaseWrapper)Úasync_unsafe)Ú
parse_dateÚparse_datetimeÚ
parse_time)Ú_lazy_re_compileé   )Úregister)ÚDatabaseClient)ÚDatabaseCreation)ÚDatabaseFeatures)ÚDatabaseIntrospection)ÚDatabaseOperations)ÚDatabaseSchemaEditorc                    s   ‡ fdd„S )zR
    Convert bytestrings from Python's sqlite3 interface to a regular string.
    c                    s   ˆ |   ¡ ƒS ©N)Údecode)Ús©Ú	conv_func© úX/var/www/html/loop/nvenv/lib/python3.10/site-packages/django/db/backends/sqlite3/base.pyÚ<lambda>    s    zdecoder.<locals>.<lambda>r   r   r   r   r   Údecoder   s   r   c                 C   s   |   ¡ S r   ©Ú	isoformat©Úvalr   r   r   Ú
adapt_date#   ó   r#   c                 C   s
   |   d¡S )Nú r   r!   r   r   r   Úadapt_datetime'   s   
r&   Úbooló   1ÚdateÚtimeÚdatetimeÚ	timestampc                   @   sz  e Zd ZdZdZi dd“dd“dd“dd	“d
d“dd“dd“dd“dd“dd“dd“dd“dd“dd“dd“dd“dd“dd d!d"ddd#dd$d%d&œ
¥Zd'd(d'd'd)œZd*d*d*d+œZd,d-d-d-d.d/d0d1d2d3d-d-d-d-d4œZd5Z	d6d7d8d9d:d;d<œZ
eZeZeZeZeZeZeZd=d>„ Zd?d@„ ZedAdB„ ƒZdXdDdE„ZedFdG„ ƒZdHdI„ ZdJdK„ ZdLdM„ Z dNdO„ Z!dXdPdQ„Z"dRdS„ Z#dTdU„ Z$dVdW„ Z%dCS )YÚDatabaseWrapperÚsqliteÚSQLiteÚ	AutoFieldÚintegerÚBigAutoFieldÚBinaryFieldÚBLOBÚBooleanFieldr'   Ú	CharFieldzvarchar(%(max_length)s)Ú	DateFieldr)   ÚDateTimeFieldr+   ÚDecimalFieldÚdecimalÚDurationFieldÚbigintÚ	FileFieldÚFilePathFieldÚ
FloatFieldÚrealÚIntegerFieldÚBigIntegerFieldÚIPAddressFieldzchar(15)ÚGenericIPAddressFieldzchar(39)Ú	JSONFieldÚtextzbigint unsignedzinteger unsignedzsmallint unsignedÚsmallintr*   zchar(32))
ÚOneToOneFieldÚPositiveBigIntegerFieldÚPositiveIntegerFieldÚPositiveSmallIntegerFieldÚ	SlugFieldÚSmallAutoFieldÚSmallIntegerFieldÚ	TextFieldÚ	TimeFieldÚ	UUIDFieldz"%(column)s" >= 0z2(JSON_VALID("%(column)s") OR "%(column)s" IS NULL))rI   rE   rJ   rK   ÚAUTOINCREMENT)r0   r2   rM   z= %szLIKE %s ESCAPE '\'z	REGEXP %szREGEXP '(?i)' || %sz> %sz>= %sz< %sz<= %s)ÚexactÚiexactÚcontainsÚ	icontainsÚregexÚiregexÚgtÚgteÚltÚlteÚ
startswithÚendswithÚistartswithÚ	iendswithz@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z"LIKE '%%' || {} || '%%' ESCAPE '\'z)LIKE '%%' || UPPER({}) || '%%' ESCAPE '\'zLIKE {} || '%%' ESCAPE '\'z!LIKE UPPER({}) || '%%' ESCAPE '\'zLIKE '%%' || {} ESCAPE '\'z!LIKE '%%' || UPPER({}) ESCAPE '\')rU   rV   r]   r_   r^   r`   c                 C   sd   | j }|d stdƒ‚|d tjtjB dœ|d ¥}d|v r(|d r(t dt¡ | ddd	œ¡ |S )
NÚNAMEzJsettings.DATABASES is improperly configured. Please supply the NAME value.)ÚdatabaseÚdetect_typesÚOPTIONSÚcheck_same_threadzÃThe `check_same_thread` option was provided and set to True. It will be overridden with False. Use the `DatabaseWrapper.allow_thread_sharing` property instead for controlling thread shareability.FT)re   Úuri)	Úsettings_dictr   ÚDatabaseÚPARSE_DECLTYPESÚPARSE_COLNAMESÚwarningsÚwarnÚRuntimeWarningÚupdate)Úselfrg   Úkwargsr   r   r   Úget_connection_params“   s"   ÿ
þýûz%DatabaseWrapper.get_connection_paramsc                 C   s   | j jS r   )rh   Úsqlite_version_info©ro   r   r   r   Úget_database_version°   r$   z$DatabaseWrapper.get_database_versionc                 C   s0   t jdi |¤Ž}t|ƒ | d¡ | d¡ |S )NúPRAGMA foreign_keys = ONzPRAGMA legacy_alter_table = OFFr   )rh   ÚconnectÚregister_functionsÚexecute)ro   Úconn_paramsÚconnr   r   r   Úget_new_connection³   s
   

z"DatabaseWrapper.get_new_connectionNc                 C   s   | j jtd�S )N)Úfactory)Ú
connectionÚcursorÚSQLiteCursorWrapper)ro   Únamer   r   r   Úcreate_cursor¾   s   zDatabaseWrapper.create_cursorc                 C   s"   |   ¡  |  ¡ st | ¡ d S d S r   )Úvalidate_thread_sharingÚis_in_memory_dbr   Úclosers   r   r   r   r„   Á   s   ÿzDatabaseWrapper.closec                 C   s   | j S r   )Úin_atomic_blockrs   r   r   r   Ú_savepoint_allowedÊ   s   z"DatabaseWrapper._savepoint_allowedc                 C   sB   |rd }nd}| j � || j_W d   ƒ d S 1 sw   Y  d S )NÚ )Úwrap_database_errorsr}   Úisolation_level)ro   Ú
autocommitÚlevelr   r   r   Ú_set_autocommitÒ   s   
"ÿzDatabaseWrapper._set_autocommitc                 C   sN   |   ¡ �}| d¡ | d¡ ¡ d }W d   ƒ n1 sw   Y  t|ƒ S )NzPRAGMA foreign_keys = OFFzPRAGMA foreign_keysr   )r~   rx   Úfetchoner'   )ro   r~   Úenabledr   r   r   Údisable_constraint_checkingÞ   s
   

û
z+DatabaseWrapper.disable_constraint_checkingc                 C   s8   |   ¡ �}| d¡ W d   ƒ d S 1 sw   Y  d S )Nru   ©r~   rx   )ro   r~   r   r   r   Úenable_constraint_checkingç   s   
"ÿz*DatabaseWrapper.enable_constraint_checkingc                    sþ   ˆ  ¡ �q‰ |du rˆ  d¡ ¡ }nt ‡ ‡fdd„|D ƒ¡}|D ]L\}}}}ˆ  dˆj |¡ ¡ ¡ | }|dd… \}}	ˆj ˆ |¡}
ˆ  dˆj |
¡ˆj |¡ˆj |¡f |f¡ 	¡ \}}t
d	|||||||	f ƒ‚W d  ƒ dS 1 sxw   Y  dS )
a]  
        Check each table name in `table_names` for rows with invalid foreign
        key references. This method is intended to be used in conjunction with
        `disable_constraint_checking()` and `enable_constraint_checking()`, to
        determine if rows with invalid references were entered while constraint
        checks were off.
        NzPRAGMA foreign_key_checkc                 3   s*   � | ]}ˆ   d ˆj |¡ ¡ ¡ V  qdS )zPRAGMA foreign_key_check(%s)N)rx   ÚopsÚ
quote_nameÚfetchall)Ú.0Ú
table_name©r~   ro   r   r   Ú	<genexpr>÷   s   € ýÿ
ýz4DatabaseWrapper.check_constraints.<locals>.<genexpr>zPRAGMA foreign_key_list(%s)é   é   z'SELECT %s, %s FROM %s WHERE rowid = %%sz–The row in table '%s' with primary key '%s' has an invalid foreign key: %s.%s contains a value '%s' that does not have a corresponding value in %s.%s.)r~   rx   r”   r   Úfrom_iterabler’   r“   ÚintrospectionÚget_primary_key_columnr�   r   )ro   Útable_namesÚ
violationsr–   ÚrowidÚreferenced_table_nameÚforeign_key_indexÚforeign_keyÚcolumn_nameÚreferenced_column_nameÚprimary_key_column_nameÚprimary_key_valueÚ	bad_valuer   r—   r   Úcheck_constraintsë   s\   
üûÿþÿ


ýÿùø	ùýÿê"õz!DatabaseWrapper.check_constraintsc                 C   s   dS )NTr   rs   r   r   r   Ú	is_usable#  s   zDatabaseWrapper.is_usablec                 C   s   |   ¡  d¡ dS )zÂ
        Start a transaction explicitly in autocommit mode.

        Staying in autocommit mode works around a bug of sqlite3 that breaks
        savepoints when autocommit is disabled.
        ÚBEGINNr�   rs   r   r   r   Ú#_start_transaction_under_autocommit&  s   z3DatabaseWrapper._start_transaction_under_autocommitc                 C   s   | j  | jd ¡S )Nra   )Úcreationrƒ   rg   rs   r   r   r   rƒ   /  s   zDatabaseWrapper.is_in_memory_dbr   )&Ú__name__Ú
__module__Ú__qualname__ÚvendorÚdisplay_nameÚ
data_typesÚdata_type_check_constraintsÚdata_types_suffixÚ	operatorsÚpattern_escÚpattern_opsrh   r   ÚSchemaEditorClassr   Úclient_classr   Úcreation_classr   Úfeatures_classr   Úintrospection_classr   Ú	ops_classrq   rt   r	   r{   r�   r„   r†   rŒ   r�   r‘   r©   rª   r¬   rƒ   r   r   r   r   r-   6   sÎ    ÿþýüûúùø	÷
öõôóòñðïåüý	òú	



	
8	r-   z(?<!%)%sc                       s<   e Zd ZdZd
‡ fdd„	Z‡ fdd„Zddœdd	„Z‡  ZS )r   aQ  
    Django uses the "format" and "pyformat" styles, but Python's sqlite3 module
    supports neither of these styles.

    This wrapper performs the following conversions:

    - "format" style to "qmark" style
    - "pyformat" style to "named" style

    In both cases, if you want to use a literal "%s", you'll need to use "%%s".
    Nc                    sF   |d u r
t ƒ  |¡S t|tƒrt|ƒnd }| j||d�}t ƒ  ||¡S ©N©Úparam_names)Úsuperrx   Ú
isinstancer   ÚlistÚconvert_query)ro   ÚqueryÚparamsrÁ   ©Ú	__class__r   r   rx   C  s
   zSQLiteCursorWrapper.executec                    sR   t t|ƒƒ\}}t|d ƒ }rt|tƒrt|ƒ}nd }| j||d�}tƒ  ||¡S r¿   )	r   ÚiterÚnextrÃ   r   rÄ   rÅ   rÂ   Úexecutemany)ro   rÆ   Ú
param_listÚpeekablerÇ   rÁ   rÈ   r   r   rÌ   K  s   
zSQLiteCursorWrapper.executemanyrÀ   c                C   s.   |d u rt  d|¡ dd¡S |dd„ |D ƒ S )Nú?z%%ú%c                 S   s   i | ]}|d |› �“qS )ú:r   )r•   r€   r   r   r   Ú
<dictcomp>\  s    z5SQLiteCursorWrapper.convert_query.<locals>.<dictcomp>)ÚFORMAT_QMARK_REGEXÚsubÚreplace)ro   rÆ   rÁ   r   r   r   rÅ   V  s   z!SQLiteCursorWrapper.convert_queryr   )r®   r¯   r°   Ú__doc__rx   rÌ   rÅ   Ú__classcell__r   r   rÈ   r   r   6  s
    r   )6rÖ   r+   r:   rk   Úcollections.abcr   Ú	itertoolsr   r   Úsqlite3r   rh   Údjango.core.exceptionsr   Ú	django.dbr   Údjango.db.backends.base.baser   Údjango.utils.asyncior	   Údjango.utils.dateparser
   r   r   Údjango.utils.regex_helperr   Ú
_functionsr   rw   Úclientr   r­   r   Úfeaturesr   rœ   r   Ú
operationsr   Úschemar   r   r#   r&   Úregister_converterÚ__eq__Úregister_adapterÚDecimalÚstrr)   r-   rÓ   ÚCursorr   r   r   r   r   Ú<module>   sF     ~