o {,h@sdZddlmZmZddlmZGdddeZGdddeZGdd d eZGd d d eZ Gd d d eZ GdddeZ dS)z;Database functions that do comparisons or type conversions.)FuncValue)_lazy_re_compilecs\eZdZdZdZdZfddZfddZfdd Zd d Z d d Z fddZ 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__[/var/www/html/rh/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 rrrsz 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 rr as_sqlites.   zCast.as_sqlitecKsFd}|j}|dkrd}n |dkr|jrd}|j||fd|i|S)N FloatFieldz(%(expressions)s + 0.0) JSONFieldz"JSON_EXTRACT(%(expressions)s, '$')r)rget_internal_typemysql_is_mariadbr)r rrrr output_typerrras_mysql&s z Cast.as_mysqlcKs|j||fddi|S)Nrz(%(expressions)s)::%(db_type)s)rrrrr as_postgresql1szCast.as_postgresqlc s@|jdkrd}tj||fd|i|S|j||fi|S)Nr!z JSON_QUERY(%(expressions)s, '$')r)rr"rr)r rrrrr rr as_oracle<szCast.as_oracle) __name__ __module__ __qualname____doc__functionrr rrr%r&r' __classcell__rrr rrs     rcs<eZdZdZdZfddZeddZfddZZ S) 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 ValueErrorrr r expressionsextrar rrr K zCoalesce.__init__cCs0|D]}|j}|tus|dur|SqdS)N)get_source_expressionsempty_result_set_valueNotImplemented)r r resultrrrr:Ps zCoalesce.empty_result_set_valuec s\|jdkr$|}|dd|Dtt|j||fi|S|j||fi|S)N TextFieldcSsg|]}t|ddqS)TO_NCLOB)r,)r).0r rrr ^s z&Coalesce.as_oracle..)rr"copyset_source_expressionsr9rr.r)r rrrcloner rrr'XszCoalesce.as_oracle) r(r)r*r+r,r propertyr:r'r-rrr rr.Fs  r.cs<eZdZdZdZdZedZfddZfddZ Z S) CollateCOLLATEz*%(expressions)s %(function)s %(collation)sFz^[\w-]+$cs2|r|j|std|||_t|dS)NzInvalid collation name: %r.) collation_rematchr4 collationrr )r r rIr rrr os zCollate.__init__c s,|d|j|jtj||fi|S)NrI) setdefaultops quote_namerIrrrr rrruszCollate.as_sql) r(r)r*r,rallowed_defaultrrGr rr-rrr rrEgs rEc0eZdZdZdZfddZfddZZS)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. GREATESTcr0)Nr1z+Greatest must take at least two expressionsr2r5r rrr r8zGreatest.__init__c tj||fddi|S)zUse the MAX function on SQLite.r,MAXrrrr rrrzGreatest.as_sqliter(r)r*r+r,r rr-rrr rrOz  rOcrN)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. LEASTcr0)Nr1z(Least must take at least two expressionsr2r5r rrr r8zLeast.__init__c rQ)zUse the MIN function on SQLite.r,MINrSrr rrrrTzLeast.as_sqliterUrrr rrWrVrWcs$eZdZdZdZfddZZS)NullIfNULLIFr1c s>|d}t|tr|jdurtdtj||fi|S)Nrz2Oracle does not allow Value(None) for expression1.)r9 isinstancervaluer4rr)r rrr expression1r rrr's zNullIf.as_oracle)r(r)r*r,arityr'r-rrr rrZsrZN) r+django.db.models.expressionsrrdjango.utils.regex_helperrrr.rErOrWrZrrrrs ?!