可能会想办法解决这个问题。我需要通过pymysql将数据保存到数据库这个脚本给了我错误：
“cursor.execute（sql\模板，{“productid”：productid，“producttitle”：producttitle，“saleprice”：saleprice，nameerror:未定义名称'productid'”

import pymysql.cursors

connection = pymysql.connect(host='localhost',
                                 user='root',
                                 password='Kradz579032!!',
                                 db='aliexpressapidb',
                                 charset='utf8mb4',
                                 cursorclass=pymysql.cursors.DictCursor)
    try:
        with connection.cursor() as cursor:
            sql_template ="""
            INSERT INTO producttable (productId, productTitle, salePrice, originalPrice )
                SELECT * FROM (SELECT %(productId)s, %(productTitle)s, %(salePrice)s, %(originalPrice)s) AS tmp
                WHERE NOT EXISTS (
                    SELECT productId FROM producttable WHERE productId = %(productId)s
                )
                LIMIT 1;
            """

            for product in data['products']:
                print('%s %s %s %s' % (
                product['productId'], product['productTitle'], product['salePrice'], product['originalPrice']))

                cursor.execute(sql_template, {"productId": productId, "productTitle": productTitle, "salePrice": salePrice,
                                              "originalPrice": originalPrice})
            connection.commit()

    finally:
        connection.close()