Question

flask怎样查询mysql并显示在页面上

Answer 1

from sqlalchemy import create_enginefrom sqlalchemy.orm import sessionmakerfrom sqlalchemy.ext.declarative import declarative_base Base = declarative_base()class Database(object): def __init__(self, configure): self.configure = configure self.engine = create_engine(self.configure.MYSQL_SQLALCHEMY_URL) self.Session = sessionmaker(bind=self.engine) self.session = self.Session() from sqlalchemy import Column, Integer, String, Sequenceclass User(Base): """ user table """ __tablename__ = 'user' id = Column(Integer, Sequence("USER_ID_SEQ"), primary_key=True) username = Column(String(256), doc=u"用户名") password = Column(String(256), doc=u"密码") def __repr__(self): return "<User(username='%s', password='%s', id='%s')" % (self.username, self.password, self.id)