|
Server : Apache System : Linux cvar2.toservers.com 3.10.0-962.3.2.lve1.5.73.el7.x86_64 #1 SMP Wed Aug 24 21:31:23 UTC 2022 x86_64 User : njnconst ( 1116) PHP Version : 8.4.18 Disable Function : NONE Directory : /usr/lib64/python2.7/site-packages/django/db/backends/sqlite3/ |
Upload File : |
�
r�\c @ s� d Z d d l m Z d d l Z d d l Z d d l Z d d l Z d d l m Z d d l Td 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 y< y d d l! m" Z# Wn! e$ k
rVd d l% m" Z# n XWn3 e$ k
r�Z& d d l' m( Z( e( d e& � � n Xy d d l) Z) Wn e$ k
r�d Z) n Xe# j+ Z+ e# j, Z, d � Z- d � Z. d � Z/ e# j0 e1 d � e/ d � � � e# j0 e1 d � e/ e � � e# j0 e1 d � e/ e � � e# j0 e1 d � e/ e- � � e# j0 e1 d � e/ e- � � e# j0 e1 d � e/ e- � � e# j0 e1 d � e/ e2 j3 � � e# j4 e j e. � e# j4 e j5 e2 j6 � e j7 re# j8 d3 k re# j4 e1 d" � � e# j4 e d# � � n d$ e9 f d% � � YZ: d& e; f d' � � YZ< d( e= f d) � � YZ> e j? d* � Z@ d+ e# jA f d, � � YZB d- � ZC d. � ZD d/ � ZE d0 � ZF d1 � ZG d2 � ZH d S(4 ut
SQLite3 backend for django.
Works with either the pysqlite2 module or the sqlite3 module in the
standard library.
i����( t unicode_literalsN( t utils( t *( t DatabaseClient( t DatabaseCreation( t DatabaseIntrospection( t fields( t
aggregates( t
parse_datet parse_datetimet
parse_time( t
force_text( t cached_property( t SafeBytes( t six( t timezone( t dbapi2( t ImproperlyConfigureduK Error loading either pysqlite2 or sqlite3 modules (tried in that order): %sc C sL t | � } | d k rH t j rH t j | � rH | j d t j � } n | S( Nt tzinfo( R t Nonet settingst USE_TZR t is_naivet replacet utc( t valuet dt( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt$ parse_datetime_with_timezone_support- s $c C s� t j rn t j | � rM t j d | t � t j � } t j | | � } n | j t j
� j d d � } n | j
t d � � S( NuH SQLite received a naive datetime (%s) while time zone support is active.R u ( R R R R t warningst warnt RuntimeWarningt get_default_timezonet
make_awaret
astimezoneR R R t isoformatt str( R t default_timezone( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt$ adapt_datetime_with_timezone_support4 s !c s
� f d � S( u� The Python sqlite3 interface returns always byte strings.
This function converts the received value to a regular string before
passing it to the receiver function.
c s � | j d � � S( Nu utf-8( t decode( t s( t conv_func( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt <lambda>E s ( ( R( ( ( R( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt decoder@ s u boolc C s
| d k S( Nu 1( ( R' ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR) G s u timeu dateu datetimeu timestampu TIMESTAMPu decimali i i c C s
| j d � S( Nu utf-8( R& ( R' ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR) W s c C s
| j d � S( Nu utf-8( R& ( R' ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR) X s t DatabaseFeaturesc B s} e Z e Z e Z e Z e Z e Z e Z e Z
e Z e Z e Z
e Z e Z e d � � Z e d � � Z e d � � Z RS( c C s
t j d k S( Ni i i ( i i i ( t Databaset sqlite_version_info( t self( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt uses_savepointsl s c C sa | j j � } | j d � y | j d � t } Wn t j k
rO t } n X| j d � | S( u Confirm support for STDDEV and related stats functions
SQLite supports STDDEV as an extension package; so
connection.ops.check_aggregate_support() can't unilaterally
rule out support for STDDEV. We need to manually check
whether the call works.
u CREATE TABLE STDDEV_TEST (X INT)u! SELECT STDDEV(*) FROM STDDEV_TESTu DROP TABLE STDDEV_TEST( t
connectiont cursort executet TrueR t
DatabaseErrort False( R. R1 t has_support( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt supports_stddevp s
c C s
t d k S( N( t pytzR ( R. ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt has_zoneinfo_database� s ( t __name__t
__module__R5 t can_use_chunked_readst# test_db_allows_multiple_connectionsR3 t supports_unspecified_pkt supports_timezonest supports_1000_query_parameterst( supports_mixed_date_datetime_comparisonst has_bulk_insertt6 can_combine_inserts_with_and_without_auto_increment_pkt" autocommits_when_autocommit_is_offt atomic_transactionst can_rollback_ddlt supports_paramstyle_pyformatR R/ R7 R9 ( ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR+ Z s t DatabaseOperationsc B s� e Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z
d � Z d
� Z e
d � Z d � Z d
� Z d � Z d � Z RS( c C sH t | � d k r d n d } t | � d k r> | t | � St | � S( u
SQLite has a compile-time default (SQLITE_LIMIT_VARIABLE_NUMBER) of
999 variables per query.
If there is just single field to insert, then we can hit another
limit, SQLITE_MAX_COMPOUND_SELECT which defaults to 500.
i i� i� i ( t len( R. R t objst limit( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt bulk_batch_size� s c C sj t j t j t j f } t j t j t j t j f } t | j
| � rf t | | � rf t d � � n d S( Nuz You cannot use Sum, Avg, StdDev and Variance aggregations on date/time fields in sqlite3 since date/time is saved as text.( R t DateFieldt
DateTimeFieldt TimeFieldR t Sumt Avgt Variancet StdDevt
isinstancet sourcet NotImplementedError( R. t aggregatet
bad_fieldst bad_aggregates( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt check_aggregate_support� s c C s d | j � | f S( Nu django_date_extract('%s', %s)( t lower( R. t lookup_typet
field_name( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt date_extract_sql� s c C s d | | | j | j | j f S( Nu1 django_format_dtdelta(%s, "%s", "%d", "%d", "%d")( t dayst secondst microseconds( R. t sqlt connectort timedelta( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt date_interval_sql� s c C s d | j � | f S( Nu django_date_trunc('%s', %s)( R[ ( R. R\ R] ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt date_trunc_sql� s c C sT t j r7 t d k r7 d d l m } | d � � q7 n d | j � | f | g f S( Ni����( R u1 This query requires pytz, but it isn't installed.u& django_datetime_extract('%s', %s, %%s)( R R R8 R t django.core.exceptionsR R[ ( R. R\ R] t tznameR ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt datetime_extract_sql� s c C sT t j r7 t d k r7 d d l m } | d � � q7 n d | j � | f | g f S( Ni����( R u1 This query requires pytz, but it isn't installed.u$ django_datetime_trunc('%s', %s, %%s)( R R R8 R Rg R R[ ( R. R\ R] Rh R ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt datetime_trunc_sql� s c C s d S( Nu ( ( R. ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt drop_foreignkey_sql� s c C s d S( Nu NULL( ( R. ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt pk_default_value� s c C s* | j d � r" | j d � r" | Sd | S( Nu "u "%s"( t
startswitht endswith( R. t name( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt
quote_name� s c C s d S( Ni����( ( R. ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt no_limit_value� s c C sN g | D]= } d | j d � | j d � | j | j | � � f ^ q } | S( Nu %s %s %s;u DELETEu FROM( t SQL_KEYWORDt SQL_FIELDRp ( R. t stylet tablest sequencest
allow_cascadet tableRb ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt sql_flush� s Gc C se | d k r d St j | � rX t j rI | j t j � j d d � } qX t d � � n t j
| � S( NR uN SQLite backend does not support timezone-aware datetimes when USE_TZ is False.( R R t is_awareR R R! R R t
ValueErrorR t text_type( R. R ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt value_to_db_datetime� s !c C s; | d k r d St j | � r. t d � � n t j | � S( Nu5 SQLite backend does not support timezone-aware times.( R R Rz R{ R R| ( R. R ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt value_to_db_time� s
c C s� | d k r d S| j � } | d k r> t j | j | � � S| rS | j d � s_ | d k ri t | � S| d k r t | � S| d k r� t | � S| d k r� t | � S| S( u� SQLite returns floats when it should be returning decimals,
and gets dates and datetimes wrong.
For consistency with other backends, coerce when required.
u DecimalFieldu IntegerFieldu AutoFieldu DateFieldu
DateTimeFieldu TimeFieldN(
R t get_internal_typet utilt typecast_decimalt
format_numberRn t intR R R
( R. R t fieldt
internal_type( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt convert_values� s !
c so g } | j d d j � f d � | D� � � | j d d j d g t | � � g | d � d j | � S( Nu SELECT %su , c 3 s% | ] } d � j | j � Vq d S( u %%s AS %sN( Rp t column( t .0t f( R. ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pys <genexpr> s u UNION ALL SELECT %su %si u ( t appendt joint extendRI ( R. R t
num_valuest res( ( R. sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt bulk_insert_sql s
2( R: R; RL RZ R^ Re Rf Ri Rj Rk Rl Rp Rq R5 Ry R} R~ R� R� ( ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyRH � s
t DatabaseWrapperc B s� e Z d Z i d d 6d d 6d d 6d d 6d d 6d d
6d d 6d
d 6d d 6d d 6d d 6d d 6d d 6d d 6Z e Z d � Z d � Z d � Z d � Z d � Z d � Z
d � Z d � Z d" d � Z d � Z d! � Z RS(# u sqliteu = %su exactu LIKE %s ESCAPE '\'u iexactu containsu icontainsu REGEXP %su regexu REGEXP '(?i)' || %su iregexu > %su gtu >= %su gteu < %su ltu <= %su lteu
startswithu endswithu istartswithu iendswithc O sw t t | � j | | � t | � | _ t | � | _ t | � | _ t | � | _
t | � | _ t
| � | _ d S( N( t superR� t __init__R+ t featuresRH t opsR t clientR t creationR t
introspectiont BaseDatabaseValidationt
validation( R. t argst kwargs( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR� 3 s c C s� | j } | d s2 d d l m } | d � � n i | d d 6t j t j Bd 6} | j | d � d | k r� | d r� t j d t � n | j i t
d 6� | S(
Nu NAMEi����( R uJ settings.DATABASES is improperly configured. Please supply the NAME value.u databaseu detect_typesu OPTIONSu check_same_threadu� The `check_same_thread` option was provided and set to True. It will be overriden with False. Use the `DatabaseWrapper.allow_thread_sharing` property instead for controlling thread shareability.( t
settings_dictRg R R, t PARSE_DECLTYPESt PARSE_COLNAMESt updateR R R R5 ( R. R� R R� ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt get_connection_params= s
c C s� t j | � } | j d d t � | j d d t � | j d d t � | j d d t � | j d d t � | j d d t � | S(
Nu django_date_extracti u django_date_truncu django_datetime_extracti u django_datetime_truncu regexpu django_format_dtdeltai ( R, t connectt create_functiont _sqlite_date_extractt _sqlite_date_trunct _sqlite_datetime_extractt _sqlite_datetime_trunct _sqlite_regexpt _sqlite_format_dtdelta( R. t conn_paramst conn( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt get_new_connectionZ s c C s d S( N( ( R. ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt init_connection_stated s c C s | j j d t � S( Nt factory( R0 R1 t SQLiteCursorWrapper( R. ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt
create_cursorg s c C s1 | j � | j d d k r- t j | � n d S( Nu NAMEu :memory:( t validate_thread_sharingR� t BaseDatabaseWrappert close( R. ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR� j s
c C s | j j o | j S( N( R� R/ t in_atomic_block( R. ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt _savepoint_allowedr s
c C s5 | r d } n d } | j � | | j _ Wd QXd S( Nu ( R t wrap_database_errorsR0 t isolation_level( R. t
autocommitt level( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt _set_autocommit~ s
c
C s | j � } | d k r- | j j | � } n x� | D]� } | j j | | � } | s[ q4 n | j j | | � } x� | D] \ } } } | j d | | | | | | | | f � xD | j � D]6 } t j d | | d | | | d | | f � � q� Wqw Wq4 Wd S( u�
Checks 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.
Raises an IntegrityError on the first invalid foreign key reference encountered (if any) and provides
detailed information about the invalid reference in the error message.
Backends can override this method if they can more directly apply constraint checking (e.g. via "SET CONSTRAINTS
ALL IMMEDIATE")
u
SELECT REFERRING.`%s`, REFERRING.`%s` FROM `%s` as REFERRING
LEFT JOIN `%s` as REFERRED
ON (REFERRING.`%s` = REFERRED.`%s`)
WHERE REFERRING.`%s` IS NOT NULL AND REFERRED.`%s` IS NULLu� 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.i i N(
R1 R R� t table_namest get_primary_key_columnt get_key_columnsR2 t fetchallR t IntegrityError(
R. R� R1 t
table_namet primary_key_column_namet key_columnst column_namet referenced_table_namet referenced_column_namet bad_row( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt check_constraints� s"
c C s t S( N( R3 ( R. ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt is_usable� s c C s | j � j d � d S( u�
Start a transaction explicitly in autocommit mode.
Staying in autocommit mode works around a bug of sqlite3 that breaks
savepoints when autocommit is disabled.
u BEGINN( R1 R2 ( R. ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt# _start_transaction_under_autocommit� s N( R: R; t vendort operatorsR, R� R� R� R� R� R� R� R� R R� R� R� ( ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR� s8
" u (?<!%)%sR� c B s, e Z d Z d d � Z d � Z d � Z RS( u�
Django uses "format" style placeholders, but pysqlite2 uses "qmark" style.
This fixes it -- but note that if you want to use a literal "%s" in a query,
you'll need to use "%%s".
c C sD | d k r t j j | | � S| j | � } t j j | | | � S( N( R R, t CursorR2 t
convert_query( R. t queryt params( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR2 � s c C s% | j | � } t j j | | | � S( N( R� R, R� t executemany( R. R� t
param_list( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR� � s c C s t j d | � j d d � S( Nu ?u %%u %( t FORMAT_QMARK_REGEXt subR ( R. R� ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR� � s N( R: R; t __doc__R R2 R� R� ( ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR� � s c C sm | d k r d Sy t j | � } Wn t t f k
r= d SX| d k r\ | j � d d St | | � Sd S( Nu week_dayi i ( R R� t typecast_timestampR{ t TypeErrort
isoweekdayt getattr( R\ R ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR� � s c C s� y t j | � } Wn t t f k
r- d SX| d k rE d | j S| d k re d | j | j f S| d k r� d | j | j | j f Sd S( Nu yearu %i-01-01u monthu
%i-%02i-01u dayu %i-%02i-%02i( R� R� R{ R� R t yeart montht day( R\ R ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR� � s c C s� | d k r d Sy t j | � } Wn t t f k
r= d SX| d k rh t j | t j | � � } n | d k r� | j � d d St | | � Sd S( Nu week_dayi i (
R R� R� R{ R� R t localtimeR8 R� R� ( R\ R Rh ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR� � s c C sO y t j | � } Wn t t f k
r- d SX| d k rX t j | t j | � � } n | d k ro d | j S| d k r� d | j | j f S| d k r� d | j | j | j
f S| d k r� d | j | j | j
| j f S| d k rd
| j | j | j
| j | j f S| d k rKd | j | j | j
| j | j | j
f Sd S(
Nu yearu %i-01-01 00:00:00u monthu %i-%02i-01 00:00:00u dayu %i-%02i-%02i 00:00:00u houru %i-%02i-%02i %02i:00:00u minuteu %i-%02i-%02i %02i:%02i:00u secondu %i-%02i-%02i %02i:%02i:%02i( R� R� R{ R� R R R� R8 R� R� R� t hourt minutet second( R\ R Rh ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR� � s$ & c C s� yc t j | � } t j t | � t | � t | � � } | j � d k rX | | } n
| | } Wn t t f k
r} d SXt | � S( Nu +(
R� R� t datetimeRd R� t stripR{ R� R R# ( R R� R_ t secst usecst delta( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR� s '
c C s, | d k r( t t j | t | � � � St S( N( R t boolt ret searchR R5 ( t
re_patternt re_string( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyR� s ( i i i (I R� t
__future__R R� t decimalR R� t django.dbR t django.db.backendst! django.db.backends.sqlite3.clientR t# django.db.backends.sqlite3.creationR t( django.db.backends.sqlite3.introspectionR t django.db.modelsR t django.db.models.sqlR t django.utils.dateparseR R R
t django.utils.encodingR t django.utils.functionalR t django.utils.safestringR
t django.utilsR R t pysqlite2R R, t ImportErrort sqlite3t excRg R R8 R R4 R� R R% R* t register_converterR# R� R� t register_adaptert Decimalt rev_typecast_decimalt PY2t version_infot BaseDatabaseFeaturesR+ t BaseDatabaseOperationsRH R� R� t compileR� R� R� R� R� R� R� R� R� ( ( ( sA /tmp/pip-install-XxeQeY/django/django/db/backends/sqlite3/base.pyt <module> st
-��