上传模板用例时,报错sqlalchemy.exc.InterfaceError: (sqlite3.InterfaceError) Error binding parameter 2 - probably unsupported type. · Issue #I7SNO9 · Kobayasi/FastApi_auto_test

起因，导入har文件，点击上传报错
sqlalchemy.exc.InterfaceError: (sqlite3.InterfaceError) Error binding parameter 2 - probably unsupported type.
[SQL: INSERT INTO case_template_data (temp_id, number, host, path, code, method, params, json_body, data, file, file_data, headers, response, description) VALUES (?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING id, created_at, updated_at]
[parameters: (1, 0, Url('http://api.myroki.com/'), '/rest/dms/api/device-type/getAllDeviceType', 200, 'POST', '{}', 'json', '{}', False, '[]', '{"Content-Type": "application/json; charset=UTF-8", "Content-Length": "2", "Host": "api.myroki.com", "Accept-Encoding": "gzip", "User-Agent": "okhttp/2.2.0", "Connection": "keep-alive"}', '{"rc": 0, "msg": null}', None)]

排查过程中发现，插入数据库第三个参数应该是string,但插入时是Url('http://api.myroki.com/')

我发现前端上传的文件的url使用了httpurl类型做约束，但是在如下方法中

async def create_template_data(db: Session, data: schemas.TemplateDataIn, temp_id: int):
    """
    创建模板数据集
    :param db:
    :param data:
    :param temp_id:
    :return:
    """
    print(data.host)
    print(data.dict())
    data.host = str(data.host)
    print(data.host)
    print(data.dict())
    db_data = models.TemplateData(**data.dict(), temp_id=temp_id)
    db.add(db_data)
    db.commit()
    db.refresh(db_data)
    return db_data

打印结果如下：
http://www.baidu.com/
{'number': 0, 'host': Url('http://www.baidu.com/'), 'path': '/rest', 'code': 200, 'method': 'POST', 'params': {}, 'json_body': 'json', 'data': {}, 'file': False, 'file_data': [], 'headers': {'Content-Type': 'application/json; charset=UTF-8'}, 'response': {}, 'description': None}
http://www.baidu.com/
D:\XXXXXXX\Desktop\fast-api_auto_test\.venv\lib\site-packages\pydantic\main.py:301: UserWarning: Pydantic serializer warnings:
  Expected `url` but got `str` - serialized value may not be as expected
  return self.__pydantic_serializer__.to_python(
{'number': 0, 'host': 'http://www.baidu.com/', 'path': '/rest', 'code': 200, 'method': 'POST', 'params': {}, 'json_body': 'json', 'data': {}, 'file': False, 'file_data': [], 'headers': {'Content-Type': 'application/json; charset=UTF-8'}, 'response': {}, 'description': None}

貌似httpurl类型的数据，在data.dict()时没有被正确的成string类型

Kobayasi/FastApi_auto_test

内容风险标识

上传模板用例时,报错sqlalchemy.exc.InterfaceError: (sqlite3.InterfaceError) Error binding parameter 2 - probably unsupported type.

评论 (4)

Kobayasi/FastApi_auto_test .gitee-modal { width: 500px !important; }

内容风险标识

上传模板用例时,报错sqlalchemy.exc.InterfaceError: (sqlite3.InterfaceError) Error binding parameter 2 - probably unsupported type.

评论 (4)

搜索帮助

Kobayasi/FastApi_auto_test