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/elvia_gridtariff.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'scripts/elvia_gridtariff.py') 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""" -- cgit v1.2.3