OwlCyberSecurity - MANAGER
Edit File: base.cpython-39.pyc
a ���e�o � @ s6 d dl Z d dlZd dlZd dlZd dlZd dlZd dlZd dlmZ d dl m Z d dl m Z z d dl Z W n ey� d dlm Z Y n0 d dlmZ d dlmZ d dlmZmZmZ d d lmZ d d lmZ d d l m Z d d l m Z d d l m!Z! d dl"m#Z# d dl$m%Z% dZ&e'� a(e�)d�Z*dd� Z+G dd� d�Z,dS )� N)�deque)�contextmanager)�debug_transaction)�zoneinfo)�settings)�ImproperlyConfigured)�DEFAULT_DB_ALIAS� DatabaseError�NotSupportedError)�utils)�BaseDatabaseValidation)�connection_created)�TransactionManagementError��DatabaseErrorWrapper)� async_unsafe)�cached_propertyZ __no_db__zdjango.db.backends.basec C s" t jrdd l}|�| �S t�| �S �Nr )r ZUSE_DEPRECATED_PYTZ�pytz�timezoner ZZoneInfo)�tznamer � r �]/home/gouroczh/virtualenv/pat/3.9/lib/python3.9/site-packages/django/db/backends/base/base.py�timezone_constructor$ s r c @ s� e Zd ZdZi Zi Zi ZdZdZdZ dZ dZ dZ dZ dZdZeZdZefdd�Zdd� Zd d � Zed d � �Zed d� �Zedd� �Zedd� �Z dd� Z dd� Z dd� Z dd� Z dd � Z!d�d d �Z"e#d d � �Z$d!d"� Z%e#d#d$� �Z&d%d&� Z'd�d'd(�Z(d)d*� Z)d+d,� Z*d-d.� Z+e#d/d0� �Z,e#d1d2� �Z-e#d3d4� �Z.e#d5d6� �Z/d7d8� Z0d9d:� Z1d;d<� Z2d=d>� Z3e#d?d@� �Z4e#dAdB� �Z5e#dCdD� �Z6e#dEdF� �Z7dGdH� Z8dIdJ� Z9d�dLdM�Z:dNdO� Z;dPdQ� Z<dRdS� Z=dTdU� Z>e?dVdW� �Z@dXdY� ZAdZd[� ZBd�d\d]�ZCd^d_� ZDd`da� ZEdbdc� ZFeddde� �ZGdfdg� ZHdhdi� ZIdjdk� ZJdldm� ZKedndo� �ZLdpdq� ZMdrds� ZNdtdu� ZOe?dvdw� �ZPe?dxdy� �ZQdzd{� ZRd�d|d}�ZSd~d� ZTe?d�d�� �ZUd�d�d��ZVdS )��BaseDatabaseWrapperz Represent a database connection.N�unknowni(# c C s� d | _ || _|| _t| jd�| _d| _d| _d| _d| _ g | _ g | _ d| _ d| _ d | _d | _d| _d| _d| _d| _t�� | _d| _t�� | _g | _d| _ g | _ | � | �| _ | � | �| _!| �"| �| _#| �$| �| _%| �&| �| _'| �(| �| _)d S )N)�maxlenFr T)*� connection� settings_dict�aliasr � queries_limit� queries_log�force_debug_cursor� autocommit�in_atomic_block�savepoint_state� savepoint_ids� atomic_blocksZcommit_on_exit�needs_rollback� rollback_exc�close_at�closed_in_transaction�errors_occurred�health_check_enabled�health_check_done� threading�Lock�_thread_sharing_lock�_thread_sharing_count�_thread� get_ident� _thread_ident� run_on_commit�%run_commit_hooks_on_set_autocommit_on�execute_wrappers� client_class�client�creation_classZcreation�features_class�features�introspection_classZ introspection� ops_class�ops�validation_classZ validation)�selfr r r r r �__init__C s< z BaseDatabaseWrapper.__init__c C s d| j j� d| j�d| j�d�S )N�<z vendor=z alias=�>)� __class__� __qualname__�vendorr �rB r r r �__repr__� s ���z BaseDatabaseWrapper.__repr__c C s dS )z Ensure the connection's timezone is set to `self.timezone_name` and return whether it changed or not. Fr rI r r r �ensure_timezone� s z#BaseDatabaseWrapper.ensure_timezonec C s2 t js dS | jd du r tjjS t| jd �S dS )a Return a tzinfo of the database connection time zone. This is only used when time zone support is enabled. When a datetime is read from the database, it is always returned in this time zone. When the database backend supports time zones, it doesn't matter which time zone Django uses, as long as aware datetimes are used everywhere. Other users connecting to the database can choose their own time zone. When the database backend doesn't support time zones, the time zone Django uses may be constrained by the requirements of other users of the database. N� TIME_ZONE)r �USE_TZr �datetimer �utcr rI r r r r � s z BaseDatabaseWrapper.timezonec C s, t js t jS | jd du r dS | jd S dS )zC Name of the time zone of the database connection. rL N�UTC)r rM rL r rI r r r � timezone_name� s z!BaseDatabaseWrapper.timezone_namec C s | j p tjS �N)r" r �DEBUGrI r r r �queries_logged� s z"BaseDatabaseWrapper.queries_loggedc C s0 t | j�| jjkr&t�d�| jj�� t| j�S )NzLLimit for query logging exceeded, only the last {} queries will be returned.)�lenr! r �warnings�warn�format�listrI r r r �queries� s ��zBaseDatabaseWrapper.queriesc C s t d��dS )z)Return a tuple of the database's version.zNsubclasses of BaseDatabaseWrapper may require a get_database_version() method.N��NotImplementedErrorrI r r r �get_database_version� s �z(BaseDatabaseWrapper.get_database_versionc C sd | j jdur`| �� | j jk r`d�tt| �� ��}d�tt| j j��}t| j� d|� d|� d���dS )zk Raise an error if the database version isn't supported by this version of Django. N�.� z or later is required (found z).)r= Zminimum_database_versionr] �join�map�strr � display_name)rB Z db_versionZmin_db_versionr r r � check_database_version_supported� s ����z4BaseDatabaseWrapper.check_database_version_supportedc C s t d��dS )z<Return a dict of parameters suitable for get_new_connection.zNsubclasses of BaseDatabaseWrapper may require a get_connection_params() methodNr[ rI r r r �get_connection_params� s �z)BaseDatabaseWrapper.get_connection_paramsc C s t d��dS )z"Open a connection to the database.zKsubclasses of BaseDatabaseWrapper may require a get_new_connection() methodNr[ )rB � conn_paramsr r r �get_new_connection� s �z&BaseDatabaseWrapper.get_new_connectionc C s" | j tvr | �� t�| j � dS )z,Initialize the database connection settings.N)r �RAN_DB_VERSION_CHECKrd �addrI r r r �init_connection_state� s z)BaseDatabaseWrapper.init_connection_statec C s t d��dS )z9Create a cursor. Assume that a connection is established.zFsubclasses of BaseDatabaseWrapper may require a create_cursor() methodNr[ �rB �namer r r � create_cursor� s �z!BaseDatabaseWrapper.create_cursorc C s� | � � d| _g | _g | _d| _| jd | _| jd }|du rBdn t�� | | _ d| _ d| _ d| _ | � � }| �|�| _| �| jd � | �� tj| j| d� g | _dS )z>Connect to the database. Assume that the connection is closed.FZCONN_HEALTH_CHECKSZ CONN_MAX_AGENT� AUTOCOMMIT)Zsenderr )�check_settingsr$ r& r' r( r r- �time� monotonicr* r+ r, r. re rg r �set_autocommitrj r �sendrF r6 )rB Zmax_agerf r r r �connect� s" zBaseDatabaseWrapper.connectc C s& | j d d ur"tjs"td| j ��d S )NrL z=Connection '%s' cannot set TIME_ZONE because USE_TZ is False.)r r rM r r rI r r r ro s ��z"BaseDatabaseWrapper.check_settingsc C s< | j du r8| j� | �� W d � n1 s.0 Y dS )z;Guarantee that a connection to the database is established.N)r �wrap_database_errorsrt rI r r r �ensure_connection s z%BaseDatabaseWrapper.ensure_connectionc C s( | � � | jr| �|�}n | �|�}|S )zY Validate the connection is usable and perform database cursor wrapping. )�validate_thread_sharingrT �make_debug_cursor� make_cursor)rB �cursorZwrapped_cursorr r r �_prepare_cursor% s z#BaseDatabaseWrapper._prepare_cursorc C sJ | � � | �� | j� | �| �|��W d � S 1 s<0 Y d S rR )� close_if_health_check_failedrv ru r{ rm rk r r r �_cursor0 s zBaseDatabaseWrapper._cursorc C sv | j d urrt| d��N | j�( | j �� W d � W d � S 1 sJ0 Y W d � n1 sh0 Y d S )NZCOMMIT)r r ru �commitrI r r r �_commit6 s zBaseDatabaseWrapper._commitc C sv | j d urrt| d��N | j�( | j �� W d � W d � S 1 sJ0 Y W d � n1 sh0 Y d S )NZROLLBACK)r r ru �rollbackrI r r r � _rollback; s z BaseDatabaseWrapper._rollbackc C s> | j d ur:| j� | j �� W d � S 1 s00 Y d S rR )r ru �closerI r r r �_close@ s zBaseDatabaseWrapper._closec C s | � � S )z3Create a cursor, opening a connection if necessary.)r} rI r r r rz G s zBaseDatabaseWrapper.cursorc C s( | � � | �� | �� d| _d| _dS )z.Commit a transaction and reset the dirty flag.FTN)rw �validate_no_atomic_blockr r, r7 rI r r r r~ L s zBaseDatabaseWrapper.commitc C s. | � � | �� | �� d| _d| _g | _dS )z1Roll back a transaction and reset the dirty flag.FN)rw r� r� r, r( r6 rI r r r r� V s z BaseDatabaseWrapper.rollbackc C sj | � � g | _| js | jdu r"dS z&| �� W | jrBd| _d| _qfd| _n | jr^d| _d| _nd| _0 dS )z%Close the connection to the database.NT)rw r6 r+ r r� r$ r( rI r r r r� a s �zBaseDatabaseWrapper.closec C s> | � � �"}|�| j�|�� W d � n1 s00 Y d S rR )rz �executer@ Zsavepoint_create_sql�rB �sidrz r r r � _savepointw s z BaseDatabaseWrapper._savepointc C s> | � � �"}|�| j�|�� W d � n1 s00 Y d S rR )rz r� r@ Zsavepoint_rollback_sqlr� r r r �_savepoint_rollback{ s z'BaseDatabaseWrapper._savepoint_rollbackc C s> | � � �"}|�| j�|�� W d � n1 s00 Y d S rR )rz r� r@ Zsavepoint_commit_sqlr� r r r �_savepoint_commit s z%BaseDatabaseWrapper._savepoint_commitc C s | j jo| �� S rR )r= Zuses_savepoints�get_autocommitrI r r r �_savepoint_allowed� s z&BaseDatabaseWrapper._savepoint_allowedc C sV | � � s dS t�� }t|��dd�}| jd7 _d|| jf }| �� | �|� |S )z� Create a savepoint inside the current transaction. Return an identifier for the savepoint that will be used for the subsequent rollback or commit. Do nothing if savepoints are not supported. N�-� � zs%s_x%d)r� r3 r4 rb �replacer% rw r� )rB Z thread_ident�tidr� r r r � savepoint� s z BaseDatabaseWrapper.savepointc s8 | � � s dS | �� | �� � � fdd�| jD �| _dS )zW Roll back to a savepoint. Do nothing if savepoints are not supported. Nc s$ g | ] \}}}� |vr|||f�qS r r )�.0Zsids�func�robust�r� r r � <listcomp>� s �z:BaseDatabaseWrapper.savepoint_rollback.<locals>.<listcomp>)r� rw r� r6 �rB r� r r� r �savepoint_rollback� s �z&BaseDatabaseWrapper.savepoint_rollbackc C s" | � � s dS | �� | �|� dS )zR Release a savepoint. Do nothing if savepoints are not supported. N)r� rw r� r� r r r �savepoint_commit� s z$BaseDatabaseWrapper.savepoint_commitc C s d| _ dS )zY Reset the counter used to generate unique savepoint ids in this thread. r N)r% rI r r r �clean_savepoints� s z$BaseDatabaseWrapper.clean_savepointsc C s t d��dS )zR Backend-specific implementation to enable or disable autocommit. zHsubclasses of BaseDatabaseWrapper may require a _set_autocommit() methodNr[ )rB r# r r r �_set_autocommit� s �z#BaseDatabaseWrapper._set_autocommitc C s | � � | jS )zGet the autocommit state.)rv r# rI r r r r� � s z"BaseDatabaseWrapper.get_autocommitFc C s� | � � | �� | �� |o*| o*t| d�}|r:| �� nD|rJ| �|� n4t| d�� | �|� W d � n1 st0 Y || _|r�| jr�| � � d| _dS )a� Enable or disable autocommit. The usual way to start a transaction is to turn autocommit off. SQLite does not properly start a transaction when disabling autocommit. To avoid this buggy behavior and to actually enter a new transaction, an explicit BEGIN is required. Using force_begin_transaction_with_broken_autocommit=True will issue an explicit BEGIN with SQLite. This option will be ignored for other backends. �#_start_transaction_under_autocommitZBEGINNF) r� r| rv �hasattrr� r� r r# r7 �run_and_clear_commit_hooks)rB r# Z.force_begin_transaction_with_broken_autocommitZ"start_transaction_under_autocommitr r r rr � s$ �� ( z"BaseDatabaseWrapper.set_autocommitc C s | j std��| jS )z9Get the "needs rollback" flag -- for *advanced use* only.�<The rollback flag doesn't work outside of an 'atomic' block.�r$ r r( rI r r r � get_rollback� s �z BaseDatabaseWrapper.get_rollbackc C s | j std��|| _dS )zT Set or unset the "needs rollback" flag -- for *advanced use* only. r� Nr� )rB r� r r r � set_rollback s �z BaseDatabaseWrapper.set_rollbackc C s | j rtd��dS )z,Raise an error if an atomic block is active.z3This is forbidden when an 'atomic' block is active.N)r$ r rI r r r r� s �z,BaseDatabaseWrapper.validate_no_atomic_blockc C s | j rtd�| j�d S )NzlAn error occurred in the current transaction. You can't execute queries until the end of the 'atomic' block.)r( r r) rI r r r � validate_no_broken_transaction s ��z2BaseDatabaseWrapper.validate_no_broken_transactionc c s2 | � � }zdV W |r.| �� n|r,| �� 0 dS )z: Disable foreign key constraint checking. N)�disable_constraint_checking�enable_constraint_checking)rB �disabledr r r �constraint_checks_disabled s �z.BaseDatabaseWrapper.constraint_checks_disabledc C s dS )z� Backends can implement as needed to temporarily disable foreign key constraint checking. Should return True if the constraints were disabled and will need to be reenabled. Fr rI r r r r� & s z/BaseDatabaseWrapper.disable_constraint_checkingc C s dS )zh Backends can implement as needed to re-enable foreign key constraint checking. Nr rI r r r r� . s z.BaseDatabaseWrapper.enable_constraint_checkingc C s dS )z� Backends can override this method if they can apply constraint checking (e.g. via "SET CONSTRAINTS ALL IMMEDIATE"). Should raise an IntegrityError if any invalid foreign key references are encountered. Nr )rB Z table_namesr r r �check_constraints5 s z%BaseDatabaseWrapper.check_constraintsc C s t d��dS )a Test if the database connection is usable. This method may assume that self.connection is not None. Actual implementations should take care not to raise exceptions as that may prevent Django from recycling unusable connections. zCsubclasses of BaseDatabaseWrapper may require an is_usable() methodNr[ rI r r r � is_usable? s �z BaseDatabaseWrapper.is_usablec C s4 | j du s| jr| jrdS | �� s*| �� d| _dS )z5Close existing connection if it fails a health check.NT)r r- r. r� r� rI r r r r| L s ���z0BaseDatabaseWrapper.close_if_health_check_failedc C s~ | j durzd| _| �� | jd kr.| �� dS | jrV| �� rJd| _d| _n | �� dS | jdurzt� � | jkrz| �� dS dS )z Close the current connection if unrecoverable errors have occurred or if it outlived its maximum age. NFrn T) r r. r� r r� r, r� r* rp rq rI r r r � close_if_unusable_or_obsoleteY s z1BaseDatabaseWrapper.close_if_unusable_or_obsoletec C s4 | j � | jdkW d � S 1 s&0 Y d S r �r1 r2 rI r r r �allow_thread_sharingv s z(BaseDatabaseWrapper.allow_thread_sharingc C s8 | j � | jd7 _W d � n1 s*0 Y d S )Nr� r� rI r r r �inc_thread_sharing{ s z&BaseDatabaseWrapper.inc_thread_sharingc C sJ | j �0 | jdkrtd��| jd8 _W d � n1 s<0 Y d S )Nr z5Cannot decrement the thread sharing count below zero.r� )r1 r2 � RuntimeErrorrI r r r �dec_thread_sharing s �z&BaseDatabaseWrapper.dec_thread_sharingc C s2 | j s.| jt�� ks.td| j| jt�� f ��dS )a3 Validate that the connection isn't accessed by another thread than the one which originally created it, unless the connection was explicitly authorized to be shared between threads (via the `inc_thread_sharing()` method). Raise an exception if the validation fails. z�DatabaseWrapper objects created in a thread can only be used in that same thread. The object with alias '%s' was created in thread id %s and this is thread id %s.N)r� r5 r3 r4 r r rI r r r rw � s ��z+BaseDatabaseWrapper.validate_thread_sharingc C s dS )z~ Hook to do any database check or preparation, generally called before migrating a project or an app. Nr rI r r r �prepare_database� s z$BaseDatabaseWrapper.prepare_databasec C s t | �S )z� Context manager and decorator that re-throws backend-specific database exceptions using Django's common wrappers. r rI r r r ru � s z(BaseDatabaseWrapper.wrap_database_errorsc C s | � � S )z� Return a cursor that tries to avoid caching in the database (if supported by the database), otherwise return a regular cursor. )rz rI r r r �chunked_cursor� s z"BaseDatabaseWrapper.chunked_cursorc C s t �|| �S )z:Create a cursor that logs all queries in self.queries_log.)r ZCursorDebugWrapper�rB rz r r r rx � s z%BaseDatabaseWrapper.make_debug_cursorc C s t �|| �S )z&Create a cursor without debug logging.)r Z CursorWrapperr� r r r ry � s z BaseDatabaseWrapper.make_cursorc c s\ | j du }z>| �� �}|V W d � n1 s00 Y W |rX| �� n|rV| �� 0 dS )a8 Context manager that ensures that a connection is established, and if it opened one, closes it to avoid leaving a dangling connection. This is useful for operations outside of the request-response cycle. Provide a cursor: with self.temporary_connection() as cursor: ... N)r rz r� )rB Z must_closerz r r r �temporary_connection� s & �z(BaseDatabaseWrapper.temporary_connectionc c sf | j i | j�ddi�td�}z:|�� �}|V W d � n1 sB0 Y W |�� n |�� 0 dS )aq Return a cursor from an alternative connection to be used when there is no need to access the main database, specifically for test db creation/deletion. This also prevents the production database from being exposed to potential child threads while (or after) the test database is destroyed. Refs #10868, #17786, #16969. �NAMEN)r )rF r � NO_DB_ALIASrz r� )rB �connrz r r r � _nodb_cursor� s &z BaseDatabaseWrapper._nodb_cursorc O s* | j du rtd��| j | g|�R i |��S )zG Return a new instance of this backend's SchemaEditor. NzFThe SchemaEditorClass attribute of this database wrapper is still None)�SchemaEditorClassr\ )rB �args�kwargsr r r � schema_editor� s �z!BaseDatabaseWrapper.schema_editorc C s� t |�std��| jr0| j�t| j�||f� nh| �� sBtd��nV|r�z |� W q� t y� } z&t j d|j � d�|dd� W Y d }~q�d }~0 0 n|� d S )Nz*on_commit()'s callback must be a callable.z;on_commit() cannot be used in manual transaction management�Error calling z in on_commit() (%s).T��exc_info) �callable� TypeErrorr$ r6 �append�setr& r� r � Exception�logger�errorrG )rB r� r� �er r r � on_commit� s$ � � z BaseDatabaseWrapper.on_commitc C s� | � � | j}g | _|r�|�d�\}}}|rxz |� W q~ tyt } z&tjd|j� d�|dd� W Y d }~q~d }~0 0 q|� qd S )Nr r� z( in on_commit() during transaction (%s).Tr� )r� r6 �popr� r� r� rG )rB Zcurrent_run_on_commit�_r� r� r� r r r r� � s � z.BaseDatabaseWrapper.run_and_clear_commit_hooksc c s2 | j �|� zdV W | j �� n | j �� 0 dS )z| Return a context manager under which the wrapper is applied to suitable database query executions. N)r8 r� r� )rB �wrapperr r r �execute_wrapper s z#BaseDatabaseWrapper.execute_wrapperc C s( t �| j�}|du r| j}t| �||�S )zy Return a copy of this connection. For tests that require two connections to the same database. N)�copy�deepcopyr r �type)rB r r r r r r� s zBaseDatabaseWrapper.copy)N)N)F)N)F)N)W�__name__� __module__rG �__doc__� data_typesZdata_types_suffixZdata_type_check_constraintsr@ rH rc r� r9 r; r< r> r? r rA r r rC rJ rK r r rQ �propertyrT rZ r] rd re rg rj rm r rt ro rv r{ r} r r� r� rz r~ r� r� r� r� r� r� r� r� r� r� r� r� rr r� r� r� r� r r� r� r� r� r� r| r� r� r� r� rw r� ru r� rx ry r� r� r� r� r� r� r� r r r r r , s� D � % r )-r3 r� rN �loggingr/ rp rV � collectionsr � contextlibr Zdjango.db.backends.utilsr r � ImportErrorZ backportsZ django.confr Zdjango.core.exceptionsr Z django.dbr r r Zdjango.db.backendsr Z"django.db.backends.base.validationr Zdjango.db.backends.signalsr Zdjango.db.transactionr Zdjango.db.utilsr Zdjango.utils.asyncior Zdjango.utils.functionalr r� r� rh � getLoggerr� r r r r r r �<module> s8