class Transport(db.Model):
    __tablename__ = 'transport'
    number = db.Column(db.String(10), primary_key=True)
    type = db.Column(db.Integer)
    start = db.Column(db.String(10))
    end = db.Column(db.String(10))
    time = db.Column(db.Date)
Exemple #2
0
class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(30), unique=True, nullable=False)
    password = db.Column(db.String(60), nullable=False)
    favorite_countries = db.relationship("Favorite", backref="favorite_user", lazy=True) 
    def __repr__(self):
        return f"User('{self.username}')"
Exemple #3
0
class Favorite(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    slug = db.Column(db.String(20), nullable=False)
    watchlevel = db.Column(db.String(20), nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False)

    def __repr__(self):
        return f"Post('{self.slug}', '{self.watchlevel}', '{self.user_id}')"
Exemple #4
0
class Popflow(db.Model):
    __tablename__ = 'population_flow'
    popflow_ID = db.Column(db.String(50), default=gen_id, primary_key=True)
    people_province = db.Column(db.String(150))  #与用户管理子系统协商
    people_inflow = db.Column(db.Integer)
    people_outflow = db.Column(db.Integer)
    people_time = db.Column(db.DateTime,
                            default=datetime.datetime.now,
                            onupdate=datetime.datetime.now)
Exemple #5
0
class GoodsInfo(db.Model):
    __tablename__ = 'GoodsInfo'
    id = db.Column(db.String(32), default=gen_id, primary_key=True)
    Goodsname = db.Column(db.String(30))
    OrderLimit = db.Column(db.Integer, nullable=False)
    OrderLimitPerPerson = db.Column(db.Integer, nullable=False)
    DDL = db.Column(db.Date, nullable=False)

    def __repr__(self):
        return '<Goods %r>' % self.GoodsName
Exemple #6
0
class Comment(db.Model):
    __tablename__ = 'comment'
    comment_ID = db.Column(db.String(50), default=gen_id,
                           primary_key=True)  #这个是作为主键标记每一条记录的,用户用的是user_ID
    user_name = db.Column(db.String(50))
    info_ID = db.Column(db.String(50), db.ForeignKey('information.info_ID'))
    comment_text = db.Column(db.String(100))
    comment_time = db.Column(db.DateTime,
                             default=datetime.datetime.now,
                             onupdate=datetime.datetime.now)
Exemple #7
0
class WareHouse(db.Model):
    __tablename__ = 'WareHouse'
    Goodsname = db.Column(db.String(30),
                          primary_key=True,
                          nullable=False,
                          unique=True)
    number = db.Column(db.Integer, nullable=False, unique=False)
    usage = db.Column(db.String(50), nullable=False)

    def __repr__(self):
        return '<Goods %r>' % self.Goodsname
class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)  # User ID: primary key
    username = db.Column(db.String(30), unique=True,
                         nullable=False)  # username: UNIQUE, NOT NULL
    password = db.Column(
        db.String(60), nullable=False
    )  # password: NOT NULL, stored as a hashed password, not plaintext that the user inputs
    favorite_countries = db.relationship(
        "Favorite", backref="favorite_user", lazy=True
    )  # User has one-to-many relationship with Favorite: one(User) to many(Favorite)

    def __repr__(self):
        return f"User('{self.username}')"
class Favorite(db.Model):
    id = db.Column(db.Integer, primary_key=True)  # Favorite ID: primary key
    slug = db.Column(
        db.String(20), nullable=False
    )  # slug code for countries (e.g., united-kingdom, japan), NOT NULL
    watchlevel = db.Column(
        db.String(20),
        nullable=False)  # watchlevel of the country (priority for the user)
    user_id = db.Column(
        db.Integer, db.ForeignKey("user.id"), nullable=False
    )  # user_id of the user who has relation with the Favorite

    def __repr__(self):
        return f"Post('{self.slug}', '{self.watchlevel}', '{self.user_id}')"
Exemple #10
0
class Admin(UserMixin, db.Model):
    __tablename__ = 'admin'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(40), unique=True, nullable=False)
    pwd = db.Column(db.String(20), unique=False, nullable=False)
    email = db.Column(db.String(50), unique=True, index=True)
    province = db.Column(db.String(150), nullable=True)
    auth = db.Column(db.Integer, unique=True, nullable=True)
    system = db.Column(db.Integer, unique=True, nullable=False)

    def is_admin(self):
        '''检查是否为管理员'''
        return self.can(Permission.ADMINISTER)

    def get_id(self):
        return str(self.id)

    def verify_password(self, password):
        return check_password_hash(generate_password_hash(self.pwd), password)

    def is_authenticated(self):
        return True

    def is_active(self):
        return True

    def is_anonymous(self):
        return False
