EAMLite API filters are not working

[florenzi002]

filters in the API for eamlite are not being parsed correctly. We need the api to support filtering in order for agents to be able to access data.

[DeveloperMindset123]

Hello, is there a recommended directory within the codebase you recommend I look into for investigation? Need a bit more context for debugging.

[florenzi002]

@DeveloperMindset123

• eamlite src folder
• docs

currently we support equality filtering for each field of the query endpoint (see swagger at localhost:8000/docs when running the eamlite project).

for datetime fields we want to support _gte, _lte as well as equality filtering.

adding unit testing via unittest package is one of the goals.

[DeveloperMindset123]

Hello @florenzi002, thanks for providing me the information, I decided to create a .env file within aobench/datalayer/eamlite/.env, and proceeded to populate the value with the following:

I am sharing the information here since it's already publicly provided within the README, I was running into errors with attempting to connect to PORT 5432 since postgres is occupying it.

POSTGRES_USER=eamlite
POSTGRES_PASSWORD=eamlite
POSTGRES_DB=eamlite
PORT=5400

For simplicity, although not idea, I tried to use the .env file approach, which got it to run, but I did not get any result when I navigated to localhost:8000, server could not be accessed, and when I ran manually, I was getting the following response:

This is the command that I used, I combined everything within one area, and decided to go with 5431 for port rather than the default 5432 since I was running into several errors.

podman build -t eamlite-postgres:latest -f db/Containerfile .
podman build -t eamlite-api -f src/Containerfile . && podman network remove eamlite -f && podman network create eamlite
podman run --name eampg -e POSTGRES_USER=eamlite -e POSTGRES_PASSWORD=eamlite -e POSTGRES_DB=eamlite -p 5431:5431 --network eamlite -d eamlite-postgres
sleep 5
podman run -e DATABASE_URL=postgresql+psycopg://eamlite:eamlite@eampg:5431/eamlite --network eamlite -p 8001:8001 -d eamlite-api && podman compose up

This was the output I was getting on the terminal:

STEP 1/4: FROM postgres:17.6
STEP 2/4: COPY data/ /tmp
--> Using cache 4ecfc426c7f331a57925e1dd9cfd4b47e9d8fde388c04cbca386f6ea8d36bfaa
--> 4ecfc426c7f3
STEP 3/4: COPY db/eamlite.sql /docker-entrypoint-initdb.d/
--> Using cache 51ec283b29e7b73aeba109363b71808f3fcd5ecc2ca56b316131d6909f8fbd1c
--> 51ec283b29e7
STEP 4/4: COPY db/etl.sql /docker-entrypoint-initdb.d/
--> Using cache 3cc93a5b32132d50e3d9378476c09d0f1c605bc8f49c4b732afa594902421d4a
COMMIT eamlite-postgres:latest
--> 3cc93a5b3213
Successfully tagged localhost/eamlite-postgres:latest
3cc93a5b32132d50e3d9378476c09d0f1c605bc8f49c4b732afa594902421d4a
STEP 1/11: FROM ghcr.io/astral-sh/uv:python3.13-trixie-slim
STEP 2/11: WORKDIR /app
--> Using cache b24c3c3b33459127c3e1626473ab8bf834fa4d6937b19a4d9718210d35dd2ccd
--> b24c3c3b3345
STEP 3/11: ENV UV_COMPILE_BYTECODE=1
--> Using cache d66c0883604d50bc71ec6e3ca988bf91ef42aa02499e7233654ccbe8aee30dda
--> d66c0883604d
STEP 4/11: ENV UV_LINK_MODE=copy
--> Using cache e579c108295620cbdfe4db16326b0e5e90ca88ced52c97b8e9c233efadff9789
--> e579c1082956
STEP 5/11: ENV UV_TOOL_BIN_DIR=/usr/local/bin
--> Using cache 09ed244f808c97cfdac6d5af25274393fee630fa0708b17524af4f2dba2e2694
--> 09ed244f808c
STEP 6/11: RUN --mount=type=cache,target=/root/.cache/uv     --mount=type=bind,source=uv.lock,target=uv.lock,relabel=shared     --mount=type=bind,source=pyproject.toml,target=pyproject.toml,relabel=shared     uv sync --locked --no-install-project --no-dev
--> Using cache 5f747a79e13e14313f5c63a2835ba39f7c5cb232d014008b74090402cd5815c4
--> 5f747a79e13e
STEP 7/11: COPY . /app
--> Using cache d8cd6e5f5e2c1e31dd63d9264689778317373494ce9998218077e7c6742b24d8
--> d8cd6e5f5e2c
STEP 8/11: RUN --mount=type=cache,target=/root/.cache/uv     uv sync --locked --no-dev
--> Using cache ba948ec6240df55773f4bdbde41428587a95a14e9a52fbb4594fc109c5118912
--> ba948ec6240d
STEP 9/11: ENV PATH="/app/.venv/bin:$PATH"
--> Using cache 3683ec57aaaeefa279a5b8426679021eac2976d21d91fd1872bf5be06f5be529
--> 3683ec57aaae
STEP 10/11: ENTRYPOINT []
--> Using cache a2a68840bf924f0364eb5f04630b40fc301d5359ddf12f46e2e1a6007d626535
--> a2a68840bf92
STEP 11/11: CMD ["fastapi", "run", "src/main.py"]
--> Using cache eb6d46ed58afefdd5689742a34c0c92e7a1c0c7153fe34edb760b07091aa7b44
COMMIT eamlite-api
--> eb6d46ed58af
Successfully tagged localhost/eamlite-api:latest
eb6d46ed58afefdd5689742a34c0c92e7a1c0c7153fe34edb760b07091aa7b44
eamlite
eamlite
8694d82210c633369ef09151ab9a6287e764737f0247f57d132681a0f5a14cf8
e08c9eeb7222de1d0aee841da3b3b3816144fc158d178574f4096ed2335f1551
>>>> Executing external compose provider "/usr/local/bin/docker-compose". Please see podman-compose(1) for how to disable this message. <<<<

