def status():
if request.method <> 'POST':
status = db.getStatuses(g.db)
return render_template('status.html', status = status)
else:
debug('Adding the status : ' + request.form['status'])
db.addStatus(g.db, request.form['status'], request.form['description'])
status = db.getStatuses(g.db)
return render_template('status.html', status = status)
def bug():
bug_id = request.args.get('bug_id', '')
if request.method <> 'POST':
debug('Calling getBugHeader')
bugh = db.getBugHeader(g.db, bug_id)
debug('Calling getBugBody')
bugb = db.getBugBody(g.db, bug_id)
all_status = db.getStatuses(g.db)
all_users = db.getUsers(g.db)
return render_template('bug.html', bugh = bugh, bugb = bugb, all_status = all_status, all_users = all_users)
else:
debug('Creating dictionary of bug to update the header for '+str(bug_id))
assigned_to_user_id = db.getUser(g.db, request.form['assigned_to_username'])['user_id']
updating_user_id = db.getUser(g.db, session['username'])['user_id']
bug = dict(title = request.form['title'], customer=request.form['customer'], updated_by_username = session['username'], assigned_to_user_id = assigned_to_user_id ,assigned_to_username = request.form['assigned_to_username'], description = request.form['description'], priority = request.form['priority'], status = request.form['status'], updating_user_id = updating_user_id, bug_id = bug_id)
# creating list of header updates onto the body
debug(str(bug_id))
bugh = db.getBugHeader(g.db, bug_id)
changedString = ""
if bugh['title'] <> bug['title']:
changedString += "** Changed Title from "+bugh['title']+" to "+ bug['title'] + "\n"
#if bugh['description'] <> bug['description']:
# changedString += "** Changed Description from "+bugh['description']+" to "+ bug['description'] + "\n"
if bugh['assigned_to_user_id'] <> bug['assigned_to_user_id']:
to = db.getUserEmail(g.db,bug['assigned_to_user_id'])
debug('Sending email to notify assignation to : '+to)
changedString += "** Changed Assigned from "+ bugh['assigned_to_username'] + " to "+ request.form['assigned_to_username'] + "\n"
debug (changedString)
emails.bugAssignNotify(bug, to)
if bugh['description'] <> bug['description']:
changedString += "** Changed Bug Description from " + "\n" + bugh['description']
if bugh['customer'] <> bug['customer']:
changedString += "** Changed Customer from "+bugh['customer']+" to "+ bug['customer'] + "\n"
if bugh['status'] <> bug['status']:
changedString += "** Changed Status from "+bugh['status']+" to "+ bug['status'] + "\n"
if str(bugh['priority']) <> str(bug['priority']):
changedString += "** Changed Priority from "+str(bugh['priority'])+" to "+ str(bug['priority']) + "\n"
debug(changedString)
# Now updating the header with changes
db.updateBugHeader(g.db, bug)
newUpdate = changedString + "\n" + request.form['newupdate']
bugUpdate = dict(update = newUpdate, updated_by_user_id = updating_user_id, bug_id = bug_id)
db.insertBugUpdate(g.db, bugUpdate)
return redirect(url_for('queue'))
