Export SQL Script from SQLAlchemy

Question

I am using SQLAlchemy with ORM and DeclarativeMeta to connect to my Database.

Is there a way to generate or export a .sql file that contains all the Create Tables Commands?

Thank you!

I tried to get that information from my Meta Object or even from my SQLAlchemy Engine but they don't hold information like that.

Even the Meta.metadate._create_all() does not return a string or something else

NiklasUllmann · Accepted Answer · 2022-12-02 15:30:49Z

1

Found an answers in the documentation of sqlalchemy.

from sqlalchemy.schema import CreateTable
print(CreateTable(my_mysql_table).compile(mysql_engine))

CREATE TABLE my_table (
id INTEGER(11) NOT NULL AUTO_INCREMENT,
...
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

SQLAlchemy Documentation!

answered Dec 2, 2022 at 15:30

NiklasUllmann

771 gold badge2 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

Export SQL Script from SQLAlchemy

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related