从数据库中生成的url中删除

from sqlalchemy import create_engine, Table, MetaData
from urllib.parse import urlparse, parse_qs, urlencode

# 创建数据库连接
engine = create_engine('your_database_connection_string')
metadata = MetaData(bind=engine)
table = Table('your_table_name', metadata, autoload=True)

# 查询数据库
with engine.connect() as connection:
    result = connection.execute(table.select())
    for row in result:
        url = row['url']
        
        # 解析URL
        parsed_url = urlparse(url)
        query_params = parse_qs(parsed_url.query)
        
        # 删除特定查询参数
        if 'unwanted_param' in query_params:
            del query_params['unwanted_param']
        
        # 重新构建URL
        new_query_string = urlencode(query_params, doseq=True)
        new_url = parsed_url._replace(query=new_query_string).geturl()
        
        print(f'Original URL: {url}')
        print(f'Processed URL: {new_url}')