flask-sqlalchemy基本操作数据库
# -*- coding: utf-8 -*- from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import Column,Integer,String,Text,ForeignKey,DateTime,UniqueConstraint,Index from sqlalchemy import create_engine from flask import Blueprint,render_template,redirect,session login = Blueprint("login",__name__) Base = declarative_base() class Users(Base): __tablename__ = "users" id = Column(Integer,primary_key=Text,autoincrement=True) name = Column(String(32),index=True,nullable=False) def init_db(): engine = create_engine( "mysql+pymysql://root:123456@127.0.0.1:3306/flask?charset=utf8", max_overflow = 0, pool_size = 5, pool_timeout = 30, pool_recycle = -1 ) Base.metadata.create_all(engine) def drop_db(): engine = create_engine( "mysql+pymysql://root:123456@127.0.0.1:3306/flask?charset=utf8", max_overflow = 0, pool_size = 5, pool_timeout = 30, pool_recycle = -1 ) Base.metadata.drop_all(engine) if __name__ == '__main__': # init_db() drop_db() @login.route("/login") def login_s(): session["user"] = "张大爷" return render_template("login.html")
本文来自博客园,作者:一石数字欠我15w!!!,转载请注明原文链接:https://www.cnblogs.com/52-qq/p/8270431.html