File size: 683 Bytes
fd21f0c |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
from sqlalchemy_schemadisplay import create_schema_graph
from sqlalchemy import MetaData
from database import engine # same folder import
# Reflect database schema
metadata = MetaData()
metadata.reflect(bind=engine)
# Generate the diagram
graph = create_schema_graph(
engine=engine, # ✅ required in newer versions
metadata=metadata,
show_datatypes=True, # show column data types
show_indexes=True, # show indexes
rankdir='LR', # left-to-right layout
concentrate=False # avoid merging edges
)
# Save diagram
graph.write_png('models_diagram.png')
print("✅ ER diagram generated: models_diagram.png")
|