diff options
| -rw-r--r-- | scripts/elvia.py | 2 | ||||
| -rw-r--r-- | scripts/elvia_gridtariff.py | 2 | ||||
| -rw-r--r-- | scripts/nb.py | 2 | ||||
| -rw-r--r-- | scripts/neohub.py | 2 | ||||
| -rw-r--r-- | scripts/tibber_consumption.py | 2 | ||||
| -rw-r--r-- | scripts/tibber_prices.py | 2 | ||||
| -rw-r--r-- | scripts/yr.py | 2 |
7 files changed, 7 insertions, 7 deletions
diff --git a/scripts/elvia.py b/scripts/elvia.py index 61bc692..e1ea6de 100644 --- a/scripts/elvia.py +++ b/scripts/elvia.py @@ -57,7 +57,7 @@ for item in data['meteringpoints'][0]['metervalue']['timeSeries']: # SQL -sql = """ INSERT INTO elvia +sql = """INSERT INTO elvia VALUES(%s, %s, %s, %s, %s, %s) ON CONFLICT (startTime,endTime) DO NOTHING;""" diff --git a/scripts/elvia_gridtariff.py b/scripts/elvia_gridtariff.py index 2e398b3..f6b64f9 100644 --- a/scripts/elvia_gridtariff.py +++ b/scripts/elvia_gridtariff.py @@ -69,7 +69,7 @@ for item in data['gridTariffCollections'][0]['gridTariff']['tariffPrice']['hours item['energyPrice']['totalExVat'])) # SQL -sql = """ INSERT INTO elvia_gridtariff +sql = """INSERT INTO elvia_gridtariff VALUES(%s, %s, %s, %s, %s, %s, %s) ON CONFLICT (meteringPointId,startTime,endTime) DO NOTHING""" diff --git a/scripts/nb.py b/scripts/nb.py index 88d40c5..db65cf7 100644 --- a/scripts/nb.py +++ b/scripts/nb.py @@ -60,7 +60,7 @@ with open(temp.name, encoding="utf-8") as csvfile: temp.close() # SQL -sql = """ INSERT INTO nbex +sql = """INSERT INTO nbex VALUES(%s, %s, %s, %s) ON CONFLICT (startdate,base_cur,quote_cur) DO NOTHING""" diff --git a/scripts/neohub.py b/scripts/neohub.py index 9ee471e..e5c1b16 100644 --- a/scripts/neohub.py +++ b/scripts/neohub.py @@ -32,7 +32,7 @@ async def run(): device.target_temperature, device.temperature) - sql = """ INSERT INTO neohub + sql = """INSERT INTO neohub (timestamp, time, device_id, diff --git a/scripts/tibber_consumption.py b/scripts/tibber_consumption.py index 3df48fe..01732d0 100644 --- a/scripts/tibber_consumption.py +++ b/scripts/tibber_consumption.py @@ -77,7 +77,7 @@ for item in data["data"]["viewer"]["homes"][0]["consumption"]["nodes"]: item["unitPriceVAT"])) # SQL -sql = """ INSERT INTO tibber_consumption +sql = """INSERT INTO tibber_consumption VALUES(%s, %s, %s, %s, %s, %s, %s) ON CONFLICT (startTime,endTime) DO NOTHING""" diff --git a/scripts/tibber_prices.py b/scripts/tibber_prices.py index 05db9a5..809a74c 100644 --- a/scripts/tibber_prices.py +++ b/scripts/tibber_prices.py @@ -79,7 +79,7 @@ for item in data["data"]["viewer"]["homes"][0]["currentSubscription"]["priceInfo item["level"])) # SQL -sql = """ INSERT INTO tibber_prices +sql = """INSERT INTO tibber_prices VALUES(%s, %s, %s, %s, %s) ON CONFLICT (startsat) DO NOTHING""", diff --git a/scripts/yr.py b/scripts/yr.py index 243f531..9ec04d7 100644 --- a/scripts/yr.py +++ b/scripts/yr.py @@ -52,7 +52,7 @@ for item in data["properties"]["timeseries"]: details["wind_speed"])) # SQL -sql = """ INSERT INTO yr ( +sql = """INSERT INTO yr ( time, location, air_temperature, |