It is missing a call which closes the function update (
dbmanager_wx.updateValue) and writes to the database
for example --> finally: _cursor.close()
Am Donnerstag, 9. März 2017 17:08:54 UTC+1 schrieb Hartmut Schweidler:
>
> Hallo Gary,
>
> You do not have to apologize for anything.
>
> I have already done this several times
>
> Right now runs the next attempt instead of outTemp1 with NULL I want to
> replace maxSolarRad with values.
> Simply
> # we do so go ahead and clear them
> for _rec in dbmanager_wx.genBatchRecords(start_ts - 1,
> stop_ts):
>
> msr = weewx.wxformulas.solar_rad_Bras(53.605963,
> 11.341407, 53, _rec['dateTime'], 2)
> dbmanager_wx.updateValue(_rec['dateTime'],
> 'maxSolarRad', msr)
>
> For security, I just leave the current values per print on the screen
> issue.
> In addition, weewx runs normally
> result: "cleared in 350828 records (approx 1225 days)" on screen
> weewx_copy_fill: record 350825 unter 128.238500608 tag
> weewx_copy_fill: record 350826 unter 117.421041055 tag
> weewx_copy_fill: record 350827 unter 106.746424888 tag
> an in database NULL, NULL, NULL ....
> the funktion from manager:
> def updateValue(self, timestamp, obs_type, new_value):
> """Update (replace) a single value in the database."""
>
> self.connection.execute("UPDATE %s SET %s=? WHERE dateTime=?" %
> (self.table_name, obs_type), (new_value,
> timestamp))
>
> Is called but nothing appears in the database
>
> Hartmut
>
