File: //lib/python3/dist-packages/django/db/models/functions/__pycache__/comparison.cpython-310.pyc
o
3�a� � @ s� d Z ddlmZ ddlmZmZ ddlmZ ddlm Z G dd� de�Z
G dd � d e�Z G d
d � d e�Z G d d
� d
e�Z
G dd� de�ZG dd� de�ZG dd� de�ZdS )z;Database functions that do comparisons or type conversions.� )�NotSupportedError)�Func�Value)� JSONField)�_lazy_re_compilec sT e Zd ZdZdZdZ� fdd�Z� fdd�Z� fdd �Zd
d � Z � fd d
�Z
� Z S )�Castz)Coerce an expression to a new field type.�CASTz,%(function)s(%(expressions)s AS %(db_type)s)c s t � j||d� d S )N)� output_field)�super�__init__)�self�
expressionr �� __class__� �G/usr/lib/python3/dist-packages/django/db/models/functions/comparison.pyr
s z
Cast.__init__c s& | j �|�|d< t� j||fi |��S )N�db_type)r � cast_db_typer
�as_sql�r �compiler�
connection�
extra_contextr r r r s z Cast.as_sqlc s� | j �|�}|dv r-d}t� j||fd|i|��\}}|dkr!dnd}|�d|� ||fS |dkr@d }t� j||fd|i|��S | j||fi |��S )
N> �time�datetimez strftime(%%s, %(expressions)s)�templater z%H:%M:%fz%Y-%m-%d %H:%M:%fr �datezdate(%(expressions)s))r r r
r �insert) r r r r r r �sql�params�
format_stringr r r � as_sqlite s zCast.as_sqlitec K sF d }| j �� }|dkrd}n |dkr|jrd}| j||fd|i|��S )N�
FloatFieldz(%(expressions)s + 0.0)r z"JSON_EXTRACT(%(expressions)s, '$')r )r �get_internal_type�mysql_is_mariadbr )r r r r r � output_typer r r �as_mysql" s
z
Cast.as_mysqlc s@ | j �� dkrd}t� j||fd|i|��S | j||fi |��S )Nr z JSON_QUERY(%(expressions)s, '$')r )r r# r
r )r r r r r r r r � as_oracle- s zCast.as_oracle) �__name__�
__module__� __qualname__�__doc__�functionr r r r! r& r' �
__classcell__r r r r r s r c �0 e Zd ZdZdZ� fdd�Z� fdd�Z� ZS )�Coalescez:Return, from left to right, the first non-null expression.�COALESCEc �* t |�dk r
td��t� j|i |�� d S )N� z+Coalesce must take at least two expressions��len�
ValueErrorr
r �r � expressions�extrar r r r 9 � zCoalesce.__init__c s\ | j �� dkr$| �� }|�dd� | �� D �� tt|�j||fi |��S | j||fi |��S )N� TextFieldc S s g | ]}t |d d��qS )�TO_NCLOB)r, )r )�.0r
r r r �
<listcomp>C s �z&Coalesce.as_oracle.<locals>.<listcomp>)r r# �copy�set_source_expressions�get_source_expressionsr
r/ r )r r r r �cloner r r r' > s
�zCoalesce.as_oracle)r( r) r* r+ r, r r' r- r r r r r/ 5 s
r/ c s8 e Zd ZdZdZed�Z� fdd�Z� fdd�Z� Z S )�Collate�COLLATEz*%(expressions)s %(function)s %(collation)sz ^[\w\-]+$c s2 |r| j �|�std| ��|| _t� �|� d S )NzInvalid collation name: %r.)� collation_re�matchr5 � collationr
r )r r
rF r r r r P s zCollate.__init__c s, |� d|j�| j�� t� j||fi |��S )NrF )�
setdefault�ops�
quote_namerF r
r r r r r r V s zCollate.as_sql)
r( r) r* r, r r rD r r r- r r r r rB J s rB c r. )�Greatestz�
Return the maximum expression.
If any expression is null the return value is database-specific:
On PostgreSQL, the maximum not-null expression is returned.
On MySQL, Oracle, and SQLite, if any expression is null, null is returned.
�GREATESTc r1 )Nr2 z+Greatest must take at least two expressionsr3 r6 r r r r e r9 zGreatest.__init__c � t � j||fddi|��S )z Use the MAX function on SQLite.r, �MAX�r
r! r r r r r! j � zGreatest.as_sqlite�r( r) r* r+ r, r r! r- r r r r rJ [ �
rJ c sB e Zd ZdZe� Z� fdd�Z� fdd�Zdd� Zdd � Z � Z
S )
�
JSONObject� JSON_OBJECTc s8 g }|� � D ]
\}}|�t|�|f� qt� j|� d S )N)�items�extendr r
r )r �fieldsr7 �key�valuer r r r s s zJSONObject.__init__c s& |j jstd��t� j||fi |��S )Nz7JSONObject() is not supported on this database backend.)�features�has_json_object_functionr r
r r r r r r y s
�zJSONObject.as_sqlc K s | j ||fddi|��S )Nr, �JSONB_BUILD_OBJECT�r r r r r �
as_postgresql� s ���zJSONObject.as_postgresqlc K s* G dd� d�}| j ||f|� dd�|��S )Nc @ s e Zd Zdd� ZdS )z'JSONObject.as_oracle.<locals>.ArgJoinerc S s2 dd� t |d d d� |dd d� �D �}d�|�S )Nc S s g | ]}d � |��qS )z VALUE )�join)r< �argr r r r= � s z@JSONObject.as_oracle.<locals>.ArgJoiner.join.<locals>.<listcomp>r2 � z, )�zipr^ )r �argsr r r r^ � s (
z,JSONObject.as_oracle.<locals>.ArgJoiner.joinN)r( r) r* r^ r r r r � ArgJoiner� s rc z,%(function)s(%(expressions)s RETURNING CLOB))�
arg_joinerr r\ )r r r r rc r r r r' � s ���zJSONObject.as_oracle) r( r) r* r, r r r r r] r' r- r r r r rR o s rR c r. )�Leastz�
Return the minimum expression.
If any expression is null the return value is database-specific:
On PostgreSQL, return the minimum not-null expression.
On MySQL, Oracle, and SQLite, if any expression is null, return null.
�LEASTc r1 )Nr2 z(Least must take at least two expressionsr3 r6 r r r r � r9 zLeast.__init__c rL )z Use the MIN function on SQLite.r, �MINrN r r r r r! � rO zLeast.as_sqliterP r r r r re � rQ re c s$ e Zd ZdZdZ� fdd�Z� ZS )�NullIf�NULLIFr2 c s> | � � d }t|t�r|jd u rtd��t� j||fi |��S )Nr z2Oracle does not allow Value(None) for expression1.)r@ �
isinstancer rX r5 r
r )r r r r � expression1r r r r' � s zNullIf.as_oracle)r( r) r* r, �arityr' r- r r r r rh � s rh N)r+ � django.dbr � django.db.models.expressionsr r � django.db.models.fields.jsonr �django.utils.regex_helperr r r/ rB rJ rR re rh r r r r �<module> s -(