Python connection Examples

Example #1

File: service.py Project: DaAbgrall/Tech_Prod_Log_Abgrall_Auzou

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

Example #2

File: rest_activites.py Project: DaAbgrall/Tech_Prod_Log_Abgrall_Auzou

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

Example #3

File: rest_activites.py Project: DaAbgrall/Tech_Prod_Log_Abgrall_Auzou

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