Class Name (`TestCase`) Conflict With `pytest`? #13558

YTKme · 2025-06-23T23:43:14Z

YTKme
Jun 23, 2025

Hello All,

I am currently using pytest and SQLAlchemy for testing. I am getting an error column test_case.name does not exist with my TestCase model. I was wondering if there's a conflict in class name calling the model in SQLAlchemy TestCase?

Model

class TestCase(Base):
    __tablename__ = "test_case"

    id: Mapped[uuid.UUID] = mapped_column(
        Uuid,
        # default=uuid.uuid4,
        server_default=text("gen_random_uuid()"),
        primary_key=True,
        unique=True
    )
    name: Mapped[str] = mapped_column(
        TEXT(collation="unicode"),
    )

    test_run_list: Mapped[List["TestRun"]] = relationship(
        # cascade="all, delete",
        backref="test_case",
        # passive_deletes=True,
    )

    def __repr__(self):
        return (
            f"<TestCase(id={self.id}, "
            f"test_case_name={self.name})>"
        )

Fetch Function

async def fetch_database_test_case_by_name(
    async_session: async_sessionmaker[AsyncSession],
    name: str,
) -> TestCase | None:

    async with async_session() as session:
        async with session.begin():
            try:
                statement = select(TestCase).where(TestCase.name == name)
                database_logger.debug(f"Statement: {statement}")
                result = await session.execute(statement)
                database_logger.debug(f"Result: {result}")
                result_test_case = result.scalar_one_or_none()
            except NoResultFound as error:
                database_logger.error(f"No Result Found for Test Case: {name}")
                database_logger.error(f"Error: {error}")

    return result_test_case

YTKme · 2025-06-23T23:44:18Z

YTKme
Jun 23, 2025
Author

Here is the traceback

