File size: 9,009 Bytes
25732fb
 
29baa44
 
 
 
25732fb
 
29baa44
25732fb
 
 
 
29baa44
 
 
25732fb
29baa44
25732fb
 
 
 
29baa44
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
25732fb
 
29baa44
25732fb
 
 
 
 
29baa44
 
 
25732fb
 
29baa44
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
25732fb
29baa44
 
25732fb
29baa44
25732fb
29baa44
 
25732fb
 
29baa44
25732fb
 
29baa44
25732fb
 
29baa44
25732fb
 
 
29baa44
 
 
 
25732fb
 
 
29baa44
25732fb
 
29baa44
25732fb
29baa44
25732fb
 
 
 
 
 
29baa44
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
25732fb
 
29baa44
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
25732fb
29baa44
25732fb
29baa44
 
 
25732fb
 
 
 
29baa44
 
25732fb
 
29baa44
25732fb
 
 
29baa44
25732fb
29baa44
25732fb
 
 
29baa44
25732fb
29baa44
25732fb
 
 
 
29baa44
25732fb
 
 
 
29baa44
25732fb
29baa44
25732fb
 
29baa44
 
25732fb
 
 
 
29baa44
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
from datetime import datetime

from flask_sqlalchemy import SQLAlchemy
from sqlalchemy import inspect, text
from werkzeug.security import check_password_hash, generate_password_hash

db = SQLAlchemy()


class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    password_hash = db.Column(db.String(256))  # nullable for accounts created before v2
    learning_style = db.Column(db.String(30), default='mixed')
    goals = db.Column(db.JSON, default=list)
    created_at = db.Column(db.DateTime, default=datetime.utcnow)

    knowledge_states = db.relationship('KnowledgeState', backref='user', lazy=True)
    learning_sessions = db.relationship('LearningSession', backref='user', lazy=True)
    quiz_attempts = db.relationship('QuizAttempt', backref='user', lazy=True)

    def set_password(self, password):
        self.password_hash = generate_password_hash(password)

    def check_password(self, password):
        return bool(self.password_hash) and check_password_hash(self.password_hash, password)

    def to_dict(self):
        return {
            'user_id': self.id,
            'username': self.username,
            'email': self.email,
            'learning_style': self.learning_style or 'mixed',
            'goals': self.goals or [],
        }


class Topic(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    slug = db.Column(db.String(80), unique=True)
    name = db.Column(db.String(100), nullable=False)
    category = db.Column(db.String(50), nullable=False)
    difficulty = db.Column(db.String(20), nullable=False)
    description = db.Column(db.Text)
    prerequisites = db.Column(db.String(200))  # Comma-separated topic IDs
    key_concepts = db.Column(db.JSON, default=list)
    position = db.Column(db.Integer, default=0)

    knowledge_states = db.relationship('KnowledgeState', backref='topic', lazy=True)

    @property
    def prerequisite_ids(self):
        if not self.prerequisites:
            return []
        return [int(x) for x in self.prerequisites.split(',') if x.strip().isdigit()]

    def to_dict(self):
        return {
            'id': self.id,
            'slug': self.slug,
            'name': self.name,
            'category': self.category,
            'difficulty': self.difficulty,
            'description': self.description,
            'prerequisites': self.prerequisite_ids,
            'key_concepts': self.key_concepts or [],
        }


class KnowledgeState(db.Model):
    __table_args__ = (db.UniqueConstraint('user_id', 'topic_id', name='uq_knowledge_user_topic'),)

    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False, index=True)
    topic_id = db.Column(db.Integer, db.ForeignKey('topic.id'), nullable=False)
    knowledge_level = db.Column(db.Float, default=0.0)  # BKT posterior P(mastered)
    confidence = db.Column(db.Float, default=0.0)
    last_practiced = db.Column(db.DateTime, default=datetime.utcnow)
    practice_count = db.Column(db.Integer, default=0)
    correct_count = db.Column(db.Integer, default=0)
    updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)


class LearningSession(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False, index=True)
    topic_id = db.Column(db.Integer, db.ForeignKey('topic.id'), nullable=False)
    content = db.Column(db.Text, nullable=False)
    difficulty = db.Column(db.String(20))
    strategy = db.Column(db.String(50))
    context_bucket = db.Column(db.String(20))
    reward_sum = db.Column(db.Float, default=0.0)
    reward_count = db.Column(db.Integer, default=0)
    duration = db.Column(db.Integer)  # in seconds
    created_at = db.Column(db.DateTime, default=datetime.utcnow)


