excel_tool/run_tests.py

import subprocess
import sys

def run_translate_new_col():
    print("Running translate_new_col.py...")
    result = subprocess.run(["python", "translate_new_col.py"])
    if result.returncode != 0:
        print("translate_new_col.py failed!")
        sys.exit(1)
    print("translate_new_col.py completed.\n")

def run_brand_add_url_link():
    print("Running brand_add_url_link.py...")
    result = subprocess.run(["python", "brand_add_url_link.py"])
    if result.returncode != 0:
        print("brand_add_url_link.py failed!")
        sys.exit(1)
    print("brand_add_url_link.py completed.\n")

def main():
    print("Starting test sequence...\n")
    
    try:
        # 第一步：运行翻译脚本
        run_translate_new_col()
        
        # 第二步：运行品牌和ASIN链接脚本
        run_brand_add_url_link()
        
        print("All tests completed successfully!")
    except Exception as e:
        print(f"Error during test sequence: {e}")
        sys.exit(1)

if __name__ == "__main__":
    import sys
    print(sys.executable)
    # main()