aita_core.db — Database

SQLite database for interaction logs, student feedback, and feature requests. The database auto-initializes tables on first connection.

Connection

aita_core.db.get_conn()

Interactions

aita_core.db.log_interaction(student_id, week, question, response, sources)

aita_core.db.get_interactions(limit=100, offset=0, student_id=None)

aita_core.db.count_interactions(student_id=None)

aita_core.db.rate_interaction(interaction_id, rating)

Feedback

aita_core.db.add_feedback(student_id, interaction_id, rating, comment)

aita_core.db.get_feedback(limit=100)

Feature Requests

aita_core.db.add_feature_request(student_id, title, description)

aita_core.db.get_feature_requests(status=None, limit=100)

aita_core.db.update_feature_request_status(request_id, status)

Analytics

aita_core.db.get_interaction_stats()

Database Schema

CREATE TABLE interactions (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    timestamp TEXT NOT NULL,
    student_id TEXT NOT NULL,
    week INTEGER NOT NULL,
    question TEXT NOT NULL,
    response TEXT NOT NULL,
    sources TEXT,
    rating INTEGER
);

CREATE TABLE feedback (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    timestamp TEXT NOT NULL,
    student_id TEXT NOT NULL,
    interaction_id INTEGER REFERENCES interactions(id),
    rating INTEGER,
    comment TEXT
);

CREATE TABLE feature_requests (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    timestamp TEXT NOT NULL,
    student_id TEXT NOT NULL,
    title TEXT NOT NULL,
    description TEXT,
    status TEXT DEFAULT 'open'
);