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)