[sqlalchemy] Re: Create Database trought sqlalchemy 0.6.6 !

2011-02-22 Thread Eric Ongerth
sqlalchemy allows you to issue any literal sql statements as text: http://www.sqlalchemy.org/docs/core/tutorial.html#using-text On Feb 22, 7:38 am, Toninho Nunes toninhonu...@gmail.com wrote: Hi, I would like to know how to create database with sqlalchemy using the PostGresql driver, are

[sqlalchemy] Re: Create Database trought sqlalchemy 0.6.6 !

2011-02-22 Thread Eric Ongerth
Even with that autocommit transaction isolation level, you probably need to commit the create database before you try to add tables to it. On Feb 22, 1:45 pm, Toninho Nunes toninhonu...@gmail.com wrote: Hi see my source code below import sqlalchemy import psycopg2 from sqlalchemy import

Re: [sqlalchemy] Re: Create Database trought sqlalchemy 0.6.6 !

2011-02-22 Thread Michael Bayer
Setting an autocommit setting on a single raw_connection() won't work also because that's just one connection out of several in the pool. The operation should be performed on a Connection: c = engine.connect() c.detach() # so it is never returned to the pool, since we're changing settings

[sqlalchemy] Re: Create Database trought sqlalchemy 0.6.6 !

2011-02-22 Thread Toninho Nunes
You are right, but I would like to create the database without to connect to other database existent, I'm newbie learning python and sqlalchemy. any example will be welcome. Thanks a lot On Feb 22, 6:06 pm, Warwick Prince warwi...@mushroomsys.com wrote: Hi Toninho Looks to me that the issue