oops - I meant 'drop-field' and 'rebuild-field' there of course in the last paragraph...intent was to handle the case where somebody doesn't want to drop all summary tables, just the one matching the field they cleaned up in the archive table.
On Thursday, March 25, 2021 at 12:17:15 PM UTC-7 vince wrote: > I know 'drop' is a database term, but I'm wondering if --delete-column > might be better wording here generically. > > We have drop-daily and rebuild-daily for dealing with summary tables, so > I'm thinking maybe the terminology meaning different things in different > context might be confusing. Just a thought. > > Similarly, we have lots of cases where folks get bad data in their archive > for rain/whatever and need to clean those items up. Is there a > "drop-field" or "rename-field" or the like to help people drop/rebuild just > the summary tables for a particular database element ? Apologies if that > already exists... > > > On Wednesday, March 24, 2021 at 2:10:23 PM UTC-7 Tom Keffer wrote: > >> Several interesting new features. Most notably, you can add, remove, or >> rename columns in the main database with the utility wee_database. No need >> to use --reconfigure with all the database shuffling involved! For >> example, to remove the type soilMoist2: >> >> wee_database --drop-columns=soilMoist2 >> >> >> If you use this feature, remember that this is a beta release. Be sure to >> do a backup first!! >> >> There is also support for using *series* in the templates, including >> generating JSON. For example, a JSON series of the maximum temperature for >> each day of the month would be: >> >> $month.outTemp.series(aggregate_type='max', aggregate_interval='day').json >> >> >> This generates something like: >> >> [[1614585600, 1614672000, 58.2], [1614672000, 1614758400, 55.8], >> [1614758400, 1614844800, 59.6], ... ] >> >> >> This is a series of 3-way tuples, where each tuple consists of the start >> time of the day, stop time of the day, and (in this case) maximum >> temperature for the day. >> >> See the Wiki article *Tags for series >> <https://github.com/weewx/weewx/wiki/Tags-for-series>* for more details. >> Please note: this is still experimental, and subject to change! >> >> Lots of miscellaneous bug fixes. >> >> Find it in the usual place >> <http://weewx.com/downloads/development_versions/> for development >> releases. >> >> Feedback is very welcome!! >> >> -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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/79e7ef19-94af-4c3b-8983-7eff8889ce5cn%40googlegroups.com.
