U 8T_p@shdZddlmZmZGdddeZGdddeZGdddeZGd d d eZGd d d eZd S)z;Database functions that do comparisons or type conversions.)FuncValuecs\eZdZdZdZdZfddZfddZfdd Zd d Z d d Z fddZ 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__I/tmp/pip-unpacked-wheel-dv63caxw/django/db/models/functions/comparison.pyr sz Cast.__init__c s"|j||d<tj||f|S)Ndb_type)rZ cast_db_typeras_sqlrcompiler connection extra_contextr r r r sz Cast.as_sqlc  s|j|}|dkrZd}tj||fd|i|\}}|dkrBdnd}|d|||fS|dkrd }tj||fd|i|S|j||f|S) N>datetimetimezstrftime(%%s, %(expressions)s)templaterz%H:%M:%fz%Y-%m-%d %H:%M:%frdatezdate(%(expressions)s))rrrrinsert) rrrrrrZsqlparams format_stringr r r as_sqlites  zCast.as_sqlitecKsFd}|j}|dkrd}n|dkr.|jr.d}|j||fd|i|S)NZ FloatFieldz(%(expressions)s + 0.0) JSONFieldz"JSON_EXTRACT(%(expressions)s, '$')r)rget_internal_typeZmysql_is_mariadbr)rrrrr output_typer r r as_mysqls z Cast.as_mysqlcKs|j||fddi|S)Nrz(%(expressions)s)::%(db_type)s)rrr r r as_postgresql*szCast.as_postgresqlc s<|jdkr,d}tj||fd|i|S|j||f|S)Nrz JSON_QUERY(%(expressions)s, '$')r)rrrr)rrrrrr r r as_oracle0szCast.as_oracle) __name__ __module__ __qualname____doc__functionrrrrrr r! __classcell__r r r r rs    rcs0eZdZdZdZfddZfddZZS)Coalescez:Return, from left to right, the first non-null expression.ZCOALESCEcs&t|dkrtdtj||dS)Nz+Coalesce must take at least two expressionslen ValueErrorrrrZ expressionsextrar r r r<s zCoalesce.__init__c sT|jdkrD|}|dd|Dtt|j||f|S|j||f|S)NZ TextFieldcSsg|]}t|ddqS)ZTO_NCLOB)r&)r).0r r r r Fsz&Coalesce.as_oracle..)rrcopyZset_source_expressionsget_source_expressionsrr(r)rrrrcloner r r r!As zCoalesce.as_oracle)r"r#r$r%r&rr!r'r r r r r(8s r(cs0eZdZdZdZfddZfddZZS)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. ZGREATESTcs&t|dkrtdtj||dS)Nr)z+Greatest must take at least two expressionsr*r-r r r rWs zGreatest.__init__c stj||fddi|S)zUse the MAX function on SQLite.r&MAXrrrr r r r\szGreatest.as_sqliter"r#r$r%r&rrr'r r r r r4Ms r4cs0eZdZdZdZfddZfddZZS)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. ZLEASTcs&t|dkrtdtj||dS)Nr)z(Least must take at least two expressionsr*r-r r r rks zLeast.__init__c stj||fddi|S)zUse the MIN function on SQLite.r&ZMINr6rr r r rpszLeast.as_sqliter7r r r r r8as r8cs$eZdZdZdZfddZZS)NullIfZNULLIFr)c s:|d}t|tr(|jdkr(tdtj||f|S)Nrz2Oracle does not allow Value(None) for expression1.)r2 isinstancervaluer,rr)rrrrZ expression1r r r r!ys zNullIf.as_oracle)r"r#r$r&arityr!r'r r r r r9usr9N) r%Zdjango.db.models.expressionsrrrr(r4r8r9r r r r s 3