Spaces:
Sleeping
Sleeping
File size: 1,673 Bytes
233222c | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 | 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) |