Bug: unsupported operand type(s) when use scalar #75
Description
i have a bug when running session.scalar with this message: "unsupported operand type(s) for +: 'int' and 'str'",
i see the error occurred in _render_string_type on line 411, but i not know why this error occurred
sqlalchemy: 2.0.30, but in my poetry.lock is 2.0.40 i returned to 2.0.30 and is running ok now
sqlalchemy-firebird: 2.1
firebird: 2.5
python: 3.12.3
this is my code
query_sequencia = select(SequenceTable).where(
SequenceTable.codigo == '000025'
)
sequence_product = session.scalar(query_sequencia)
this my class
class SequenceTable:
__tablename__ = 'c000000'
__table_args__ = (
PrimaryKeyConstraint('codigo', name='PK_C000000'),
Index('PK_C000000', 'codigo'),
)
codigo: Mapped[str] = mapped_column(FBVARCHAR(length=6))
tabela: Mapped[str] = mapped_column(FBVARCHAR(length=6))
sequencia: Mapped[int] = mapped_column(FBINTEGER)
Stacktrace
" + Exception Group Traceback (most recent call last):\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\_utils.py", line 87, in collapse_excgroups\n | yield\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\base.py", line 190, in call\n | async with anyio.create_task_group() as task_group:\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\anyio\_backends\_asyncio.py", line 772, in aexit\n | raise BaseExceptionGroup(\n | ExceptionGroup: unhandled errors in a TaskGroup (1 sub-exception)\n +-+---------------- 1 ----------------\n | Traceback (most recent call last):\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\errors.py", line 164, in call\n | await self.app(scope, receive, _send)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\base.py", line 189, in call\n | with collapse_excgroups():\n | File "C:\Users\VeeV\.pyenv\pyenv-win\versions\3.12.3-win32\Lib\contextlib.py", line 158, in exit\n | self.gen.throw(value)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\_utils.py", line 93, in collapse_excgroups\n | raise exc\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\base.py", line 191, in call\n | response = await self.dispatch_func(request, call_next)\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\PythonProjects\integrations_veev\integrations_veev\core\middleware\response_logger_middleware.py", line 15, in dispatch\n | response = await call_next(request)\n | ^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\base.py", line 165, in call_next\n | raise app_exc\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\base.py", line 151, in coro\n | await self.app(scope, receive_or_disconnect, send_no_error)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\cors.py", line 85, in call\n | await self.app(scope, receive, send)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\opentelemetry\instrumentation\asgi\init.py", line 743, in call\n | await self.app(scope, otel_receive, otel_send)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\exceptions.py", line 65, in call\n | await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\_exception_handler.py", line 64, in wrapped_app\n | raise exc\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\_exception_handler.py", line 53, in wrapped_app\n | await app(scope, receive, sender)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\routing.py", line 756, in call\n | await self.middleware_stack(scope, receive, send)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\routing.py", line 776, in app\n | await route.handle(scope, receive, send)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\routing.py", line 297, in handle\n | await self.app(scope, receive, send)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\routing.py", line 77, in app\n | await wrap_app_handling_exceptions(app, request)(scope, receive, send)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\_exception_handler.py", line 64, in wrapped_app\n | raise exc\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\_exception_handler.py", line 53, in wrapped_app\n | await app(scope, receive, sender)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\routing.py", line 72, in app\n | response = await func(request)\n | ^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\fastapi\routing.py", line 278, in app\n | raw_response = await run_endpoint_function(\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\fastapi\routing.py", line 191, in run_endpoint_function\n | return await dependant.call(**values)\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\PythonProjects\integrations_veev\integrations_veev\dmarques\product\routers\product_routers.py", line 32, in sync_products\n | await product_controller.sync_products()\n | File "C:\PythonProjects\integrations_veev\integrations_veev\core\measure\measure_time.py", line 20, in async_wrapper\n | result = await fn(*args, **kwargs) # type: ignore\n | ^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\PythonProjects\integrations_veev\integrations_veev\dmarques\product\controllers\product_controller.py", line 499, in sync_products\n | sequence_product = self.get_sequence_product(session)\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\PythonProjects\integrations_veev\integrations_veev\core\measure\measure_time.py", line 31, in wrapper\n | result = fn(*args, **kwargs)\n | ^^^^^^^^^^^^^^^^^^^\n | File "C:\PythonProjects\integrations_veev\integrations_veev\dmarques\product\controllers\product_controller.py", line 148, in get_sequence_product\n | sequence_product = session.scalar(query_sequencia)\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\orm\session.py", line 2413, in scalar\n | return self._execute_internal(\n | ^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\orm\session.py", line 2251, in _execute_internal\n | result: Result[Any] = compile_state_cls.orm_execute_statement(\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\orm\context.py", line 306, in orm_execute_statement\n | result = conn.execute(\n | ^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\engine\base.py", line 1416, in execute\n | return meth(\n | ^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\elements.py", line 523, in _execute_on_connection\n | return connection._execute_clauseelement(\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\engine\base.py", line 1630, in _execute_clauseelement\n | compiled_sql, extracted_params, cache_hit = elem._compile_w_cache(\n | ^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\elements.py", line 711, in _compile_w_cache\n | compiled_sql = self._compiler(\n | ^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\elements.py", line 320, in _compiler\n | return dialect.statement_compiler(dialect, self, **kw)\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 1446, in init\n | Compiled.init(self, dialect, statement, **kwargs)\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 886, in init\n | self.string = self.process(self.statement, **compile_kwargs)\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 932, in process\n | return obj._compiler_dispatch(self, **kwargs)\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\visitors.py", line 141, in _compiler_dispatch\n | return meth(self, **kw) # type: ignore # noqa: E501\n | ^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 4873, in visit_select\n | text = self._compose_select_body(\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 5035, in _compose_select_body\n | t = self._generate_delimited_and_list(\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 2784, in _generate_delimited_and_list\n | return clauses[0]._compiler_dispatch(self, **kw)\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\visitors.py", line 141, in _compiler_dispatch\n | return meth(self, **kw) # type: ignore # noqa: E501\n | ^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 3429, in visit_binary\n | return self._generate_generic_binary(\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 3488, in _generate_generic_binary\n | + binary.right._compiler_dispatch(\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\visitors.py", line 141, in compiler_dispatch\n | return meth(self, **kw) # type: ignore # noqa: E501\n | ^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 3823, in visit_bindparam\n | ret = self.bindparam_string(\n | ^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 4011, in bindparam_string\n | ret = self.render_bind_cast(bindparam_type, type_impl, ret)\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy_firebird\base.py", line 39, in render_bind_cast\n | self.dialect.type_compiler_instance.process(\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 977, in process\n | return type._compiler_dispatch(self, **kw)\n | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\visitors.py", line 141, in _compiler_dispatch\n | return meth(self, **kw) # type: ignore # noqa: E501\n | ^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 7264, in visit_VARCHAR\n | return self._render_string_type(\n | ^^^^^^^^^^^^^^^^^^^^^^^^^\n | File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy_firebird\base.py", line 425, in _render_string_type\n | text = text + (length and "(%d)" % length or "")\n | ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n | TypeError: unsupported operand type(s) for +: 'int' and 'str'\n +------------------------------------\n\nDuring handling of the above exception, another exception occurred:\n\nTraceback (most recent call last):\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\errors.py", line 164, in call\n await self.app(scope, receive, _send)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\base.py", line 189, in call\n with collapse_excgroups():\n File "C:\Users\VeeV\.pyenv\pyenv-win\versions\3.12.3-win32\Lib\contextlib.py", line 158, in exit\n self.gen.throw(value)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\_utils.py", line 93, in collapse_excgroups\n raise exc\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\base.py", line 191, in call\n response = await self.dispatch_func(request, call_next)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\PythonProjects\integrations_veev\integrations_veev\core\middleware\response_logger_middleware.py", line 15, in dispatch\n response = await call_next(request)\n ^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\base.py", line 165, in call_next\n raise app_exc\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\base.py", line 151, in coro\n await self.app(scope, receive_or_disconnect, send_no_error)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\cors.py", line 85, in call\n await self.app(scope, receive, send)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\opentelemetry\instrumentation\asgi\init.py", line 743, in call\n await self.app(scope, otel_receive, otel_send)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\middleware\exceptions.py", line 65, in call\n await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\_exception_handler.py", line 64, in wrapped_app\n raise exc\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\_exception_handler.py", line 53, in wrapped_app\n await app(scope, receive, sender)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\routing.py", line 756, in call\n await self.middleware_stack(scope, receive, send)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\routing.py", line 776, in app\n await route.handle(scope, receive, send)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\routing.py", line 297, in handle\n await self.app(scope, receive, send)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\routing.py", line 77, in app\n await wrap_app_handling_exceptions(app, request)(scope, receive, send)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\_exception_handler.py", line 64, in wrapped_app\n raise exc\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\_exception_handler.py", line 53, in wrapped_app\n await app(scope, receive, sender)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\starlette\routing.py", line 72, in app\n response = await func(request)\n ^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\fastapi\routing.py", line 278, in app\n raw_response = await run_endpoint_function(\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\fastapi\routing.py", line 191, in run_endpoint_function\n return await dependant.call(**values)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\PythonProjects\integrations_veev\integrations_veev\dmarques\product\routers\product_routers.py", line 32, in sync_products\n await product_controller.sync_products()\n File "C:\PythonProjects\integrations_veev\integrations_veev\core\measure\measure_time.py", line 20, in async_wrapper\n result = await fn(*args, **kwargs) # type: ignore\n ^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\PythonProjects\integrations_veev\integrations_veev\dmarques\product\controllers\product_controller.py", line 499, in sync_products\n sequence_product = self.get_sequence_product(session)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\PythonProjects\integrations_veev\integrations_veev\core\measure\measure_time.py", line 31, in wrapper\n result = fn(*args, **kwargs)\n ^^^^^^^^^^^^^^^^^^^\n File "C:\PythonProjects\integrations_veev\integrations_veev\dmarques\product\controllers\product_controller.py", line 148, in get_sequence_product\n sequence_product = session.scalar(query_sequencia)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\orm\session.py", line 2413, in scalar\n return self._execute_internal(\n ^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\orm\session.py", line 2251, in _execute_internal\n result: Result[Any] = compile_state_cls.orm_execute_statement(\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\orm\context.py", line 306, in orm_execute_statement\n result = conn.execute(\n ^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\engine\base.py", line 1416, in execute\n return meth(\n ^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\elements.py", line 523, in _execute_on_connection\n return connection._execute_clauseelement(\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\engine\base.py", line 1630, in _execute_clauseelement\n compiled_sql, extracted_params, cache_hit = elem._compile_w_cache(\n ^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\elements.py", line 711, in _compile_w_cache\n compiled_sql = self._compiler(\n ^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\elements.py", line 320, in _compiler\n return dialect.statement_compiler(dialect, self, **kw)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 1446, in init\n Compiled.init(self, dialect, statement, **kwargs)\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 886, in init\n self.string = self.process(self.statement, **compile_kwargs)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 932, in process\n return obj._compiler_dispatch(self, **kwargs)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\visitors.py", line 141, in _compiler_dispatch\n return meth(self, **kw) # type: ignore # noqa: E501\n ^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 4873, in visit_select\n text = self._compose_select_body(\n ^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 5035, in _compose_select_body\n t = self._generate_delimited_and_list(\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 2784, in _generate_delimited_and_list\n return clauses[0]._compiler_dispatch(self, **kw)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\visitors.py", line 141, in _compiler_dispatch\n return meth(self, **kw) # type: ignore # noqa: E501\n ^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 3429, in visit_binary\n return self._generate_generic_binary(\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 3488, in _generate_generic_binary\n + binary.right._compiler_dispatch(\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\visitors.py", line 141, in compiler_dispatch\n return meth(self, **kw) # type: ignore # noqa: E501\n ^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 3823, in visit_bindparam\n ret = self.bindparam_string(\n ^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 4011, in bindparam_string\n ret = self.render_bind_cast(bindparam_type, type_impl, ret)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy_firebird\base.py", line 39, in render_bind_cast\n self.dialect.type_compiler_instance.process(\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 977, in process\n return type._compiler_dispatch(self, **kw)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\visitors.py", line 141, in _compiler_dispatch\n return meth(self, **kw) # type: ignore # noqa: E501\n ^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy\sql\compiler.py", line 7264, in visit_VARCHAR\n return self._render_string_type(\n ^^^^^^^^^^^^^^^^^^^^^^^^^\n File "C:\Users\VeeV\AppData\Local\pypoetry\Cache\virtualenvs\integrations-veev--I7s6ump-py3.12\Lib\site-packages\sqlalchemy_firebird\base.py", line 425, in _render_string_type\n text = text + (length and "(%d)" % length or "")\n ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nTypeError: unsupported operand type(s) for +: 'int' and 'str'\n"