Er Diagram from a dict Python

Viewed 514

I have a database. The task was to get all the views, see what is inside and visualize all the tables and views that are inside. I made a dict like:

{
    view_name1: [tab1, tab2, view_name2],
    view_name2: [tab4, tab99, view_name43],
    ...
}

So as u can see, there might be the same views or tabs in each view.

But now I gotta create a ER diagram with all relations. I found ERALCHEMY but it works only from databases or SQLALCHEMY models.

So how to create a er diagram from a dict or maybe from a DataFrame. Or I should create a model from a dict?

0 Answers
Related