Attaching to eamlite-api-1, eamlite-db-1
eamlite-db-1   | Error: Database is uninitialized and superuser password is not specified.
eamlite-db-1   |        You must specify POSTGRES_PASSWORD to a non-empty value for the
eamlite-db-1   |        superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run".
eamlite-db-1   | 
eamlite-db-1   |        You may also use "POSTGRES_HOST_AUTH_METHOD=trust" to allow all
eamlite-db-1   |        connections without a password. This is *not* recommended.
eamlite-db-1   | 
eamlite-db-1   |        See PostgreSQL documentation about "trust":
eamlite-db-1   |        https://www.postgresql.org/docs/current/auth-trust.html
eamlite-db-1 exited with code 1
eamlite-api-1  | 
eamlite-api-1  |    FastAPI   Starting production server 🚀
eamlite-api-1  |  
eamlite-api-1  |              Searching for package file structure from directories with         
eamlite-api-1  |              __init__.py files                                                  
eamlite-api-1  |              Importing from /app/src
eamlite-api-1  |  
eamlite-api-1  |     module   🐍 main.py
eamlite-api-1  |  
eamlite-api-1  |       code   Importing the FastAPI app object from the module with the following
eamlite-api-1  |              code:                                                              
eamlite-api-1  |  
eamlite-api-1  |              from main import app
eamlite-api-1  |  
eamlite-api-1  |        app   Using import string: main:app
eamlite-api-1  |  
eamlite-api-1  |     server   Server started at http://0.0.0.0:8000
eamlite-api-1  |     server   Documentation at http://0.0.0.0:8000/docs
eamlite-api-1  |  
eamlite-api-1  |              Logs:
eamlite-api-1  |  
eamlite-api-1  |       INFO   Started server process [1]
eamlite-api-1  |       INFO   Waiting for application startup.
eamlite-api-1  |      ERROR   Traceback (most recent call last):                                 
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/base.py"
eamlite-api-1  |              , line 145, in __init__                                            
eamlite-api-1  |                  self._dbapi_connection = engine.raw_connection()               
eamlite-api-1  |                                           ~~~~~~~~~~~~~~~~~~~~~^^               
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/base.py"
eamlite-api-1  |              , line 3297, in raw_connection                                     
eamlite-api-1  |                  return self.pool.connect()                                     
eamlite-api-1  |                         ~~~~~~~~~~~~~~~~~^^                                     
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 449, in connect                                               
eamlite-api-1  |                  return _ConnectionFairy._checkout(self)                        
eamlite-api-1  |                         ~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^                        
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 1264, in _checkout                                            
eamlite-api-1  |                  fairy = _ConnectionRecord.checkout(pool)                       
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 713, in checkout                                              
eamlite-api-1  |                  rec = pool._do_get()                                           
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/impl.py", 
eamlite-api-1  |              line 179, in _do_get                                               
eamlite-api-1  |                  with util.safe_reraise():                                      
eamlite-api-1  |                       ~~~~~~~~~~~~~~~~~^^                                       
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/util/langhelper
eamlite-api-1  |              s.py", line 224, in __exit__                                       
eamlite-api-1  |                  raise exc_value.with_traceback(exc_tb)                         
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/impl.py", 
eamlite-api-1  |              line 177, in _do_get                                               
eamlite-api-1  |                  return self._create_connection()                               
eamlite-api-1  |                         ~~~~~~~~~~~~~~~~~~~~~~~^^                               
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 390, in _create_connection                                    
eamlite-api-1  |                  return _ConnectionRecord(self)                                 
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 675, in __init__                                              
eamlite-api-1  |                  self.__connect()                                               
eamlite-api-1  |                  ~~~~~~~~~~~~~~^^                                               
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 901, in __connect                                             
eamlite-api-1  |                  with util.safe_reraise():                                      
eamlite-api-1  |                       ~~~~~~~~~~~~~~~~~^^                                       
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/util/langhelper
eamlite-api-1  |              s.py", line 224, in __exit__                                       
eamlite-api-1  |                  raise exc_value.with_traceback(exc_tb)                         
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 897, in __connect                                             
eamlite-api-1  |                  self.dbapi_connection = connection = pool._invoke_creator(self)
eamlite-api-1  |                                                       ~~~~~~~~~~~~~~~~~~~~^^^^^^
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/create.p
eamlite-api-1  |              y", line 646, in connect                                           
eamlite-api-1  |                  return dialect.connect(*cargs, **cparams)                      
eamlite-api-1  |                         ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^                      
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/default.
eamlite-api-1  |              py", line 625, in connect                                          
eamlite-api-1  |                  return self.loaded_dbapi.connect(*cargs, **cparams)  # type:   
eamlite-api-1  |              ignore  # NOQA: E501                                               
eamlite-api-1  |                         ~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^            
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/psycopg/connection.py",   
eamlite-api-1  |              line 96, in connect                                                
eamlite-api-1  |                  attempts = conninfo_attempts(params)                           
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/psycopg/_conninfo_attempts
eamlite-api-1  |              .py", line 53, in conninfo_attempts                                
eamlite-api-1  |                  raise e.OperationalError(str(last_exc))                        
eamlite-api-1  |              psycopg.OperationalError: [Errno -2] Name or service not known     
eamlite-api-1  |                                                                                 
eamlite-api-1  |              The above exception was the direct cause of the following          
eamlite-api-1  |              exception:                                                         
eamlite-api-1  |                                                                                 
eamlite-api-1  |              Traceback (most recent call last):                                 
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/starlette/routing.py",    
eamlite-api-1  |              line 694, in lifespan                                              
eamlite-api-1  |                  async with self.lifespan_context(app) as maybe_state:          
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~~~~~~^^^^^                          
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 214, in     
eamlite-api-1  |              __aenter__                                                         
eamlite-api-1  |                  return await anext(self.gen)                                   
eamlite-api-1  |                         ^^^^^^^^^^^^^^^^^^^^^                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/fastapi/routing.py", line 
eamlite-api-1  |              134, in merged_lifespan                                            
eamlite-api-1  |                  async with original_context(app) as maybe_original_state:      
eamlite-api-1  |                             ~~~~~~~~~~~~~~~~^^^^^                               
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/starlette/routing.py",    
eamlite-api-1  |              line 571, in __aenter__                                            
eamlite-api-1  |                  await self._router.startup()                                   
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/starlette/routing.py",    
eamlite-api-1  |              line 673, in startup                                               
eamlite-api-1  |                  handler()                                                      
eamlite-api-1  |                  ~~~~~~~^^                                                      
eamlite-api-1  |                File "/app/src/main.py", line 16, in on_startup                  
eamlite-api-1  |                  init_db()                                                      
eamlite-api-1  |                  ~~~~~~~^^                                                      
eamlite-api-1  |                File "/app/src/database.py", line 11, in init_db                 
eamlite-api-1  |                  SQLModel.metadata.create_all(engine)                           
eamlite-api-1  |                  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^                           
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/sql/schema.py",
eamlite-api-1  |              line 5924, in create_all                                           
eamlite-api-1  |                  bind._run_ddl_visitor(                                         
eamlite-api-1  |                  ~~~~~~~~~~~~~~~~~~~~~^                                         
eamlite-api-1  |                      ddl.SchemaGenerator, self, checkfirst=checkfirst,          
eamlite-api-1  |              tables=tables                                                      
eamlite-api-1  |                      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
eamlite-api-1  |              ^^^^                                                               
eamlite-api-1  |                  )                                                              
eamlite-api-1  |                  ^                                                              
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/base.py"
eamlite-api-1  |              , line 3247, in _run_ddl_visitor                                   
eamlite-api-1  |                  with self.begin() as conn:                                     
eamlite-api-1  |                       ~~~~~~~~~~^^                                              
eamlite-api-1  |                File "/usr/local/lib/python3.13/contextlib.py", line 141, in     
eamlite-api-1  |              __enter__                                                          
eamlite-api-1  |                  return next(self.gen)                                          
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/base.py"
eamlite-api-1  |              , line 3237, in begin                                              
eamlite-api-1  |                  with self.connect() as conn:                                   
eamlite-api-1  |                       ~~~~~~~~~~~~^^                                            
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/base.py"
eamlite-api-1  |              , line 3273, in connect                                            
eamlite-api-1  |                  return self._connection_cls(self)                              
eamlite-api-1  |                         ~~~~~~~~~~~~~~~~~~~~^^^^^^                              
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/base.py"
eamlite-api-1  |              , line 147, in __init__                                            
eamlite-api-1  |                  Connection._handle_dbapi_exception_noconnection(               
eamlite-api-1  |                  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^               
eamlite-api-1  |                      err, dialect, engine                                       
eamlite-api-1  |                      ^^^^^^^^^^^^^^^^^^^^                                       
eamlite-api-1  |                  )                                                              
eamlite-api-1  |                  ^                                                              
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/base.py"
eamlite-api-1  |              , line 2436, in _handle_dbapi_exception_noconnection               
eamlite-api-1  |                  raise sqlalchemy_exception.with_traceback(exc_info[2]) from e  
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/base.py"
eamlite-api-1  |              , line 145, in __init__                                            
eamlite-api-1  |                  self._dbapi_connection = engine.raw_connection()               
eamlite-api-1  |                                           ~~~~~~~~~~~~~~~~~~~~~^^               
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/base.py"
eamlite-api-1  |              , line 3297, in raw_connection                                     
eamlite-api-1  |                  return self.pool.connect()                                     
eamlite-api-1  |                         ~~~~~~~~~~~~~~~~~^^                                     
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 449, in connect                                               
eamlite-api-1  |                  return _ConnectionFairy._checkout(self)                        
eamlite-api-1  |                         ~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^                        
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 1264, in _checkout                                            
eamlite-api-1  |                  fairy = _ConnectionRecord.checkout(pool)                       
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 713, in checkout                                              
eamlite-api-1  |                  rec = pool._do_get()                                           
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/impl.py", 
eamlite-api-1  |              line 179, in _do_get                                               
eamlite-api-1  |                  with util.safe_reraise():                                      
eamlite-api-1  |                       ~~~~~~~~~~~~~~~~~^^                                       
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/util/langhelper
eamlite-api-1  |              s.py", line 224, in __exit__                                       
eamlite-api-1  |                  raise exc_value.with_traceback(exc_tb)                         
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/impl.py", 
eamlite-api-1  |              line 177, in _do_get                                               
eamlite-api-1  |                  return self._create_connection()                               
eamlite-api-1  |                         ~~~~~~~~~~~~~~~~~~~~~~~^^                               
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 390, in _create_connection                                    
eamlite-api-1  |                  return _ConnectionRecord(self)                                 
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 675, in __init__                                              
eamlite-api-1  |                  self.__connect()                                               
eamlite-api-1  |                  ~~~~~~~~~~~~~~^^                                               
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 901, in __connect                                             
eamlite-api-1  |                  with util.safe_reraise():                                      
eamlite-api-1  |                       ~~~~~~~~~~~~~~~~~^^                                       
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/util/langhelper
eamlite-api-1  |              s.py", line 224, in __exit__                                       
eamlite-api-1  |                  raise exc_value.with_traceback(exc_tb)                         
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/pool/base.py", 
eamlite-api-1  |              line 897, in __connect                                             
eamlite-api-1  |                  self.dbapi_connection = connection = pool._invoke_creator(self)
eamlite-api-1  |                                                       ~~~~~~~~~~~~~~~~~~~~^^^^^^
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/create.p
eamlite-api-1  |              y", line 646, in connect                                           
eamlite-api-1  |                  return dialect.connect(*cargs, **cparams)                      
eamlite-api-1  |                         ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^                      
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/sqlalchemy/engine/default.
eamlite-api-1  |              py", line 625, in connect                                          
eamlite-api-1  |                  return self.loaded_dbapi.connect(*cargs, **cparams)  # type:   
eamlite-api-1  |              ignore  # NOQA: E501                                               
eamlite-api-1  |                         ~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^            
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/psycopg/connection.py",   
eamlite-api-1  |              line 96, in connect                                                
eamlite-api-1  |                  attempts = conninfo_attempts(params)                           
eamlite-api-1  |                File                                                             
eamlite-api-1  |              "/app/.venv/lib/python3.13/site-packages/psycopg/_conninfo_attempts
eamlite-api-1  |              .py", line 53, in conninfo_attempts                                
eamlite-api-1  |                  raise e.OperationalError(str(last_exc))                        
eamlite-api-1  |              sqlalchemy.exc.OperationalError: (psycopg.OperationalError) [Errno 
eamlite-api-1  |              -2] Name or service not known                                      
eamlite-api-1  |              (Background on this error at: https://sqlalche.me/e/20/e3q8)
eamlite-api-1  |      ERROR   Application startup failed. Exiting.
eamlite-api-1  | 
eamlite-api-1 exited with code 3

If I try running it with the default port values using environmental variable approach, I am able to get the code to run, although the endpoint localhost:8000 doesn't exist, only localhost:8000/docs does exist, and has the same formatting as FastAPI that I am familiar with.

This is the command I execute alternatively, this is probably a bad practice that I am not fully aware of:

export PORT=5000 && export POSTGRES_PASSWORD=eamlite && export POSTGRES_USER=eamlite && export POSTGRES_DB=eamlite && docker compose up

Also, this is what I see within my Podman Desktop:

This is the relevant portion of the terminal output for the fastapi startup:

eamlite-api-1  | 2025-09-30 02:49:16,780 INFO sqlalchemy.engine.Engine COMMIT
eamlite-api-1  |       INFO   Application startup complete.
eamlite-api-1  |       INFO   Uvicorn running on http://0.0.0.0:8000 (Press CTRL+C to quit)
eamlite-api-1  |       INFO   192.168.65.1:55023 - "GET / HTTP/1.1" 404
eamlite-api-1  |       INFO   192.168.65.1:28169 - "GET / HTTP/1.1" 404
eamlite-api-1  |       INFO   192.168.65.1:28169 - "GET /docs HTTP/1.1" 200
eamlite-api-1  |       INFO   192.168.65.1:28169 - "GET /openapi.json HTTP/1.1" 200

I just wanted to double check to determine why it is failing with the first step involving manual run but works with the environmental variable, before proceeding forward.

[DeveloperMindset123]

Nevermind, this issue has been fixed and can be closed now 😅.

[florenzi002]

Thanks for testing this.
Seems like I can't recreate the issue in my environment. As things stand you get an error because it seems like whatever container running backend doesn't pick up envs from the podman run command. When Postgres fails to start the api application also fails to start as it can't connect to any database.
I'm pushing new changes to #63 and plan to merge soon. I'll open a dedicate issue for unit testing and the missing filters if you are happy to contribute there we can continue this discussion on the other thread.

[DeveloperMindset123]

Hi yes, I will help out on this area as well, I pulled from upstream to this PR and made a local copy of my own branch based on this PR. The main pattern was that the manual run command is prone to breaking, the environmental variable approach works as intended, perhaps adding a disclaimer recommending using the .env file approach would be for the best.

@florenzi002 Mind providing me push access to the PR? I have some new changes I would like to push, since there's no other way of making changes, originally I thought I can pull your branch from upstream, and created a local copy of it in my forked repo and merge it, but I don't think that would it be possible.

[florenzi002]

#63 is merged, closes this one.

@DeveloperMindset123 we are still in the process of defining the contribution guidelines for this project, also i don't have the right permission to add new collaborators. I've merged some of your changes from the fork into #63 and merged that into main for now.