class RecipeBooks(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(80))
steps = db.relationship('RecipeBookSteps',
backref='RecipeBooks',
lazy='dynamic',
cascade="all, delete-orphan")
class Config2(db.Model):
name = db.Column(db.String(50), primary_key=True)
type = db.Column(db.String(50))
value = db.Column(db.String(255))
description = db.Column(db.String(255))
options = db.Column(db.String(255))
def __repr__(self):
return self.name
def __unicode__(self):
return self.name
class Hydrometer(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80))
tuning = db.Column(db.String(255))
def __repr__(self):
return self.name
def __unicode__(self):
return self.name
def decodeJson(self, json):
self.name = json.get("name")
class Hardware(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80))
type = db.Column(db.String(80))
config = db.Column(db.String(256))
def decodeJson(self, json):
self.name = json.get("name")
self.type = json.get("type")
#self.config = json.get("config")
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 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 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 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 Hardware(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80))
type = db.Column(db.String(80))
switch = db.Column(db.String(80))
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
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())
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
