o b@sdZddlmZddlmZmZddlmZddlm Z GdddeZ Gdd d eZ Gd d d eZ Gd d d eZ GdddeZGdddeZGdddeZdS)z;Database functions that do comparisons or type conversions.)NotSupportedError)FuncValue) JSONField)_lazy_re_compilecsTeZdZdZdZdZfddZfddZfdd Zd d Z fd d Z Z S)Castz)Coerce an expression to a new field type.ZCASTz,%(function)s(%(expressions)s AS %(db_type)s)cstj||ddS)N) output_field)super__init__)self expressionr __class__d/var/www/secure340b-portal/env/lib/python3.10/site-packages/django/db/models/functions/comparison.pyr sz Cast.__init__c s&|j||d<tj||fi|S)Ndb_type)rZ cast_db_typer as_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))rrr rinsert) r rrrrrsqlparams format_stringr rr as_sqlites  zCast.as_sqlitecKsFd}|j}|dkrd}n |dkr|jrd}|j||fd|i|S)NZ FloatFieldz(%(expressions)s + 0.0)rz"JSON_EXTRACT(%(expressions)s, '$')r)rget_internal_typeZmysql_is_mariadbr)r rrrr output_typerrras_mysql"s z Cast.as_mysqlc s@|jdkrd}tj||fd|i|S|j||fi|S)Nrz JSON_QUERY(%(expressions)s, '$')r)rr r r)r rrrrr rr as_oracle-szCast.as_oracle) __name__ __module__ __qualname____doc__functionrr rrr"r# __classcell__rrr rrs    rc0eZdZdZdZfddZfddZZS)Coalescez:Return, from left to right, the first non-null expression.ZCOALESCEc*t|dkr tdtj|i|dS)Nz+Coalesce must take at least two expressionslen ValueErrorr r r expressionsextrar rrr 9 zCoalesce.__init__c s\|jdkr$|}|dd|Dtt|j||fi|S|j||fi|S)NZ TextFieldcSsg|]}t|ddqS)ZTO_NCLOB)r()r).0r rrr Cs z&Coalesce.as_oracle..)rr copyZset_source_expressionsget_source_expressionsr r+r)r rrrcloner rrr#>s zCoalesce.as_oracle)r$r%r&r'r(r r#r)rrr rr+5s  r+cs8eZdZdZdZedZfddZfddZZ S)CollateZCOLLATEz*%(expressions)s %(function)s %(collation)sz ^[\w\-]+$cs2|r|j|std|||_t|dS)NzInvalid collation name: %r.) collation_rematchr0 collationr r )r r r=r rrr Ps zCollate.__init__c s,|d|j|jtj||fi|S)Nr=) setdefaultopsZ quote_namer=r rrr rrrVszCollate.as_sql) r$r%r&r(rrr;r rr)rrr rr:Js  r:cr*)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. ZGREATESTcr,)Nr-z+Greatest must take at least two expressionsr.r1r rrr er4zGreatest.__init__c tj||fddi|S)zUse the MAX function on SQLite.r(MAXr rrr rrrjzGreatest.as_sqliter$r%r&r'r(r rr)rrr rr@[  r@csBeZdZdZeZfddZfddZddZdd Z Z S) JSONObjectZ JSON_OBJECTc s8g}|D] \}}|t||fqtj|dS)N)itemsextendrr r )r fieldsr2keyvaluer rrr sszJSONObject.__init__c s&|jjstdtj||fi|S)Nz7JSONObject() is not supported on this database backend.)featuresZhas_json_object_functionrr rrr rrrys zJSONObject.as_sqlcKs|j||fddi|S)Nr(ZJSONB_BUILD_OBJECTrrrrr as_postgresqlszJSONObject.as_postgresqlcKs*Gddd}|j||f|dd|S)Nc@seZdZddZdS)z'JSONObject.as_oracle..ArgJoinercSs2ddt|ddd|dddD}d|S)NcSsg|]}d|qS)z VALUE )join)r5argrrrr6sz@JSONObject.as_oracle..ArgJoiner.join..r-z, )ziprP)r argsrrrrPs( z,JSONObject.as_oracle..ArgJoiner.joinN)r$r%r&rPrrrr ArgJoiners rUz,%(function)s(%(expressions)s RETURNING CLOB))Z arg_joinerrrN)r rrrrUrrrr#szJSONObject.as_oracle) r$r%r&r(rrr rrOr#r)rrr rrGos  rGcr*)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. ZLEASTcr,)Nr-z(Least must take at least two expressionsr.r1r rrr r4zLeast.__init__c rA)zUse the MIN function on SQLite.r(ZMINrCrr rrrrDzLeast.as_sqliterErrr rrVrFrVcs$eZdZdZdZfddZZS)NullIfZNULLIFr-c s>|d}t|tr|jdurtdtj||fi|S)Nrz2Oracle does not allow Value(None) for expression1.)r8 isinstancerrLr0r r)r rrrZ expression1r rrr#s zNullIf.as_oracle)r$r%r&r(arityr#r)rrr rrWsrWN)r'Z django.dbrZdjango.db.models.expressionsrrZdjango.db.models.fields.jsonrZdjango.utils.regex_helperrrr+r:r@rGrVrWrrrrs   -(