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 <paolobe...@gmail.com>
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 <paolo...@gmail.com>
>> 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 weewx-user+...@googlegroups.com.
>>> 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 weewx-user+unsubscr...@googlegroups.com.
> 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 weewx-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
