import sqlite3

def load_tickets():
    conn = sqlite3.connect('neuropulse.db')
    cursor = conn.cursor()
    cursor.execute("SELECT id, title, description, status FROM tickets")
    tickets = [{'id': row[0], 'title': row[1], 'description': row[2], 'status': row[3]} for row in cursor.fetchall()]
    conn.close()
    return tickets

def save_ticket(title, description):
    conn = sqlite3.connect('neuropulse.db')
    cursor = conn.cursor()
    cursor.execute("INSERT INTO tickets (title, description, status) VALUES (?, ?, ?)", (title, description, 'Ouvert'))
    conn.commit()
    conn.close()