def file_upload(response): auth.require_user(response) user = auth.get_user(response) if user == None: return else: username = user.get_username() ul_error_msg = "" filename, content_type, data = response.get_file('to_upload') if response.get_field("ul_flag") == "True": # we did submit a form print"#####", response.get_field("subject") if data == None or response.get_field("subject") == None or response.get_field("category") == None or response.get_field("description") == None: ul_error_msg = "Make sure you have all fields filled in and have selected a file. If you have joined any subject(s), you cannot upload files." else: #A form was submitted with content. Proceed with upload print "a form was submitted" _do_upload(response) return # we did not submit a form or it's wrong print "loading page first time" listofsubjects = [] for item in user.get_subjects(): listofsubjects.append([item, database_subject.get_subject(item).get_name().replace("_", " ")]) print "item", item context = {"css": "fileupload", "title": "File Uploader", "ul_err_msg": ul_error_msg, "ulsubjects": listofsubjects, "ulcategories": ["Notes", "Exam Paper","Exercises", "Solution"], "user": user} template.render_template("templates/fileupload.html", context, response)
def viewsubject(response, subjectid, resourcetype, page): auth.require_user(response) if not resourcetype: resourcetype = 'All' if not page: page = 1 user = auth.get_user(response) info = database_subject.get_subject(int(subjectid)) lower = (int(page) - 1 )*10 upper = int(page)*10 - 1 top_resources = dbfiles.getFilesSubject(int(subjectid)) sorted(top_resources, key=attrgetter('rank'), reverse=True) #eliminate those without the correct type new_top = [] if len(top_resources): for s in top_resources: if s.category == resourcetype or resourcetype == 'All': new_top.append(s) top_resources = new_top[lower:upper] all_resources = dbfiles.getFilesSubject(int(subjectid)) sorted(all_resources, key=attrgetter('ori_filename')) if len(all_resources): new_all = [] for s in all_resources: if s.category == resourcetype or resourcetype == 'All': new_all.append(s) all_resources = new_all[lower:upper] template.render_template("templates/subject_view_template.html",{"user":user, "css":"subject","subject":info,"top_resources":top_resources,"all_resources":all_resources,'current_Wall':subjectid,'wallorfeed':'wallupdate','can_use_wall':True},response)
def get_wall(self): final = [] data = self.cursor.execute('SELECT * FROM WALL ORDER BY time DESC') if not data: return 0 for row in data: current_Row = [[row[0],row[1],row[1],row[2],row[4],age(int(row[3])),'']]; if row[2] == self.current_Wall: author = User.get(row[1]) fullname = author.get_first_name() + " " + author.get_last_name() path = author.get_profile_pic_path() if not path: current_Row[0][6] = '/static/images/default_avatar.jpeg' else: current_Row[0][6] = path if current_Row[0][3].isdigit(): current_Row[0][3] = database_subject.get_subject(current_Row[0][3]).get_name() current_Row[0][3] = current_Row[0][3].replace('_',' ') current_Row[0][3] = 'Posted to ' + current_Row[0][3] elif current_Row[0][3] == current_Row[0][2]: current_Row[0][3] = '' else: current_Row[0][3] = 'Posted to ' + current_Row[0][3] +'\'s wall' current_Row[0][1] = fullname final.append(current_Row[0]) return final
def mysubjects(response): user = auth.get_user(response) subjectlist = user.get_subjects() tmp_list = [] for sub in subjectlist: sub = database_subject.get_subject(sub) tmp_list.append(sub) subjectlist = tmp_list template.render_template("templates/subject_list_template.html",{"user":user, "css":"subject","subjectlist":subjectlist},response) targetsubject=response.get_field("subjectselected")
def get_wall(self): final = [] data = self.cursor.execute('SELECT * FROM WALL ORDER BY time DESC') if not data: return 0 for row in data: current_Row = [[ row[0], row[1], row[1], row[2], row[4], age(int(row[3])), '' ]] if row[2] == self.current_Wall: author = User.get(row[1]) fullname = author.get_first_name( ) + " " + author.get_last_name() path = author.get_profile_pic_path() if not path: current_Row[0][6] = '/static/images/default_avatar.jpeg' else: current_Row[0][6] = path if current_Row[0][3].isdigit(): current_Row[0][3] = database_subject.get_subject( current_Row[0][3]).get_name() current_Row[0][3] = current_Row[0][3].replace('_', ' ') current_Row[0][3] = 'Posted to ' + current_Row[0][3] elif current_Row[0][3] == current_Row[0][2]: current_Row[0][3] = '' else: current_Row[0][ 3] = 'Posted to ' + current_Row[0][3] + '\'s wall' current_Row[0][1] = fullname final.append(current_Row[0]) return final
def getsubjectname(self): return database_subject.get_subject(self.subjectid).get_name().replace("_", " ")
def get_feed(self): final = [] friendsList = get_friends(self.current_User) data = self.cursor.execute('SELECT * FROM WALL ORDER BY time DESC LIMIT 15;') if not data: return 0 for row in data: current_Row = [[row[0],row[1],row[1],row[2],row[4],age(int(row[3])),'']] for user in friendsList: if user.get_username() == row[1]: if current_Row not in final: fullname = user.get_first_name() + " " + user.get_last_name() current_Row[0][1] = fullname #set the picture path = user.get_profile_pic_path() if not path: current_Row[0][6] = '/static/images/default_avatar.jpeg' else: current_Row[0][6] = path if current_Row[0][3].isdigit(): current_Row[0][3] = database_subject.get_subject(current_Row[0][3]).get_name() current_Row[0][3] = current_Row[0][3].replace('_',' ') current_Row[0][3] = 'Posted to ' + current_Row[0][3] elif current_Row[0][3] == current_Row[0][2]: current_Row[0][3] = '' else: current_Row[0][3] = 'Posted to ' + current_Row[0][3] +'\'s wall' final.append(current_Row[0]) if self.currentUserObject.get_username() == row[1]: currentuser = self.currentUserObject fullname = currentuser.get_first_name() + " " + currentuser.get_last_name() current_Row[0][1] = fullname path = currentuser.get_profile_pic_path() if not path: current_Row[0][6] = '/static/images/default_avatar.jpeg' else: current_Row[0][6] = path if current_Row[0][3].isdigit(): current_Row[0][3] = database_subject.get_subject(current_Row[0][3]).get_name() current_Row[0][3] = current_Row[0][3].replace('_',' ') current_Row[0][3] = 'Posted to ' + current_Row[0][3] elif current_Row[0][3] == current_Row[0][2]: current_Row[0][3] = '' else: current_Row[0][3] = 'Posted to ' + current_Row[0][3]+'\'s wall' final.append(current_Row[0]) # elif row[0] not in final[0]: # print final[0] return final
def getsubjectname(self): return database_subject.get_subject(self.subjectid).get_name().replace( "_", " ")
def get_feed(self): final = [] friendsList = get_friends(self.current_User) data = self.cursor.execute( 'SELECT * FROM WALL ORDER BY time DESC LIMIT 15;') if not data: return 0 for row in data: current_Row = [[ row[0], row[1], row[1], row[2], row[4], age(int(row[3])), '' ]] for user in friendsList: if user.get_username() == row[1]: if current_Row not in final: fullname = user.get_first_name( ) + " " + user.get_last_name() current_Row[0][1] = fullname #set the picture path = user.get_profile_pic_path() if not path: current_Row[0][ 6] = '/static/images/default_avatar.jpeg' else: current_Row[0][6] = path if current_Row[0][3].isdigit(): current_Row[0][3] = database_subject.get_subject( current_Row[0][3]).get_name() current_Row[0][3] = current_Row[0][3].replace( '_', ' ') current_Row[0][ 3] = 'Posted to ' + current_Row[0][3] elif current_Row[0][3] == current_Row[0][2]: current_Row[0][3] = '' else: current_Row[0][3] = 'Posted to ' + current_Row[0][ 3] + '\'s wall' final.append(current_Row[0]) if self.currentUserObject.get_username() == row[1]: currentuser = self.currentUserObject fullname = currentuser.get_first_name( ) + " " + currentuser.get_last_name() current_Row[0][1] = fullname path = currentuser.get_profile_pic_path() if not path: current_Row[0][6] = '/static/images/default_avatar.jpeg' else: current_Row[0][6] = path if current_Row[0][3].isdigit(): current_Row[0][3] = database_subject.get_subject( current_Row[0][3]).get_name() current_Row[0][3] = current_Row[0][3].replace('_', ' ') current_Row[0][3] = 'Posted to ' + current_Row[0][3] elif current_Row[0][3] == current_Row[0][2]: current_Row[0][3] = '' else: current_Row[0][ 3] = 'Posted to ' + current_Row[0][3] + '\'s wall' final.append(current_Row[0]) # elif row[0] not in final[0]: # print final[0] return final