database/init_db.py

"""Database initialization - creates empty tables for incident logging"""
import sqlite3, os

DB_PATH = os.path.join(os.path.dirname(os.path.abspath(__file__)), 'roadsos.db')

def create_database():
    os.makedirs(os.path.dirname(DB_PATH), exist_ok=True)
    conn = sqlite3.connect(DB_PATH)
    conn.executescript('''
        CREATE TABLE IF NOT EXISTS trauma_centers (
            id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, city TEXT NOT NULL,
            state TEXT NOT NULL, latitude REAL NOT NULL, longitude REAL NOT NULL,
            phone TEXT, address TEXT, type TEXT DEFAULT 'Level-II',
            has_icu INTEGER DEFAULT 1, has_blood_bank INTEGER DEFAULT 0, open_24x7 INTEGER DEFAULT 1);
        CREATE TABLE IF NOT EXISTS incidents (
            id INTEGER PRIMARY KEY AUTOINCREMENT, timestamp TEXT NOT NULL,
            latitude REAL NOT NULL, longitude REAL NOT NULL, location_text TEXT,
            state TEXT, incident_type TEXT, severity TEXT, description TEXT,
            services_contacted TEXT, status TEXT DEFAULT 'reported');
        CREATE TABLE IF NOT EXISTS emergency_searches (
            id INTEGER PRIMARY KEY AUTOINCREMENT, timestamp TEXT NOT NULL,
            latitude REAL NOT NULL, longitude REAL NOT NULL, location_text TEXT,
            radius_km REAL, results_count INTEGER);
    ''')
    conn.commit()
    conn.close()
    print(f"✅ Database initialized at: {DB_PATH}")

if __name__ == '__main__':
    create_database()