Created At: 2026-11-18T06:19:31Z Completed At: 2026-11-18T06:19:39Z Command exited with code 1. Command output: ============================= test session starts ============================== platform linux -- Python 3.12.3, pytest-9.2.0, pluggy-1.7.0 -- /root/telegram-saas/.venv/bin/python3 cachedir: .pytest_cache rootdir: /root/telegram-saas configfile: pyproject.toml testpaths: tests plugins: anyio-4.16.0, asyncio-1.5.0 asyncio: mode=Mode.AUTO, debug=False, asyncio_default_fixture_loop_scope=function, asyncio_default_test_loop_scope=function collecting ... collected 33 items tests/integration/test_auth.py::test_auth_workflow PASSED [ 3%] tests/integration/test_emojis_api.py::test_search_emojis_by_term PASSED [ 6%] tests/integration/test_emojis_api.py::test_search_emojis_by_category PASSED [ 9%] tests/integration/test_emojis_api.py::test_get_categories_list PASSED [ 12%] tests/integration/test_health.py::test_health_liveness PASSED [ 15%] tests/integration/test_health.py::test_health_readiness PASSED [ 18%] tests/integration/test_i18n_api.py::test_get_locales_list PASSED [ 21%] tests/integration/test_i18n_api.py::test_get_translation_bundle PASSED [ 24%] tests/integration/test_i18n_api.py::test_update_user_locale PASSED [ 27%] tests/integration/test_i18n_api.py::test_save_custom_translation_override PASSED [ 30%] tests/integration/test_message_studio_api.py::test_bot_message_studio_lifecycle FAILED [ 33%] tests/tenant_isolation/test_tenant_isolation.py::test_strict_tenant_isolation PASSED [ 36%] tests/unit/test_emojis.py::test_telegram_html_emoji_formatting PASSED [ 39%] tests/unit/test_emojis.py::test_telegram_markdown_emoji_formatting PASSED [ 42%] tests/unit/test_emojis.py::test_id_precision_is_preserved_as_string PASSED [ 45%] tests/unit/test_i18n.py::test_supported_locales_catalog PASSED [ 48%] tests/unit/test_i18n.py::test_rtl_detection PASSED [ 51%] tests/unit/test_i18n.py::test_plural_rules PASSED [ 54%] tests/unit/test_i18n.py::test_formatting PASSED [ 57%] tests/unit/test_i18n.py::test_fallback_resolution PASSED [ 60%] tests/unit/test_i18n.py::test_translation_engine PASSED [ 63%] tests/unit/test_i18n.py::test_interpolation PASSED [ 66%] tests/unit/test_i18n.py::test_missing_translation_fallback PASSED [ 69%] tests/unit/test_i18n.py::test_telegram_keyboard_builder PASSED [ 72%] tests/unit/test_message_studio.py::test_variable_interpolation PASSED [ 75%] tests/unit/test_message_studio.py::test_missing_variables_fallback PASSED [ 78%] tests/unit/test_message_studio.py::test_keyboard_matrix_ordering PASSED [ 81%] tests/unit/test_message_studio.py::test_aiogram_keyboard_generation PASSED [ 84%] tests/unit/test_message_studio.py::test_default_system_templates PASSED [ 87%] tests/unit/test_security.py::test_password_hashing PASSED [ 90%] tests/unit/test_security.py::test_aes_256_gcm_encryption PASSED [ 93%] tests/unit/test_security.py::test_jwt_tokens PASSED [ 96%] tests/unit/test_security.py::test_token_hashing PASSED [100%] =================================== FAILURES =================================== ______________________ test_bot_message_studio_lifecycle _______________________ self = operation = 'INSERT INTO bot_message_versions (id, template_id, version, snapshot_json, updated_by, created_at) VALUES ($1::UUID, $2::UUID, $3::INTEGER, $4::JSONB, $5::UUID, $6::TIMESTAMP WITH TIME ZONE)' parameters = (UUID('c3a1197d-8093-4dca-a6f2-7cfa6adaa67c'), UUID('3caec20e-71d3-4aa5-86ad-0aa99f922e3a'), 1, '{"message_key": "welc...531aa0-7cda-4fc7-8d26-292f6356381c'), datetime.datetime(2026, 11, 18, 6, 19, 37, 496071, tzinfo=datetime.timezone.utc)) async def _prepare_and_execute(self, operation, parameters): adapt_connection = self._adapt_connection async with adapt_connection._execute_mutex: if adapt_connection._transaction is None: await adapt_connection._start_transaction() if parameters is None: parameters = () try: prepared_stmt, attributes = await adapt_connection._prepare( operation, self._invalidate_schema_cache_asof ) if attributes: self._description = [ ( attr.name, attr.type.oid, None, None, None, None, None, ) for attr in attributes ] else: self._description = None if self.server_side: self._cursor = await prepared_stmt.cursor(*parameters) self._rowcount = -1 else: > self._rows = deque(await prepared_stmt.fetch(*parameters)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:620: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ .venv/lib/python3.12/site-packages/asyncpg/prepared_stmt.py:177: in fetch data = await self.__bind_execute(args, 0, timeout) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/asyncpg/prepared_stmt.py:268: in __bind_execute data, status, _ = await self.__do_execute( .venv/lib/python3.12/site-packages/asyncpg/prepared_stmt.py:257: in __do_execute return await executor(protocol) ^^^^^^^^^^^^^^^^^^^^^^^^ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ > ??? E asyncpg.exceptions.UntranslatableCharacterError: unsupported Unicode escape sequence E DETAIL: Unicode escape value could not be translated to the server's encoding SQL_ASCII. asyncpg/protocol/protocol.pyx:197: UntranslatableCharacterError The above exception was the direct cause of the following exception: self = dialect = context = statement = parameters = [(UUID('c3a1197d-8093-4dca-a6f2-7cfa6adaa67c'), UUID('3caec20e-71d3-4aa5-86ad-0aa99f922e3a'), 1, '{"message_key": "wel...31aa0-7cda-4fc7-8d26-292f6356381c'), datetime.datetime(2026, 11, 18, 6, 19, 37, 496071, tzinfo=datetime.timezone.utc))] def _exec_single_context( self, dialect: Dialect, context: ExecutionContext, statement: Union[str, Compiled], parameters: Optional[_AnyMultiExecuteParams], ) -> CursorResult[Unpack[TupleAny]]: """continue the _execute_context() method for a single DBAPI cursor.execute() or cursor.executemany() call. """ if dialect.bind_typing is BindTyping.SETINPUTSIZES: generic_setinputsizes = context._prepare_set_input_sizes() if generic_setinputsizes: try: dialect.do_set_input_sizes( context.cursor, generic_setinputsizes, context ) except BaseException as e: self._handle_dbapi_exception( e, str(statement), parameters, None, context ) cursor, str_statement, parameters = ( context.cursor, context.statement, context.parameters, ) effective_parameters: Optional[_AnyExecuteParams] if not context.executemany: effective_parameters = parameters[0] else: effective_parameters = parameters evt_handled: bool = False try: if self._has_events or self.engine._has_events: for fn in self.dispatch.before_cursor_execute: str_statement, effective_parameters = fn( self, cursor, str_statement, effective_parameters, context, context.executemany, ) if self._echo: self._log_info(str_statement) stats = context._get_cache_stats() self._log_parameters( effective_parameters, stats, ismulti=context.executemany ) if context.execute_style is ExecuteStyle.EXECUTEMANY: effective_parameters = cast( "_CoreMultiExecuteParams", effective_parameters ) if self.dialect._has_events: for fn in self.dialect.dispatch.do_executemany: if fn( cursor, str_statement, effective_parameters, context, ): evt_handled = True break if not evt_handled: self.dialect.do_executemany( cursor, str_statement, effective_parameters, context, ) elif not effective_parameters and context.no_parameters: if self.dialect._has_events: for fn in self.dialect.dispatch.do_execute_no_params: if fn(cursor, str_statement, context): evt_handled = True break if not evt_handled: self.dialect.do_execute_no_params( cursor, str_statement, context ) else: effective_parameters = cast( "_CoreSingleExecuteParams", effective_parameters ) if self.dialect._has_events: for fn in self.dialect.dispatch.do_execute: if fn( cursor, str_statement, effective_parameters, context, ): evt_handled = True break if not evt_handled: > self.dialect.do_execute( cursor, str_statement, effective_parameters, context ) .venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py:1977: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ .venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py:1192: in do_execute cursor.execute(statement, parameters) .venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:671: in execute await_(self._prepare_and_execute(operation, parameters)) .venv/lib/python3.12/site-packages/sqlalchemy/util/concurrency.py:171: in await_ return current.parent.switch(awaitable) # type: ignore[no-any-return] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/sqlalchemy/util/concurrency.py:209: in greenlet_spawn value = await result ^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:633: in _prepare_and_execute self._handle_exception(error) .venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:583: in _handle_exception self._adapt_connection._handle_exception(error) .venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:862: in _handle_exception super()._handle_exception(error) .venv/lib/python3.12/site-packages/sqlalchemy/connectors/asyncio.py:412: in _handle_exception self._handle_exception_no_connection(self.dbapi, error) _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ cls = dbapi = error = UntranslatableCharacterError('unsupported Unicode escape sequence') @classmethod def _handle_exception_no_connection( cls, dbapi: Any, error: Exception ) -> NoReturn: if not isinstance(error, AsyncAdapt_asyncpg_dbapi.Error): exception_mapping = dbapi._asyncpg_error_translate for super_ in type(error).__mro__: if super_ in exception_mapping: message = error.args[0] translated_error = exception_mapping[super_]( message, error ) > raise translated_error from error E sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_dbapi.Error: unsupported Unicode escape sequence .venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:855: Error The above exception was the direct cause of the following exception: async_client = db_session = @pytest.mark.asyncio async def test_bot_message_studio_lifecycle(async_client: AsyncClient, db_session: AsyncSession): # 1. Setup User A & Tenant A user_a_email = f"user_studio_{uuid.uuid4().hex[:6]}@example.com" resp_a = await async_client.post( "/api/v1/auth/register", json={"email": user_a_email, "password": "PasswordA123!", "full_name": "Studio Master"}, ) token_a = resp_a.json()["data"]["access_token"] tenant_resp = await async_client.post( "/api/v1/tenants", headers={"Authorization": f"Bearer {token_a}"}, json={"name": "Studio Tenant", "slug": f"studio-{uuid.uuid4().hex[:6]}"}, ) tenant_id = tenant_resp.json()["data"]["id"] headers_a = { "Authorization": f"Bearer {token_a}", "X-Tenant-ID": str(tenant_id), } # 2. Insert Bot A & Bot B into database for Tenant A bot_a = Bot( tenant_id=uuid.UUID(tenant_id), name="Business Bot A", username=f"biz_bot_a_{uuid.uuid4().hex[:6]}", status="active", default_locale="en", ) bot_b = Bot( tenant_id=uuid.UUID(tenant_id), name="Business Bot B", username=f"biz_bot_b_{uuid.uuid4().hex[:6]}", status="active", default_locale="en", ) db_session.add(bot_a) db_session.add(bot_b) await db_session.commit() await db_session.refresh(bot_a) await db_session.refresh(bot_b) bot_a_id = str(bot_a.id) bot_b_id = str(bot_b.id) # 3. Create a Message Template with Buttons create_payload = { "message_key": "welcome", "title": "Main Welcome Screen", "message_text": "🙏 Welcome, {first_name}!\n\nWelcome to our VIP club. Choose below:", "parse_mode": "HTML", "media_type": "none", "locale": "en", "is_active": True, "is_draft": False, "buttons": [ { "text": "💎 Buy Premium", "button_type": "callback_data", "action_value": "act:buy_premium", "row_position": 0, "column_position": 0, "sort_order": 0, }, { "text": "👤 My Account", "button_type": "callback_data", "action_value": "act:account", "row_position": 1, "column_position": 0, "sort_order": 0, }, { "text": "📞 Support", "button_type": "callback_data", "action_value": "act:support", "row_position": 1, "column_position": 1, "sort_order": 1, }, ], } > post_resp = await async_client.post( f"/api/v1/bots/{bot_a_id}/messages", headers=headers_a, json=create_payload, ) tests/integration/test_message_studio_api.py:91: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ .venv/lib/python3.12/site-packages/httpx/_client.py:1859: in post return await self.request( .venv/lib/python3.12/site-packages/httpx/_client.py:1540: in request return await self.send(request, auth=auth, follow_redirects=follow_redirects) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/httpx/_client.py:1629: in send response = await self._send_handling_auth( .venv/lib/python3.12/site-packages/httpx/_client.py:1657: in _send_handling_auth response = await self._send_handling_redirects( .venv/lib/python3.12/site-packages/httpx/_client.py:1694: in _send_handling_redirects response = await self._send_single_request(request) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/httpx/_client.py:1730: in _send_single_request response = await transport.handle_async_request(request) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/httpx/_transports/asgi.py:170: in handle_async_request await self.app(scope, receive, send) .venv/lib/python3.12/site-packages/fastapi/applications.py:1194: in __call__ await super().__call__(scope, receive, send) .venv/lib/python3.12/site-packages/starlette/applications.py:96: in __call__ await self.middleware_stack(scope, receive, send) .venv/lib/python3.12/site-packages/starlette/middleware/errors.py:186: in __call__ raise exc .venv/lib/python3.12/site-packages/starlette/middleware/errors.py:164: in __call__ await self.app(scope, receive, _send) .venv/lib/python3.12/site-packages/fastapi/telemetry/_asgi.py:151: in __call__ await self.app(scope, receive, send) .venv/lib/python3.12/site-packages/starlette/middleware/base.py:203: in __call__ response = await self.dispatch_func(request, call_next) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ apps/api/main.py:53: in request_context_middleware response = await call_next(request) ^^^^^^^^^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/starlette/middleware/base.py:179: in call_next raise app_exc from app_exc.__cause__ or app_exc.__context__ .venv/lib/python3.12/site-packages/starlette/middleware/base.py:149: in coro await self.app(scope, receive_or_disconnect, send_no_error) .venv/lib/python3.12/site-packages/starlette/middleware/base.py:203: in __call__ response = await self.dispatch_func(request, call_next) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ modules/i18n/middleware.py:24: in dispatch response = await call_next(request) ^^^^^^^^^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/starlette/middleware/base.py:179: in call_next raise app_exc from app_exc.__cause__ or app_exc.__context__ .venv/lib/python3.12/site-packages/starlette/middleware/base.py:149: in coro await self.app(scope, receive_or_disconnect, send_no_error) .venv/lib/python3.12/site-packages/starlette/middleware/cors.py:91: in __call__ await self.simple_response(scope, receive, send, request_headers=headers) .venv/lib/python3.12/site-packages/starlette/middleware/cors.py:149: in simple_response await self.app(scope, receive, send) .venv/lib/python3.12/site-packages/starlette/middleware/exceptions.py:63: in __call__ await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send) .venv/lib/python3.12/site-packages/starlette/_exception_handler.py:53: in wrapped_app raise exc .venv/lib/python3.12/site-packages/starlette/_exception_handler.py:42: in wrapped_app await app(scope, receive, sender) .venv/lib/python3.12/site-packages/fastapi/middleware/asyncexitstack.py:18: in __call__ await self.app(scope, receive, send) .venv/lib/python3.12/site-packages/starlette/routing.py:683: in __call__ await self.middleware_stack(scope, receive, send) .venv/lib/python3.12/site-packages/fastapi/routing.py:2811: in app await route.handle(scope, receive, send) .venv/lib/python3.12/site-packages/fastapi/routing.py:1839: in handle await self.original_router.handle(scope, receive, send) .venv/lib/python3.12/site-packages/fastapi/routing.py:2894: in handle await included_router._handle_selected(scope, receive, send) .venv/lib/python3.12/site-packages/fastapi/routing.py:1850: in _handle_selected await route.handle(scope, receive, send) .venv/lib/python3.12/site-packages/fastapi/routing.py:1839: in handle await self.original_router.handle(scope, receive, send) .venv/lib/python3.12/site-packages/fastapi/routing.py:2894: in handle await included_router._handle_selected(scope, receive, send) .venv/lib/python3.12/site-packages/fastapi/routing.py:1865: in _handle_selected await original_route.handle(scope, receive, send) .venv/lib/python3.12/site-packages/fastapi/routing.py:1328: in handle await effective_context.app(scope, receive, send) .venv/lib/python3.12/site-packages/fastapi/routing.py:166: in app await wrap_app_handling_exceptions(app, request)(scope, receive, send) .venv/lib/python3.12/site-packages/starlette/_exception_handler.py:53: in wrapped_app raise exc .venv/lib/python3.12/site-packages/starlette/_exception_handler.py:42: in wrapped_app await app(scope, receive, sender) .venv/lib/python3.12/site-packages/fastapi/routing.py:152: in app response = await f(request) ^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/fastapi/routing.py:745: in app raw_response = await run_endpoint_function( .venv/lib/python3.12/site-packages/fastapi/routing.py:372: in run_endpoint_function return await dependant.call(**values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ apps/api/routes/message_studio.py:51: in create_bot_message template = await service.create_template( modules/message_studio/service.py:102: in create_template await self.repo.create_version(template, updated_by=user_id) modules/message_studio/repository.py:129: in create_version await self.db.flush() .venv/lib/python3.12/site-packages/sqlalchemy/ext/asyncio/session.py:1031: in flush await greenlet_spawn(self.sync_session.flush, objects=objects) .venv/lib/python3.12/site-packages/sqlalchemy/util/concurrency.py:216: in greenlet_spawn result = context.switch(value) ^^^^^^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py:4626: in flush self._flush(objects) :2: in _flush return target(fn, self, objects=objects) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/sqlalchemy/util/deprecations.py:281: in warned return fn(*args, **kwargs) # type: ignore[no-any-return] ^^^^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py:4769: in _flush with util.safe_reraise(): .venv/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py:166: in __exit__ raise exc_value.with_traceback(exc_tb) .venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py:4730: in _flush flush_context.execute() .venv/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py:467: in execute rec.execute(self) .venv/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py:643: in execute util.preloaded.orm_persistence._save_obj( .venv/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py:92: in _save_obj _emit_insert_statements( .venv/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py:1250: in _emit_insert_statements result = connection.execute( .venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py:1494: in execute return meth( .venv/lib/python3.12/site-packages/sqlalchemy/sql/elements.py:534: in _execute_on_connection return connection._execute_clauseelement( .venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py:1714: in _execute_clauseelement ret = self._execute_context( .venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py:1868: in _execute_context return self._exec_single_context( .venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py:1996: in _exec_single_context self._handle_dbapi_exception( .venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py:2351: in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e .venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py:1977: in _exec_single_context self.dialect.do_execute( .venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py:1192: in do_execute cursor.execute(statement, parameters) .venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:671: in execute await_(self._prepare_and_execute(operation, parameters)) .venv/lib/python3.12/site-packages/sqlalchemy/util/concurrency.py:171: in await_ return current.parent.switch(awaitable) # type: ignore[no-any-return] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/sqlalchemy/util/concurrency.py:209: in greenlet_spawn value = await result ^^^^^^^^^^^^ .venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:633: in _prepare_and_execute self._handle_exception(error) .venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:583: in _handle_exception self._adapt_connection._handle_exception(error) .venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:862: in _handle_exception super()._handle_exception(error) .venv/lib/python3.12/site-packages/sqlalchemy/connectors/asyncio.py:412: in _handle_exception self._handle_exception_no_connection(self.dbapi, error) _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ cls = dbapi = error = UntranslatableCharacterError('unsupported Unicode escape sequence') @classmethod def _handle_exception_no_connection( cls, dbapi: Any, error: Exception ) -> NoReturn: if not isinstance(error, AsyncAdapt_asyncpg_dbapi.Error): exception_mapping = dbapi._asyncpg_error_translate for super_ in type(error).__mro__: if super_ in exception_mapping: message = error.args[0] translated_error = exception_mapping[super_]( message, error ) > raise translated_error from error E sqlalchemy.exc.DBAPIError: (sqlalchemy.dialects.postgresql.asyncpg.Error) unsupported Unicode escape sequence E [SQL: INSERT INTO bot_message_versions (id, template_id, version, snapshot_json, updated_by, created_at) VALUES ($1::UUID, $2::UUID, $3::INTEGER, $4::JSONB, $5::UUID, $6::TIMESTAMP WITH TIME ZONE)] E [parameters: (UUID('c3a1197d-8093-4dca-a6f2-7cfa6adaa67c'), UUID('3caec20e-71d3-4aa5-86ad-0aa99f922e3a'), 1, '{"message_key": "welcome", "title": "Main Welcome Screen", "message_text": "\\ud83d\\ude4f Welcome, {first_name}!\\n\\nWelcome to our VIP club. Choos ... (477 characters truncated) ... "\\ud83d\\udcde Support", "button_type": "callback_data", "action_value": "act:support", "row_position": 1, "column_position": 1, "sort_order": 1}]}', UUID('a0531aa0-7cda-4fc7-8d26-292f6356381c'), datetime.datetime(2026, 11, 18, 6, 19, 37, 496071, tzinfo=datetime.timezone.utc))] E (Background on this error at: https://sqlalche.me/e/21/dbapi) .venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py:855: DBAPIError ----------------------------- Captured stdout call ----------------------------- 2026-11-18 06:19:37 [info ] dispatching_domain_event event_id=17513c5a-ee1e-48ee-bdf4-e163c9762afd event_type=UserRegisteredEvent handlers_count=0 2026-11-18 06:19:37 [info ] dispatching_domain_event event_id=512d5d6e-91a2-44a6-9d54-e6d7fff9fe8f event_type=TenantCreatedEvent handlers_count=0 2026-11-18 06:19:37 [error ] unhandled_server_error error='(sqlalchemy.dialects.postgresql.asyncpg.Error) unsupported Unicode escape sequence\n[SQL: INSERT INTO bot_message_versions (id, template_id, version, snapshot_json, updated_by, created_at) VALUES ($1::UUID, $2::UUID, $3::INTEGER, $4::JSONB, $5::UUID, $6::TIMESTAMP WITH TIME ZONE)]\n[parameters: (UUID(\'c3a1197d-8093-4dca-a6f2-7cfa6adaa67c\'), UUID(\'3caec20e-71d3-4aa5-86ad-0aa99f922e3a\'), 1, \'{"message_key": "welcome", "title": "Main Welcome Screen", "message_text": "\\\\ud83d\\\\ude4f Welcome, {first_name}!\\\\n\\\\nWelcome to our VIP club. Choos ... (477 characters truncated) ... "\\\\ud83d\\\\udcde Support", "button_type": "callback_data", "action_value": "act:support", "row_position": 1, "column_position": 1, "sort_order": 1}]}\', UUID(\'a0531aa0-7cda-4fc7-8d26-292f6356381c\'), datetime.datetime(2026, 11, 18, 6, 19, 37, 496071, tzinfo=datetime.timezone.utc))]\n(Background on this error at: https://sqlalche.me/e/21/dbapi)' method=POST path=/api/v1/bots/6592350a-72da-4bc1-bff1-083415c80b7a/messages Traceback (most recent call last): File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 620, in _prepare_and_execute self._rows = deque(await prepared_stmt.fetch(*parameters)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/asyncpg/prepared_stmt.py", line 177, in fetch data = await self.__bind_execute(args, 0, timeout) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/asyncpg/prepared_stmt.py", line 268, in __bind_execute data, status, _ = await self.__do_execute( ^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/asyncpg/prepared_stmt.py", line 257, in __do_execute return await executor(protocol) ^^^^^^^^^^^^^^^^^^^^^^^^ File "asyncpg/protocol/protocol.pyx", line 197, in bind_execute asyncpg.exceptions.UntranslatableCharacterError: unsupported Unicode escape sequence DETAIL: Unicode escape value could not be translated to the server's encoding SQL_ASCII. The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1977, in _exec_single_context self.dialect.do_execute( File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 1192, in do_execute cursor.execute(statement, parameters) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 671, in execute await_(self._prepare_and_execute(operation, parameters)) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/util/concurrency.py", line 171, in await_ return current.parent.switch(awaitable) # type: ignore[no-any-return] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/util/concurrency.py", line 209, in greenlet_spawn value = await result ^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 633, in _prepare_and_execute self._handle_exception(error) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 583, in _handle_exception self._adapt_connection._handle_exception(error) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 862, in _handle_exception super()._handle_exception(error) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/connectors/asyncio.py", line 412, in _handle_exception self._handle_exception_no_connection(self.dbapi, error) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 855, in _handle_exception_no_connection raise translated_error from error sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_dbapi.Error: unsupported Unicode escape sequence The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 164, in __call__ await self.app(scope, receive, _send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/telemetry/_asgi.py", line 151, in __call__ await self.app(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 203, in __call__ response = await self.dispatch_func(request, call_next) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/apps/api/main.py", line 53, in request_context_middleware response = await call_next(request) ^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 179, in call_next raise app_exc from app_exc.__cause__ or app_exc.__context__ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 149, in coro await self.app(scope, receive_or_disconnect, send_no_error) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 203, in __call__ response = await self.dispatch_func(request, call_next) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/modules/i18n/middleware.py", line 24, in dispatch response = await call_next(request) ^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 179, in call_next raise app_exc from app_exc.__cause__ or app_exc.__context__ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/middleware/base.py", line 149, in coro await self.app(scope, receive_or_disconnect, send_no_error) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/middleware/cors.py", line 91, in __call__ await self.simple_response(scope, receive, send, request_headers=headers) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/middleware/cors.py", line 149, in simple_response await self.app(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/middleware/exceptions.py", line 63, in __call__ await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app raise exc File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app await app(scope, receive, sender) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/middleware/asyncexitstack.py", line 18, in __call__ await self.app(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/routing.py", line 683, in __call__ await self.middleware_stack(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/routing.py", line 2811, in app await route.handle(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/routing.py", line 1839, in handle await self.original_router.handle(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/routing.py", line 2894, in handle await included_router._handle_selected(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/routing.py", line 1850, in _handle_selected await route.handle(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/routing.py", line 1839, in handle await self.original_router.handle(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/routing.py", line 2894, in handle await included_router._handle_selected(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/routing.py", line 1865, in _handle_selected await original_route.handle(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/routing.py", line 1328, in handle await effective_context.app(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/routing.py", line 166, in app await wrap_app_handling_exceptions(app, request)(scope, receive, send) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app raise exc File "/root/telegram-saas/.venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app await app(scope, receive, sender) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/routing.py", line 152, in app response = await f(request) ^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/routing.py", line 745, in app raw_response = await run_endpoint_function( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/fastapi/routing.py", line 372, in run_endpoint_function return await dependant.call(**values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/apps/api/routes/message_studio.py", line 51, in create_bot_message template = await service.create_template( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/modules/message_studio/service.py", line 102, in create_template await self.repo.create_version(template, updated_by=user_id) File "/root/telegram-saas/modules/message_studio/repository.py", line 129, in create_version await self.db.flush() File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/ext/asyncio/session.py", line 1031, in flush await greenlet_spawn(self.sync_session.flush, objects=objects) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/util/concurrency.py", line 216, in greenlet_spawn result = context.switch(value) ^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4626, in flush self._flush(objects) File "", line 2, in _flush return target(fn, self, objects=objects) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned return fn(*args, **kwargs) # type: ignore[no-any-return] ^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4769, in _flush with util.safe_reraise(): File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 166, in __exit__ raise exc_value.with_traceback(exc_tb) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4730, in _flush flush_context.execute() File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 467, in execute rec.execute(self) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 643, in execute util.preloaded.orm_persistence._save_obj( File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 92, in _save_obj _emit_insert_statements( File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 1250, in _emit_insert_statements result = connection.execute( ^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1494, in execute return meth( ^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 534, in _execute_on_connection return connection._execute_clauseelement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1714, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1868, in _execute_context return self._exec_single_context( ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1996, in _exec_single_context self._handle_dbapi_exception( File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2351, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1977, in _exec_single_context self.dialect.do_execute( File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 1192, in do_execute cursor.execute(statement, parameters) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 671, in execute await_(self._prepare_and_execute(operation, parameters)) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/util/concurrency.py", line 171, in await_ return current.parent.switch(awaitable) # type: ignore[no-any-return] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/util/concurrency.py", line 209, in greenlet_spawn value = await result ^^^^^^^^^^^^ File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 633, in _prepare_and_execute self._handle_exception(error) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 583, in _handle_exception self._adapt_connection._handle_exception(error) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 862, in _handle_exception super()._handle_exception(error) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/connectors/asyncio.py", line 412, in _handle_exception self._handle_exception_no_connection(self.dbapi, error) File "/root/telegram-saas/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 855, in _handle_exception_no_connection raise translated_error from error sqlalchemy.exc.DBAPIError: (sqlalchemy.dialects.postgresql.asyncpg.Error) unsupported Unicode escape sequence [SQL: INSERT INTO bot_message_versions (id, template_id, version, snapshot_json, updated_by, created_at) VALUES ($1::UUID, $2::UUID, $3::INTEGER, $4::JSONB, $5::UUID, $6::TIMESTAMP WITH TIME ZONE)] [parameters: (UUID('c3a1197d-8093-4dca-a6f2-7cfa6adaa67c'), UUID('3caec20e-71d3-4aa5-86ad-0aa99f922e3a'), 1, '{"message_key": "welcome", "title": "Main Welcome Screen", "message_text": "\\ud83d\\ude4f Welcome, {first_name}!\\n\\nWelcome to our VIP club. Choos ... (477 characters truncated) ... "\\ud83d\\udcde Support", "button_type": "callback_data", "action_value": "act:support", "row_position": 1, "column_position": 1, "sort_order": 1}]}', UUID('a0531aa0-7cda-4fc7-8d26-292f6356381c'), datetime.datetime(2026, 11, 18, 6, 19, 37, 496071, tzinfo=datetime.timezone.utc))] (Background on this error at: https://sqlalche.me/e/21/dbapi) =========================== short test summary info ============================ FAILED tests/integration/test_message_studio_api.py::test_bot_message_studio_lifecycle ========================= 1 failed, 32 passed in 2.38s =========================