[FIXED] How to generate python models from existing Postgres schema?

Issue

I have a PostgreSQL database with existing tables. I wish to :

1. Create a set of Python models (plain classes, SQLAlchemy models or other) based on the existing database
2. Then manage changes in these models with a migrations tool.

The second part I think is easy to achieve as long as I manage to get my initial schema created. How can this be achieved?

Solution

So if someone is willing to use SQLAlchemy I found these two solutions:

1. Straight with SQLAlchemy reflection and automapping
2. With sqlacodegen

Answered By - KZiovas

Answer Checked By - David Goodson (PHPFixing Volunteer)