@app.route('/produit.<prd>')
def produit(prd):
    headers = {
        'Content-Type': 'application/json',
    }
    global tests, produits, suites, nbtest
    tests_complet = []
    tests, produits, suites, nbtest = functions.directory.create_table_tests(conf.directory, conf.marqueur, conf.cucumber_qa_test_directory)
    tests_api = get_all_tests()
    for ite in tests:
        if ite['produit'] == prd:
            for ite_api in tests_api['tests']:
                if ite_api['produit']==ite['produit'] and ite_api['test']==ite['testcase'] and ite_api['suite']==ite['testsuite']:
                    resultat = ite_api
                    break
            prio = ""
            tags = ""
            split_tags = ite['tags'].split(";")
            for elt in split_tags:
                if elt.upper() == "HIGH":
                    prio = "HIGH"
                    split_tags.remove(elt)
                elif elt.upper() == "MEDIUM":
                    prio = "MEDIUM"
                    split_tags.remove(elt)
                elif elt.upper() == "LOW":
                    prio = "LOW"
                    split_tags.remove(elt)
            tags = ';'.join(split_tags)
            data = '{"produit": "' + ite['produit'] + '", "test": "' + ite['testcase'] + '", "suite": "' + ite['testsuite'] + '", "tags": "' + tags + '", "prio": "' + prio + '"}'
            if resultat is None:
                r = requests.post(url + '/api/v1.0/add_test', headers=headers, data=data)
                resultat = data
            else:
                if not tags == resultat['tags'] or not prio == resultat['prio']:
                    r = requests.post(url + '/api/v1.0/update_test', headers=headers, data=data)
                    resultat = data
            if resultat['produit'] == prd:
                test_complet = {
                    'produit': str(resultat['produit']) if resultat['produit'] != None else '',
                    'testsuite': str(resultat['suite']) if resultat['suite'] != None else '',
                    'testcase': str(resultat['test']) if resultat['test'] != None else '',
                    'tags': str(resultat['tags']) + ';' + str(resultat['prio']) if resultat['tags'] != None and resultat['prio'] != None else '',
                    'mobiledate': str(resultat['mobiledate']) if resultat['mobiledate'] != None else '',
                    'mobilestatut': str(resultat['mobilestatut']) if resultat['mobilestatut'] != None else '',
                    'mobilelog': str(resultat['mobilelog']) if resultat['mobilelog'] != None else '',
                    'mobilelog_file': str(resultat['mobilelog_file'].encode("utf-8")) if resultat['mobilelog_file'] != None else '',
                    'desktopdate': str(resultat['desktopdate']) if resultat['desktopdate'] != None else '',
                    'desktopstatut': str(resultat['desktopstatut']) if resultat['desktopstatut'] != None else '',
                    'desktoplog': str(resultat['desktoplog']) if resultat['desktoplog'] != None else '',
                    'desktoplog_file': str(resultat['desktoplog_file'].encode("utf-8")) if resultat['desktoplog_file'] != None else '',
                    'commentaire': str(resultat['commentaire'].encode("utf-8")) if resultat['commentaire'] != None else ''
                }
                tests_complet.append(test_complet)
    #cursor_bdd.execute("SELECT * FROM tests where produit=?", (prd,))
    #resultat = cursor_bdd.fetchall()
    #for r in resultat:
    #    if not checkindic(r[1], r[2], r[3], tests_complet):
    #        cursor_bdd.execute("DELETE FROM tests WHERE produit=? and suite=? and test=?", (r[1], r[2], r[3],))
    #        session_bdd.commit()
    return flask.render_template('automation.html', products=produits, prd=prd, tests=tests_complet, sep=os.sep)