diff options
Diffstat (limited to 'scripts/elvia_gridtariff.py')
| -rw-r--r-- | scripts/elvia_gridtariff.py | 2 |
1 files changed, 1 insertions, 1 deletions
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""" |