import sqlite3

def init_db():
    conn = sqlite3.connect("kunden.db")
    cursor = conn.cursor()
    cursor.execute("""
        CREATE TABLE IF NOT EXISTS kunden (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            name TEXT,
            adresse TEXT,
            termin DATE
        )
    """)
    conn.commit()
    conn.close()

def add_kunde(name, adresse, termin):
    conn = sqlite3.connect("kunden.db")
    cursor = conn.cursor()
    cursor.execute("INSERT INTO kunden (name, adresse, termin) VALUES (?, ?, ?)", (name, adresse, termin))
    conn.commit()
    conn.close()

def get_kunden():
    conn = sqlite3.connect("kunden.db")
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM kunden")
    kunden = cursor.fetchall()
    conn.close()
    return kunden


def get_kunde_by_id(kunde_id):
    conn = sqlite3.connect("kunden.db")
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM kunden WHERE id = ?", (kunde_id,))
    kunde = cursor.fetchone()
    conn.close()
    return kunde

def update_kunde(kunde_id, name, adresse, termin):
    conn = sqlite3.connect("kunden.db")
    cursor = conn.cursor()
    cursor.execute("UPDATE kunden SET name = ?, adresse = ?, termin = ? WHERE id = ?", 
                   (name, adresse, termin, kunde_id))
    conn.commit()
    conn.close()