def service(ville, acitvite): Tab = [] connect = connection() curseur = connect.cursor() curseur.execute("SELECT i.numero, i.nom, e.numero, e.nom, a.numero, a.nom FROM installations i JOIN Equipement e ON i.numero = e.numero_installation JOIN Equipement_Activite ea ON e.numero = ea.numero_equipement JOIN Activite a ON ea.numero_activite = a.numero WHERE i.ville = ? AND a.nom LIKE ?",("'%'acitvite"%")) for row in curseur: Tab.append(row) connect.close() return Tab
def activite(activNom): activitesTab = [] connect = connection() curseur = connect.cursor() curseur.execute("select numero, nom from Activite where nom LIKE ?", ["%"+activNom+"%"]) for row in curseur: activitesTab.append(Activite(row[0], row[1]).__dict__) connect.close() return activitesTab
def allActivites(): activitesTab = [] connect = connection() curseur = connect.cursor() curseur.execute("select numero, nom from Activite") for row in curseur: activitesTab.append(Activite(row[0], row[1]).__dict__) connect.close() return activitesTab