hpdZddlmZmZGddeZGddeZGddeZGd d eZGd d eZy )z;Database functions that do comparisons or type conversions.)FuncValuecTeZdZdZdZdZfdZfdZfdZdZ dZ fd Z xZ S) Castz)Coerce an expression to a new field type.CASTz,%(function)s(%(expressions)s AS %(db_type)s)c(t|||y)N) output_field)super__init__)self expressionr __class__s h/var/www/html/ranktracker/api/venv/lib/python3.12/site-packages/django/db/models/functions/comparison.pyr z Cast.__init__ s ,?c b|jj||d<t| ||fi|S)Ndb_type)r cast_db_typer as_sqlr compiler connection extra_contextrs rrz Cast.as_sql s4#'#4#4#A#A*#M i w~h DmDDrc |jj|}|dvr7d}t | ||fd|i|\}}|dk(rdnd}|j d|||fS|dk(rd }t | ||fd|i|S|j||fi|S) N>timedatetimezstrftime(%%s, %(expressions)s)templaterz%H:%M:%fz%Y-%m-%d %H:%M:%frdatezdate(%(expressions)s))r rr rinsert) r rrrrrsqlparams format_stringrs r as_sqlitezCast.as_sqlites##++J7 * *7H'.:bbTabKC*1V*;JATM MM!] +;   .H7>(J[[][ [t{{8ZA=AArc d}|jj}|dk(rd}n|dk(r|jrd}|j||fd|i|S)N FloatFieldz(%(expressions)s + 0.0) JSONFieldz"JSON_EXTRACT(%(expressions)s, '$')r)r get_internal_typemysql_is_mariadbr)r rrrr output_types ras_mysqlz Cast.as_mysqlsZ''99; , &0H K 'J,G,G;Ht{{8ZT(TmTTrc .|j||fddi|S)Nrz(%(expressions)s)::%(db_type)s)r)r rrrs r as_postgresqlzCast.as_postgresql*s#t{{8Zl:Zl^kllrc |jjdk(rd}t| ||fd|i|S|j||fi|S)Nr%z JSON_QUERY(%(expressions)s, '$')r)r r&r r)r rrrrrs r as_oraclezCast.as_oracle0sR    . . 0K ?9H7>(J[[][ [t{{8ZA=AAr) __name__ __module__ __qualname____doc__functionrr rr"r)r+r- __classcell__rs@rrrs:3H=H@E B Um BBrrc0eZdZdZdZfdZfdZxZS)Coalescez:Return, from left to right, the first non-null expression.COALESCEcVt|dkr tdt| |i|y)Nz+Coalesce must take at least two expressionslen ValueErrorr r r expressionsextrars rr zCoalesce.__init__<. { a JK K +//rc *|jjdk(r]|j}|j|j Dcgc]}t |dc}t t|"||fi|S|j||fi|Scc}w)N TextFieldTO_NCLOB)r2) r r&copyset_source_expressionsget_source_expressionsrr r6r)r rrrcloner rs rr-zCoalesce.as_oracleAs    . . 0K ?IIKE  ( (HLHcHcHe*:DZ*5* 50:WW Wt{{8ZA=AA *s B)r.r/r0r1r2r r-r3r4s@rr6r68sDH0 B Brr6c0eZdZdZdZfdZfdZxZS)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. GREATESTcVt|dkr tdt| |i|y)Nr9z+Greatest must take at least two expressionsr:r=s rr zGreatest.__init__Wr@rc *t|||fddi|S)zUse the MAX function on SQLite.r2MAXr r"rs rr"zGreatest.as_sqlite\w :WWWWrr.r/r0r1r2r r"r3r4s@rrIrIMs H0 XXrrIc0eZdZdZdZfdZfdZxZS)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. LEASTcVt|dkr tdt| |i|y)Nr9z(Least must take at least two expressionsr:r=s rr zLeast.__init__ks. { a GH H +//rc *t|||fddi|S)zUse the MIN function on SQLite.r2MINrNrs rr"zLeast.as_sqliteprOrrPr4s@rrRrRas H0 XXrrRc&eZdZdZdZfdZxZS)NullIfNULLIFr9c |jd}t|tr|j t dt |||fi|S)Nrz2Oracle does not allow Value(None) for expression1.)rF isinstancervaluer<r r)r rrr expression1rs rr-zNullIf.as_oracleysM113A6 k5 )k.?.?.GQR Rw~h DmDDr)r.r/r0r2arityr-r3r4s@rrXrXusH EEErrXN) r1django.db.models.expressionsrrrr6rIrRrXrrrasRA40B40BfBtB*XtX(XDX(ETEr