Module « sqlalchemy »

Classe « MetaData »

Informations générales

Héritage

builtins.object
    Traversible
builtins.object
    SchemaEventTarget
        SchemaItem
            MetaData

Définition

class MetaData(SchemaItem):

Description _{[extrait de MetaData.doc]}

A collection of :class:`_schema.Table`
    objects and their associated schema
    constructs.

    Holds a collection of :class:`_schema.Table` objects as well as
    an optional binding to an :class:`_engine.Engine` or
    :class:`_engine.Connection`.  If bound, the :class:`_schema.Table` objects
    in the collection and their columns may participate in implicit SQL
    execution.

    The :class:`_schema.Table` objects themselves are stored in the
    :attr:`_schema.MetaData.tables` dictionary.

    :class:`_schema.MetaData` is a thread-safe object for read operations.
    Construction of new tables within a single :class:`_schema.MetaData`
    object,
    either explicitly or via reflection, may not be completely thread-safe.

    .. seealso::

        :ref:`metadata_describing` - Introduction to database metadata

Constructeur(s)

Signature du constructeur	Description
__init__(self, bind=None, schema=None, quote_schema=None, naming_convention=None, info=None)	Create a new MetaData object. _{[extrait de __init__.__doc__]}

Liste des attributs statiques

Nom de l'attribut	Valeur
create_drop_stringify_dialect	default
dispatch	<sqlalchemy.event.base.DDLEventsDispatch object at 0x7f40cbc2af40>
info	<sqlalchemy.util.langhelpers.memoized_property object at 0x7f40cbc85d20>
tables	None

Liste des propriétés

Nom de la propriété	Description
bind	An :class:`_engine.Engine` or :class:`_engine.Connection` _{[extrait de __doc__]}
sorted_tables	Returns a list of :class:`_schema.Table` objects sorted in order of _{[extrait de __doc__]}

Liste des opérateurs

Signature de l'opérateur	Description
__contains__(self, table_or_key)

Opérateurs hérités de la classe object

__eq__, __ge__, __gt__, __le__, __lt__, __ne__

Liste des méthodes

Toutes les méthodes Méthodes d'instance Méthodes statiques

Signature de la méthode	Description
__getstate__(self)
__repr__(self)
__setstate__(self, state)
clear(self)	Clear all Table objects from this MetaData. _{[extrait de clear.__doc__]}
create_all(self, bind=None, tables=None, checkfirst=True)	Create all tables stored in this metadata. _{[extrait de create_all.__doc__]}
drop_all(self, bind=None, tables=None, checkfirst=True)	Drop all tables stored in this metadata. _{[extrait de drop_all.__doc__]}
is_bound(self)	True if this MetaData is bound to an Engine or Connection. _{[extrait de is_bound.__doc__]}
reflect(self, bind=None, schema=None, views=False, only=None, extend_existing=False, autoload_replace=True, resolve_fks=True, **dialect_kwargs)	Load all available table definitions from the database. _{[extrait de reflect.__doc__]}
remove(self, table)	Remove the given Table object from this MetaData. _{[extrait de remove.__doc__]}