def save( self ): # get the assignment values from the ui index = self.view.get_index() name = self.view.get_name() due = float(self.view.get_due()) max = float(self.view.get_max()) rcv = float(self.view.get_received()) grade = Grade(max,rcv) notes = self.view.get_notes() # store the new values in the assignment variable assignment = Assignment(-1,self.criteria,index,name,due,grade,notes) # save the changes into the db BGModelController.add_assignment( assignment )
def assignment_create(): if request.method == 'GET': return render_template('assignment_create.html') elif request.method == 'POST': assignment = Assignment( name=request.form['name'], description=request.form['description'], #comment=request.form['comment'],#ThiscausesanHTTP400whenavaluewasn'tsubmittedintheform(becauseofaKeyErrorontheMultiDict).Howstupid! due_date=request.form['due_date'], points=request.form['points'], is_public=request.form.get('is_public', False, bool)) assignment.save() if "create_and_add" in request.form: return render_template('assignment_create.html') elif "create" in request.form: return redirect( url_for('assignment_view', assignment_pk=assignment.pk))
def load_assignments(): """Load assignments from assignment.txt into database.""" print "Assignments" for i, row in enumerate(open("data/assignment.txt")): row = row.rstrip() cs_id, pi_id = row.split(", ") assignment = Assignment(cs_id=cs_id, pi_id=pi_id) # Add to the session. db.session.add(assignment) # Commit the session/data to the dbase. db.session.commit()
def add_assign(): """Add assignment to database.""" task = request.form.get("task") tech = request.form.get("tech") equip = request.form.get("equip") details = request.form.get("details") if task and tech and equip: task_ob = Task.query.get(task) equip_ob = Equipment.query.get(equip) name = task_ob.name + " (" + equip_ob.name + ")" tbd_stat = AssignStatus.query.filter_by(name="To Be Done").first() new_assign = Assignment(user_id=g.user_id, assignstat_id=tbd_stat.assignstat_id, name=name, date=datetime.now(), details=details) add_to_database(new_assign) new_assigntask = AssignmentTask(task_id=task, assignment_id=new_assign.assignment_id) new_assigntech = AssignmentTechnician( tech_id=tech, assignment_id=new_assign.assignment_id) new_assignequip = AssignmentEquipment( equip_id=equip, assignment_id=new_assign.assignment_id) add_to_database(new_assigntask) add_to_database(new_assigntech) add_to_database(new_assignequip) flash("Assignment successfully created.", "success") else: flash( "Make sure you have enough resources before creating a new assignment.", "warning") return redirect(request.referrer)