Use raw SQL to create tables in SQLAlchemy, after which use ORM

Question

Is it possible to use raw SQL rather than the TABLE construct for creating tables in SQL Alchemy? I would still like to use the rest of SQLAlchemy though, such as the object mapper and session module. I'm just not fond of the SQLAlchemy syntax used to create tables (I've spent too long mired in SAS and SQL to learn another!).

Many thanks, Rich

Alex Brasetvik · Accepted Answer · 2010-01-02 20:59:09Z

3

Yes.

connection.execute("""
CREATE TABLE ...
""")

You can then reflect all tables: MetaData(dsn, reflect=True) or metadata_instance.reflect().

answered Jan 2, 2010 at 20:59

Alex Brasetvik

11.8k2 gold badges40 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Noufal Ibrahim · Accepted Answer · 2010-01-03 08:15:20Z

1

You can use the autoload paramater to the Table constructor to have it automatically load up the table definitions. There are some examples here.

answered Jan 3, 2010 at 8:15

Noufal Ibrahim

73.2k13 gold badges140 silver badges174 bronze badges

Collectives™ on Stack Overflow

Use raw SQL to create tables in SQLAlchemy, after which use ORM

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related