class BusStop(db.Model):
__tablename__ = 'stops'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(40), nullable=False)
bus = db.Column(db.String(30),
db.ForeignKey('busses.name'),
nullable=False)
class Classes(db.Model):
__tablename__ = 'classes'
id = db.Column(db.Integer, primary_key=True, nullable=False)
courseNum = db.Column(db.String(15), nullable=False)
sectionNum = db.Column(db.String(2), nullable=False)
startTime = db.Column(db.String(4), nullable=False)
endTime = db.Column(db.String(4), nullable=False)
pm = db.Column(db.String(1), nullable=False)
meetingDay = db.Column(db.String(3), nullable=False)
campus = db.Column(db.String(10), nullable=False)
building = db.Column(db.String(20), nullable=False)
class User(UserMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), index=True, unique=True)
email = db.Column(db.String(120), index=True, unique=True)
password_hash = db.Column(db.String(128))
def __repr__(self):
return '<User {}>'.format(self.username)
def set_password(self, password):
self.password_hash = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password_hash, password)
@login.user_loader
def load_user(id):
return User.query.get(int(id))
class Schedule(db.Model):
__tablename__ = 'schedules'
id = db.Column(db.Integer, primary_key=True)
student = db.Column(db.Integer,
db.ForeignKey('students.id'),
nullable=False)
classID = db.Column(db.Integer,
db.ForeignKey('classes.id'),
nullable=False)
timePref = db.Column(db.Integer, nullable=False)
bus = db.Column(db.String(20),
db.ForeignKey('busses.name'),
nullable=False)
stop = db.Column(db.Integer, db.ForeignKey('stops.id'), nullable=False)
class Bus(db.Model):
__tablename__ = 'busses'
name = db.Column(db.String(30), primary_key=True, unique=True)
running = db.Column(db.String(1), nullable=False)
class Student(db.Model, UserMixin):
__tablename__ = 'students'
id = db.Column(db.Integer, primary_key=True, nullable=False)
name = db.Column(db.String(25), nullable=False)
number = db.Column(db.String(12), unique=True, nullable=False)