Python ForeignKey示例

示例#1

class Mods(Item):
    id = db.Column(db.Integer, db.ForeignKey('item.id'), primary_key=True)
    capacity = db.Column(db.String)

    __mapper_args__ = {
        "polymorphic_identity": "mods",
    }

示例#2

class Armor(Item):
    id = db.Column(db.Integer, db.ForeignKey('item.id'), primary_key=True)
    armorrating = db.Column(db.String)

    __mapper_args__ = {
        "polymorphic_identity": "armor",
    }

示例#3

class FirearmAccessory(Item):
    id = db.Column(db.Integer, db.ForeignKey('item.id'), primary_key=True)
    mount = db.Column(db.String)

    __mapper_args__ = {
        "polymorphic_identity": "firearmaccessory",
    }

示例#4

class Cyberdeck(Item):
    id = db.Column(db.Integer, db.ForeignKey('item.id'), primary_key=True)
    attarray = db.Column(db.String)
    programs = db.Column(db.Integer)

    __mapper_args__ = {
        "polymorphic_identity": "cyberdeck",
    }

示例#5

class Ammo(Item):
    id = db.Column(db.Integer, db.ForeignKey('item.id'), primary_key=True)
    dmgmod = db.Column(db.String)
    apmod = db.Column(db.String)
    blast = db.Column(db.String)

    __mapper_args__ = {
        "polymorphic_identity": "ammo",
    }

示例#6

class MeleeWeapon(Item):
    id = db.Column(db.Integer, db.ForeignKey('item.id'), primary_key=True)
    ap = db.Column(db.String)
    accuracy = db.Column(db.String)
    damage = db.Column(db.String)
    reach = db.Column(db.Integer)

    __mapper_args__ = {
        "polymorphic_identity": "meleeweapon",
    }

示例#7

class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(100), nullable=False)
    date_posted = db.Column(db.DateTime,
                            nullable=False,
                            default=datetime.utcnow)
    content = db.Column(db.Text, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

    def __repr__(self):
        return f'Post("{self.title}", "{self.date_posted}")'

示例#8

class Firearm(Item):
    id = db.Column(db.Integer, db.ForeignKey('item.id'), primary_key=True)
    ap = db.Column(db.String)
    accuracy = db.Column(db.String)
    damage = db.Column(db.String)
    mode = db.Column(db.String)
    rc = db.Column(db.String)
    ammo = db.Column(db.String)

    __mapper_args__ = {
        "polymorphic_identity": "firearm",
    }