# 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
