API Request Methods - Get Todos from Database

 API Request Methods - Get Todos from Database

Fetching all records:

Fetch Todos and dependency inversion.

code:

# This file it to perform all the activity which we required for Todo application.
# Depends means dependency injection
from fastapi import FastAPI, Depends
import models
from models import Todos
from database import engine, SessionLocal
from typing import Annotated
from sqlalchemy.orm import Session

app = FastAPI()

# it will execute only when todos.db is not existing.
# side effect if you enhance the table in model file then it will not update
# it in database automatically.
models.Base.metadata.create_all(bind=engine)
 
# creating db dependency
def get_db():
    # We need to fetch this SessionLocal before each request made to database.
    db = SessionLocal()
    try:
        # Only the code prio to and including the
        # yield statement will execute before sending the response.
        yield db
    finally:
        # It will be executed after sending the response.
        # It makes fastAPI quicker as we can fetch information
        # from the database and return it to client
        # and then can close the db connection.
        # It makes the connection extreamly safe.
        # As it will open the database connect only at the time of usage.
        db.close()

db_dependency = Annotated[Session, Depends(get_db)]
# Creating asynchronous API Endpoint for database interaction.
@app.get("/")
#async def read_all(db: Annotated[Session, Depends(get_db)]):
async def read_all(db: db_dependency):
    return db.query(Todos).all()

Fetching only one record:

Code:
# This file it to perform all the activity which we required for Todo application.
# Depends means dependency injection
from fastapi import FastAPI, Depends, HTTPException, Path
import models
from models import Todos
from database import engine, SessionLocal
from typing import Annotated
from sqlalchemy.orm import Session
from starlette import status

app = FastAPI()

# it will execute only when todos.db is not existing.
# side effect if you enhance the table in model file then it will not update
# it in database automatically.
models.Base.metadata.create_all(bind=engine)
 
# creating db dependency
def get_db():
    # We need to fetch this SessionLocal before each request made to database.
    db = SessionLocal()
    try:
        # Only the code prio to and including the
        # yield statement will execute before sending the response.
        yield db
    finally:
        # It will be executed after sending the response.
        # It makes fastAPI quicker as we can fetch information
        # from the database and return it to client
        # and then can close the db connection.
        # It makes the connection extreamly safe.
        # As it will open the database connect only at the time of usage.
        db.close()

db_dependency = Annotated[Session, Depends(get_db)]
# Creating asynchronous API Endpoint for database interaction.
@app.get("/", status_code=status.HTTP_200_OK)
#async def read_all(db: Annotated[Session, Depends(get_db)]):
async def read_all(db: db_dependency):
    return db.query(Todos).all()

@app.get("/todo/{todo_id}", status_code=status.HTTP_200_OK)
async def read_todo_by_id(db: db_dependency, todo_id: int = Path(gt=0)):
    todo_model= db.query(Todos).filter(Todos.id == todo_id).first()
    if todo_model is not None:
        return todo_model
    raise HTTPException(status_code=404, detail="id not found in table Todo")

Result:

Fetched all records:

Fetched specific record:

Specific id record not found:




Comments

Post a Comment

Popular posts from this blog

Path Parameter Data Validation | Query Parameter Data Validation

Image
 Path Parameter Data Validation Here we will try to put validation on each API endpoint we have created in FastAPI. Parts which we will try to validate is: If there is no book then are we returning any message as confirmation of validation? return desired message if your logic not executed as final return statement to validate your API endpoint run in place of showing null in output box or no message at output. How to validate input parameter of the method? We need to import path from FastAPI to implement it at the time of method definition to provide input constraints to be checked. @ app . get ( "/books/ {book_id} " ) async def read_book_by_id ( book_id : int = Path ( gt = 0 )): # it will make sure that index will start from 1.     for book in BOOKS :         if book . id == book_id :             return book     return { "message" : "book not found" } Code:  from fastapi import FastAPI , Bod...
Read more

CRUD Assignment

Image
 CRUD Assignment 1. Create a new API Endpoint that can fetch all books from a specific author using either Path Parameters or Query Parameters. Code and Result: As async is implemented by FastAPI itself hence ignored it. from fastapi import FastAPI app = FastAPI () BOOKS = [         { "title" : "Book One" , "author" : "Author A" , "category" : "Fiction" },         { "title" : "Book Two" , "author" : "Author B" , "category" : "Non-Fiction" },         { "title" : "Book Three" , "author" : "Author A" , "category" : "Biography" },         { "title" : "Book Four" , "author" : "Author A" , "category" : "Historical" },         { "title" : "Book Five" , "author" : "Author A" , "category" : "Romanc...
Read more

Python Variables

Python Variables   Variables: They are containers for holding data values. It will help you store the value in a memory location. example: cost = 10 print(cost) Now cost variable will direct you to get the information stored over the memory location which is holding the data 10. Variables help you to create formulas or help to reuse the data over different locations in a code. example: cost=10 tax_percent = 0.25 tax = cost * tax_percent price = cost I+ tax print(price) String datatype variable sample: username="Rock!rupesh" first_name="Rahul" print(username) print(first_name) print(username + " " + first_name) first_number=10 second_number=2 print(first_number) print(second_number) first_number=1 So you can modify the variable stored information according to your need. So as a summary variables are memory location which hold relevant information for your application.
Read more