Re: [sqlalchemy]Close database connection in SQLAlchemy

2012-01-23 Thread Sana klh
Thank you for the document . im currently using SQLSoup to connect to my database like this SqlSoup('mysql://@localhost:portnumbr/databasename') How can i achieve the same using SQLAlchemy? On Mon, Jan 23, 2012 at 4:37 AM, Jackson, Cameron < cameron.jack...@thalesgroup.com.au> wrote: > * > htt

Re: [sqlalchemy] CREATE SEQUENCE issued twice (sqlalchemy 0.7.4 with oracle)

2012-01-23 Thread Michael Bayer
On Jan 23, 2012, at 6:45 PM, Michael Bayer wrote: > > On Jan 23, 2012, at 8:25 AM, Robert Forkel wrote: > >> hi, >> just ran into the following problem: When creating tables (for oracle) >> with a primary key fetched from a sequence, the create statement for >> the sequence is issued twice; i.e

Re: [sqlalchemy] CREATE SEQUENCE issued twice (sqlalchemy 0.7.4 with oracle)

2012-01-23 Thread Michael Bayer
On Jan 23, 2012, at 8:25 AM, Robert Forkel wrote: > hi, > just ran into the following problem: When creating tables (for oracle) > with a primary key fetched from a sequence, the create statement for > the sequence is issued twice; i.e. the following code > > from sqlalchemy import MetaData, cre

RE: [sqlalchemy] Anticipating an IntegrityError before it happens (or noticing it immediately after)

2012-01-23 Thread Jackson, Cameron
Ahh, that looks like it might help! After I use begin_nested(), does the next commit() commit the nested changes to the database, or does it commit them back to the outer session? -Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of Wic

[sqlalchemy] CREATE SEQUENCE issued twice (sqlalchemy 0.7.4 with oracle)

2012-01-23 Thread Robert Forkel
hi, just ran into the following problem: When creating tables (for oracle) with a primary key fetched from a sequence, the create statement for the sequence is issued twice; i.e. the following code from sqlalchemy import MetaData, create_engine, Table, Column, Integer, Sequence from sqlalchemy.sch