o uvXj@shdZddlmZmZGdddeZGdddeZGdddeZGd d d eZGd d d eZd S)z;Database functions that do comparisons or type conversions.)FuncValuecsPeZdZdZdZdZfddZfddZfdd Zd d Z d d Z Z S)Castz)Coerce an expression to a new field type.CASTz,%(function)s(%(expressions)s AS %(db_type)s)cstj||ddS)N) output_field)super__init__)self expressionr __class__b/var/www/html/myproject/venv/lib/python3.10/site-packages/django/db/models/functions/comparison.pyr sz Cast.__init__c s&|j||d<tj||fi|S)Ndb_type)r cast_db_typeras_sqlr compiler connection extra_contextr r rr sz Cast.as_sqlc  s|j|}|dvr-d}tj||fd|i|\}}|dkr!dnd}|d|||fS|dkr@d }tj||fd|i|S|j||fi|S) N>timedatetimezstrftime(%%s, %(expressions)s)templaterz%H:%M:%fz%Y-%m-%d %H:%M:%frdatezdate(%(expressions)s))rrrrinsert) r rrrrrsqlparams format_stringr r r as_sqlites  zCast.as_sqlitecKs.|jdkr dnd}|j||fd|i|S)N FloatFieldz(%(expressions)s + 0.0)r)rget_internal_typer)r rrrrr r ras_mysqlsz Cast.as_mysqlcKs|j||fddi|S)Nrz(%(expressions)s)::%(db_type)s)rrr r r as_postgresql$szCast.as_postgresql) __name__ __module__ __qualname____doc__functionrrrrr!r" __classcell__r r r rrs   rc0eZdZdZdZfddZfddZZS)Coalescez:Return, from left to right, the first non-null expression.COALESCEc*t|dkr tdtj|i|dS)Nz+Coalesce must take at least two expressionslen ValueErrorrrr expressionsextrar r rr/ zCoalesce.__init__c s\|jdkr$|}|dd|Dtt|j||fi|S|j||fi|S)N TextFieldcSsg|]}t|ddqS)TO_NCLOB)r')r).0r r r r 9s z&Coalesce.as_oracle..)rr copyset_source_expressionsget_source_expressionsrr*r)r rrrcloner r r as_oracle4s zCoalesce.as_oracle)r#r$r%r&r'rr=r(r r r rr*+s  r*cr))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. GREATESTcr,)Nr-z+Greatest must take at least two expressionsr.r1r r rrJr4zGreatest.__init__c tj||fddi|S)zUse the MAX function on SQLite.r'MAXrrrr r rrOzGreatest.as_sqliter#r$r%r&r'rrr(r r r rr>@  r>cr))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. LEASTcr,)Nr-z(Least must take at least two expressionsr.r1r r rr^r4zLeast.__init__c r@)zUse the MIN function on SQLite.r'MINrBrr r rrcrCzLeast.as_sqliterDr r r rrFTrErFcs$eZdZdZdZfddZZS)NullIfNULLIFr-c s>|d}t|tr|jdurtdtj||fi|S)Nrz2Oracle does not allow Value(None) for expression1.)r; isinstancervaluer0rr)r rrr expression1r r rr=ls zNullIf.as_oracle)r#r$r%r'arityr=r(r r r rrIhsrIN) r&django.db.models.expressionsrrrr*r>rFrIr r r rs&