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'))