Error running first time MSNOISE

[fontiela]

When using the master branch of MSNoise (installed via pip), the command msnoise db init fails if no schema exists in the SQLite database. It tries to read from the config table before creating it, resulting in OperationalError: no such table: config. This makes it impossible to initialize a fresh project without manually creating the schema.

Any command (even --help) fails with:
sqlite3.OperationalError: no such table: config

To fix it, the schema must be manually created with:
from msnoise.msnoise_table_def import Base
from msnoise.api import get_engine
Base.metadata.create_all(get_engine())

I’m using a conda environment with Python 3.12 on macOS, using SQLite as the backend. I’m not sure if this issue is specific to my setup, to the master branch, or something else. In any case, I’m sharing the workaround I used to fix it, in case it helps others or points to a bug.

[ThomasLecocq]

hey, thanks for the report & sorry for the delay. I never had this issue, maybe linked to new ways of sqlalchemy to create the engines ...