Python DB.Column 예제들

예제 #1

파일: instance_data.py 프로젝트: altai/altai-api

class InstanceData(DB.Model):
    """Model for Altai-API specific extra instance data"""
    __tablename__ = 'instance_data'

    instance_id = DB.Column(DB.String(64), primary_key=True)
    expires_at = DB.Column(DB.DateTime)
    remind_at = DB.Column(DB.DateTime)

예제 #2

파일: tokens.py 프로젝트: altai/altai-api

class Token(DB.Model):
    __tablename__ = 'tokens'

    code = DB.Column(DB.String(32), primary_key=True)
    token_type = DB.Column(DB.String(32), nullable=False)
    email = DB.Column(DB.String(120), nullable=False)
    user_id = DB.Column(DB.String(64), nullable=False)
    complete = DB.Column(DB.Boolean, nullable=False, default=False)
    created_at = DB.Column(DB.DateTime,
                           nullable=False,
                           default=datetime.utcnow)
    complete_at = DB.Column(DB.DateTime, nullable=True, default=None)

예제 #3

파일: audit.py 프로젝트: altai/altai-api

class AuditRecord(DB.Model):
    __tablename__ = 'audit_records'

    record_id = DB.Column(DB.Integer, primary_key=True, autoincrement=True)

    resource = DB.Column(DB.String(1024), nullable=False)
    method = DB.Column(DB.String(16), nullable=False)
    response_status = DB.Column(DB.Integer, nullable=False)
    message = DB.Column(DB.String(16))

    resource_id = DB.Column(DB.String(1024))
    user_id = DB.Column(DB.String(64))
    project_id = DB.Column(DB.String(64))
    remote_address = DB.Column(DB.String(255))

    timestamp = DB.Column(DB.DateTime, nullable=False, default=datetime.utcnow)
    extra = DB.Column(Json(), nullable=False, default={})

예제 #4

class ConfigVar(DB.Model):
    __tablename__ = 'configuration'

    group = DB.Column(DB.String(1024), primary_key=True)
    name = DB.Column(DB.String(1024), primary_key=True)
    value = DB.Column(Json, nullable=False, default=None)