An API for interacting with a database of books that are added and rated by users.

• A user needs to be created.
• To retrieve all books with their average rating, no user login is needed.
• To create, update, delete or rate a book, user login must be done first.
• A user can rate his or someone else's book only once. They can update their rating after.

Make sure you have PostgreSQL installed: sudo apt install postgresql.

Run conda env create -f environment.yml to create a conda environment and install all dependencies with poetry install.

Fill in your local DB credentials in .env on the root directory of this repository like so:

    DATABASE_HOSTNAME=...
    DATABASE_PORT=...
    DATABASE_NAME=...
    DATABASE_USERNAME=...
    DATABASE_PASSWORD=...
    SECRET_KEY=...
    ALGORITHM=...
    ACCESS_TOKEN_EXPIRE_MINUTES=...

Then run uvicorn app.main:app --host 0.0.0.0 --port 8000 to run the API locally and test it by making requests. See the Swagger documentation by navigating in your browser to http://localhost:8000/docs.

If you want to containerise the API, you can do so by first building the image on your machine: docker build -t biblioteca-api . And then running the container in detached mode by passing in the environment variables at runtime: docker run -d --network="host" --name biblioteca-api -p 8000:8000 --env-file .env biblioteca-api

You should then be able to access the UI from localhost:8000 in your browser.

Note: You should configure PostgreSQL to accept connections from external addresses. In your postgresql.conf:

    listen_addresses = '*'

and in your pg_hba.conf:

    host    all             all             172.17.0.0/16           md5

Make sure to restart PostgreSQL: sudo systemctl restart postgresql.