SQLAlchemy printing raw SQL from create()

python sqlalchemy pylons
Mads Madsen picture Mads Madsen · Jan 24, 2010 · Viewed 26.4k times · Source

I am giving Pylons a try with SQLAlchemy, and I love it, there is just one thing, is it possible to print out the raw SQL CREATE TABLE data generated from Table().create() before it's executed?

Answer

Antoine Leclair picture Antoine Leclair · Jun 30, 2010 
from sqlalchemy.schema import CreateTable

print(CreateTable(table))

If you are using declarative syntax:

print(CreateTable(Model.__table__))

Update:

Since I have the accepted answer and there is important information in klenwell answer, I'll also add it here.

You can get the SQL for your specific database (MySQL, Postgresql, etc.) by compiling with your engine.

print(CreateTable(Model.__table__).compile(engine))

Update 2:

@jackotonye Added in the comments a way to do it without an engine.

print(CreateTable(Model.__table__).compile(dialect=postgresql.dialect()))

Related questions

How can I select all rows with sqlalchemy?

I am trying to get all rows from a table. In controller I have: meta.Session.query(User).all() The result is [, ], but I have 2 rows in this table. I use this model for the table: import hashlib import sqlalchemy …

Read More
How to get column names from SQLAlchemy result (declarative syntax)

I am working in a pyramid project and I've the table in SQLAlchemy in declarative syntax """models.py""" class Projects(Base): __tablename__ = 'projects' __table_args__ = {'autoload': True} I get the results by using """"views.py""" session = DBSession() row_data = session.…

Read More
SQLAlchemy, clear database content but don't drop the schema

I'm developing a Pylons app which is based on exisitng database, so I'm using reflection. I have an SQL file with the schema that I used to create my test database. That's why I can't simply use drop_all and …

Read More