tornado web mysql_Tornado Web 开发 框架搭建 (4)

数据库设置

使用 mysqlconnector，python3 环境下比较好用的mysql连接库

DB_CONNECT_STRING = 'mysql+mysqlconnector://root:@localhost/demo?charset=utf8'

from sqlalchemy import create_engine

from sqlalchemy.orm import scoped_session, sessionmaker

from sqlalchemy.ext.declarative import declarative_base

engine = create_engine(DB_CONNECT_STRING)

db_session = scoped_session(sessionmaker(autocommit=False,

autoflush=False,

bind=engine))

Base = declarative_base(metadata=MetaData(), metaclass=DeclarativeMeta)

Base.query = db_session.query_property() 这样 Base 可以作为 sqlalchemy的 Model 的 基类使用

class User(Base):

__tablename__ = 'user_tab'

id = Column(Integer, primary_key=True)

name = Column(String(50), unique=True, index=True, nullable=False)

pwd