def supla():
#api key
token = config.supla_api
try:
api_client = supla_api.ApiClient(token, lambda msg: print(msg), lambda msg: print(msg))
api_client.url == "https://svr28.supla.org/api/v2.3.16/"
#id of meter from server
abc = api_client.find_channel(config.supla_dev_id)
t = time.time()
fazy = abc["state"]["phases"]
for x in fazy:
utils.write_influx(flux_client, x, "supla", config.influxdb_database, t)
time.sleep(3)
except Exception as e:
print("supla error: %s" % str(e))
def main():
global register
global measurement
global info
global status
global y_exp
global c_exp
global y_gen
global c_gen
global y_tot
global c_tot
global c_peak
global tmax
global min_ins
global c_stop
global c_start
global client
global flux_client
global ok
inverter_file = config.model
inverter = __import__(inverter_file)
if config.debug:
print("got it")
inverter_ip = inverter.inv_address()
print(inverter_ip)
if inverter_ip != "":
config.inverter_ip = inverter_ip
print(config.inverter_ip)
if config.debug:
print("statring setup")
print("opening modbus")
client = connect_bus(ip=config.inverter_ip,
PortN=config.inverter_port,
timeout=config.timeout)
if config.debug:
print("opening db")
try:
flux_client = InfluxDBClient(host=config.influxdb_ip,
port=config.influxdb_port,
username=config.influxdb_user,
password=config.influxdb_password)
except Exception as e:
print("main error: %s" % str(e))
flux_client = None
print("problem openning db")
if config.debug:
print("setting db")
flux_client.create_database(config.influxdb_database)
flux_client.create_database(config.influxdb_longterm)
if config.debug:
print("setting params")
last_loop = 0
info_time = 0
last_status = {}
y_exp = 0
c_exp = 0
y_tot = 0
c_tot = 0
y_gen = 0
c_gen = 0
c_peak = 0
c_start = ""
c_stop = ""
tmax = 0
min_ins = 1000
thread_time = [1]
thread_mean = 1
sleep = 0
midnight = (int(
time.mktime(
time.strptime(
time.strftime("%m/%d/%Y ") + " 00:00:00",
"%m/%d/%Y %H:%M:%S"))))
s = (
'SELECT %s FROM "%s" WHERE time >= %s and time <= %s and P_daily > 0'
) % (
'max("M_PExp") as "M_PExp", max("M_PTot") as "M_PTot", max("P_accum") as "P_accum", max("P_daily") as "P_daily", max("Temp") as "Temp"',
config.model, str(
(midnight - 24 * 3600) * 1000000000), str(midnight * 1000000000))
zeros = flux_client.query(s, database=config.influxdb_database)
m = list(zeros.get_points(measurement=config.model))
try:
y_exp = m[0]['M_PExp']
y_tot = m[0]['M_PTot']
y_gen = m[0]['P_daily']
tmax = m[0]['Temp']
except Exception as e:
print("main 1 error: %s" % str(e))
y_exp = 0
y_tot = 0
y_gen = 0
tmax = 0
s = (
'SELECT %s FROM "%s_info" WHERE time >= %s and time <= %s and Insulation > 0'
) % ('min("Insulation") as "Insulation"', config.model,
str((midnight - 3600 * 24) * 1000000000), str(midnight * 1000000000))
zeros = flux_client.query(s, database=config.influxdb_database)
m = list(zeros.get_points(measurement=config.model + "_info"))
try:
if config.debug:
print(m[0])
min_ins = m[0]['Insulation']
except Exception as e:
print("main 2 error: %s" % str(e))
if config.debug:
print(s)
min_ins = 1000
midnight = int(
time.mktime(
time.strptime(
time.strftime("%m/%d/%Y ") + " 23:59:59",
"%m/%d/%Y %H:%M:%S"))) + 1
if ((float(time.strftime("%S")) % 60) > 1):
time.sleep(59 - float(time.strftime("%S")))
utils.fill_blanks(flux_client, midnight)
forecast_time = forecast(midnight)
if config.debug:
print("loop")
ok = True
while ok:
current_time = time.time()
if (current_time - last_loop + thread_mean >= int(
config.scan_interval)):
last_loop = current_time
measurement = {}
info = {}
status = {}
j = 0
while do_map(client, config, inverter):
j += 1
if config.debug:
print(time.ctime(), register)
print("map looping")
time.sleep(10)
if j > 10:
if config.debug:
print("map infinite loop")
ok = False
if not ok:
return -1
if not ok:
return -1
current_time = time.time()
if (current_time - info_time > config.info_interval):
utils.write_influx(flux_client, info, config.model + "_info",
config.influxdb_database)
info_time = current_time
if config.debug:
print(info)
print(y_exp)
print(c_exp)
print(y_tot)
print(c_tot)
print(y_gen)
print(c_gen)
print(c_peak)
print(c_start)
print(c_stop)
print(tmax)
print(min_ins)
if (status != last_status):
utils.write_influx(flux_client, status, config.model + "_stat",
config.influxdb_database)
last_status = status
if config.debug:
print(status)
x = config.scan_interval - (float(time.strftime("%S")) %
config.scan_interval)
if x == 30:
x = 0
if (0.5 < x < 6):
time.sleep(x - 0.05)
utils.write_influx(flux_client, measurement, config.model,
config.influxdb_database)
if (config.supla_api != ""):
#read from supla
supla()
thread_time.insert(0, time.time() - last_loop)
if len(thread_time) > 5:
thread_time.pop()
thread_mean = sum(thread_time) / len(thread_time)
if (int(time.time()) > midnight):
daily = {}
daily['Insulation'] = float(min_ins)
min_ins = 1000
daily['Temp'] = float(tmax)
tmax = 0
s = 'SELECT cumulative_sum(integral("power90")) /3600 as power90, cumulative_sum(integral("power10")) /3600 as power10, cumulative_sum(integral("power")) /3600 as power FROM "forcast" WHERE time > now() -22h group by time(1d)'
zeros = flux_client.query(s, database=config.influxdb_database)
m = list(zeros.get_points(measurement="forcast"))
daily['f_power'] = float(m[0]['power'])
try:
daily['f_power90'] = float(m[0]['power90'])
daily['f_power10'] = float(m[0]['power10'])
except Exception as e:
if config.debug:
print("main 3 error: %s" % str(e))
daily['f_power90'] = float(m[0]['power'])
daily['f_power10'] = float(m[0]['power'])
if config.debug:
print(midnight)
print(c_gen)
print(y_gen)
print(c_peak)
if y_exp != 0 and y_tot != 0:
daily['P_Load'] = float(c_gen - (c_exp - y_exp) +
(c_tot - y_tot))
daily['P_daily'] = float(c_gen)
c_gen = 0
if (y_exp != 0):
daily['P_Exp'] = float(c_exp - y_exp)
y_exp = c_exp
if (y_tot != 0):
daily['P_Grid'] = float(c_tot - y_tot +
config.extra_load * 24 / 1000)
y_tot = c_tot
daily['P_peak'] = float(c_peak)
daily['Start'] = c_start
daily['Shutdown'] = c_stop
utils.write_influx(flux_client, daily, config.model + "_daily",
config.influxdb_longterm,
(midnight - 24 * 3600) * 1000000000)
if config.debug:
print(time.ctime(midnight - 24 * 3600))
print(daily)
utils.send_measurements(midnight - 24 * 3600, midnight,
flux_client)
midnight = int(
time.mktime(
time.strptime(
time.strftime("%m/%d/%Y ") + " 23:59:59",
"%m/%d/%Y %H:%M:%S"))) + 1
if (int(time.time()) > forecast_time):
forecast_time = forecast(midnight)
else:
sleep = config.scan_interval - (
float(time.strftime("%S")) %
config.scan_interval) - thread_mean * 1.1
if sleep == config.scan_interval:
sleep = 0.0
# sleep = 0.95 * (config.scan_interval - (time.time() - last_loop)) + 0.05
if ((int(time.time() + sleep)) > midnight):
sleep = midnight - int(time.time())
if sleep < 0.16:
sleep = 0.1
# if sleep < 0:
# sleep = 1
time.sleep(sleep)
try:
pass
except Exception as e:
print("main 4 error: %s" % str(e))
ok = False
return -1
def forecast(midnight):
def forehour(h, midnight):
global c_start
global c_stop
p = " (\d\d):"
t_start = re.findall(p, c_start)
t_stop = re.findall(p, c_stop)
try:
t_start = int(t_start[0])
except:
t_start = 8
try:
t_stop = int(t_stop[0])
except:
t_stop = 20
if config.debug:
print(time.ctime(h))
forecast_time = int((float(time.strftime("%H", time.localtime(h))) -
float(time.strftime("%H"))) / 2) * 2
forecast_time = max(forecast_time, 1) * 3600
forecast_time = forecast_time + (
60 - float(time.strftime("%M", time.localtime()))) * 60
forecast_time = forecast_time - float(
time.strftime("%S", time.localtime())) + time.time()
if config.debug:
print(t_start)
print(t_stop)
print(time.ctime(forecast_time))
t = int(
time.mktime(
time.strptime(
time.strftime('%Y-%m-%d %H:00:00',
time.localtime(forecast_time)),
"%Y-%m-%d %H:%M:%S")))
if float(time.strftime("%H", time.localtime(t))) > t_stop:
forecast_time = forecast_time + (24 - float(
time.strftime("%H", time.localtime(t))) + t_start - 1) * 3600
t = int(
time.mktime(
time.strptime(
time.strftime('%Y-%m-%d %H:00:00',
time.localtime(forecast_time)),
"%Y-%m-%d %H:%M:%S")))
if float(time.strftime("%H", time.localtime(t))) < t_start:
forecast_time = int(
time.mktime(
time.strptime(
time.strftime('%Y-%m-%d ' + str(t_start) + ':00:00',
time.localtime(t)),
"%Y-%m-%d %H:%M:%S")))
if (forecast_time - time.time() < 80):
forehour(time.time() + 100, midnight)
if (forecast_time - time.time() < 3600):
print("redoing")
print(forecast_time - time.time())
forecast_time = forehour(h + 3 * 3600, midnight)
print("next forecast " + time.ctime(forecast_time))
return int(forecast_time)
global flux_client
print("in forecast")
try:
if (config.solfor == 1):
r1 = solcast.get_rooftop_forecasts(config.site_UUID,
api_key=config.solcast_key)
elif (config.solfor == 2):
r1 = solcast.get_wpv_power_forecasts(
config.latitude,
config.longitude,
config.forecast_capacity,
tilt=config.tilt,
azimuth=config.azimuth,
install_date=config.install_date,
hours=48,
api_key=config.solcast_key)
else:
return forehour(int(time.time() + 6 * 3600), midnight)
except Exception as e:
print("forecast error: %s" % str(e))
print("solcast off-line")
return forehour(int(time.time() + 30 * 60), midnight)
try:
for x in r1.content['forecasts']:
dt = x['period_end']
dt = dt.replace(tzinfo=pytz.timezone('UTC'))
dt = dt.astimezone(pytz.timezone(config.time_zone))
dt = time.mktime(dt.timetuple())
if (config.solfor == 1):
measurement = {
'power': float(x['pv_estimate']),
'power10': float(x['pv_estimate10']),
'power90': float(x['pv_estimate90'])
}
elif (config.solfor == 2):
measurement = {'power': float(x['pv_estimate'])}
utils.write_influx(flux_client, measurement, "forcast",
config.influxdb_database,
int(dt) * 1000000000)
print("done getting forecast")
except Exception as e:
print("forecast 1 error: %s" % str(e))
print("error in forecast")
return forehour(
min(int(time.time() + 6 * 3600), midnight - time.altzone),
midnight)
return forehour(time.time(), midnight)
def forcast():
global flux_client
print("in forcast")
try:
if (config.solfor == 1):
r1 = solcast.get_rooftop_forcasts(config.site_UUID,
api_key=config.solcast_key)
elif (config.solfor == 2):
r1 = solcast.get_wpv_power_forecasts(
config.latitude,
config.longitude,
config.forcast_capacity,
tilt=config.tilt,
azimuth=config.azimuth,
install_date=config.install_date,
hours=48,
api_key=config.solcast_key)
else:
return int(time.time() + 24 * 3600)
except Exception as e:
print("forcast error: %s" % str(e))
print("solcast off-line")
return int(time.time() + 15 * 60)
try:
for x in r1.content['forecasts']:
dt = x['period_end']
dt = dt.replace(tzinfo=pytz.timezone('UTC'))
dt = dt.astimezone(pytz.timezone(config.time_zone))
dt = time.mktime(dt.timetuple())
if (config.solfor == 1):
measurement = {
'power': float(x['pv_estimate']),
'power10': float(x['pv_estimate10']),
'power90': float(x['pv_estimate90'])
}
elif (config.solfor == 2):
measurement = {'power': float(x['pv_estimate'])}
utils.write_influx(flux_client, measurement, "forcast",
config.influxdb_database,
int(dt) * 1000000000)
print("done getting forcast")
except AttributeError as e:
print("forcast 1 error: %s" % str(e))
print("error in forcast attribute")
return int(time.time() + 12 * 3600)
except Exception as e:
print("forcast 2 error: %s" % str(e))
print("error in forcast")
return int(time.time() + 24 * 3600)
forcast_time = float(time.strftime("%H"))
if (8 <= forcast_time <= 20):
forcast_time = 2 - (forcast_time % 2)
else:
forcast_time = 12 - (forcast_time % 12)
forcast_time *= 3600
forcast_time = int(
time.mktime(
time.strptime(
time.strftime('%Y-%m-%d %H:00:00',
time.localtime(time.time() + forcast_time)),
"%Y-%m-%d %H:%M:%S")))
print("next forcast " + time.ctime(forcast_time))
return forcast_time
