[weewx-user] Re: delete ID dans weewx.sdb

[Pat]

Yes Belchertown skin works with 3.9.1. I'm also going to release an update 
to the skin in the coming days. 

On Friday, February 15, 2019 at 5:34:47 AM UTC-5, Patrick Tranchant wrote:
>
> hello PAT,
> I could edit the database but on my PC windows with DBmanager because I 
> could not do it on my RPi with the same soft ( maybe problem of super user 
> !!!)
> it is OK now.
> So , your Skin Belchertown is compatible with the new version of Weewx ?
> thanks for all
>
> Patrick
>
> On Tuesday, February 12, 2019 at 2:18:39 PM UTC+1, Patrick Tranchant wrote:
>>
>> hello
>> do you know how to delete a record ID in the weewx.sdb database?
>> I would delete some records on top of this database when I done tests 
>> before the driver works well.
>> thanks
>>
>> Patrick
>>
>> ps: I installed db browser on my RPi, but the button "delete record" is 
>> not valid.
>>
>

-- 
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.

[weewx-user] Re: delete ID dans weewx.sdb

[Patrick Tranchant]

hello PAT,
I could edit the database but on my PC windows with DBmanager because I 
could not do it on my RPi with the same soft ( maybe problem of super user 
!!!)
it is OK now.
So , your Skin Belchertown is compatible with the new version of Weewx ?
thanks for all

Patrick

On Tuesday, February 12, 2019 at 2:18:39 PM UTC+1, Patrick Tranchant wrote:
>
> hello
> do you know how to delete a record ID in the weewx.sdb database?
> I would delete some records on top of this database when I done tests 
> before the driver works well.
> thanks
>
> Patrick
>
> ps: I installed db browser on my RPi, but the button "delete record" is 
> not valid.
>

-- 
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.

[weewx-user] Re: delete ID dans weewx.sdb

[Pat]

If you stop weewx, then delete the sqlite file, then you will start with a 
brand new database. 

If you just want to delete rows, open the sqlite file on command line (sqlite3 
weewx.sdb) or in a tool like DB Browser for SQLite 
 and find the dateTime you want to delete. 

Then run this SQLite command. Change 123456 with the correct dateTime

delete from archive where dateTime = "123456"

Disclaimer: have a backup of your database in case you want to undo what 
you did. You are responsible for any changes you make.

-- 
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.

[weewx-user] Re: delete ID dans weewx.sdb

[Andrew Milner]

yes

On Tuesday, 12 February 2019 21:43:38 UTC+2, Patrick Tranchant wrote:
>
> again
>
> if I delete the file weewx.sdb, weewx create an other automaticly. 
>
> On Tuesday, February 12, 2019 at 2:18:39 PM UTC+1, Patrick Tranchant wrote:
>>
>> hello
>> do you know how to delete a record ID in the weewx.sdb database?
>> I would delete some records on top of this database when I done tests 
>> before the driver works well.
>> thanks
>>
>> Patrick
>>
>> ps: I installed db browser on my RPi, but the button "delete record" is 
>> not valid.
>>
>

-- 
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.

[weewx-user] Re: delete ID dans weewx.sdb

[Patrick Tranchant]

again

if I delete the file weewx.sdb, weewx create an other automaticly. 

On Tuesday, February 12, 2019 at 2:18:39 PM UTC+1, Patrick Tranchant wrote:
>
> hello
> do you know how to delete a record ID in the weewx.sdb database?
> I would delete some records on top of this database when I done tests 
> before the driver works well.
> thanks
>
> Patrick
>
> ps: I installed db browser on my RPi, but the button "delete record" is 
> not valid.
>

-- 
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.

[weewx-user] Re: delete ID dans weewx.sdb

[Andrew Milner]

delete from archive where timeDate < ..; 
would delete records with a dateTime earlier than the specified datetime



On Tuesday, 12 February 2019 18:19:51 UTC+2, Patrick Tranchant wrote:
>
> yes I do
> Patrick
>
> On Tuesday, February 12, 2019 at 2:18:39 PM UTC+1, Patrick Tranchant wrote:
>>
>> hello
>> do you know how to delete a record ID in the weewx.sdb database?
>> I would delete some records on top of this database when I done tests 
>> before the driver works well.
>> thanks
>>
>> Patrick
>>
>> ps: I installed db browser on my RPi, but the button "delete record" is 
>> not valid.
>>
>

-- 
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.

[weewx-user] Re: delete ID dans weewx.sdb

[Patrick Tranchant]

yes I do
Patrick

On Tuesday, February 12, 2019 at 2:18:39 PM UTC+1, Patrick Tranchant wrote:
>
> hello
> do you know how to delete a record ID in the weewx.sdb database?
> I would delete some records on top of this database when I done tests 
> before the driver works well.
> thanks
>
> Patrick
>
> ps: I installed db browser on my RPi, but the button "delete record" is 
> not valid.
>

-- 
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.

[weewx-user] Re: delete ID dans weewx.sdb

[Andrew Milner]

did you stop weewx first??


On Tuesday, 12 February 2019 15:18:39 UTC+2, Patrick Tranchant wrote:
>
> hello
> do you know how to delete a record ID in the weewx.sdb database?
> I would delete some records on top of this database when I done tests 
> before the driver works well.
> thanks
>
> Patrick
>
> ps: I installed db browser on my RPi, but the button "delete record" is 
> not valid.
>

-- 
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.