How to run a test suite with in-memory SQLite?

[gamesbook]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

My code is in this repo: https://github.com/gamesbook/fasttest/

It can be checked out and used. Its essentially a "copy and paste" of the code from the examples in the tutorials but not working "as is".

I'd appreciate knowing what I have missed, as I'd like to get tests working in a similar way for my own project.

Description

The pytest run generates these errors:

======================================================= short test summary info ========================================================
FAILED src/tests/test_api.py::test_create_hero - sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: hero
FAILED src/tests/test_api.py::test_read_heroes - sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: hero
FAILED src/tests/test_api.py::test_read_hero - sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: hero
===================================================== 3 failed, 2 passed in 1.51s =====================================================

Operating System

Linux

Operating System Details

No response

SQLModel Version

0.0.8

Python Version

Python 3.11.4

Additional Context

No response