F.                                                                       [100%]
=================================== FAILURES ===================================
______________ test_login_budget_shared_between_independent_apps _______________
.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:526: in _prepare_and_execute
    prepared_stmt, attributes = await adapt_connection._prepare(
.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:773: in _prepare
    prepared_stmt = await self._connection.prepare(
.venv/lib/python3.14/site-packages/asyncpg/connection.py:661: in prepare
    return await self._prepare(
.venv/lib/python3.14/site-packages/asyncpg/connection.py:680: in _prepare
    stmt = await self._get_statement(
.venv/lib/python3.14/site-packages/asyncpg/connection.py:466: in _get_statement
    statement = await self._protocol.prepare(
asyncpg/protocol/protocol.pyx:161: in prepare
    ???
E   asyncpg.exceptions.PostgresSyntaxError: syntax error at or near "window"

The above exception was the direct cause of the following exception:
.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py:1967: in _exec_single_context
    self.dialect.do_execute(
.venv/lib/python3.14/site-packages/sqlalchemy/engine/default.py:952: in do_execute
    cursor.execute(statement, parameters)
.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:585: in execute
    self._adapt_connection.await_(
.venv/lib/python3.14/site-packages/sqlalchemy/util/_concurrency_py3k.py:132: in await_only
    return current.parent.switch(awaitable)  # type: ignore[no-any-return,attr-defined] # noqa: E501
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
.venv/lib/python3.14/site-packages/sqlalchemy/util/_concurrency_py3k.py:196: in greenlet_spawn
    value = await result
            ^^^^^^^^^^^^
.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:563: in _prepare_and_execute
    self._handle_exception(error)
.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:513: in _handle_exception
    self._adapt_connection._handle_exception(error)
.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:797: in _handle_exception
    raise translated_error from error
E   sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_dbapi.ProgrammingError: <class 'asyncpg.exceptions.PostgresSyntaxError'>: syntax error at or near "window"

The above exception was the direct cause of the following exception:
student-tests/adapters/test_login_protection.py:20: in test_login_budget_shared_between_independent_apps
    responses = await asyncio.gather(
.venv/lib/python3.14/site-packages/httpx/_client.py:1859: in post
    return await self.request(
.venv/lib/python3.14/site-packages/httpx/_client.py:1540: in request
    return await self.send(request, auth=auth, follow_redirects=follow_redirects)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
.venv/lib/python3.14/site-packages/httpx/_client.py:1629: in send
    response = await self._send_handling_auth(
.venv/lib/python3.14/site-packages/httpx/_client.py:1657: in _send_handling_auth
    response = await self._send_handling_redirects(
.venv/lib/python3.14/site-packages/httpx/_client.py:1694: in _send_handling_redirects
    response = await self._send_single_request(request)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
.venv/lib/python3.14/site-packages/httpx/_client.py:1730: in _send_single_request
    response = await transport.handle_async_request(request)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
.venv/lib/python3.14/site-packages/httpx/_transports/asgi.py:170: in handle_async_request
    await self.app(scope, receive, send)
.venv/lib/python3.14/site-packages/fastapi/applications.py:1163: in __call__
    await super().__call__(scope, receive, send)
.venv/lib/python3.14/site-packages/starlette/applications.py:96: in __call__
    await self.middleware_stack(scope, receive, send)
.venv/lib/python3.14/site-packages/starlette/middleware/errors.py:186: in __call__
    raise exc
.venv/lib/python3.14/site-packages/starlette/middleware/errors.py:164: in __call__
    await self.app(scope, receive, _send)
.venv/lib/python3.14/site-packages/dishka/integrations/starlette.py:68: in __call__
    return await self.app(scope, receive, send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
src/messenger/shared/entrypoints/pipeline.py:163: in __call__
    rejection = await self._guard(scope) or self._oversized(scope, limit)
                ^^^^^^^^^^^^^^^^^^^^^^^^
src/messenger/identity/entrypoints/authentication.py:69: in guard
    user = await verify(*credentials) if credentials else None
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
src/messenger/identity/application/queries.py:41: in __call__
    if self._maintenance and (retry := await self._maintenance.consume()):
                                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
src/messenger/identity/infrastructure/login_protection.py:46: in consume
    await session.execute(statement, {"window": self._window, "limit": self._limit})
.venv/lib/python3.14/site-packages/sqlalchemy/ext/asyncio/session.py:449: in execute
    result = await greenlet_spawn(
.venv/lib/python3.14/site-packages/sqlalchemy/util/_concurrency_py3k.py:201: in greenlet_spawn
    result = context.throw(*sys.exc_info())
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
.venv/lib/python3.14/site-packages/sqlalchemy/orm/session.py:2351: in execute
    return self._execute_internal(
.venv/lib/python3.14/site-packages/sqlalchemy/orm/session.py:2258: in _execute_internal
    result = conn.execute(
.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py:1419: in execute
    return meth(
.venv/lib/python3.14/site-packages/sqlalchemy/sql/elements.py:527: in _execute_on_connection
    return connection._execute_clauseelement(
.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py:1641: in _execute_clauseelement
    ret = self._execute_context(
.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py:1846: in _execute_context
    return self._exec_single_context(
.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py:1986: in _exec_single_context
    self._handle_dbapi_exception(
.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py:2363: in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
.venv/lib/python3.14/site-packages/sqlalchemy/engine/base.py:1967: in _exec_single_context
    self.dialect.do_execute(
.venv/lib/python3.14/site-packages/sqlalchemy/engine/default.py:952: in do_execute
    cursor.execute(statement, parameters)
.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:585: in execute
    self._adapt_connection.await_(
.venv/lib/python3.14/site-packages/sqlalchemy/util/_concurrency_py3k.py:132: in await_only
    return current.parent.switch(awaitable)  # type: ignore[no-any-return,attr-defined] # noqa: E501
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
.venv/lib/python3.14/site-packages/sqlalchemy/util/_concurrency_py3k.py:196: in greenlet_spawn
    value = await result
            ^^^^^^^^^^^^
.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:563: in _prepare_and_execute
    self._handle_exception(error)
.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:513: in _handle_exception
    self._adapt_connection._handle_exception(error)
.venv/lib/python3.14/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:797: in _handle_exception
    raise translated_error from error
E   sqlalchemy.exc.ProgrammingError: (sqlalchemy.dialects.postgresql.asyncpg.ProgrammingError) <class 'asyncpg.exceptions.PostgresSyntaxError'>: syntax error at or near "window"
E   [SQL: 
E               INSERT INTO login_budget (id, window, attempts)
E               VALUES (1, floor(extract(epoch FROM statement_timestamp()) / $1), 1)
E               ON CONFLICT (id) DO UPDATE SET
E                   window = EXCLUDED.window,
E                   attempts = CASE WHEN login_budget.window = EXCLUDED.window
E                       THEN login_budget.attempts + 1 ELSE 1 END
E               WHERE login_budget.window <> EXCLUDED.window OR login_budget.attempts < $2
E               RETURNING attempts
E           ]
E   [SQL parameters hidden due to hide_parameters=True]
E   (Background on this error at: https://sqlalche.me/e/20/f405)
=========================== short test summary info ============================
FAILED student-tests/adapters/test_login_protection.py::test_login_budget_shared_between_independent_apps
1 failed, 1 passed in 1.95s
