security_member_model.py 文件源码

def define_security_member_table():
    global security_member_table

    security_member_table = Table(
        'security_member',
        meta.metadata,
        Column(
               'id',
               types.Integer,
               primary_key=True,
               autoincrement=True), 
        Column(
               'member_id',
               types.UnicodeText,
               primary_key=True, 
               nullable=False),
        Column('user_id',
               types.UnicodeText,
               nullable=False),
        Column('group_id',
               types.UnicodeText,
               nullable=False),
        Column('state',
               types.UnicodeText,
               nullable=False),
        Column('dataset_type',
               types.UnicodeText,
               nullable=False),
        Column('classification',
               types.UnicodeText,
               nullable=False),
        ForeignKeyConstraint(
                ['member_id'],
                ['member.id'],
                onupdate="CASCADE", ondelete="CASCADE"
        ),
        UniqueConstraint('member_id', 
                         'user_id', 
                         'group_id',
                         'dataset_type',
                         name='uix_1')
    )

    meta.mapper(SecurityMember, security_member_table)