Joaopcamposs

version: '3.9'

services:
  db:
    container_name: mysql_database
    image: mysql:latest
    ports:
      - "3306:3306"
    environment:
      MYSQL_ROOT_PASSWORD: password

Joaopcamposs

# pull official base image
FROM python:3.10

# set work directory
WORKDIR /app

# copy requirements file
COPY requirements.txt requirements.txt

# install dependencies

Joaopcamposs

# crud.py

from typing import List
from sqlalchemy.orm import Session
from exceptions import UserAlreadyExistError, UserNotFoundError
from models import User
from schemas import CreateAndUpdateUser


# Function to get list of users

Joaopcamposs

# api.py

from typing import List
from fastapi import APIRouter, Depends, HTTPException
from sqlalchemy.orm import Session
from crud import get_all_users, create_user, update_user_by_id, delete_user_by_id, get_user_by_id
from database import get_db
from exceptions import UserException
from schemas import Users, CreateAndUpdateUser

Joaopcamposs

# main.py

from fastapi import FastAPI
import api
from crud import create_db

# initialize mysql database
create_db()

# initialize the app

Joaopcamposs

# api.py

from typing import List
from fastapi import APIRouter, Depends, HTTPException
from sqlalchemy.orm import Session
from crud import get_all_users, create_user, update_user, delete_user, get_user_by_id
from database import get_db
from exceptions import UserException
from schemas import Users, CreateAndUpdateUser

Joaopcamposs

# exceptions.py

class UserException(Exception):
    ...


class UserNotFoundError(UserException):
    def __init__(self):
        self.status_code = 404
        self.detail = "User Not Found"

Joaopcamposs

# crud.py

from typing import List
from sqlalchemy.orm import Session
from exceptions import UserAlreadyExistError, UserNotFoundError
from models import User
from schemas import CreateAndUpdateUser


# Function to get list of users

Joaopcamposs

# schemas.py

from pydantic import BaseModel


# To support creation and update APIs
class CreateAndUpdateUser(BaseModel):
    name: str
    email: str
    password: str

Joaopcamposs

# models.py

from sqlalchemy.schema import Column
from sqlalchemy.types import String, Integer
from database import Base


class User(Base):
    __tablename__ = "users"
    id = Column(Integer, primary_key=True, index=True, autoincrement=True)