Awesome flask-sqlalchemy, I have two questions. 1. typo in docs, 2. set up test

[capymind]

Hi, all.
flask-sqlalchemy is awesome.
But I am not awsome and (still) a beginner.
Sorry for this kind of silly question.

1. typo in docs
   docs say in section about test that
   (https://flask-sqlalchemy.palletsprojects.com/en/3.0.x/contexts/#tests)

import pytest

@pytest.mark.fixture  # 👈👈 I think @pytest.fixture (there is no @pytest.mark.fixture...)
def app_ctx(app):
    with app.app_context():
        yield

@pytest.mark.usefixtures("app_ctx")
def test_user_model(app):
    user = User()
    db.session.add(user)
    db.session.commit()

Regardless of the fact that this is typo or not.
The section itself is really helpful for me to set up test code.
Thanks a lot for adding this section (relatively) recently.

There are already many blogs and youtubes about pytest, flask, sqlalchemy..
But there is no simple, easy to understand ways to set up test environment about flask-sqlalchemy(flask and database)

2. set up test
   If I understand the code above correctly, the environment about database
   (such as table, data(rows) in table) is effective across all test functions.
   That is, if test_add_row() is executed and then test_row_exists() is executed
   former test's result affect latter test's result. Is it right?

That's cool, however, is there any way to set up database indpendent across test functions?
I think it's a lot related to pytest, not flask-sqlalchemy itself. (sorry for wrong place if that is true).

I did some googling and find open source named skylines. In that codebase, there are code related to this topic.

@pytest.fixture(scope="session")
def db(app):
    """Creates clean database schema and drops it on teardown

    Note, that this is a session scoped fixture, it will be executed only once
    and shared among all tests. Use `db_session` fixture to get clean database
    before each test.
    """
    assert isinstance(app, SkyLines)

    setup_db(app)
    yield database.db
    teardown_db()


@pytest.fixture(scope="function")
def db_session(db, app):
    """Provides clean database before each test. After each test,
    session.rollback() is issued.

    Return sqlalchemy session.
    """
    assert isinstance(app, SkyLines)

    with app.app_context():
        clean_db()
        yield db.session
        db.session.rollback()

(https://github.com/skylines-project/skylines/blob/master/tests/conftest.py#L48)

I think it's helpful too for mentioning about "per test function" and "applied to all test functions" for beginner like me.

Anyway, really appreciate for maintaining this project. It's really awesome !!
(and sorry for my poor English writing)