o
    e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 R/var/www/html/venv/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_threadzThe `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 = %%szThe 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-   5   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   B  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   J  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   U  s   z!SQLiteCursorWrapper.convert_queryr   )r   r   r   __doc__rx   r   r   __classcell__r   r   r   r   r   5  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     ~