FCM82 - Programmer en Python n°52

def OpenDB():
    global connection
    global curseur
    connection = apsw.Connection("labpackagestudy.db3")
    curseur = connection.cursor()

def TraiterJoursDeSemaine():
    # on cree un second curseur pour mettre a jour la nouvelle table
    curseur2 = connection.cursor()
    q1 = "DROP TABLE IF EXISTS JoursDeSemaine"
    curseur.execute(q1)
    query = '''CREATE TABLE IF NOT EXISTS JoursDeSemaine AS SELECT pkgs,
               Count(DOW) as NombreDeJoursDeSemaine FROM etude WHERE (Holiday <> 1)
               AND DayName in
               ("lundi","mardi","mercredi","jeudi","vendredi")
               GROUP BY pkgs'''

    curseur.execute(query)
    addcolquery = 'ALTER TABLE JoursDeSemaine ADD COLUMN probability REAL'
    curseur.execute(addcolquery)
    addcolquery = 'ALTER TABLE JoursDeSemaine ADD COLUMN lower REAL'
    curseur.execute(addcolquery)
    addcolquery = 'ALTER TABLE JoursDeSemaine ADD COLUMN upper REAL'
    curseur.execute(addcolquery)
    sumquery = "SELECT Sum(NombreDeJoursDeSemaine) as Sm FROM JoursDeSemaine"
    tmp = curseur.execute(sumquery)
    for t in tmp:
        DaySum = t[0]
    upquery = "SELECT * FROM JoursDeSemaine"
    c1 = curseur.execute(upquery)
    LastUpper = .0
    for row in c1:
        cod = row[1]
        pkg = row[0]
        prob = cod / float(DaySum)
        if LastUpper != .0:
            lower = LastUpper
            LastUpper = (lower + prob)
        else:
            lower = .0
            LastUpper = prob
        nquery = 'UPDATE JoursDeSemaine SET probability = %f, \
                  lower = %f, upper = %f WHERE pkgs = %d' \
                  % (prob,lower,LastUpper,pkg)
        u = curseur2.execute(nquery)
#====================================
#       End of TraiterJoursDeSemaine
#====================================