이미 만들어진 DB에서 sqlalchemy Model 생성하기

이미 만들어진 DB에서 sqlalchemy Model 생성하기

 

 

	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)

view raw make_models.py hosted with ❤ by GitHub

	sqlalchemy
	sqlacodegen

view raw requiremests.txt hosted with ❤ by GitHub