Не сохраняется запись в БД

Здравствуйте, возникла проблемка при записи данных в БД. Не могу понять, где проблема, в записи или в сохранении. Спасибо.

# -*- coding: utf-8 -*-
import requests
import time
from subprocess import call, PIPE
import MySQLdb
Routers = []
Hosts = []

db = MySQLdb.connect(host="localhost",
                     user="root",
                     passwd="1234",
                     db="sqlrst",
                     charset='utf8')
db.autocommit = True
cursor = db.cursor()

def HttpRequest():
    cursor.execute("SELECT Host FROM Hosts")
    Hosts = cursor.fetchall()
    for x in Hosts:
        for z in x:
            try:
                request = requests.get(z)
                request.raise_for_status()
                r = 1
            except requests.exceptions.RequestException:
                r = 0
            cursor.execute(" UPDATE Routers SET Response = %s WHERE Router = %s ", (r, z))

def Pinger():
    cursor.execute("SELECT Router FROM Routers")
    Routers = cursor.fetchall()
    for x in Routers:
        for z in x:
            g = "ping -n 1 %s" % z
            p = call(g,
                     shell=True,
                     stdout=PIPE,
                     stderr=PIPE)
            if p != 0:
                r = 0
            else:
                r = 1
            cursor.execute(" UPDATE Hosts SET Response = %s WHERE Host = %s ", (r, z))

while True:
    HttpRequest()
    Pinger()
    db.commit()
    time.sleep(3)