class SmartPlantDevice(db.Model):
mac = db.Column(db.String, primary_key=True)
isSmartPlant = db.Column(db.Boolean)
isConnected = db.Column(db.Boolean)
guid = db.Column(db.String, unique=True, nullable=False)
def __repr__(self):
return f"SmartPlantDevice('{self.mac}', sp: '{self.isSmartPlant}', connected: '{self.isConnected}', '{self.guid}')"
class MoistureModel(db.Model):
id = db.Column(db.Integer, primary_key=True)
guid = db.Column(db.String, nullable=False)
timestamp = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
moisture = db.Column(db.Integer)
def __repr__(self):
return f"MoistureModel('{self.guid}', '{self.timestamp}', '{self.moisture}')"
class LightingModel(db.Model):
id = db.Column(db.Integer, primary_key=True)
guid = db.Column(db.String, nullable=False)
timestamp = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
mode = db.Column(db.String(10), nullable=False)
state = db.Column(db.Boolean)
def __repr__(self):
return f"LightingModel('{self.guid}', '{self.timestamp}', '{self.mode}', '{self.state}')"
class PlantModel(db.Model):
puid = db.Column(db.String, primary_key=True)
guid = db.Column(db.String, nullable=False)
pid = db.Column(db.Integer, nullable=False)
timestamp = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
name = db.Column(db.String(30), unique=True, nullable=False)
description = db.Column(db.String(100))
def __repr__(self):
return f"PlantModel(guid: '{self.guid}', puid: '{self.puid}', pid: '{self.pid}', {self.timestamp}', {self.name}', '{self.description}')"