图文混排
from flask import *
from flask_sqlalchemy import SQLAlchemy
import re
from captcha.captcha import captcha
app = Flask(name)
app.config[‘SQLALCHEMY_DATABASE_URI’] = ‘mysql+pymysql://root:@localhost/kaoshi’
db = SQLAlchemy(app)
app.secret_key=‘23dssdgf3t34’
用户表
class User(db.Model):
tablename = ‘user’
id = db.Column(db.Integer,primary_key=True)
name = db.Column(db.String(200))
tel = db.Column(db.String(20))
分类表
class Cate(db.Model):
tablename = ‘cate’
id = db.Column(db.Integer,primary_key=True)
name = db.Column(db.String(200))
good_list = db.relationship(‘Goods’,backref =‘cate’)
#商品表
class Goods(db.Model):
tablename = ‘goods’
id = db.Column(db.Integer,primary_key=True)
name = db.Column(db.String(200))
img_url = db.Column(db.String(500))
price = db.Column(db.DECIMAL(10,2),default=(9999999.99))
content = db.Column(db.TEXT)
c_id = db.Column(db.Integer,db.ForeignKey(‘cate.id’))
@app.route(’/’)
def Cate():
return render_template(‘shouye.html’)
@app.route(’/register’,methods =[‘GET’,‘POST’] )
注册
def register():
if request.method ==‘POST’:
#获取数据
user_name = request.form.get(‘user_name’)
pwd = request.form.get(‘pwd’)
tel = request.form.get(‘tel’)
image_code = request.form.get(‘image_code’)
if all([user_name,pwd,tel,image_code]):
if re.match(‘1[3-9]\d{9}’,tel):
if image_code.lower()==session.get(‘img_code’).lower():
u = User()
u.name = user_name
u.ped = pwd
u.tel = tel
db.session.add(u)
db.session.commit()
flash(‘注册成功’)
else:
flash(‘验证码不正确’)
else:
flash(‘手机号格式错误’)
else:
flash(‘信息不全’)
return render_template(‘zhuce.html’)
生成验证码
@app.route(’/get_image’)
def get_image():
name,text, image = captcha.generate_captcha()
# 保存验证码图片 内容(文本)
session[‘img_code’] = text
# 返回对象response,Content-Type固定写法
res = make_response(image)
res.headers[‘Content-Type’] = ‘image/jpg’
return res
if name == ‘main’:
# db.drop_all()
# db.create_all()
app.run(debug=True)
图文混排基本配置信息
from flask import *
from flask_uploads import UploadSet, IMAGES, configure_uploads
import sys
import os
app = Flask(name)
图片上传配置
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(’/’)
def index():
return render_template(‘index.html’)
@app.route(’/submit-image’, methods=[‘GET’, ‘POST’])
def submit_image():
# content = request.form.get(‘content’)
# 获取图片
img = request.files.get('file')
img_name = photos.save(img)
img_path = "/static/upload/" + img_name
mes = {}
mes['path'] = img_path # key为固定值,不可随意修改
mes['error'] = False # key为固定值,不可随意修改
return jsonify(mes)
if name == ‘main’:
app.run(debug=True)