ok, is there a command to add the db field? Il giorno lunedì 27 marzo 2017 00:41:08 UTC+2, Tom Keffer ha scritto: > > That's the nature of schema-based databases, such as sqlite or MySQL. You > give up flexibility in exchange for speed and efficiency. > > -tk > > On Sun, Mar 26, 2017 at 12:30 PM, Paolo Benvenuto <[email protected] > <javascript:>> wrote: > >> Yes, it stands. >> >> However: >> >> - I didn't create the columns for the other data which weewx inserts into >> the database, I'd expect that those data have their column in the database >> like the other data which have them >> - It seems that weewx receives that data from the wmr100 driver, why >> doesn't it create their database columns for all the data it receives from >> the driver? or at least weewx, if security suggest not to do it, the user >> to create the columns with a syslog message >> >> Il giorno sabato 25 marzo 2017 22:31:42 UTC+1, Tom Keffer ha scritto: >>> >>> Data for plots are taken from the database. So, unless there is a column >>> 'hourRain' in your schema, it cannot be used in a plot. It can only be >>> used in the $current tag. >>> >>> Stands to reason, if you think about it. >>> >>> -tk >>> >>> On Sat, Mar 25, 2017 at 12:30 PM, Paolo Benvenuto <[email protected]> >>> wrote: >>> >>>> My wmr100 driver outputs a hourRain field: >>>> >>>> {'UV': 'uv', 'outHumidity': 'humidity_1', 'inTempBatteryStatus': >>>> 'battery_status_0', 'rainBatteryStatus': 'battery_status_rain', >>>> 'extraTemp2': 'temperature_3', 'outTempBatteryStatus': >>>> 'battery_status_1', 'inTemp': 'temperature_0', 'hourRain': 'rain_hour', >>>> 'rain': 'rain', 'extraHumid6': 'humidity_7', 'pressure': 'pressure', >>>> 'extraHumid4': 'humidity_5', 'extraHumid5': 'humidity_6', 'extraHumid2' >>>> : 'humidity_3', 'extraHumid3': 'humidity_4', 'extraHumid1': >>>> 'humidity_2', 'extraTemp6': 'temperature_7', 'extraTemp7': >>>> 'temperature_8', 'extraTemp4': 'temperature_5', 'extraTemp5': >>>> 'temperature_6', 'rainRate': 'rain_rate', 'extraTemp3': 'temperature_4' >>>> , 'extraTemp1': 'temperature_2', 'extraHumid7': 'humidity_8', >>>> 'extraBatteryStatus2': 'battery_status_3', 'extraBatteryStatus3': >>>> 'battery_status_4', 'windBatteryStatus': 'battery_status_wind', >>>> 'extraBatteryStatus1': 'battery_status_2', 'extraBatteryStatus6': >>>> 'battery_status_7', 'extraBatteryStatus7': 'battery_status_8', >>>> 'extraBatteryStatus4': 'battery_status_5', 'extraBatteryStatus5': >>>> 'battery_status_6', 'windDir': 'wind_dir', 'outTemp': 'temperature_1', >>>> 'windSpeed': 'wind_speed', 'inHumidity': 'humidity_0', 'rain24': >>>> 'rain_24', 'windGust': 'wind_gust', 'uvBatteryStatus': >>>> 'battery_status_uv', 'rainTotal': 'rain_total'} >>>> >>>> So I put it in my skin: >>>> >>>> [[[dayrain]]] >>>> yscale = None, None, 0.02 >>>> plot_type = bar >>>> [[[[rain]]]] >>>> color = gray >>>> [[[[hourRain]]]] >>>> color = black >>>> >>>> >>>> >>>> However, I get this error: >>>> >>>> Mar 25 20:26:19 localhost weewx[31399]: reportengine: Caught >>>> unrecoverable exception in generator weewx.imagegenerator. >>>> ImageGenerator >>>> Mar 25 20:26:19 localhost weewx[31399]: **** no such column: >>>> hourRain >>>> Mar 25 20:26:19 localhost weewx[31399]: **** Traceback (most >>>> recent call last): >>>> Mar 25 20:26:19 localhost weewx[31399]: **** File >>>> "/usr/share/weewx.github.development/weewx/reportengine.py", line 239, >>>> in run >>>> Mar 25 20:26:19 localhost weewx[31399]: **** obj.start() >>>> Mar 25 20:26:19 localhost weewx[31399]: **** File >>>> "/usr/share/weewx.github.development/weewx/reportengine.py", line 273, >>>> in start >>>> Mar 25 20:26:19 localhost weewx[31399]: **** self.run() >>>> Mar 25 20:26:19 localhost weewx[31399]: **** File >>>> "/usr/share/weewx.github.development/weewx/imagegenerator.py", line 32, >>>> in run >>>> Mar 25 20:26:19 localhost weewx[31399]: **** self. >>>> genImages(self.gen_ts) >>>> Mar 25 20:26:19 localhost weewx[31399]: **** File >>>> "/usr/share/weewx.github.development/weewx/imagegenerator.py", line 145 >>>> , in genImages >>>> Mar 25 20:26:19 localhost weewx[31399]: **** >>>> aggregate_interval=aggregate_interval) >>>> Mar 25 20:26:19 localhost weewx[31399]: **** File >>>> "/usr/share/weewx.github.development/weewx/manager.py", line 511, in >>>> getSqlVectors >>>> Mar 25 20:26:19 localhost weewx[31399]: **** >>>> aggregate_type, aggregate_interval) >>>> Mar 25 20:26:19 localhost weewx[31399]: **** File >>>> "/usr/share/weewx.github.development/weewx/manager.py", line 757, in >>>> _getSqlVectors >>>> Mar 25 20:26:19 localhost weewx[31399]: **** for _rec in >>>> _cursor.execute(sql_str, (startstamp, stopstamp)): >>>> Mar 25 20:26:19 localhost weewx[31399]: **** File >>>> "/usr/share/weewx.github.development/weedb/sqlite.py", line 41, in >>>> guarded_fn >>>> Mar 25 20:26:19 localhost weewx[31399]: **** raise weedb. >>>> NoColumnError(e) >>>> Mar 25 20:26:19 localhost weewx[31399]: **** NoColumnError: no >>>> such column: hourRain >>>> Mar 25 20:26:19 localhost weewx[31399]: **** Generator >>>> terminated >>>> >>>> Is it a bug or am I missing something? >>>> >>>> -- >>>> 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]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > >
-- 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]. For more options, visit https://groups.google.com/d/optout.
