# import logging
#
# import pandas
# import pytest
# from ui_automation_framework.utils import logger as cl
# from ui_automation_framework.utils import CoreConfig
#
# from app.api_client import ApiClient
#
# log = cl.Logger(logging.DEBUG)
#
# new_env = 'https://test-proxy.apollo.stream'
# old_env = 'https://proxy.apollo.stream'
# api_client_old = ApiClient(host_endpoint=old_env)
# api_client_new = ApiClient(host_endpoint=new_env)
# token_new = api_client_new.authorize()
# prod_user = 'anna.sheremet@dataart.com'
# request_url = 'Request URL'
#
#
# def f(dat, c='red'):
#     colors = []
#     for i in dat:
#         if i:
#             c = 'green'
#         elif i == '':
#             c = 'white'
#         else:
#             c = 'red'
#         colors.append(f'background-color: {c}')
#     return colors
#
#
# chart_available = 'chart_available'
# data_keys = ['end_date', 'is_entered', 'isrc', 'market', 'start_date', 'trend']
# positions_keys = ['change', 'date', 'position']
#
# isrcs_markets = ['isrc=USSM19400325&market=us',
#                  'isrc=USSM19400325&market=_gl',
#                  'isrc=TCAEW2040509&market=au',
#                  'isrc=TCAEW2040509&market=_gl',
#                  'isrc=USQX92102219&date_shift=4&market=_gl&end=2021-11-01',
#                  'isrc=USSM12103949&date_shift=4&market=_gl&end=2021-11-01',
#                  'isrc=USSM12105357&date_shift=4&market=_gl&end=2021-11-01']
#
#
# @pytest.mark.parametrize("isrc_market", isrcs_markets)
# def test_gtp_e_1(isrc_market):
#     old_endpoint = f'/apollo-api/gtp/charts/?{isrc_market}'
#     new_endpoint = f'/gate-api/gtp/charts/?{isrc_market}'
#     # get old response
#     old_resp = api_client_old.get_response(endpoint=old_endpoint, user=prod_user, env=old_env, token=token_old)['body']
#     new_resp = api_client_old.get_response(endpoint=new_endpoint, user=CoreConfig.USER_EMAIL, env=new_env)['body']
#     old_resp_data = old_resp['data']
#     new_resp_data = new_resp['data']
#     log.info(f'old resp data: {old_resp_data}')
#     log.info(f'new resp data: {new_resp_data}')
#
#     indexes_all = [request_url, chart_available]
#     log.info(f'indexes all: {indexes_all}')
#     old_endpoint_values = []
#     new_endpoint_values = []
#     diffs = []
#
#     old_endpoint_values.append(old_endpoint)
#     new_endpoint_values.append(new_endpoint)
#     diffs.append('')
#
#     old_endpoint_values.append(old_resp[chart_available])
#     new_endpoint_values.append(new_resp[chart_available])
#     diffs.append(old_resp[chart_available] == new_resp[chart_available])
#
#     for to, tn in zip(old_resp_data, new_resp_data):
#         old_endpoint_values.extend([to[k] for k in data_keys])
#         new_endpoint_values.extend([tn[k] for k in data_keys])
#         indexes_all.extend(data_keys)
#         diffs.extend([to[k] == tn[k] for k in data_keys])
#         for po, pn in zip(to['positions'], tn['positions']):
#             old_endpoint_values.extend([po[k] for k in positions_keys])
#             new_endpoint_values.extend([pn[k] for k in positions_keys])
#             indexes_all.extend(positions_keys)
#             diffs.extend([po[k] == pn[k] for k in positions_keys])
#
#     df = pandas.DataFrame({
#         'IS CORRECT': diffs,
#         'OLD API VALUE': old_endpoint_values,
#         'NEW API VALUE': new_endpoint_values,
#     },
#         index=indexes_all)
#
#     df.reset_index().style.apply(f, subset=['IS CORRECT']) \
#         .to_excel(f'gtp_{isrc_market.replace("=", "_")}.xlsx')