def updatePinsetInformation():
    #Get existing information:
    am = AsteriskMySQLManager()
    am.connect('nextor_tarificador');
    sql = "SELECT * from tarifica_pinset"
    am.cursor.execute(sql)
    existing_pinsets = am.cursor.fetchall()

    #Get current providers on asterisk's db
    todays_pinsets = am.getPinsetInformation()
    print todays_pinsets
    new_pinsets = []
    for today_u in todays_pinsets:
        existing = False
        for ex_u in existing_pinsets:
            if today_u == ex_u['pinset_number']:
                existing = True
        if not existing:
            #Didn't exist before, so we create one:
            new_pinset = (
                today_u,
            )
            new_pinsets.append(new_pinset)
            print "New pinset", today_u, "found."

    #Now, we update all previously existing pinsets and save the new ones
    am.connect('nextor_tarificador');
    sql = "INSERT INTO tarifica_pinset \
    (pinset_number) VALUES(%s)"
    totalRowsSaved = am.cursor.executemany(sql, new_pinsets)
    am.db.commit()
    print "----------------------------------------"
    print totalRowsSaved, "new pinsets saved."
Exemplo n.º 2
0
def updatePinsetInformation():
    #Get existing information:
    am = AsteriskMySQLManager()
    am.connect('nextor_tarificador')
    sql = "SELECT * from tarifica_pinset"
    am.cursor.execute(sql)
    existing_pinsets = am.cursor.fetchall()

    #Get current providers on asterisk's db
    todays_pinsets = am.getPinsetInformation()
    print todays_pinsets
    new_pinsets = []
    for today_u in todays_pinsets:
        existing = False
        for ex_u in existing_pinsets:
            if today_u == ex_u['pinset_number']:
                existing = True
        if not existing:
            #Didn't exist before, so we create one:
            new_pinset = (today_u, )
            new_pinsets.append(new_pinset)
            print "New pinset", today_u, "found."

    #Now, we update all previously existing pinsets and save the new ones
    am.connect('nextor_tarificador')
    sql = "INSERT INTO tarifica_pinset \
    (pinset_number) VALUES(%s)"

    totalRowsSaved = am.cursor.executemany(sql, new_pinsets)
    am.db.commit()
    print "----------------------------------------"
    print totalRowsSaved, "new pinsets saved."