|
Server : Apache System : Linux iad1-shared-b8-43 6.6.49-grsec-jammy+ #10 SMP Thu Sep 12 23:23:08 UTC 2024 x86_64 User : dh_edsupp ( 6597262) PHP Version : 8.2.26 Disable Function : NONE Directory : /lib/python3/dist-packages/django/db/models/fields/__pycache__/ |
Upload File : |
o
3�aL � @ sh d dl Z d dlmZ d dlmZmZ d dlmZmZm Z d dl
m Z d dl m
Z
mZ d dlmZ dd lmZ dd
lmZ d gZG d d � d ee�ZdHdd�ZG dd� de
�ZG dd� de
�ZG dd� de
�ZG dd� de�Z G dd� de�Z G dd� de �Z G d d � d e j �Z e�!e� e�!e� e�!e � e�!e � e�!e � e�!e � G d d � d e�Z"G d d!� d!e"�Z#G d"d#� d#�Z$G d$d%� d%�Z%G d&d'� d'e j&�Z'G d(d)� d)e j(�Z)G d*d+� d+e �Z*G d,d-� d-e%e$e j+�Z,G d.d/� d/e%e$e j-�Z.G d0d1� d1e$e j/�Z0G d2d3� d3e%e$e j1�Z2G d4d5� d5e$e j3�Z4G d6d7� d7e%e$e j5�Z6G d8d9� d9e$e j7�Z8G d:d;� d;e%e$e j9�Z:G d<d=� d=�Z;G d>d?� d?e;e j<�Z=G d@dA� dAe;e j>�Z?G dBdC� dCe;e j@�ZAG dDdE� dEe;e jB�ZCe"�!e)� e"�!e*� e"�!e,� e"�!e'� e"�!e.� e"�!e0� e"�!e2� e"�!e4� e"�!e6� e"�!e8� e"�!e:� e"�!e=� e"�!e?� e"�!eA� e"�!eC� G dFdG� dG�ZDdS )I� N)�forms)�checks�
exceptions)�NotSupportedError� connections�router)�lookups)�PostgresOperatorLookup� Transform)� gettext_lazy� )�Field)�CheckFieldDefaultMixin� JSONFieldc s� e Zd ZdZed�Zded�iZdZ d � fdd� Z� fd d
�Z d d � Z
� fd
d�Z dd� Z dd� Z
dd� Z� fdd�Z� fdd�Zdd� Z� fdd �Z� ZS ) r Fz
A JSON object�invalidzValue must be valid JSON.)�dictz{}Nc sN |r
t |�s
td��|rt |�std��|| _|| _t� j||fi |�� d S )Nz0The encoder parameter must be a callable object.z0The decoder parameter must be a callable object.)�callable�
ValueError�encoder�decoder�super�__init__)�self� verbose_name�namer r �kwargs�� __class__� �>/usr/lib/python3/dist-packages/django/db/models/fields/json.pyr s zJSONField.__init__c s4 t � jdi |��}|�d�pg }|�| �|�� |S )N� databasesr )r �check�get�extend�_check_supported)r r �errorsr r r r r! $ s zJSONField.checkc C sz g }|D ]6}t �|| j�sqt| }| jjjr | jjj|jkr qd| jjjv s:|jj s:|�
t j d|j
| jdd�� q|S )N�supports_json_fieldz %s does not support JSONFields.z fields.E180)�obj�id)r �allow_migrate_model�modelr �_meta�required_db_vendor�vendor�required_db_features�featuresr& �appendr �Error� display_name)r r r% �db�
connectionr r r r$ * s. ������zJSONField._check_supportedc sF t � �� \}}}}| jd ur| j|d< | jd ur | j|d< ||||fS )Nr r )r � deconstructr r )r r �path�argsr r r r r5 C s
zJSONField.deconstructc C sP |d u r|S t |t�rt |t�s|S z tj|| jd�W S tjy' | Y S w �N��cls)�
isinstance� KeyTransform�str�json�loadsr �JSONDecodeError)r �value�
expressionr4 r r r �
from_db_valueK s �zJSONField.from_db_valuec C s dS )Nr r �r r r r �get_internal_typeW s zJSONField.get_internal_typec C s |d u r|S t j|| jd�S r8 )r> �dumpsr )r rA r r r �get_prep_valueZ s zJSONField.get_prep_valuec s t � �|�}|r
|S t|�S �N)r �
get_transform�KeyTransformFactory)r r � transformr r r rI _ s zJSONField.get_transformc sN t � �||� z tj|| jd� W d S ty& tj| jd dd|id��w )Nr9 r rA )�code�params) r �validater> rF r � TypeErrorr �ValidationError�error_messages)r rA �model_instancer r r rN e s ��zJSONField.validatec C s
| � |�S rH )�value_from_object)r r' r r r �value_to_stringp �
zJSONField.value_to_stringc s$ t � jdi tj| j| jd�|���S )N)�
form_classr r r )r � formfieldr r r r )r r r r r rW s s
��zJSONField.formfield)NNNN)�__name__�
__module__� __qualname__�empty_strings_allowed�_� description�default_error_messages�
_default_hintr r! r$ r5 rC rE rG rI rN rT rW �
__classcell__r r r r r s$ �� Tc C sj |rdgng }| D ]&}zt |�}W n ty' |�d� |�t�|�� Y q w |�d| � q d�|�S )N�$�.z[%s]� )�intr r0 r> rF �join)�key_transforms� include_rootr6 �
key_transform�numr r r �compile_json_path| s
�
rj c @ � e Zd ZdZdZdd� ZdS )� DataContains�containsz@>c C sP |j jstd��| �||�\}}| �||�\}}t|�t|� }d||f |fS )Nz:contains lookup is not supported on this database backend.�JSON_CONTAINS(%s, %s)�r/ � supports_json_field_containsr � process_lhs� process_rhs�tuple�r �compilerr4 �lhs�
lhs_params�rhs�
rhs_paramsrM r r r �as_sql� � �zDataContains.as_sqlN�rX rY rZ � lookup_name�postgres_operatorrz r r r r rl � � rl c @ rk )� ContainedBy� contained_byz<@c C sP |j jstd��| �||�\}}| �||�\}}t|�t|� }d||f |fS )Nz>contained_by lookup is not supported on this database backend.rn ro rt r r r rz � r{ zContainedBy.as_sqlNr| r r r r r� � r r� c sB e Zd ZdZd dd�Zdd� Zdd� Z� fdd �Zd
d � Z� Z S )
� HasKeyLookupNc C s� t | jt�r| j�||�\}}}t|�}n
| �||�\}}d}|| }| j} g }
t | ttf�s2| g} | D ]!} t | t�rE| �||��^ } }
n| g}
|
� d|t|
dd�f � q4| j
rfd| j
� |gt |
� � }|t|�t|
� fS )Nra z%s%sF)rg z(%s))
r; rv r< �preprocess_lhsrj rq rx �listrs r0 �logical_operatorre �len)r ru r4 �templaterv rw �lhs_key_transforms�
lhs_json_path�sqlrx ry �keyr\ �rhs_key_transformsr r r rz � s*
�zHasKeyLookup.as_sqlc C � | j ||dd�S )Nz"JSON_CONTAINS_PATH(%s, 'one', %%s)�r� �rz �r ru r4 r r r �as_mysql� � zHasKeyLookup.as_mysqlc C s$ | j ||dd�\}}|t|� g fS )NzJSON_EXISTS(%s, '%%s')r� )rz rs )r ru r4 r� rM r r r � as_oracle� s zHasKeyLookup.as_oraclec sX t | jt�r%| j�||��^ }}|d d� D ] }t|| j�| _q|d | _t� �||�S )N���)r; rx r< r� rv r �
as_postgresql)r ru r4 r\ r� r� r r r r� � s
zHasKeyLookup.as_postgresqlc C r� )N� JSON_TYPE(%s, %%s) IS NOT NULLr� r� r� r r r � as_sqlite� r� zHasKeyLookup.as_sqliterH )
rX rY rZ r� rz r� r� r� r� r` r r r r r� � s
r� c @ � e Zd ZdZdZdZdS )�HasKey�has_key�?FN)rX rY rZ r} r~ � prepare_rhsr r r r r� � � r� c @ s e Zd ZdZdZdZdd� ZdS )�HasKeys�has_keysz?&z AND c C s dd� | j D �S )Nc S s g | ]}t |��qS r )r= )�.0�itemr r r �
<listcomp>� s z+HasKeys.get_prep_lookup.<locals>.<listcomp>)rx rD r r r �get_prep_lookup� r� zHasKeys.get_prep_lookupN)rX rY rZ r} r~ r� r� r r r r r� � s
r� c @ r� )�
HasAnyKeys� has_any_keysz?|z OR N)rX rY rZ r} r~ r� r r r r r� � r� r� c �, e Zd ZdZ� fdd�Z� fdd�Z� ZS )� JSONExactTc sP t � �||�\}}|jdkr$t � �||�\}}|dkr$|d gkr$d| }||fS )N�sqlite�%szJSON_TYPE(%s, '$'))r rq r- rr )r ru r4 rv rw rx ry r r r rq � s
zJSONExact.process_lhsc sV t � �||�\}}|dkr|d gkrdg}|jdkr'dgt|� }|t|� }||fS )Nr� �null�mysql�JSON_EXTRACT(%s, '$'))r rr r- r� rs )r ru r4 rx ry �funcr r r rr � s
zJSONExact.process_rhs)rX rY rZ �can_use_none_as_rhsrq rr r` r r r r r� � s r� c sL e Zd ZdZdZ� fdd�Zdd� Zdd� Zd d
� Zd d � Z d
d� Z
� Z S )r< z->z#>c s t � j|i |�� t|�| _d S rH )r r r= �key_name)r r� r7 r r r r r s zKeyTransform.__init__c C sf | j g}| j}t|t�r|�d|j � |j}t|t�s |�|�\}}|jdkr.dd� |D �}|||fS )Nr �oraclec S s g | ]}|� d d��qS )�%z%%)�replace)r� r� r r r r� s z/KeyTransform.preprocess_lhs.<locals>.<listcomp>)r� rv r; r< �insert�compiler- )r ru r4 rf �previousrv rM r r r r� s
�
zKeyTransform.preprocess_lhsc C �0 | � ||�\}}}t|�}d| t|�|f fS �NzJSON_EXTRACT(%s, %%s)�r� rj rs �r ru r4 rv rM rf � json_pathr r r r� # � zKeyTransform.as_mysqlc C s6 | � ||�\}}}t|�}d||fd t|�d fS )Nz4COALESCE(JSON_QUERY(%s, '%s'), JSON_VALUE(%s, '%s'))� r� r� r r r r� ( s
�
�zKeyTransform.as_oraclec C s� | � ||�\}}}t|�dkr d|| jf }|t|�|f fS zt| j�}W n ty2 | j}Y nw d|| jf t|�|f fS )Nr z (%s %s %%s))r� r� �postgres_nested_operatorrs rd r� r r~ )r ru r4 rv rM rf r� �lookupr r r r� 0 s
� zKeyTransform.as_postgresqlc C r� r� r� r� r r r r� ; r� zKeyTransform.as_sqlite) rX rY rZ r~ r� r r� r� r� r� r� r` r r r r r< s r< c @ s e Zd ZdZdZdS )�KeyTextTransformz->>z#>>N)rX rY rZ r~ r� r r r r r� A s r� c s e Zd ZdZ� fdd�Z� ZS )�KeyTransformTextLookupMixinz�
Mixin for combining with a lookup expecting a text lhs from a JSONField
key lookup. On PostgreSQL, make use of the ->> operator instead of casting
key values to text and performing the lookup on the resulting
representation.
c sL t |t�s td��t|jg|j�R i |j��}t� j|g|�R i |�� d S )NzLTransform should be an instance of KeyTransform in order to use this lookup.) r; r< rO r� r� �source_expressions�extrar r )r rh r7 r �key_text_transformr r r r M s
���� z$KeyTransformTextLookupMixin.__init__)rX rY rZ �__doc__r r` r r r r r� F s r� c r� )�CaseInsensitiveMixinz�
Mixin to allow case-insensitive comparison of JSON values on MySQL.
MySQL handles strings used in JSON context using the utf8mb4_bin collation.
Because utf8mb4_bin is a binary collation, comparison of JSON values is
case-sensitive.
c �0 t � �||�\}}|jdkrd| |fS ||fS �Nr� z LOWER(%s))r rq r- )r ru r4 rv rw r r r rq a �
z CaseInsensitiveMixin.process_lhsc r� r� )r rr r- �r ru r4 rx ry r r r rr g r� z CaseInsensitiveMixin.process_rhs)rX rY rZ r� rq rr r` r r r r r� Z s r� c @ � e Zd Zdd� Zdd� ZdS )�KeyTransformIsNullc C s\ t | jj| jj��||�\}}| js||fS | j�||�\}}}d||f t|�t|� fS )Nz(NOT %s OR %s IS NULL))r� rv r� r� rx r� rs )r ru r4 r� rM rv rw r\ r r r r� p s �� z KeyTransformIsNull.as_oraclec C s, d}| j sd}t| jj| jj�j|||d�S )NzJSON_TYPE(%s, %%s) IS NULLr� r� )rx r� rv r� rz )r ru r4 r� r r r r� { s �z KeyTransformIsNull.as_sqliteN)rX rY rZ r� r� r r r r r� n s r� c � e Zd Z� fdd�Z� ZS )�KeyTransformInc s� t � �||||�\}}t|d�s8|jjs8|jdkr1t�|�}d}t|t t
f�r,|d }n |d }n|jdv r8d}|jdkrD|j rDd | }||fS )
Nrz r� �9%s(JSON_OBJECT('value' VALUE %%s FORMAT JSON), '$.value')�
JSON_QUERY�
JSON_VALUE> r� r� r� r� zJSON_UNQUOTE(%s)) r � resolve_expression_parameter�hasattrr/ �has_native_json_fieldr- r> r? r; r� r �mysql_is_mariadb)r ru r4 r� �paramrM rA r r r r� � s$ ���
z+KeyTransformIn.resolve_expression_parameter)rX rY rZ r� r` r r r r r� � � r� c s4 e Zd Z� fdd�Z� fdd�Z� fdd�Z� ZS )�KeyTransformExactc sb t � �||�\}}|jdkr-t � �||�\}}|dkr-|dgkr-| j�||�^}}d| }||fS )Nr� r� r� zJSON_TYPE(%s, %%s))r rq r- rr rv r� )r ru r4 rv rw rx ry r\ r r r rq � s
z KeyTransformExact.process_lhsc s� t | jt�rttj| ��||�S t� �||�\}}|jdkrLg }d}|D ] }t� |�}t |t
t f�r:|� |d � q$|� |d � q$|t
|� }||fS |jdkr^dd� |D �}|t
|� }||fS )Nr� r� r� r� r� c S s g | ]
}|d kr
dnd�qS )r� r� r� r �r� rA r r r r� � s z1KeyTransformExact.process_rhs.<locals>.<listcomp>)r; rx r< r r �Exactrr r- r> r? r� r r0 rs )r ru r4 rx ry r� r� rA r r r rr � s"
� z KeyTransformExact.process_rhsc s� t � �||�\}}|dgkr?t| jj| jj�}|�||�\}}| j�d�| jd�}|�||�\} }
d|| f t|�t|
� fS t � �||�S )Nr� �isnullTz %s AND %s) r rr r� rv r� r� �
get_lookuprz rs ) r ru r4 rx ry � has_key_expr� has_key_sql�has_key_params� is_null_expr� is_null_sql�is_null_paramsr r r r� � s
�zKeyTransformExact.as_oracle)rX rY rZ rq rr r� r` r r r r r� � s r� c @ � e Zd ZdS )�KeyTransformIExactN�rX rY rZ r r r r r� � � r� c @ r� )�KeyTransformIContainsNr� r r r r r� � r� r� c @ r� )�KeyTransformStartsWithNr� r r r r r� � r� r� c @ r� )�KeyTransformIStartsWithNr� r r r r r� � r� r� c @ r� )�KeyTransformEndsWithNr� r r r r r� � r� r� c @ r� )�KeyTransformIEndsWithNr� r r r r r� � r� r� c @ r� )�KeyTransformRegexNr� r r r r r� � r� r� c @ r� )�KeyTransformIRegexNr� r r r r r� � r� r� c r� )� KeyTransformNumericLookupMixinc s0 t � �||�\}}|jjsdd� |D �}||fS )Nc S s g | ]}t �|��qS r )r> r? r� r r r r� � s z>KeyTransformNumericLookupMixin.process_rhs.<locals>.<listcomp>)r rr r/ r� r� r r r rr � s z*KeyTransformNumericLookupMixin.process_rhs)rX rY rZ rr r` r r r r r� � r� r� c @ r� )�KeyTransformLtNr� r r r r r� � r� r� c @ r� )�KeyTransformLteNr� r r r r r� � r� r� c @ r� )�KeyTransformGtNr� r r r r r� � r� r� c @ r� )�KeyTransformGteNr� r r r r r� � r� r� c @ r� )rJ c C s
|| _ d S rH )r� )r r� r r r r rU z KeyTransformFactory.__init__c O s t | jg|�R i |��S rH )r< r� )r r7 r r r r �__call__ s z KeyTransformFactory.__call__N)rX rY rZ r r� r r r r rJ s rJ )T)Er> �djangor � django.corer r � django.dbr r r �django.db.modelsr �django.db.models.lookupsr r
�django.utils.translationr r\ rc r
�mixinsr �__all__r rj rl r� r� r� r� r� r� r� �register_lookupr< r� r� r� �IsNullr� �Inr� r� �IExactr� � IContainsr� �
StartsWithr� � IStartsWithr� �EndsWithr� � IEndsWithr� �Regexr� �IRegexr� r� �LessThanr� �LessThanOrEqualr� � GreaterThanr� �GreaterThanOrEqualr� rJ r r r r �<module> sz
l
4
2,