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