Python 执行语句中出现意外的关键参数

发布于06月15日

def add_application_to_db(job_id, data):
    with engine.connect() as conn:
        sql = text(
            "INSERT INTO application(id,job_id,fullname,email,linkedin,education,experience,resumeurl) VALUES (:job_id,:fullname,:email,:linkedin,:education,:experience,:resumeurl)"
        )
        conn.execute(
            job_id=job_id,
            fullname=data["fullname"],
            email=data["email"],
            linkedin=data["linkedin"],
            education=data["education"],
            experience=data["experience"],
            resumeurl=data["resumeurl"],
        )

我正在学习FASK并使用MySQL和SQLALCHEMIY.我正在try 将用户的信息存储到数据库中(表名=应用程序) 我收到以下错误

TypeError:Connection.ecute()获得意外的关键字参数‘job_id’

推荐答案

如果您使用的是SQLAlChemy 2.0，那么您必须将参数作为字典发送，而不是您现在正在try 的参数.

def add_application_to_db(job_id, data):
    row = {
        "job_id": job_id,
        "fullname": data["fullname"],
        "email": data["email"],
        "linkedin": data["linkedin"],
        "education": data["education"],
        "experience": data["experience"],
        "resumeurl": data["resumeurl"],
    }
    with engine.connect() as conn:
        sql = text(
            "INSERT INTO application(id,job_id,fullname,email,linkedin,education,experience,resumeurl) VALUES (:job_id,:fullname,:email,:linkedin,:education,:experience,:resumeurl)"
        )
        conn.execute(sql, row)