Ah good, makes sense indeed. Please ignore my last message with the error message.
> On 19 Apr, 2021, at 20:13, Tom Keffer <[email protected]> wrote: > > Vince is right that you need V4.5. > > But, your command is also wrong. Review the docs for wee_database > <http://www.weewx.com/docs/utilities.htm#wee_database_utility>. > > The --config option selects a configuration file, such as weewx.conf, not a > database. > > The --binding option selects the binding. By default, it uses the binding > wx_binding. > > So, if you want to use a second database, such as envoy.sdb, it must first be > listed as a binding. For example, > > [DataBindings] > > [[envoy_binding]] > # The database must match one of the sections in [Databases]. > # This is likely to be the only option you would want to change. > database = envoy_sqlite > # The name of the table within the database > table_name = archive > # The manager handles aggregation of data for historical summaries > manager = weewx.wxmanager.WXDaySummaryManager > # The schema defines the structure of the database. > # It is *only* used when the database is created. > schema = schemas.wview_extended.schema > > [Databases] > > # A SQLite database is simply a single file > [[envoy_sqlite]] > database_name = envoy.sdb > database_type = SQLite > > This sets up a new binding envoy_binding, which uses envoy.sdb. Now you can > add a new column to the new binding: > > wee_database --add-column=mynewcolumn --binding=envoy_binding > > > > On Mon, Apr 19, 2021 at 12:57 PM vince <[email protected] > <mailto:[email protected]>> wrote: > Your weewx is too old. You need to update to 4.5.0 or later according to the > release notes at https://github.com/weewx/weewx/releases > <https://github.com/weewx/weewx/releases> > > > On Monday, April 19, 2021 at 11:38:54 AM UTC-7 [email protected] > <mailto:[email protected]> wrote: > I am asking just that but I can’t see how —binding might work > > When I installed the Envoy drive, it still uses wx_binding when in creates > envoy.sdb > > So I tried: > > In /home/weewx: > > sudo bin/wee_database --add-column=energy_total --config=archive/envoy.sdb > > And it throws an error: > > wee_database: error: no such option: --add-column > > >> On 16 Apr, 2021, at 17:58, vince <[email protected] <>> wrote: >> > >> (untested but...) see if the --binding option gets you what you're looking >> for, if you're asking how to add column(s) to a secondary database other >> than the default one. >> >> On Friday, April 16, 2021 at 2:54:19 PM UTC-7 [email protected] >> <http://gmail.com/> wrote: >> From the WeeWx docs: >>> Adding a new type to an existing database >>> Here's how you would add the observation type electricity (from the example >>> Adding a second data source >>> <http://weewx.com/docs/customizing.htm#Adding_2nd_source>) to an existing >>> database by using wee_database: >>> >>> wee_database --add-column=electricity >> >> But if I want to specify **which** .sdb file can I do: >> >> wee_database --add-column=mynewcolumn --config=another.sdb (which already >> exists). >> >> WeeWx 4.4.1 >> Python 3.7 >> Raspian Desktop Buster >> > >> -- >> 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/961ff186-7efa-4306-9e21-4fa6c505e9e2n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/961ff186-7efa-4306-9e21-4fa6c505e9e2n%40googlegroups.com?utm_medium=email&utm_source=footer>. > > > -- > 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] > <mailto:[email protected]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/3a4ffda4-c4c6-4506-af39-22d5140e81ddn%40googlegroups.com > > <https://groups.google.com/d/msgid/weewx-user/3a4ffda4-c4c6-4506-af39-22d5140e81ddn%40googlegroups.com?utm_medium=email&utm_source=footer>. > > -- > 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] > <mailto:[email protected]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/CAPq0zECBhPoP3CSaJJZ-EdxKOKj5kziWGZTF%3DqbWiJo2x%3D0QkA%40mail.gmail.com > > <https://groups.google.com/d/msgid/weewx-user/CAPq0zECBhPoP3CSaJJZ-EdxKOKj5kziWGZTF%3DqbWiJo2x%3D0QkA%40mail.gmail.com?utm_medium=email&utm_source=footer>. -- 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/369BD6AF-8B6A-449A-B6BE-7AB04D07AE88%40gmail.com.
