o
    
=h;                     @   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+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j0e1 e/ej2e* e/eje+ G d"d# d#eZ3ed$Z4G d%d& d&ej5Z6d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 W/var/www/ecommerce/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&   c                 C   s   | d d u rdS d|  S )N
max_lengthvarcharvarchar(%(max_length)s)r   )datar   r   r   _get_varchar_column+   s   r+   bool   1datetimedatetime	timestampc                   @   s  e Zd ZdZdZi dddddddd	d
e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g d=ZeZeZeZeZeZeZeZd>d? Zd@dA ZedBdC ZdYdEdFZedGdH Z dIdJ Z!dKdL Z"dMdN Z#dOdP Z$dYdQdRZ%dSdT Z&dUdV Z'dWdX Z(dDS )ZDatabaseWrappersqliteSQLite	AutoFieldintegerBigAutoFieldBinaryFieldBLOBBooleanFieldr,   	CharField	DateFieldr.   DateTimeFieldr0   DecimalFielddecimalDurationFieldbigint	FileFieldr)   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))rN   rJ   rO   rP   AUTOINCREMENT)r5   r7   rR   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 '\')rZ   r[   rb   rd   rc   re   )DEFERRED	EXCLUSIVE	IMMEDIATEc                 C   s   | j }|d std|d tjtjB d|d }d|v r(|d r(tdt |ddd	 |	d
d }|d ur]|
 | jvr]ddd t| jD }td| jd| d| d|rc|
 nd | _|	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)rm   uritransaction_modez, c                 S   s   g | ]}|qS r   r   ).0moder   r   r   
<listcomp>   s    z9DatabaseWrapper.get_connection_params.<locals>.<listcomp>zsettings.DATABASES[z>]['OPTIONS']['transaction_mode'] is improperly configured to 'z'. Use one of z
, or None.init_command ;)settings_dictr   DatabasePARSE_DECLTYPESPARSE_COLNAMESwarningswarnRuntimeWarningupdatepopuppertransaction_modesjoinsortedaliasro   splitinit_commands)selfrv   kwargsro   allowed_transaction_modesrs   r   r   r   get_connection_params   sB   

z%DatabaseWrapper.get_connection_paramsc                 C   s   | j jS r   )rw   sqlite_version_infor   r   r   r   get_database_version   r$   z$DatabaseWrapper.get_database_versionc                 C   sR   t jdi |}t| |d |d | jD ]}|  }r&|| q|S )NPRAGMA foreign_keys = ONzPRAGMA legacy_alter_table = OFFr   )rw   connectregister_functionsexecuter   strip)r   conn_paramsconnrs   r   r   r   get_new_connection   s   



z"DatabaseWrapper.get_new_connectionNc                 C   s   | j jtdS )N)factory)
connectioncursorSQLiteCursorWrapper)r   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   closer   r   r   r   r      s   zDatabaseWrapper.closec                 C   s   | j S r   )in_atomic_blockr   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 )Nrt   )wrap_database_errorsr   isolation_level)r   
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   r   fetchoner,   )r   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 )Nr   )r   r   )r   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)r   ops
quote_namefetchall)rp   
table_namer   r   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   r   r   r   from_iterabler   r   introspectionget_primary_key_columnr   r   )r   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   r   r   r   r   	is_usable?  s   zDatabaseWrapper.is_usablec                 C   s6   | j du r|  d dS |  d| j   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.
        NBEGINzBEGIN )ro   r   r   r   r   r   r   #_start_transaction_under_autocommitB  s   
z3DatabaseWrapper._start_transaction_under_autocommitc                 C   s   | j | jd S )Nri   )creationr   rv   r   r   r   r   r   N  s   zDatabaseWrapper.is_in_memory_dbr   ))__name__
__module____qualname__vendordisplay_namer+   
data_typesdata_type_check_constraintsdata_types_suffix	operatorspattern_escpattern_ops	frozensetr   rw   r   SchemaEditorClassr   client_classr   creation_classr   features_classr   introspection_classr   	ops_classr   r   r	   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r2   <   s    	
		.


	
8r2   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)superr   
isinstancer   listconvert_query)r   queryparamsr   	__class__r   r   r   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)r   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   )rp   r   r   r   r   
<dictcomp>{  s    z5SQLiteCursorWrapper.convert_query.<locals>.<dictcomp>)FORMAT_QMARK_REGEXsubreplace)r   r   r   r   r   r   r   u  s   z!SQLiteCursorWrapper.convert_queryr   )r   r   r   __doc__r   r   r   __classcell__r   r   r   r   r   U  s
    r   )7r   r0   r?   rz   collections.abcr   	itertoolsr   r   sqlite3r   rw   django.core.exceptionsr   	django.dbr   django.db.backends.base.baser   django.utils.asyncior	   django.utils.dateparser
   r   r   django.utils.regex_helperr   
_functionsr   r   clientr   r   r   featuresr   r   r   
operationsr   schemar   r   r#   r&   r+   register_converter__eq__register_adapterDecimalstrr.   r2   r   Cursorr   r   r   r   r   <module>   sJ      