X@sdZddlmZmZmZmZGdddeZGdddeZGdddeZGd d d eZ Gd d d eZ Gd ddeZ GdddeZ GdddeZ GdddeZGdddeZGdddeZdS)z, Classes that represent database functions. )Func TransformValuefieldscseZdZdZdZdZidej6dej6dej 6Z fddZ fd d Z d d Z d dZS)Castz3 Coerce an expression to a new field type. ZCASTz,%(function)s(%(expressions)s AS %(db_type)s)charzsigned integersignedcs tt|j|d|dS)N output_field)superr__init__)self expressionr ) __class__M/home/ubuntu/projects/ifolica/build/django/django/db/models/functions/base.pyr sz Cast.__init__c sAd|kr%|jj||dt|dkr!tdntt|j||dS)Nz+Coalesce must take at least two expressions)len ValueErrorr r"r )r expressionsextra)rrrr .szCoalesce.__init__cs|jjdkr|Gdddtfdd|jD}|j}|j|tt|j||S|j||S)NZ TextFieldc@seZdZdZdS)z#Coalesce.as_oracle..ToNCLOBZTO_NCLOBN)rrrr rrrrToNCLOB7s r(csg|]}|qSrr).0r )r(rr ;s z&Coalesce.as_oracle..) r Zget_internal_typerget_source_expressionscopyset_source_expressionsr r"r)r rrr&clone)r)r(r as_oracle3s  zCoalesce.as_oracle)rrrrr r r/rr)rrr"(s r"cs^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 r0r )r leftrightr')rrrr JszConcatPair.__init__cs1|j}tt|j||ddddS)Nrz%(expressions)sZ arg_joinerz || )coalescer r0r)r rrZ coalesced)rrr as_sqliteMs zConcatPair.as_sqlitecs%tt|j||ddddS)Nr Z CONCAT_WSrz!%(function)s('', %(expressions)s))r r0r)r rr)rrrrSszConcatPair.as_mysqlcCs6|j}dd|jD}|j||S)NcSs%g|]}t|tdqS))r"r)r)r rrrr*]s z'ConcatPair.coalesce..)r,r+r-)r cr&rrrr3Ys  zConcatPair.coalesce) rrrrr r r4rr3rr)rrr0Bs r0cs@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)Nr#z)Concat must take at least two expressions)r$r%_pairedr r7r )r r&r'Zpaired)rrrr lszConcat.__init__cCs@t|dkrt|St|d|j|ddS)Nr#r)r$r0r8)r r&rrrr8rs zConcat._paired)rrrrr rr r8rr)rrr7cs r7cs@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)Nr#z+Greatest must take at least two expressions)r$r%r r:r )r r&r')rrrr szGreatest.__init__cstt|j||ddS)zUse the MAX function on SQLite.r MAX)r r:r)r rr)rrrr4szGreatest.as_sqlite)rrrrr r r4rr)rrr:{s r:cs@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)Nr#z(Least must take at least two expressions)r$r%r r<r )r r&r')rrrr szLeast.__init__cstt|j||ddS)zUse the MIN function on SQLite.r ZMIN)r r<r)r rr)rrrr4szLeast.as_sqlite)rrrrr r r4rr)rrr<s r<csFeZdZdZdZdZfddZfddZS)Lengthz2Returns the number of characters in the expressionZLENGTHlengthc s;|jdtj}tt|j|d||dS)Nr )poprr!r r=r )r r r'r )rrrr szLength.__init__cstt|j||ddS)Nr Z CHAR_LENGTH)r r=r)r rr)rrrrszLength.as_mysql)rrrrr lookup_namer rrr)rrr=s r=c@seZdZdZdZdS)LowerZLOWERlowerN)rrrr r@rrrrrAs rAcs7eZdZdZdfddZddZS)NowZCURRENT_TIMESTAMPNc s;|dkrtj}ntt|jd||dS)Nr )rZ DateTimeFieldr rCr )r r r')rrrr s z Now.__init__cCs|j||ddS)NrzSTATEMENT_TIMESTAMP())r)r rrrrrrszNow.as_postgresql)rrrrr rrr)rrrCs rCcsOeZdZdZdfddZfddZfddZS) 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_expressionr9z'pos' must be greater than 0N)hasattrr%rappendr rDr )r r posr>r'r&)rrrr s   zSubstr.__init__cstt|j||ddS)Nr SUBSTR)r rDr)r rr)rrrr4szSubstr.as_sqlitecstt|j||ddS)Nr rH)r rDr)r rr)rrrr/szSubstr.as_oracle)rrrr r r4r/rr)rrrDs rDc@seZdZdZdZdS)UpperZUPPERupperN)rrrr r@rrrrrIs rIN)rZdjango.db.modelsrrrrrr"r0r7r:r<r=rArCrDrIrrrrs"!!