Module « sqlalchemy »

Classe « DDL »

Informations générales

Héritage

    builtins.object
        Traversible
    builtins.object
        HasCopyInternals
builtins.object
    HasMemoized
builtins.object
    HasCacheKey
        MemoizedHasCacheKey
builtins.object
    SupportsAnnotations
        SupportsWrappingAnnotations
    builtins.object
        SQLRole
            ClauseElement
                _DDLCompiles
    builtins.object
        HasMemoized
            Generative
    builtins.object
        SQLRole
            StatementRole
                Executable
    builtins.object
        SQLRole
            StatementRole
                DDLRole
                    DDLElement
                        DDL

Définition

class DDL(DDLElement):

Description _{[extrait de DDL.__doc__]}

A literal DDL statement.

    Specifies literal SQL DDL to be executed by the database.  DDL objects
    function as DDL event listeners, and can be subscribed to those events
    listed in :class:`.DDLEvents`, using either :class:`_schema.Table` or
    :class:`_schema.MetaData` objects as targets.
    Basic templating support allows
    a single DDL instance to handle repetitive tasks for multiple tables.

    Examples::

      from sqlalchemy import event, DDL

      tbl = Table('users', metadata, Column('uid', Integer))
      event.listen(tbl, 'before_create', DDL('DROP TRIGGER users_trigger'))

      spow = DDL('ALTER TABLE %(table)s SET secretpowers TRUE')
      event.listen(tbl, 'after_create', spow.execute_if(dialect='somedb'))

      drop_spow = DDL('ALTER TABLE users SET secretpowers FALSE')
      connection.execute(drop_spow)

    When operating on Table events, the following ``statement``
    string substitutions are available::

      %(table)s  - the Table name, with any required quoting applied
      %(schema)s - the schema name, with any required quoting applied
      %(fullname)s - the Table name including schema, quoted if needed

    The DDL's "context", if any, will be combined with the standard
    substitutions noted above.  Keys present in the context will override
    the standard substitutions.

    

Constructeur(s)

Signature du constructeur	Description
__init__(self, statement, context=None, bind=None)	Create a DDL statement. [extrait de __init__.__doc__]

Attributs statiques hérités de la classe _DDLCompiles

bind

Liste des opérateurs

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

__invert__

Liste des opérateurs

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

__eq__, __ge__, __gt__, __le__, __lt__, __ne__

Méthodes héritées de la classe DDLElement

__call__, __init_subclass__, __subclasshook__, against, execute, execute_if

Méthodes héritées de la classe ClauseElement

__bool__, __getstate__, __nonzero__, __str__, compare, compile, params, self_group, unique_params

Méthodes héritées de la classe Traversible

__class_getitem__, get_children

Méthodes héritées de la classe Executable

execution_options, get_execution_options, options, scalar

Méthodes héritées de la classe HasMemoized

memoized_attribute, memoized_instancemethod

Méthodes héritées de la classe object

__delattr__, __dir__, __format__, __getattribute__, __hash__, __reduce__, __reduce_ex__, __setattr__, __sizeof__