From 32ee73460d011cb400cb8ef55fe13a201af3441c Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 26 Sep 2007 23:29:11 +0000 Subject: [PATCH] add micro-doc for sequence standalone execution --- doc/build/content/metadata.txt | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/doc/build/content/metadata.txt b/doc/build/content/metadata.txt index a76cd67241..1baa66364e 100644 --- a/doc/build/content/metadata.txt +++ b/doc/build/content/metadata.txt @@ -396,6 +396,12 @@ When the `Sequence` is associated with a table, CREATE and DROP statements issue The flag `optional=True` on `Sequence` will produce a sequence that is only used on databases which have no "autoincrementing" capability. For example, Postgres supports primary key generation using the SERIAL keyword, whereas Oracle has no such capability. Therefore, a `Sequence` placed on a primary key column with `optional=True` will only be used with an Oracle backend but not Postgres. +A sequence can also be executed standalone, using an `Engine` or `Connection`, returning its next value in a database-independent fashion: + + {python} + seq = Sequence('some_sequence') + nextid = connection.execute(seq) + ### Defining Constraints and Indexes {@name=constraints} #### UNIQUE Constraint -- 2.47.3