Spaces:
Sleeping
Sleeping
Download src/utils/database_utils.py from utkarsh134/FastAPI-HackathonIn2Mins: direct link, hf CLI and curl.
- Browser
- Download file 1.67 kB
-
https://huggingface.co/spaces/utkarsh134/FastAPI-HackathonIn2Mins/resolve/main/src/utils/database_utils.py
- Command line
-
hf download hf://spaces/utkarsh134/FastAPI-HackathonIn2Mins/src/utils/database_utils.py
-
curl -L -o database_utils.py https://huggingface.co/spaces/utkarsh134/FastAPI-HackathonIn2Mins/resolve/main/src/utils/database_utils.py
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) |