#!/usr/bin/env python3
"""Test regex - the actual bug"""
import re

# This is what the file ACTUALLY has (using repr to see exact chars)
bad = r'-\\d+\\.(xls|xlsx)$'
print("BAD regex repr:", repr(bad))
print("BAD regex:", bad)
good = r'-\d+\.(xls|xlsx)$'
print("GOOD regex repr:", repr(good))
print("GOOD regex:", good)

test = "某项目-123456789.xls"
b = re.sub(bad, '', test)
g = re.sub(good, '', test)
print(f"\nTest: {test}")
print(f"  BAD result:  [{b}]")
print(f"  GOOD result: [{g}]")

# Now test with the actual filename from the DB
test2 = "环保型农药制剂自动化复配生产线及配套工程建设项目-1779157188713.xls"
b2 = re.sub(bad, '', test2)
g2 = re.sub(good, '', test2)
print(f"\nTest: {test2}")
print(f"  BAD result:  [{b2}]")
print(f"  GOOD result: [{g2}]")

# Test if bad regex matches at all
m = re.search(bad, test2)
print(f"\nBAD match: {m}")
m2 = re.search(good, test2)
print(f"GOOD match: {m2}")
