python3中连接mysql执行sql语句报错not enough arguments for format string

mysql TypeError: not enough arguments for format string

"error": "Data processing failed: not enough arguments for format string"

query = query % self._escape_args(args, conn) TypeError: not enough arguments for format string

Traceback (most recent call last): File "/Users/edy/PycharmProjects/PythonProject2/1.py", line 47, in <module> fetch_and_store(api_url, database_path) File "/Users/edy/PycharmProjects/PythonProject2/1.py", line 42, in fetch_and_store cursor.executemany(insert_sql, json_data) File "/Users/edy/PycharmProjects/PythonProject2/.venv/lib/python3.12/site-packages/pymysql/cursors.py", line 182, in executemany return self._do_execute_many( ^^^^^^^^^^^^^^^^^^^^^^ File "/Users/edy/PycharmProjects/PythonProject2/.venv/lib/python3.12/site-packages/pymysql/cursors.py", line 205, in _do_execute_many v = values % escape(next(args), conn) ~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~ TypeError: not enough arguments for format stringimport json import pymysql import requests import sqlite3 from flask import Flask, render_template_string from typing import List, Dict app = Flask(__name__) def fetch_and_store(url: str, db_path: str) -> None: # 1. 发起HTTP请求获取数据 response = requests.get(url, timeout=10) response.raise_for_status() # 自动处理HTTP错误 # 2. 解析JSON到Python列表 json_data: List[Dict] = response.json() # 3. 准备数据库连接 # 数据库连接配置 DB_CONFIG = { &#39;host&#39;: &#39;localhost&#39;, # 数据库地址 &#39;user&#39;: &#39;root&#39;, # 用户名 &#39;password&#39;: &#39;11111111&#39;, # 密码 &#39;database&#39;: &#39;python&#39;, # 数据库名 &#39;port&#39;: 3306, # 端口 &#39;charset&#39;: &#39;utf8mb4&#39; # 字符集 } connection = pymysql.connect(**DB_CONFIG) insert_sql = &#39;&#39;&#39; INSERT INTO container_info ( customer_id, node_info, image_id, container_id, container_create_time, container_start_time, container_run_status, container_restart_count ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s) &#39;&#39;&#39; for i in range(0,len(json_data)) : with connection.cursor() as cursor: cursor.executemany(insert_sql, json_data) # 使用示例 if __name__ == "__main__": api_url = "http://192.168.40.242/get_field" # 替换实际地址 database_path = "server_data.db" fetch_and_store(api_url, database_path)