def add_skill(engineer): engineer = User.query.filter_by(engineer=engineer).first_or_404() form = SkillForm() if form.validate_on_submit(): skill = Skills(skill_name=form.skill_name.data, skill_strength=form.skill_strength.data, engineer=engineer, skill_engineer=engineer.engineer) print "skill is:" + repr(skill) db.session.add(skill) db.session.commit() skill_list = engineer.skills.all() return render_template('skills.html', title='Engineer Skills', engineer=engineer.engineer, skills=skill_list) return render_template('add_skill.html', title='Add a Skill', engineer=engineer.engineer, form=form)
def add_skill(): """Route to add skill to database and redirect to index page""" skills = mongo.db.Skills form = SkillForm() if request.method == 'POST' and form.validate_on_submit(): skills.insert( { 'skill_name': request.form.get('skill_name'), 'percent': int(request.form.get('percent')), 'skill_icon': request.form.get('skill_icon') }) return redirect(url_for('index')) return render_template('pages/add/skill.html', form=form)
def edit_skill(skill_id): """Route to edit skill in database and redirect to index page""" skills = mongo.db.Skills the_skill = mongo.db.Skills.find_one({'_id': ObjectId(skill_id)}) form = SkillForm() form.skill_name.data = the_skill['skill_name'] form.percent.data = the_skill['percent'] form.skill_icon.data = the_skill['skill_icon'] if request.method == 'POST' and form.validate_on_submit(): skills.update({'_id': ObjectId(skill_id)}, { 'skill_name': request.form.get('skill_name'), 'percent': int(request.form.get('percent')), 'skill_icon': request.form.get('skill_icon') }) return redirect(url_for('index')) return render_template('pages/edit/skill.html', skill=the_skill, form=form)
def addskill(): form = SkillForm() if form.validate_on_submit(): if request.method == 'POST': result = request.form cursor = connection1.cursor() values = list(result.values()) cursor.execute("select * from skill_list") l = cursor.fetchall() lit = [i[0] for i in l] if values[1] in lit: flash("Already skill exists", 'danger') return redirect(url_for('addskill')) else: cursor.execute("insert into skill_list(skill) values('" + values[1] + "')") connection1.commit() flash('Skill added successfully', 'success') return render_template('addskill.html', form=form)
def addSkill(): # define an error variable to be passed through if any errors that need to be prompted to the user occur error = None skill_form = SkillForm() # checks for a post request from the form submit button if request.method == 'POST': # if the validation from the wtform class passes continue if skill_form.validate_on_submit(): skills = [] for skill in current_user.get_skills(): skills.append(skill.skillType) if skill_form.skill.data not in skills: new_skill = Skill(skill_form.skill.data, current_user.id) # add and commit to the database db.session.add(new_skill) db.session.commit() return redirect(url_for('dashboard.userDashboard')) else: error = "You have all ready added that skill." else: error = "Invalid Skill Selected." return render_template('accounts/add_skill.html', skill_form=skill_form, error=error)