U e<6@sdZddlZddlZddlZddlmZddlmZmZddl m Z ddl m Z ddlmZddlmZdd lmZdd lmZmZmZdd lmZd d lmZd dlmZd dlm Z d dl!m"Z"d dl#m$Z$d dl%m&Z&d dl'm(Z(ddZ)ddZ*ddZ+e ,ddj-e ,de)ee ,de)ee ,de)ee ,de)ee .ej/e0e .ej1e*e .eje+Gd d!d!eZ2ed"Z3Gd#d$d$e j4Z5dS)%z@ SQLite backend for the sqlite3 module in the standard library. N)Mapping)chaintee)dbapi2)ImproperlyConfigured)IntegrityError)BaseDatabaseWrapper) async_unsafe) parse_dateparse_datetime parse_time)_lazy_re_compile)register)DatabaseClient)DatabaseCreation)DatabaseFeatures)DatabaseIntrospection)DatabaseOperations)DatabaseSchemaEditorcs fddS)zR Convert bytestrings from Python's sqlite3 interface to a regular string. cs |SN)decode)sZ conv_funcC/tmp/pip-unpacked-wheel-lctamlir/django/db/backends/sqlite3/base.pyzdecoder..rrrrrdecodersrcCs|Sr isoformatvalrrr adapt_date"sr#cCs |dS)N rr!rrradapt_datetime&sr%bool1datetimedatetime timestampc@s2eZdZdZdZdddddddd d ddd dd d d ddddddddddddZdddddZddddZdddddddd d!d"ddddd#Zd$Z d%d&d'd(d)d*d+Z e Z e Z eZeZeZeZeZd,d-Zd.d/Zed0d1ZdGd3d4Zed5d6Zd7d8Zd9d:Zd;d<Z d=d>Z!dHd?d@Z"dAdBZ#dCdDZ$dEdFZ%d2S)IDatabaseWrapperZsqliteZSQLiteintegerZBLOBr&zvarchar(%(max_length)s)r(r*decimalZbigintrealzchar(15)zchar(39)textzbigint unsignedzinteger unsignedzsmallint unsignedZsmallintr)zchar(32)) AutoField BigAutoFieldZ BinaryFieldZ BooleanFieldZ CharFieldZ DateFieldZ DateTimeFieldZ DecimalFieldZ DurationFieldZ FileFieldZ FilePathFieldZ FloatFieldZ IntegerFieldZBigIntegerFieldZIPAddressFieldZGenericIPAddressField JSONFieldZ OneToOneFieldPositiveBigIntegerFieldPositiveIntegerFieldPositiveSmallIntegerFieldZ SlugFieldSmallAutoFieldZSmallIntegerFieldZ TextFieldZ TimeFieldZ UUIDFieldz"%(column)s" >= 0z2(JSON_VALID("%(column)s") OR "%(column)s" IS NULL))r4r3r5r6Z AUTOINCREMENT)r1r2r7z= %szLIKE %s ESCAPE '\'z REGEXP %szREGEXP '(?i)' || %sz> %sz>= %sz< %sz<= %s)exactZiexactcontains icontainsregexZiregexgtZgteltZlte startswithendswith istartswith iendswithz@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z"LIKE '%%' || {} || '%%' ESCAPE '\'z)LIKE '%%' || UPPER({}) || '%%' ESCAPE '\'zLIKE {} || '%%' ESCAPE '\'z!LIKE UPPER({}) || '%%' ESCAPE '\'zLIKE '%%' || {} ESCAPE '\'z!LIKE '%%' || UPPER({}) ESCAPE '\')r9r:r>r@r?rAcCsd|j}|dstd|dtjtjBd|d}d|krP|drPtdt|ddd |S) NNAMEzJsettings.DATABASES is improperly configured. Please supply the NAME value.)ZdatabaseZ detect_typesOPTIONScheck_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)rDuri) settings_dictrDatabaseZPARSE_DECLTYPESZPARSE_COLNAMESwarningswarnRuntimeWarningupdate)selfrFkwargsrrrget_connection_paramss"  z%DatabaseWrapper.get_connection_paramscCs|jjSr)rGZsqlite_version_inforLrrrget_database_versionsz$DatabaseWrapper.get_database_versioncCs,tjf|}t||d|d|S)NPRAGMA foreign_keys = ONzPRAGMA legacy_alter_table = OFF)rGconnectregister_functionsexecute)rLZ conn_paramsconnrrrget_new_connections    z"DatabaseWrapper.get_new_connectionNcCs|jjtdS)N)factory) connectioncursorSQLiteCursorWrapper)rLnamerrr create_cursorszDatabaseWrapper.create_cursorcCs||st|dSr)Zvalidate_thread_sharingis_in_memory_dbrcloserOrrrr^szDatabaseWrapper.closecCs|jSr)Zin_atomic_blockrOrrr_savepoint_allowedsz"DatabaseWrapper._savepoint_allowedc Cs,|r d}nd}|j||j_W5QRXdS)N)Zwrap_database_errorsrXZisolation_level)rLZ autocommitlevelrrr_set_autocommits zDatabaseWrapper._set_autocommitc Cs:|"}|d|dd}W5QRXt| S)NzPRAGMA foreign_keys = OFFzPRAGMA foreign_keysr)rYrTfetchoner&)rLrYZenabledrrrdisable_constraint_checkings  z+DatabaseWrapper.disable_constraint_checkingc Cs"|}|dW5QRXdS)NrQrYrT)rLrYrrrenable_constraint_checkings z*DatabaseWrapper.enable_constraint_checkingc s؉|dkr"d}ntfdd|D}|D]\}}}}dj||}|dd\}} j|} dj| j|j|f|f \} } t d || ||| || fq@W5QRXdS) 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. NzPRAGMA foreign_key_checkc3s(|] }dj|VqdS)zPRAGMA foreign_key_check(%s)N)rTops quote_namefetchall).0 table_namerYrLrr sz4DatabaseWrapper.check_constraints..zPRAGMA 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.) rYrTrir from_iterablergrh introspectionZget_primary_key_columnrcr) rLZ table_namesZ violationsrkZrowidZreferenced_table_nameZforeign_key_indexZ foreign_keyZ column_nameZreferenced_column_nameZprimary_key_column_nameZprimary_key_valueZ bad_valuerrlrcheck_constraintssV      z!DatabaseWrapper.check_constraintscCsdS)NTrrOrrr is_usable"szDatabaseWrapper.is_usablecCs|ddS)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. ZBEGINNrerOrrr#_start_transaction_under_autocommit%sz3DatabaseWrapper._start_transaction_under_autocommitcCs|j|jdS)NrB)creationr]rFrOrrrr].szDatabaseWrapper.is_in_memory_db)N)N)&__name__ __module__ __qualname__vendorZ display_name data_typesZdata_type_check_constraintsZdata_types_suffix operatorsZ pattern_escZ pattern_opsrGrZSchemaEditorClassrZ client_classrZcreation_classrZfeatures_classrZintrospection_classrZ ops_classrNrPr rVr\r^r_rbrdrfrrrsrtr]rrrrr,5s       8 r,z(?[sz5SQLiteCursorWrapper.convert_query..)FORMAT_QMARK_REGEXsubreplace)rLrr~rrrrUsz!SQLiteCursorWrapper.convert_query)N)rvrwrx__doc__rTrr __classcell__rrrrrZ5s  rZ)6rr*r.rHcollections.abcr itertoolsrrZsqlite3rrGZdjango.core.exceptionsrZ django.dbrZdjango.db.backends.base.baserZdjango.utils.asyncior Zdjango.utils.dateparser r r Zdjango.utils.regex_helperr Z _functionsrrSclientrrurfeaturesrrqr operationsrZschemarrr#r%Zregister_converter__eq__Zregister_adapterDecimalstrr(r,rCursorrZrrrrsD              ~