U scc@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_compilecs\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___/var/www/html/project/venv/lib/python3.8/site-packages/django/db/models/functions/comparison.pyr sz Cast.__init__c s"|j||d<tj||f|S)Ndb_type)rZ cast_db_typer as_sqlr compiler connection extra_contextr rrrsz Cast.as_sqlc  s|j|}|dkrZd}tj||fd|i|\}}|dkrBdnd}|d|||fS|dkrd }tj||fd|i|S|j||f|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_sqlites2   zCast.as_sqlitecKsFd}|j}|dkrd}n|dkr.|jr.d}|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_mysqlcKs|j||fddi|S)Nrz(%(expressions)s)::%(db_type)srrrrr as_postgresql2szCast.as_postgresqlc s<|jdkr,d}tj||fd|i|S|j||f|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$r% __classcell__rrr rrs     rcs<eZdZdZdZfddZeddZfddZZ S) Coalescez:Return, from left to right, the first non-null expression.ZCOALESCEcs&t|dkrtdtj||dS)Nz+Coalesce must take at least two expressionslen ValueErrorr r r expressionsextrar rrr Ls zCoalesce.__init__cCs0|D]"}|j}|tks"|dk r|SqdSN)get_source_expressionsempty_result_set_valueNotImplemented)r r resultrrrr6Qs   zCoalesce.empty_result_set_valuec sT|jdkrD|}|dd|Dtt|j||f|S|j||f|S)NZ TextFieldcSsg|]}t|ddqS)ZTO_NCLOB)r*)r).0r rrr _sz&Coalesce.as_oracle..)rr copyZset_source_expressionsr5r r,r)r rrrcloner rrr%YszCoalesce.as_oracle) r&r'r(r)r*r propertyr6r%r+rrr rr,Gs   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 rAr rrr os zCollate.__init__c s(|d|j|jtj||f|S)NrA) setdefaultopsZ quote_namerAr rrr rrruszCollate.as_sql) r&r'r(r*rrr?r rr+rrr rr>hs  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.r1r rrr s zGreatest.__init__c stj||fddi|S)zUse the MAX function on SQLite.r*MAXr rrr rrrszGreatest.as_sqliter&r'r(r)r*r rr+rrr rrDzs rDcsBeZdZdZeZfddZfddZddZdd Z Z S) JSONObjectZ JSON_OBJECTc s8g}|D]\}}|t||fq tj|dSr4)itemsextendrr r )r fieldsr2keyvaluer rrr szJSONObject.__init__c s"|jjstdtj||f|S)Nz7JSONObject() is not supported on this database backend.)featuresZhas_json_object_functionrr rrr rrrs zJSONObject.as_sqlcKs|j||fddi|S)Nr*ZJSONB_BUILD_OBJECTr#rrrrr$szJSONObject.as_postgresqlcKs*Gddd}|j||f|dd|S)Nc@seZdZddZdS)z'JSONObject.as_oracle..ArgJoinercSs2ddt|ddd|dddD}d|S)NcSsg|]}d|qS)z VALUE )join)r9argrrrr:sz@JSONObject.as_oracle..ArgJoiner.join..r-z, )ziprO)r argsrrrrOs(z,JSONObject.as_oracle..ArgJoiner.joinN)r&r'r(rOrrrr ArgJoinersrTz,%(function)s(%(expressions)s RETURNING CLOB))Z arg_joinerrr#)r rrrrTrrrr%szJSONObject.as_oracle) r&r'r(r*rrr rr$r%r+rrr rrHs   rHcs0eZdZdZdZfddZfddZZS)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.r1r rrr s zLeast.__init__c stj||fddi|S)zUse the MIN function on SQLite.r*ZMINrFrr rrrszLeast.as_sqliterGrrr rrUs rUcs$eZdZdZdZfddZZS)NullIfZNULLIFr-c s:|d}t|tr(|jdkr(tdtj||f|S)Nrz2Oracle does not allow Value(None) for expression1.)r5 isinstancerrMr0r r)r rrrZ expression1r rrr%s zNullIf.as_oracle)r&r'r(r*arityr%r+rrr rrVsrVN)r)Z django.dbrZdjango.db.models.expressionsrrZdjango.db.models.fields.jsonrZdjango.utils.regex_helperrrr,r>rDrHrUrVrrrrs   ?!(