def getAttributesTaxon(connection, cd_ref, attrDesc, attrComment, attrMilieu, attrChoro):
    sql = '\n        SELECT *\n        FROM atlas.vm_cor_taxon_attribut\n        WHERE id_attribut IN (:thisattrDesc, :thisattrComment, :thisattrMilieu, :thisattrChoro)\n        AND cd_ref = :thiscdref\n    '
    req = connection.execute(text(sql), thiscdref=cd_ref, thisattrDesc=attrDesc, thisattrComment=attrComment, thisattrMilieu=attrMilieu, thisattrChoro=attrChoro)
    descTaxon = {'description': None, 'commentaire': None, 'milieu': None, 'chorologie': None}
    for r in req:
        if (r.id_attribut == attrDesc):
            descTaxon['description'] = r.valeur_attribut
        elif (r.id_attribut == attrComment):
            descTaxon['commentaire'] = r.valeur_attribut
        elif (r.id_attribut == attrMilieu):
            descTaxon['milieu'] = r.valeur_attribut.replace('&', ' | ')
        elif (r.id_attribut == attrChoro):
            descTaxon['chorologie'] = r.valeur_attribut
    return descTaxon
def getAttributesTaxon(connection, cd_ref, attrDesc, attrComment, attrMilieu, attrChoro):
    sql = '\n        SELECT *\n        FROM atlas.vm_cor_taxon_attribut\n        WHERE id_attribut IN (:thisattrDesc, :thisattrComment, :thisattrMilieu, :thisattrChoro)\n        AND cd_ref = :thiscdref\n    '
    req = connection.execute(text(sql), thiscdref=cd_ref, thisattrDesc=attrDesc, thisattrComment=attrComment, thisattrMilieu=attrMilieu, thisattrChoro=attrChoro)
    descTaxon = {'description': None, 'commentaire': None, 'milieu': None, 'chorologie': None}
    for r in req:
        if (r.id_attribut == attrDesc):
            descTaxon['description'] = r.valeur_attribut
        elif (r.id_attribut == attrComment):
            descTaxon['commentaire'] = r.valeur_attribut
        elif (r.id_attribut == attrMilieu):
            descTaxon['milieu'] = r.valeur_attribut.replace('&', ' | ')
        elif (r.id_attribut == attrChoro):
            descTaxon['chorologie'] = r.valeur_attribut
    return descTaxon