Python Column示例

示例#1

class UserModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    first_name = db.Column(db.Text)
    last_name = db.Column(db.Text)
    country = db.Column(db.Text, default=None)
    permissions = db.relationship('PermissionModel',
                                  secondary=perms,
                                  backref=db.backref('users'))

示例#2

文件： models.py 项目： oucb/scrapez

class DownloadModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.Text)
    url = db.Column(db.Text)
    path = db.Column(db.Text)
    size = db.Column(db.Integer)
    extra_data = db.Column(db.Text)

示例#3

class UserModel(db.Model):
    username = db.Column(db.Text, primary_key=True)
    first_name = db.Column(db.Text)
    last_name = db.Column(db.Text)
    country = db.Column(db.Text, default=None)

示例#4

class PermissionModel(db.Model):
    name = db.Column(db.Text, primary_key=True)

示例#5

from flask_flash.extensions import db, ma

perms = db.Table('perms',
    db.Column('user_model.first_name', db.Integer, db.ForeignKey('permission_model.name')),
    db.Column('permission_model.name', db.Integer, db.ForeignKey('user_model.first_name'))
)

class UserModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    first_name = db.Column(db.Text)
    last_name = db.Column(db.Text)
    country = db.Column(db.Text, default=None)
    permissions = db.relationship('PermissionModel', secondary=perms, backref=db.backref('users'))

class PermissionModel(db.Model):
    name = db.Column(db.Text, primary_key=True)

class PermissionSchema(ma.ModelSchema):
    class Meta:
        model = PermissionModel
    name = ma.Field(required=True)
    users = ma.List(ma.HyperlinkRelated('api.user', external=True))

class UserSchema(ma.ModelSchema):
    class Meta:
        model = UserModel
    first_name = ma.Field(required=True)
    last_name = ma.Field(required=True)
    permissions = ma.List(ma.HyperlinkRelated('api.permission', external=True))