Refactoring how to specify ROOT directories. about weewx HOT 3 CLOSED

using [SQLite] and [MySQL] stanzas has a well-defined upgrade path; we can automatically convert existing weewx.conf files.

so the default weewx.conf would look like this:

[Databases]
    [[archive_sqlite]]
        database_name = weewx.sdb
        driver = weedb.sqlite
    [[archive_mysql]]
        database_name = weewx
        driver = weedb.mysql

and a user could override the sqlite database location for a single database like this:

[Database]
    [[custom_sqlite]]
        database_name = /home/username/custom.sdb
        driver = weedb.sqlite

or like this:

[Database]
    [[custom_sqlite]]
        SQLITE_ROOT = /home/username
        database_name = custom.sdb
        driver = weedb.sqlite

or override mysql login credentials like this (still using the same 'localhost' defined in the [MySQL] stanza):

[Database]
    [[custom_mysql]]
        database_name = custom
        user = username
        password = pw
        driver = weedb.mysql

so the minimal definition for an extension (specified in install.py) would be this:

[Databases]
  [[cmon_sqlite]]
    database_name = cmon.sdb
    driver = weedb.sqlite
  [[cmon_mysql]]
    database_name = cmon
    driver = weedb.mysql

from weewx.

Exactly.

One correction: on my earlier post, I proposed including the driver in the [SQLite] and [MySQL] stanzas. That won't work because, right now, the driver name is the only way to identify what kind of database it is.

We can either do things the way you outline above, or introduce yet another level of indirection:

[Databases]
  [[cmon_sqlite]]
    database_name = cmon.sdb
    database_type = SQLite
  [[cmon_mysql]]
    database_name = cmon
    database_type = MySQL

where option database_type has to match a stanza name.

from weewx.

Fixed in V3.2. With the addition of [SQLite] and [MySQL], the installer has become much simpler.

Closing issue.

from weewx.