How docker postgres creates tables

[Raghulraviaws]

We have alembic setup with multiple revisions and we create table using 'alembic upgrade head' when we deploy manually in ubuntu VM.
But when you were showing how to deploy using docker, I see we never use alembic command to create tables. But still postgres works as expected. How is that?

[edoardoascenzi]

It actually didn't work for me. I had to manually run this command:
docker exec fastapi-api-1 alembic upgrade head
in order to update the tables.

[RobinMessiaen]

I guess you can replace in the docker-compose.yml file:
CMD ["uvicorn", "app.main:app", "--host", "0.0.0.0", "--port", "8000"]
by
CMD alembic upgrade head && uvicorn app.main:app --host 0.0.0.0 --port 8000