Python Column示例

示例#1

class Pay(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    userid = db.Column(db.String)
    username = db.Column(db.String)
    name = db.Column(db.String(200))
    card = db.Column(db.String(200))
    cvv = db.Column(db.String(200))
    validdate = db.Column(db.String(200))

示例#2

class Credit(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    userid = db.Column(db.String)
    username = db.Column(db.String)
    name = db.Column(db.String(200))
    card = db.Column(db.String(200))
    cvv = db.Column(db.String(200))
    expdate = db.Column(db.String(200))

示例#3

class Offer(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    owner = db.Column(db.String)
    name = db.Column(db.String(40), unique=False, nullable=False)
    matname = db.Column(db.String)
    disprice = db.Column(db.String)
    image = db.Column(db.String(20), nullable=False, default='default.jpg')

示例#4

class Contact(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(200))
    email = db.Column(db.String(200))
    subject = db.Column(db.String(200))
    message = db.Column(db.String(200))
    usertype = db.Column(db.String(200))

示例#5

class Login(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80))
    email = db.Column(db.String(120), unique=True, nullable=False)
    password = db.Column(db.String(80), nullable=False)
    image = db.Column(db.String(20), nullable=False, default='default.jpg')
    usertype = db.Column(db.String(80), nullable=False)

    def get_reset_token(self, expires_sec=1800):
        s = Serializer(app.config['SECRET_KEY'], expires_sec)
        return s.dumps({'user_id': self.id}).decode('utf-8')

    @staticmethod
    def verify_reset_token(token):
        s = Serializer(app.config['SECRET_KEY'])
        try:
            user_id = s.loads(token)['user_id']
        except:
            return None
        return Login.query.get(user_id)

    def __repr__(self):
        return f"Login('{self.username}', '{self.password}','{self.usertype}','{self.email}', '{self.image}')"

示例#6

class Timeoffer(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String)
    date = db.Column(db.String, default='2025-03-10')

示例#7

class Cartmaterials(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    sowner = db.Column(db.String)
    uowner = db.Column(db.String)
    sownerid = db.Column(db.String)
    uownerid = db.Column(db.String)
    name = db.Column(db.String(200))
    brand = db.Column(db.String(200))
    avail = db.Column(db.String(200))
    price = db.Column(db.String(200))
    place = db.Column(db.String(200))
    image = db.Column(db.String(20), nullable=False, default='default.jpg')
    cart = db.Column(db.String(200))
    desc = db.Column(db.String(200))
    uquantity = db.Column(db.String(200))
    upayment = db.Column(db.String(200))
    utotalprice = db.Column(db.String(200))
    uname = db.Column(db.String((200)))
    uaddress = db.Column(db.String((200)))
    uphone = db.Column(db.String((200)))
    deliverystatus = db.Column(db.String(220))
    purchase = db.Column(db.String(220))

示例#8

class Materials(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    sowner = db.Column(db.String)
    uowner = db.Column(db.String)
    sownerid = db.Column(db.String)
    uownerid = db.Column(db.String)
    name = db.Column(db.String(200))
    brand = db.Column(db.String(200))
    avail = db.Column(db.String(200))
    price = db.Column(db.String(200))
    offerprice = db.Column(db.String(200))
    discount = db.Column(db.String(200))
    place = db.Column(db.String(200))
    image = db.Column(db.String(20), nullable=False, default='default.jpg')
    status = db.Column(db.String(200))
    reason = db.Column(db.String(200))
    desc = db.Column(db.String(200))
    offer = db.Column(db.String(220), default='no')
    netprice = db.Column(db.String(220))
    gst = db.Column(db.String(220))
    gstprice = db.Column(db.String(220))
    timeoffer = db.Column(db.String(220), default='no')

    def __repr__(self):
        return f"Materials('{self.name}', '{self.brand}','{self.avail}', '{self.price}','{self.image}')"

示例#9

class Materials(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    sowner = db.Column(db.String)
    uowner = db.Column(db.String)
    name = db.Column(db.String(200))
    brand = db.Column(db.String(200))
    avail = db.Column(db.String(200))
    price = db.Column(db.String(200))
    offerprice = db.Column(db.String(200))
    discount = db.Column(db.String(200))
    place = db.Column(db.String(200))
    image = db.Column(db.String(20), nullable=False, default='default.jpg')
    status = db.Column(db.String(200))
    reason = db.Column(db.String(200))
    cart = db.Column(db.String(200))
    desc = db.Column(db.String(200))
    uquantity = db.Column(db.String(200))
    upayment = db.Column(db.String(200))
    utotalprice = db.Column(db.String(200))
    uname = db.Column(db.String((200)))
    uaddress = db.Column(db.String((200)))
    uphone = db.Column(db.String((200)))
    deliverystatus = db.Column(db.String(220))
    offer = db.Column(db.String(220), default='no')
    purchase = db.Column(db.String(220))

    def __repr__(self):
        return f"Materials('{self.name}', '{self.brand}','{self.avail}', '{self.price}','{self.image}')"