File manager - Edit - /usr/local/CyberPanel/lib/python3.10/site-packages/django/db/backends/sqlite3/__pycache__/base.cpython-310.pyc
Back
o �h<6 � @ s� d Z ddlZddlZddlZddlmZ ddlmZmZ ddl m Z ddl m Z ddlmZ ddlmZ dd lmZ dd lmZmZmZ dd lmZ d d lmZ d dl m Z d dl m Z d dl!m"Z" d dl#m$Z$ d dl%m&Z& d dl'm(Z( dd� Z)dd� Z*dd� Z+e �,ddj-� e �,d e)e�� e �,d e)e�� e �,d e)e�� e �,d e)e�� e �.ej/e0� e �.ej1e*� e �.eje+� G d d!� d!e�Z2ed"�Z3G d#d$� d$e j4�Z5dS )%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 � fdd�S )zR Convert bytestrings from Python's sqlite3 interface to a regular string. c s � | � � �S �N)�decode)�s�� conv_func� �U/usr/local/CyberPanel/lib/python3.10/site-packages/django/db/backends/sqlite3/base.py�<lambda> s zdecoder.<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 Zd ZdZdZi dd�dd�dd�dd �d d �d d �dd�dd�dd�dd �dd �dd�dd�dd�dd�d d �d d �dd d!d"d dd#d d$d%d&� �Zd'd(d'd'd)�Zd*d*d*d+�Zd,d-d-d-d.d/d0d1d2d3d-d-d-d-d4�Zd5Z d6d7d8d9d:d;d<�Z e Z e Z eZeZeZeZeZd=d>� Zd?d@� ZedAdB� �ZdXdDdE�Z edFdG� �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' � CharFieldzvarchar(%(max_length)s)� DateFieldr) � DateTimeFieldr+ � DecimalField�decimal� DurationField�bigint� FileField� FilePathField� FloatField�real� IntegerField�BigIntegerField�IPAddressFieldzchar(15)�GenericIPAddressFieldzchar(39)� JSONField�textzbigint unsignedzinteger unsignedzsmallint unsigned�smallintr* zchar(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= %szLIKE %s ESCAPE '\'z REGEXP %szREGEXP '(?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 '\'zLIKE {} || '%%' ESCAPE '\'z!LIKE UPPER({}) || '%%' ESCAPE '\'zLIKE '%%' || {} ESCAPE '\'z!LIKE '%%' || UPPER({}) ESCAPE '\')rU rV r] r_ r^ r` c C sd | j }|d s td��|d tjtjB d�|d �}d|v r(|d r(t�dt� |�ddd �� |S ) N�NAMEzJsettings.DATABASES is improperly configured. Please supply the NAME value.)�database� detect_types�OPTIONS�check_same_threadz�The `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 jS r )rh �sqlite_version_info�ro r r r �get_database_version� r$ z$DatabaseWrapper.get_database_versionc C s0 t jdi |��}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 jtd�S )N)�factory)� connection�cursor�SQLiteCursorWrapper)ro �namer r r � create_cursor� s z DatabaseWrapper.create_cursorc C s" | � � | �� st�| � d S d S r )�validate_thread_sharing�is_in_memory_dbr �closers r r r r� � s �zDatabaseWrapper.closec C s | j S r )�in_atomic_blockrs r r r �_savepoint_allowed� s z"DatabaseWrapper._savepoint_allowedc C sB |rd }nd}| j � || j_W d � d S 1 sw 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 � n1 s w Y t|� S )NzPRAGMA foreign_keys = OFFzPRAGMA 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 sw Y d S )Nru �r~ rx )ro r~ r r r �enable_constraint_checking� s "�z*DatabaseWrapper.enable_constraint_checkingc s� �� � �q� |du r� �d��� }n t�� �fdd�|D ��}|D ]L\}}}}� �d�j�|� ��� | }|dd� \}} �j�� |�} � �d�j�| ��j�|��j�|�f |f�� � \} } t d || ||| || f ��W d � dS 1 sxw Y dS ) 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_checkc 3 s* � | ]}� � d �j�|� ��� V qdS )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>zPRAGMA foreign_key_list(%s)� � z'SELECT %s, %s FROM %s WHERE rowid = %%sz�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.) 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 dS )NTr rs r r r � is_usable" s zDatabaseWrapper.is_usablec C s | � � �d� dS )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 �| jd �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 Zd ZdZd � fdd� Z� fdd�Zdd�dd �Z� ZS ) 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�rt|�nd }| j||d�}t � �||�S �N�� param_names)�superrx � isinstancer �list� convert_query)ro �query�paramsr� �� __class__r r rx B s zSQLiteCursorWrapper.executec sR t t|��\}}t|d � }rt|t�rt|�}nd }| 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 rt �d|��dd�S |dd� |D � S )N�?z%%�%c S s i | ]}|d |� ��qS )�: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 ~
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings