Skip to content

Instantly share code, notes, and snippets.

@Everfighting

Everfighting/search_config_id

Created August 17, 2022 02:45
Download ZIP

Revisions

  1. Everfighting renamed this gist Aug 17, 2022. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions search_ → search_config_id
    View file
    Original file line number Diff line number Diff line change
    @@ -2,6 +2,7 @@ import requests
    import pandas
    import copy

    # 根据公司名或者app_code查询id
    url = "http://121.5.100.192:7006/api/user_app/get_page"
    res = requests.post(url=url, json={
    "page_size": 1000,
  2. Everfighting created this gist Aug 17, 2022.
    31 changes: 31 additions & 0 deletions search_
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,31 @@
    import requests
    import pandas
    import copy

    url = "http://121.5.100.192:7006/api/user_app/get_page"
    res = requests.post(url=url, json={
    "page_size": 1000,
    "page_num": 1,
    "like_name": ""
    }).json()["data"]

    df = pandas.DataFrame(res)
    df_2 = pandas.DataFrame(df.res_list.apply(lambda x: {**x}).tolist())
    df_2.company_name = df_2.company_name.apply(lambda x: str(x))

    result = copy.deepcopy(df_2)[["app_code", "company_name", "id"]]

    company = input("请输入公司名")
    if company:
    result = result.loc[result.company_name.str.contains(company)]
    print(result)
    if result.empty:
    result = copy.deepcopy(df_2)[["app_code", "company_name", "id"]]

    app_code = input("请输入app_code")
    if app_code:
    result = result.loc[result.app_code.str.contains(app_code)]
    print(result)
    if result.id.count() == 1:
    pk = result.iloc[0].id
    print(df_2.loc[df_2.id == pk].iloc[0])