basic CRUD with FASTAPI + MONGODB + beanie

-

 main.py


from typing import Union

from fastapi import FastAPI

from routes import crud


from database.connection import init_db


app = FastAPI()


@app.on_event("startup")

async def connect():

    await init_db()


app.include_router(crud.router)

-----------------------------------------------

routes/crud.py


from fastapi import APIRouter, status

from database.models import Student


from database.schemas import Students, UpdateStudent


from bson.objectid import ObjectId


router = APIRouter()



@router.post("/student/", status_code=status.HTTP_200_OK, tags=['student'])

async def create_student(users: Students):

    try:

        stu_obj = Student(name=users.name, phone=users.phone, email=users.email, address=users.address)

        await stu_obj.insert()

        return {"status":"record inserted"}

    except Exception as e:

        print(e)

        return {"status":"error occured"}


@router.get("/student/", status_code=status.HTTP_200_OK, tags=['student'])

async def read_students():

    students = await Student.find_all().to_list()

    return students


@router.put("/student/", status_code=status.HTTP_200_OK, tags=['student'])

async def update_student(userid, users: UpdateStudent):

    objInstance = ObjectId(userid)

    try:

        stu_obj = await Student.find_one({"_id": objInstance})

        

        if users.name:

            await stu_obj.set({Student.name : users.name})

        if users.address: 

            await stu_obj.set({Student.address : users.address})

        if users.phone:

            await stu_obj.set({Student.phone : users.phone})

        if users.email:

            await stu_obj.set({Student.email : users.email})


        return {"status":"record updated"}

    except Exception as e:

        print(e)

        return {"status":"user id not exist!"}

    

@router.delete("/student/", status_code=status.HTTP_200_OK, tags=['student'])

async def delete_user(userid : str):

    objInstance = ObjectId(userid)

    try:

        stu_obj = await Student.find_one({"_id": objInstance})

        await stu_obj.delete()

        return {"status":"collection deleted"}     

    except Exception as e:

        print(e)

        return {"status":"something error occured"}        

----------------------------------------------------------------------------------

database/connection.py


from motor.motor_asyncio import AsyncIOMotorClient

from beanie import init_beanie


from .models import Student


async def init_db():

    client = AsyncIOMotorClient("mongodb+srv://iamshimantadas:9icJV6nfGTlFB0v5@cluster0.nyxj0fc.mongodb.net/")

    await init_beanie(database=client.db_name, document_models=[Student])

------------------------------------------------------------------------------------

database/models.py



from beanie import Document


class Student(Document):

    name : str

    phone : int

    address : str

    email : str

------------------------------------------------------------------------------------

database/schemas,py


from pydantic import BaseModel



class Students(BaseModel):

    name : str

    phone : int

    address : str

    email : str


class UpdateStudent(BaseModel):

    name : str | None = None

    phone : int  | None = None

    address : str | None = None

    email : str | None = None    

-----------------------------------------------------------------------------------



Popular posts from this blog

MCSL 216 MCA NEW Practical ~ common questions suggestions

-
Topic: JS VALIDATION   Q1. Design a form for booking room through a Hotel website. The form should have relevant fields (make suitable assumptions). Further, the form should have Submit and Reset button. Now, perform following: Marks: 20   Solution: <html>     <title>hotel form booking</title>     <body>         <br>         <h2>Hotel Form</h2>         <br>           <form id="booking_form">             <label for="p_name">Person Name</label> <br>             <input type="text" id="p_name" name="p_name">          ...
Read more

dev chaeatsheet

-
Image
dev cheatsheet link: https://docs.google.com/document/d/15gRGAB57iEFs_TGsqrk08_OZ36mX1yfsMKCYM6qX7gk/edit?usp=sharing Topic: WordPress Theme Dev We can develop our custom theme in wordpress. Let’s first understand the folder structure of wordpress.contact form Let me assure you, how can you make a proper structure of a wordpress project.  front-page.php: This template is used to display the front page of the site. It's often used for the site's homepage. index.php: This is the fallback template used when more specific templates are not available. It usually displays a list of posts. style.css: This file contains the styles for your theme. While it can include theme author details in comments, its primary purpose is to style the HTML elements of your theme. single.php: This template is used to display a single post's details.             404.php: handle 404 error page         ...
Read more

STRAPI

-
Image
  Strapi helps us to provide pre-made cms backend. In strapi everything is about content type.   Topic: Weird Things About STRAPI Topic: Document Save States When we want to store a post into strapi, that time it gives us 2 options: “publish”, “save”. When we create content as publish/save it creates 2 different records. First 2 are for “save” and the rest 2 are for “publish”. Good thing is when creating a new publish/save it delta the OLD one ID and create a NEW one. Topic: Content Type change in strapi We can add multiple fields into strapi content type. For changing the Column Type we need go in inside /src/your-content-type/schema.json /* OLD ONE */ "attributes": {     "title": {       "type": "string"     },     "description": {       "type": "text",   "length": 80     }, /* NEW ONE */ "description": {    ...
Read more