�
���ec@s�dZd
dl
Z
d
dlZd
dlZddlmZ
ddlmZ
ddlmZ
ddlm	Z	
ddlm
Z

dd	lmZ
dd
lmZ
ddlm
Z

dd
lmZ
ddlmZ
ddlmZ
ddlmZ
eZeZeZejd�
Zejd�
Zdef
d��YZdef
d��YZd�Zd�Zd�Zd�Zd�Z d�Z!d�Z"d�Z#dej$j%f
d ��YZ&d!ej$j%f
d"��YZ'ej(d#�
d$��
Z)d%ef
d&��YZ*d'ef
d(��YZ+d)ef
d*��YZ,d+ef
d,��YZ-d-e,f
d.��YZ.d/e/f
d0��YZ0d1ej1e0�
f
d2��YZ2d3e2efd4��YZ3d5e	f
d6��YZ4d7ej5e,fd8��YZ6d9e7f
d:��YZ8d;ef
d<��YZ9d=ef
d>��YZ:d?ef
d@��YZ;dAe;f
dB��YZ<dCej=e;fdD��YZ>dEej?f
dF��YZ@edG�
ZAdH�ZBedI�
ZCdS(Js4Foundational utilities common to many sql modules.

i����Ni
(
troles(
tvisitors(
tHasCacheKey(
tHasCopyInternals(
tMemoizedHasCacheKey(
t
ClauseVisitor(
tExtendedInternalTraversal(
tInternalTraversali(
texc(
tutil(
tHasMemoized(
thybridmethodtPARSE_AUTOCOMMITtNO_ARGt	Immutablec
Bs8eZ
dZeZd
�Zd�Zd�Zd�ZRS(s@mark a ClauseElement as 'immutable' when expressions are cloned.c
Ostd
�
�
dS(Ns(Immutable objects do not support copying(
tNotImplementedError(tselftoptionaldicttkwargs((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt
unique_params,s
c
Ostd
�
�
dS(Ns(Immutable objects do not support copying(
R(RRR((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytparams/s
c

Ks|S(
N((Rtkw((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_clone2s
c

KsdS(
N((RR((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_copy_internals5s
(	t__name__t
__module__t__doc__tTruet
_is_immutableRRRR(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR's
			tSingletonConstantcBs,eZ
dZeZd
�Zed��
ZRS(s.Represent SQL constants like NULL, TRUE, FALSEc

Os|jS(
N(
t
_singleton(tclstargR((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__new__>s
c
Cs8tj
|�
}
|
j�
t|
g
�
|
_|
|_dS(
N(tobjectR!t__init__t	frozensett	proxy_setR(Rtobj((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_create_singletonAs

	
(RRRRt_is_singleton_constantR!tclassmethodR'(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR9s
	cGs&tj
jg|D]}
|
j^q�
S(
N(t	itertoolstchaint
from_iterablet
_from_objects(telementstelement((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR-Qs
	
c
Cs&tj
jg|D]}
|
j^q�
S(
sXexpand tables into individual columns in the
    given list of column expressions.

    (R*R+R,t_select_iterable(R.t
c((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_select_iterablesWs	
c
Cs+tj
d
��
}
|
|�
}||_|S(s�non-caching _generative() decorator.

    This is basically the legacy decorator that copies the object and
    runs a method on the new copy.

    c_s:|
j�}
||
||�
}|dks6td
�
�
|
S(sMark a method as generative.s,generative methods must have no return valueN(t	_generatetNonetAssertionError(tfnRtargsRt
x((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_generativeis


(R	t	decoratortnon_generative(R6R9t	decorated((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR9as	
	
csz|
jd
i��
|
jdi�}g|D]*}|t
j|�
|j|d�f^q+�tj��
fd��
}|S(Ntmsgstdefaultsc
s�|
d
}|
d}
x]�D]U\}}}||�
|k	r�
j|d|j
|jf�}tj|�
�
qqW|||
|�
S(Nii
s9Method %s() has already been invoked on this %s construct(tgetRt	__class__RtInvalidRequestError(R6R7RRtnametgettertdefault_tmsg(tgettersR=(sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytcheck�s









(tpoptoperatort
attrgetterR?R4R	R:(tnamesRR>RBRG((RFR=sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_exclusive_againstws

4c
Ks
|j|
�S(
N(
R(R/R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�s
c
Cs#tj
g|D]}
|
j^q
�S(
s\expand the given set of ClauseElements to be the set of all 'cloned'
    predecessors.

    (R*R+t_cloned_set(R.R8((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_expand_cloned�scs;tt
|�
�
jt
|
�
�
�t�f
d
�|D�
�
S(s�return the intersection of sets a and b, counting
    any overlap between 'cloned' predecessors.

    The returned set is in terms of the entities present within 'a'.

    c
3s'|]}
�j|
j
�
r|
V
qdS(
N(tintersectionRM(t.0telem(
tall_overlap(sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>�s(tsetRNRO(t
at
b((
RRsD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_cloned_intersection�s!

cs;tt
|�
�
jt
|
�
�
�t�f
d
�|D�
�
S(Nc
3s'|]}
�j|
j
�
s|
V
qdS(
N(RORM(RPRQ(
RR(sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>�s(RSRNRO(RTRU((
RRsD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_cloned_difference�s
!

t_DialectArgViewc
BsMeZ
dZd
�Zd�Zd�Zd�Zd�Zd�Zd�Z	RS(saA dictionary view of dialect-level arguments in the form
    <dialectname>_<argument_name>.

    cCs
|
|_dS(
N(
R&(RR&((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR#�s
cCsYy|
jd
d�\}}Wn,t
k
rJ
}
tjt|
�
d|�


nX||fSdS(Nt
_i
treplace_context(tsplitt
ValueErrorR	traise_tKeyError(Rtkeytdialectt	value_keyterr((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_key�s




cCsg|j|
�
\}}y|j
j|}Wn/tjk
rZ
}
tjt|
�
d
|�


n	X||SdS(NRZ(RcR&tdialect_optionsRtNoSuchModuleErrorR	R]R^(RR_R`RatoptRb((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__getitem__�s



cCscy|j|
�
\}}Wn/t
k
rJ
}
tjtjd
�
d|�


nX||jj||<dS(Ns0Keys must be of the form <dialectname>_<argname>RZ(RcR^R	R]Rt
ArgumentErrorR&Rd(RR_tvalueR`RaRb((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__setitem__�s





	cCs*|j|
�
\}}|j
j||=dS(
N(RcR&Rd(RR_R`Ra((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__delitem__�s

c

Cs td
�|j
jj�D�
�
S(Nc
ss|]}
t|
j
�
V
qdS(
N(tlent
_non_defaults(RPR7((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>�s
(tsumR&Rdtvalues(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__len__�s


c

s�f
d
��jj
D�
S(Nc
3s9|]/}
�jj
|
jD]}d|
|fV
qqd
S(s%s_%sN(R&RdRm(RPtdialect_namet
value_name(
R(sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>�s

	
(R&Rd(
R((
RsD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__iter__�s
(
RRRR#RcRgRjRkRpRs(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRX�s			
	
		t_DialectArgDictc
BsDeZ
dZd
�Zd�Zd�Zd�Zd�Zd�ZRS(s�A dictionary view of dialect-level arguments for a specific
    dialect.

    Maintains a separate collection of user-specified arguments
    and dialect-specified default arguments.

    c

Csi|_i|_
dS(
N(Rmt	_defaults(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR#�s
	
c

Cstt
|j�
j|j�
�
S(
N(RlRSRmtunionRu(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRp�s
c

Cstt
|j�
j|j�
�
S(
N(titerRSRmRvRu(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRs
s
cCs)|
|jkr|j|
S|j
|
SdS(
N(RmRu(RR_((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRg
s

cCs||j|
<dS(
N(
Rm(RR_Ri((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRj	
s
cCs|j|
=dS(
N(
Rm(RR_((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRk
s
(	RRRR#RpRsRgRjRk(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRt�s					ssqlalchemy.dialectsc
Cs8tj
jjj|�
}
|
jdkr+dSt|
j�
S(
N(R	t	preloadedtdialectstregistrytloadtconstruct_argumentsR4tdict(Rqtdialect_cls((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_kw_reg_for_dialect
s


t
DialectKWArgscBs�eZ
dZd
ejfg
Zed��
Zej	d��
Z
ed��
Zej
e�
Zd�Zej	d��
Zd�ZRS(s9
Establish the ability for a class to have dialect-specific arguments
    with defaults and constructor validation.

    The :class:`.DialectKWArgs` interacts with the
    :attr:`.DefaultDialect.construct_arguments` present on a dialect.

    .. seealso::

        :attr:`.DefaultDialect.construct_arguments`

    RdcCsZtj
|
}|dkr/tjd
|
�
�
n||krHi||<n||||<dS(s�Add a new kind of dialect-specific keyword argument for this class.

        E.g.::

            Index.argument_for("mydialect", "length", None)

            some_index = Index('a', 'b', mydialect_length=5)

        The :meth:`.DialectKWArgs.argument_for` method is a per-argument
        way adding extra arguments to the
        :attr:`.DefaultDialect.construct_arguments` dictionary. This
        dictionary provides a list of argument names accepted by various
        schema-level constructs on behalf of a dialect.

        New dialects should typically specify this dictionary all at once as a
        data member of the dialect class.  The use case for ad-hoc addition of
        argument names is typically for end-user code that is also using
        a custom compilation scheme which consumes the additional arguments.

        :param dialect_name: name of a dialect.  The dialect must be
         locatable, else a :class:`.NoSuchModuleError` is raised.   The
         dialect must also include an existing
         :attr:`.DefaultDialect.construct_arguments` collection, indicating
         that it participates in the keyword-argument validation and default
         system, else :class:`.ArgumentError` is raised.  If the dialect does
         not include this collection, then any keyword argument can be
         specified on behalf of this dialect already.  All dialects packaged
         within SQLAlchemy include this collection, however for third party
         dialects, support may vary.

        :param argument_name: name of the parameter.

        :param default: default value of the parameter.

        .. versionadded:: 0.9.4

        sRDialect '%s' does have keyword-argument validation and defaults enabled configuredN(R�t_kw_registryR4RRh(RRqt
argument_nametdefaulttconstruct_arg_dictionary((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytargument_for)
s(








c

Cs
t|�
S(
s9A collection of keyword arguments specified as dialect-specific
        options to this construct.

        The arguments are present here in their original ``<dialect>_<kwarg>``
        format.  Only arguments that were actually passed are included;
        unlike the :attr:`.DialectKWArgs.dialect_options` collection, which
        contains all options known by this dialect including defaults.

        The collection is also writable; keys are accepted of the
        form ``<dialect>_<kwarg>`` where the value will be assembled
        into the list of options.

        .. versionadded:: 0.9.2

        .. versionchanged:: 0.9.4 The :attr:`.DialectKWArgs.dialect_kwargs`
           collection is now writable.

        .. seealso::

            :attr:`.DialectKWArgs.dialect_options` - nested dictionary form

        (
RX(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytdialect_kwargs[
sc


Cs|jS(
s4A synonym for :attr:`.DialectKWArgs.dialect_kwargs`.(
R�(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRu
scCs�tj
|
}t�}|dkr<|jji
dd
6�

n@x=t|jj�
D])}||krO|jj||�

qOqOW|S(Nt
*(	R�R�RtR4RutupdatetreversedR@t__mro__(RRqR�t
dR((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_kw_reg_for_dialect_cls|
s


	



c

Cstj
tj|j�
�
S(
s�
A collection of keyword arguments specified as dialect-specific
        options to this construct.

        This is a two-level nested registry, keyed to ``<dialect_name>``
        and ``<argument_name>``.  For example, the ``postgresql_where``
        argument would be locatable as::

            arg = my_object.dialect_options['postgresql']['where']

        .. versionadded:: 0.9.2

        .. seealso::

            :attr:`.DialectKWArgs.dialect_kwargs` - flat dictionary form

        (R	tPopulateDicttportable_instancemethodR�(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRd�
s
cCs%
|
s
dSx
|
D]
}tj
d
|�}|sBtd|�
�
n|jdd�\}}y|j|}Wngtjk
r�


tjd||f�

t	�|j|<}|j
ji
dd6�

|
||j
|<qXd|kr
||kr
tjd|||jf�
�
q|
|||<qWdS(Ns^(.+?)_(.+)$sGAdditional arguments should be named <dialectname>_<argument>, got '%s'i
isHCan't validate argument %r; can't locate any SQLAlchemy dialect named %rR�s9Argument %r is not accepted by dialect %r on behalf of %r(tretmatcht	TypeErrortgroupRdRReR	twarnRtRuR�R4RmRhR@(RRt
kt
mRqtarg_nameR�R�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_validate_dialect_kwargs�
s0















(RRRRtdp_dialect_optionst"_dialect_kwargs_traverse_internalsR)R�R	tmemoized_propertyR�tpropertyRR�RR�R�RdR�(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�
s2	tCompileStatecBs_eZ
dZdZiZed��
Zd�Zed��
Zed��
Z	ed��
Z
RS(sProduces additional object state necessary for a statement to be
    compiled.

    the :class:`.CompileState` class is at the base of classes that assemble
    state for a particular statement object that is then used by the
    compiler.   This process is essentially an extension of the process that
    the SQLCompiler.visit_XYZ() method takes, however there is an emphasis
    on converting raw user intent into more organized structures rather than
    producing string output.   The top-level :class:`.CompileState` for the
    statement being executed is also accessible when the execution context
    works with invoking the statement and collecting results.

    The production of :class:`.CompileState` is specific to the compiler,  such
    as within the :meth:`.SQLCompiler.visit_insert`,
    :meth:`.SQLCompiler.visit_select` etc. methods.  These methods are also
    responsible for associating the :class:`.CompileState` with the
    :class:`.SQLCompiler` itself, if the statement is the "toplevel" statement,
    i.e. the outermost SQL statement that's actually being executed.
    There can be other :class:`.CompileState` objects that are not the
    toplevel, such as when a SELECT subquery or CTE-nested
    INSERT/UPDATE/DELETE is generated.

    .. versionadded:: 1.4

    t	statementcKs�|
jrd|
jj
d
d�}|jj
||
jfd�}|dkrz|jd|
jf}qzn|jd|
jf}||kr�||
||�S|j|
||�SdS(Ntcompile_state_pluginR�(t_propagate_attrsR?tpluginst_effective_plugin_targetR4tcreate_for_statement(RR�tcompilerRtplugin_nametklass((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR��
s	
	
	




cKs
|
|_dS(
N(
R�(RR�R�R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR#s
cCsx|
jj
d
d�}|rG||
jf}||jkrG|j|Sny|jd|
jfSWntk
rs


dSXdS(NR�R�(R�R?R4R�R�R^(RR�R�R_((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytget_plugin_classs	







cCs1y|j||
j
fSWntk
r,


dSXdS(
N(R�R�R^R4(RR�R�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_get_plugin_class_for_plugins




cs��
�fd
�}|S(Nc

s|�j�
�f<|S(
N(
R�(
tcls_to_decorate(RR�t
visit_name(sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytdecorate"s

((RR�R�R�((RR�R�sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt
plugin_for s(
R�(RRRt	__slots__R�R)R�R#R�R�R�(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR��
s		t
Generativec
BseZ
dZd
�ZRS(sUProvide a method-chaining pattern in conjunction with the
    @_generative decorator.c
sh|j�|j
}
|
j|
�
}�rR�f
d
�|jj�j�D�
|_n|jj�|_|S(Nc
s+i|]!\}
}|
�kr||
�qS(((RPR�t
v(
tskip(sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys
<dictcomp>4s	(t_memoized_keysR@R!t__dict__tcopytitems(RRt
s((
R�sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR3-s
	
	

+
(RRRR3(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�)stInPlaceGenerativec
BseZ
dZd
�ZRS(skProvide a method-chaining pattern in conjunction with the
    @_generative decorator that mutates in place.c
Cs1|j}
x!|
D]}|j
j|d�
qW|S(
N(R�R�RHR4(RR�R�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR3?s
	



(RRRR3(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�;stHasCompileStatec
Bs)eZ
dZd
Zej�Zej	Z
RS(s=A class that has a :class:`.CompileState` associated with it.N(RRRR4t_compile_state_pluginR	t
immutabledictt_attributesR�R�t_compile_state_factory(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�Fs
t_MetaOptionsc
Bs eZ
dZd
�Zd�ZRS(s metaclass for the Options class.cCs9tt
d
�|D�
�
�
|_tj||
||�
dS(Nc
ss1|]'}
|
jd�
r|
dkr|
V
qdS(t__t_cache_key_traversalN(
R�(
t
startswith(RPR�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>Vs


(ttupletsortedt_cache_attrsttypeR#(Rt	classnametbasestdict_((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR#Ss




cCs`|�}t|
�
j
|j�
rLtd
|t|
�
j
|j�
f�
�
n|jj|
�

|S(NsBdictionary contains attributes not covered by Options class %s: %r(RSt
differenceR�R�R�R�(Rtotherto1((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__add__^s
	

%
(RRRR#R�(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�Ps
	tOptionscBs�eZ
dZd
�Zd�Zd�Zd�Zed��
Ze	d��
Z
e	d��
Zej
�Zejd��
Zed	��
Zed
��
ZRS(s,A cacheable option dictionary with defaults.c
Ks|jj
|
�

dS(
N(R�R�(RR((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR#os
cCs|jj
|j�
}|jj|j�

t|
�
j|j�
rktd
|t|
�
j|j�
f�
�
n|jj|
�

|S(NsBdictionary contains attributes not covered by Options class %s: %r(R@R!R�R�RSR�R�R�(RR�R�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�rs



%
cCsOxHtj
|j|
j�D].\}}t||�t|
|�krtSqWtS(
N(R	tzip_longestR�tgetattrtFalseR(RR�RTRU((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__eq__�s%


c

s0d
�jj
dj�f
d��jD�
�
fS(Ns%s(%s)s, c
3s5|]+}
|
�jkrd|
�j|
fV
qd
S(s%s=%rN(
R�(RPR�(
R(sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>�s

(R@RtjoinR�(
R((
RsD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__repr__�s

	


cCs
t||
�S(
N(
t
issubclass(RR�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt
isinstance�scCs|i
t||
�||
6S(
N(
R�(RRBRi((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytadd_to_element�sc


Cs|jS(
N(
R�(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_state_dict�sc


Cs|jS(
N(
t_state_dict_const(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR��scCsx|
j�}||
j
k	rp|
jrpt|
j�
j|j�
rptd
|
|t|
j�
j|j�
f�
�
n||S(Ns]other element %r is not empty, is not of type %s, and contains attributes not covered here %r(R�R@R�RSR�R�(RR�R�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt
safe_merge�s
	



%cCs�|jt
|�
j|�
�
}|j|
|�}|r�i}xR|D]J}d
|}	||krp||||	<qC||krC||||	<qCqCW||}
tj�j|i
|
|
6�}|
|fS||fSdS(s{process Options argument in terms of execution options.


        e.g.::

            (
                load_options,
                execution_options,
            ) = QueryContext.default_load_options.from_execution_options(
                "_sa_orm_load_options",
                {
                    "populate_existing",
                    "autoflush",
                    "yield_per"
                },
                execution_options,
                statement._execution_options,
            )

        get back the Options and refresh "_sa_orm_load_options" in the
        exec options dict w/ the Options as well

        RYN(RORSRvR?R	R�t
merge_with(RR_tattrstexec_optionststatement_exec_optionstcheck_argnamestexisting_optionstresulttargnametlocaltnew_options((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytfrom_execution_options�s 













(RRRR#R�R�R�R)R�RR�R�R	R�R�t
classlevelR�R�(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�ls
				tCacheableOptionscBs8eZ
ed��
Zejd
��
Zed��
ZRS(cCstj
||
|�S(
N(Rt_gen_cache_key(Rtanon_mapt
bindparams((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR��scCs
|d
fS(N(((RR�R�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR��sc

Cs
tj
|�
S(
N(Rt_generate_cache_key_for_object(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_generate_cache_key�s(RRRR�R�R�(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR��s
tExecutableOptionc
Bs&eZ
ejZdZeZd
�ZRS(texecutable_optionc
Ks+|jj
|j�
}t|j�
|_|S(
s/Create a shallow copy of this ExecutableOption.(R@R!R}R�(RRR1((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRs

(	RRR	t
EMPTY_DICTt_annotationst__visit_name__R�t_is_has_cache_keyR(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�s
	t
ExecutablecBsI
eZ
dZeZej�ZdZ	dZ
dZd
ej
fdejfdejfgZeZeZeZeZeZeZed��
Zed��
Zed��
Zed��
Zed��
Zed	��
Z d
�Z!ej"ddd
�

d��
Z#ej"ddd�

d��
Z$eej"dddde�
d��
�
Z%RS(s�Mark a :class:`_expression.ClauseElement` as supporting execution.

    :class:`.Executable` is a superclass for all "statement" types
    of objects, including :func:`select`, :func:`delete`, :func:`update`,
    :func:`insert`, :func:`text`.

    t
_with_optionst_with_context_optionsR�c


Cs|jS(
N(
R�(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�1sc
Gs#|jt
d
�|
D�
�
7_dS(sKApply options to this statement.

        In the general sense, options are any kind of Python object
        that can be interpreted by the SQL compiler for the statement.
        These options can be consumed by specific dialects or specific kinds
        of compilers.

        The most commonly known kind of option are the ORM level options
        that apply "eager load" and other loading behaviors to an ORM
        query.   However, options can theoretically be used for many other
        purposes.

        For background on specific kinds of options for specific kinds of
        statements, refer to the documentation for those option objects.

        .. versionchanged:: 1.4 - added :meth:`.Generative.options` to
           Core statement objects towards the goal of allowing unified
           Core / ORM querying capabilities.

        .. seealso::

            :ref:`deferred_options` - refers to options specific to the usage
            of ORM queries

            :ref:`relationship_loader_options` - refers to options specific
            to the usage of ORM queries

        c
ss$|]}
tj
tj|
�V
qdS(
N(t	coercionstexpectRtExecutableOptionRole(RPRf((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>Ts
N(R�R�(Rtoptions((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�5s


cCs
|
|_d
S(s|Assign the compile options to a new value.

        :param compile_options: appropriate CacheableOptions structure

        N(
t_compile_options(Rtcompile_options((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_set_compile_optionsXscCs|j|
7_d
S(s*update the _compile_options with new keys.N(
R�(RR�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_update_compile_optionsbscCs|j|
|ff
7_d
S(sM
Add a context option to this statement.

        These are callable functions that will
        be given the CompileState object upon compilation.

        A second argument cache_args is required, which will be combined with
        the ``__code__`` identity of the function itself in order to produce a
        cache key.

        N(
R�(Rt	callable_t
cache_args((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_add_context_optionhsc
KsUd
|
krtj
d�
�
nd|
kr<tj
d�
�
n|jj|
�
|_dS(s�Set non-SQL options for the statement which take effect during
        execution.

        Execution options can be set on a per-statement or
        per :class:`_engine.Connection` basis.   Additionally, the
        :class:`_engine.Engine` and ORM :class:`~.orm.query.Query`
        objects provide
        access to execution options which they in turn configure upon
        connections.

        The :meth:`execution_options` method is generative.  A new
        instance of this statement is returned that contains the options::

            statement = select(table.c.x, table.c.y)
            statement = statement.execution_options(autocommit=True)

        Note that only a subset of possible execution options can be applied
        to a statement - these include "autocommit" and "stream_results",
        but not "isolation_level" or "compiled_cache".
        See :meth:`_engine.Connection.execution_options` for a full list of
        possible options.

        .. seealso::

            :meth:`_engine.Connection.execution_options`

            :meth:`_query.Query.execution_options`

            :meth:`.Executable.get_execution_options`

        tisolation_levels�'isolation_level' execution option may only be specified on Connection.execution_options(), or per-engine using the isolation_level argument to create_engine().tcompiled_cachesm'compiled_cache' execution option may only be specified on Connection.execution_options(), not per statement.N(RRht_execution_optionsRv(RR((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytexecution_optionsvs!



c


Cs|jS(
s�Get the non-SQL options which will take effect during execution.

        .. versionadded:: 1.3

        .. seealso::

            :meth:`.Executable.execution_options`
        (
R�(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytget_execution_options�s	s:meth:`.Executable.execute`talternatives�All statement execution in SQLAlchemy 2.0 is performed by the :meth:`_engine.Connection.execute` method of :class:`_engine.Connection`, or in the ORM by the :meth:`.Session.execute` method of :class:`.Session`.c
Osk|j}|dkrOt|d
d�p0|jj}d|}tj|�
�
n|j||
|tj	��S(s.Compile and execute this :class:`.Executable`.tdescriptions�This %s is not directly bound to a Connection or Engine. Use the .execute() method of a Connection or Engine to execute this construct.N(
tbindR4R�R@RRtUnboundExecutionErrort_execute_clauseelementR	R�(RtmultiparamsRt
etlabelRE((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytexecute�s
	


s:meth:`.Executable.scalar`s�Scalar execution in SQLAlchemy 2.0 is performed by the :meth:`_engine.Connection.scalar` method of :class:`_engine.Connection`, or in the ORM by the :meth:`.Session.scalar` method of :class:`.Session`.c
Os|j|
|�j
�S(
snCompile and execute this :class:`.Executable`, returning the
        result's scalar representation.

        (R

tscalar(RR
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR
�s
s:attr:`.Executable.bind`s5Bound metadata is being removed as of SQLAlchemy 2.0.tenable_warningsc
Cs`|jd
k	r|jSxCt|�
D]1}
|
|kr;q#n|
j}|d
k	r#|Sq#Wd
Sd
S(sK
Returns the :class:`_engine.Engine` or :class:`_engine.Connection`
        to
        which this :class:`.Executable` is bound, or None if none found.

        This is a traversal which checks locally, then
        checks among the "from" clauses of associated objects
        until a bound engine or connection is found.

        N(t_bindR4R-R
(Rt
ftengine((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR
�s



	

N(((&RRRRtsupports_executionR	R�R�R4R

R�R�Rtdp_executable_optionsRtdp_with_context_optionstdp_propagate_attrst_executable_traverse_internalsR�t	is_selectt	is_updatet	is_inserttis_textt	is_deletetis_dmlR�R�R9R�R�R�R�R
R

t
deprecated_20R

R
R
(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�sD




	




#
/	








tprefix_anon_mapc
BseZ
dZd
�ZRS(sf
A map that creates new keys for missing key access.

    Considers keys of the form "<ident> <name>" to produce
    new symbols "<name>_<index>", where "index" is an incrementing integer
    corresponding to <name>.

    Inlines the approach taken by :class:`sqlalchemy.util.PopulateDict` which
    is otherwise usually used for this type of operation.

    cCsZ|
jd
d�\}}|j
|d�}|d||<|dt|�
}|||
<|S(Nt
 i
RY(R[R?tstr(RR_tidenttderivedtanonymous_counterRi((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__missing__
s






(RRRR"
(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR
�s
tSchemaEventTargetc
Bs eZ
dZd
�Zd�ZRS(s�Base class for elements that are the targets of :class:`.DDLEvents`
    events.

    This includes :class:`.SchemaItem` as well as :class:`.SchemaType`.

    c
Ksd
S(s0Associate with this SchemaEvent's parent object.N((RtparentR((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_set_parenttcKs:|jj
||
�
|j|
|�

|jj||
�
dS(
N(tdispatchtbefore_parent_attachR%
tafter_parent_attach(RR$
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_set_parent_with_dispatchs


(RRRR%
R*
(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR#

s	t
SchemaVisitorcBseZ
dZi
ed
6ZRS(s/Define the visiting for ``SchemaItem`` objects.tschema_visitor(RRRRt__traverse_options__(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR+
s
tColumnCollectioncBs1
eZ
dZd!Zd"d�
Zd�Zed��
Zd�Z	d�Z
d	�Zd
�Zd�Z
d�Zd
�Zd�Zd�Zd�Zd�Zd"d�
Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd"Zd�Zd"d�
Zd�Zd�Z d�Z!d�Z"e#d �
Z$RS(#s�Collection of :class:`_expression.ColumnElement` instances,
    typically for
    :class:`_sql.FromClause` objects.

    The :class:`_sql.ColumnCollection` object is most commonly available
    as the :attr:`_schema.Table.c` or :attr:`_schema.Table.columns` collection
    on the :class:`_schema.Table` object, introduced at
    :ref:`metadata_tables_and_columns`.

    The :class:`_expression.ColumnCollection` has both mapping- and sequence-
    like behaviors. A :class:`_expression.ColumnCollection` usually stores
    :class:`_schema.Column` objects, which are then accessible both via mapping
    style access as well as attribute access style.

    To access :class:`_schema.Column` objects using ordinary attribute-style
    access, specify the name like any other object attribute, such as below
    a column named ``employee_name`` is accessed::

        >>> employee_table.c.employee_name

    To access columns that have names with special characters or spaces,
    index-style access is used, such as below which illustrates a column named
    ``employee ' payment`` is accessed::

        >>> employee_table.c["employee ' payment"]

    As the :class:`_sql.ColumnCollection` object provides a Python dictionary
    interface, common dictionary method names like
    :meth:`_sql.ColumnCollection.keys`, :meth:`_sql.ColumnCollection.values`,
    and :meth:`_sql.ColumnCollection.items` are available, which means that
    database columns that are keyed under these names also need to use indexed
    access::

        >>> employee_table.c["values"]


    The name for which a :class:`_schema.Column` would be present is normally
    that of the :paramref:`_schema.Column.key` parameter.  In some contexts,
    such as a :class:`_sql.Select` object that uses a label style set
    using the :meth:`_sql.Select.set_label_style` method, a column of a certain
    key may instead be represented under a particular label name such
    as ``tablename_columnname``::

        >>> from sqlalchemy import select, column, table
        >>> from sqlalchemy import LABEL_STYLE_TABLENAME_PLUS_COL
        >>> t = table("t", column("c"))
        >>> stmt = select(t).set_label_style(LABEL_STYLE_TABLENAME_PLUS_COL)
        >>> subq = stmt.subquery()
        >>> subq.c.t_c
        <sqlalchemy.sql.elements.ColumnClause at 0x7f59dcf04fa0; t_c>

    :class:`.ColumnCollection` also indexes the columns in order and allows
    them to be accessible by their integer position::

        >>> cc[0]
        Column('x', Integer(), table=None)
        >>> cc[1]
        Column('y', Integer(), table=None)

    .. versionadded:: 1.4 :class:`_expression.ColumnCollection`
       allows integer-based
       index access to the collection.

    Iterating the collection yields the column expressions in order::

        >>> list(cc)
        [Column('x', Integer(), table=None),
         Column('y', Integer(), table=None)]

    The base :class:`_expression.ColumnCollection` object can store
    duplicates, which can
    mean either two columns with the same key, in which case the column
    returned by key  access is **arbitrary**::

        >>> x1, x2 = Column('x', Integer), Column('x', Integer)
        >>> cc = ColumnCollection(columns=[(x1.name, x1), (x2.name, x2)])
        >>> list(cc)
        [Column('x', Integer(), table=None),
         Column('x', Integer(), table=None)]
        >>> cc['x'] is x1
        False
        >>> cc['x'] is x2
        True

    Or it can also mean the same column multiple times.   These cases are
    supported as :class:`_expression.ColumnCollection`
    is used to represent the columns in
    a SELECT statement which may include duplicates.

    A special subclass :class:`.DedupeColumnCollection` exists which instead
    maintains SQLAlchemy's older behavior of not allowing duplicates; this
    collection is used for schema level objects like :class:`_schema.Table`
    and
    :class:`.PrimaryKeyConstraint` where this deduping is helpful.  The
    :class:`.DedupeColumnCollection` class also has additional mutation methods
    as the schema constructs have more use cases that require removal and
    replacement of columns.

    .. versionchanged:: 1.4 :class:`_expression.ColumnCollection`
       now stores duplicate
       column keys as well as the same column in multiple positions.  The
       :class:`.DedupeColumnCollection` class is added to maintain the
       former behavior in those cases where deduplication as well as
       additional replace/remove operations are needed.


    t_collectiont_indext_colsetcCsVtj
|d
t��
tj
|di�
tj
|dg�
|
rR|j|
�

ndS(NR1
R0
R/
(R"t__setattr__RSt_initial_populate(Rtcolumns((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR#�s





cCs|j|
�

dS(
N(
t_populate_separate_keys(Rtiter_((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR3
�s
c
Cs g|jD]\}
}|^q
S(
N(
R/
(RR�tcol((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_all_columns�sc
Cs g|jD]\}
}|
^q
S(
sQReturn a sequence of string key names for all columns in this
        collection.(
R/
(RR�R7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytkeys�sc
Cs g|jD]\}
}|^q
S(
s�Return a sequence of :class:`_sql.ColumnClause` or
        :class:`_schema.Column` objects for all columns in this
        collection.(
R/
(RR�R7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRo�sc

Cs
t|j
�
S(
s�Return a sequence of (key, column) tuples for all columns in this
        collection each consisting of a string key name and a
        :class:`_sql.ColumnClause` or
        :class:`_schema.Column` object.
        (tlistR/
(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR��sc

Cs
t|j
�
S(
N(tboolR/
(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__bool__�s
c

Cs
t|j
�
S(
N(RlR/
(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRp�s
c
Cs&tg|j
D]\}
}|^q
�
S(
N(RwR/
(RR�R7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRs�scCsZy|j|
SWnDt
k
rU
}
t|
tj�rOtjt|
�
d
|�


qV�n
XdS(NRZ(R0
R^R�R	t	int_typesR]t
IndexError(RR_Rb((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRg�s




cCsBy|j|
SWn,t
k
r=
}
tjt|
�
d
|�


n
XdS(NRZ(R0
R^R	R]tAttributeError(RR_Rb((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__getattr__�s



cCs?|
|jkr7t
|
tj�s3tjd
�
�
ntStSdS(Ns'__contains__ requires a string argument(R0
R�R	tstring_typesRRhR�R(RR_((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__contains__�s



cCs;x4tj
||
�D]\}}||k	rtSqWtSd
S(sdCompare this :class:`_expression.ColumnCollection` to another
        based on the names of the keysN(R	R�R�R(RR�t
lt
r((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytcompare�s

cCs
|j|
�
S(
N(
RE
(RR�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR��s
cCs"|
|jkr|j|
S|Sd
S(s�Get a :class:`_sql.ColumnClause` or :class:`_schema.Column` object
        based on a string key name from this
        :class:`_expression.ColumnCollection`.N(
R0
(RR_R�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR?�s
c

Cs'd
|jj
djd�|D�
�
fS(Ns%s(%s)s, c
ss|]}
t|
�
V
qdS(
N(
R
(RPR1((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>�s(R@RR�(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__str__�s

	
c
Cs
t��
dS(
N(
R(RR_Ri((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRj�s
c
Cs
t��
dS(
N(
R(RR_((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRk�s
c
Cs
t��
dS(
N(
R(RR_R&((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR2
�s
c


Cs
t��
d
S(sQDictionary clear() is not implemented for
        :class:`_sql.ColumnCollection`.N(
R(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytclear�sc
Cs
t��
d
S(sRDictionary remove() is not implemented for
        :class:`_sql.ColumnCollection`.N(
R(Rtcolumn((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytremovesc
Cs
t��
d
S(sRDictionary update() is not implemented for
        :class:`_sql.ColumnCollection`.N(
R(RR6
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�scCs}t|
�
}||j
(|jjd
�|j
D�
�

|jjd�t|j
�
D�
�

|jjd�t|j
�
D�
�

dS(s*populate from an iterator of (key, column)c
ss|]\}
}|V
qdS(
N((RPR�R1((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>sc
ss'|]\}
\}}|
|fV
qdS(
N((RPtidxR�R1((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>sc
Ssi|]\}
}||
�qS(((RPR�R7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys
<dictcomp>s	N(R:
R/
R1
R�R0
t	enumerateR�(RR6
tcols((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR5
s



	
cCs}|d
kr|
j
}nt|j�
}|jj||
f�

|jj|
�

|
|j|<||jkry|
|j|<nd
S(s�
Add a column to this :class:`_sql.ColumnCollection`.

        .. note::

            This method is **not normally used by user-facing code**, as the
            :class:`_sql.ColumnCollection` is usually part of an existing
            object such as a :class:`_schema.Table`. To add a
            :class:`_schema.Column` to an existing :class:`_schema.Table`
            object, use the :meth:`_schema.Table.append_column` method.

        N(R4R_RlR/
tappendR1
taddR0
(RRH
R_RC
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRN
s






c

Csi|jd
6|j
d6S(NR/
R0
(R/
R0
(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__getstate__,s
cCsRtj
|d
|
d
�
tj
|d|
d�
tj
|dd�|jD�
�
dS(NR0
R/
R1
c
Ssh|]\}
}|�qS(((RPR�R7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<setcomp>3s	(R"R2
R/
(Rtstate((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt__setstate__/s



cCs?|
|jkr7t
|
tj�r3tjd
�
�
ntStSdS(s3Checks if a column object exists in this collectionsZcontains_column cannot be used with string arguments. Use ``col_name in table.c`` instead.N(R1
R�R	RA
RRhR�R(RR7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytcontains_column6s


c

Cs
t|�
S(
sJReturn an "immutable" form of this
        :class:`_sql.ColumnCollection`.(
tImmutableColumnCollection(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytas_immutableBscCs�
d
�}|
|jkr|
Sd\}}|
j}g|jD]\}}|^q;}	xX
|	D]P
}tt|j�
�
}
|j|
�
}|rZ|s�||
|�rZ|dkr�||}}q�
t|�
t|�
kr�||}}q�
||kr�
tj	t
jg|j�D]*}|j
|
�
r	
|jjdd�^q	
�}
tj	t
jg|j�D]*}|j
|
�
rU
|jjdd�^qU
�}||
kr�
||}}q�
q�
qZqZW|S(s�Given a :class:`_expression.ColumnElement`, return the exported
        :class:`_expression.ColumnElement` object from this
        :class:`_expression.ColumnCollection`
        which corresponds to that original :class:`_expression.ColumnElement`
        via a common
        ancestor column.

        :param column: the target :class:`_expression.ColumnElement`
                      to be matched.

        :param require_embedded: only return corresponding columns for
         the given :class:`_expression.ColumnElement`, if the given
         :class:`_expression.ColumnElement`
         is actually present within a sub-element
         of this :class:`_expression.Selectable`.
         Normally the column will match if
         it merely shares a common ancestor with one of the exported
         columns of this :class:`_expression.Selectable`.

        .. seealso::

            :meth:`_expression.Selectable.corresponding_column`
            - invokes this method
            against the collection returned by
            :attr:`_expression.Selectable.exported_columns`.

        .. versionchanged:: 1.4 the implementation for ``corresponding_column``
           was moved onto the :class:`_expression.ColumnCollection` itself.

        cSs@x9|
j|�
D](}t
t|g
�
�
j|�
stSqWtS(
N(R�RSRNROR�R(texpanded_proxy_sett
target_sett
t((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytembeddedhs



	
tweighti
N(NN(R1
R4R%R/
RSRNRORlR	treduceRIRN
t_uncached_proxy_listtshares_lineageR�R?(RRH
trequire_embeddedRX
R7
t	intersectRV
R�R1RL
RU
t
itsctcol_distancet
c_distance((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytcorresponding_columnHs< 		


	
"











-


-

(R/
R0
R1
N(%RRRR�R4R#R3
R�R8
R9
RoR�R<
RpRsRgR@
RB
RE
R�R?RF
RjRkR2
RG
RI
R�t__hash__R5
RN
RO
RQ
RR
RT
R�Rc
(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR.
!s@k												
	
	
								
				tDedupeColumnCollectioncBs>eZ
dZdd
�
Zd�Zd�Zd�Zd�ZRS(su
A :class:`_expression.ColumnCollection`
    that maintains deduplicating behavior.

    This is useful by schema level objects such as :class:`_schema.Table` and
    :class:`.PrimaryKeyConstraint`.    The collection includes more
    sophisticated mutator methods as well to suit schema objects which
    require mutable column collections.

    .. versionadded:: 1.4

    cCs�|dk	r-|
j
|kr-tjd
�
�
n|
j
}|dkrTtjd�
�
n||jkr�|j|}||
kr�dS|j|
�

tjj|
d�
nOt	|j
�
}|j
j||
f�

|jj
|
�

|
|j|<|
|j|<dS(NsKDedupeColumnCollection requires columns be under the same key as their .keys-Can't add unnamed column to column collectionR%(R4R_RRhR0
treplaceR	R�tresetRlR/
RM
R1
RN
(RRH
R_texistingRC
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRN
�s$

	









cCs%
t|
�
}g}x�|D]�\}}|j
|krFtjd
�
�
n|j|jkrz|j
|jkrz|j|�

q|j
|jkr�|j|�

q||j|<|jj||f�

qW|jj	d�|jD�
�

|jj	d�t
|j�
D�
�

x|D]}|j|�

q

WdS(s*populate from an iterator of (key, column)sKDedupeColumnCollection requires columns be under the same key as their .keyc
ss|]\}
}|V
qdS(
N((RPR�R1((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>�sc
ss'|]\}
\}}|
|fV
qdS(
N((RPRJ
R�R1((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>�sN(R:
R_RRhRBR0
RM
R/
R1
R�RK
Rf
(RR6
RL
treplace_colR�R7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR5
�s"



$






	


cCs|jd
�|
D�
�

dS(Nc
ss|]}
|
j|
fV
qdS(
N(
R_(RPR7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>�s(
R5
(RR6
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pytextend�s
cCs�|
|jkr"t
d
|
�
�
n|j|
j=|jj|
�

g|jD]$\}}||
k	rI||f^qI|j(|jjd�t|j�
D�
�

|jt|j�
=dS(Ns8Can't remove column %r; column is not in this collectionc
Ss%i|]\}
\}}||
�qS(((RPRJ
R�R7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys
<dictcomp>
s	(	R1
R\R0
R_RI
R/
R�RK
Rl(RRH
R�R1((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRI
�s






8	
cCs�
t�}|
j
|jkrb|
j|
j
krb|j|
j
}|j
|jkrb|j|�

qbn|
j|jkr�|j|j|
j�

ng}t}x^|jD]S\}}||kr�|s�t}|j|
j|
f�

q�q�|j||f�

q�W|r
|j	j
|�

n|s3
|j|
j|
f�

n|j	j|
�

||j(|jj�
|jjd
�t
|j�
D�
�

|jj|j�

dS(sadd the given column to this collection, removing unaliased
        versions of this column  as well as existing columns with the
        same key.

        e.g.::

            t = Table('sometable', metadata, Column('col1', Integer))
            t.columns.replace(Column('col1', Integer, key='columnone'))

        will remove the original 'col1' from the collection, and add
        the new column under the name 'columnname'.

        Used by schema.Column to override columns during table reflection.

        c
Ss%i|]\}
\}}||
�qS(((RPRJ
R�R7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys
<dictcomp>6s	N(RSRBR0
R_RN
R�R/
RRM
R1
tdifference_updateRG
R�RK
(RRH
t
remove_colR�tnew_colstreplacedR�R7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRf
s2	$















	
N(	RRRR4RN
R5
Rj
RI
Rf
(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRe
�s"			RS
cBs=eZ
dZd
�Zd�Zd�ZejjZ	Z
ZRS(t_parentcCsYtj
|d
|
�
tj
|d|
j�
tj
|d|
j�
tj
|d|
j�
dS(NRo
R1
R0
R/
(R"R2
R1
R0
R/
(Rt
collection((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR#>s



c

Csi
|jd
6S(NRo
(
Ro
(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRO
Ds
cCs|
d
}|j|�

dS(NRo
(
R#(RRP
R$
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRQ
Gs


(
Ro
(RRR�R#RO
RQ
R	tImmutableContainert
_immutableRN
Rj
RI
(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRS
;s

			t	ColumnSetc
Bs5eZ
d�Zd
�Zd�Zd�Zd�ZRS(cCs
|
|kS(
N((RR7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRR
Os
cCs"x|
D]}|j|�

qWdS(
N(
RN
(RRL
R7
((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRj
Rs


cCst|�
t|
�
S(
N(
R:
(RR�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�Vs
cCsZg}xD|
D]<}x3|D]+}|j|�
r|j
||k�

qqWq
Wtj|�S(
N(R\
RM
R.tand_(RR�RC
R1R�((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyR�Ys







c

Cstt
d
�|D�
�
�
S(Nc
ss|]}
|
V
qdS(
N((RPR8((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pys	<genexpr>bs(thashR�(
R((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRd
as
(RRRR
Rj
R�R�Rd
(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyRs
Ns

				cCs�tj
d
�

|j}|s�|jj}t|dt|dd��}|r_d||f}n
d|}|
dkr�d|}
ntj|
�
�
n|S(Ns|The ``bind`` argument for schema methods that invoke SQL against an engine or connection will be required in SQLAlchemy 2.0.tfullnameRBs%s object %rs	%s objectsm%s is not bound to an Engine or Connection.  Execution can not proceed without a database to execute against.(	R	twarn_deprecated_20R
R@RR�R4RR
(t
schemaitemRER
RBR	
titem((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_bind_or_errores
	








c
CsVy|jSWnDt
k
rQ


x4tj|�
D]}
t|
d
�r+|
jSq+W�n
XdS(s�Return the nearest .entity_namespace for the given entity.

    If not immediately available, does an iterate to find a sub-element
    that has one, if any.

    tentity_namespaceN(R{
R?
R
titeratethasattr(tentityRQ((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_entity_namespaces





cCsyy9t|�
}|t
k	r+t||
|�St||
�SWn9tk
rt
}
tjtjd
||
f�
d|�


n
XdS(s�Return an entry from an entity_namespace.


    Raises :class:`_exc.InvalidRequestError` rather than attribute error
    on not found.

    s.Entity namespace for "%s" has no property "%s"RZN(R
R
R�R?
R	R]RRA(R~
R_R�tnsRb((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt_entity_namespace_key�s	







(DRR*RIR�R&
RR
t
traversalsRRRRRRRR	R
RR4R�R.ttype_apitsymbolRR
R"RRR-R2R9RLRRNRVRWtcollections_abctMutableMappingRXRttpreload_moduleRR�R�R�R�R�R�R�twith_metaclassR�R�R�t
StatementRoleR�R}R
R#
R+
R.
Re
Rq
RS
tordered_column_setRs
Rz
R
R�
(((sD/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/base.pyt<module>
sl















		
					
	< �b
�����