Python ForeignKey Examples

Example #1

class RecipeBookSteps(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    order = db.Column(db.Integer())
    temp = db.Column(db.Float())
    name = db.Column(db.String(80))
    timer = db.Column(db.Integer())
    type = db.Column(db.String(1))
    kettleid = db.Column(db.Integer())
    receipe_id = db.Column(db.Integer, db.ForeignKey('recipe_books.id'))

Example #2

File: model.py Project: beryll71/craftbeerpi

class RecipeBookSteps(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    order = db.Column(db.Integer())
    temp = db.Column(db.Float())
    name = db.Column(db.String(80))
    timer = db.Column(db.Integer())
    type = db.Column(db.String(1))
    kettleid = db.Column(db.Integer())
    receipe_id = db.Column(db.Integer, db.ForeignKey('recipe_books.id'))
    alarm = db.Column(db.String(1))

    def __repr__(self):
        return self.name

    def __unicode__(self):
        return self.name

Example #3

File: model.py Project: beryll71/craftbeerpi

class FermenterStep(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80))
    temp = db.Column(db.Float())
    hours = db.Column(db.Integer())
    minutes = db.Column(db.Integer())
    days = db.Column(db.Integer())
    temp = db.Column(db.Integer())
    order = db.Column(db.Integer(), default=999)
    state = db.Column(db.String(1))
    start = db.Column(db.DateTime())
    timer_start = db.Column(db.DateTime())
    end = db.Column(db.DateTime())
    fermenter_id = db.Column(db.Integer, db.ForeignKey('fermenter.id'))

    def __repr__(self):
        return self.name

    def __unicode__(self):
        return self.name