ó H`¾Tc@ssdZddlmZmZddlmZmZddlmZm Z m Z m Z m Z m Z mZmZmZmZddlmZmZmZddlmZddlmZdd lmZdd lmZejeƒZd d „Zd eeefd„ƒYZde fd„ƒYZ!e!ƒZ"e!de#ƒZ$defd„ƒYZ%defd„ƒYZ&dej'e&e%ƒfd„ƒYZ(ede ƒede ƒde(fd„ƒYZ)de(fd„ƒYZ*de(fd„ƒYZ+d e+fd!„ƒYZ,d"e+fd#„ƒYZ-d$e+fd%„ƒYZ.d&e+fd'„ƒYZ/d(e(fd)„ƒYZ0d*e(fd+„ƒYZ1d,e(fd-„ƒYZ2d.e(fd/„ƒYZ3d0e(fd1„ƒYZ4d2e*fd3„ƒYZ5d4e*fd5„ƒYZ6d6e*fd7„ƒYZ7d8e*fd9„ƒYZ8d:e*fd;„ƒYZ9d<e*fd=„ƒYZ:d>e*fd?„ƒYZ;d@e*fdA„ƒYZ<dBe*fdC„ƒYZ=dDS(Es6SQL function API, factories, and built-in functions. i(tsqltypestschema(t ExecutabletColumnCollection( t ClauseListtCasttExtractt_literal_as_bindstliteral_columnt_type_from_argst ColumnElementt_clonetOvert BindParameter(t FromClausetSelecttAlias(t operators(t VisitableTypei(tutil(t annotationt_defaultcCst|}|||RBRDRCRJ(((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyR's       t_FunctionGeneratorcBs)eZdZd„Zd„Zd„ZRS(s;Generate :class:`.Function` objects based on getattr calls.cKsg|_||_dS(N(t_FunctionGenerator__namestopts(R$RT((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyR)Ós cCsŒ|jdƒrAy|j|SWq`tk r=t|ƒ‚q`Xn|jdƒr`|dd!}nt|j}t|jƒ|g|_|S(Nt__t_iiÿÿÿÿ( t startswitht__dict__tKeyErrortAttributeErrortendswithRRRTtlistRS(R$Rtf((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyt __getattr__×s cOsÔ|jjƒ}|j|ƒt|jƒ}|dkrI|j\}}n)|dkrld|jd}}nd}|dk r­t|j|ƒ}|dk r­|||ŽSnt|jdd|jdd!||ŽS(NiiRiiÿÿÿÿRN( RTtcopytupdatetlenRSR0RtgettFunction(R$R'R&tottokensRtfnametfunc((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyt__call__ås     (RKRLRMR)R^Rh(((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyRRÐs  tgroupRccBs&eZdZdZd„Zd„ZRS(sYDescribe a named SQL function. See the superclass :class:`.FunctionElement` for a description of public methods. .. seealso:: :data:`.func` - namespace which produces registered or ad-hoc :class:`.Function` instances. :class:`.GenericFunction` - allows creation of registered function types. tfunctioncOsn|jddƒpg|_||_|jddƒ|_tj|jddƒƒ|_t j |||ŽdS(s–Construct a :class:`.Function`. The :data:`.func` construct is normally used to construct new :class:`.Function` instances. RNtbindttype_N( tpopR0RNRRbt_bindRt to_instanceRHRR)(R$RR%R;((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyR)Zs  c Cs%t|j|d|d|jdtƒS(NRERFRG(R RRHR!(R$RRI((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyRJhs (RKRLRMt__visit_name__R)RJ(((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyRcHs t _GenericMetacBseZd„ZRS(cCs¥tj|jkr…|jd|ƒ|_}|jd|ƒ|_}|jddƒ}d|krr|d|_nt|||ƒnt t |ƒj |||ƒdS(NRRRRt__return_type__( Rt Annotatedt__mro__RbRRRmRHRtsuperRqR)(tclstclsnametbasestclsdictRRR((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyR)ps (RKRLR)(((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyRqostGenericFunctioncBseZdZeZd„ZRS(sI Define a 'generic' function. A generic function is a pre-established :class:`.Function` class that is instantiated automatically when called by name from the :data:`.func` attribute. Note that calling any name from :data:`.func` has the effect that a new :class:`.Function` instance is created automatically, given that name. The primary use case for defining a :class:`.GenericFunction` class is so that a function of a particular name may be given a fixed return type. It can also include custom argument parsing schemes as well as additional methods. Subclasses of :class:`.GenericFunction` are automatically registered under the name of the class. For example, a user-defined function ``as_utc()`` would be available immediately:: from sqlalchemy.sql.functions import GenericFunction from sqlalchemy.types import DateTime class as_utc(GenericFunction): type = DateTime print select([func.as_utc()]) User-defined generic functions can be organized into packages by specifying the "package" attribute when defining :class:`.GenericFunction`. Third party libraries containing many functions may want to use this in order to avoid name conflicts with other systems. For example, if our ``as_utc()`` function were part of a package "time":: class as_utc(GenericFunction): type = DateTime package = "time" The above function would be available from :data:`.func` using the package name ``time``:: print select([func.time.as_utc()]) A final option is to allow the function to be accessed from one name in :data:`.func` but to render as a different name. The ``identifier`` attribute will override the name used to access the function as loaded from :data:`.func`, but will retain the usage of ``name`` as the rendered name:: class GeoBuffer(GenericFunction): type = Geometry package = "geo" name = "ST_Buffer" identifier = "buffer" The above function will render as follows:: >>> print func.geo.buffer() ST_Buffer() .. versionadded:: 0.8 :class:`.GenericFunction` now supports automatic registration of new functions as well as package and custom naming support. .. versionchanged:: 0.8 The attribute name ``type`` is used to specify the function's return type at the class level. Previously, the name ``__return_type__`` was used. This name is still recognized for backwards-compatibility. cOs¶|jddƒ}|dkr@g|D]}t|ƒ^q%}ng|_|jddƒ|_tdtjdt |Œj ƒ|_ t j |jddƒp©t|ddƒƒ|_dS(Nt _parsed_argsRkRRRlRH(RmR0RRNRbRnRRR R!R"R#RRotgetattrRH(R$R(R&t parsed_argsR'((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyR)Æs "  (RKRLRMR!tcoerce_argumentsR)(((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyRz|sFtcasttextractt next_valuecBs8eZdZejƒZdZd„Zed„ƒZ RS(sRepresent the 'next value', given a :class:`.Sequence` as its single argument. Compiles into the appropriate function on each backend, or will raise NotImplementedError if used on a backend that does not provide support for sequences. RcKs@t|tjƒstdƒ‚|jddƒ|_||_dS(Ns0next_value() accepts a Sequence object as input.Rk(t isinstanceRtSequencetAssertionErrorRbR0Rntsequence(R$tseqR;((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyR)âs cCsgS(N((R$((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyR6ès( RKRLRMRtIntegerRHRR)ROR6(((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyRÖs   t AnsiFunctioncBseZd„ZRS(cKstj||dS(N(RzR)(R$R&((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyR)îs(RKRLR)(((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyRˆístReturnTypeFromArgscBseZdZd„ZRS(sADefine a function whose return type is the same as its arguments.cOsVg|D]}t|ƒ^q}|jdt|ƒƒ||dRMtRRtbaseRRtelementsRRRRRR R R R R t selectableRRRRtvisitorsRRRt defaultdicttdictRRRtobjectRRRgRQtmodifierRcRqtwith_metaclassRzRRˆR‰R‹RŒRRŽRR‘R“R•R–R™R›RRžRŸR R¡R¢R£(((s^/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/functions.pyt sPF ©+ J' "V