hypercrypt / octopus-db

Importer for Octopus Energy API Data
5 stars 0 forks source link

div by zero warning #5

Closed NiccyB closed 1 year ago

NiccyB commented 1 year ago

Hi, I'm getting a

MariaDB [octopus]> show warnings;
+---------+------+---------------+
| Level   | Code | Message       |
+---------+------+---------------+
| Warning | 1365 | Division by 0 |
+---------+------+---------------+
1 row in set (0.000 sec)

warning when querying against billing_e_day. It turns out that one of the fixed tariffs which has loaded has created a record with zero kWh and null p/kWh figures.

image

hypercrypt commented 1 year ago

This is fixed in 0.0.3