Hi Leonard,
paniq303 wrote:
> Hello,
>
> how is the progress with this feature - how can I use it? My
> application strongly depends on AUTOINCREMENT being available.
>
> To explain:
>
> Without AUTOINCREMENT, a deleted primary key will be reassigned.
>
> As an example: three records are created, with ids 1, 2 and 3. Now the
> record with id 3 is being deleted. We create a new record, and this
> record will get id 3 again, instead of id 4. In this way, there can be
> confusion between the old and the new record with id 3.
>
It is available in SA, i.e. I use it with Firebird SQL and in my model I
just do this:
sa.Column(u'langid', sa.Integer(),
sa.Sequence('gen_language_langid'), primary_key=True, nullable=False),
The sa.Sequence will with Firebird use a generator which will assign an
unique number.
See its doc here:
http://www.sqlalchemy.org/docs/05/metadata.html#defining-sequences
What database are you using?
Werner
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
