Skip to content

Instantly share code, notes, and snippets.

@buxx

buxx/sqla_copy_data.py

Created October 25, 2019 08:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save buxx/1e552aa80053570d4cf72cb445996780 to your computer and use it in GitHub Desktop.
Save buxx/1e552aa80053570d4cf72cb445996780 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqla_copy_data.py
src = create_engine('mysql+oursql://username:password@127.0.0.1:3306/dbname')
dst = create_engine('postgresql://username:password@localhost:5432/dbname')
tables = Base.metadata.tables;
for tbl in tables:
data = src.execute(tables[tbl].select()).fetchall()
for a in data: print(a)
if data:
print (tables[tbl].insert())
dst.execute( tables[tbl].insert(), data)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment