stoffelmauro/ConsultancyProject_2_ETL
1
0
Fork 1
Code Issues Pull Requests Packages Projects Releases Wiki Activity

Endpoint für Auslastung einer Region #7

New Issue
Closed
opened 2025-01-09 18:26:33 +01:00 by dianigionath · 3 comments
dianigionath commented 2025-01-09 18:26:33 +01:00
Collaborator
Copy Link

Neuer Endpoint genau so aufgebaut wie @app.get("/property/{id}/capacities") aber für Regionen (-1,0,1...)
Würde dazu den bestehende @app.get("/region/{id}/capacities") zu @app.get("/region/{id}/properties/capacities") umbenennen und dafür den hier beschriebenen Endpoint @app.get("/region/{id}/capacities") nennen.

Neuer Endpoint genau so aufgebaut wie `@app.get("/property/{id}/capacities")` aber für Regionen (-1,0,1...) Würde dazu den bestehende `@app.get("/region/{id}/capacities")` zu `@app.get("/region/{id}/properties/capacities")` umbenennen und dafür den hier beschriebenen Endpoint `@app.get("/region/{id}/capacities")` nennen.
stoffelmauro was assigned by dianigionath 2025-01-09 18:26:44 +01:00
dianigionath commented 2025-01-11 18:29:41 +01:00
Author
Collaborator
Copy Link

Bei mir kommen Fehlermeldungen:

INFO:     127.0.0.1:37032 - "GET /region/2/capacities HTTP/1.1" 500 Internal Server Error
ERROR:    Exception in ASGI application
Traceback (most recent call last):
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/_utils/construction/series.py", line 310, in _construct_series_with_fallbacks
    return constructor(name, values, strict)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
