_V@sdZddlmZmZmZmZmZGdddeZGdddeZGdddeZ Gd d d eZ Gd d d eZ Gd ddeZ GdddeZ GdddeZGdddeZGdddeZdS)z, Classes that represent database functions. ) DateTimeFieldFunc IntegerField TransformValuecs@eZdZdZdZfddZfddZS)CoalescezT Chooses, from left to right, the first non-null expression and returns it. ZCOALESCEcs>t|dkr!tdntt|j||dS)Nz+Coalesce must take at least two expressions)len ValueErrorsuperr__init__)self expressionsextra) __class__.ToNCLOBZTO_NCLOBN)__name__ __module__ __qualname__functionrrrrToNCLOBs rcsg|]}|qSrr).0 expression)rrr s z&Coalesce.as_oracle..) output_fieldZget_internal_typerget_source_expressionsset_source_expressionsr ras_sql)r compiler connectionr)r)rr as_oracles zCoalesce.as_oracle)rrr__doc__rr r!rr)rrr s rcs^eZdZdZdZfddZfddZfddZd d ZS) ConcatPairz A helper class that concatenates two arguments together. This is used by `Concat` because not all backend databases support more than two arguments. ZCONCATc s tt|j|||dS)N)r r#r )r leftrightr)rrrr )szConcatPair.__init__cs7|j}d|_d|_tt|j||S)Nz || z%(expressions)s)coalesceZ arg_joinertemplater r#r)r rr Z coalesced)rrr as_sqlite,s   zConcatPair.as_sqlitecs+d|_d|_tt|j||S)NZ CONCAT_WSz!%(function)s('', %(expressions)s))rr'r r#r)r rr )rrras_mysql2s  zConcatPair.as_mysqlcCs6|j}dd|jD}|j||S)NcSs%g|]}t|tdqS))rr)rrrrrr<s z'ConcatPair.coalesce..)copyrr)r crrrrr&8s  zConcatPair.coalesce) rrrr"rr r(r)r&rr)rrr#!s r#cs@eZdZdZdZdZfddZddZS)Concatz Concatenates 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 we always get a non-null result. Nz%(expressions)scsMt|dkr!tdn|j|}tt|j||dS)Nrz)Concat must take at least two expressions)r r _pairedr r-r )r rrZpaired)rrrr KszConcat.__init__cCs@t|dkrt|St|d|j|ddS)Nrr)r r#r.)r rrrrr.Qs zConcat._paired)rrrr"rr'r r.rr)rrr-Bs r-cs@eZdZdZdZfddZfddZS)Greatesta  Chooses the maximum expression and returns it. 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|dkr!tdntt|j||dS)Nrz+Greatest must take at least two expressions)r r r r0r )r rr)rrrr dszGreatest.__init__cstt|j||ddS)zUse the MAX function on SQLite.rMAX)r r0r)r rr )rrrr(iszGreatest.as_sqlite)rrrr"rr r(rr)rrr0Zs r0cs@eZdZdZdZfddZfddZS)Leasta  Chooses the minimum expression and returns it. If any expression is null the return value is database-specific: On Postgres, the minimum not-null expression is returned. On MySQL, Oracle, and SQLite, if any expression is null, null is returned. ZLEASTcs>t|dkr!tdntt|j||dS)Nrz(Least must take at least two expressions)r r r r2r )r rr)rrrr xszLeast.__init__cstt|j||ddS)zUse the MIN function on SQLite.rZMIN)r r2r)r rr )rrrr(}szLeast.as_sqlite)rrrr"rr r(rr)rrr2ns r2csFeZdZdZdZdZfddZfddZS)Lengthz2Returns the number of characters in the expressionZLENGTHlengthc s8|jdt}tt|j|d||dS)Nr)poprr r3r )r rrr)rrrr szLength.__init__cs"d|_tt|j||S)NZ CHAR_LENGTH)rr r3r)r rr )rrrr)s zLength.as_mysql)rrrr"r lookup_namer r)rr)rrr3s r3cs.eZdZdZdZfddZS)LowerZLOWERlowerc stt|j||dS)N)r r7r )r rr)rrrr szLower.__init__)rrrrr6r rr)rrr7s r7cs7eZdZdZdfddZddZS)NowZCURRENT_TIMESTAMPNc s8|dkrt}ntt|jd||dS)Nr)rr r9r )r rr)rrrr s  z Now.__init__cCsd|_|j||S)NzSTATEMENT_TIMESTAMP())r'r)r rr rrr as_postgresqls zNow.as_postgresql)rrrr'r r:rr)rrr9s r9csOeZdZdZdfddZfddZfddZS) SubstrZ SUBSTRINGNc st|ds9|dkr*tdnt|}n||g}|dk rt|dsot|}n|j|ntt|j||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_expressionr/z'pos' must be greater than 0N)hasattrr rappendr r;r )r rposr4rr)rrrr s   zSubstr.__init__cs"d|_tt|j||S)NSUBSTR)rr r;r)r rr )rrrr(s zSubstr.as_sqlitecs"d|_tt|j||S)Nr?)rr r;r)r rr )rrrr!s zSubstr.as_oracle)rrrrr r(r!rr)rrr;s r;cs.eZdZdZdZfddZS)UpperZUPPERupperc stt|j||dS)N)r r@r )r rr)rrrr szUpper.__init__)rrrrr6r rr)rrr@s r@N)r"Zdjango.db.modelsrrrrrrr#r-r0r2r3r7r9r;r@rrrrs(!