data_access.py

import sqlite3

DATABASE_NAME = 'progress.db'

def init_db():
    conn = sqlite3.connect(DATABASE_NAME)
    cursor = conn.cursor()
    cursor.execute('''
        CREATE TABLE IF NOT EXISTS progress (
            day INTEGER PRIMARY KEY,
            description TEXT NOT NULL
        )
    ''')
    conn.commit()
    conn.close()

def log_progress(day, progress):
    conn = sqlite3.connect(DATABASE_NAME)
    cursor = conn.cursor()
    cursor.execute('INSERT OR REPLACE INTO progress (day, description) VALUES (?, ?)', (day, progress))
    conn.commit()
    conn.close()

def view_progress():
    conn = sqlite3.connect(DATABASE_NAME)
    cursor = conn.cursor()
    cursor.execute('SELECT day, description FROM progress ORDER BY day ASC')
    progress = cursor.fetchall()
    conn.close()
    return progress

def edit_progress(day, new_progress):
    conn = sqlite3.connect(DATABASE_NAME)
    cursor = conn.cursor()
    cursor.execute('UPDATE progress SET description = ? WHERE day = ?', (new_progress, day))
    conn.commit()
    conn.close()

def get_progress(day):
    conn = sqlite3.connect(DATABASE_NAME)
    cursor = conn.cursor()
    cursor.execute('SELECT description FROM progress WHERE day = ?', (day,))
    result = cursor.fetchone()
    conn.close()
    return result[0] if result else ''