# sqlite3 weewx.sdb_new SQLite version 3.16.2 2017-01-06 16:32:41 Enter ".help" for usage hints. sqlite> .schema archive CREATE TABLE archive (`dateTime` INTEGER NOT NULL UNIQUE PRIMARY KEY, `usUnits` INTEGER NOT NULL, `interval` INTEGER NOT NULL, `barometer` REAL, `pressure` REAL, `altimeter` REAL, `inTemp` REAL, `outTemp` REAL, `inHumidity` REAL, `outHumidity` REAL, `windSpeed` REAL, `windDir` REAL, `windGust` REAL, `windGustDir` REAL, `rainRate` REAL, `rain` REAL, `dewpoint` REAL, `windchill` REAL, `heatindex` REAL, `ET` REAL, `radiation` REAL, `UV` REAL, `extraTemp1` REAL, `extraTemp2` REAL, `extraTemp3` REAL, `soilTemp1` REAL, `soilTemp2` REAL, `soilTemp3` REAL, `soilTemp4` REAL, `leafTemp1` REAL, `leafTemp2` REAL, `extraHumid1` REAL, `extraHumid2` REAL, `soilMoist1` REAL, `soilMoist2` REAL, `soilMoist3` REAL, `soilMoist4` REAL, `leafWet1` REAL, `leafWet2` REAL, `rxCheckPercent` REAL, `txBatteryStatus` REAL, `consBatteryVoltage` REAL, `hail` REAL, `hailRate` REAL, `heatingTemp` REAL, `heatingVoltage` REAL, `supplyVoltage` REAL, `referenceVoltage` REAL, `windBatteryStatus` REAL, `rainBatteryStatus` REAL, `outTempBatteryStatus` REAL, `inTempBatteryStatus` REAL, `appTemp` REAL, `windRun` REAL); sqlite> .exit
Last line shows both in the db now... On Wednesday, December 26, 2018 at 6:46:21 PM UTC-8, Scott Grayban wrote: > > AHHH I got it.... It didn't dawn on me that this > > *schema = schemas.wview.schema + [('appTemp', 'REAL'), ('windRun', > 'REAL')]* > > should be this > > *schema_apptemp = schemas.wview.schema + [('appTemp', 'REAL'), > ('windRun', 'REAL')]* > > Soooo stupid me....... > > > On Wednesday, December 26, 2018 at 6:40:41 PM UTC-8, gjr80 wrote: >> >> Simple, delete the line: >> >> schema = user.extensions.schema_windrun >> >> We now put everything in schema_apptemp. Please post user/extensions.py >> >> Gary >> >> >> On Thursday, 27 December 2018 12:32:23 UTC+10, Scott Grayban wrote: >>> >>> The error is in the weewx.conf >>> >>> >>> [DataBindings] >>> >>> [[wx_binding]] >>> # The database must match one of the sections in [Databases]. >>> # This is likely to be the only option you would want to change. >>> database = archive_sqlite >>> # The name of the table within the database >>> table_name = archive >>> # The manager handles aggregation of data for historical >>> summaries >>> manager = weewx.wxmanager.WXDaySummaryManager >>> # The schema defines the structure of the database. >>> # It is *only* used when the database is created. >>> #schema = schemas.wview.schema >>> >>> * schema = user.extensions.schema_apptemp* >>> * schema = user.extensions.schema_windrun* >>> >>> This is where it's saying *Duplicate keyword name at line 403* >>> >>> And I can't figure out how to combine that into 1 line. >>> >>> I have this in */usr/share/weewx/user/extensions.py* >>> >>> *schema = schemas.wview.schema + [('appTemp', 'REAL'), ('windRun', >>> 'REAL')]* >>> >>> >>> On Wednesday, December 26, 2018 at 5:19:35 PM UTC-8, gjr80 wrote: >>>> >>>> Hi Scott, >>>> >>>> On Thursday, 27 December 2018 09:19:11 UTC+10, Scott Grayban wrote: >>>>> >>>>> I tried adding 1 at a time but it deletes the previous one. Certainly >>>>> you should be able to add more then just 1 right ? >>>>> >>>> >>>> Do you mean adding more than one field to your schema or more than one >>>> schema >>>> = entry under [[wx_binding]]. I presume you mean the former, as the >>>> latter is not allowed, configobj (which handles parsing of the weeWX >>>> .conf files) only allows unique config option entries in a given >>>> stanza. So you can't have two schema = entries under [[wx_binding]]. >>>> You can certainly add more than one field at a time with a custom schema >>>> defined in a file. >>>> >>>> So we can work what is going wrong I suggest you give us the complete >>>> picture by posting: >>>> >>>> 1. the contents of weewx.conf with any sensitive info (eg passwords, >>>> user names etc) removed >>>> 2. the contents of the file (it should be >>>> /home/weewx/bin/user/extensions.py or >>>> /usr/share/weewx/user/extensions.py depending on your weeWX install >>>> type) containing the custom schema you are specifying at the schema = >>>> entry under [[wx_binding]] in weewx.conf >>>> 3. a screen capture showing the exact commands you issue and the exact >>>> responses received >>>> >>>> Please don't remove anything other than sensitive info, often a user >>>> may post what they think is the critical piece of info from a command or >>>> config file only to find that there is some other piece of critical info >>>> in >>>> the command output or config file that we need to work out exactly what is >>>> happening. Saves a lot of to'ing and fro'ing >>>> >>>> Gary >>>> >>> -- 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.