pocolifo / noter-backend

0 stars 0 forks source link

Delete item by id fails #29

Closed YoungerMax closed 11 months ago

YoungerMax commented 11 months ago
INFO:     ::ffff:127.0.0.1:0 - "DELETE /items/delete?id=f23e33b3-28e5-4278-93ba-7b288e4bc2a5 HTTP/1.1" 500 Internal Server Error
ERROR:    Exception in ASGI application
Traceback (most recent call last):
  File "/home/youngermax/.local/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 1964, in _do_pre_synchronize_evaluate
    eval_condition = evaluator_compiler.process(*crit)
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/sqlalchemy/orm/evaluator.py", line 92, in process
    return meth(clause)
           ^^^^^^^^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/sqlalchemy/orm/evaluator.py", line 143, in visit_clauselist
    evaluators = list(map(self.process, clause.clauses))
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/sqlalchemy/orm/evaluator.py", line 92, in process
    return meth(clause)
           ^^^^^^^^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/sqlalchemy/orm/evaluator.py", line 187, in visit_binary
    eval_left, eval_right = list(
                            ^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/sqlalchemy/orm/evaluator.py", line 92, in process
    return meth(clause)
           ^^^^^^^^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/sqlalchemy/orm/evaluator.py", line 265, in visit_unary
    raise UnevaluatableError(
sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate CollectionAggregate with operator <function any_op at 0x7f325d487060>

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/youngermax/.local/lib/python3.11/site-packages/uvicorn/protocols/http/h11_impl.py", line 428, in run_asgi
    result = await app(  # type: ignore[func-returns-value]
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/uvicorn/middleware/proxy_headers.py", line 78, in __call__
    return await self.app(scope, receive, send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/fastapi/applications.py", line 284, in __call__
    await super().__call__(scope, receive, send)
  File "/home/youngermax/.local/lib/python3.11/site-packages/starlette/applications.py", line 122, in __call__
    await self.middleware_stack(scope, receive, send)
  File "/home/youngermax/.local/lib/python3.11/site-packages/starlette/middleware/errors.py", line 184, in __call__
    raise exc
  File "/home/youngermax/.local/lib/python3.11/site-packages/starlette/middleware/errors.py", line 162, in __call__
    await self.app(scope, receive, _send)
  File "/home/youngermax/.local/lib/python3.11/site-packages/starlette/middleware/cors.py", line 91, in __call__
    await self.simple_response(scope, receive, send, request_headers=headers)
  File "/home/youngermax/.local/lib/python3.11/site-packages/starlette/middleware/cors.py", line 146, in simple_response
    await self.app(scope, receive, send)
  File "/home/youngermax/.local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 79, in __call__
    raise exc
  File "/home/youngermax/.local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 68, in __call__
    await self.app(scope, receive, sender)
  File "/home/youngermax/.local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 20, in __call__
    raise e
  File "/home/youngermax/.local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 17, in __call__
    await self.app(scope, receive, send)
  File "/home/youngermax/.local/lib/python3.11/site-packages/starlette/routing.py", line 718, in __call__
    await route.handle(scope, receive, send)
  File "/home/youngermax/.local/lib/python3.11/site-packages/starlette/routing.py", line 276, in handle
    await self.app(scope, receive, send)
  File "/home/youngermax/.local/lib/python3.11/site-packages/starlette/routing.py", line 66, in app
    response = await func(request)
               ^^^^^^^^^^^^^^^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/fastapi/routing.py", line 241, in app
    raw_response = await run_endpoint_function(
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/fastapi/routing.py", line 167, in run_endpoint_function
    return await dependant.call(**values)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/youngermax/Programming/Noter/noter-backend/backend/routes/update_routes.py", line 37, in delete_item
    db.delete_item_by_id(request, id)
  File "/home/youngermax/Programming/Noter/noter-backend/backend/noterdb.py", line 229, in delete_item_by_id
    self.session.query(Note).filter(Note.path.any(id), Note.owner_id == user_id).delete()
  File "/home/youngermax/.local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 3222, in delete
    result = self.session.execute(
             ^^^^^^^^^^^^^^^^^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1665, in execute
    ) = compile_state_cls.orm_pre_session_exec(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 1843, in orm_pre_session_exec
    update_options = cls._do_pre_synchronize_evaluate(
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/youngermax/.local/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 1971, in _do_pre_synchronize_evaluate
    util.raise_(
  File "/home/youngermax/.local/lib/python3.11/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
    raise exception
sqlalchemy.exc.InvalidRequestError: Could not evaluate current criteria in Python: "Cannot evaluate CollectionAggregate with operator <function any_op at 0x7f325d487060>". Specify 'fetch' or False for the synchronize_session execution option.
YoungerMax commented 11 months ago

resolved