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