SQLite 绑定错误数量不正确

一点背景 我在 python 2.7 中这样做是因为 Alexa Rank 通过 SeoLib 但我完全愿意更新如果这有助于这个问题或可能解决未来的问题。

现在，该程序对我在预定 csv 中拥有的站点进行排序，如下所示：

site
00rbt.com

我特别收到以下错误：

 File "igorPanda.py", line 84, in <module>
    update_site(site,cur_ip,cur_rank,cur_hash)
  File "igorPanda.py", line 30, in update_site
    (site))
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 9 supplied.

发生此错误的地方是：

def update_site(site,cur_ip,cur_rank,cur_hash):
    conn = sqlite3.connect('/root/Database/Sites.db')
    cursor = conn.cursor()
    with conn:
        cursor.execute("SELECT EXISTS(SELECT * from sites WHERE site = ?)",
                       (site))
        record = cursor.fetchone()
        if record[0] == 1:
            cursor.execute("UPDATE sites SET cur_ip = ?, cur_rank = ?, cur_hash = ? WHERE site = ?",
                       (cur_ip,cur_rank,cur_hash,site))
        else:
            cursor.execute("INSERT into sites values (?,?,?,?,?,?,?,?)",
                       (site,cur_ip,None,cur_rank,None,None,cur_hash,None))

除了导入，我的整个代码是：

#Updates the DB
def update_site(site,cur_ip,cur_rank,cur_hash):
    conn = sqlite3.connect('/root/Database/Sites.db')
    cursor = conn.cursor()
    with conn:
        cursor.execute("SELECT EXISTS(SELECT * from sites WHERE site = ?)",
                       (site))
        record = cursor.fetchone()
        if record[0] == 1:
            cursor.execute("UPDATE sites SET cur_ip = ?, cur_rank = ?, cur_hash = ? WHERE site = ?",
                       (cur_ip,cur_rank,cur_hash,site))
        else:
            cursor.execute("INSERT into sites values (?,?,?,?,?,?,?,?)",
                       (site,cur_ip,None,cur_rank,None,None,cur_hash,None))
#Moves CSV for Historical Savings
bashmove = "mv top.csv /root/Desktop/scripts/results-igor/top-$(date +%m-%d-%Y).csv"
#Sets file with all sites to variable
filename='/root/Desktop/scripts/sorted.csv'
#Creates hash algorithm for later use
hasher = hashlib.sha256()
sess = requests.Session()
x = datetime.datetime.now()
date = x.strftime('%Y-%m-%d')
regex = r"^(?:https?:)?(?:\/\/)?(?:[^@\n]+@)?(?!www\.)?([^:\/\n]+)\w*\.\b(com|org|co|be|de|br|(\w+\b))" #regex to get stripepd website no https://www. or anything afte$

df = pd.DataFrame()
df = df.append(pd.read_csv(filename), ignore_index=True)
ip = "NOT FOUND"
for i in df.index:
    #print(i)
    site = df['site'][i]
    try :
     ip = socket.gethostbyname(site)
     page = requests.get('http://' + df['site'][i], timeout=5)
     hasher.update((page.text).encode('utf-8'))
    except: #ignore errors if the site is bad
        pass
    try :
     alexa_rank = seo.get_alexa('http://{}'.format(site)) #seolib gets the alexa ranking
     #alexa_rank = None
    except:
     pass
    site = site
    cur_ip = ip
    cur_rank = alexa_rank
    cur_hash = hasher.hexdigest()
    update_site(site,cur_ip,cur_rank,cur_hash)  
    rd = call(["/root/Desktop/scripts/./rDNSlookup.sh", site, ip]) #call bash script to get reverse DNS of ip
    wi = call(["/root/Desktop/scripts/./whois.sh", site]) #call bash script to print host info
    with open('/root/Desktop/scripts/IGOR_His/'+ date + 'sites.csv', 'a') as f:
      print >> f, 'site: ',site,', ip: ',ip,', rank: ',alexa_rank, ', hash', cur_hash
shutil.copy("/root/Database/Sites.db", "/var/www/html/sites/Sites.db")

该表包含以下列：

site,cur_ip,prev_ip,cur_rank,prev_rank,play,cur_hash,prev_hash