weewx-purpleair icon indicating copy to clipboard operation
weewx-purpleair copied to clipboard

change schema to record raw A and B data

Open jonathankoren opened this issue 3 years ago • 1 comments

Adds columns to record channels A and B's data separately. This schema is backwards comparable with the current average of A and B records.

jonathankoren avatar Jul 20 '21 03:07 jonathankoren

Hi @jonathankoren ,

This fails with a schema mismatch for me.

Jul 20 10:30:41 machine weewx[17180] CRITICAL __main__:     ****  purpleair schema mismatch: ['dateTime', 'usUnits', 'interval', 'purple_temperature', 'purple_humidity', 'purple_dewpoint', 'purple_pressure', 'pm1_0_cf_1', 'pm1_0_atm', 'pm2_5_cf_1', 'pm2_5_atm', 'pm10_0_cf_1', 'pm10_0_atm'] != ['dateTime', 'usUnits', 'interval', 'purple_temperature', 'purple_humidity', 'purple_dewpoint', 'purple_pressure', 'pm1_0_cf_1', 'pm1_0_atm', 'pm2_5_cf_1', 'pm2_5_atm', 'pm10_0_cf_1', 'pm10_0_atm', 'pm1_0_cf_1_a', 'pm1_0_atm_a', 'pm2_5_cf_1_a', 'pm2_5_atm_a', 'pm10_0_cf_1_a', 'pm10_0_atm_a', 'pm1_0_cf_1_b', 'pm1_0_atm_b', 'pm2_5_cf_1_b', 'pm2_5_atm_b', 'pm10_0_cf_1_b', 'pm10_0_atm_b']
Jul 20 10:30:41 machine weewx[17180] CRITICAL __main__:     ****  Traceback (most recent call last):
Jul 20 10:30:41 machine weewx[17180] CRITICAL __main__:     ****    File "/usr/share/weewx/weewxd", line 172, in main
Jul 20 10:30:41 machine weewx[17180] CRITICAL __main__:     ****      engine = weewx.engine.StdEngine(config_dict)
Jul 20 10:30:41 machine weewx[17180] CRITICAL __main__:     ****    File "/usr/share/weewx/weewx/engine.py", line 93, in __init__
Jul 20 10:30:41 machine weewx[17180] CRITICAL __main__:     ****      self.loadServices(config_dict)
Jul 20 10:30:41 machine weewx[17180] CRITICAL __main__:     ****    File "/usr/share/weewx/weewx/engine.py", line 161, in loadServices
Jul 20 10:30:41 machine weewx[17180] CRITICAL __main__:     ****      obj = weeutil.weeutil.get_object(svc)(self, config_dict)
Jul 20 10:30:41 machine weewx[17180] CRITICAL __main__:     ****    File "/usr/share/weewx/user/purpleair.py", line 275, in __init__
Jul 20 10:30:41 machine weewx[17180] CRITICAL __main__:     ****      raise Exception('purpleair schema mismatch: %s != %s' % (dbcol, memcol))
Jul 20 10:30:41 machine weewx[17180] CRITICAL __main__:     ****  Exception: purpleair schema mismatch: ['dateTime', 'usUnits', 'interval', 'purple_temperature', 'purple_humidity', 'purple_dewpoint', 'purple_pressure', 'pm1_0_cf_1', 'pm1_0_atm', 'pm2_5_cf_1', 'pm2_5_atm', 'pm10_0_cf_1', 'pm10_0_atm'] != ['dateTime', 'usUnits', 'interval', 'purple_temperature', 'purple_humidity', 'purple_dewpoint', 'purple_pressure', 'pm1_0_cf_1', 'pm1_0_atm', 'pm2_5_cf_1', 'pm2_5_atm', 'pm10_0_cf_1', 'pm10_0_atm', 'pm1_0_cf_1_a', 'pm1_0_atm_a', 'pm2_5_cf_1_a', 'pm2_5_atm_a', 'pm10_0_cf_1_a', 'pm10_0_atm_a', 'pm1_0_cf_1_b', 'pm1_0_atm_b', 'pm2_5_cf_1_b', 'pm2_5_atm_b', 'pm10_0_cf_1_b', 'pm10_0_atm_b']

bakerkj avatar Jul 20 '21 14:07 bakerkj