[sqlalchemy] Re: Sequences support for CYCLE and MIN/MAX values

2010-03-26 Thread Kent
Sorry! Nevermind, your link answers that question. Thanks. On Mar 26, 4:23 pm, Kent Bower k...@retailarchitects.com wrote: Thanks for the info. Since it is NOCYCLE in oracle and NO CYCLE in postgres, I would check the engine.dialect.name in the compile, method correct?                    

[sqlalchemy] Re: Sequences

2007-06-15 Thread Andreas Jung
--On 15. Juni 2007 12:55:43 + voltron [EMAIL PROTECTED] wrote: Could someone point me to the documentation about declaring and using Sequence fields in Sqlalchemy? Check yourself with the SA docs on sqlalchemy.org under defining sequences. -aj pgpWMRtJ1NwMS.pgp Description: PGP

[sqlalchemy] Re: sequences skipping and reporting incorrectly

2006-12-01 Thread Michael Bayer
if youre using the ORM, its doing a flush() which can insert many values at once. the ID for each value is available on the newly saved instance directly. if you need to get the ID at the instant its saved, you can implement the after_insert() method on mapper extension which will give you the

[sqlalchemy] Re: sequences skipping and reporting incorrectly

2006-12-01 Thread Rick S.
I don't need to do anything between. Our use of transactions is simple-- almost always a single-operation happens per flush. I looked at after_insert, but am not exactly sure how that can help me. Do I need to define something so that it retrieves the record from the database? (I looked for

[sqlalchemy] Re: sequences skipping and reporting incorrectly

2006-12-01 Thread Rick S.
Thank you much! You hit the nail on the head with your observation about the bldcmdid not being a primary key. I verified that an identical operation worked 100% correctly on a table where the primary key was also a serial type. I needed the combination of a few keys to be unique. I naively