python - 插入数据库，单个插入有效，循环插入怎么就不行了？

Question

def insert_into_bet(data):
    len_team_data = int(len(data)/7)
    conn=mdb.connect(host='localhost',user='root',passwd='oracle',db='betdb',port=3306)
    cur = conn.cursor()
    sql = "insert into bet(id,lea,gmd,hos,gue,hos_sco,gue_sco) values(%s,%s,%s,%s,%s,%s,%s)"
    for l in range(len_team_data):
        for item in data[7*l:7*l+1]:
            cur.executemany(sql,data[7*l:7*l+7])
            l+=1
    cur.close()
    conn.commit()
    conn.close()

if __name__=='__main__':
#     download_live_urls()
    now = datetime.datetime.now()
    now_date = now.strftime('%Y-%m-%d')
    pages_path = '/root/bet/teamUrls/%s' % now_date
    for page in os.listdir(pages_path):
        page_path = '/root/bet/teamUrls/%s/%s' % (now_date,page)
        #问题出在这里！！！
        insert_into_bet(from_page_to_data(page_path))

我尝试取消main里面的for循环，然后执行insert_into_bet这个，是可以插入数据库的，但是一旦加入for循环以后，就无法插入数据库了，不知道什么原因，求指点~

Answer 1

建议查看日志有没有报错，mysql配置打开global_log，看看sql执行情况

Answer 2

for
executemany

仔细看executemany的用法

Answer 3

def insert_into_bet(data):
len_team_data = int(len(data)/7)
conn=mdb.connect(host='localhost',user='root',passwd='oracle',db='betdb',port=3306)
cur = conn.cursor()
sql = "insert into bet(id,lea,gmd,hos,gue,hos_sco,gue_sco) values(%s,%s,%s,%s,%s,%s,%s)"
for l in range(len_team_data):
    for item in data[7*l:7*l+1]:
        cur.executemany(sql,data[7*l:7*l+7])
        l+=1
cur.close()
conn.commit()
conn.close()

顺序颠倒了~~
cur.close()
conn.commit()