# -*- 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")