Module « sqlalchemy »

Classe « Sequence »

Informations générales

Héritage

    builtins.object
        Traversible
    builtins.object
        SchemaEventTarget
            SchemaItem
builtins.object
    HasMemoized
        Generative
builtins.object
    SQLRole
        StatementRole
            Executable
                DefaultGenerator
            builtins.object
                IdentityOptions
                    Sequence

Définition

class Sequence(IdentityOptions, DefaultGenerator):

Description _{[extrait de Sequence.doc]}

Represents a named database sequence.

    The :class:`.Sequence` object represents the name and configurational
    parameters of a database sequence.   It also represents
    a construct that can be "executed" by a SQLAlchemy :class:`_engine.Engine`
    or :class:`_engine.Connection`,
    rendering the appropriate "next value" function
    for the target database and returning a result.

    The :class:`.Sequence` is typically associated with a primary key column::

        some_table = Table(
            'some_table', metadata,
            Column('id', Integer, Sequence('some_table_seq'),
            primary_key=True)
        )

    When CREATE TABLE is emitted for the above :class:`_schema.Table`, if the
    target platform supports sequences, a CREATE SEQUENCE statement will
    be emitted as well.   For platforms that don't support sequences,
    the :class:`.Sequence` construct is ignored.

    .. seealso::

        :ref:`defaults_sequences`

        :class:`.CreateSequence`

        :class:`.DropSequence`

Constructeur(s)

Signature du constructeur	Description
__init__(self, name, start=None, increment=None, minvalue=None, maxvalue=None, nominvalue=None, nomaxvalue=None, cycle=None, schema=None, cache=None, order=None, data_type=None, optional=False, quote=None, metadata=None, quote_schema=None, for_update=False)	Construct a :class:`.Sequence` object. _{[extrait de __init__.__doc__]}

Liste des attributs statiques

Nom de l'attribut	Valeur
allows_lambda	False
column	None
create_drop_stringify_dialect	default
dispatch	<sqlalchemy.event.base.DDLEventsDispatch object at 0x7f40cbc2af40>
info	<sqlalchemy.util.langhelpers.memoized_property object at 0x7f40cbc85d20>
is_callable	<sqlalchemy.util.langhelpers.memoized_property object at 0x7f40cbae8b50>
is_clause_element	<sqlalchemy.util.langhelpers.memoized_property object at 0x7f40cbaea860>
is_delete	False
is_dml	False
is_insert	False
is_select	False
is_sequence	True
is_server_default	False
is_text	False
is_update	False
supports_execution	True
uses_inspection	False

Liste des propriétés

Nom de la propriété	Description
bind

Liste des opérateurs

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
create(self, bind=None, checkfirst=True)	Creates this sequence in the database. _{[extrait de create.__doc__]}
drop(self, bind=None, checkfirst=True)	Drops this sequence from the database. _{[extrait de drop.__doc__]}
next_value(self)	Return a :class:`.next_value` function element _{[extrait de next_value.__doc__]}