I've also extended my database scheme a second time - without any issues.

Here's my extensions.py
I've just added the additional three fields to the already extended scheme.

[email protected] schrieb am Freitag, 12. März 2021 um 08:42:17 UTC+1:

> got it, thank you manfred!
>
> now a question about radiationhours: i have extended the schema already 
> one time for the weatherlink-driver: 
> https://github.com/michael-slx/weewx-weatherlink-live
>
> whats the correct way to extend the schema a second time? i tried it one 
> time, but then i lost the additional fields from the weatherlink-driver
>
> Manfred Maier schrieb am Donnerstag, 11. März 2021 um 19:28:55 UTC+1:
>
>> Yes, you are correct. If the page is using https, all components need to 
>> have a ssl certificate.
>>
>> [email protected] schrieb am Donnerstag, 11. März 2021 um 10:00:07 UTC+1:
>>
>>> hi,
>>>
>>> thanks for this file, i will try it after mqtt-setup :-)
>>>
>>> i always get failed connecting on my website and i think it's because my 
>>> site is using https
>>>
>>> the test here is working fine, i get the live data 
>>> http://www.hivemq.com/demos/websocket-client/
>>>
>>> do i have to run my local mosquitto installation also with ssl/tls or is 
>>> there another way to get it working?
>>>
>>> regards,
>>> chris
>>>
>>> Manfred Maier schrieb am Mittwoch, 10. März 2021 um 20:44:02 UTC+1:
>>>
>>>> I'm using the attached file, which I found somewhere here in this user 
>>>> forum. 
>>>> I've slightly adapted it to bette fit my needs. 
>>>>
>>>> Don't get confused by the filed name 'EmptyReal'. That was just a spare 
>>>> field I had in my database.
>>>>
>>>> The calculation of the theoretical radiation level is not 100% perfect, 
>>>> but it does the job.
>>>>
>>>>
>>>> [email protected] schrieb am Mittwoch, 10. März 2021 um 20:05:55 UTC+1:
>>>>
>>>>> ok, i will try it locally before, but vserver is also a good (cheap) 
>>>>> option :-)
>>>>>
>>>>> another question to you: how do you calculate sun hours on your site, 
>>>>> is it from here? https://github.com/gjr80/weewx-weewx-wd
>>>>>
>>>>> Manfred Maier schrieb am Mittwoch, 10. März 2021 um 19:23:40 UTC+1:
>>>>>
>>>>>> No, I didn't.
>>>>>>
>>>>>> I'm (unfortunately) sitting behind fiberglass without a static IPv4. 
>>>>>> So I anyway had to rent a vServer for running my own tunneling 
>>>>>> solution for my local webcam.
>>>>>>
>>>>>> [email protected] schrieb am Mittwoch, 10. März 2021 um 19:12:12 
>>>>>> UTC+1:
>>>>>>
>>>>>>> hi manfred,
>>>>>>>
>>>>>>> did you try to run the broker locally before? 
>>>>>>>
>>>>>>> i have a static ip with symmetric bandwidth. or are there other 
>>>>>>> reasons why it doesnt work?
>>>>>>>
>>>>>>> regards,
>>>>>>> chris
>>>>>>>
>>>>>>> Manfred Maier schrieb am Mittwoch, 10. März 2021 um 15:16:35 UTC+1:
>>>>>>>
>>>>>>>> Hi Chris,
>>>>>>>> I've been in a similar situation to you.
>>>>>>>> My web hosting service didn't allow me to run a MQTT broker and the 
>>>>>>>> (free) public brokers didn't perform very well. The majority of MQTT 
>>>>>>>> packages got lost and were not delivered to the web client.
>>>>>>>> So in the end I've decided to rent an additional vServer and run my 
>>>>>>>> own MQTT broker. The setup was really easy, but there's a server cost 
>>>>>>>> of 
>>>>>>>> approx. 2€ per month.
>>>>>>>>
>>>>>>>> Manfred  
>>>>>>>>
>>>>>>>> [email protected] schrieb am Mittwoch, 10. März 2021 um 11:59:33 
>>>>>>>> UTC+1:
>>>>>>>>
>>>>>>>>> You need a publicly available MQTT broker. Either you install one 
>>>>>>>>> on your webhoster's webspace (if possible), or you use a public 
>>>>>>>>> broker like 
>>>>>>>>> test.mosquitto.org.
>>>>>>>>>
>>>>>>>>> [email protected] schrieb am Mittwoch, 10. März 2021 um 07:46:52 
>>>>>>>>> UTC+1:
>>>>>>>>>
>>>>>>>>>> hello,
>>>>>>>>>>
>>>>>>>>>> i am uploading the reports via FTP to my webhoster. can i use 
>>>>>>>>>> mqtt then for live data oder do i need a locally webserver?
>>>>>>>>>>
>>>>>>>>>> regards,
>>>>>>>>>> chris
>>>>>>>>>>
>>>>>>>>>

-- 
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].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/d40856a9-6a35-4a27-8430-5a6e53654ce5n%40googlegroups.com.
#
#    Copyright (c) 2009-2015 Tom Keffer <[email protected]>
#
#    See the file LICENSE.txt for your full rights.
#

"""User extensions module

This module is imported from the main executable, so anything put here will be
executed before anything else happens. This makes it a good place to put user
extensions.
"""

import locale
import schemas.wview
# This will use the locale specified by the environment variable 'LANG'
# Other options are possible. See:
# http://docs.python.org/2/library/locale.html#locale.setlocale
locale.setlocale(locale.LC_ALL, '')

schema_extended = schemas.wview.schema + [('appTemp', 'REAL'), ('windrun', 'REAL'), ('maxSolarRad', 'REAL'), ('sunshineTime', 'REAL'), ('sunshineTheoretical', 'REAL'), ('emptyReal', 'REAL')]

#
# Units for sunshine_days calculated field
#
import weewx.units
weewx.units.obs_group_dict['sunshineTime'] = 'group_interval'
weewx.units.obs_group_dict['sunshineTheoretical'] = 'group_interval'

Reply via email to