TypeError: 'int' object cannot be converted to 'PyString'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/uvicorn/protocols/http/httptools_impl.py", line 401, in run_asgi
    result = await app(  # type: ignore[func-returns-value]
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/uvicorn/middleware/proxy_headers.py", line 60, in __call__
    return await self.app(scope, receive, send)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/fastapi/applications.py", line 1054, in __call__
    await super().__call__(scope, receive, send)
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/applications.py", line 113, in __call__
    await self.middleware_stack(scope, receive, send)
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/middleware/errors.py", line 187, in __call__
    raise exc
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/middleware/errors.py", line 165, in __call__
    await self.app(scope, receive, _send)
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/middleware/exceptions.py", line 62, in __call__
    await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
    raise exc
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
    await app(scope, receive, sender)
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/routing.py", line 715, in __call__
    await self.middleware_stack(scope, receive, send)
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/routing.py", line 735, in app
    await route.handle(scope, receive, send)
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/routing.py", line 288, in handle
    await self.app(scope, receive, send)
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/routing.py", line 76, in app
    await wrap_app_handling_exceptions(app, request)(scope, receive, send)
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
    raise exc
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
    await app(scope, receive, sender)
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/routing.py", line 73, in app
    response = await f(request)
               ^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/fastapi/routing.py", line 301, in app
    raw_response = await run_endpoint_function(
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/fastapi/routing.py", line 214, in run_endpoint_function
    return await run_in_threadpool(dependant.call, **values)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/concurrency.py", line 39, in run_in_threadpool
    return await anyio.to_thread.run_sync(func, *args)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/anyio/to_thread.py", line 56, in run_sync
    return await get_async_backend().run_sync_in_worker_thread(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/anyio/_backends/_asyncio.py", line 2441, in run_sync_in_worker_thread
    return await future
           ^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/anyio/_backends/_asyncio.py", line 943, in run
    result = context.run(func, *args)
             ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/src/api/main.py", line 75, in region_capacities_data
    capacities = etl_rc.region_capacities(id)
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/src/data/etl_region_capacities.py", line 36, in region_capacities
    df = pl.DataFrame(gridData)
         ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/dataframe/frame.py", line 375, in __init__
    self._df = sequence_to_pydf(
               ^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/_utils/construction/dataframe.py", line 460, in sequence_to_pydf
    return _sequence_to_pydf_dispatcher(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/functools.py", line 907, in wrapper
    return dispatch(args[0].__class__)(*args, **kw)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/_utils/construction/dataframe.py", line 600, in _sequence_of_sequence_to_pydf
    pl.Series(
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/series/series.py", line 289, in __init__
    self._s = sequence_to_pyseries(
              ^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/_utils/construction/series.py", line 295, in sequence_to_pyseries
    return _construct_series_with_fallbacks(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/_utils/construction/series.py", line 313, in _construct_series_with_fallbacks
    return PySeries.new_from_any_values(name, values, strict=strict)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
TypeError: unexpected value while building Series of type String; found value of type Int64: 427

Hint: Try setting `strict=False` to allow passing data with mixed types.
Bei mir kommen Fehlermeldungen: ```bash INFO: 127.0.0.1:37032 - "GET /region/2/capacities HTTP/1.1" 500 Internal Server Error ERROR: Exception in ASGI application Traceback (most recent call last): File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/_utils/construction/series.py", line 310, in _construct_series_with_fallbacks return constructor(name, values, strict) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ TypeError: 'int' object cannot be converted to 'PyString' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/uvicorn/protocols/http/httptools_impl.py", line 401, in run_asgi result = await app( # type: ignore[func-returns-value] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/uvicorn/middleware/proxy_headers.py", line 60, in __call__ return await self.app(scope, receive, send) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/fastapi/applications.py", line 1054, in __call__ await super().__call__(scope, receive, send) File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/applications.py", line 113, in __call__ await self.middleware_stack(scope, receive, send) File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/middleware/errors.py", line 187, in __call__ raise exc File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/middleware/errors.py", line 165, in __call__ await self.app(scope, receive, _send) File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/middleware/exceptions.py", line 62, in __call__ await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send) File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app raise exc File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app await app(scope, receive, sender) File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/routing.py", line 715, in __call__ await self.middleware_stack(scope, receive, send) File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/routing.py", line 735, in app await route.handle(scope, receive, send) File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/routing.py", line 288, in handle await self.app(scope, receive, send) File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/routing.py", line 76, in app await wrap_app_handling_exceptions(app, request)(scope, receive, send) File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app raise exc File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app await app(scope, receive, sender) File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/routing.py", line 73, in app response = await f(request) ^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/fastapi/routing.py", line 301, in app raw_response = await run_endpoint_function( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/fastapi/routing.py", line 214, in run_endpoint_function return await run_in_threadpool(dependant.call, **values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/starlette/concurrency.py", line 39, in run_in_threadpool return await anyio.to_thread.run_sync(func, *args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/anyio/to_thread.py", line 56, in run_sync return await get_async_backend().run_sync_in_worker_thread( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/anyio/_backends/_asyncio.py", line 2441, in run_sync_in_worker_thread return await future ^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/anyio/_backends/_asyncio.py", line 943, in run result = context.run(func, *args) ^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/src/api/main.py", line 75, in region_capacities_data capacities = etl_rc.region_capacities(id) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/src/data/etl_region_capacities.py", line 36, in region_capacities df = pl.DataFrame(gridData) ^^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/dataframe/frame.py", line 375, in __init__ self._df = sequence_to_pydf( ^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/_utils/construction/dataframe.py", line 460, in sequence_to_pydf return _sequence_to_pydf_dispatcher( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/functools.py", line 907, in wrapper return dispatch(args[0].__class__)(*args, **kw) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/_utils/construction/dataframe.py", line 600, in _sequence_of_sequence_to_pydf pl.Series( File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/series/series.py", line 289, in __init__ self._s = sequence_to_pyseries( ^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/_utils/construction/series.py", line 295, in sequence_to_pyseries return _construct_series_with_fallbacks( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/gio/Code/ConsultancyProject_2_ETL/etl/.pixi/envs/default/lib/python3.12/site-packages/polars/_utils/construction/series.py", line 313, in _construct_series_with_fallbacks return PySeries.new_from_any_values(name, values, strict=strict) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ TypeError: unexpected value while building Series of type String; found value of type Int64: 427 Hint: Try setting `strict=False` to allow passing data with mixed types. ```
stoffelmauro commented 2025-01-11 18:41:12 +01:00
Owner
Copy Link

Es funktioniert bei mir lokal. Muss das morgen überprüfen image

Es funktioniert bei mir lokal. Muss das morgen überprüfen ![image](/attachments/01c9183f-7fe4-4060-abde-603a3a8c7cc4)
image.png
101 KiB
stoffelmauro commented 2025-01-12 12:20:03 +01:00
Owner
Copy Link

Die Resultate des Fix stimmen. Aber ich habe bemerkt, dass die Berechnungszeit schneller ist, wenn es als Array aufgebaut und verrechnet wird und danach wieder in ein Dataframe verpackt wird. Wenn meine Lösung aber zu Typenproblemen führt spielt das keine Rolle und wir lassen es besser so wie es ist. Jedoch ist die globale Option (region = -1) praktisch unbrauchbar, da die Ladezeit zu lange ist

Die Resultate des Fix stimmen. Aber ich habe bemerkt, dass die Berechnungszeit schneller ist, wenn es als Array aufgebaut und verrechnet wird und danach wieder in ein Dataframe verpackt wird. Wenn meine Lösung aber zu Typenproblemen führt spielt das keine Rolle und wir lassen es besser so wie es ist. Jedoch ist die globale Option (region = -1) praktisch unbrauchbar, da die Ladezeit zu lange ist
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
bollicolin dianigionath winklecharle stoffelmauro
No Assignees stoffelmauro
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: stoffelmauro/ConsultancyProject_2_ETL#7
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?