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)
