g#dZddlmZddlmZmZddlmZddlm Z ddl m Z GddeZ Gd d eZ Gd d eZGd deZGddeZGddeZGddeZy)z;Database functions that do comparisons or type conversions.)NotSupportedError)FuncValue) TextField) JSONField)_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/python.vincentserveurtest.ovh/public_html/venv/lib/python3.12/site-packages/django/db/models/functions/comparison.pyrz Cast.__init__s ,?c b|jj||d<t| ||fi|S)Ndb_type)r cast_db_typeras_sqlrcompiler connection extra_contextrs rrz Cast.as_sqls4#'#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 rrrinsert) rrrrrr sqlparams format_stringrs r as_sqlitezCast.as_sqlites##++J7 * *7H'.*/7;HKC+2V*;JATM MM!] +;   .H7>*/7;H t{{8ZA=AArc d}|jj}|dk(rd}n|dk(r|jrd}|j||fd|i|S)N FloatFieldz(%(expressions)s + 0.0)rz"JSON_EXTRACT(%(expressions)s, '$')r )r get_internal_typemysql_is_mariadbr)rrrrr output_types ras_mysqlz Cast.as_mysql)sZ''99; , &0H K 'J,G,G;Ht{{8ZT(TmTTrc .|j||fddi|S)Nr z(%(expressions)s)::%(db_type)srrrrrs r as_postgresqlzCast.as_postgresql4s1t{{   6    rc |jjdk(rd}t| ||fd|i|S|j||fi|S)Nrz JSON_QUERY(%(expressions)s, '$')r )r r)rr)rrrrr rs r as_oraclezCast.as_oracle?s_    . . 0K ?9H7>*/7;H t{{8ZA=AAr) __name__ __module__ __qualname____doc__functionr rrr&r,r0r2 __classcell__rs@rr r s93H=H@EB$ U  BBrr c@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 ValueErrorrrr expressionsextrars rrzCoalesce.__init__N. { a JK K +//rcb|jD]}|j}|tus||cSyN)get_source_expressionsempty_result_set_valueNotImplemented)rrresults rrIzCoalesce.empty_result_set_valueSs7557J66F'6+= 8rc *|jjdk(r]|j}|j|j Dcgc]}t |dc}t t|"||fi|S|j||fi|Scc}w)NrTO_NCLOB)r7) r r)copyset_source_expressionsrHrrr;r)rrrrclonerrs rr2zCoalesce.as_oracle[s    . . 0K ?IIKE  ( ('+&A&A&C&C j9&C  50:WW Wt{{8ZA=AA s B) r3r4r5r6r7rpropertyrIr2r8r9s@rr;r;Is0DH0  B Brr;cDeZdZdZdZdZedZfdZfdZ xZ S)CollateCOLLATEz*%(expressions)s %(function)s %(collation)sFz^[\w-]+$c|r|jj|std|z||_t||y)NzInvalid collation name: %r.) collation_rematchrA collationrr)rrrXrs rrzCollate.__init__rs>d//55i@:YFG G" $rc |jd|jj|jt |||fi|S)NrX) setdefaultops quote_namerXrrrs rrzCollate.as_sqlxs<  jnn.G.G.WXw~h DmDDr) r3r4r5r7r allowed_defaultrrVrrr8r9s@rrSrSjs/H;HO$K0L% EErrSc0eZdZdZdZfdZfdZxZS)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)Nr>z+Greatest must take at least two expressionsr?rBs rrzGreatest.__init__rErc *t|||fddi|S)zUse the MAX function on SQLite.r7MAXrr&rs rr&zGreatest.as_sqlitew :WWWWrr3r4r5r6r7rr&r8r9s@rr_r_}s H0 XXrr_cPeZdZdZeZfdZfdZdZfdZ dZ xZ S) JSONObject JSON_OBJECTc g}|jD]!\}}|jt||f#t||yrG)itemsextendrrr)rfieldsrCkeyvaluers rrzJSONObject.__init__s@  ,,.JC   c E2 3) +&rc h|jjs tdt|||fi|S)Nz7JSONObject() is not supported on this database backend.)featureshas_json_object_functionrrrrs rrzJSONObject.as_sqls:"";;#I w~h DmDDrc VGdd}|j||f|d|dd|S)NceZdZdZy)'JSONObject.as_native..ArgJoinerct|ddd|dddd}dj|Dcgc]}dj|c}Scc}w)Nr>T)strictz, z VALUE )zipjoin)rargspairspairs rrzz,JSONObject.as_native..ArgJoiner.joinsLD1ItADqDz$?yy5!I54).."65!IJJ!IsA N)r3r4r5rzrr ArgJoinerrus Krrz'%(function)s(%(expressions)s RETURNING )) arg_joinerr r.)rrr returningrrs r as_nativezJSONObject.as_nativesK K K t{{   !{>ykK     rc |jjr|jjr~|j}|j t |j Dcgc]#\}}|dzdk(rt|tn|%c}}tt|.||fddi|S|j||fddi|Scc}}w)Nr>rr7JSONB_BUILD_OBJECTrJSONB) rqis_postgresql_16uses_server_side_bindingrNrO enumeraterHr rrrhrr)rrrrrNindexrrs rr0zJSONObject.as_postgresqls##44"";;99;D  ' '.7t7R7R7T-U-U)z6;QY!^DY[1S-U  T1.   t~~h WgWWWs%(C c .|j||fddi|S)NrCLOB)rr/s rr2zJSONObject.as_oraclest~~h VfV VVr) r3r4r5r7rr rrrr0r2r8r9s@rrhrhs+H;L' E  X(Wrrhc0eZdZdZdZfdZfdZxZS)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)Nr>z(Least must take at least two expressionsr?rBs rrzLeast.__init__s. { a GH H +//rc *t|||fddi|S)zUse the MIN function on SQLite.r7MINrdrs rr&zLeast.as_sqlitererrfr9s@rrrs H0 XXrrc&eZdZdZdZfdZxZS)NullIfNULLIFr>c |jd}t|tr|j t dt |||fi|S)Nrz2Oracle does not allow Value(None) for expression1.)rH isinstancerrorArr)rrrr expression1rs rr2zNullIf.as_oraclesM113A6 k5 )k.?.?.GQR Rw~h DmDDr)r3r4r5r7arityr2r8r9s@rrrsH EEErrN)r6 django.dbrdjango.db.models.expressionsrrdjango.db.models.fieldsrdjango.db.models.fields.jsonrdjango.utils.regex_helperrr r;rSr_rhrrr~rrrs|A'4-26<B4<B~BtBBEdE&XtX*4W4WnXDX*ETEr