INTERNALERROR> Traceback (most recent call last):
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 521, in _prepare_and_execute
INTERNALERROR>     prepared_stmt, attributes = await adapt_connection._prepare(
INTERNALERROR>                                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 768, in _prepare
INTERNALERROR>     prepared_stmt = await self._connection.prepare(
INTERNALERROR>                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/asyncpg/connection.py", line 635, in prepare
INTERNALERROR>     return await self._prepare(
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/asyncpg/connection.py", line 653, in _prepare
INTERNALERROR>     stmt = await self._get_statement(
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/asyncpg/connection.py", line 432, in _get_statement
INTERNALERROR>     statement = await self._protocol.prepare(
INTERNALERROR>                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "asyncpg/protocol/protocol.pyx", line 165, in prepare
INTERNALERROR> asyncpg.exceptions.UndefinedColumnError: column test_case.name does not exist
INTERNALERROR>
INTERNALERROR> The above exception was the direct cause of the following exception:
INTERNALERROR>
INTERNALERROR> Traceback (most recent call last):
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1963, in _exec_single_context
INTERNALERROR>     self.dialect.do_execute(
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 943, in do_execute
INTERNALERROR>     cursor.execute(statement, parameters)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 580, in execute
INTERNALERROR>     self._adapt_connection.await_(
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only
INTERNALERROR>     return current.parent.switch(awaitable)  # type: ignore[no-any-return,attr-defined] # noqa: E501
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn
INTERNALERROR>     value = await result
INTERNALERROR>             ^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 558, in _prepare_and_execute
INTERNALERROR>     self._handle_exception(error)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 508, in _handle_exception
INTERNALERROR>     self._adapt_connection._handle_exception(error)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 792, in _handle_exception
INTERNALERROR>     raise translated_error from error
INTERNALERROR> sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_dbapi.ProgrammingError: <class 'asyncpg.exceptions.UndefinedColumnError'>: column test_case.name does not exist
INTERNALERROR>
INTERNALERROR> The above exception was the direct cause of the following exception:
INTERNALERROR>
INTERNALERROR> Traceback (most recent call last):
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/main.py", line 289, in wrap_session
INTERNALERROR>     session.exitstatus = doit(config, session) or 0
INTERNALERROR>                          ^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/main.py", line 343, in _main
INTERNALERROR>     config.hook.pytest_runtestloop(session=session)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_hooks.py", line 512, in __call__
INTERNALERROR>     return self._hookexec(self.name, self._hookimpls.copy(), kwargs, firstresult)
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_manager.py", line 120, in _hookexec
INTERNALERROR>     return self._inner_hookexec(hook_name, methods, kwargs, firstresult)
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 167, in _multicall
INTERNALERROR>     raise exception
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 139, in _multicall
INTERNALERROR>     teardown.throw(exception)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/logging.py", line 801, in pytest_runtestloop
INTERNALERROR>     return (yield)  # Run all the tests.
INTERNALERROR>             ^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 139, in _multicall
INTERNALERROR>     teardown.throw(exception)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/terminal.py", line 688, in pytest_runtestloop
INTERNALERROR>     result = yield
INTERNALERROR>              ^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 121, in _multicall
INTERNALERROR>     res = hook_impl.function(*args)
INTERNALERROR>           ^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/main.py", line 367, in pytest_runtestloop
INTERNALERROR>     item.config.hook.pytest_runtest_protocol(item=item, nextitem=nextitem)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_hooks.py", line 512, in __call__
INTERNALERROR>     return self._hookexec(self.name, self._hookimpls.copy(), kwargs, firstresult)
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_manager.py", line 120, in _hookexec
INTERNALERROR>     return self._inner_hookexec(hook_name, methods, kwargs, firstresult)
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 167, in _multicall
INTERNALERROR>     raise exception
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 139, in _multicall
INTERNALERROR>     teardown.throw(exception)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/warnings.py", line 90, in pytest_runtest_protocol
INTERNALERROR>     return (yield)
INTERNALERROR>             ^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 139, in _multicall
INTERNALERROR>     teardown.throw(exception)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/assertion/__init__.py", line 192, in pytest_runtest_protocol
INTERNALERROR>     return (yield)
INTERNALERROR>             ^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 139, in _multicall
INTERNALERROR>     teardown.throw(exception)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/unittest.py", line 475, in pytest_runtest_protocol
INTERNALERROR>     return (yield)
INTERNALERROR>             ^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 139, in _multicall
INTERNALERROR>     teardown.throw(exception)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/faulthandler.py", line 88, in pytest_runtest_protocol
INTERNALERROR>     return (yield)
INTERNALERROR>             ^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 121, in _multicall
INTERNALERROR>     res = hook_impl.function(*args)
INTERNALERROR>           ^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/runner.py", line 117, in pytest_runtest_protocol
INTERNALERROR>     runtestprotocol(item, nextitem=nextitem)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/runner.py", line 130, in runtestprotocol
INTERNALERROR>     rep = call_and_report(item, "setup", log)
INTERNALERROR>           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/runner.py", line 248, in call_and_report
INTERNALERROR>     report: TestReport = ihook.pytest_runtest_makereport(item=item, call=call)
INTERNALERROR>                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_hooks.py", line 512, in __call__
INTERNALERROR>     return self._hookexec(self.name, self._hookimpls.copy(), kwargs, firstresult)
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_manager.py", line 120, in _hookexec
INTERNALERROR>     return self._inner_hookexec(hook_name, methods, kwargs, firstresult)
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 167, in _multicall
INTERNALERROR>     raise exception
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 139, in _multicall
INTERNALERROR>     teardown.throw(exception)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/_pytest/tmpdir.py", line 308, in pytest_runtest_makereport
INTERNALERROR>     rep = yield
INTERNALERROR>           ^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 107, in _multicall
INTERNALERROR>     next(function_gen)  # first yield
INTERNALERROR>     ^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/pluggy/_callers.py", line 34, in run_old_style_hookwrapper
INTERNALERROR>     next(teardown)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Repository/Alpha/Beta/borealis-test/test/conftest.py", line 762, in pytest_runtest_makereport
INTERNALERROR>     test_case = asyncio.run(fetch_database_test_case_by_name(
INTERNALERROR>                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/opt/python/substance3d_scene_automation_130_m_1344/lib/python3.11/asyncio/runners.py", line 190, in run
INTERNALERROR>     return runner.run(main)
INTERNALERROR>            ^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/opt/python/substance3d_scene_automation_130_m_1344/lib/python3.11/asyncio/runners.py", line 118, in run
INTERNALERROR>     return self._loop.run_until_complete(task)
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/opt/python/substance3d_scene_automation_130_m_1344/lib/python3.11/asyncio/base_events.py", line 653, in run_until_complete
INTERNALERROR>     return future.result()
INTERNALERROR>            ^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Repository/Alpha/Beta/borealis-test/test/database.py", line 310, in fetch_database_test_case_by_name
INTERNALERROR>     result = await session.execute(statement)
INTERNALERROR>              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/ext/asyncio/session.py", line 463, in execute
INTERNALERROR>     result = await greenlet_spawn(
INTERNALERROR>              ^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 201, in greenlet_spawn
INTERNALERROR>     result = context.throw(*sys.exc_info())
INTERNALERROR>              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2365, in execute
INTERNALERROR>     return self._execute_internal(
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2251, in _execute_internal
INTERNALERROR>     result: Result[Any] = compile_state_cls.orm_execute_statement(
INTERNALERROR>                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 306, in orm_execute_statement
INTERNALERROR>     result = conn.execute(
INTERNALERROR>              ^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1415, in execute
INTERNALERROR>     return meth(
INTERNALERROR>            ^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 523, in _execute_on_connection
INTERNALERROR>     return connection._execute_clauseelement(
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1637, in _execute_clauseelement
INTERNALERROR>     ret = self._execute_context(
INTERNALERROR>           ^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context
INTERNALERROR>     return self._exec_single_context(
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1982, in _exec_single_context
INTERNALERROR>     self._handle_dbapi_exception(
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2351, in _handle_dbapi_exception
INTERNALERROR>     raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1963, in _exec_single_context
INTERNALERROR>     self.dialect.do_execute(
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 943, in do_execute
INTERNALERROR>     cursor.execute(statement, parameters)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 580, in execute
INTERNALERROR>     self._adapt_connection.await_(
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only
INTERNALERROR>     return current.parent.switch(awaitable)  # type: ignore[no-any-return,attr-defined] # noqa: E501
INTERNALERROR>            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn
INTERNALERROR>     value = await result
INTERNALERROR>             ^^^^^^^^^^^^
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 558, in _prepare_and_execute
INTERNALERROR>     self._handle_exception(error)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 508, in _handle_exception
INTERNALERROR>     self._adapt_connection._handle_exception(error)
INTERNALERROR>   File "/Users/yk/Desktop/Project/Workspace/Python/pv311-ssca-130-m-1344/lib/python3.11/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 792, in _handle_exception
INTERNALERROR>     raise translated_error from error
INTERNALERROR> sqlalchemy.exc.ProgrammingError: (sqlalchemy.dialects.postgresql.asyncpg.ProgrammingError) <class 'asyncpg.exceptions.UndefinedColumnError'>: column test_case.name does not exist
INTERNALERROR> [SQL: SELECT test_case.id, test_case.name
INTERNALERROR> FROM test_case
INTERNALERROR> WHERE test_case.name = $1::VARCHAR COLLATE "unicode"]
INTERNALERROR> [parameters: ('test_ssca_compare_base',)]
INTERNALERROR> (Background on this error at: https://sqlalche.me/e/20/f405)

0 replies

RonnyPfannschmidt · 2025-06-24T04:31:06Z

RonnyPfannschmidt
Jun 24, 2025
Maintainer

At first glance the error is completely unrelated to pytest

How do you create/ migrate your database

Do you import all models before creating it?

3 replies

YTKme Jun 24, 2025
Author

Thank you @RonnyPfannschmidt, yes, it probably might be, but wanted to get other opinions since I am not sure.

The seeding script seeds the database fine, so I am assuming it is not SQLAlchemy.

I know Python unittest have a TestCase class, but not sure if that's causing conflict also? But I am not importing anything related to other TestCase class.

i have a seeding script for each model, essentially is the below

import database
from model import Base
from model import Asset
from model import Project
from model import Platform
from model import Reference
from model import TestCase

TEST_CASE_LIST = [
    TestCase(
        name="test_compare_base",
    )
]

...

async with async_session() as session:
    async with session.begin():
        session.add_all(TEST_CASE_LIST)

...

RonnyPfannschmidt Jun 24, 2025
Maintainer

Nothing in the shown code suggests such a problem

RonnyPfannschmidt Jun 24, 2025
Maintainer

I recommend validation of the database creation

The name in the repr is different from the name of the field

That indicates the possibility of a python field name change that wasn't put into a migration

mrbean-bremen · 2025-06-24T04:59:12Z

mrbean-bremen
Jun 24, 2025
Collaborator

The error message is

column test_case.name does not exist

I'm not very familiar with SQLAlchemy, but are you sure that your model has a name entry?

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Uh oh!

Class Name (`TestCase`) Conflict With `pytest`? #13558

Uh oh!

{{title}}

Uh oh!

Replies: 3 comments 3 replies

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Uh oh!

Class Name (TestCase) Conflict With pytest? #13558

Uh oh!

YTKme Jun 23, 2025

Replies: 3 comments · 3 replies

Uh oh!

Uh oh!

YTKme Jun 23, 2025 Author

Uh oh!

RonnyPfannschmidt Jun 24, 2025 Maintainer

Uh oh!

Uh oh!

YTKme Jun 24, 2025 Author

Uh oh!

RonnyPfannschmidt Jun 24, 2025 Maintainer

Uh oh!

RonnyPfannschmidt Jun 24, 2025 Maintainer

Uh oh!

mrbean-bremen Jun 24, 2025 Collaborator

Class Name (`TestCase`) Conflict With `pytest`? #13558

YTKme
Jun 23, 2025

Replies: 3 comments 3 replies

YTKme
Jun 23, 2025
Author

RonnyPfannschmidt
Jun 24, 2025
Maintainer

YTKme Jun 24, 2025
Author

RonnyPfannschmidt Jun 24, 2025
Maintainer

RonnyPfannschmidt Jun 24, 2025
Maintainer

mrbean-bremen
Jun 24, 2025
Collaborator