class USER(db.Model):
    __tablename__ = "users"
    identity_number = db.Column(db.String(30), primary_key=True)
    email = db.Column(db.String(30))
    address = db.Column(db.String(30))
    name = db.Column(db.String(20))
    phone_number = db.Column(db.String(11), unique=True)
    transport_number = db.Column(db.String(10),
                                 db.ForeignKey('transport.number'))
    transport = db.relationship('Transport', backref='User')
Exemple #12
0
class Information(db.Model):
    __tablename__ = 'information'
    info_ID = db.Column(db.String(50), default=gen_id, primary_key=True)
    info_province = db.Column(db.String(150))  #与用户管理子系统协商
    info_type = db.Column(db.Integer)
    info_title = db.Column(db.String(50))
    info_text = db.Column(db.String(1000))
    info_time = db.Column(db.DateTime,
                          default=datetime.datetime.now,
                          onupdate=datetime.datetime.now)
Exemple #13
0
class Complaint(db.Model):
    __tablename__ = 'Complaint'
    id = db.Column(db.String(20), default=gen_id, primary_key=True)
    Orderid = db.Column(db.String(32),
                        db.ForeignKey('OrderInfo.id'),
                        nullable=False)
    Goodsname = db.Column(db.String(30))
    Content = db.Column(db.Text, nullable=False)
    ComplaintReason = db.Column(db.Integer, nullable=False)  #0: 物流问题; 1: 物资问题
    ComplaintState = db.Column(db.Integer, nullable=False)  #0: 未处理; 1: 已处理

    def __repr__(self):
        return '<Complaint %r>' % self.id
Exemple #14
0
class Users(db.Model):
    __tablename__ = 'user'
    name = db.Column(db.String(40), nullable=False)
    pwd = db.Column(db.String(20), nullable=False)
    phone = db.Column(db.String(20), unique=True, index=True)
    email = db.Column(db.String(50), unique=True, index=True)
    idcard = db.Column(db.String(20),
                       unique=True,
                       index=True,
                       primary_key=True)
    address = db.Column(db.String(100), index=True)
    province = db.Column(db.String(10), index=True)
    username = db.Column(db.String(20), index=True)

    def __init__(self, name, pwd, phone, email, idcard, address, province,
                 username):
        self.name = name
        self.pwd = pwd
        self.phone = phone
        self.email = email
        self.idcard = idcard
        self.address = address
        self.province = province
        self.username = username

    def verify_password(self, password):
        return check_password_hash(generate_password_hash(self.pwd), password)

    def __repr__(self):
        return "%s/%s/%s/%s/%s/%s" % (self.name, self.pwd, self.phone,
                                      self.email, self.idcard, self.address)

    def is_authenticated(self):
        return True

    def is_active(self):
        return True

    def is_anonymous(self):
        return False
Exemple #15
0
class OrderInfo(db.Model):
    __tablename__ = 'OrderInfo'
    id = db.Column(db.String(32), default=gen_id, primary_key=True)
    userid = db.Column(
        db.String(19),
        db.ForeignKey('user.idcard'))  # The IDNumber of the applicant
    GoodsID = db.Column(db.String(32), db.ForeignKey('GoodsInfo.id'))
    Goodsname = db.Column(db.String(30))
    OrderNum = db.Column(db.Integer, nullable=False)
    idcards = db.Column(db.String(32), nullable=False)
    username = db.Column(db.String(30), nullable=False)
    address = db.Column(db.String(30), nullable=False)
    CreateTime = db.Column(db.Date, nullable=False)
    DeliveryTime = db.Column(db.Date, nullable=True)
    ReceiveTime = db.Column(db.Date, nullable=True)
    CancelTime = db.Column(db.Date, nullable=True)
    OrderState = db.Column(
        db.Integer, nullable=False)  # 0:等待抽签; 1:未发货; 2:已发货; 3:已送达; 4:已取消

    def __repr__(self):
        return '<Goods %r>' % self.id