FastAPI-HackathonIn2Mins / src /utils /database_utils.py
utkarsh134's picture
for pushin
233222c
Raw History Blame
1.67 kB
from typing import Dict, Any
from fastapi import HTTPException
from .database import DatabaseHandler
def save_to_database(drill_info: Dict[str, Any], db_handler: DatabaseHandler = None) -> None:
"""
Save drill information to the database.
Args:
drill_info: Dictionary containing event details
db_handler: Database handler instance (optional, will create one if not provided)
Raises:
HTTPException: If there's an error saving to the database
"""
try:
if db_handler is None:
db_handler = DatabaseHandler()
required_columns = [
"drillSubCategory",
"drillName",
"phaseStartDt",
"drillType",
"isDrillPaid",
"drillPurpose",
]
db_handler.create_table_if_not_exists("event_records", required_columns)
filtered_record = {}
for column in required_columns:
value = drill_info.get(column)
if column == "isDrillPaid":
filtered_record[column] = 1 if value else 0
elif column == "phaseStartDt":
from datetime import datetime
if isinstance(value, datetime):
filtered_record[column] = value.strftime("%d-%m-%Y")
else:
filtered_record[column] = value
else:
filtered_record[column] = value
db_handler.insert_record("hackathon_records", filtered_record)
except Exception as e:
error_msg = f"Database Error: {str(e)}"
print(error_msg)
raise HTTPException(status_code=500, detail=error_msg)