Failed to run tests with fastapi templates on Linux and Mac

[v-jiaodi]

Describe the issue:
When test Running tests with fastapi templates on Linux and Mac, run python3 -m pytest, get error as follow:

Repro Steps:

1. Clone the repo to local.
2. Create a Python virtual environment and activate it.
3. Install requirements:
   python3 -m pip install -r requirements-dev.in
playwright install --with-deps
4. Run the tests: python3 -m pytest

Environment:

• OS: Linux and Mac.
• Azd version: 1.4.1 (commit Azure/azure-dev@1cbed85)
• Python : 3.8
• Template:
  https://github.com/Azure-Samples/azure-fastapi-postgres-flexible-aca
  https://github.com/Azure-Samples/azure-fastapi-postgres-flexible-appservice
  https://github.com/Azure-Samples/azure-fastapi-cosmos-postgres-aca
  https://github.com/Azure-Samples/azure-fastapi-cosmos-postgres-appservice
  https://github.com/Azure-Samples/azure-fastapi-postgres-addon-aca

Expected behavior:
Running python3 -m pytest with flask templates can pass on Linux and Mac.

@pamelafox for notification.

[pamelafox]

Can you copy and paste the full error message? (That starts with SSL error) You might also need to scroll up.

[pamelafox]

Did you set up a Postgres database locally with the correct username/password? (The same as what would have been setup by the dev container)

[v-jiaodi]

@pamelafox I set up a Postgres database locally with the correct username/password, the full error message as follow:

[pamelafox]

I made various updates to the tests and also added instructions for running Postgres locally. Can you try it again?

If you're still getting an SSL error, I wonder why it's trying to use SSL. You could try explicitly setting a local environment variable of POSTGRES_SSL to "disable".

[pamelafox]

Another thought - if you're still getting SSL issues, can you try changing line 19 in models to py to:

if os.environ.get("POSTGRES_HOST") == "localhost":
    sql_url = f"{sql_url}?sslmode=disable"

[v-jiaodi]

Test again, the current issue no longer exists.