Prisma With Fastapi

pip3 install prisma

// prisma/schema.prisma

datasource db {
  provider = "postgresql"
  url      = env("DB_URL")
}

generator client {
  provider             = "prisma-client-py"
  recursive_type_depth = 5
}

model User {
  id   String @id @default(uuid())
  name String
}

DB_URL="postgresql://artoriax:mypassword@localhost:5432/news_db"

prisma migrate dev --name init

# src/prisma.py

from prisma import Prisma

prisma = Prisma()

# main.py
from contextlib import asynccontextmanager
from fastapi import FastAPI
from src.prisma import prisma
import logging

logger = logging.getLogger("uvicorn.error")
logger.setLevel(logging.DEBUG)


# connect to db during lifecycle of the application
@asynccontextmanager
async def lifespan(app: FastAPI):
    await prisma.connect()
    logger.debug("Successfully connected to database!")

    yield
    await prisma.disconnect()
    logger.debug("Successfully disconnected from database!")


app = FastAPI(lifespan=lifespan)


@app.get("/")
async def root():
    return {"message": "Server is running"}


@app.get("/users")
async def get_users():
    users = await prisma.user.find_many()
    return {"users": users}

fastapi dev main.py