search

bakerkj / weewx-purpleair

WeeWx Extension to pull data from the local interface of a Purple Air air quality sensor
GNU General Public License v2.0
17 stars 11 forks source link

change schema to record raw A and B data #21

Open jonathankoren opened 3 years ago

jonathankoren commented 3 years ago

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.

bakerkj commented 3 years ago

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']