pastebin.h0me.dk

Thermia Online API - fetch data

From Rasmus, 2 Years ago, written in Python, viewed 8 times.
URL https://pastebin.h0me.dk/view/fc5f752c Embed
Download Paste or View Raw
  1. from datetime import datetime, timedelta
  2. from ThermiaOnlineAPI import Thermia
  3. from credentials import USERNAME, PASSWORD
  4. import time
  5. import mysql.connector
  6.  
  7. config = {
  8.   'user': '<user>',
  9.   'password': '<pw>',
  10.   'host': '<host>',
  11.   'database': '<db>',
  12.   'raise_on_warnings': True
  13. }
  14.  
  15.  
  16.  
  17.  
  18. thermia = Thermia(USERNAME, PASSWORD, "genesis")
  19.  
  20. print("Connected: " + str(thermia.connected))
  21. print("\n")
  22.  
  23. while True:
  24.     # https://www.w3schools.com/python/python_try_except.asp
  25.     heat_pump = thermia.fetch_heat_pumps()[0]
  26.  
  27.     print ("**************************************")
  28.     print ("MY OWN STUFF")
  29.     print("heatingEffect: " + str(heat_pump.heat_temperature))
  30.     print("REG_OUTDOOR_TEMPERATURE: " + str(heat_pump.outdoor_temperature))
  31.     print("REG_SUPPLY_LINE: " + str(heat_pump.supply_line_temperature))
  32.     print("REG_OPER_DATA_RETURN: " + str(heat_pump.return_line_temperature))
  33.     print("REG_HOT_WATER_TEMPERATURE: " + str(heat_pump.hot_water_temperature))
  34.     print("REG_BRINE_IN: " + str(heat_pump.brine_in_temperature))
  35.     print("REG_BRINE_OUT: " + str(heat_pump.brine_out_temperature))
  36.     print("REG_DESIRED_SYS_SUPPLY_LINE_TEMP: " + str(heat_pump.desired_supply_line_temperature))
  37.    
  38.     cnx = mysql.connector.connect(**config)
  39.     cursor = cnx.cursor()
  40.  
  41.     # WHEN YOU KNOW SHIT ABOUT PYTHON AND IS LAZY AND DONT WANNA KNOW; THEN DO IT LIKE THIS LOLNEWBS ;D
  42.     query1 = ("INSERT INTO heatpump (id, name, value, lastModified, datetime, unixtimestamp) VALUES (NULL, 'heatingEffect', '" + str(heat_pump.heat_temperature) + "', 'N/A', CURRENT_TIME(), UNIX_TIMESTAMP())")
  43.     query2 = ("INSERT INTO heatpump (id, name, value, lastModified, datetime, unixtimestamp) VALUES (NULL, 'REG_OUTDOOR_TEMPERATURE', '" + str(heat_pump.outdoor_temperature) + "', 'N/A', CURRENT_TIME(), UNIX_TIMESTAMP())")
  44.     query3 = ("INSERT INTO heatpump (id, name, value, lastModified, datetime, unixtimestamp) VALUES (NULL, 'REG_SUPPLY_LINE', '" + str(heat_pump.supply_line_temperature) + "', 'N/A', CURRENT_TIME(), UNIX_TIMESTAMP())")
  45.     query4 = ("INSERT INTO heatpump (id, name, value, lastModified, datetime, unixtimestamp) VALUES (NULL, 'REG_OPER_DATA_RETURN', '" + str(heat_pump.return_line_temperature) + "', 'N/A', CURRENT_TIME(), UNIX_TIMESTAMP())")
  46.     query5 = ("INSERT INTO heatpump (id, name, value, lastModified, datetime, unixtimestamp) VALUES (NULL, 'REG_HOT_WATER_TEMPERATURE', '" + str(heat_pump.hot_water_temperature) + "', 'N/A', CURRENT_TIME(), UNIX_TIMESTAMP())")
  47.     query6 = ("INSERT INTO heatpump (id, name, value, lastModified, datetime, unixtimestamp) VALUES (NULL, 'REG_BRINE_IN', '" + str(heat_pump.brine_in_temperature) + "', 'N/A', CURRENT_TIME(), UNIX_TIMESTAMP())")
  48.     query7 = ("INSERT INTO heatpump (id, name, value, lastModified, datetime, unixtimestamp) VALUES (NULL, 'REG_BRINE_OUT', '" + str(heat_pump.brine_out_temperature) + "', 'N/A', CURRENT_TIME(), UNIX_TIMESTAMP())")
  49.     query8 = ("INSERT INTO heatpump (id, name, value, lastModified, datetime, unixtimestamp) VALUES (NULL, 'REG_DESIRED_SYS_SUPPLY_LINE_TEMP', '" + str(heat_pump.desired_supply_line_temperature) + "', 'N/A', CURRENT_TIME(), UNIX_TIMESTAMP())")
  50.    
  51.     # Denne er for heatingEffect, mangler et timestamp, go fetch
  52.     # $query = "INSERT INTO heatpump (id, name, value, lastModified, datetime, unixtimestamp) VALUES (NULL, 'heatingEffect', '$($currentStatusData.heatingEffect)', 'N/A', CURRENT_TIME(), UNIX_TIMESTAMP())"
  53.     cursor.execute(query1)
  54.     cursor.execute(query2)
  55.     cursor.execute(query3)
  56.     cursor.execute(query4)
  57.     cursor.execute(query5)
  58.     cursor.execute(query6)
  59.     cursor.execute(query7)
  60.     cursor.execute(query8)
  61.  
  62.     cnx.commit()
  63.    
  64.     cursor.close()
  65.     cnx.close()
  66.  
  67.     time.sleep(60.0)
  68.  
  69.  

Reply to "Thermia Online API - fetch data"

Here you can reply to the paste above

captcha
Powered by Stikked