Ñò
‰„[Jc
@ s d d k l Z l Z l Z l Z l Z d d k l Z l Z l Z d d k
l Z d „ Z d „ Z
e e e e d „ Z d „ Z e d „ Z d e f d
„ ƒ YZ h Z d d k l Z xr e i i ƒ e i e i g D]Q Z e e e ƒ o; e e e i ƒ o( d e i f e ƒ Ud
e i d UqÜ qÜ Wd d „ Z! d „ Z" d d „ Z# d „ Z$ d d e d „ Z% d d „ Z& d e f d „ ƒ YZ' d e i( f d „ ƒ YZ) d e) f d „ ƒ YZ* d S( iÿÿÿÿ( t exct schemat topologicalt utilt sql( t
expressiont operatorst visitors( t chainc sf t ˆ ƒ ‰ g ‰ ‡ ‡ f d † } x/ ˆ D]' } t i | h t d 6h | d 6ƒ q+ Wt i ˆ ˆ ƒ S( sL sort a collection of Table objects in order of their foreign-key dependency.c sO | i o d S| i i } | ˆ j o# | i i } ˆ i | | f ƒ n d S( N( t use_altert columnt tablet parentt append( t fkeyt parent_tablet child_table( t tuplest tables( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt visit_foreign_key s
t schema_visitort foreign_key( t listR t traverset TrueR t sort( R R R ( ( R R s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt sort_tables s %c C sf t t i | ƒ ƒ } xJ t | ƒ D]8 \ } } x) | D]! } | i | ƒ o | | f Sq5 Wq" Wd Sd S( s³ Given a list of FROM clauses and a selectable,
return the first index and element from the list of
clauses which can be joined against the selectable. returns
None, None if no match is found.
e.g.::
clause1 = table1.join(table2)
clause2 = table4.join(table5)
join_to = table2.join(table3)
find_join_source([clause1, clause2], join_to) == clause1
N( NN( R R t
_from_objectst enumeratet is_derived_fromt None( t clausest join_tot selectablest it ft s( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt find_join_source s
c s® g ‰ h } ‡ f d † } | o | | d <| d Can't find any foreign key relationships between '%s' and '%s'i s® Can't determine join between '%s' and '%s'; tables have more than one foreign key constraint relationship between them. Please specify the 'onclause' of this join explicitly.N( t sett foreign_keyst get_referentR t NoReferencedTableErrorR
R R6 t
constraintt lent
ArgumentErrort descriptionR t and_( t at bt ignore_nonexistent_tablest critt constraintst fkR7 ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt join_conditionW sH
t Annotatedc B sM e Z d Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z RS( s§ clones a ClauseElement and applies an 'annotations' dictionary.
Unlike regular clones, this clone also mimics __hash__() and
__cmp__() of the original element so that it takes its place
in hashed collections.
A reference to the original element is maintained, for the important
reason of keeping its hash value current. When GC'ed, the
hash value may be reused, causing conflicts.
c G s | p t i | ƒ S| \ } } y t | i } WnI t j
o= t i t d | i i t | i f h ƒ } t | i R„ R6 R R R t ColumnSetRƒ (
Rˆ R t kwRF R7 RI RY t fk_colR‰ R/ ( ( R‡ Rˆ s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt reduce_columns s4
"c s] ˆ o ˆ o t i d ƒ ‚ n ‡ ‡ ‡ ‡ f d † } g ‰ t i | h h | d 6ƒ ˆ S( s9 traverse an expression and locate binary criterion pairs.sS Can only specify one of 'consider_as_foreign_keys' or 'consider_as_referenced_keys'c sC ˆ o | i t i j o d St | i t i ƒ p t | i t i ƒ o d Sˆ o¤ | i ˆ j o@ | i | i j p | i ˆ j o ˆ i | i | i f ƒ q?| i ˆ j o@ | i | i j p | i ˆ j o ˆ i | i | i f ƒ q?nBˆ o¤ | i ˆ j o@ | i | i j p | i ˆ j o ˆ i | i | i f ƒ q?| i ˆ j o@ | i | i j p | i ˆ j o ˆ i | i | i f ƒ q?n— t | i t i
ƒ o€ t | i t i
ƒ oj | i i | i ƒ o ˆ i | i | i f ƒ q?| i i | i ƒ o ˆ i | i | i f ƒ q?n d S( N( R R R‚ RW Ry R t
ColumnElementRz R
R t Columnt
references( R… ( t pairst any_operatort consider_as_foreign_keyst consider_as_referenced_keys( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyR‰ S s& .3 3!3 3!, R… ( R RA R R ( R R” R• R“ R‰ ( ( R’ R“ R” R• s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt criterion_as_pairsM s c s9 ˆ d j o
t ƒ ‰ n ‡ f d † } t i | i h h | d 6ƒ g } t | i t i ƒ o t | i ˆ ƒ } n t
| i i ƒ } t | i t i ƒ o t | i ˆ ƒ } n t
| i i ƒ } t ƒ } xa | | D]U } | ˆ j o5 | i
| j o! | i | ƒ | i | i
ƒ q1qÜ | i | ƒ qÜ W| S( sk Return a list of uniquely named columns.
The column list of the given Join will be narrowed
down to a list of all equivalently-named,
equated columns folded into one column, where 'equated' means they are
equated to each other in the ON clause of this join.
This function is used by Join.select(fold_equivalents=True).
Deprecated. This function is used for a certain kind of
"polymorphic_union" which is designed to achieve joined
table inheritance where the base table has no "discriminator"
column; [ticket:1131] will provide a better way to
achieve this.
c sT | i t i j o= | i i | i i j o$ ˆ i | i ƒ ˆ i | i ƒ n d S( N( R R R‚ Ry t nameRz R6 ( R… ( t equivs( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyR‰ € s ,R… N( R R; R R Rx RW Ry R Rv t folded_equivalentsR Rˆ Rz R— R
R6 ( R* R˜ R‰ t collistRy Rz t usedRY ( ( R˜ s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyR™ m s(
t
AliasedRowc B s; e Z d Z d „ Z d „ Z d „ Z d „ Z d „ Z RS( s Wrap a RowProxy with a translation map.
This object allows a set of keys to be translated
to those present in a RowProxy.
c C s6 t | t ƒ o | i | _ n
| | _ | | _ d S( N( RW Rœ t rowt map( R^ R Rž ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyR_ Ÿ s c C s | i | | i j S( N( Rž R ( R^ t key( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt __contains__¨ s c C s
| | j S( N( ( R^ RŸ ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt has_key« s c C s | i | i | S( N( R Rž ( R^ RŸ ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt __getitem__® s c C s
| i i ƒ S( N( R t keys( R^ ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyR£ ± s ( RR Rk Rl R_ R R¡ R¢ R£ ( ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyRœ ˜ s Rt c B s8 e Z d Z d d d d „ Z e i d „ Z d „ Z RS( s9 Clones and modifies clauses based on column correspondence.
E.g.::
table1 = Table('sometable', metadata,
Column('col1', Integer),
Column('col2', Integer)
)
table2 = Table('someothertable', metadata,
Column('col1', Integer),
Column('col2', Integer)
)
condition = table1.c.col1 == table2.c.col1
make an alias of table1::
s = table1.alias('foo')
calling ``ClauseAdapter(s).traverse(condition)`` converts
condition to read::
s.c.col1 == table2.c.col1
c C sR h t d 6| g d 6| _ | | _ | | _ | | _ t i | p h ƒ | _ d S( NR- R{ ( R. t __traverse_options__t
selectablet includeRp R t column_dictt equivalents( R^ R¥ R¨ R¦ Rp ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyR_ Ï s
c C s | i i | d | ƒ} | ol | | i j o\ | | j oO xL | i | D]9 } | i | d | d | i | g ƒ ƒ} | o | SqK Wn | S( Nt require_embeddedt _seen( R¥ t corresponding_columnR¨ t _corresponding_columnt union( R^ R7 R© Rª t newcolt equiv( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyR¬ Ö s % '
c C s˜ t | t i ƒ o | i i | ƒ o | i Sn t | t i ƒ p d S| i o | | i j o d S| i o | | i j o d S| i | t
ƒ S( N( RW R RX R¥ R R R R¦ Rp R¬ R ( R^ R7 ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt replaceà s N( RR Rk Rl R R_ R t EMPTY_SETR¬ R° ( ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyRt µ s
t
ColumnAdapterc B sk e Z d Z d d d d d „ Z d „ Z e i Z e i Z
d „ Z d „ Z d „ Z
d „ Z d „ Z RS( s Extends ClauseAdapter with extra utility functions.
Provides the ability to "wrap" this ClauseAdapter
around another, a columns dictionary which returns
cached, adapted elements given an original, and an
adapted_row() factory.
c C sJ t i | | | | | ƒ | o | i | ƒ n t i | i ƒ | _ d S( N( Rt R_ R R t populate_column_dictt _locate_colRˆ ( R^ R¥ R¨ t chain_toR¦ Rp ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyR_ ø s c C s‘ | i i | i ƒ } | i i ƒ | _ | i | i | i ƒ | _ | i | i | i ƒ | _ | i | i | i ƒ | _ t i | i ƒ | _
| S( N( RO RM RZ R[ t _wrapR´ t adapt_clauset
adapt_listR R³ Rˆ ( R^ R} t ac( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt wrapþ s c s ‡ ‡ f d † } | S( Nc s ˆ | ƒ } ˆ | ƒ S( N( ( R7 ( t wrappedt local( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt locate s ( ( R^ R¼ R» R½ ( ( R» R¼ s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyR¶
s c C sV | i | t ƒ } | p9 | i | ƒ } t | t i ƒ o | i d ƒ } qR n | S( N( R¬ R. R· RW R t _Labelt labelR ( R^ R7 RY ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyR´ s c C s t | | i ƒ S( N( Rœ Rˆ ( R^ R ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt adapted_row s c C s | i i ƒ } | d =| S( NRˆ ( RZ R[ ( R^ t d( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt __getstate__ s c C s) | i i | ƒ t i | i ƒ | _ d S( N( RZ R` R t PopulateDictR´ Rˆ ( R^ t state( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt __setstate__" s N( RR Rk Rl R R_ Rº Rt R R· t copy_and_processR¸ R¶ R´ RÀ R RÅ ( ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyR² ï s
(+ t
sqlalchemyR R R R R t sqlalchemy.sqlR R R t itertoolsR R R% R. R5 R: RJ RL RK RN RZ RV R t TableRS RW RQ t
issubclasst
ClauseElementRR t localsR Rr Rs R€ RŽ R– R™ Rœ t ReplacingCloningVisitorRt R² ( ( ( s7 /usr/lib/python2.6/site-packages/sqlalchemy/sql/util.pyt s2 ( 8F #
5 + :