#ijdZddlmZmZddlmZGddeZGddeZGdd eZGd d eZ Gd d eZ GddeZ y)z;Database functions that do comparisons or type conversions.)FuncValue)_lazy_re_compilecTeZdZdZdZdZfdZfdZfdZdZ 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 _/var/www/html/office/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_sqls4#'#4#4#A#A*#M i w~h DmDDrc |jj|}|dvr+d}t | ||fd|i|\}}|dk(rdnd}|g|}||fS|dk(rd}t | ||fd|i|S|j||fi|S) N>timedatetimezstrftime(%%s, %(expressions)s)templaterz%H:%M:%fz%Y-%m-%d %H:%M:%fdatezdate(%(expressions)s))r rr r) r rrrrrsqlparams format_stringrs r as_sqlitezCast.as_sqlites##++J7 * *7H'.*/7;HKC+2V*;JATM#-f-F;   .H7>*/7;H 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_mysql&sZ''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_postgresql1s1t{{   6    rc |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_oracle<s_    . . 0K ?9H7>*/7;H t{{8ZA=AAr) __name__ __module__ __qualname____doc__functionrr rr"r)r+r- __classcell__rs@rrrs93H=H@EB$ U  BBrrc@eZdZdZdZfdZedZfdZxZ S)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__K. { a JK K +//rcb|jD]}|j}|tus||cSy)N)get_source_expressionsempty_result_set_valueNotImplemented)r rresults rrCzCoalesce.empty_result_set_valuePs<557 J66F'6+=  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_expressionsrBrr r6r)r rrrclonerrs rr-zCoalesce.as_oracleXs    . . 0K ?IIKE  ( ('+&A&A&C"j9  50:WW Wt{{8ZA=AA s B) r.r/r0r1r2r propertyrCr-r3r4s@rr6r6Fs0DH0  B Brr6cDeZdZdZdZdZedZfdZfdZ xZ S)CollateCOLLATEz*%(expressions)s %(function)s %(collation)sFz^[\w-]+$c|r|jj|std|z||_t||y)NzInvalid collation name: %r.) collation_rematchr< collationr r )r rrSrs rr zCollate.__init__os>d//55i@:YFG G" $rc |jd|jj|jt |||fi|S)NrS) setdefaultops quote_namerSr rrs rrzCollate.as_sqlus<  jnn.G.G.WXw~h DmDDr) r.r/r0r2rallowed_defaultrrQr rr3r4s@rrNrNgs/H;HO$K0L% EErrNc0eZdZdZdZfdZfdZxZS)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__r@rc *t|||fddi|S)zUse the MAX function on SQLite.r2MAXr r"rs rr"zGreatest.as_sqlitew :WWWWrr.r/r0r1r2r r"r3r4s@rrZrZzs H0 XXrrZc0eZdZdZdZfdZfdZxZS)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__s. { a GH H +//rc *t|||fddi|S)zUse the MIN function on SQLite.r2MINr_rs rr"zLeast.as_sqliter`rrar4s@rrcrcs H0 XXrrcc&eZdZdZdZfdZxZS)NullIfNULLIFr9c |jd}t|tr|j t dt |||fi|S)Nrz2Oracle does not allow Value(None) for expression1.)rB isinstancervaluer<r r)r rrr expression1rs rr-zNullIf.as_oraclesM113A6 k5 )k.?.?.GQR Rw~h DmDDr)r.r/r0r2arityr-r3r4s@rririsH EEErriN) r1django.db.models.expressionsrrdjango.utils.regex_helperrrr6rNrZrcrirrrssdA46<B4<B~BtBBEdE&XtX*XDX*ETEr