@app.route("/export_path_unused", methods=['GET'])
def export_path_unused():
    paths = [
        '',
        'home',
        'users',
        'users/details/*/*',
        'users/edit/*',
        'users/groups/*',
        'users/set-password/*',
        'users/add',
        'users/cases/*',
        'users/user_info_controller/new/*',
        'users/user_info_controller/new/*/*',
        'payment-terms',
        'payment-terms/add',
        'payment-terms/edit/*',
        'groups',
        'groups/add',
        'groups/users/*',
        'groups/cases/users/*',
        'groups/edit/*',
        'groups/permission/*',
        'groups/case-type/*',
        'customers',
        'customers/add',
        'customers/details/*',
        'customers/details/*/*',
        'customers/edit/*',
        'customers/cases/*',
        'customers/contact/add/*',
        'customers/vcard/edit/*',
        'customers/form/edit/*',
        'customers/contact/edit/*/*',
        'customers/contact/history-contact/add/*',
        'customers/contact/history-contact/edit/*/*',
        'customers/message/*/*',
        'customers/weight/edit/*',
        'location',
        'location/industry-connect/*',
        'location/add/*',
        'location/add',
        'location/edit/*',
        'location/edit/*/*',
        'location/edit/*/*/*',
        'location/edit/*/*',
        'office-work',
        'timeline',
        'timeline/add',
        'timeline/add/company',
        'timeline/edit-company-event/*',
        'timeline/edit/*/*',
        'vacation-request',
        'cases',
        'cases-bilans',
        'cases-creator',
        'cases/add',
        'cases/details/*',
        'cases/edit/*',
        'cases/retry/*',
        'cases/restore',
        'cases/return/*',
        'forward-cases',
        'my-cases',
        'cost-cases-planner',
        'bank-transfer-details',
        'currency-list',
        'currency-list/add',
        'currency-list/edit/*',
        'deleted-purchase-invoices',
        'invoice-list',
        'pucharse-invoices-responsible-users',
        'invoice-list/add',
        'invoice-list/add/*',
        'invoice-list/edit/*',
        'invoice-list/details/*/*',
        'invoice-list/return/*',
        'sells-invoice',
        'sells-invoice/client/*',
        'sells-invoice/unpaid-invoices-report/*/*',
        'warehouse',
        'project',
        'permissions',
        'permissions/add',
        'permissions/edit/*',
        'spare-parts',
        'spare-parts/add',
        'spare-parts/add/*',
        'spare-parts/edit/*',
        'spare-parts/details/*',
        'sells-invoice/add',
        'sells-invoice/add/*',
        'sells-invoice/edit/*',
        'sells-invoice/correction/*',
        'project',
        'project/add',
        'project/add/user/*',
        'project/edit/*',
        'project/stage/add/*',
        'project/stage/edit/*',
        'settlements',
        'settlements-montly',
        'settlements/add',
        'settlements/add/*',
        'settlements/edit/*',
        'settlements/default-edit/*',
        'delegation',
        'delegation/add/*',
        'delegation/edit/*',
        'monitor',
        'marketing-monitor',
        'ticket',
        'users-vacation',
        'users-employments',
        'procedures',
        'procedures/*',
        'acceptance',
        'past-contacts',
        'future-contacts',
        'purchase',
        'issues',
        'change-password',
        'work-cards',
        'office-equipment',
        'my-vacation-request',
        'budget-planner',
        'port-calls-ship/*',
        'port-calls-port/*',
        'port-calls',
        'port-calls-port/*',
        'port-calls-ship/*',
        'monitor-case-invoices',
        'documents',
        'delegations',
        'delegations-national',
        'delegations-national-add',
        'delegations-national-edit/*',
        'delegations-national-add-settlements/*',
        'delegations-national-edit-settlements/*',
        'delegations-foreign',
        'delegations-foreign-add',
        'delegations-foreign-edit/*',
        'delegations-foreign-add-settlements/*',
        'delegations-foreign-edit-settlements/*',
        'delegations-users',
        'delegations-users-add',
        'delegations-users-edit/*',
        'delegations-fleet-company',
        'delegations-fleet-company-add',
        'delegations-fleet-company-edit/*',
        'delegations-fleet-other',
        'delegations-fleet-other-add',
        'delegations-fleet-other-edit/*',
        'delegations-acceptance-path',
        'delegations-acceptance-path-add',
        'delegations-advances',
        'delegations-advances/*/*',
        'delegations-advances-add',
        'financial-statistics',
        'financial-statistics/generating-expenses/*/*/*',
        'financial-statistics/generating-profits/*/*/*',
        'financial-statistics/generating-balance/*/*/*',
        'l4verification',
        'timeline-service',
        'warehouse-office-equipment',
        'warehouse-clothes',
        'warehouse-office-equipment/edit/*',
        'warehouse-office-equipment/addrequest',
        'warehouse-office-equipment/addset',
        'warehouse-office-equipment/editset/*',
        'warehouse-clothes/add',
        'warehouse-clothes/add-self',
        'warehouse-clothes/addrequest',
        'warehouse-clothes/edit/*',
        'warehouse-clothes/editUserrequest/*',
        'warehouse-clothes/editLogisticrequest/*',
        'warehouse-office-equipment/editUserrequest/*',
        'warehouse-office-equipment/editLogisticrequest/*',
        'purchase-order',
        'purchase-order/add/*',
        'purchase-order/add',
        'purchase-order/edit/*',
        'info-notify'
    ]

    query = """SELECT distinct(url) FROM user_logs where user_id not in (181,77,316,326,144, 42);"""
    df = pd.read_sql(query, db.session.bind)
    import fnmatch

    def match_path(path, patterns):
        for pattern in patterns:
            if fnmatch.fnmatch(path, f'/{pattern}'):
                return pattern
        return None

    df['matched_pattern'] = df['url'].apply(lambda x: match_path(x, paths))

    matched_patterns = df['matched_pattern'].dropna().unique()

    all_patterns = set(paths)

    unmatched_patterns = all_patterns - set(matched_patterns)
    sorted_unmatched_patterns = sorted(unmatched_patterns)

    print("Wzorce, które nie zostały przypisane:")
    for row in sorted_unmatched_patterns:
        print(row)

    return df