File manager - Edit - /usr/local/CyberCP/lib/python3.10/site-packages/django/db/backends/sqlite3/__pycache__/operations.cpython-310.pyc
Back
o �hAB � @ s� d dl Z d dlZd dlZd dlmZ d dlmZ d dlmZ d dl m Z d dl m Z m Z mZ d dlmZ d dlmZ d d lmZ d d lmZ d d lmZmZmZ d d lm Z G d d� de�Z dS )� N)� lru_cache)�chain)�settings)� FieldError)� DatabaseError�NotSupportedError�models)�BaseDatabaseOperations)� OnConflict)�Col)�timezone)� parse_date�parse_datetime� parse_time)�cached_propertyc s� e Zd ZdZddd�ZdZeg d��Zdd� Zdd � Z d d � Z d d � Z dd� Z dWdd�Z dWdd�Zdd� Zdd� Zdd� Zdd � Zd d � Zd d � Zd!d"� Zd#d$� Zd%d&� Zd'd(� Zd)d*� Zd+d,� Zed-d.� �Z d/d/d0�d1d2�Z d3d4� Z d5d6� Z d7d8� Z � fd9d:�Z!d;d<� Z"d=d>� Z#d?d@� Z$dAdB� Z%dCdD� Z&dEdF� Z'dGdH� Z(� fdIdJ�Z)dKdL� Z*dMdN� Z+dOdP� Z,dW� fdQdR� Z-dSdT� Z.� fdUdV�Z/� Z0S )X�DatabaseOperations�text�TEXT)� DateField� DateTimeFieldzEXPLAIN QUERY PLAN)�null�false�truec C s6 t |�dkrdS t |�dkr| jjjt |� S t |�S )z� SQLite has a compile-time default (SQLITE_LIMIT_VARIABLE_NUMBER) of 999 variables per query. If there's only a single field to insert, the limit is 500 (SQLITE_MAX_COMPOUND_SELECT). � i� )�len� connection�features�max_query_params)�self�fields�objs� r! �X/usr/local/CyberCP/lib/python3.10/site-packages/django/db/backends/sqlite3/operations.py�bulk_batch_size s z"DatabaseOperations.bulk_batch_sizec C s� t jt jt jf}t jt jt jt jf}t||�r8|� � D ] }z|j }W n t t fy- Y qw t||�r7t d��qt|t j�rL|jrNt|j�dkrPt d��d S d S d S )Nz{You cannot use Sum, Avg, StdDev, and Variance aggregations on date/time fields in sqlite3 since date/time is saved as text.r zTSQLite doesn't support DISTINCT on aggregate functions accepting multiple arguments.)r r r � TimeField�Sum�Avg�Variance�StdDev� isinstance�get_source_expressions� output_field�AttributeErrorr r � Aggregate�distinctr �source_expressions)r � expression� bad_fields�bad_aggregates�exprr+ r! r! r" �check_expression_support, s0 � �� ����z+DatabaseOperations.check_expression_supportc C � d|� d�|� � g|�R fS )z� Support EXTRACT with a user-defined function django_date_extract() that's registered in connect(). Use single quotes because this is a string and could otherwise cause a collision with a field name. zdjango_date_extract(%s, �)��lower�r � lookup_type�sql�paramsr! r! r" �date_extract_sqlH s z#DatabaseOperations.date_extract_sqlc C s |� � S )z� Given a cursor object that has just performed an INSERT...RETURNING statement into a table, return the list of returned data. )�fetchall)r �cursorr! r! r" �fetch_returned_insert_rowsP s z-DatabaseOperations.fetch_returned_insert_rowsc C s |S )z>Do nothing since formatting is handled in the custom function.r! )r r; r! r! r" � format_for_duration_arithmeticW � z1DatabaseOperations.format_for_duration_arithmeticNc C �& d|� d�|� � g|�| �|��R fS )Nzdjango_date_trunc(%s, � , %s, %s)�r8 �_convert_tznames_to_sql�r r: r; r< �tznamer! r! r" �date_trunc_sql[ � ���z!DatabaseOperations.date_trunc_sqlc C rC )Nzdjango_time_trunc(%s, rD rE rG r! r! r" �time_trunc_sqlb rJ z!DatabaseOperations.time_trunc_sqlc C s |r t jr || jjfS dS �N)NN)r �USE_TZr � timezone_name)r rH r! r! r" rF i s z*DatabaseOperations._convert_tznames_to_sqlc C � d|� d�g |�| � |��R fS )Nzdjango_datetime_cast_date(rD �rF �r r; r< rH r! r! r" �datetime_cast_date_sqln � ��z)DatabaseOperations.datetime_cast_date_sqlc C rO )Nzdjango_datetime_cast_time(rD rP rQ r! r! r" �datetime_cast_time_sqlt rS z)DatabaseOperations.datetime_cast_time_sqlc C rC )Nz django_datetime_extract(%s, rD rE rG r! r! r" �datetime_extract_sqlz rJ z'DatabaseOperations.datetime_extract_sqlc C rC )Nzdjango_datetime_trunc(%s, rD rE rG r! r! r" �datetime_trunc_sql� rJ z%DatabaseOperations.datetime_trunc_sqlc C r5 )Nzdjango_time_extract(%s, r6 r7 r9 r! r! r" �time_extract_sql� s z#DatabaseOperations.time_extract_sqlc C � dS )N�NULLr! �r r! r! r" �pk_default_value� � z#DatabaseOperations.pk_default_valuec C s� d}t |�|kr&d}tdt |�|�D ]}|||| � }|| �|�7 }q|S dd�dgt |� � }| jj�� }z |�||��� W |�� S |�� w )zV Only for last_executed_query! Don't use this to execute SQL queries! i� r! r zSELECT �, zQUOTE(?)) r �range�%_quote_params_for_last_executed_query�joinr r? �execute�fetchone�close)r r< � BATCH_SIZE�results�index�chunkr; r? r! r! r" r_ � s z8DatabaseOperations._quote_params_for_last_executed_queryc C sT |r(t |ttf�r| �|�}|| S t|�� �}| �|�}tt||��}|| S |S �N)r) �list�tupler_ �values�dict�zip)r r? r; r< rk r! r! r" �last_executed_query� s � z&DatabaseOperations.last_executed_queryc C s |� d�r |�d�r |S d| S )N�"z"%s")� startswith�endswith)r �namer! r! r" � quote_name� s z DatabaseOperations.quote_namec C rX )N���r! rZ r! r! r" �no_limit_value� r\ z!DatabaseOperations.no_limit_valuec C sZ d}|ddf}| j �� �}|�||�}dd� |�� D �W d � S 1 s&w Y d S )Nz� WITH tables AS ( SELECT %s name UNION SELECT sqlite_master.name FROM sqlite_master JOIN tables ON (sql REGEXP %s || tables.name || %s) ) SELECT name FROM tables; z(?i)\s+references\s+("|\')?z ("|\')?\s*\(c S s g | ]}|d �qS )r r! ��.0�rowr! r! r" � <listcomp>� � z9DatabaseOperations.__references_graph.<locals>.<listcomp>)r r? ra r> )r � table_name�queryr< r? re r! r! r" �__references_graph� s � $�z%DatabaseOperations.__references_graphc C s t dd�| j�S )Ni )�maxsize)r �%_DatabaseOperations__references_graphrZ r! r! r" �_references_graph� s z$DatabaseOperations._references_graphF)�reset_sequences� allow_cascadec s` |r|rt t�� fdd�|D ���}� �fdd�|D �}|r.dd� |D �}|�� ��|�� |S )Nc 3 s � | ]}� � |�V qd S rh )r� �rw �tablerZ r! r" � <genexpr>� � � z/DatabaseOperations.sql_flush.<locals>.<genexpr>c s2 g | ]}d �� d��� d���� �|��f �qS )z %s %s %s;�DELETE�FROM)� SQL_KEYWORD� SQL_FIELDrs r� �r �styler! r" ry � s ����z0DatabaseOperations.sql_flush.<locals>.<listcomp>c S s g | ]}d |i�qS )r� r! r� r! r! r" ry � rz )�setr � from_iterable�extend�sequence_reset_by_name_sql)r r� �tablesr� r� r; � sequencesr! r� r" � sql_flush� s � � z DatabaseOperations.sql_flushc C sn |sg S d|� d�|�| �d��|� d�|�| �d��|� d�|�| �d��|� d�d �d d � |D ��f gS ) Nz %s %s %s %s = 0 %s %s %s (%s);�UPDATE�sqlite_sequence�SET�seq�WHERErr �INr] c S s g | ]}d |d �qS )�'%s'r� r! )rw � sequence_infor! r! r" ry � s zADatabaseOperations.sequence_reset_by_name_sql.<locals>.<listcomp>)r� � SQL_TABLErs r� r` )r r� r� r! r! r" r� � s ����z-DatabaseOperations.sequence_reset_by_name_sqlc C sR |d u rd S t |d�r |S t�|�r%tjr!t�|| jj�}t|�S td��t|�S )N�resolve_expressionzNSQLite backend does not support timezone-aware datetimes when USE_TZ is False.) �hasattrr �is_awarer rM � make_naiver � ValueError�str�r �valuer! r! r" �adapt_datetimefield_value s ��z,DatabaseOperations.adapt_datetimefield_valuec C s4 |d u rd S t |d�r |S t�|�rtd��t|�S )Nr� z5SQLite backend does not support timezone-aware times.)r� r r� r� r� r� r! r! r" �adapt_timefield_value s z(DatabaseOperations.adapt_timefield_valuec s� t � �|�}|j�� }|dkr|�| j� |S |dkr#|�| j� |S |dkr/|�| j� |S |dkr=|�| �|�� |S |dkrI|�| j � |S |dkrS|�| j � |S )Nr r r$ � DecimalField� UUIDField� BooleanField) �super�get_db_convertersr+ �get_internal_type�append�convert_datetimefield_value�convert_datefield_value�convert_timefield_value�get_decimalfield_converter�convert_uuidfield_value�convert_booleanfield_value)r r0 � converters� internal_type�� __class__r! r" r� & s( � � �� � z$DatabaseOperations.get_db_convertersc C s@ |d ur t |tj�st|�}tjr t�|�s t�|| jj�}|S rh ) r) �datetimer r rM r r� � make_awarer �r r� r0 r r! r! r" r� 7 s z.DatabaseOperations.convert_datetimefield_valuec C � |d urt |tj�st|�}|S rh )r) r� �dater r� r! r! r" r� ? � z*DatabaseOperations.convert_datefield_valuec C r� rh )r) r� �timer r� r! r! r" r� E r� z*DatabaseOperations.convert_timefield_valuec sP t jdd�j� t|t�r t �d��|jj ��� �fdd�}|S � fdd�}|S )N� )�precr c s" | d ur� | �j �|jjd�S d S )N)�context)�quantizer+ r� �r� r0 r ��create_decimal�quantize_valuer! r" � converterT s ��z@DatabaseOperations.get_decimalfield_converter.<locals>.converterc s | d ur� | �S d S rh r! r� )r� r! r" r� \ s �) �decimal�Context�create_decimal_from_floatr) r �Decimal�scalebr+ �decimal_places)r r0 r� r! r� r" r� K s � �z-DatabaseOperations.get_decimalfield_converterc C s |d ur t �|�}|S rh )�uuid�UUIDr� r! r! r" r� b s z*DatabaseOperations.convert_uuidfield_valuec C s |dv rt |�S |S )N)r r )�boolr� r! r! r" r� g s z-DatabaseOperations.convert_booleanfield_valuec C s, dd� |D �}d� dd� |D ��}d|� �S )Nc s s � | ]}d � |�V qdS )r] N�r` rv r! r! r" r� k r� z5DatabaseOperations.bulk_insert_sql.<locals>.<genexpr>r] c s s � | ] }d |� d�V qdS )�(r6 Nr! )rw r; r! r! r" r� l s � zVALUES r� )r r �placeholder_rows�placeholder_rows_sql� values_sqlr! r! r" �bulk_insert_sqlj s z"DatabaseOperations.bulk_insert_sqlc s: |dkr dd� |� S |dkrdd� |� S t� �||�S )N�^z POWER(%s)�,�#z BITXOR(%s))r` r� �combine_expression)r � connector�sub_expressionsr� r! r" r� o s z%DatabaseOperations.combine_expressionc C sD |dvr t d| ��d| g| }t|�dkrtd��dd�|� S )N)�+�-�*�/z$Invalid connector for timedelta: %s.r� � z)Too many params for timedelta operations.zdjango_format_dtdelta(%s)r] )r r r� r` )r r� r� � fn_paramsr! r! r" �combine_duration_expressionx s z.DatabaseOperations.combine_duration_expressionc C rX rL r! )r r� r! r! r" �integer_field_range� rB z&DatabaseOperations.integer_field_rangec C sF |\}}|\}}g |�|�R }|dkrd||f |fS d||f |fS )Nr$ zdjango_time_diff(%s, %s)z django_timestamp_diff(%s, %s)r! ) r r� �lhs�rhs�lhs_sql� lhs_params�rhs_sql� rhs_paramsr< r! r! r" �subtract_temporals� s z%DatabaseOperations.subtract_temporalsc s |t jkrdS t� j|d�S )NzINSERT OR IGNORE INTO)� on_conflict)r �IGNOREr� �insert_statement)r r� r� r! r" r� � s z#DatabaseOperations.insert_statementc s, |sdS � fdd�|D �}dd� |� dfS )N)� r! c s, g | ]}d � � |jjj�� � |j�f �qS )z%s.%s)rs �model�_meta�db_table�column�rw �fieldrZ r! r" ry � s � ���z<DatabaseOperations.return_insert_columns.<locals>.<listcomp>z RETURNING %sr] r! r� )r r �columnsr! rZ r" �return_insert_columns� s �z(DatabaseOperations.return_insert_columnsc sX |t jkr#| jjjr#dd�t| j|��d�dd� t| j|�D ��f S t� � ||||�S )Nz ON CONFLICT(%s) DO UPDATE SET %sr] c S s g | ] }|� d |� ��qS )z = EXCLUDED.r! r� r! r! r" ry � s ��z=DatabaseOperations.on_conflict_suffix_sql.<locals>.<listcomp>) r r� r r �%supports_update_conflicts_with_targetr` �maprs r� �on_conflict_suffix_sql)r r r� � update_fields� unique_fieldsr� r! r" r� � s" � ��� �z)DatabaseOperations.on_conflict_suffix_sqlrh )1�__name__� __module__� __qualname__�"cast_char_field_without_max_length�cast_data_types�explain_prefix� frozenset�jsonfield_datatype_valuesr# r4 r= r@ rA rI rK rF rR rT rU rV rW r[ r_ rn rs ru r r r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� � __classcell__r! r! r� r" r s^ � r ) r� r� r� � functoolsr � itertoolsr � django.confr �django.core.exceptionsr � django.dbr r r �"django.db.backends.base.operationsr �django.db.models.constantsr � django.db.models.expressionsr � django.utilsr �django.utils.dateparser r r �django.utils.functionalr r r! r! r! r" �<module> s
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings