class Electricity(SurrogatePK, Model):
__tablename__ = "electricity_data"
id = Column(db.Integer(), nullable=False, primary_key=True)
created_at = Column(db.Text(), nullable=False, default=dt.datetime.utcnow)
meter_180 = Column(db.Float(), nullable=True)
meter_280 = Column(db.Float(), nullable=True)
active_power = Column(db.Float(), nullable=True)
class Weather(SurrogatePK, Model):
__tablename__ = 'weather_data'
id = Column(db.Integer(), nullable=False, primary_key=True)
created_at = Column(db.Text(), nullable=False, default=dt.datetime.utcnow)
temp = Column(db.Float(), nullable=True)
pressure = Column(db.Integer(), nullable=True)
temp_min = Column(db.Float(), nullable=True)
temp_max = Column(db.Float(), nullable=True)
humidity = Column(db.Integer(), nullable=True)
wind_speed = Column(db.Float(), nullable=True)
wind_gust = Column(db.Float(), nullable=True)
wind_deg = Column(db.Integer(), nullable=True)
clouds = Column(db.Integer(), nullable=True)
rain = Column(db.Integer(), nullable=True)
snow = Column(db.Integer(), nullable=True)
weather_id = Column(db.Integer(), nullable=True)
class PVData(SurrogatePK, Model):
__tablename__ = 'pvdata'
id = Column(db.Integer(), nullable=False, primary_key=True)
created_at = Column(db.Text(), nullable=False, default=dt.datetime.utcnow)
dc_1_u = Column(db.Integer(), nullable=True)
dc_1_i = Column(db.Float(), nullable=True)
ac_1_u = Column(db.Integer(), nullable=True)
ac_1_p = Column(db.Integer(), nullable=True)
dc_2_u = Column(db.Integer(), nullable=True)
dc_2_i = Column(db.Float(), nullable=True)
ac_2_u = Column(db.Integer(), nullable=True)
ac_2_p = Column(db.Integer(), nullable=True)
dc_3_u = Column(db.Integer(), nullable=True)
dc_3_i = Column(db.Float(), nullable=True)
ac_3_u = Column(db.Integer(), nullable=True)
ac_3_p = Column(db.Integer(), nullable=True)
current_power = Column(db.Integer(), nullable=True)
daily_energy = Column(db.Float(), nullable=True)
total_energy = Column(db.Integer(), nullable=True)