[Bug] PyTest 시 SQLite table이 생성되지 않는 현상

[Zerohertz]

What happened?

create_all까지 모두 수행은 하지만 PyTest 시 아래 오류 발생

    def run(self) -> None:
        """
        Execute function calls on a separate thread.
    
        :meta private:
        """
        while True:
            # Continues running until all queue items are processed,
            # even after connection is closed (so we can finalize all
            # futures)
    
            tx_item = self._tx.get()
            if tx_item is _STOP_RUNNING_SENTINEL:
                break
    
            future, function = tx_item
    
            try:
                LOG.debug("executing %s", function)
>               result = function()
E               sqlite3.OperationalError: no such table: user

.venv/lib/python3.12/site-packages/aiosqlite/core.py:115: OperationalError

Relevant log output

platform linux -- Python 3.12.3, pytest-8.3.4, pluggy-1.5.0 -- 
cachedir: .pytest_cache
rootdir: /home/zerohertz/Zerohertz/fastapi-cookbook
configfile: pyproject.toml
plugins: dotenv-0.5.2, anyio-4.8.0, asyncio-0.25.2, Faker-35.0.0, cov-6.0.0
asyncio: mode=Mode.STRICT, asyncio_default_fixture_loop_scope=None
collected 7 items                                                                                                                                                                                                                                                                                              

app/tests/api/v1/test_shields.py::test_jmy PASSED                                                                                                                                                                                                                                                        [ 14%]
app/tests/api/v1/test_users.py::test_crud_user FAILED                                                                                                                                                                                                                                                    [ 28%]
app/tests/services/test_users.py::test_create_user FAILED                                                                                                                                                                                                                                                [ 42%]
app/tests/services/test_users.py::test_get_user FAILED                                                                                                                                                                                                                                                   [ 57%]
app/tests/services/test_users.py::test_put_user FAILED                                                                                                                                                                                                                                                   [ 71%]
app/tests/services/test_users.py::test_patch_user FAILED                                                                                                                                                                                                                                                 [ 85%]
app/tests/services/test_users.py::test_delete_user FAILED   

2025-01-30 05:26:01,881 INFO sqlalchemy.engine.Engine BEGIN (implicit)
2025-01-30 05:26:01,881 INFO sqlalchemy.engine.Engine PRAGMA main.table_info("user")
2025-01-30 05:26:01,881 INFO sqlalchemy.engine.Engine [raw sql] ()
2025-01-30 05:26:01,882 INFO sqlalchemy.engine.Engine PRAGMA temp.table_info("user")
2025-01-30 05:26:01,882 INFO sqlalchemy.engine.Engine [raw sql] ()
2025-01-30 05:26:01,882 INFO sqlalchemy.engine.Engine PRAGMA main.table_info("user")
2025-01-30 05:26:01,882 INFO sqlalchemy.engine.Engine [raw sql] ()
2025-01-30 05:26:01,883 INFO sqlalchemy.engine.Engine PRAGMA temp.table_info("user")
2025-01-30 05:26:01,883 INFO sqlalchemy.engine.Engine [raw sql] ()
2025-01-30 05:26:01,884 INFO sqlalchemy.engine.Engine 
CREATE TABLE user (
	name VARCHAR(255) NOT NULL, 
	email VARCHAR(255) NOT NULL, 
	oauth VARCHAR(255) NOT NULL, 
	password VARCHAR(255), 
	refresh_token VARCHAR(255), 
	github_token VARCHAR(255), 
	id INTEGER NOT NULL, 
	created_at DATETIME NOT NULL, 
	updated_at DATETIME NOT NULL, 
	PRIMARY KEY (id), 
	UNIQUE (name), 
	UNIQUE (email)
)


2025-01-30 05:26:01,884 INFO sqlalchemy.engine.Engine [no key 0.00011s] ()
2025-01-30 05:26:01,884 INFO sqlalchemy.engine.Engine COMMIT

[Zerohertz]

fastapi-cookbook/envs/test.env

Line 16 in 8ae5c48

DB_NAME=":memory:"

SQLite의 :memory:를 사용하지 않고 local storage에 할당해서 사용하면 문제가 해결된다.