Re: [weewx-user] Delete data between two time points

[Neil S]

Bingo!

Thank you for your help.

Neil


On Saturday, 11 January 2020 14:46:36 UTC, Thomas Keffer wrote:
>
> It's actually much simpler. The field 'dateTime' is already in unix epoch 
> time. So, you want
>
> *  delete from archive where dateTime>1578739140 and dateTime<1578741360;*
>
> Then rebuild the daily summaries.
>
> -tk
>
> On Sat, Jan 11, 2020 at 7:29 AM Neil S > 
> wrote:
>
>> I am trying to delete data between two time points as it is erroneous (I 
>> updated and for a short period the station type was reset to simulate).
>>
>> The time points are 11/1/20 at 10:39:00 and 11:16:00 (so I think I have 
>> the right unixepoch timestamps)
>>
>> I have worked out how to delete data that is older or newer than any one 
>> point but not between. In theory the following should work 
>>
>> *sqlite3 /var/lib/weewx/weewx.sdb*
>>
>> *delete from archive where datetime(dateTime,'unixepoch','localtime') 
>> BETWEEN '1578739140' AND '1578741360';*
>> *.exit*
>>
>>
>> but it doesnt and just appears to delete all data up to the last time 
>> stamp. All historic data seems to have been deleted (including all the NOAA 
>> data).
>>
>> I have also tried 
>>
>> *sqlite3 /var/lib/weewx/weewx.sdb*
>> *delete from archive where 
>> (datetime(dateTime,'unixepoch','localtime')>1578739140) AND *
>> *(datetime(dateTime,'unixepoch','localtime')<**1578741360);*
>> *.exit*
>>
>>
>> Strangely the database size seems to be the same though - so is it just a 
>> case of me panicking that I am loosing data and I need to wait for tables 
>> to be rebuilt?
>>
>> TIA
>> Neil
>>
>> -- 
>> 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...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/weewx-user/0f6dc72d-4366-4e63-922a-bde2275822b7%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/487e0a08-3686-4137-ab24-dcc1508741af%40googlegroups.com.

Re: [weewx-user] Delete data between two time points

[Thomas Keffer]

It's actually much simpler. The field 'dateTime' is already in unix epoch
time. So, you want

*  delete from archive where dateTime>1578739140 and dateTime<1578741360;*

Then rebuild the daily summaries.

-tk

On Sat, Jan 11, 2020 at 7:29 AM Neil S  wrote:

> I am trying to delete data between two time points as it is erroneous (I
> updated and for a short period the station type was reset to simulate).
>
> The time points are 11/1/20 at 10:39:00 and 11:16:00 (so I think I have
> the right unixepoch timestamps)
>
> I have worked out how to delete data that is older or newer than any one
> point but not between. In theory the following should work
>
> *sqlite3 /var/lib/weewx/weewx.sdb*
>
> *delete from archive where datetime(dateTime,'unixepoch','localtime')
> BETWEEN '1578739140' AND '1578741360';*
> *.exit*
>
>
> but it doesnt and just appears to delete all data up to the last time
> stamp. All historic data seems to have been deleted (including all the NOAA
> data).
>
> I have also tried
>
> *sqlite3 /var/lib/weewx/weewx.sdb*
> *delete from archive where
> (datetime(dateTime,'unixepoch','localtime')>1578739140) AND *
> *(datetime(dateTime,'unixepoch','localtime')<**1578741360);*
> *.exit*
>
>
> Strangely the database size seems to be the same though - so is it just a
> case of me panicking that I am loosing data and I need to wait for tables
> to be rebuilt?
>
> TIA
> Neil
>
> --
> 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/0f6dc72d-4366-4e63-922a-bde2275822b7%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/CAPq0zEC6LuCYs43yCNw1eiAivjZcXLj5UEiy-OJ%3DjQ5FYAmgvg%40mail.gmail.com.

[weewx-user] Delete data between two time points

[Neil S]

I am trying to delete data between two time points as it is erroneous (I 
updated and for a short period the station type was reset to simulate).

The time points are 11/1/20 at 10:39:00 and 11:16:00 (so I think I have the 
right unixepoch timestamps)

I have worked out how to delete data that is older or newer than any one 
point but not between. In theory the following should work 

*sqlite3 /var/lib/weewx/weewx.sdb*

*delete from archive where datetime(dateTime,'unixepoch','localtime') 
BETWEEN '1578739140' AND '1578741360';*
*.exit*


but it doesnt and just appears to delete all data up to the last time 
stamp. All historic data seems to have been deleted (including all the NOAA 
data).

I have also tried 

*sqlite3 /var/lib/weewx/weewx.sdb*
*delete from archive where 
(datetime(dateTime,'unixepoch','localtime')>1578739140) AND *
*(datetime(dateTime,'unixepoch','localtime')<**1578741360);*
*.exit*


Strangely the database size seems to be the same though - so is it just a 
case of me panicking that I am loosing data and I need to wait for tables 
to be rebuilt?

TIA
Neil

-- 
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/0f6dc72d-4366-4e63-922a-bde2275822b7%40googlegroups.com.