python写入数据库模块（自用）

from connect_db import DB

val = [{"id": 1, "xh": 1001, "name": "a"},
       {"id": 2, "xh": 2002, "name": "b"}, 
       {"id": 3, "xh": 3003, "name": "c"}]

with DB(db="test") as db:
    db.execute("DROP TABLE IF EXISTS test1")
    db.execute("CREATE TABLE test1 (id INT AUTO_INCREMENT PRIMARY KEY,xh INT, name VARCHAR(20))")

    try:
        for i in range(99999999999999):
            sql = "insert into test1 values(%s, %s, %s)"
            insert_val = [int(val[i]["id"]), int(val[i]["xh"]), val[i]["name"]]
            db.execute(sql, insert_val)
    except IndexError:
        print("导入结束，共有%d条数据" % i)