-- encoding: utf-8 --
from flask import *
from flask_sqlalchemy import SQLAlchemy
导入captcha 用于生成验证码
from captcha.captcha import captcha
from flask_uploads import UploadSet, IMAGES, configure_uploads
import sys
import os
import re
app = Flask(name)
app.secret_key = ‘1812B1234567890’
app.config[‘SQLALCHEMY_DATABASE_URI’] = ‘mysql+pymysql://root:12345678@127.0.0.1:3306/KaoShi’
db = SQLAlchemy(app)
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’) # 用来保存图片的对象 photos.save()
configure_uploads(app, photos)
用户表
class User(db.Model):
tablename = ‘user’
id = db.Column(db.Integer, primary_key=True)
user_name = db.Column(db.String(200))
pwd = 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))
goods_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 i