o timedatetimezstrftime(%%s, %(expressions)s)templaterz%H:%M:%fz%Y-%m-%d %H:%M:%frdatezdate(%(expressions)s))r rr rinsert) r rrrrrsqlparams format_stringrrr as_sqlites.   zCast.as_sqlitecKsFd}|j}|dkrd}n |dkr|jrd}|j||fd|i|S)N FloatFieldz(%(expressions)s + 0.0)rz"JSON_EXTRACT(%(expressions)s, '$')r)r get_internal_typemysql_is_mariadbr)r rrrr output_typerrras_mysql)s z Cast.as_mysqlcK|j||fddi|S)Nrz(%(expressions)s)::%(db_type)srrrrr as_postgresql4szCast.as_postgresqlc s@|jdkrd}tj||fd|i|S|j||fi|S)Nrz JSON_QUERY(%(expressions)s, '$')r)r r$r r)r rrrrrrr as_oracle?szCast.as_oracle) __name__ __module__ __qualname____doc__functionrr rr"r'r*r+ __classcell__rrrrr s     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 ValueErrorr r r expressionsextrarrrr N zCoalesce.__init__cCs0|D]}|j}|tus|dur|SqdSN)get_source_expressionsempty_result_set_valueNotImplemented)r rresultrrrr?Ss zCoalesce.empty_result_set_valuec s\|jdkr$|}|dd|Dtt|j||fi|S|j||fi|S)NrcSsg|]}t|ddqS)TO_NCLOB)r0)r).0rrrr as z&Coalesce.as_oracle..)r r$copyset_source_expressionsr>r r2r)r rrrclonerrrr+[szCoalesce.as_oracle) r,r-r.r/r0r propertyr?r+r1rrrrr2Is  r2cs<eZdZdZdZdZedZfddZfddZ Z S) CollateCOLLATEz*%(expressions)s %(function)s %(collation)sFz^[\w-]+$cs2|r|j|std|||_t|dS)NzInvalid collation name: %r.) collation_rematchr8 collationr r )r rrMrrrr rs zCollate.__init__c s,|d|j|jtj||fi|S)NrM) setdefaultops quote_namerMr rrrrrrxszCollate.as_sql) r,r-r.r0rallowed_defaultrrKr rr1rrrrrIjs rIc0eZdZdZdZfddZfddZZS)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. GREATESTcr4)Nr5z+Greatest must take at least two expressionsr6r9rrrr r<zGreatest.__init__c tj||fddi|S)zUse the MAX function on SQLite.r0MAXr r"rrrrr"zGreatest.as_sqliter,r-r.r/r0r r"r1rrrrrS}  rScsNeZdZdZeZfddZfddZddZfdd Z d d Z Z S) JSONObject JSON_OBJECTc s8g}|D] \}}|t||fqtj|dSr=)itemsextendrr r )r fieldsr:keyvaluerrrr szJSONObject.__init__c s&|jjstdtj||fi|S)Nz7JSONObject() is not supported on this database backend.)featureshas_json_object_functionrr rrrrrrs zJSONObject.as_sqlcKs2Gddd}|j||f|d|dd|S)Nc@seZdZddZdS)z'JSONObject.as_native..ArgJoinercSs6t|ddd|ddddd}ddd|DS)Nr5T)strictz, cSsg|]}d|qS)z VALUE )join)rCpairrrrrDsz@JSONObject.as_native..ArgJoiner.join..)ziprf)r argspairsrrrrfs"z,JSONObject.as_native..ArgJoiner.joinN)r,r-r.rfrrrr ArgJoiners rkz'%(function)s(%(expressions)s RETURNING )) arg_joinerrr))r rr returningrrkrrr as_natives zJSONObject.as_nativec sj|jjr|jjr)|}|ddt|Dtt|j ||fddi|S|j ||fddi|S)NcSs,g|]\}}|ddkrt|tn|qS)r5r)rr)rCindexrrrrrDsz,JSONObject.as_postgresql..r0JSONB_BUILD_OBJECTrnJSONB) rbis_postgresql_16uses_server_side_bindingrErF enumerater>r r[rro)r rrrrErrrr*s&  zJSONObject.as_postgresqlcKr()NrnCLOB)rorrrrr+szJSONObject.as_oracle) r,r-r.r0rr r rror*r+r1rrrrr[s   r[crR)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. LEASTcr4)Nr5z(Least must take at least two expressionsr6r9rrrr r<zLeast.__init__c rU)zUse the MIN function on SQLite.r0MINrWrrrrr"rXzLeast.as_sqliterYrrrrrwrZrwcs$eZdZdZdZfddZZS)NullIfNULLIFr5c s>|d}t|tr|jdurtdtj||fi|S)Nrz2Oracle does not allow Value(None) for expression1.)r> isinstancerrar8r r)r rrr expression1rrrr+s zNullIf.as_oracle)r,r-r.r0arityr+r1rrrrrzsrzN)r/ django.dbrdjango.db.models.expressionsrrdjango.db.models.fieldsrdjango.db.models.fields.jsonrdjango.utils.regex_helperrrr2rIrSr[rwrzrrrrs    ?!7