Re: [sqlalchemy] sequence incrementing

2011-02-05 Thread Michael Bayer
On Feb 4, 2011, at 5:46 PM, Josh Stratton wrote: I'm currently passing the table the sequence object, when I create the table. I've been building the table with metadata.create_all. Calling sequnce.create() before creating the table complains of no binding to an engine or a connection. I

Re: [sqlalchemy] sequence incrementing

2011-02-05 Thread Michael Bayer
On Feb 4, 2011, at 5:59 PM, Josh Stratton wrote: I've tried something like this before creating the table. Here len(sites) is definitely evaluating to 6 as it should, but I'm only getting the increment issue now. sequence = Sequence('id_seq', start=siteIndex, increment=len(sites),

[sqlalchemy] sequence incrementing

2011-02-04 Thread Josh Stratton
I'm connecting to an Oracle database for my work and we do replication by periodically joining tables across sites instead of a single server just in case a link in between goes down. One issue with this though is I need to generate unique keys for a single table so if the connection does go

Re: [sqlalchemy] sequence incrementing

2011-02-04 Thread Michael Bayer
The sequence has to be created (meaning, the appropriate DDL statements must be executed) on the target platform with those options, or the appropriate ALTER statements emitted to ALTER the sequence's settings. So when those flags are applied to sqlalchemy.Sequence(), its assumed that you're

Re: [sqlalchemy] sequence incrementing

2011-02-04 Thread Josh Stratton
I'm currently passing the table the sequence object, when I create the table. I've been building the table with metadata.create_all. Calling sequnce.create() before creating the table complains of no binding to an engine or a connection. I understand this makes sense as I haven't told the