Load database connection from settings/env

[tombola]

Use pydantic settings to load from environment?

https://docs.pydantic.dev/latest/concepts/pydantic_settings/

Alternatively could load a dictionary from a python settings file? (eg django)

Bear in mind will want to support multiple databases.

[tombola]

On second thoughts, multiple databases doesn't need to be specifically handled in fmsql.

As long as can initialise an fmsql object with the required settings, and collect defaults/arguments from the environment for cli commands (which are against one dB) the client project can create several instances.

---

Could maybe just check whether it is possible to set the env_prefix for the nested settings model on init though? If so would give the option of getting settings for multiple dB from env. Eg:

FMSQL__DB__DBNAME__HOST

[tombola]

This looks brilliant for loading database and API instances

https://svcs.hynek.me/en/stable/

Might even handle closing database connection?

[tombola]

If use svcs then initially can just use it to load database in the same place as we do currently, and leave all the dependency injection in place.

After testing coverage is improved (in progress), can simplify by loading database service directly where needed, or in a decorator? (Would make the dependency more visible)