database.py

import sqlite3
from datetime import datetime

def init_db():
    conn = sqlite3.connect("tasks.db")
    cursor = conn.cursor()
    cursor.execute("""
        CREATE TABLE IF NOT EXISTS tasks (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            name TEXT NOT NULL,
            due_date TEXT,
            status TEXT DEFAULT 'niezrobione'
        )
    """)
    conn.commit()
    conn.close()

def add_task(name, due_date, status="niezrobione"):
    conn = sqlite3.connect("tasks.db")
    cursor = conn.cursor()
    cursor.execute("INSERT INTO tasks (name, due_date, status) VALUES (?, ?, ?)", (name, due_date, status))
    conn.commit()
    conn.close()

def get_tasks(filter_status=None):
    conn = sqlite3.connect("tasks.db")
    cursor = conn.cursor()
    if filter_status and filter_status != "Wszystkie":
        cursor.execute("SELECT id, name, due_date, status FROM tasks WHERE status = ?", (filter_status,))
    else:
        cursor.execute("SELECT id, name, due_date, status FROM tasks")
    tasks = cursor.fetchall()
    conn.close()
    return tasks

def delete_task(task_id):
    conn = sqlite3.connect("tasks.db")
    cursor = conn.cursor()
    cursor.execute("DELETE FROM tasks WHERE id = ?", (task_id,))
    conn.commit()
    conn.close()

def toggle_status(task_id):
    conn = sqlite3.connect("tasks.db")
    cursor = conn.cursor()
    cursor.execute("SELECT status FROM tasks WHERE id = ?", (task_id,))
    current = cursor.fetchone()[0]
    new_status = "zrobione" if current == "niezrobione" else "niezrobione"
    cursor.execute("UPDATE tasks SET status = ? WHERE id = ?", (new_status, task_id))
    conn.commit()
    conn.close()

def update_task(task_id, name, due_date):
    conn = sqlite3.connect("tasks.db")
    cursor = conn.cursor()
    cursor.execute("UPDATE tasks SET name = ?, due_date = ? WHERE id = ?", (name, due_date, task_id))
    conn.commit()
    conn.close()