FastAPI Authorization Setup

Setup

For this Lesson, we’ll start by working with a pre-existing application that utilizes a PostgreSQL database instance, SQLAlchemy models and a database seeded with initial data.

If you have a complete, working application from the Python FastAPI Authentication Lesson, you may choose to use a copy of that codebase as starter code instead of the repo provided below.

1. Clone the starter code

We’ve provided a starter repository with the base application code. Clone the repository to your local machine and rename the folder for this lesson:

git clone https://git.generalassemb.ly/modular-curriculum-all-courses/python-fastapi-authentication-solution python-fastapi-authorization

2. Install dependencies:

This project uses pipenv for managing dependencies. To install everything the project needs, run:

 pipenv install

3. Activate the virtual environment:

 pipenv shell

4. Set up the database

Set up your PostgreSQL database:
- Ensure PostgreSQL is installed and running on your machine.
- Create a database named teas_db if it does not already exist:

createdb teas_db

5. Connect to database

Open the application in Visual Studio Code:

code .

The database connection string is defined in the config/environment.py file:

db_URI = "postgresql://<username>@localhost:5432/teas_db"

Ensure your PostgreSQL instance is configured to allow connections with the provided credentials.
Modify your database connection string to use your username as the <username>.

6. Seed the database

Seed the database with initial data:

Run the seed.py file to reset the database by dropping existing tables and repopulating it with starter data:

pipenv run python seed.py

You should see output indicating the database was successfully seeded. If there are any errors, check the db_URI in the config/environment.py file.

7. Start the development server:

pipenv run uvicorn main:app --reload

You should now have the app running. Visit http://127.0.0.1:8000 in your browser to confirm it’s working.

You can test each endpoint using FastAPI’s built-in documentation.

Navigate to FastAPI Documentation: Open http://localhost:8000/docs in your browser.