def newrule(): user_id = session.get('user_id') if request.method == 'GET': userrulelist = Rule.query.order_by(desc(Rule.id)).all() return render_template('newrule.html', key1 = rulekey1, key2 = rulekey2, userrules = userrulelist) else: rulename = request.form.get('rulename') customer = request.form.get('customer') release = request.form.get('release') customer_feature_white = request.form.get('customer_feature_white') customer_feature_black = request.form.get('customer_feature_black') customer_top_fault = request.form.get('customer_top_fault') customer_care_function = request.form.get('customer_care_function') customer_bbu = request.form.get('customer_bbu') customer_rru = request.form.get('customer_rru') customer_keyword_white = request.form.get('customer_keyword_white') customer_keyword_black = request.form.get('customer_keyword_black') category_tag = request.form.get('category_tag') category_search_field = request.form.get('category_search_field') uuf_filter = request.form.get('uuf_filter') uuf_exclusion = request.form.get('uuf_exclusion') kpi_filter = request.form.get('kpi_filter') kpi_exclusion = request.form.get('kpi_exclusion') ca_filter = request.form.get('ca_filter') ca_exclusion = request.form.get('ca_exclusion') oamstab_filter = request.form.get('oamstab_filter') oamstab_exclusion = request.form.get('oamstab_exclusion') pet_filter = request.form.get('pet_filter') pet_exclusion = request.form.get('pet_exclusion') func_filter = request.form.get('func_filter') func_exclusion = request.form.get('func_exclusion') customer_pronto_white = request.form.get('customer_pronto_white') customer_pronto_black = request.form.get('customer_pronto_black') r4bbu = request.form.get('r4bbu') r3bbu = request.form.get('r3bbu') ftcomsc = request.form.get('func_exclusion') rule = Rule.query.filter(Rule.rulename == rulename).first() if rule: flash('Rule is already exist, please try another rule name!','danger') return redirect(url_for('newrule')) else: rule = Rule(rulename=rulename,customer=customer,release=release,customer_feature_white=customer_feature_white, customer_feature_black=customer_feature_black, customer_top_fault=customer_top_fault, customer_care_function=customer_care_function, uuf_filter=uuf_filter, uuf_exclusion=uuf_exclusion, kpi_filter=kpi_filter, kpi_exclusion=kpi_exclusion, ca_filter=ca_filter, ca_exclusion=ca_exclusion, oamstab_filter=oamstab_filter, oamstab_exclusion=oamstab_exclusion, pet_filter=pet_filter, pet_exclusion=pet_exclusion, func_filter=func_filter, func_exclusion=func_exclusion, category_search_field=category_search_field, category_tag=category_tag, customer_rru=customer_rru, customer_bbu=customer_bbu, customer_keyword_white=customer_keyword_white, customer_keyword_black=customer_keyword_black, customer_pronto_white=customer_pronto_white, customer_pronto_black=customer_pronto_black, r4bbu=r4bbu, r3bbu=r3bbu, ftcomsc=ftcomsc) user = User.query.filter(User.id == user_id).first() rule.owner = user db.session.add(rule) db.session.commit() flash('Rule is already sucessfully added!', 'success') return redirect(url_for('newrule'))