Automap sqlalchemy.ext.automap 自动映射数据库表结构

最新推荐文章于 2024-10-10 13:32:22 发布

转载最新推荐文章于 2024-10-10 13:32:22 发布 · 231 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/tensorflownews/p/7451878.html

文章标签：

#数据库

本文介绍了使用SQLAlchemy的自动映射功能从现有数据库表结构中动态生成ORM类的方法。通过示例展示了如何连接数据库、反射表结构以及操作数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

from sqlalchemy.ext.automap import automap_base
from sqlalchemy.orm import Session
from sqlalchemy import create_engine

Base = automap_base()

# engine, suppose it has two tables 'user' and 'address' set up
engine = create_engine("mysql+mysqldb://wise:wise@172.31.238.141/wise?charset=utf8")

# reflect the tables
Base.prepare(engine, reflect=True)

# mapped classes are now created with names by default
# matching that of the table name.
User = Base.classes.user
Address = Base.classes.address


session = Session(engine)

# rudimentary relationships are produced
#session.add(Address(email_address="foo@bar.com", user=User(name="foo")))
#session.commit()

# collection-based relationships are by default named
# "<classname>_collection"

http://www.buluo360.com/

转载于:https://www.cnblogs.com/tensorflownews/p/7451878.html