moving some variables around

1 files changed, 2 insertions, 7 deletions

diff --git a/scripts/tibber_prices.py b/scripts/tibber_prices.py
index a2e9dda..985a068 100644
--- a/scripts/tibber_prices.py
+++ b/scripts/tibber_prices.py
@@ -8,17 +8,13 @@ from datetime import timedelta
 from tzlocal import get_localzone
 import requests
 
-from common import dbi
+import common
 
 
 # variables
 apiKey = os.environ['el_tibber_token']
 apiUrl = "https://api.tibber.com/v1-beta/gql"
 
-pg_db = os.environ['el_pg_db']
-pg_host = os.environ['el_pg_host']
-pg_table = "tibber_prices"
-
 startTime = datetime.now(get_localzone()) - timedelta(days = 1)
 startTime = startTime.isoformat('T')
 
@@ -72,5 +68,4 @@ for item in data["data"]["viewer"]["homes"][0]["currentSubscription"]["priceInfo
 for item in data["data"]["viewer"]["homes"][0]["currentSubscription"]["priceInfo"]["tomorrow"]:
     prices.append((item["startsAt"],item["total"],item["energy"],item["tax"],item["level"]))
 
-
-dbi("INSERT INTO " + pg_table + " VALUES(%s,%s,%s,%s,%s) ON CONFLICT (startsat) DO NOTHING", prices, verbose=True)
+common.dbi(common.sql[common.name], prices, verbose=True)