From 5ddd61b1656df80badd850da7fa0900eaa07331e Mon Sep 17 00:00:00 2001 From: dennis Date: Sun, 5 Feb 2023 20:19:33 +0100 Subject: remove starting space --- scripts/tibber_consumption.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'scripts/tibber_consumption.py') 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""" -- cgit v1.2.3