def ctg_rec_result(name, add, ctg): value = name value2 = add value3 = int(ctg) os.putenv('NLS_LANG', 'KOREAN_KOREA.KO16MSWIN949') connection = cx_Oracle.connect('hr/[email protected]:1521/xe') cur = connection.cursor() cur.execute( "select distinct name from jjj_rec_add where category=:category and address1=:address1", { "category": value3, "address1": value2 }) member = [] for result in cur: member.append(result[0]) cur.close() connection.close() if name not in member: mm.main(value, value2, value3) result = mm.get_recommend_info(value, value2, value3) return render_template("jjj/category_recommend_result.html", name=value, add=value2, ctg=value3, data=result)
def chart(name): result = mm.get_recommend_info(name) address_count, ctg_count = mm.get_chart_data(result) add_length = len(address_count) ctg_length = len(ctg_count) return render_template("jjj/graph1.html", add_data=address_count, add_len=add_length, ctg_data=ctg_count, ctg_len=ctg_length, name=name)
def hybrid(name): os.putenv('NLS_LANG', 'KOREAN_KOREA.KO16MSWIN949') connection = cx_Oracle.connect('hr/[email protected]:1521/xe') cur = connection.cursor() cur.execute("select distinct name from jjj_rec ") member = [] for result in cur: member.append(result[0]) if name not in member: mm.main(name) reco = mm.get_recommend_info(name) cur.close() return render_template("jjj/hybrid.html", data=reco, name=name)