• 基于flask写的一个小商城mall项目

    1.项目实现功能

    项目主要是分为用户、管理员两个角色，分别对两个角色的功能进行展示

     2.项目技术

          项目主要是后端开发，利用flask框架进行开发、数据库采用mysql；其中运用蓝图blueprint、装饰器进行权限控制等

    3.项目实现

    （1）整体项目结构

     (2)先列一下整体都需要的

    ① utils：

    1. import hashlib
    2. import time
    3. import simplejson as json
    4.  
    5.  
    6. def result(code=200, d={},message=''):
    7.     data = dict()  # object.__dict__
    8.     data['code'] = code
    9.     data['data'] = d
    10.     data['message']=message
    11.     return json.dumps(data, ensure_ascii=False)
    12.  
    13.  
    14. def md5(m):
    15.     return hashlib.md5(m.encode()).hexdigest()
    16.  
    17.  
    18. def getNowDataTime():
    19.     return time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
    20.  
    21.  
    22. def getTimeStamp():
    23.     return time.time()
    24.  
    25.  
    26. def getOrderNum():
    27.     orderNum = str(getTimeStamp()).replace('.', '')
    28.     return orderNum

    ②连接数据库的配置信息

    1. # true表示返回的json文件中中文字符用ascii码表示
    2. JSON_AS_ASCII = False
    3. # 数据库的配置变量
    4. class MySQLConfig(object):
    5.     HOSTNAME = '127.0.0.1'
    6.     PORT = '3306'
    7.     DATABASE = 'mall'
    8.     USERNAME = 'root'
    9.     PASSWORD = ''
    10.     DB_URI = 'mysql+pymysql://{}:{}@{}:{}/{}'.format(USERNAME, PASSWORD, HOSTNAME, PORT, DATABASE)
    11.     SQLALCHEMY_DATABASE_URI = DB_URI
    12.     # 关闭数据库修改跟踪操作[提高性能]，可以设置为True，这样可以跟踪操作：
    13.     SQLALCHEMY_TRACK_MODIFICATIONS = False
    14.  
    15.     # 开启输出底层执行的sql语句
    16.     SQLALCHEMY_ECHO = True
    17.  
    18.     # session
    19.     SECRET_KEY = "123"

    ③全局变量

    1. from flask_sqlalchemy import SQLAlchemy
    2.  
    3. db = SQLAlchemy()

    ④数据库表

    1. from exts import db
    2.  
    3.  
    4. class User(db.Model):
    5.     __tablename__ = "user"
    6.     __table_args__ = {'mysql_collate': 'utf8_general_ci'}
    7.  
    8.     _id = db.Column(db.Integer, primary_key=True)
    9.     name = db.Column(db.String(30))
    10.     username = db.Column(db.String(11), unique=True)
    11.     password = db.Column(db.String(64))
    12.     avatar = db.Column(db.String(256))
    13.     age = db.Column(db.Integer)
    14.     idCard = db.Column(db.String(18))
    15.     gneder = db.Column(db.String(2))
    16.     createTime = db.Column(db.DateTime)
    17.     loginTime = db.Column(db.DateTime)
    18.     logoutTime = db.Column(db.DateTime)
    19.     balance = db.Column(db.Float(10), default=0)
    20.     vip = db.Column(db.Integer, db.ForeignKey("vip._id"))
    21.  
    22.     def __repr__(self):
    23.         return "User:%s" % self.name
    24.  
    25.  
    26. goodsCourt = db.Table("goodsCourt",
    27.                       db.Column("goods_id", db.Integer, db.ForeignKey("goods._id")),
    28.                       db.Column("court_id", db.Integer, db.ForeignKey("court._id"))
    29.                       )
    30.  
    31.  
    32. class Court(db.Model):
    33.     __tablename__ = "court"
    34.     __table_args__ = {'mysql_collate': 'utf8_general_ci'}
    35.     _id = db.Column(db.Integer, primary_key=True)
    36.     user_id = db.Column(db.Integer, db.ForeignKey('user._id'))
    37.     number = db.Column(db.Integer, default=0)  # 记录商品种类
    38.     goods = db.relationship("Goods", secondary=goodsCourt, backref=db.backref("court", lazy="dynamic"), lazy="dynamic")
    39.  
    40.  
    41. class Address(db.Model):
    42.     __tablename__ = "address"
    43.     __table_args__ = {'mysql_collate': 'utf8_general_ci'}
    44.     _id = db.Column(db.Integer, primary_key=True)
    45.     province = db.Column(db.String(18))
    46.     town = db.Column(db.String(18))
    47.     county = db.Column(db.String(18))
    48.     detail = db.Column(db.String(200))
    49.     user_id = db.Column(db.Integer, db.ForeignKey("user._id"))
    50.  
    51.     def __repr__(self):
    52.         return "Address:%s" % self.detail
    53.  
    54.  
    55. class Vip(db.Model):
    56.     __tablename__ = "vip"
    57.     __table_args__ = {'mysql_collate': 'utf8_general_ci'}
    58.     _id = db.Column(db.Integer, primary_key=True)
    59.     name = db.Column(db.String(50))
    60.     level = db.Column(db.Integer, default=0)
    61.  
    62.     def __repr__(self):
    63.         return "Vip:%s" % self.name
    64.  
    65.  
    66. class Ad(db.Model):
    67.     __tablename__ = "ad"
    68.     __table_args__ = {'mysql_collate': 'utf8_general_ci'}
    69.     _id = db.Column(db.Integer, primary_key=True)
    70.     content = db.Column(db.String(50))
    71.     createTime = db.Column(db.DateTime)
    72.     displayTime = db.Column(db.DateTime)
    73.     endTime = db.Column(db.DateTime)
    74.     image = db.Column(db.String(256))
    75.     video = db.Column(db.String(256))
    76.     title = db.Column(db.String(100))
    77.     intro = db.Column(db.String(500))
    78.  
    79.     def __repr__(self):
    80.         return "Ad:%s" % self.content
    81.  
    82.  
    83. class Admin(db.Model):
    84.     __tablename__ = "admin"
    85.     __table_args__ = {'mysql_collate': 'utf8_general_ci'}
    86.     _id = db.Column(db.Integer, primary_key=True)
    87.     name = db.Column(db.String(30))
    88.     account = db.Column(db.String(11))
    89.     password = db.Column(db.String(64))
    90.     createTime = db.Column(db.DateTime)
    91.     loginTime = db.Column(db.DateTime)
    92.     logoutTime = db.Column(db.DateTime)
    93.     level = db.Column(db.Integer, default=0)
    94.  
    95.     def __repr__(self):
    96.         return "Admin:%s" % self.name
    97.  
    98.  
    99. class GoodsType(db.Model):
    100.     __tablename__ = "goodsType"
    101.     __table_args__ = {'mysql_collate': 'utf8_general_ci'}
    102.     _id = db.Column(db.Integer, primary_key=True)
    103.     name = db.Column(db.String(50))
    104.     number = db.Column(db.Integer, default=0)
    105.  
    106.     def __repr__(self):
    107.         return "GoodsType:%s" % self.name
    108.  
    109.  
    110. class Goods(db.Model):
    111.     __tablename__ = "goods"
    112.     __table_args__ = {'mysql_collate': 'utf8_general_ci'}
    113.     _id = db.Column(db.Integer, primary_key=True)
    114.     name = db.Column(db.String(100))
    115.     goodsType_id = db.Column(db.Integer, db.ForeignKey("goodsType._id"))
    116.     originPrice = db.Column(db.Float(10))
    117.     sellPrice = db.Column(db.Float(10))
    118.     contains = db.Column(db.Integer, default=0)
    119.     produceTime = db.Column(db.DateTime)
    120.     expireTime = db.Column(db.DateTime)
    121.     createTime = db.Column(db.DateTime)
    122.     image = db.Column(db.String(256))
    123.     createAddress_id = db.Column(db.Integer, db.ForeignKey("address._id"))
    124.     sendAddress_id = db.Column(db.Integer, db.ForeignKey("address._id"))
    125.     intro = db.Column(db.String(500))
    126.     lookTimes = db.Column(db.Integer, default=0)
    127.     buyTimes = db.Column(db.Integer, default=0)
    128.     likeTimes = db.Column(db.Integer, default=0)
    129.  
    130.     def __repr__(self):
    131.         return "Goods:%s" % self.name
    132.  
    133.  
    134. class VipReceipt(db.Model):
    135.     __tablename__ = "vip_receipt"
    136.     __table_args__ = {'mysql_collate': 'utf8_general_ci'}
    137.     _id = db.Column(db.Integer, primary_key=True)
    138.     orderNum = db.Column(db.String(30))
    139.     createTime = db.Column(db.DateTime)
    140.     payValue = db.Column(db.Float(10))
    141.     cutoffValue = db.Column(db.Float(10))
    142.     user_id = db.Column(db.Integer, db.ForeignKey("user._id"))
    143.     vipId = db.Column(db.Integer)
    144.  
    145.     def __repr__(self):
    146.         return "VipReceipt:%s" % self.orderNum
    147.  
    148.  
    149. class ReceiptItem(db.Model):
    150.     __tablename__ = "receipt_item"
    151.     __table_args__ = {'mysql_collate': 'utf8_general_ci'}
    152.     _id = db.Column(db.Integer, primary_key=True)
    153.     goodsId = db.Column(db.Integer)
    154.     number = db.Column(db.Integer, default=0)
    155.  
    156.  
    157. class Receipt(db.Model):
    158.     __tablename__ = "receipt"
    159.     __table_args__ = {'mysql_collate': 'utf8_general_ci'}
    160.     _id = db.Column(db.Integer, primary_key=True)
    161.     orderNum = db.Column(db.String(30))
    162.     createTime = db.Column(db.DateTime)
    163.     payValue = db.Column(db.Float(10))
    164.     cutoffValue = db.Column(db.Float(10))
    165.     user_id = db.Column(db.Integer, db.ForeignKey("user._id"))
    166.     itemId = db.Column(db.String(100), default="[]")
    167.  
    168.     def get_goods_id_list(self):
    169.         idStrList = self.itemId[1:-1].split(',')
    170.         idList = []
    171.         for item in idStrList:
    172.             idList.append(int(item))
    173.         return idList
    174.  
    175.     def __repr__(self):
    176.         return "Receipt:%s" % self.orderNum
    177.  
    178.  
    179. class Comment(db.Model):
    180.     __tablename__ = "comment"
    181.     __table_args__ = {'mysql_collate': 'utf8_general_ci'}
    182.     _id = db.Column(db.Integer, primary_key=True)
    183.     createTime = db.Column(db.DateTime)
    184.     content = db.Column(db.String(500))
    185.     points = db.Column(db.Integer, default=5)
    186.     screenCut = db.Column(db.String(256))
    187.     user = db.Column(db.Integer, db.ForeignKey("user._id"))
    188.     good = db.Column(db.Integer, db.ForeignKey("goods._id"))
    189.  
    190.     def __repr__(self):
    191.         return "Comment:%s" % self.content

    （3）登录登出

     

    1. from datetime import datetime
    2.  
    3. from flask import Flask, request, jsonify, session
    4. from flask_migrate import Migrate
    5.  
    6. from blueprints.admin import bp as admin_bp
    7. from blueprints.user import bp as user_bp
    8. from blueprints.mall import bp as mall_bp
    9. from blueprints.visitor import bp as visitor_bp
    10. import config
    11. from config import *
    12. from exts import db
    13. from blueprints.forms import LoginForm
    14. from models import Admin, User
    15.  
    16. app = Flask(__name__)
    17.  
    18. # 组装蓝图 将book、course、user模块都组装在main.py中
    19. app.register_blueprint(admin_bp)
    20. app.register_blueprint(user_bp)
    21. app.register_blueprint(mall_bp)
    22. app.register_blueprint(visitor_bp)
    23. # 配置项
    24. app.config.from_object(MySQLConfig)
    25.  
    26. db.init_app(app)
    27. db.app = app
    28.  
    29. # migrate = Migrate(app, db)
    30.  
    31.  
    32. # db.create_all()
    33.  
    34.  
    35. @app.route("/login", methods=['POST', 'GET'])
    36. def login():
    37.     """三个都有登录功能 所以直接在app.py中进行登录功能"""
    38.     if request.method == 'GET':
    39.         return "login.html"
    40.     else:
    41.         form = LoginForm(request.form)
    42.         if form.validate():
    43.             account = form.account.data
    44.             password_input = form.password.data
    45.             type = form.type.data
    46.             if type == 'admin':
    47.                 admin_model = Admin.query.filter_by(account=account).first()
    48.                 print("admin:", admin_model)
    49.                 if admin_model:
    50.                     if password_input == admin_model.password:
    51.                         session["_id"] = admin_model._id
    52.                         admin_model.loginTime = datetime.now()
    53.                         db.session.commit()
    54.                         print("登录成功")
    55.                         return jsonify({"code": 200, "message": " admin suceess"})
    56.                     else:
    57.                         print("密码错误")
    58.                         return jsonify({"code": 403, "message": "admin 密码错误"})
    59.                 else:
    60.                     print("不存在该admin")
    61.                     return jsonify({"code": 404, "message": "admin 不存在"})
    62.             else:
    63.                 user_model = User.query.filter_by(username=account).first()
    64.                 if user_model:
    65.                     if password_input == user_model.password:
    66.                         session["_id"] = user_model._id
    67.                         user_model.loginTime = datetime.now()
    68.                         db.session.commit()
    69.                         print("登录成功")
    70.                         return jsonify({"code": 200, "message": "user suceess"})
    71.                     else:
    72.                         print("密码错误")
    73.                         return jsonify({"code": 403, "message": "user 密码错误"})
    74.                 else:
    75.                     print("不存在该user")
    76.                     return jsonify({"code": 404, "message": "user 不存在"})
    77.         else:
    78.             print("请输入正确格式的账号或密码")
    79.             return jsonify({"code": 500, "message": "格式错误"})
    80.  
    81.  
    82. # 退出系统
    83. @app.route("/logout", methods=["POST"])
    84. def logout():
    85.     if request.method == "POST":
    86.         _id = session["_id"]
    87.         _type = request.form["type"]
    88.         if _type == "admin":
    89.             admin = Admin.query.get(_id)
    90.             admin.logoutTime = datetime.now()
    91.         else:
    92.             user = User.query.get(_id)
    93.             user.logoutTime = datetime.now()
    94.         del session["_id"]
    95.         return jsonify({"code": 200, "message": "退出登录成功"})
    96.  
    97.  
    98. @app.route('/')
    99. def hello_world():
    100.     return 'Hello World!'
    101.  
    102.  
    103. if __name__ == '__main__':
    104.     app.run(debug=True)

  • 相关阅读:
    0.泛型基础学习
    基于javaweb的智慧社区设计与实现
    动作捕捉系统用于室内组合定位技术研究
    算法通过村第十六关-滑动窗口|黄金笔记|结合堆的应用
    1151 LCA in a Binary Tree
    2023年09月 Python（一级）真题解析#中国电子学会#全国青少年软件编程等级考试
    虚拟摄像头之一: android8.1 移植 v4l2loopback 虚拟摄像头
    未来已来：探索5G技术如何改变我们的生活和工作
    Linux 系统安全及应用
    在Telegram营销后该如何进行客户管理
  • 原文地址：https://blog.csdn.net/m0_57098080/article/details/126021183