Python Column Examples

Example #1

class Backup(db.Model):
    __tablename__ = 'backups'
    id = db.Column(db.Integer, primary_key=True)
    time = db.Column(db.Integer)
    success = db.Column(db.Boolean)
    status = db.Column(db.String)

    def __init__(self, status, success=False):
        self.time = int(time.time())
        self.success = success
        self.status = status

Example #2

class LogMessage(db.Model):
    __tablename__ = 'logs'
    id = db.Column(db.Integer, primary_key=True)
    time = db.Column(db.Integer)
    level = db.Column(db.Integer)
    message = db.Column(db.String)

    def __init__(self, level, message):
        self.time = int(time.time())
        self.level = level
        self.message = message