sqlacodegen을 python으로 실행하여 models.py 만들기

make_models.py

from sqlalchemy.engine import create_engine
from sqlalchemy.schema import MetaData

from sqlacodegen.codegen import CodeGenerator

url = 'mysql+pymysql://user:password@localhost/dbname'
engine = create_engine(url)
metadata = MetaData(engine)
metadata.reflect(engine)


with open('models.py', 'w', encoding='utf-8') as outfile:
    generator = CodeGenerator(metadata)
    generator.render(outfile)

requiremests.txt

sqlalchemy
sqlacodegen