[sqlalchemy] Re: creating a database through SQLAlchemy

2007-09-04 Thread Travis Kriplean
Thanks everyone! On 3 Sep, 01:13, Marco Mariani [EMAIL PROTECTED] wrote: TravisKriplean ha scritto: However, this seems a bit ugly. Is there a way to obtain a non- transactional connection from an engine in 0.3.10? If not, is it possible in 0.4? I use this with SA 0.3.10 and Postgres:

[sqlalchemy] Re: creating a database through SQLAlchemy

2007-09-03 Thread Marco Mariani
Travis Kriplean ha scritto: However, this seems a bit ugly. Is there a way to obtain a non- transactional connection from an engine in 0.3.10? If not, is it possible in 0.4? I use this with SA 0.3.10 and Postgres:

[sqlalchemy] Re: creating a database through SQLAlchemy

2007-08-31 Thread Michael Bayer
all connections in DBAPI are transactional. theres no begin() method, only commit() and rollback(). some DBAPis support an autocommit flag but this is not standardized. so SA has not much choice but to issue its own autocommit behavior, which could be expanded to detect CREATE

[sqlalchemy] Re: creating a database through SQLAlchemy

2007-08-30 Thread Mike Orr
On 8/30/07, Travis Kriplean [EMAIL PROTECTED] wrote: I'd like to use SQLAlchemy to connect to a db server, create a database, and then start using it. However, it appears that the SQLAlchemy api assumes the existence of a database to connect to. I'm able to connect to the server without a