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)