Sqlacodegen
lastmod 2024-12-03created 2024-12-031 edits
Automatically generates tables (code) for use with SQLAlchemy.
Install
## sqlacodegen
pip install sqlacodegen
## MySQL 사용시
pip install pymysql
## sqlalchemy
pip install sqlalchemy
Examples
sqlacodegen 'mysql+pymysql://username:password@localhost:3307/dbname' > tables.py
sqlacodegen 'mssql+pymssql://username:password@localhost:1433/dbname' > tables.py