class Student_Course(db.Model):
student_course_id = db.Column(db.Integer, primary_key=True)
student_id = db.Column(db.Integer,
db.ForeignKey('student.student_id'),
nullable=False)
course_id = db.Column(db.Integer,
db.ForeignKey('courses.course_id'),
nullable=False)
class Notes(db.Model):
note_id = db.Column(db.Integer, primary_key=True)
course_id = db.Column(db.Integer,
db.ForeignKey('courses.course_id'),
nullable=False)
student_id = db.Column(db.Integer,
db.ForeignKey('student.student_id'),
nullable=False)
Note = db.Column(db.LargeBinary, nullable=False)
class Courses(db.Model):
course_id = db.Column(db.String(20), primary_key=True)
uni_id = db.Column(db.Integer,
db.ForeignKey('university.id'),
nullable=False)
name = db.Column(db.String(40), nullable=False, unique=True)
faculty_id = db.Column(db.Integer,
db.ForeignKey('faculty.faculty_id'),
nullable=False)
class Department(db.Model):
id = db.Column(db.Integer, primary_key=True)
uni_id = db.Column(db.Integer,
db.ForeignKey('university.id'),
nullable=False)
name = db.Column(db.String(40), nullable=False)
college_id = db.Column(db.Integer,
db.ForeignKey('college.id'),
nullable=False)
def getDepartment(uni_admin_id):
return Department.query.filter_by(uni_id=uni_admin_id).all()
class Courses(db.Model):
id = db.Column(db.Integer, primary_key=True)
uni_id = db.Column(db.Integer,
db.ForeignKey('university.id'),
nullable=False)
name = db.Column(db.String(40), nullable=False)
faculty_id = db.Column(db.Integer,
db.ForeignKey('faculty.id'),
nullable=False)
department_id = db.Column(db.Integer,
db.ForeignKey('department.id'),
nullable=False)
def getCourse(uni_admin_id): #will also work for faculty-course table
return Courses.query.filter_by(uni_id=uni_admin_id).all()
class Feedback(db.Model):
id = db.Column(db.Integer, primary_key=True)
note_id = db.Column(db.Integer, db.ForeignKey('notes.id'), nullable=False)
faculty_id = db.Column(db.Integer,
db.ForeignKey('faculty.id'),
nullable=False)
feedback = db.Column(db.String(500), nullable=False)
def fbl(student_user_id): #Returns all the feedback for a given student.
student = Student.query.filter_by(user_id=student_user_id).first()
Feedbackstudent = []
for n in Notes.query.filter_by(student_id=student.id):
for f in Feedback.query.all():
if f.note_id == n.id:
Feedbackstudent.append(f)
return Feedbackstudent
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
#username=db.Column(db.String(25),nullable=False,unique=True)
password = db.Column(db.String(150), nullable=False)
email = db.Column(db.String(40), nullable=False, unique=True)
university_id = db.Column(db.Integer,
db.ForeignKey('university.id'),
nullable=False)
st_fa = db.Column(db.Boolean, nullable=False) #True if Faculty
uni_admin_check = db.Column(db.Boolean, nullable=False) #True if Uniadmin
class Rating(db.Model):
id = db.Column(db.Integer, primary_key=True)
note_id = db.Column(db.Integer, db.ForeignKey('notes.id'), nullable=False)
rating = db.Column(db.Integer, nullable=False)
student_id = db.Column(db.Integer,
db.ForeignKey('student.id'),
nullable=False)
def getRatingNote(noteid):
return int(Rating.query.filter_by(note_id=noteid).first())
def getAverageRating(noteID): #Prints the average rating for a given Note
R = []
for ra in Rating.query.filter_by(note_id=noteID).all():
R.append(ra.rating)
if len(R) == 0:
return 'No Ratings Yet'
return sum(R) / len(
R) #Returns the average of the list of rating for a Note ID
class Faculty(db.Model):
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
firstname = db.Column(db.String(20), nullable=False)
lastname = db.Column(db.String(20), nullable=False)
def getFaculty(uni_id): #uni_id is admin id
FacultyList = []
for uzer in User.GetUserOfUni(uni_id):
if Faculty.query.filter_by(user_id=uzer.id).first():
FacultyList.append(
Faculty.query.filter_by(user_id=uzer.id).first())
return FacultyList
class Notes(db.Model):
id = db.Column(db.Integer, primary_key=True)
course_id = db.Column(db.Integer,
db.ForeignKey('courses.id'),
nullable=False)
student_id = db.Column(db.Integer,
db.ForeignKey('student.id'),
nullable=False)
Note = db.Column(db.LargeBinary, nullable=False)
approve = db.Column(db.Boolean, nullable=False)
def GetFacultyNotes(
Faculty_User_id
): #returns all the notes for the courses which the faculty teaches.
facid = Faculty.query.filter_by(user_id=Faculty_User_id).first().id
cours = Courses.query.filter_by(faculty_id=facid).all()
NoteList = []
for n in Notes.query.all():
for co in cours:
if co.id == n.course_id:
NoteList.append(n)
return NoteList
class Student(db.Model):
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
firstname = db.Column(db.String(20), nullable=False)
lastname = db.Column(db.String(20), nullable=False)
def getStudent(uni_id): #uni_id is admin uni id
studentlist = []
for uzer in User.GetUserOfUni(uni_id):
if Student.query.filter_by(user_id=uzer.id).first():
studentlist.append(
Student.query.filter_by(user_id=uzer.id).first())
return studentlist
def getStudentFromUserID(userid):
return Student.query.filter_by(user_id=userid).first()
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
password = db.Column(db.String(150), nullable=False)
email = db.Column(db.String(40), nullable=False, unique=True)
university_id = db.Column(db.Integer,
db.ForeignKey('university.id'),
nullable=False)
st_fa = db.Column(db.Boolean, nullable=False) #True if Faculty
uni_admin_check = db.Column(db.Boolean, nullable=False) #True if Uniadmin
def get_reset_token(self, expires_sec=1800):
s = Serializer(app.config['SECRET_KEY'], expires_sec)
return s.dumps({'user_id': self.id}).decode('utf-8')
def GetUser(id):
return User.query.filter_by(id=id).all()
def GetUserOfUni(uni_admin_uni_id):
return User.query.filter_by(university_id=uni_admin_uni_id).all()
class Student_Course(db.Model):
id = db.Column(db.Integer, primary_key=True)
student_id = db.Column(db.Integer,
db.ForeignKey('student.id'),
nullable=False)
course_id = db.Column(db.Integer,
db.ForeignKey('courses.id'),
nullable=False)
def getStudentCourse_ofUni(uni_admin_id):
student_course_list = []
students = Student.getStudent(uni_admin_id)
for z in students:
for stcr in Student_Course.query.all():
if stcr.student_id == z.id:
student_course_list.append(stcr)
return student_course_list
def studentcourselist(
user_id
): #Get all the courses for which a student is registered for...
student = Student.query.filter_by(
user_id=user_id).first() # Get The Student
studentcourseList = [] #Add Courses he is registered for to this list
print("THE TEST ID OF THE STUDENT IS ")
print(student.id)
StudentCourses = Student_Course.query.filter_by(
student_id=student.id).all() #check if this works.
print("TEST-2 VIEW ALL COURSE")
for sc in StudentCourses:
print("Student id is " + str(sc.student_id))
print("Course id is " + str(sc.course_id))
for courses in Courses.query.all():
for studentcourse in StudentCourses:
if studentcourse.course_id == courses.id:
studentcourseList.append(courses)
return studentcourseList
def ReturnApproveNotesStudent(
userid
): #Returns Notes which have been approved by the professor for the courses the student is in
student = Student.query.filter_by(user_id=userid).first()
courseidlist = []
FilterStudent = Student_Course.query.filter_by(
student_id=student.id).all()
approveNotes = []
for fs in FilterStudent:
courseidlist.append(fs.course_id)
print(
"The courses for which this student has registered are- RANS function"
)
for course in courseidlist:
print(course)
for note in Notes.query.all():
if note.approve == True and note.course_id in courseidlist:
approveNotes.append(note)
return approveNotes
class Uni_admin(db.Model):
uni_ad_id = db.Column(db.Integer, primary_key=True) #admin id
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
firstname = db.Column(db.String(20), nullable=False)
lastname = db.Column(db.String(20), nullable=False)
class Faculty(db.Model):
faculty_id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
firstname = db.Column(db.String(20), nullable=False)
lastname = db.Column(db.String(20), nullable=False)
class Rating(db.Model):
rating_id = db.Column(db.Integer, primary_key=True)
note_id = db.Column(db.Integer,
db.ForeignKey('notes.note_id'),
nullable=False)
rating = db.Column(db.Integer, nullable=False)
class Department(db.Model):
department_id = db.Column(db.Integer, primary_key=True)
uni_id = db.Column(db.Integer,
db.ForeignKey('university.id'),
nullable=False)
name = db.Column(db.String(40), nullable=False, unique=True)
