Re: [weewx-user] Changing signal names ("Members") in existing WeeWx database

2021-05-05 Thread engolling 
Hallo, I used the rename-colum option of the wee_database utility and it 
worked fine. Thank you for the hint.
I noticed one thing concerning case sensitivity. I wanted to rename "CO2" 
to "co2" but I got the following output:
pi@WeatherDuinoPI:~ $ wee_database --rename-column=CO2 --to-name=co2
Using configuration file /etc/weewx/weewx.conf
Using database binding 'wx_binding', which is bound to database 
'archive_sqlite'
Rename column 'CO2' to 'co2' (y/n)? y
Traceback (most recent call last):
  File "/usr/share/weewx/weedb/sqlite.py", line 30, in guarded_fn
return fn(*args, **kwargs)
  File "/usr/share/weewx/weedb/sqlite.py", line 219, in execute
return sqlite3.Cursor.execute(self, *args, **kwargs)
sqlite3.OperationalError: there is already another table or index with this 
name: archive_day_co2

Seems as there is a problem with case sensitivity, so I changed the name to 
"carbon" and then to "co2" as workaround.

Regards,
engolling

engolling schrieb am Montag, 3. Mai 2021 um 20:55:01 UTC+2:

> Thank you for your quick answer. I will give it a try.
>
> Do I have to make sure if the new_name does not exist already (as far as I 
> have seen in this is not the case for me) or would it be overridden?
>
> Regards,
> engolling
>
> tke...@gmail.com schrieb am Montag, 3. Mai 2021 um 14:19:56 UTC+2:
>
>> As an alternative, if you are using WeeWX v4.5, you can just use the 
>> utility wee_database with the --rename-column 
>>  option.
>>
>> *wee_database --rename-column=old_name --to-name=new_name*
>>
>> This has the advantage that it directly alters the database, so it is 
>> very fast. 
>>
>> Make a backup first.
>>
>> On Mon, May 3, 2021 at 5:11 AM engolling  wrote:
>>
>>>
>>> Hello,
>>>
>>> I have an existing WeeWx Database with following signals I generated 
>>> myself: "Snow_Heigt", "AQM_PM10_0", etc...
>>> With WeeWx 4 some of my signals were introduced as default and I would 
>>> like to moove my scheme to the default for compatibility reasons with skins 
>>> and so on.
>>>
>>> I would therefore just rename my "old" columns to the new default name 
>>> (and delete the default comlums if available".
>>> Adjust my old schemes that it is compatible angain an then
>>>
>>>- *Reconfigure the Database: wee_database weewx.conf --reconfigure*
>>>- *Rebuild the daily tables: wee_database weewx.conf --rebuild-daily*
>>>
>>> Do you think there is anythink else to take into account? I would like 
>>> to do it right the first time, since my Database has already 600MB it might 
>>> take a while ;)
>>>
>>> Regards,
>>> engolling
>>>
>>> -- 
>>> 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+...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/weewx-user/5ff06bd8-d3bd-459f-84aa-d3f65f1ab9bcn%40googlegroups.com
>>>  
>>> 
>>> .
>>>
>>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/ffa79226-5948-42e9-919b-e59c48ef58ffn%40googlegroups.com.

Re: [weewx-user] Changing signal names ("Members") in existing WeeWx database

2021-05-03 Thread engolling 
Thank you for your quick answer. I will give it a try.

Do I have to make sure if the new_name does not exist already (as far as I 
have seen in this is not the case for me) or would it be overridden?

Regards,
engolling

tke...@gmail.com schrieb am Montag, 3. Mai 2021 um 14:19:56 UTC+2:

> As an alternative, if you are using WeeWX v4.5, you can just use the 
> utility wee_database with the --rename-column 
>  option.
>
> *wee_database --rename-column=old_name --to-name=new_name*
>
> This has the advantage that it directly alters the database, so it is very 
> fast. 
>
> Make a backup first.
>
> On Mon, May 3, 2021 at 5:11 AM engolling  wrote:
>
>>
>> Hello,
>>
>> I have an existing WeeWx Database with following signals I generated 
>> myself: "Snow_Heigt", "AQM_PM10_0", etc...
>> With WeeWx 4 some of my signals were introduced as default and I would 
>> like to moove my scheme to the default for compatibility reasons with skins 
>> and so on.
>>
>> I would therefore just rename my "old" columns to the new default name 
>> (and delete the default comlums if available".
>> Adjust my old schemes that it is compatible angain an then
>>
>>- *Reconfigure the Database: wee_database weewx.conf --reconfigure*
>>- *Rebuild the daily tables: wee_database weewx.conf --rebuild-daily*
>>
>> Do you think there is anythink else to take into account? I would like to 
>> do it right the first time, since my Database has already 600MB it might 
>> take a while ;)
>>
>> Regards,
>> engolling
>>
>> -- 
>> 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+...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/weewx-user/5ff06bd8-d3bd-459f-84aa-d3f65f1ab9bcn%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/5c1d8bea-38e4-4974-a732-61e1e3b2489dn%40googlegroups.com.

Re: [weewx-user] Changing signal names ("Members") in existing WeeWx database

2021-05-03 Thread Tom Keffer 
As an alternative, if you are using WeeWX v4.5, you can just use the
utility wee_database with the --rename-column
 option.

*wee_database --rename-column=old_name --to-name=new_name*

This has the advantage that it directly alters the database, so it is very
fast.

Make a backup first.

On Mon, May 3, 2021 at 5:11 AM engolling  wrote:

>
> Hello,
>
> I have an existing WeeWx Database with following signals I generated
> myself: "Snow_Heigt", "AQM_PM10_0", etc...
> With WeeWx 4 some of my signals were introduced as default and I would
> like to moove my scheme to the default for compatibility reasons with skins
> and so on.
>
> I would therefore just rename my "old" columns to the new default name
> (and delete the default comlums if available".
> Adjust my old schemes that it is compatible angain an then
>
>- *Reconfigure the Database: wee_database weewx.conf --reconfigure*
>- *Rebuild the daily tables: wee_database weewx.conf --rebuild-daily*
>
> Do you think there is anythink else to take into account? I would like to
> do it right the first time, since my Database has already 600MB it might
> take a while ;)
>
> Regards,
> engolling
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/5ff06bd8-d3bd-459f-84aa-d3f65f1ab9bcn%40googlegroups.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/CAPq0zECzcFHvWb2woKWkcQJ-6r8rCz_NRfhnRh8wJfuhjaLGPg%40mail.gmail.com.