B 0H[@sdZddlmZmZmZmZGdddeZGdddeZGdddeZGd d d eZ Gd d d eZ Gd ddeZ GdddeZ GdddeZ GdddeZGdddeZGdddeZGdddeZdS)z, Classes that represent database functions. )Func TransformValuefieldscs<eZdZdZdZdZfddZfddZdd ZZ 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__cC:\Users\HIRONO~1\AppData\Local\Temp\pip-install-6bm3nxem\django\django\db\models\functions\base.pyr sz Cast.__init__c s"|j||d<tj||f|S)NZdb_type)rZ cast_db_typeras_sql)r compiler connectionZ extra_context)r r rrsz Cast.as_sqlcCs|j||ddS)Nz%(expressions)s::%(db_type)s)template)r)r rrr r r as_postgresqlszCast.as_postgresql) __name__ __module__ __qualname____doc__functionrr rr __classcell__r r )r rrs   rcs0eZdZdZdZfddZfddZZS)Coalescez:Return, from left to right, the first non-null expression.ZCOALESCEcs&t|dkrtdtj||dS)Nz+Coalesce must take at least two expressions)len ValueErrorrr )r expressionsextra)r r rr s zCoalesce.__init__csd|jdkrXGdddtfdd|D}|}||tt|||S|||S)NZ TextFieldc@seZdZdZdS)z#Coalesce.as_oracle..ToNCLOBZTO_NCLOBN)rrrrr r r rToNCLOB%sr csg|] }|qSr r ).0r )r r r )sz&Coalesce.as_oracle..) rZget_internal_typerget_source_expressionscopyset_source_expressionsrrr)r rrrclone)r )r r as_oracle!s zCoalesce.as_oracle)rrrrrr r'rr r )r rrs rcs8eZdZdZdZfddZfddZddZZS) ConcatPairz Concatenate two arguments together. This is used by `Concat` because not all backend databases support more than two arguments. ZCONCATcs |}tt|j||dddS)Nz%(expressions)sz || )rZ arg_joiner)coalescerr(r)r rrZ coalesced)r r r as_sqlite7s zConcatPair.as_sqlitecstj||dddS)NZ CONCAT_WSz!%(function)s('', %(expressions)s))rr)rr)r rr)r r ras_mysql=szConcatPair.as_mysqlcCs(|}dd|D}|||S)NcSsg|]}t|tdqS))rr)r!r r r rr"Gsz'ConcatPair.coalesce..)r$r#r%)r crr r rr)Cs zConcatPair.coalesce) rrrrrr*r+r)rr r )r rr(0s   r(cs0eZdZdZdZdZfddZddZZS)Concatz Concatenate text fields together. Backends that result in an entire null expression when any arguments are null will wrap each argument in coalesce functions to ensure a non-null result. Nz%(expressions)scs2t|dkrtd||}tj|f|dS)Nrz)Concat must take at least two expressions)rr_pairedrr )r rrZpaired)r r rr Vs  zConcat.__init__cCs0t|dkrt|St|d||ddS)Nrr)rr(r/)r rr r rr/\s zConcat._paired) rrrrrrr r/rr r )r rr.Ms  r.cs0eZdZdZdZfddZfddZZS)Greatestz Return the maximum expression. If any expression is null the return value is database-specific: On Postgres, the maximum not-null expression is returned. On MySQL, Oracle, and SQLite, if any expression is null, null is returned. ZGREATESTcs&t|dkrtdtj||dS)Nrz+Greatest must take at least two expressions)rrrr )r rr)r r rr os zGreatest.__init__cstj||ddS)zUse the MAX function on SQLite.MAX)r)rr*)r rr)r r rr*tszGreatest.as_sqlite)rrrrrr r*rr r )r rr1es r1cs0eZdZdZdZfddZfddZZS)Leastz Return the minimum expression. If any expression is null the return value is database-specific: On Postgres, return the minimum not-null expression. On MySQL, Oracle, and SQLite, if any expression is null, return null. ZLEASTcs&t|dkrtdtj||dS)Nrz(Least must take at least two expressions)rrrr )r rr)r r rr s zLeast.__init__cstj||ddS)zUse the MIN function on SQLite.ZMIN)r)rr*)r rr)r r rr*szLeast.as_sqlite)rrrrrr r*rr r )r rr3ys r3cs0eZdZdZdZdZeZfddZ Z S)Lengthz2Return the number of characters in the expression.ZLENGTHlengthcstj||ddS)NZ CHAR_LENGTH)r)rr)r rr)r r rr+szLength.as_mysql) rrrrr lookup_namer IntegerFieldrr+rr r )r rr4s r4c@seZdZdZdZdS)LowerZLOWERlowerN)rrrrr6r r r rr8sr8c@s eZdZdZeZddZdS)NowZCURRENT_TIMESTAMPcCs|j||ddS)NzSTATEMENT_TIMESTAMP())r)r)r rrr r rrszNow.as_postgresqlN)rrrrrZ DateTimeFieldrrr r r rr:sr:cs0eZdZdZdZdZeZfddZ Z S)StrIndexz Return a positive integer corresponding to the 1-indexed position of the first occurrence of a substring inside another string, or 0 if the substring is not found. ZINSTRrcstj||ddS)NZSTRPOS)r)rr)r rr)r r rrszStrIndex.as_postgresql) rrrrrarityrr7rrrr r )r rr;s r;cs:eZdZdZd fdd ZfddZfddZZS) SubstrZ SUBSTRINGNc sFt|ds|dkrtd||g}|dk r4||tj||dS)z expression: the name of a field, or an expression returning a string pos: an integer > 0, or an expression returning an integer length: an optional number of characters to return Zresolve_expressionr0z'pos' must be greater than 0N)hasattrrappendrr )r r posr5rr)r r rr s  zSubstr.__init__cstj||ddS)NSUBSTR)r)rr)r rr)r r rr*szSubstr.as_sqlitecstj||ddS)NrA)r)rr)r rr)r r rr'szSubstr.as_oracle)N)rrrrr r*r'rr r )r rr=s r=c@seZdZdZdZdS)UpperZUPPERupperN)rrrrr6r r r rrBsrBN)rZdjango.db.modelsrrrrrrr(r.r1r3r4r8r:r;r=rBr r r rs