To activate Python virtual environment

*windows bash

    venv/scripts/activate

Install Dependencies

    pip install -r requirements.txt

Run Postgres DB in Docker

1. Run Postgres DB container

    docker-compose -f docker-compose-dev.yaml --env-file .env up -d

Run the application

    uvicorn app.main:app --reload

Alembic Command

0. Initialize alembic

    alembic init alembic

1. Create migration

    alembic revision --autogenerate -m "your message..."

2. Update database

    alembic upgrade head

3. This will undo the last migration

    alembic downgrade -1

4. This will list all migration history(You can use this to find the migration to undo)

    alembic history --verbose

5. Downgrade to specific revision

    alembic downgrade <revision ID>

6. This will reset the database to the initial state

    alembic downgrade base