Hallo,
Supplement
The function to delete the values 'extraTemp1' and ' extraTemp2' does not
work.
if ans == 'y':
# we do so go ahead and clear them
for _rec in dbmanager_wx.genBatchRecords(start_ts - 1, stop_ts):
dbmanager_wx.updateValue(_rec['dateTime'], 'extraTemp1', None)
dbmanager_wx.updateValue(_rec['dateTime'], 'extraTemp2', None)
nrecs += 1
# all done, say so and give some stats
Hartmut
>
> It is missing a call 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
>>
>