class QuizAttempt(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False, index=True)
    topic_id = db.Column(db.Integer, db.ForeignKey('topic.id'), nullable=False)
    question_id = db.Column(db.Integer, db.ForeignKey('question_bank.id'))
    question = db.Column(db.Text, nullable=False)
    user_answer = db.Column(db.Text)
    correct_answer = db.Column(db.Text)
    is_correct = db.Column(db.Boolean)
    difficulty = db.Column(db.String(20))
    time_taken = db.Column(db.Integer)  # in seconds
    created_at = db.Column(db.DateTime, default=datetime.utcnow, index=True)


class QuestionBank(db.Model):
    """Reusable question pool. Most quizzes are assembled from here without an LLM call."""
    __tablename__ = 'question_bank'

    id = db.Column(db.Integer, primary_key=True)
    topic_id = db.Column(db.Integer, db.ForeignKey('topic.id'), nullable=False, index=True)
    difficulty = db.Column(db.String(20), nullable=False)
    concept = db.Column(db.String(120))
    question = db.Column(db.Text, nullable=False)
    question_hash = db.Column(db.String(40), unique=True)
    options = db.Column(db.JSON, nullable=False)
    correct_answer = db.Column(db.String(1), nullable=False)
    explanation = db.Column(db.Text)
    source = db.Column(db.String(20), default='llm')  # seed | llm
    times_served = db.Column(db.Integer, default=0)
    times_answered = db.Column(db.Integer, default=0)
    times_correct = db.Column(db.Integer, default=0)
    created_at = db.Column(db.DateTime, default=datetime.utcnow)

    @property
    def empirical_p_correct(self):
        # Beta(2,2)-smoothed proportion correct, an item-difficulty estimate
        return (self.times_correct + 2) / (self.times_answered + 4)

    def to_public_dict(self):
        """What the client sees while answering: no answer key; grading happens server-side."""
        return {
            'id': self.id,
            'question': self.question,
            'options': self.options,
            'difficulty': self.difficulty,
            'concept': self.concept,
        }


class AgentKnowledge(db.Model):
    """Stores learned patterns and strategies for each agent (e.g. bandit arm posteriors)."""
    id = db.Column(db.Integer, primary_key=True)
    agent_type = db.Column(db.String(50), index=True)
    knowledge_type = db.Column(db.String(50))
    key = db.Column(db.String(120), index=True)
    content = db.Column(db.JSON)
    effectiveness_score = db.Column(db.Float, default=0.5)
    usage_count = db.Column(db.Integer, default=0)
    created_at = db.Column(db.DateTime, default=datetime.utcnow)
    updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)


class AgentMessage(db.Model):
    """Communication between agents (kept for backwards compatibility)."""
    id = db.Column(db.Integer, primary_key=True)
    from_agent = db.Column(db.String(50))
    to_agent = db.Column(db.String(50))
    message_type = db.Column(db.String(50))
    content = db.Column(db.JSON)
    status = db.Column(db.String(20))
    created_at = db.Column(db.DateTime, default=datetime.utcnow)
    processed_at = db.Column(db.DateTime)


class AgentPerformance(db.Model):
    """Per-run agent telemetry."""
    id = db.Column(db.Integer, primary_key=True)
    agent_id = db.Column(db.String(50))
    action_type = db.Column(db.String(50))
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    success_metric = db.Column(db.Float)
    api_calls_used = db.Column(db.Integer, default=0)
    execution_time_ms = db.Column(db.Integer)
    created_at = db.Column(db.DateTime, default=datetime.utcnow)


class ContentLibrary(db.Model):
    """Generated content cache (lessons, study tips) to reduce LLM calls."""
    id = db.Column(db.Integer, primary_key=True)
    topic_id = db.Column(db.Integer, db.ForeignKey('topic.id'))
    content_type = db.Column(db.String(50), index=True)
    cache_key = db.Column(db.String(200), index=True)
    difficulty = db.Column(db.String(20))
    content = db.Column(db.Text)
    meta_data = db.Column(db.JSON)
    quality_score = db.Column(db.Float, default=0.5)
    usage_count = db.Column(db.Integer, default=0)
    created_at = db.Column(db.DateTime, default=datetime.utcnow)


def migrate_schema():
    """Tiny additive migration for SQLite databases created by v1 (adds missing columns)."""
    inspector = inspect(db.engine)
    existing_tables = set(inspector.get_table_names())
    with db.engine.begin() as conn:
        for table in db.metadata.sorted_tables:
            if table.name not in existing_tables:
                continue
            present = {c['name'] for c in inspector.get_columns(table.name)}
            for column in table.columns:
                if column.name in present:
                    continue
                col_type = column.type.compile(dialect=db.engine.dialect)
                conn.execute(text(f'ALTER TABLE "{table.name}" ADD COLUMN "{column.name}" {col_type}'))