sqlalchemy建表时指定schema

sqlalchemy建表时指定模式（schema）```pythonfrom sqlalchemy import create_engine,MetaDatafrom sqlalchemy.ext.declarative import declarative_basefrom sqlalchemy import Column,String,Integerengine = create_engine

卡冈都亚

2182人浏览 · 2022-03-29 14:58:17

卡冈都亚 · 2022-03-29 14:58:17 发布

sqlalchemy建表时指定模式（schema）


from sqlalchemy import create_engine,MetaData
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column,String,Integer

engine = create_engine("postgres://user:pwd@192.168.1.12:5432/db")
metadata = MetaData(
    schema='other_schema',bind=engine
)
Base = declarative_base(metadata=metadata) #生成orm基类

class User(Base): #继承生成的orm基类
    __tablename__ = "sql_test" #表名

    id = Column(Integer,primary_key=True) #设置主键
    user_name = Column(String(32))
    user_password = Column(String(64))


if __name__ == '__main__':

    Base.metadata.create_all(engine)  # 创建表结构