Spaces:
Sleeping
Sleeping
File size: 2,083 Bytes
7cb4836 | 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 | from app import db
from datetime import datetime
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
created_at = db.Column(db.DateTime, default=datetime.utcnow)
# Relationship with progress
progress_entries = db.relationship('Progress', backref='user', lazy=True)
class Tutorial(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(200), nullable=False)
slug = db.Column(db.String(100), unique=True, nullable=False)
category = db.Column(db.String(50), nullable=False)
difficulty = db.Column(db.String(20), nullable=False) # beginner, intermediate, advanced
order_index = db.Column(db.Integer, nullable=False)
estimated_time = db.Column(db.Integer) # in minutes
description = db.Column(db.Text)
created_at = db.Column(db.DateTime, default=datetime.utcnow)
class Progress(db.Model):
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
tutorial_id = db.Column(db.Integer, db.ForeignKey('tutorial.id'), nullable=False)
completed = db.Column(db.Boolean, default=False)
current_step = db.Column(db.Integer, default=0)
completion_date = db.Column(db.DateTime)
created_at = db.Column(db.DateTime, default=datetime.utcnow)
updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
class Project(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(200), nullable=False)
slug = db.Column(db.String(100), unique=True, nullable=False)
category = db.Column(db.String(50), nullable=False)
difficulty = db.Column(db.String(20), nullable=False)
description = db.Column(db.Text)
estimated_time = db.Column(db.Integer) # in minutes
prerequisites = db.Column(db.Text) # JSON string of tutorial IDs
created_at = db.Column(db.DateTime, default=datetime.utcnow)
|