【Flask】世界杯购票网站开发

效果图

模型设计

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(20))
    username = db.Column(db.String(20))  # 用户名
    password_hash = db.Column(db.String(128))  # 密码散列值
    activities = db.relationship('Activity', secondary='activity_user', backref='users', lazy='dynamic')

    def set_password(self, password):  # 用来设置密码的方法，接受密码作为参数
        self.password_hash = generate_password_hash(password)  # 将生成的密码保持到对应字段

    def validate_password(self, password):  # 用于验证密码的方法，接受密码作为参数
        return check_password_hash(self.password_hash, password)  # 返回布尔值


class Admin(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(20))
    username = db.Column(db.String(20))
    password_hash = db.Column(db.String(128))

    def set_password(self, password):
        self.password_hash = generate_password_hash(password)

    def validate_password(self, password):
        return check_password_hash(self.password_hash, password)


class Activity(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    activity_name = db.Column(db.String(64))
    activity_info = db.Column(db.String(512))
    price = db.Column(db.Integer)  # 票价
    limit = db.Column(db.Integer)  # 限制人数
    applied = db.Column(db.Integer, default=0)  # 购买已通过人数
    time = db.Column(db.DateTime)  # 举办时间
    deadline = db.Column(db.Date)  # 购买截止时间
    location = db.Column(db.String(64))  # 位置
    lon = db.Column(db.Float)  # 经度
    lat = db.Column(db.Float)  # 纬度


activity_user = db.Table('activity_user',
                         db.Column('activity_id', db.Integer, db.ForeignKey('activity.id'),primary_key=True),
                         db.Column('user_id', db.Integer, db.ForeignKey('user.id'),primary_key=True),
                         )