diff options
| author | dennis <d@ennis.no> | 2023-02-05 20:19:33 +0100 |
|---|---|---|
| committer | dennis <d@ennis.no> | 2023-02-05 20:19:33 +0100 |
| commit | 5ddd61b1656df80badd850da7fa0900eaa07331e (patch) | |
| tree | 2a53686aac48e2e0e1254e32d470d264b6d2ba00 /scripts/elvia.py | |
| parent | adding location and rooms (diff) | |
| download | energyscripts-5ddd61b1656df80badd850da7fa0900eaa07331e.tar.gz | |
remove starting space
Diffstat (limited to 'scripts/elvia.py')
| -rw-r--r-- | scripts/elvia.py | 2 |
1 files changed, 1 insertions, 1 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;""" |