SQLAlchemy连接postgres

pip install sqlalchemy

from sqlalchemy import Column,String,create_engine
from sqlalchemy.types import CHAR,Integer,String,Text
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from sqlalchemy import func, desc, distinct, asc

Base = declarative_base()

class Catalog(Base):
    """
    目录结构
    """
    __tablename__ = "t_app_market_catalog"                 #关联的数据库中的表名

    id = Column("id", Integer, primary_key=True, nullable=False, autoincrement=True)        #类成员变量关联表字段
    catalog = Column('catalog', Text, nullable=False)					#类成员变量关联表字段

    def __init__(self, id=None,catalog=None):				#(可有可无,看需求)
        self.id = id
        self.catalog = catalog


# "postgresql://postgres:36o%Situation2018@192.168.232.188:52432/situation"
# '数据库类型://用户名:口令@机器地址:端口号/数据库名
engine = create_engine('postgresql://postgres:36o%Situation2018@192.168.232.188:52432/situation',echo=True)

DBsession = sessionmaker(bind=engine)
session = DBsession()
query = session.query(Catalog)
print(session.query(func.count(Catalog.id)).one()[0])