class Fermenter(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80))
brewname = db.Column(db.String(80))
sensorid = db.Column(db.Integer())
hydrometerid = db.Column(db.Integer())
heaterid = db.Column(db.Integer())
heateroffset_min = db.Column(db.Float())
heateroffset_max = db.Column(db.Float())
coolerid = db.Column(db.Integer())
cooleroffset_min = db.Column(db.Float())
cooleroffset_max = db.Column(db.Float())
fanid = db.Column(db.Integer())
target_temp = db.Column(db.Integer())
steps = db.relationship('FermenterStep',
backref='Fermenter',
lazy='joined',
cascade="all, delete-orphan",
order_by="FermenterStep.order")
def __repr__(self):
return self.name
def __unicode__(self):
return self.name
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'))
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
class Kettle(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80))
sensorid = db.Column(db.String(80))
sensoroffset = db.Column(db.Float())
heater = db.Column(db.String(10))
automatic = db.Column(db.String(255))
agitator = db.Column(db.String(10))
target_temp = db.Column(db.Integer())
height = db.Column(db.Integer())
diameter = db.Column(db.Integer())
def __repr__(self):
return '<Kettle %r>' % self.name
def __unicode__(self):
return self.id
class Step(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=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))
state = db.Column(db.String(1))
timer_start = db.Column(db.DateTime())
start = db.Column(db.DateTime())
end = db.Column(db.DateTime())
kettleid = db.Column(db.Integer())
def __repr__(self):
return '<Step %r>' % self.name
def __unicode__(self):
return self.id
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