The pe32sunspecpy_pub from wdoekes

pe32sunspecpy_pub's People

Contributors

Watchers

pe32sunspecpy_pub's Issues

bug with negative solar values

monitoring_db=# select * from power where value > 10000;
             time              | location_id |     value      
-------------------------------+-------------+----------------
 2022-02-09 20:00:00+01        |          16 |  4.4515825e+06
 2022-04-07 08:00:00+02        |          16 |  5.0971095e+06
 2022-04-11 23:00:00+02        |          16 |   5.124041e+06
 2022-04-13 23:00:00+02        |          16 |   5.212228e+06
 2022-05-23 00:00:00+02        |          16 |  6.0072465e+06
 2022-05-23 23:00:00+02        |          16 |   6.076068e+06
 2022-05-25 00:00:00+02        |          16 |   6.141218e+06
 2022-04-16 23:00:00+02        |          16 |  5.2588925e+06
 2022-04-20 22:46:12.276155+02 |          14 |  1.0664771e+08
 2022-04-20 22:46:12.276155+02 |          28 | 1.06648024e+08
 2022-04-29 22:54:00.303727+02 |          14 |  1.4729024e+08
 2022-04-29 22:54:00.303727+02 |          28 |  1.4729054e+08
 2022-05-01 23:02:25.353769+02 |          14 |   2.196628e+08
 2022-05-01 23:02:25.353769+02 |          28 |  2.1966534e+08
 2022-05-03 00:00:00+02        |          16 |   5.650945e+06
 2022-02-13 20:00:00+01        |          16 |  4.4572765e+06
 2022-02-15 06:00:00+01        |          16 |   4.492356e+06
 2022-06-27 23:47:50.118163+02 |          14 |  1.3305859e+08
 2022-06-27 23:47:50.118163+02 |          28 | 1.33058896e+08
(19 rows)

monitoring_db=# delete from power where value > 10000;
DELETE 19

monitoring_db=# select * from power where location_id = 14 order by value  limit 5;
             time              | location_id | value 
-------------------------------+-------------+-------
 2022-05-01 23:01:25.292098+02 |          14 | -2490
 2022-04-29 22:52:31.252198+02 |          14 |  -319
 2022-06-27 23:45:48.759922+02 |          14 |  -304
 2022-04-20 22:44:13.506633+02 |          14 |  -301
 2022-05-12 02:05:10.004392+02 |          14 |     0
(5 rows)

monitoring_db=# delete from power where value < 0 and location_id = 14;
DELETE 4

monitoring_db=# select * from location where id in (14,16,28);
 id |        name        
----+--------------------
 14 | PE32 solaredge
 16 | PE32 solaredge avg
 28 | PE32 power used
(3 rows)

Recommend Projects