CLEAN_VJ_HOT_NEAR_INFO_TAB = "clean_flights_vj_hot_0_7_info_tab"
CLEAN_VJ_HOT_FAR_INFO_TAB = "clean_flights_vj_hot_7_30_info_tab"
CLEAN_VJ_NOTHOT_NEAR_INFO_TAB = "clean_flights_vj_nothot_0_7_info_tab"
CLEAN_VJ_NOTHOT_FAR_INFO_TAB = "clean_flights_vj_nothot_7_30_info_tab"


mongodb_config = {
    "host": "192.168.20.218",
    "port": 27017,
    "db": "flights_datas_db",
    "user": "",
    "pwd": ""
}

# 热门的航线
vj_flight_route_list_hot = [
    "CAN-DPS", "CAN-HAN", "CAN-SGN", "CTU-HAN", "CTU-SGN",
    "DAD-SEL", "DEL-HAN", "DPS-CAN", "HAN-CAN", "HAN-DAD",
    "HAN-SHA", "HAN-UIH", "HKG-PQC", "KUL-DAD", "NGO-HAN",
    "NHA-HAN", "NHA-SEL", "PQC-HKG", "PUS-NHA", "SEL-DAD",
    "SEL-SGN", "SGN-CAN", "SGN-DPS", "SGN-NGO", "SGN-NHA",
    "SGN-PQC", "SGN-SEL", "SGN-SHA", "SHA-HAN", "SHA-SGN",
    "SIN-DAD", "TPE-HAN", "TPE-PQC", "TPE-SGN", "TYO-HAN",
    "TYO-SGN"
]
# 冷门的航线
vj_flight_route_list_nothot = [
    "BKK-SGN", "BKK-TPE", "BLR-FUK", "BMV-HAN", "BNE-SGN",
    "CAN-PQC", "CTU-BNE", "CTU-DPS", "CTU-PQC", "DAD-DEL",
    "DAD-DLI", "DAD-HAN", "DLI-HAN", "DPS-BOM", "DPS-HAN",
    "DPS-SGN", "DPS-SHA", "FUK-DPS", "HAN-CTU",
    "HAN-DEL", "HAN-DLI", "HAN-KUL", "HAN-NGO",
    "HAN-NHA", "HAN-OSA", "HAN-PQC", "HAN-RMQ", "HAN-SGN",
    "HAN-TPE", "HAN-TYO", "HKG-SGN", "HKT-SGN", "HPH-NHA",
    "KHH-BNE", "KUL-HAN", "MEL-HKG", "MEL-HKT", "MEL-SGN",
    "MNL-SGN", "NGO-SYD", "OSA-REP", "OSA-SGN", "PQC-DAD",
    "PQC-SEL", "PQC-SGN", "SEL-NHA", "SEL-VTE", "SGN-CTU",
    "SGN-DAD", "SGN-HAN", "SGN-HKG", "SGN-HPH", "SGN-HYD",
    "SGN-MNL", "SGN-OSA", "SGN-SYD",
    "SGN-TPE", "SGN-TYO", "SHA-BKK", "SHA-BLR", "SHA-DPS",
    "SHA-PQC", "SIN-HAN", "SIN-PQC", "SIN-SGN", "SYD-SGN",
    "TYO-AMD", "UIH-SGN"
]
# 所有航线
vj_flight_route_list = vj_flight_route_list_hot + vj_flight_route_list_nothot


if __name__ == '__main__':
    from collections import Counter
    # 检查重复项
    # 统计每个航线出现的次数
    route_counter = Counter(vj_flight_route_list)

    # 找出重复的航线
    duplicates = {route: count for route, count in route_counter.items() if count > 1}

    # 输出结果
    if duplicates:
        print("发现重复的航线：")
        for route, count in duplicates.items():
            print(f"  {route}: 出现 {count} 次")

        print(f"\n总共发现 {len(duplicates)} 条重复航线")

        # 查找这些航线分别在哪个列表中
        print("\n重复航线分布：")
        for route in duplicates:
            hot_count = vj_flight_route_list_hot.count(route)
            nothot_count = vj_flight_route_list_nothot.count(route)
            print(f"  {route}: hot列表中出现 {hot_count} 次, nothot列表中出现 {nothot_count} 次")
    else:
        print("没有发现重复航线")