Ñò
Š„[Jc @ sš d Z d d k Z d d k Z d d k l Z l Z l Z l Z d d k l Z l
Z
e a d d d d d d
d d d
d d d d d d d d d d d g Z
e
i ƒ d e
i f d „ ƒ YZ d „ Z d e
i f d „ ƒ YZ d e e i f d „ ƒ YZ d e e i f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d! „ ƒ YZ d e f d" „ ƒ YZ d e f d# „ ƒ YZ d e f d$ „ ƒ YZ e Z d e f d% „ ƒ YZ d
e f d& „ ƒ YZ! d e f d' „ ƒ YZ" d e f d( „ ƒ YZ# d e f d) „ ƒ YZ$ d
e f d* „ ƒ YZ% d e f d+ „ ƒ YZ& d e& f d, „ ƒ YZ' d e
i( f d- „ ƒ YZ) d e f d. „ ƒ YZ* d/ „ Z+ d0 „ Z, d S(1 s1 The schema module provides the building blocks for database metadata.
Each element within this module describes a database entity which can be
created and dropped, or is otherwise part of such an entity. Examples include
tables, columns, sequences, and indexes.
All entities are subclasses of :class:`~sqlalchemy.schema.SchemaItem`, and as defined
in this module they are intended to be agnostic of any vendor-specific
constructs.
A collection of entities are grouped into a unit called
:class:`~sqlalchemy.schema.MetaData`. MetaData serves as a logical grouping of schema
elements, and can also be associated with an actual database connection such
that operations involving the contained elements can contact the database as
needed.
Two of the elements here also build upon their "syntactic" counterparts, which
are defined in :class:`~sqlalchemy.sql.expression.`, specifically
:class:`~sqlalchemy.schema.Table` and :class:`~sqlalchemy.schema.Column`. Since these objects
are part of the SQL expression language, they are usable as components in SQL
expressions.
iÿÿÿÿN( t typest exct utilt databases( t
expressiont visitorst
SchemaItemt Tablet Columnt
ForeignKeyt Sequencet Indext ForeignKeyConstraintt PrimaryKeyConstraintt CheckConstraintt UniqueConstraintt DefaultGeneratort
Constraintt MetaDatat ThreadLocalMetaDatat
SchemaVisitort PassiveDefaultt
DefaultClauset FetchedValuet
ColumnDefaultt DDLc B s\ e Z d Z d Z d Z d „ Z d „ Z d „ Z d „ Z e
d „ ƒ Z e
d „ ƒ Z RS( s3 Base class for items that define a database schema.t schema_itemc G s3 x, | D]$ } | d j o | i | ƒ q q Wd S( s7 Initialize the list of child items for this SchemaItem.N( t Nonet _set_parent( t selft argst item( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt _init_items1 s
c C s
t ƒ ‚ d S( s/ Associate with this SchemaItem's parent object.N( t NotImplementedError( R t parent( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR 8 s c K s g S( s" used to allow SchemaVisitor access( ( R t kwargs( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt get_children= s c C s d | i i S( Ns %s()( t __class__t __name__( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt __repr__A s c C s | i } | o
| i p d S( s7 Return the connectable associated with this SchemaItem.N( t metadatat bindR ( R t m( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR) D s c C s2 y | i SWn t j
o h | _ | i SXd S( N( t _infot AttributeError( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt infoK s
N(
R& t
__module__t __doc__t __visit_name__R t quoteR R R$ R' t propertyR) R- ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR + s c C s" | d j o | S| d | Sd S( Nt .( R ( t namet schema( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt _get_table_keyT s
t _TableSingletonc B s e Z d Z d „ Z RS( sG A metaclass used by the ``Table`` object to provide singleton behavior.c
O s( | i d | i d d ƒ ƒ } | i d t ƒ } | i d t ƒ } t | | ƒ } yW | i | } | o* | i | | Ž o t i d | ƒ ‚ n | i | | Ž | SWny t
j
om | o t i d | ƒ ‚ n y t i | | | | | Ž SWq$| | i j o | i | =n ‚ q$Xn Xd S( NR5 t ownert useexistingt mustexists’ Table '%s' is already defined for this MetaData instance. Specify 'useexisting=True' to redefine options and columns on an existing Table object.s Table '%s' not defined(
t getR t popt FalseR6 t tablest _cant_overrideR t InvalidRequestErrort _init_existingt KeyErrort typet __call__(
R R4 R( R R# R5 R9 R: t keyt table( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRD ] s,
( R& R. R/ RD ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR7 Z s c B sø e Z d Z e Z d Z d Z d „ Z d „ Z d „ Z d „ Z
d
„ Z e d „ ƒ Z
d „ Z d
„ Z e e e ƒ Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z e e d „ Z d d „ Z d e d „ Z d e d „ Z d d „ Z RS( s Represent a table in a database.RF s
before-creates after-creates before-drops
after-dropc O sá t t | ƒ i | ƒ | | _ | i d | i d d ƒ ƒ | _ t ƒ | _ t ƒ | _ t
i ƒ | _ t
ƒ | _ t i ƒ | _ t i t ƒ | _ h | _ | i d j o d | i | i f | _ n
| i | _ | i d t ƒ } | i d d ƒ } | i d d ƒ } | i | ƒ | i d d ƒ | _ | i d d ƒ | _ | i d ƒ o | i d ƒ | _ n | i d
g ƒ | _ | i | | o; | o | i | d | ƒqÍt! | ƒ i | d | ƒn | i" | | Ž d S( sÛ
Construct a Table.
:param name: The name of this table as represented in the database.
This property, along with the *schema*, indicates the *singleton
identity* of this table in relation to its parent :class:`MetaData`.
Additional calls to :class:`Table` with the same name, metadata,
and schema name will return the same :class:`Table` object.
Names which contain no upper case characters
will be treated as case insensitive names, and will not be quoted
unless they are a reserved word. Names with any number of upper
case characters will be quoted and sent exactly. Note that this
behavior applies even for databases which standardize upper
case names as case insensitive such as Oracle.
:param metadata: a :class:`MetaData` object which will contain this
table. The metadata is used as a point of association of this table
with other tables which are referenced via foreign key. It also
may be used to associate this table with a particular
:class:`~sqlalchemy.engine.base.Connectable`.
:param \*args: Additional positional arguments are used primarily
to add the list of :class:`Column` objects contained within this table.
Similar to the style of a CREATE TABLE statement, other :class:`SchemaItem`
constructs may be added here, including :class:`PrimaryKeyConstraint`,
and :class:`ForeignKeyConstraint`.
:param autoload: Defaults to False: the Columns for this table should be reflected
from the database. Usually there will be no Column objects in the
constructor if this property is set.
:param autoload_with: If autoload==True, this is an optional Engine or Connection
instance to be used for the table reflection. If ``None``, the
underlying MetaData's bound connectable will be used.
:param include_columns: A list of strings indicating a subset of columns to be loaded via
the ``autoload`` operation; table columns who aren't present in
this list will not be represented on the resulting ``Table``
object. Defaults to ``None`` which indicates all columns should
be reflected.
:param info: A dictionary which defaults to ``{}``. A space to store application
specific data. This must be a dictionary.
:param mustexist: When ``True``, indicates that this Table must already
be present in the given :class:`MetaData`` collection.
:param prefixes:
A list of strings to insert after CREATE in the CREATE TABLE
statement. They will be separated by spaces.
:param quote: Force quoting of this table's name on or off, corresponding
to ``True`` or ``False``. When left at its default of ``None``,
the column identifier will be quoted according to whether the name is
case sensitive (identifiers with at least one upper case character are
treated as case sensitive), or if it's a reserved word. This flag
is only needed to force quoting of a reserved word which is not known
by the SQLAlchemy dialect.
:param quote_schema: same as 'quote' but applies to the schema identifier.
:param schema: The *schema name* for this table, which is required if the table
resides in a schema other than the default selected schema for the
engine's database connection. Defaults to ``None``.
:param useexisting: When ``True``, indicates that if this Table is already
present in the given :class:`MetaData`, apply further arguments within
the constructor to the existing :class:`Table`. If this flag is not
set, an error is raised when the parameters of an existing :class:`Table`
are overwritten.
R5 R8 s %s.%st autoloadt
autoload_witht include_columnsR1 t quote_schemaR- t prefixesN(# t superR t __init__R( R< R R5 t sett indexest constraintsR t ColumnCollectiont _columnsR
t primary_keyR t
OrderedSett
_foreign_keyst defaultdictt listt
ddl_listenersR# R4 t fullnameR= R R1 RJ R; R+ t _prefixest _Table__extra_kwargst reflecttablet _bind_or_errort _Table__post_init( R R4 R( R R# RG RH RI ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM s8 K !
c O s@ | i d t ƒ } | i d d ƒ } | i d d ƒ } | o/ | | i j o t i d | i | f ƒ ‚ n | i d d ƒ } | o< x9 | i D]* } | i | j o | i i | ƒ q q Wn x8 d D]0 } | | j o t | | | i | ƒ ƒ qÈ qÈ Wd | j o | i d ƒ | _
n | i | | i | | Ž d S(
NRG RH R5 s7 Can't change schema of existing table from '%s' to '%s'RI R1 RJ R- ( s quotes quote_schema(
R< R= R R5 R t
ArgumentErrort cR4 t removet setattrR+ R[ R^ ( R R R# RG RH R5 RI R` RE ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRA ÷ s*
!
c O s2 t | ƒ p% t t | ƒ i d d d d g ƒ ƒ S( sð Return True if any argument is not supported as an override.
Takes arguments that would be sent to Table.__init__, and returns
True if any of them would be disallowed if sent to an existing
Table singleton.
RG RH R5 R8 ( t boolRN t
difference( R R R# ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR? s c K sƒ t g } | D]4 } t i d d i t i ƒ | ƒ p | | q q ~ ƒ o t d t | i ƒ ƒ ƒ ‚ n | i i
| ƒ d S( Ns ^(?:%s)_t |s! Invalid argument(s) for Table: %s( t lent ret matcht joinR t __all__t TypeErrort reprt keysR# t update( R R# t _[1]t k( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt __extra_kwargs s
; c O s | i | Œ d S( N( R ( R R R# ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt __post_init" s c C s t | i | i ƒ S( N( R6 R4 R5 ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRE % s c C sP t | d d ƒ | i j o | i i | i ƒ n | | _ | i i | ƒ d S( Nt _primary_key( t getattrR RP Ra Rs t add( R t pk( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt _set_primary_key) s c C s | i S( N( Rs ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRS / s c C s d d i t | i ƒ g t | i ƒ g g } | i D] } | t | ƒ q6 ~ g } d g D]& } | d | t t | | ƒ ƒ f q^ ~ ƒ S( Ns Table(%s)s , R5 s %s=%s( Ri Rl R4 R( t columnsRt ( R Ro t xt _[2]Rp ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR' 3 s Gc C s t | i | i ƒ S( N( R6 t descriptionR5 ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt __str__9 s c C s | i | ƒ d S( s& Append a ``Column`` to this ``Table``.N( R ( R t column( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt
append_column< s c C s | i | ƒ d S( s* Append a ``Constraint`` to this ``Table``.N( R ( R t
constraint( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt append_constraintA s c C s8 | | i j o t | ƒ ‚ n | i | i | ƒ d S( sM Append a DDL event listener to this ``Table``.
The ``listener`` callable will be triggered when this ``Table`` is
created or dropped, either directly before or after the DDL is issued
to the database. The listener may modify the Table, but may not abort
the event itself.
Arguments are:
event
One of ``Table.ddl_events``; e.g. 'before-create', 'after-create',
'before-drop' or 'after-drop'.
listener
A callable, invoked with three positional arguments:
event
The event currently being handled
schema_item
The ``Table`` object being created or dropped
bind
The ``Connection`` bueing used for DDL execution.
Listeners are added to the Table's ``ddl_listeners`` attribute.
N( t
ddl_eventst LookupErrorRX t append( R t eventt listener( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt append_ddl_listenerF s c C s) | | i t | i | i ƒ <| | _ d S( N( R> R6 R4 R5 R( ( R R( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR e s c K sS | p t i i | d | | S| o# g } | i D]
} | | q6 ~ Sg Sd S( Nt column_collections( R t TableClauseR$ Rx ( R R‡ t schema_visitorR# Ro R` ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR$ i s #c s9 | d j o t ˆ ƒ } n ‡ f d † } | i | ƒ S( s! Return True if this table exists.c s | i i | ˆ i d ˆ i ƒS( NR5 ( t dialectt has_tableR4 R5 ( t conn( R ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt doy s N( R R] t run_callable( R R) R ( ( R s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt existss s
c C s& | i i d | d | d | g ƒ d S( sb Issue a ``CREATE`` statement for this table.
See also ``metadata.create_all()``.
R) t
checkfirstR> N( R( t
create_all( R R) R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt create} s c C s& | i i d | d | d | g ƒ d S( s^ Issue a ``DROP`` statement for this table.
See also ``metadata.drop_all()``.
R) R R> N( R( t drop_all( R R) R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt drop„ s c
C sÅ y5 | p
| i } n t | i | ƒ } | i | SWn‰ t j
o} g } x* | i D] } | i | i d | ƒ ƒ qV Wx* | i D] } | i | i d | ƒ ƒ qƒ Wt | i | d | | ŒSXd S( sI Return a copy of this ``Table`` associated with a different ``MetaData``.R5 N(
R5 R6 R4 R> RB Rx Rƒ t copyRP R ( R R( R5 RE R R` ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt
tometadata‹ s
( s
before-creates after-creates before-drops
after-dropN( R& R. R/ R7 t
__metaclass__R0 R RM RA R? R[ R^ R2 RE Rw RS R' R| R~ R€ R† R t TrueR= R$ R R R’ R” R– ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR x s0 v
c B sz e Z d Z d Z d „ Z d „ Z e d „ ƒ Z d „ Z d „ Z d „ Z
d „ Z d „ Z d d
„ Z e d „ Z RS(
s( Represents a column in a database table.R} c O s | i d d ƒ } | i d d ƒ } | oW t | ƒ } t | d t ƒ o3 | d j o t i d ƒ ‚ n | i d ƒ } q‚ n | o˜ | d } t i | ƒ o | d ƒ } n t | t i
ƒ p# t | t ƒ oF t | t i
ƒ o3 | d j o t i d ƒ ‚ n | i d ƒ } q!n t
t | ƒ i | d | ƒ | | _ | i d | ƒ | _ | i d t ƒ | _ | i d | i ƒ | _ | i d d ƒ | _ | i d
d ƒ | _ | i d d ƒ | _ | i d d ƒ | _ | i d
d ƒ | _ | i d d ƒ | _ | i d d ƒ | _ | i d t ƒ | _ t ƒ | _ t i ƒ | _! t i" | ƒ | i# d ƒ o | i d ƒ | _$ n | o# t i d t% | i& ƒ ƒ ƒ ‚ n d S( sv
Construct a new ``Column`` object.
:param name: The name of this column as represented in the database.
This argument may be the first positional argument, or specified
via keyword.
Names which contain no upper case characters
will be treated as case insensitive names, and will not be quoted
unless they are a reserved word. Names with any number of upper
case characters will be quoted and sent exactly. Note that this
behavior applies even for databases which standardize upper
case names as case insensitive such as Oracle.
The name field may be omitted at construction time and applied
later, at any time before the Column is associated with a
:class:`Table`. This is to support convenient
usage within the :mod:`~sqlalchemy.ext.declarative` extension.
:param type\_: The column's type, indicated using an instance which
subclasses :class:`~sqlalchemy.types.AbstractType`. If no arguments
are required for the type, the class of the type can be sent
as well, e.g.::
# use a type with arguments
Column('data', String(50))
# use no arguments
Column('level', Integer)
The ``type`` argument may be the second positional argument
or specified by keyword.
If this column also contains a :class:`ForeignKey`,
the type argument may be left as ``None`` in which case the
type assigned will be that of the referenced column.
:param \*args: Additional positional arguments include various
:class:`SchemaItem` derived constructs which will be applied
as options to the column. These include instances of
:class:`Constraint`, :class:`ForeignKey`, :class:`ColumnDefault`,
and :class:`Sequence`. In some cases an equivalent keyword
argument is available such as ``server_default``, ``default``
and ``unique``.
:param autoincrement: This flag may be set to ``False`` to disable
SQLAlchemy indicating at the DDL level that an integer primary
key column should have autoincrementing behavior. This
is an oft misunderstood flag and has no effect whatsoever unless
all of the following conditions are met:
* The column is of the :class:`~sqlalchemy.types.Integer` datatype.
* The column has the ``primary_key`` flag set, or is otherwise
a member of a :class:`PrimaryKeyConstraint` on this table.
* a CREATE TABLE statement is being issued via :meth:`create()`
or :meth:`create_all()`. The flag has no relevance at any
other time.
* The database supports autoincrementing behavior, such as
PostgreSQL or MySQL, and this behavior can be disabled (which does
not include SQLite).
:param default: A scalar, Python callable, or :class:`~sqlalchemy.sql.expression.ClauseElement`
representing the *default value* for this column, which will be
invoked upon insert if this column is otherwise not specified
in the VALUES clause of the insert. This is a shortcut
to using :class:`ColumnDefault` as a positional argument.
Contrast this argument to ``server_default`` which creates a
default generator on the database side.
:param key: An optional string identifier which will identify this ``Column``
object on the :class:`Table`. When a key is provided, this is the
only identifier referencing the ``Column`` within the application,
including ORM attribute mapping; the ``name`` field is used only
when rendering SQL.
:param index: When ``True``, indicates that the column is indexed.
This is a shortcut for using a :class:`Index` construct on the table.
To specify indexes with explicit names or indexes that contain multiple
columns, use the :class:`Index` construct instead.
:param info: A dictionary which defaults to ``{}``. A space to store application
specific data. This must be a dictionary.
:param nullable: If set to the default of ``True``, indicates the column
will be rendered as allowing NULL, else it's rendered as NOT NULL.
This parameter is only used when issuing CREATE TABLE statements.
:param onupdate: A scalar, Python callable, or :class:`~sqlalchemy.sql.expression.ClauseElement`
representing a default value to be applied to the column within UPDATE
statements, which wil be invoked upon update if this column is not present
in the SET clause of the update. This is a shortcut to using
:class:`ColumnDefault` as a positional argument with ``for_update=True``.
:param primary_key: If ``True``, marks this column as a primary key
column. Multiple columns can have this flag set to specify composite
primary keys. As an alternative, the primary key of a :class:`Table` can
be specified via an explicit :class:`PrimaryKeyConstraint` object.
:param server_default: A :class:`FetchedValue` instance, str, Unicode or
:func:`~sqlalchemy.sql.expression.text` construct representing
the DDL DEFAULT value for the column.
String types will be emitted as-is, surrounded by single quotes::
Column('x', Text, server_default="val")
x TEXT DEFAULT 'val'
A :func:`~sqlalchemy.sql.expression.text` expression will be
rendered as-is, without quotes::
Column('y', DateTime, server_default=text('NOW()'))0
y DATETIME DEFAULT NOW()
Strings and text() will be converted into a :class:`DefaultClause`
object upon initialization.
Use :class:`FetchedValue` to indicate that an already-existing column will generate
a default value on the database side which will be available to SQLAlchemy
for post-fetch after inserts.
This construct does not specify any DDL and the implementation is
left to the database, such as via a trigger.
:param server_onupdate: A :class:`FetchedValue` instance representing
a database-side default generation function. This indicates to
SQLAlchemy that a newly generated value will be available after updates.
This construct does not specify any DDL and the implementation is
left to the database, such as via a trigger.
:param quote: Force quoting of this column's name on or off, corresponding
to ``True`` or ``False``. When left at its default of ``None``,
the column identifier will be quoted according to whether the name is
case sensitive (identifiers with at least one upper case character are
treated as case sensitive), or if it's a reserved word. This flag
is only needed to force quoting of a reserved word which is not known
by the SQLAlchemy dialect.
:param unique: When ``True``, indicates that this column contains a unique
constraint, or if ``index`` is ``True`` as well, indicates that the
:class:`Index` should be created with the unique flag. To specify multiple
columns in the constraint/index or to specify an explicit name,
use the :class:`UniqueConstraint` or :class:`Index` constructs explicitly.
R4 t type_i s0 May not pass name positionally and as a keyword.s1 May not pass type_ positionally and as a keyword.RE RS t nullablet defaultt server_defaultt server_onupdatet indext uniqueR1 t onupdatet
autoincrementR- s$ Unknown arguments passed to Column: N(' R< R RW t
isinstancet
basestringR R_ R t callableR t AbstractTypeRC t
issubclassRL R RM R RE R= RS Rš R› Rœ R Rž RŸ R1 R R˜ R¡ RN RP RT t foreign_keyst set_creation_orderR; R+ Rl Rm ( R R R# R4 R™ t coltype( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM sR ”
c C s^ | i d j o d S| i d j o. | i i o | i i d | i S| i Sn | i Sd S( Ns (no name)R3 ( R4 R RF t named_with_columnR{ ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR| c s
c C s
| i i S( N( RF R) ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR) n s c C s4 x- | i D] } | i | i ƒ o t Sq
Wt Sd S( sG Return True if this Column references the given column via foreign key.N( R§ t
referencesRF R˜ R= ( R R} t fk( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR« r s
c C s | i | ƒ d S( N( R ( R R¬ ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt append_foreign_keyz s c C s™ g } | i | i j o | i d ƒ n | i o | i d ƒ n | i p | i d ƒ n | i o | i d ƒ n | i o | i d ƒ n | i o | i d ƒ n d d i t | i ƒ g t | i
ƒ g g } | i D]$ } | d j o | t | ƒ qç qç ~ g } | i
D] } | t | ƒ q ~ | i o d | i i p d
g g } | D]& } | d | t t | | ƒ ƒ f qg~ ƒ S( NRE RS Rš R R› Rœ s
Column(%s)s , s
table=<%s>t s %s=%s( RE R4 Rƒ RS Rš R R› Rœ Ri Rl RC R§ R RP RF R{ Rt ( R t kwargRo Ry Rz t _[3]Rp ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR' } s
¢c C s | i d j o t i d ƒ ‚ n | i d j o | i | _ n | i | _ t | d d ƒ d j o t i d ƒ ‚ n | i | i j o | i i | i ƒ | _ n | i i
| ƒ | i o | i i
| ƒ n7 | i | i j o# t i d | i | i f ƒ ‚ n | | _
| i oG t | i t ƒ o t i d ƒ ‚ n t d | i | d | i ƒnK | i o@ t | i t ƒ o t i d ƒ ‚ n | i t | i ƒ ƒ n t | i ƒ } | i d j oA t | i t ƒ o | i | i ƒ q| i t | i ƒ ƒ n | i d j oA t | i t ƒ o | i | i ƒ qc| i t | i ƒ ƒ n | i d j o | i t | i d t ƒƒ n | i d j oG t | i t ƒ o | i | i ƒ qê| i t | i d t ƒƒ n | i! | Œ d | _ d S(
NsP Column must be constructed with a name or assign .name before adding to a Table.RF s this Column already has a table!sT Trying to redefine primary-key column '%s' as a non-primary-key column on table '%s's– The 'index' keyword argument on Column is boolean only. To create indexes with a specific name, create an explicit Index object external to the Table.s ix_%sRŸ sõ The 'unique' keyword argument on Column is boolean only. To create unique constraints or indexes with a specific name, append an explicit UniqueConstraint to the Table's list of elements, or create an explicit Index object external to the Table.t
for_update(" R4 R R R_ RE R( Rt RR R; t _pre_existing_columnt replaceRS RY RF Rž R¢ R£ R t _labelRŸ R€ R RW R R› R Rƒ Rœ R R R R˜ R R ( R RF t toinit( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR ’ s\
!
c K sy t | i | i | i d | i d | i d | i d | i d | i d | i g } | i
D] } | | i | qY ~ ŒS( sg Create a copy of this ``Column``, unitialized.
This is used in ``Table.tometadata``.
RE RS Rš R1 Rž R¡ ( R R4 RC R› RE RS Rš R1 Rž R¡ RP R• ( R t kwRo R` ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR• Ô s c C sì g } | i D] } | t | i ƒ q ~ } t | p | i | i | i d | p | i d | i d | i d | i
| Œ} | | _ | g | _ | i
i | ƒ | i o | i i | ƒ n g } | D] } | | i | ƒ qË ~ | S( s§ Create a *proxy* for this column.
This is a copy of this ``Column`` referenced by a different parent
(such as an alias or select statement).
RE RS Rš R1 ( R§ R R} R R4 RC R› RE RS Rš R1 RF t proxiesRx Ru R ( R t
selectableR4 Ro t fR¬ R` Rz ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt _make_proxyÜ s -
(c K su | oW g } | i | i f D] } | d j o | | q q ~ t | i ƒ t | i ƒ St i i | | Sd S( N( R› R R RW R§ RP R t ColumnClauseR$ ( R R‰ R# Ro Ry ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR$ ô s WN( R& R. R/ R0 RM R| R2 R) R« R R' R R• R Rº R= R$ ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR › s à B c B s e Z d Z d Z d
e d
d
d
d
d
e d „ Z d „ Z d
d „ Z d
d „ Z e
e ƒ Z d „ Z d „ Z
e i d „ ƒ Z d „ Z RS( s Defines a column-level FOREIGN KEY constraint between two columns.
``ForeignKey`` is specified as an argument to a :class:`Column` object, e.g.::
t = Table("remote_table", metadata,
Column("remote_id", ForeignKey("main_table.id"))
)
For a composite (multiple column) FOREIGN KEY, use a :class:`ForeignKeyConstraint`
object specified at the level of the :class:`Table`.
Further examples of foreign key configuration are in :ref:`metadata_foreignkeys`.
t foreign_keyc
C sU | | _ | | _ | | _ | | _ | | _ | | _ | | _ | | _ | | _ d S( s>
Construct a column-level FOREIGN KEY.
:param column: A single target column for the key relationship. A :class:`Column`
object or a column name as a string: ``tablename.columnkey`` or
``schema.tablename.columnkey``. ``columnkey`` is the ``key`` which has been assigned
to the column (defaults to the column name itself), unless ``link_to_name`` is ``True``
in which case the rendered name of the column is used.
:param constraint: Optional. A parent :class:`ForeignKeyConstraint` object. If not
supplied, a :class:`ForeignKeyConstraint` will be automatically created
and added to the parent table.
:param name: Optional string. An in-database name for the key if `constraint` is
not provided.
:param onupdate: Optional string. If set, emit ON UPDATE when issuing DDL
for this constraint. Typical values include CASCADE, DELETE and
RESTRICT.
:param ondelete: Optional string. If set, emit ON DELETE when issuing DDL
for this constraint. Typical values include CASCADE, DELETE and
RESTRICT.
:param deferrable: Optional bool. If set, emit DEFERRABLE or NOT DEFERRABLE when
issuing DDL for this constraint.
:param initially: Optional string. If set, emit INITIALLY when issuing DDL
for this constraint.
:param link_to_name: if True, the string name given in ``column`` is the rendered
name of the referenced column, not its locally assigned ``key``.
:param use_alter: If True, do not emit this key as part of the CREATE TABLE
definition. Instead, use ALTER TABLE after table creation to add
the key. Useful for circular dependencies.
N( t _colspecR t use_alterR4 R t ondeletet
deferrablet initiallyt link_to_name(
R R} R R¾ R4 R R¿ RÀ RÁ R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM s ( c C s d | i ƒ S( Ns ForeignKey(%r)( t _get_colspec( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR' @ s c C s t | i d | ƒ ƒ S( s) Produce a copy of this ForeignKey object.R5 ( R Rà ( R R5 ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR• C s c C sŒ | o$ | d | i i i d | i i St | i t ƒ o | i St | i d ƒ o | i i ƒ } n
| i } d | i i | i f S( NR3 t __clause_element__s %s.%s(
R} RF R4 RE R¢ R½ R£ t hasattrRÄ RY ( R R5 t _column( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRÃ H s $ c C s | i | i ƒ d j S( s@ Return True if the given table is referenced by this ForeignKey.N( t corresponding_columnR} R ( R RF ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR« V s c C s | i | i ƒ S( sž Return the column in the given table referenced by this ForeignKey.
Returns None if this ``ForeignKey`` does not reference the given table.
( RÇ R} ( R RF ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt get_referentZ s c
C s‰ t | i t ƒ oxN | i i D]$ } t | t ƒ o | i } Pq q Wt i d t | i ƒ ƒ ‚ | i i
d ƒ } | d j o t i d | i ƒ ‚ n d \ } } } t | ƒ d j o | i
ƒ } n | i
ƒ } | i
ƒ } t | ƒ d j o d i | ƒ } n t | | ƒ | i j o t i d | ƒ ‚ n t | | i d t d | ƒ} d } | d j o( | i } | i i | i i d ƒ } n^ | i o8 | } xJ | i D] } | i | j o
| } q°q°Wn | } | i i | d ƒ } | p, t i d | i | i | i | f ƒ ‚ qYn0 t | i d
ƒ o | i i ƒ } n
| i } t | i i t i ƒ o | i | i _ n | S( Ns@ Parent column '%s' does not descend from a table-attached ColumnR3 s, Invalid foreign key column specification: %si i s> Could not find table '%s' with which to generate a foreign keyR: R5 sS Could not create ForeignKey '%s' on table '%s': table '%s' has no column named '%s'RÄ ( NNN( R¢ R½ R£ R" t base_columnsR RF R R_ t strt splitR Rf R< Ri R6 R( t NoReferencedTableErrorR R˜ R` R; RE RÂ R4 t NoReferencedColumnErrorRÅ RÄ RC R t NullType(
R R` t parenttableR* R5 t tnamet colnameRF RÆ RE ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR} c sb
' c C sh t | d ƒ o t i d ƒ ‚ n | | _ t | i d ƒ od xa | i i i D]L } | i | i j o3 | i i i i | ƒ | i i i i | i
ƒ qO qO Wn | i
d j oˆ t | i i t
ƒ or t g g d | i d | i d | i d | i d | i d | i ƒ| _
| i i i | i
ƒ | i
i | ƒ n | i i i | ƒ | i i i i | ƒ d S(
NR" s& This ForeignKey already has a parent !R² R¾ R4 R R¿ RÀ RÁ ( RÅ R R@ R" R² R§ t target_fullnameRF Ra RP R R R¢ R R R¾ R4 R R¿ RÀ RÁ R€ t
_append_fkRu ( R R} R¬ ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR · s$ %&N( R& R. R/ R0 R R= RM R' R• RÃ R2 RÒ R« RÈ R t memoized_propertyR} R ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR ü s !2 Tc B sA e Z d Z d Z e d d „ Z d „ Z d d „ Z d „ Z RS( s' Base class for column *default* values.t default_generatorc C s1 | | _ t i | t t d ƒ f d ƒ | _ d S( NR( ( R± R t assert_arg_typeR RC R R( ( R R± R( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM Ó s c C sE | | _ | i i i | _ | i o | | i _ n
| | i _ d S( N( R} RF R( R± R R› ( R R} ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR × s
c K s- | d j o t | ƒ } n | i | | S( N( R R] t _execute_default( R R) R# ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt executeß s
c C s d S( Ns DefaultGenerator()( ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR' ä s N(
R& R. R/ R0 R= R RM R RØ R' ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR Î s c B s> e Z d Z d „ Z d „ Z d „ Z e e ƒ Z d „ Z RS( sw A plain default value on a column.
This could correspond to a constant, a callable function, or a SQL clause.
c K si t t | ƒ i | t | t ƒ o t i d ƒ ‚ n t i | ƒ o | i | ƒ } n | | _
d S( Ns4 ColumnDefault may not be a server-side default type.( RL R RM R¢ R R R_ R R¤ t _maybe_wrap_callablet arg( R RÚ R# ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM î s
c s& t i ˆ ƒ o
ˆ } nA t i ˆ ƒ o
ˆ i } n$ t ˆ d ƒ o
ˆ i } n ˆ } y t i | ƒ } Wn t j
o ‡ f d † SXt | d ƒ } t i | ƒ o | d 8} n | d j o ‡ f d † S| d d j o t | d ƒ p d } | | d j o t i d ƒ ‚ n ˆ S( s< Backward compat: Wrap callables that don't accept a context.RD c s ˆ ƒ S( ( ( t ctx( t fn( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt s i i c s ˆ ƒ S( ( ( RÛ ( RÜ ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRÝ
s i sD ColumnDefault Python function takes zero or one positional argumentsN(
t inspectt
isfunctiont isclassRM RÅ RD t
getargspecRk Rf t ismethodR R R_ ( R RÜ t inspectablet argspect positionalst defaulted( ( RÜ s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRÙ ÷ s*
(
c C s | i o d Sd Sd S( Nt column_onupdatet column_default( R± ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt _visit_name s
c C s d t | i ƒ S( Ns ColumnDefault(%s)( Rl RÚ ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR' s ( R& R. R/ RM RÙ Ré R2 R0 R' ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR è s c B s\ e Z d Z d Z d d d e d d „ Z d „ Z d „ Z d e d „ Z
d e d „ Z RS( s% Represents a named database sequence.t sequencec K sY t t | ƒ i | | | _ | | _ | | _ | | _ | | _ | | _ | | _ d S( N(
RL R
RM R4 t startt incrementt optionalR1 R5 R# ( R R4 Rë Rì R5 Rí R1 R# ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM % s c C s^ d d i t | i ƒ g g } d d d g D]& } | d | t t | | ƒ ƒ f q, ~ ƒ S( Ns Sequence(%s)s , Rë Rì Rí s %s=%s( Ri Rl R4 Rt ( R Ro Rp ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR' 0 s c C s# t t | ƒ i | ƒ | | _ d S( N( RL R
R Rê ( R R} ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR 6 s c C s4 | d j o t | ƒ } n | i | d | ƒd S( s& Creates this sequence in the database.R N( R R] R’ ( R R) R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR’ : s
c C s4 | d j o t | ƒ } n | i | d | ƒd S( s& Drops this sequence from the database.R N( R R] R” ( R R) R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR” A s
N( R& R. R/ R0 R R= RM R' R R˜ R’ R” ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR
s
c B s, e Z d Z e d „ Z d „ Z d „ Z RS( s1 A default that takes effect on the database side.c C s
| | _ d S( N( R± ( R R± ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM L s c C s3 | | _ | i o | | i _ n
| | i _ d S( N( R} R± R Rœ ( R R} ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR O s
c C s d | i S( Ns FetchedValue(for_update=%r)( R± ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR' V s ( R& R. R/ R= RM R R' ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR I s c B s# e Z d Z e d „ Z d „ Z RS( s% A DDL-specified DEFAULT column value.c C sE t i | t t i t i f d ƒ t t | ƒ i | ƒ | | _ d S( NRÚ (
R RÖ R£ R t
ClauseElementt _TextClauseRL R RM RÚ ( R RÚ R± ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM ] s
c C s d | i | i f S( Ns DefaultClause(%r, for_update=%r)( RÚ R± ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR' d s ( R& R. R/ R= RM R' ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR Z s c B se e Z d Z d Z d
d
d
d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z
d „ Z d „ Z RS( s– A table-level SQL constraint, such as a KEY.
Implements a hybrid of dict/setlike behavior with regards to the list of
underying columns.
R c C s. | | _ t i ƒ | _ | | _ | | _ d S( sv Create a SQL constraint.
name
Optional, the in-database name of this ``Constraint``.
deferrable
Optional bool. If set, emit DEFERRABLE or NOT DEFERRABLE when
issuing DDL for this constraint.
initially
Optional string. If set, emit INITIALLY when issuing DDL
for this constraint.
N( R4 R RQ Rx RÀ RÁ ( R R4 RÀ RÁ ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM t s c C s
| | i j S( N( Rx ( R Ry ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt __contains__ˆ s c C s | i i | ƒ S( N( Rx t contains_column( R t col( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRñ ‹ s c C s
| i i ƒ S( N( Rx Rm ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRm Ž s c C s | i | S( N( Rx ( R t other( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt __add__‘ s c C s
t | i ƒ S( N( t iterRx ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt __iter__” s c C s
t | i ƒ S( N( Rf Rx ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt __len__— s c K s
t ƒ ‚ d S( N( R! ( R R¶ ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR• š s N(
R& R. R/ R0 R RM Rð Rñ Rm Rô Rö R÷ R• ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR k s c B sG e Z d Z d d d d „ Z d „ Z e e ƒ Z d „ Z d „ Z RS( sl A table- or column-level CHECK constraint.
Can be included in the definition of a Table or Column.
c C sL t t | ƒ i | | | ƒ t | t ƒ p t i d ƒ ‚ n | | _ d S( sâ Construct a CHECK constraint.
sqltext
A string containing the constraint definition. Will be used
verbatim.
name
Optional, the in-database name of the constraint.
deferrable
Optional bool. If set, emit DEFERRABLE or NOT DEFERRABLE when
issuing DDL for this constraint.
initially
Optional string. If set, emit INITIALLY when issuing DDL
for this constraint.
s3 sqltext must be a string and will be used verbatim.N( RL R RM R¢ R£ R R_ t sqltext( R Rø R4 RÀ RÁ ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM £ s
c C s t | i t ƒ o d Sd Sd S( Nt check_constraintt column_check_constraint( R¢ R" R ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR0 ¼ s c C s | | _ | i i | ƒ d S( N( R" RP Ru ( R R" ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR Ã s c K s t | i d | i ƒS( NR4 ( R Rø R4 ( R R¶ ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR• Ç s N( R& R. R/ R RM R0 R2 R R• ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR s c B sV e Z d Z d Z d d d e d d e d „ Z d „ Z d „ Z d „ Z d „ Z
RS( s¦ A table-level FOREIGN KEY constraint.
Defines a single column or composite FOREIGN KEY ... REFERENCES
constraint. For a no-frills, single column foreign key, adding a
:class:`ForeignKey` to the definition of a :class:`Column` is a shorthand equivalent
for an unnamed, single column :class:`ForeignKeyConstraint`.
Examples of foreign key configuration are in :ref:`metadata_foreignkeys`.
t foreign_key_constraintc
C s t t | ƒ i | | | ƒ | | _ | | _ t i ƒ | _ | | _ | | _ | | _
| i d j o | o t
i d ƒ ‚ n | | _ d S( s
Construct a composite-capable FOREIGN KEY.
:param columns: A sequence of local column names. The named columns must be defined
and present in the parent Table. The names should match the ``key`` given
to each column (defaults to the name) unless ``link_to_name`` is True.
:param refcolumns: A sequence of foreign column names or Column objects. The columns
must all be located within the same Table.
:param name: Optional, the in-database name of the key.
:param onupdate: Optional string. If set, emit ON UPDATE when issuing DDL
for this constraint. Typical values include CASCADE, DELETE and
RESTRICT.
:param ondelete: Optional string. If set, emit ON DELETE when issuing DDL
for this constraint. Typical values include CASCADE, DELETE and
RESTRICT.
:param deferrable: Optional bool. If set, emit DEFERRABLE or NOT DEFERRABLE when
issuing DDL for this constraint.
:param initially: Optional string. If set, emit INITIALLY when issuing DDL
for this constraint.
:param link_to_name: if True, the string name given in ``column`` is the rendered
name of the referenced column, not its locally assigned ``key``.
:param use_alter: If True, do not emit this key as part of the CREATE TABLE
definition. Instead, use ALTER TABLE after table creation to add
the key. Useful for circular dependencies.
s9 Alterable ForeignKey/ForeignKeyConstraint requires a nameN( RL R RM t _ForeignKeyConstraint__colnamest" _ForeignKeyConstraint__refcolnamesR RT t elementsR R¿ RÂ R4 R R R_ R¾ (
R Rx t
refcolumnsR4 R R¿ R¾ RÀ RÁ RÂ ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM × s " c C sg | | _ | | i j oJ | i i | ƒ x7 t | i | i ƒ D] \ } } | i | | ƒ q? Wn d S( N( RF RP Ru t zipRü Rý t append_element( R RF R` t r( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR s c C sg t | d | d | i d | i d | i d | i d | i ƒ} | i | i i | ƒ | i | ƒ d S( NR R4 R R¿ R¾ RÂ (
R R4 R R¿ R¾ RÂ R RF R` RÓ ( R Rò t refcolR¬ ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR s ?c C s4 | i i | i i | i i ƒ | i i | ƒ d S( N( Rx Ru RF R` R" RE Rþ ( R R¬ ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRÓ s c K s| t g } | i D] } | | i i q ~ g } | i D] } | | i | q8 ~ d | i d | i d | i d | i ƒS( NR4 R R¿ R¾ ( R Rþ R" R4 RÃ R R¿ R¾ ( R R¶ Ro Ry Rz ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR• s N( R& R. R/ R0 R R= RM R R RÓ R• ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR Ê s
- c B sb e Z d Z d Z d „ Z d „ Z d „ Z e Z d „ Z d „ Z d „ Z
e i Z d „ Z
RS( s1 A table-level PRIMARY KEY constraint.
Defines a single column or composite PRIMARY KEY constraint. For a
no-frills primary key, adding ``primary_key=True`` to one or more
``Column`` definitions is a shorthand equivalent for an unnamed single- or
multiple-column PrimaryKeyConstraint.
t primary_key_constraintc O sŸ t d | i d d ƒ d | i d d ƒ d | i d d ƒ ƒ } | o0 t i d d i d „ | i ƒ Dƒ ƒ ƒ ‚ n t t | ƒ i | t
| ƒ | _ d S( s Construct a composite-capable PRIMARY KEY.
\*columns
A sequence of column names. All columns named must be defined and
present within the parent Table.
name
Optional, the in-database name of the key.
deferrable
Optional bool. If set, emit DEFERRABLE or NOT DEFERRABLE when
issuing DDL for this constraint.
initially
Optional string. If set, emit INITIALLY when issuing DDL
for this constraint.
R4 RÀ RÁ s, Unknown PrimaryKeyConstraint argument(s): %ss , c s s x | ] } t | ƒ Vq Wd S( N( Rl ( t .0Ry ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pys ; s N( t dictR< R R R_ Ri Rm RL R
RM RW t _PrimaryKeyConstraint__colnames( R Rx R# t constraint_args( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM " s 'c C s> | | _ | | _ x% | i D] } | i | i | ƒ q Wd S( N( RF RS R Ru R` ( R RF R4 ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR @ s
c C s | i i | ƒ t | _ d S( N( Rx Ru R˜ RS ( R Rò ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRu F s c C s | i i | ƒ d S( N( Rx R³ ( R Rò ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR³ K s c C s t | _ | i | i =d S( N( R= RS Rx RE ( R Rò ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRa N s c K s1 t d | i g } | D] } | | i q ~ Œ S( NR4 ( R
R4 RE ( R R¶ Ro R` ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR• R s c C s
| i | j S( N( Rx ( R Ró ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt __eq__W s ( R& R. R/ R0 RM R Ru R~ R³ Ra R• R t __hash__R ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR
s c B s8 e Z d Z d Z d „ Z d „ Z d „ Z d „ Z RS( s A table-level UNIQUE constraint.
Defines a single column or composite UNIQUE constraint. For a no-frills,
single column constraint, adding ``unique=True`` to the ``Column``
definition is a shorthand equivalent for an unnamed, single column
UniqueConstraint.
t unique_constraintc O sŸ t d | i d d ƒ d | i d d ƒ d | i d d ƒ ƒ } | o0 t i d d i d „ | i ƒ Dƒ ƒ ƒ ‚ n t t | ƒ i | t
| ƒ | _ d S( sû Construct a UNIQUE constraint.
\*columns
A sequence of column names. All columns named must be defined and
present within the parent Table.
name
Optional, the in-database name of the key.
deferrable
Optional bool. If set, emit DEFERRABLE or NOT DEFERRABLE when
issuing DDL for this constraint.
initially
Optional string. If set, emit INITIALLY when issuing DDL
for this constraint.
R4 RÀ RÁ s( Unknown UniqueConstraint argument(s): %ss , c s s x | ] } t | ƒ Vq Wd S( N( Rl ( R Ry ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pys ~ s N( R R< R R R_ Ri Rm RL R RM RW t _UniqueConstraint__colnames( R Rx R# R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM e s 'c C sE | | _ | i i | ƒ x% | i D] } | i | i | ƒ q# Wd S( N( RF RP Ru R R~ R` ( R RF R` ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR ƒ s
c C s | i i | ƒ d S( N( Rx Ru ( R Rò ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR~ ‰ s c K s t d | i | i Œ S( NR4 ( R R4 R ( R R¶ ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR• Œ s ( R& R. R/ R0 RM R R~ R• ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR Z s c B sb e Z d Z d Z d „ Z d „ Z d „ Z d „ Z d
d „ Z d
d „ Z
d „ Z d „ Z RS( sî A table-level INDEX.
Defines a composite (one or more column) INDEX. For a no-frills, single
column index, adding ``index=True`` to the ``Column`` definition is
a shorthand equivalent for an unnamed, single column Index.
Rž c O sJ | | _ g | _ d | _ | i d t ƒ | _ | | _ | i | Œ d S( sê Construct an index object.
Arguments are:
name
The name of the index
\*columns
Columns to include in the index. All columns must belong to the same
table, and no column may appear more than once.
\**kwargs
Keyword arguments include:
unique
Defaults to False: create a unique index.
postgres_where
Defaults to None: create a partial index when using PostgreSQL
RŸ N( R4 Rx R RF R< R= RŸ R# R ( R R4 Rx R# ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM ™ s c G s( x! | D] } | i t | ƒ ƒ q Wd S( N( R~ t _to_schema_column( R R R} ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR · s c C s) | | _ | i | _ | i i | ƒ d S( N( RF R( RO Ru ( R RF ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR » s c C s | i d j o | i | i ƒ n‹ | i | i j o& t i d | | i | i f ƒ ‚ nR | i g } | i D] } | | i qq ~ j o t i d | i | f ƒ ‚ n | i i | ƒ d S( Ns? All index columns must be from same table. %s is from %s not %ssJ A column may not appear twice in the same index (%s already has column %s)( RF R R R R_ R4 Rx Rƒ ( R R} Ro R` ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR~ À s 1c C s. | d j o t | ƒ } n | i | ƒ | S( N( R R] R’ ( R R) ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR’ Ð s
c C s. | d j o t | ƒ } n | i | ƒ d S( N( R R] R” ( R R) ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR” Ö s
c C s
t | ƒ S( N( Rl ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR| Û s c C s; d | i d i d „ | i Dƒ ƒ | i o d p d f S( Ns Index("%s", %s%s)s , c s s x | ] } t | ƒ Vq Wd S( N( Rl ( R R` ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pys à s s
, unique=TrueR® ( R4 Ri Rx RŸ ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR' Þ s N(
R& R. R/ R0 RM R R R~ R R’ R” R| R' ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR s c B s
e Z d Z d Z d Z d e d „ Z d „ Z d „ Z d „ Z
d
„ Z d „ Z e
i d ƒ d
„ ƒ Z d „ Z d „ Z e e e ƒ Z d „ Z d „ Z e
i d ƒ e d d „ ƒ Z e d „ ƒ Z d d d d „ Z d „ Z d d e d „ Z d d e d „ Z RS( s¤ A collection of Tables and their associated schema constructs.
Holds a collection of Tables and an optional binding to an ``Engine`` or
``Connection``. If bound, the :class:`~sqlalchemy.schema.Table` objects
in the collection and their columns may participate in implicit SQL
execution.
The `Table` objects themselves are stored in the `metadata.tables`
dictionary.
The ``bind`` property may be assigned to dynamically. A common pattern is
to start unbound and then bind later when an engine is available::
metadata = MetaData()
# define tables
Table('mytable', metadata, ...)
# connect to an engine later, perhaps after loading a URL from a
# configuration file
metadata.bind = an_engine
MetaData is a thread-safe object after tables have been explicitly defined
or loaded via reflection.
.. index::
single: thread safety; MetaData
R( s
before-creates after-creates before-drops
after-dropc C s` h | _ | | _ | | _ t i t ƒ | _ | o( | p t i d ƒ ‚ n | i ƒ n d S( s Create a new MetaData object.
bind
An Engine or Connection to bind to. May also be a string or URL
instance, these are passed to create_engine() and this MetaData will
be bound to the resulting engine.
reflect
Optional, automatically load all tables from the bound database.
Defaults to False. ``bind`` is required when this option is set.
For finer control over loaded tables, use the ``reflect`` method of
``MetaData``.
s8 A bind must be supplied in conjunction with reflect=TrueN(
R> R) R( R RV RW RX R R_ t reflect( R R) R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM s
c C s d | i S( Ns MetaData(%r)( R) ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR' s c C s
| | i j S( N( R> ( R RE ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRð s c C s h | i d 6S( NR> ( R> ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt __getstate__# s c C s | d | _ d | _ d S( NR> ( R> R t _bind( R t state( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt __setstate__& s
c C s
| i d j S( s: True if this MetaData is bound to an Engine or Connection.N( R R ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt is_bound* s sJ Deprecated. Use ``metadata.bind = `` or ``metadata.bind = ``.c K sj t d j o d d k l a n t | t t f ƒ o& d d k l } | | | | _ n
| | _ d S( s] Bind this MetaData to an Engine.
bind
A string, ``URL``, ``Engine`` or ``Connection`` instance. If a
string or ``URL``, will be passed to ``create_engine()`` along with
``\**kwargs`` to produce the engine which to connect to. Otherwise
connects directly to the given ``Engine``.
iÿÿÿÿ( t URL( t
create_engineN( R R t sqlalchemy.engine.urlR¢ R£ t
sqlalchemyR R ( R R) R# R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt connect/ s
c C s | i S( s An Engine or Connection to which this MetaData is bound.
This property may be assigned an ``Engine`` or ``Connection``, or
assigned a string or URL to automatically create a basic ``Engine``
for this bind with ``create_engine()``.
( R ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR) D s c C sg t d j o d d k l a n t | t t f ƒ o# d d k l } | | ƒ | _ n
| | _ d S( s; Bind this MetaData to an Engine, Connection, string or URL.iÿÿÿÿ( R ( R N( R R R R¢ R£ R R R ( R R) R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt _bind_toN s
c C s | i i ƒ d S( s+ Clear all Table objects from this MetaData.N( R> t clear( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR \ s c C s | i | i =d S( s1 Remove the given Table object from this MetaData.N( R> RE ( R RF ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRa b s s* Deprecated. Use ``metadata.sorted_tables``c C s{ d d k l } | d j o | i i ƒ } n t | ƒ i | i i ƒ ƒ } | | ƒ } | o t | ƒ } n t | ƒ S( s* Deprecated - use metadata.sorted_tables().iÿÿÿÿ( t sort_tablesN( t sqlalchemy.sql.utilR R R> t valuesRN t intersectiont reversedRõ ( R t reverseR> R t ret( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt table_iteratorh s
c C s# d d k l } | | i i ƒ ƒ S( sS Returns a list of ``Table`` objects sorted in order of
dependency.
iÿÿÿÿ( R ( R R R> R ( R R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt
sorted_tablesv s c C s h t d 6} | d j o t | ƒ } d } n | | d <| i ƒ } | d j o | | d Rm R¤ R R@ t urlRi R ( R R) R5 t onlyt reflect_optsRŒ t availablet currentRo R4 t loadRz R° t missingt st _[4]( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR ~ s4
652&2 c C s8 | | i j o t | ƒ ‚ n | i | i | ƒ d S( sI Append a DDL event listener to this ``MetaData``.
The ``listener`` callable will be triggered when this ``MetaData`` is
involved in DDL creates or drops, and will be invoked either before
all Table-related actions or after.
Arguments are:
event
One of ``MetaData.ddl_events``; 'before-create', 'after-create',
'before-drop' or 'after-drop'.
listener
A callable, invoked with three positional arguments:
event
The event currently being handled
schema_item
The ``MetaData`` object being operated upon
bind
The ``Connection`` bueing used for DDL execution.
Listeners are added to the MetaData's ``ddl_listeners`` attribute.
Note: MetaData listeners are invoked even when ``Tables`` are created
in isolation. This may change in a future release. I.e.::
# triggers all MetaData and Table listeners:
metadata.create_all()
# triggers MetaData listeners too:
some.table.create()
N( R R‚ RX Rƒ ( R R„ R… ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR† ½ s "c C sŠ | d j o t | ƒ } n x% | i d D] } | d | | ƒ q+ W| i | d | d | ƒx% | i d D] } | d | | ƒ ql Wd S( sx Create all tables stored in this metadata.
Conditional by default, will not attempt to recreate tables already
present in the target database.
bind
A :class:`~sqlalchemy.engine.base.Connectable` used to access the database; if None, uses the
existing bind on this ``MetaData``, if any.
tables
Optional list of ``Table`` objects, which is a subset of the total
tables in the ``MetaData`` (others are ignored).
checkfirst
Defaults to True, don't issue CREATEs for tables already present
in the target database.
s
before-createR R> s after-createN( R R] RX R’ ( R R) R> R R… ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR‘ ã s
c C sŠ | d j o t | ƒ } n x% | i d D] } | d | | ƒ q+ W| i | d | d | ƒx% | i d D] } | d | | ƒ ql Wd S( si Drop all tables stored in this metadata.
Conditional by default, will not attempt to drop tables not present in
the target database.
bind
A :class:`~sqlalchemy.engine.base.Connectable` used to access the database; if None, uses
the existing bind on this ``MetaData``, if any.
tables
Optional list of ``Table`` objects, which is a subset of the
total tables in the ``MetaData`` (others are ignored).
checkfirst
Defaults to True, only issue DROPs for tables confirmed to be present
in the target database.
s before-dropR R> s
after-dropN( R R] RX R” ( R R) R> R R… ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR“ þ s
( s
before-creates after-creates before-drops
after-dropN( R& R. R/ R0 R R R= RM R' Rð R R R R t
deprecatedR R) R R2 R Ra R˜ R" R# R R† R‘ R“ ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR ã s,
? &c B sh e Z d Z d Z d „ Z e i d ƒ d „ ƒ Z d „ Z d „ Z e
e e ƒ Z d „ Z d „ Z RS( s A MetaData variant that presents a different ``bind`` in every thread.
Makes the ``bind`` property of the MetaData a thread-local value, allowing
this collection of tables to be bound to different ``Engine``
implementations or connections in each thread.
The ThreadLocalMetaData starts off bound to None in each thread. Binds
must be made explicitly by assigning to the ``bind`` property or using
``connect()``. You can also re-bind dynamically multiple times per
thread, just like a regular ``MetaData``.
R( c C s2 t i i ƒ | _ h | _ t t | ƒ i ƒ d S( s Construct a ThreadLocalMetaData.N( R t threadingt localt contextt _ThreadLocalMetaData__enginesRL R RM ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRM ) s sJ Deprecated. Use ``metadata.bind = `` or ``metadata.bind = ``.c K s˜ t d j o d d k l a n t | t t f ƒ oP y | i | } Wn2 t j
o& d d k l } | | | } n X| } n | i | ƒ d S( s[ Bind to an Engine in the caller's thread.
bind
A string, ``URL``, ``Engine`` or ``Connection`` instance. If a
string or ``URL``, will be passed to ``create_engine()`` along with
``\**kwargs`` to produce the engine which to connect to. Otherwise
connects directly to the given ``Engine``.
iÿÿÿÿ( R ( R N(
R R R R¢ R£ R5 RB R R R ( R R) R# R& R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR 0 s
c C s t | i d d ƒ S( sê The bound Engine or Connection for this thread.
This property may be assigned an Engine or Connection, or assigned a
string or URL to automatically create a basic Engine for this bind
with ``create_engine()``.t _engineN( Rt R4 R ( R ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR) I s c C sÎ t d j o d d k l a n t | t t f ƒ of y | i | | i _ WqÊ t j
o< d d k l
} | | ƒ } | | i | <| | i _ qÊ Xn. | | i j o | | i | RØ ( R R„ R R) R: ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRD 0 s c C s | i | i | | ƒ S( N( R: t _prepare_context( R R R) ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR> 7 s c C sS | i d j o t St | i t ƒ o | i | i i j S| i | | | ƒ Sd S( N( R; R R˜ R¢ R£ R& R4 ( R R„ R R) ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR< : s
c C sÀ t | t ƒ o¥ | i i ƒ } | i i } | i | ƒ } t | ƒ d j o | d d } } n | d | d } } | i d | ƒ | i d | ƒ | i d | i | ƒ ƒ | S| i Sd S( Ni i R® iÿÿÿÿRF R5 RY (
R¢ R R4 R• RŠ t identifier_preparert format_table_seqRf t
setdefaultt format_table( R R R) R4 t preparert pathRF R5 ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyRB B s c
C s{ d t | ƒ i t | ƒ d i t | i ƒ g g } d D]4 } t | | ƒ o | d | t | | ƒ f q8 q8 ~ ƒ f S( Ns <%s@%s; %s>s , R; R4 s %s=%r( s ons context( RC R& t idRi Rl R: Rt ( R Ro RE ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR' U s
N( R& R. R/ R RM RØ RA R) R R2 RD R> R< RB R' ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR | s < 1 c C sG t | d ƒ o | i ƒ } n t | t ƒ p t i d ƒ ‚ n | S( NRÄ s schema.Column object expected( RÅ RÄ R¢ R R R_ ( t element( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR
] s
c C s° | i } | pœ | i i } t | d t | d d ƒ ƒ } | o d | | f } n | } t | t t f ƒ o d | } n d | } d | | f } t i | ƒ ‚ n | S( NRY R4 s %s %rs the %s's .binds this %s's .metadata.bindsÈ The %s is not bound to an Engine or Connection. Execution can not proceed without a database to execute against. Either execute with an explicit connection or assign %s to enable implicit execution.(
R) R% R& Rt R R¢ R R R t UnboundExecutionError( t
schemaitemR) R4 t labelR t bindablet msg( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyR] d s
(- R/ Rg RÞ R R R R R t sqlalchemy.sqlR R R R Rj t sortt VisitableR R6 t
VisitableTypeR7 Rˆ R R» R R R R R
t objectR R R R R R R
R R R R t
ClauseVisitorR R R
R] ( ( ( s5 /usr/lib/python2.6/site-packages/sqlalchemy/schema.pyt sJ "
) ÿ $ ÿ bÒ8)2-MC5Tÿ 7]á