Skip to content

Instantly share code, notes, and snippets.

@Kyu
Created January 2, 2018 15:19
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 Kyu/c8260bf8181de334ceaf85b21b888a62 to your computer and use it in GitHub Desktop.
Save Kyu/c8260bf8181de334ceaf85b21b888a62 to your computer and use it in GitHub Desktop.
converts sqlite to mysql
#Incomplete
from sqlalchemy import (
create_engine,
MetaData,
Table
)
from sqlalchemy.orm import sessionmaker
sqlite_engine = create_engine('sqlite:///main.db', echo=True)
SqliteSession = sessionmaker(bind=sqlite_engine)
sqlite_session = SqliteSession()
sqlite_meta = MetaData(sqlite_engine)
sqlite_tables = dict()
for tb in sqlite_engine.table_names():
sqlite_tables[tb] = Table(tb, sqlite_meta, autoload=True, autoload_with=sqlite_engine)
mysql_engine = create_engine('mysql+pymysql://root:****@localhost/tee', echo=True)
mysql_meta = MetaData(mysql_engine)
mysql_meta.create_all(tables=[i for i in list(sqlite_tables.values())])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment