yyt-trading-rf-api/100_test_data_clear/test_data_clear.robot

*** Settings ***
Library           DatabaseLibrary
Library           RequestsLibrary
Library           Collections
Library           urllib3

*** Test Cases ***
database_delete_user_customerclue_customer
    Connect To Database Using Custom Params    pymysql    database='uec', user='root', password='password', host='8.135.8.221', port=3306, charset='utf8'
    Execute Sql String    update qn_account set is_delete = 1 where tid = "${account_customer}"
    #${query}    Query    select user_id from qn_account where tid = "${account_customer}"
    #${query_list}    Get From List    ${query}    0
    #${userid}    Get From List    ${query_list}    0
    Execute Sql String    update qn_enterprise_member set is_delete = 1 where user_id = ${userid_customer}
    Execute Sql String    update qn_user set is_delete = 1 where id = ${userid_customer}
    Connect To Database Using Custom Params    pymysql    database='yyt_user_center', user='root', password='password', host='8.135.8.221', port=3306, charset='utf8'
    Execute Sql String    update qn_customer_clue set is_delete = 1 where mobile = "${account_customer}"
    Disconnect From Database

database_delete_user_customerclue_supplier
    Connect To Database Using Custom Params    pymysql    database='uec', user='root', password='password', host='8.135.8.221', port=3306, charset='utf8'
    Execute Sql String    update qn_account set is_delete = 1 where tid = "${account_supplier}"
    #${query}    Query    select user_id from qn_account where tid = "${account_supplier}"
    #${query_list}    Get From List    ${query}    0
    #${userid}    Get From List    ${query_list}    0
    Execute Sql String    update qn_enterprise_member set is_delete = 1 where user_id = ${userid_supplier}
    Execute Sql String    update qn_user set is_delete = 1 where id = ${userid_supplier}
    Connect To Database Using Custom Params    pymysql    database='yyt_user_center', user='root', password='password', host='8.135.8.221', port=3306, charset='utf8'
    Execute Sql String    update qn_customer_clue set is_delete = 1 where mobile = "${account_supplier}"
    Disconnect From Database

database_delete_printing_packaging_factory
    Connect To Database Using Custom Params    pymysql    database='uec', user='root', password='password', host='8.135.8.221', port=3306, charset='utf8'
    Execute Sql String    update qn_enterprise set is_delete = 1 where id = ${printing_packaging_factory_id}
    Execute Sql String    update qn_enterprise_member set is_delete = 1 where enterprise_id = ${printing_packaging_factory_id}
    Execute Sql String    update qn_account set is_delete = 1 where tid = "${printing_packaging_factory_administrator_mobile}"
    ${query}    Query    select user_id from qn_account where tid = "${printing_packaging_factory_administrator_mobile}"
    ${query_list}    Get From List    ${query}    0
    ${userid}    Get From List    ${query_list}    0
    Execute Sql String    update qn_enterprise_member set is_delete = 1 where user_id = ${userid}
    Execute Sql String    update qn_user set is_delete = 1 where id = ${userid}
    Connect To Database Using Custom Params    pymysql    database='yyt_user_center', user='root', password='password', host='8.135.8.221', port=3306, charset='utf8'
    Execute Sql String    update qn_enterprise set is_delete = 1 where id = ${printing_packaging_factory_id}
    Execute Sql String    update qn_enterprise_profile set is_delete = 1 where enterprise_id = ${printing_packaging_factory_id}
    Disconnect From Database

database_delete_supplier_paper
    Connect To Database Using Custom Params    pymysql    database='uec', user='root', password='password', host='8.135.8.221', port=3306, charset='utf8'
    Execute Sql String    update qn_enterprise set is_delete = 1 where id = ${supplier_enterprise_id}
    Execute Sql String    update qn_enterprise_member set is_delete = 1 where enterprise_id = ${supplier_enterprise_id}
    Execute Sql String    update qn_account set is_delete = 1 where tid = "${supplier_enterprise_administrator_mobile}"
    ${query}    Query    select user_id from qn_account where tid = "${supplier_enterprise_administrator_mobile}"
    ${query_list}    Get From List    ${query}    0
    ${userid}    Get From List    ${query_list}    0
    Execute Sql String    update qn_enterprise_member set is_delete = 1 where user_id = ${userid}
    Execute Sql String    update qn_user set is_delete = 1 where id = ${userid}
    Connect To Database Using Custom Params    pymysql    database='yyt_user_center', user='root', password='password', host='8.135.8.221', port=3306, charset='utf8'
    Execute Sql String    update qn_enterprise set is_delete = 1 where id = ${supplier_enterprise_id}
    Execute Sql String    update qn_enterprise_profile set is_delete = 1 where enterprise_id = ${supplier_enterprise_id}
    Execute Sql String    update qn_mall_supplier set is_delete = 1 where enterprise_id = ${supplier_enterprise_id}
    Disconnect From Database

database_delete_printing_packaging_factory_credit
    Connect To Database Using Custom Params    pymysql    database='yyt_user_center', user='root', password='password', host='8.135.8.221', port=3306, charset='utf8'
    Execute Sql String    update qn_enterprise_credit_application set is_delete = 1 where enterprise_id = ${printing_packaging_factory_id}
    Execute Sql String    update qn_enterprise_credit_order set is_delete = 1 where enterprise_id = ${printing_packaging_factory_id}
    Disconnect From Database

supplierfocus_batch_product_status_down
    Disable Warnings
    Create Session    yytclient    ${yytclient}    headers=${cloudfactory_supplierfocus_header}
    ${product_status}    Set Variable    30112    #批量上下架状态 30110未上架 30111上架中 30112已下架
    ${body}    Set Variable    {"status":${product_status},"idList":[${product_id},${product_id1}]}
    ${response}    POST On Session    yytclient    /trading-center/update/product-status/batch    ${body.encode("utf8")}
    log    ${response.json()}
    Should Be Equal As Numbers    200    ${response.status_code}
    Should Be Equal As Strings    successful    ${response.json()["message"]}

supplierfocus_batch_product_delete
    Disable Warnings
    Create Session    yytclient    ${yytclient}    headers=${cloudfactory_supplierfocus_header}
    ${body}    Set Variable    {"ids":["${product_id}"]}
    ${response}    POST On Session    yytclient    /trading-center/delete/product-list    ${body.encode("utf8")}
    log    ${response.json()}
    Should Be Equal As Numbers    200    ${response.status_code}
    Should Be Equal As Strings    successful    ${response.json()["message"]}

database_delete_paper_category
    Connect To Database Using Custom Params    pymysql    database='trading_center', user='root', password='password', host='8.135.8.221', port=3306, charset='utf8'
    Execute Sql String    update qn_category set is_delete = 1 where id = ${paper_category_id} and name = "${paper_category_name}"
    Query    select is_delete from qn_category where id = ${paper_category_id} and name = "${paper_category_name}"
    Disconnect From Database

supplierfocus_delete_paper_manufacturer
    Disable Warnings
    Create Session    yytclient    ${yytclient}    headers=${cloudfactory_supplierfocus_header}
    ${body}    Set Variable    {"idList":["${paper_manufacturer_id}"]}
    ${response}    POST On Session    yytclient    /trading-center/delete/paper-manfucturers/by/ids    ${body.encode("utf8")}
    log    ${response.json()}
    Should Be Equal As Numbers    200    ${response.status_code}
    Should Be Equal As Strings    successful    ${response.json()["message"]}

supplierfocus_delete_paper_brand
    Disable Warnings
    Create Session    yytclient    ${yytclient}    headers=${cloudfactory_supplierfocus_header}
    ${body}    Set Variable    {"idList":["${paper_brand_id}"]}
    ${response}    POST On Session    yytclient    /trading-center/delete/category-brands/by/ids    ${body.encode("utf8")}
    log    ${response.json()}
    Should Be Equal As Numbers    200    ${response.status_code}
    Should Be Equal As Strings    successful    ${response.json()["message"]}

customer_enterprise_delete_shipping_address
    Disable Warnings
    Create Session    uecclient    ${uecclient}    headers=${cloudfactory_customer_header}
    #${body}    Set Variable    {"id":"${customer_enterprise_shipping_address_id}"}
    ${response}    Delete On Session    uecclient    /uec/delete/enterprise-shipping-address/${customer_enterprise_shipping_address_id}    #${body.encode("utf8")}
    log    ${response.json()}
    Should Be Equal As Numbers    200    ${response.status_code}