SQLAlchemy printing raw SQL from create()

by 
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()))

More Related Contents:

  1. How to get column names from SQLAlchemy result (declarative syntax)
  2. sqlalchemy existing database query
  3. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  4. SQLAlchemy IN clause
  5. Flask SQLAlchemy query, specify column names
  6. How can I bind a list to a parameter in a custom query in SQLAlchemy?
  7. How to disable SQLAlchemy caching?
  8. Case Insensitive Flask-SQLAlchemy Query
  9. sqlalchemy unique across multiple columns
  10. How to build a flask application around an already existing database?
  11. How to create a new database using SQLAlchemy?
  12. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  13. Multi-threaded use of SQLAlchemy
  14. How to discover table properties from SQLAlchemy mapped object
  15. IntegrityError when inserting data in an association table using SQLAlchemy
  16. AttributeError: ‘int’ object has no attribute ‘_sa_instance_state’
  17. Dynamic Class Creation in SQLAlchemy
  18. Strange SQLAlchemy error message: TypeError: ‘dict’ object does not support indexing
  19. SQLAlchemy equivalent to SQL “LIKE” statement
  20. How do I connect to SQL Server via sqlalchemy using Windows Authentication?
  21. How to get rows which match a list of 3-tuples conditions with SQLAlchemy
  22. Best way to do enum in Sqlalchemy?
  23. How do I INSERT INTO t1 (SELECT * FROM t2) in SQLAlchemy?
  24. Creating partial unique index with sqlalchemy on Postgres
  25. SQLAlchemy Joinedload filter column
  26. SQLAlchemy func.count on boolean column
  27. SQLAlchemy column name with space
  28. Connecting to SQL Server 2012 using sqlalchemy and pyodbc
  29. using sqlalchemy to load csv file into a database
  30. pyodbc.connect() works, but not sqlalchemy.create_engine().connect()

Leave a Comment