change values ​​in BDD

42 views
Skip to first unread message

Sebastien ROVERCH

unread,
Sep 15, 2019, 8:26:59 AM9/15/19
to weewx-user

Is there a tool to change values ​​in the database?

datetime - min - mintime - max - maxtime - sum - count - wsum - sumtime

I would like to change the value

appTemp added recent with the WindChill value felt that day.

Temp : 41.7°C
Wind : 22 km/h
WindChill : 47,5 °C


Thanks

Thomas Keffer

unread,
Sep 15, 2019, 9:40:39 PM9/15/19
to weewx-user
It is important that the main archive table and the daily summaries be kept in sync. So, you should change values in the main archive table, then rebuild the daily summaries.

Use any tool you wish to change the main archive table. I like sqlite3. You may have to install it.

sudo apt-get install sqlite3

The utility wee_database with the --rebuild-daily option can then rebuild the summaries.

-tk

--
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/67757220-3d8b-4d07-87b5-534782185950%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages