in line 546
def calc_radiation_integral(self, timespan, db_manager):
"""calculate radiation integral over time
radiation: actual radiation in Watt per square meter
interval: registration interval as per database record in minutes
"""
try:
_result = db_manager.getSql(
"SELECT SUM(radiation*interval)/60.0, "
"MIN(usUnits), MAX(usUnits) FROM %s "
"WHERE dateTime >? AND dateTime<=?"
% db_manager.table_name, timespan)
is there a sql error
Mar 11 09:20:26 hesba weewx[16349] ERROR weewx.reportengine:
**** File "/home/weewx/bin/user/GTS.py", line 559, in
calc_radiation_integral
Mar 11 09:20:26 hesba weewx[16349] ERROR weewx.reportengine:
**** % db_manager.table_name, timespan)
Mar 11 09:20:26 hesba weewx[16349] ERROR weewx.reportengine:
**** File "/home/weewx/bin/weewx/manager.py", line 430, in getSql
Mar 11 09:20:26 hesba weewx[16349] ERROR weewx.reportengine:
**** _cursor.execute(sql, sqlargs)
Mar 11 09:20:26 hesba weewx[16349] ERROR weewx.reportengine:
**** File "/home/weewx/bin/weedb/mysql.py", line 61, in guarded_fn
Mar 11 09:20:26 hesba weewx[16349] ERROR weewx.reportengine:
**** raise klass(e)
Mar 11 09:20:26 hesba weewx[16349] ERROR weewx.reportengine: ****
weedb.DatabaseError: (1064, "You have an error in your SQL syntax; check
the manual that corresponds to your MariaDB server version for the right
syntax to use near ')/60.0, MIN(usUnits),MAX(usUnits) FROM archive WHERE
dateTime>1612825200 AND ...' at line 1")
Mar 11 09:20:26 hesba weewx[16349] ERROR weewx.reportengine: ****
Generator terminated
[email protected] schrieb am Mittwoch, 10. März 2021 um 20:39:50 UTC+1:
> The radiation observation type provides the actual sun power received at
> the time of measurement. The value depends on cloud coverage and the time
> of day.
>
> Besides that it is interesting to know which amount of energy was received
> from the sun during the day or any other period of time.
>
> To get that value some calculation has to be done. Unlike with rain that
> cannot be done by simply summarizing the observation readings. Energy is no
> cumulative value. Instead, it is necessary to integrate (in the
> mathematical meaning of that word) the radiation readings over the
> aggregation interval.
>
> I extended GTS extension <https://github.com/roe-dl/weewx-GTS> to do that.
>
> For example you can display the amount of sun energy received the day
> before by using the tag $yesterday.radiation.energy_integral. Plots are
> also possible.
>
> For examples showing these values see:
> sun radiation energy value <https://www.woellsdorf-wetter.de>
> sun radiation energy plot
> <https://www.woellsdorf-wetter.de/graphs/?graph=month#Sonnenenergie>
>
>
>
--
You received this message because you are subscribed to the Google Groups
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/353789f6-4fa8-4376-a362-8a38ea8722cen%40googlegroups.com.
