from utils.captcha.captcha import captcha
# 上传图片的配置
from flask_uploads import UploadSet, IMAGES, configure_uploads
import sys
import os
class Config(object):
"""工程配置信息"""
DEBUG = True
"""SQLAlchemy 配置"""
SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://root@127.0.0.1:3306/ceshi'
SQLALCHEMY_TRACK_MODIFICATIONS = False
SQLALCHEMY_COMMIT_ON_TEARDOWN = True # 数据库内容发生改变之后,自动提交 (不会及时提交,需要马上刷新的时候自己commit)
# 查询时会显示原始SQL语句
# SQLALCHEMY_ECHO = True
SECRET_KEY = '1810'
# 日志的级别
LEVEL = 'DEBUG'
app = Flask(__name__)
db = SQLAlchemy(app)
app.config.from_object(Config)
# 图片上传配置
fn = getattr(sys.modules['__main__'], '__file__')
# 保存图片的目录
root_path = os.path.abspath(os.path.dirname(fn)) + "/static/upload"
app.config['UPLOADED_PHOTO_DEST'] = root_path
app.config['UPLOADED_PHOTO_ALLOW'] = IMAGES
photos = UploadSet('PHOTO') # 操作图片的实例
configure_uploads(app, photos)
# 生成验证码图片
@app.route('/get_image')
def get_image():
# name, text, StringIO.value
# text : 验证码图片对应到到文本
# image_url : 验证码图片IO流。理解为:二进制数据,并没有实际转换成图片呢
name, text, image_url = captcha.generate_captcha()
session['img_code'] = text
response = make_response(image_url) # 生成图片到响应
# 告诉浏览器,我要返回到是一张图片
response.headers['Content-type'] = 'image/jpg'
return response
# 分页操作
@app.route('/', methods=['GET', 'POST'])
def index():
d = {}
page = request.args.get('page', 1)
products_list = Products.query.order_by(Products.id.desc()).paginate(int(page), 3, False)
# 数据
d = {}
d['info'] = products_list.items # 经过筛选的产品列表
d['current_page'] = products_list.page # 当前页
d['total_page'] = products_list.pages # 总页数
return render_template('index.html', data=d)
if __name__ == '__main__':
app.run()