How to transfer data from MySQL shema to class for use in flask sqlalchemy?

Question

MySQL

There is a mysql database. It contains hundreds of tables and fields.
Do not manually write a description for each table and field, in the form:

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True)
    email = db.Column(db.String(120), unique=True)

Maybe there is some converter that would interrogate all the tables and fields in the database,
and then present it as classes, as in the example?

Answer 1

Your question is very closely related to stackoverflow.com/questions/1425412/reverse-engine...
Use sqlautocode .

Answer 2

IMHO, you need to write such a script yourself.