Found problems in tests on linux while devoloping

[JanEisermann]

In my branch inkludingBP in my repository i get Errors in the database. In GitHub this Errors are not showed. I think we should find a solution which always works.

configure testdata
/tmp/tmpix2_syim/mswms/testdata
WARNING:root:Couldn't import mscolab_settings (ImportError:'No module named 'mscolab_settings''), using dummy config.
WARNING:root:Couldn't import setup_saml2_backend (ImportError:'No module named 'setup_saml2_backend''), using dummy config.
INFO:matplotlib.font_manager:Failed to extract font properties from /usr/share/fonts/truetype/noto/NotoColorEmoji.ttf: In FT2Font: Could not set the fontsize (invalid pixel size; error code 0x17)
INFO:matplotlib.font_manager:generated new fontManager
WARNING:matplotlib.style.core:In /home/icg195/tmp/MSS/.pixi/envs/dev/lib/python3.11/site-packages/matplotlib/mpl-data/stylelib/classic.mplstyle: 'parseString' deprecated - use 'parse_string'
WARNING:matplotlib.style.core:In /home/icg195/tmp/MSS/.pixi/envs/dev/lib/python3.11/site-packages/matplotlib/mpl-data/stylelib/classic.mplstyle: 'resetCache' deprecated - use 'reset_cache'
WARNING:matplotlib.style.core:In /home/icg195/tmp/MSS/.pixi/envs/dev/lib/python3.11/site-packages/matplotlib/mpl-data/stylelib/classic.mplstyle: 'parseString' deprecated - use 'parse_string'
WARNING:matplotlib.style.core:In /home/icg195/tmp/MSS/.pixi/envs/dev/lib/python3.11/site-packages/matplotlib/mpl-data/stylelib/classic.mplstyle: 'resetCache' deprecated - use 'reset_cache'
WARNING:matplotlib.style.core:In /home/icg195/tmp/MSS/.pixi/envs/dev/lib/python3.11/site-packages/matplotlib/mpl-data/stylelib/classic.mplstyle: 'parseString' deprecated - use 'parse_string'
WARNING:matplotlib.style.core:In /home/icg195/tmp/MSS/.pixi/envs/dev/lib/python3.11/site-packages/matplotlib/mpl-data/stylelib/classic.mplstyle: 'resetCache' deprecated - use 'reset_cache'
WARNING:matplotlib.style.core:In /home/icg195/tmp/MSS/.pixi/envs/dev/lib/python3.11/site-packages/matplotlib/mpl-data/stylelib/classic.mplstyle: 'parseString' deprecated - use 'parse_string'
WARNING:matplotlib.style.core:In /home/icg195/tmp/MSS/.pixi/envs/dev/lib/python3.11/site-packages/matplotlib/mpl-data/stylelib/classic.mplstyle: 'resetCache' deprecated - use 'reset_cache'
WARNING:root:Couldn't import mswms_auth.allowed_users (No module named 'mswms_auth'); basic auth will reject all users.
WARNING:root:Couldn't import mswms_auth (ImportError:'{No module named 'mswms_auth'), creating dummy config.
Your database contains no alembic_version revision identifier, but it has a schema. This suggests that you have a pre-existing database but haven't followed the database migration instructions. To prevent damage to your database MSColab will abort. Please follow the documentation for a manual database migration from MSColab v8/v9.

[JanEisermann]

If I delete colabdata from my home directory, the tests run again, but with different errors. In the process, colabdata is recreated in my home directory, which causes the errors described in the issue to occur when I run the tests again.

[ReimarBauer]

Hi @JanEisermann
thx for reporting this.

1. Please show the result of QT_QPA_PLATFORM=offscreen pytest tests/_test_mscolab/test_utils.py -q

2. and try a a small test like tests/test_show_dburi.py This helps to understand the state of the database before its first reset

import sqlalchemy

def test_show_db_state():
    from mslib.mscolab.app import APP
    print("\nDB:", APP.config["SQLALCHEMY_DATABASE_URI"])
    with APP.app_context():
        from mslib.mscolab.models import db
        insp = sqlalchemy.inspect(db.engine)
        print("users:", [c["name"] for c in insp.get_columns("users")])
        print("version:", list(db.session.execute(sqlalchemy.text("SELECT * FROM alembic_version"))))

in your dev environemnt
QT_QPA_PLATFORM=offscreen pytest tests/test_show_dburi.py -q -s

3. in your dev environment pixi list sqlite

[ReimarBauer]

This needs to be checked after merge of
#3123