how to get sql dump of a database created in sqlite using sqlalchemy

Question

I have data read from json and fed into an sqlite database with proper schema using sql-alchemy in python. (used pd.dataframe.to_sql() for this). I want the database dump (.sql file) of this database. is there any api in sql alchemy that would do this?

Gord Thompson · Accepted Answer · 2019-10-26 18:18:56Z

3

Assuming that you have a SQLAlchemy engine object associated with your SQLite database you can simply use Python's iterdump method like so:

con = engine.raw_connection()
with open('C:/Users/Gord/Desktop/dump.sql', 'w') as f:
    for line in con.iterdump():
        f.write('%s\n' % line)

answered Oct 26, 2019 at 18:18

Gord Thompson

125k39 gold badges252 silver badges458 bronze badges

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

3 Comments

peak Over a year ago

The iterdump referenced here is an sqlite3 function.

G M Over a year ago

Is there any agnostic SQL alchemy function to generate a SQL dump from a database connection?

stonito Aug 30 at 7:53

Just a note, it should be f.write('%s/n' % line) as \n is not a special character.

Collectives™ on Stack Overflow

how to get sql dump of a database created in sqlite using sqlalchemy

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related