Alembic从数据库构建Python Orm文件

发布于 2025-01-22 23:36:15 字数 528 浏览 0 评论 0原文

我有一个包含近100个表的数据库。我正在尝试使用Alembic在Python中进行管理。 Alembic有没有办法为我构建Orm Python文件，或者我必须自己编写它们。

例如，在数据库中有一个带有列ID的用户表，first_name，last_name，电子邮件是否可以从数据库中删除它，并基本上为我编写以下文件：

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, ForeignKey

Base = declarative_base()

class User(Base):
   __tablename__ = 'user'

   id = Column(Integer, primary_key=True)
   first_name = Column(String)
   last_name = Column(String)
   email = Column(String)

谢谢

原文

I have a database with nearly 100 tables. I am trying to use alembic to manage it in python. Is there a way for alembic to build the ORM python files for me or do I have to write them myself.

For example in the database there is a user table with columns id, first_name, last_name, email is there a way alembic can pull this from the database and basically write the following file for me:

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, ForeignKey

Base = declarative_base()

class User(Base):
   __tablename__ = 'user'

   id = Column(Integer, primary_key=True)
   first_name = Column(String)
   last_name = Column(String)
   email = Column(String)

Thanks

分享到QQ

分享到微博