蓝图
#app.py
from apps import create_app
# app = Flask(__name__)
app = create_app()
if __name__ == '__main__':
print(app.url_map)
app.run()
#views下的__init__.py
from flask import Flask
from settings import Config
#settings里的内容
#class Config:
# DEBUG=True
from apps.views.user_view import user_bp
def create_app():
app=Flask(__name__)
#加载配置
app.config.from_object(Config)
app.config['SECRET_KEY']='123456'
app.config['PERMANENT_SESSION_LIFETIME']=7*24*60
#注册蓝图
app.register_blueprint(user_bp)
#app=Manager(app)
return app
#user_view.py
user_bp = Blueprint('user',__name__,url_prefix='/user')
@user_bp.route('/')
def user_index():
pass
sqlalchemy连数据库
# 导入:
from sqlalchemy import Column, String, create_engine, Integer
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Sequence
from contextlib import contextmanager
import pymysql
# 创建对象的基类:
Base = declarative_base()
# 定义User对象:
class User(Base):
# 表的名字:
__tablename__ = 'user'
# 表的结构:
id = Column(Integer, Sequence('user_id_seq'), primary_key=True)
name = Column(String(20))
psw = Column(String(20))
# 初始化数据库连接:
#DB_URI = "mysql+pymysql://{username}:{password}@{host}:{port}/{db}?charset=utf8".format(username=USERNAME,password=PASSWORD, host=HOST,port=PORT, db=DATABASE)
engine = create_engine('mysql+pymysql://root:123456@192.168.205.100:3306/flask?charset=utf8')
Base.metadata.create_all(engine) # 创建表结构
# 创建DBSession类型:
DBSession = sessionmaker(bind=engine)
#等效于这两个个语句
#__enter__: with语句中的代码块执行前, 会执行__enter__, 返回的值将赋值给with句中as后的变量.
#__exit__: with语句中的代码块执行结束或出错, 会执行_exit__
#with语句中的代码块执行前执行函数中yield之前代码
#yield返回的内容复制给as之后的变量
#with代码块执行完毕后执行函数中yield之后的代码
@contextmanager
def auto_commit():
session = DBSession()
try:
yield session
session.commit()
session.close()
except Exception as e:
session.rollback()
raise e
def add(name, psw):
#基本创建的语句
# # 创建session对象:
# session = DBSession()
# # 创建新User对象:
# new_user = User(name=name, psw=psw)
# # 添加到session:
# session.add(new_user)
# # 提交即保存到数据库:
# session.commit()
# # 关闭session:
# session.close()
#使用封装的函数
with auto_commit() as se:
new_user = User(name=name, psw=psw)
# 添加到session:
se.add(new_user)
# 提交即保存到数据库:
def compare(name, psw):
# 创建session对象:
session = DBSession()
for n, p in session.query(User.name, User.psw):
if name == n and psw == p:
return True
return False
# for instance in session.query(User):
cookie和session例子
https://www.cnblogs.com/wangjintao-0623/p/9598827.html
或者官方文档