def select_project(): conn = clickDatabase.getConn('clickdb') pid = request.form.get('select-name') ###this line may not work if isValid(pid): return redirect(url_for('updateProject', pid=pid)) else: flash('Please select a project') return render_template('selectProject.html')
def select_posting(): conn = clickDatabase.getConn('clickdb') pid = request.form.get('select-name') ###???? if isValid(pid): return redirect(url_for('updatePosting', pid=pid)) else: flash('Please select a project posting') return render_template('selectPosting.html')
def students(): conn = clickDatabase.getConn('clickdb') if request.method == 'GET': students = clickDatabase.getStudents(conn) return render_template('students.html', students = students) else: if request.form['submit'] == 'Search': search = request.form.get('searchsStudents') filteredStudents = clickDatabase.searchStudents(conn, search) return render_template('students.html', jobs = filteredStudents)
def search_student(): name = request.form.get('search-name') conn = clickDatabase.getConn('clickdb') email = clickDatabase.get_email(conn, name) if isValid(email): return redirect(url_for('updateProject', email=email)) else: flash('Requested student does not exist') return render_template
def studentProfile(email): conn = clickDatabase.getConn('clickdb') studentInfo = clickDatabase.getStudent(conn, email) skills = clickDatabase.studentSkills(conn, email) #renders page with all information about student in database return render_template('studentProfile.html', name = studentInfo['name'], email = studentInfo['email'], active = studentInfo['active'], skills = skills)
def submit_insertProject(): conn = clickDatabase.getConn('clickdb') if request.method == 'POST': # checking database to see if the given pid is in use if (clickDatabase.search_project_pid( conn, request.form['project-pid'])) != None: flash('bad input: project\'s pid already in use.') return render_template('insertProject.html') # checking if info is missing in input if ((request.form['project-pid'] == "") or (request.form['project-name'] == "") or (request.form['project-pay'] == "") or (request.form['project-minHours'] == "") or (request.form['project-location'] == "")): if request.form['project-pid'] == "": flash('missing input: project\'s pid is missing.') if request.form['project-name'] == "": flash('missing input: name is missing.') if request.form['project-pay'] == "": flash('missing input: pay is missing.') if request.form['project-minHours'] == "": flash('missing input: minimum hours is missing.') if request.form['project-location'] == "": flash('missing input: location is missing.') return render_template('insertProject.html') if ((request.form['project-pid'] == "") and (request.form['project-name'] == "") and (request.form['project-pay'] == "") and (request.form['project-minHours'] == "") and (request.form['project-location'] == "")): projectInfo = clickDatabase.search_project_pid( conn, request.form['project-pid']) if projectInfo == None: clickDatabase.insert_project(conn, request.form['project-pid'], request.form['project-name'], request.form['project-pay'], request.form['project-minHours'], request.form['project-location']) flash('Project {name} was created successfully'.format( title=request.form['project-name'])) else: flash("Project already exists") return redirect( url_for('updateProject', pid=request.form['project-pid']))
def project(pid): conn = clickDatabase.getConn('clickdb') #if GET, renders page with all information about that project in database if request.method == 'GET': projectInfo = clickDatabase.getProject(conn, pid) return render_template('project.html', name = projectInfo['name'], minHours = projectInfo['minHours'], pay = projectInfo['pay'], location = projectInfo['location'], )
def studentUpdate(email): conn = clickDatabase.getConn('clickdb') studentInfo = clickDatabase.getStudent(conn, email) skills = clickDatabase.studentSkills(conn, email) #if GET, renders page with given information as default values in form if request.method == 'GET': return render_template('studentUpdate.html', name=studentInfo['name'], email=studentInfo['email'], active=studentInfo['active'], skills=skills) #if POST, updates profile else: # if student updates name, email, or active status if request.form['submit'] == 'Update Personal Information': newName = request.form.get('studentName') newEmail = request.form.get('studentEmail') newActive = request.form.get('studentActive') clickDatabase.updateStudentProfile(conn, email, newEmail, newName, newActive) flash("Profile successfully updated") return redirect(url_for('studentUpdate', email=newEmail)) # if student removes a skill elif request.form['submit'] == 'Remove': skill = request.form.get('skill') clickDatabase.removeSkill(conn, email, skill) return redirect( url_for('studentUpdate', email=studentInfo['email'])) #adding skill elif request.form['submit'] == 'Add skill': #try and except to handle errors if user tries to enter a #skill they've already added to their profile try: newSkill = request.form.get('newSkill') clickDatabase.addSkill(conn, email, newSkill) return redirect( url_for('studentUpdate', email=studentInfo['email'])) except: flash("Error. Skill may already be in your profile.") return redirect( url_for('studentUpdate', email=studentInfo['email'])) else: return redirect( url_for('studentProfile', email=studentInfo['email']))
def selectProject(): conn = clickDatabase.getConn('clickdb') allProjects = clickDatabase.find_allProjects(conn) return render_template('selectProject.html', allProjects=allProjects) if (clickDatabase.search_posting_pid(conn, request.form['posting-pid'])) != None: flash('bad input: project\'s pid already in use.') return render_template('insertPosting.html') # checking if info is missing in input if ((request.form['posting-pid'] == "") or (request.form['posting-name'] == "") or (request.form['posting-pay'] == "") or (request.form['posting-minHours'] == "") or (request.form['posting-location'] == "")): if request.form['posting-pid'] == "": flash('missing input: project\'s pid is missing.') if request.form['posting-name'] == "": flash('missing input: name is missing.') if request.form['posting-pay'] == "": flash('missing input: pay is missing.') if request.form['posting-minHours'] == "": flash('missing input: minimum hours is missing.') if request.form['posting-location'] == "": flash('missing input: location is missing.') return render_template('insertPosting.html') if ((request.form['posting-pid'] == "") and (request.form['posting-name'] == "") and (request.form['posting-pay'] == "") and (request.form['posting-minHours'] == "") and (request.form['posting-location'] == "")): postingInfo = clickDatabase.search_posting_pid(conn, request.form['posting-pid']) if postingInfo == None: clickDatabase.insert_posting(conn, request.form['posting-pid'], request.form['posting-name'], request.form['posting-pay'], request.form['posting-minHours'], request.form['posting-location']) flash('Posting {name} was created successfully'.format(title=request.form['posting-name'])) else: flash("Posting already exists") return redirect(url_for('updatePosting', pid = request.form['movie-posting']))
def selectProject(): conn = clickDatabase.getConn('clickdb') allProjects = clickDatabase.find_allProjects(conn) return render_template('selectProject.html', allProjects=allProjects)